List of Advertising agencies in Northern America

[
  {
    "name": "Sharina World",
    "address": "10**********",
    "phone": "********4805",
    "email": "sh*****@sh**********",
    "lat": 40.7441984,
    "lng": -73.6026109,
    "url": "ht**********",
    "country": "United States",
    "state": "New York",
    "city": "Hempstead",
    "star_count": 5,
    "rating_count": 43,
    "category_name": "Accounting firms,Advertising agencies,Travel agencies,Medical clinics,Non-profit organizations,Direct mail advertisings,Consultants,Marketing agencies,Business development services,Certified public accountants"
  },
  {
    "name": "E-Ticaret Marketing",
    "address": "",
    "phone": "********9 24",
    "email": "in**@et**********",
    "lat": 51.2072,
    "lng": -68.28025,
    "url": "ht**********",
    "country": "Canada",
    "state": "Quebec",
    "city": null,
    "star_count": 5,
    "rating_count": 5,
    "category_name": "Service establishments,Companies,Advertising agencies"
  },
  {
    "name": "Wico Business Solutions",
    "address": "39**********",
    "phone": "********9690",
    "email": "in**@wi**********",
    "lat": 25.9370387,
    "lng": -80.1326759,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 5,
    "rating_count": 30,
    "category_name": "Advertising agencies,Website designers,Graphic designers,Internet marketing services,Web Development,Web design companies,Marketing agencies"
  },
  {
    "name": "e50Ads",
    "address": "43**********",
    "phone": "********1088",
    "email": "hihi@e5********",
    "lat": 40.3785934,
    "lng": -74.2352882,
    "url": "ht**********",
    "country": "United States",
    "state": "New Jersey",
    "city": "Marlboro",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Advertising agencies"
  },
  {
    "name": "4Diaspo",
    "address": "32**********",
    "phone": "********2747",
    "email": "cscs@4d**********",
    "lat": 26.5884295,
    "lng": -80.0944993,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Advertising agencies"
  },
  {
    "name": "Prism Digital LLC",
    "address": "71**********",
    "phone": "********1604",
    "email": "in**@pr**********",
    "lat": 49.2850685,
    "lng": -123.1151256,
    "url": "ht**********",
    "country": "Canada",
    "state": "British Columbia",
    "city": "Vancouver",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Advertising agencies,Internet marketing services"
  },
  {
    "name": "Hodgson Agency",
    "address": "70**********",
    "phone": "********6116",
    "email": "su*****@ho*********",
    "lat": 29.7591686,
    "lng": -95.3635539,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Film Production Companies,Advertising agencies,Marketing agencies"
  },
  {
    "name": "FASTADS",
    "address": "10**********",
    "phone": "********6432",
    "email": "in**@fa*********",
    "lat": 34.1168011,
    "lng": -117.5666569,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Ontario",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Advertising agencies"
  },
  {
    "name": "A BIT LAVISH | Miami's Magazine",
    "address": "11**********",
    "phone": "********1942",
    "email": "fr*******@ab**********",
    "lat": 25.8792526,
    "lng": -80.1650069,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Advertising agencies"
  },
  {
    "name": "Virtualmerse",
    "address": "",
    "phone": "********1545",
    "email": "he***@vi**********",
    "lat": 41.2227254,
    "lng": -111.972674,
    "url": "ht**********",
    "country": "United States",
    "state": "Utah",
    "city": "Ogden",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Service establishments,Advertising agencies,Companies"
  }
]