List of Media companies in North America

[
  {
    "name": "NewsMx Tv",
    "address": "La**********",
    "phone": "********2316",
    "email": "di*******@ne**********",
    "lat": 19.5963427,
    "lng": -99.0147117,
    "url": "ht**********",
    "country": "Mexico",
    "state": "México",
    "city": "Ecatepec de Morelos",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Media companies"
  },
  {
    "name": "La Grilla Networks",
    "address": "",
    "phone": "********2815",
    "email": "pe**********@gm*******",
    "lat": 21.8531319,
    "lng": -102.3040679,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Aguascalientes",
    "city": "Aguascalientes",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Companies,Media companies,Service establishments"
  },
  {
    "name": "Unlimited Levels of Versatility",
    "address": "25**********",
    "phone": "********5350",
    "email": "in**@ul******",
    "lat": 39.0585681,
    "lng": -77.9434572,
    "url": "ht**********",
    "country": "United States",
    "state": "Virginia",
    "city": null,
    "star_count": 5,
    "rating_count": 16,
    "category_name": "Media companies,Media Consultants"
  },
  {
    "name": "Stereo Noticias",
    "address": "11**********",
    "phone": "********2041",
    "email": "ad**********@st*******",
    "lat": 14.065049,
    "lng": -87.1715002,
    "url": "ht**********",
    "country": "Honduras",
    "state": "Francisco Morazán Department",
    "city": "Tegucigalpa",
    "star_count": 3.8,
    "rating_count": 4,
    "category_name": "Media companies"
  },
  {
    "name": "Sindicalismo a la Vanguardia",
    "address": "13**********",
    "phone": "********4577",
    "email": "co******@si**********",
    "lat": 19.3029831,
    "lng": -99.0410585,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Media companies"
  },
  {
    "name": "Am Hidalgo",
    "address": "Bl**********",
    "phone": "********5394",
    "email": "ve****@am**********",
    "lat": 20.0922021,
    "lng": -98.7519974,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Hidalgo",
    "city": "Pachuca de Soto",
    "star_count": 4.3,
    "rating_count": 7,
    "category_name": "Corporate campus,Media companies,Corporate offices"
  },
  {
    "name": "Central Oregon Daily",
    "address": "63**********",
    "phone": "********5151",
    "email": "in**@ce**********",
    "lat": 44.0904914,
    "lng": -121.3025971,
    "url": "ht**********",
    "country": "United States",
    "state": "Oregon",
    "city": "Bend",
    "star_count": 3.9,
    "rating_count": 49,
    "category_name": "Media companies"
  },
  {
    "name": "Tamil America TV",
    "address": "14**********",
    "phone": "********8875",
    "email": "ad***@ta**********",
    "lat": 40.5617666,
    "lng": -74.3710955,
    "url": "ht**********",
    "country": "United States",
    "state": "New Jersey",
    "city": "Edison",
    "star_count": 5,
    "rating_count": 159,
    "category_name": "Television stations,Media Consultants,News services,Non-profit organizations,Media companies,Social services organizations"
  },
  {
    "name": "Unlimited Levels of Versatility (ULOV®)",
    "address": "25**********",
    "phone": "********1663",
    "email": "in**@ul******",
    "lat": 39.0585681,
    "lng": -77.9434572,
    "url": "ht**********",
    "country": "United States",
    "state": "Virginia",
    "city": null,
    "star_count": 5,
    "rating_count": 19,
    "category_name": "Media companies,Media Consultants"
  },
  {
    "name": "Clear Channel Outdoor - Las Vegas",
    "address": "63**********",
    "phone": "********7200",
    "email": "Ja********@cl**********",
    "lat": 36.0732661,
    "lng": -115.2707073,
    "url": "ht**********",
    "country": "United States",
    "state": "Nevada",
    "city": "Las Vegas",
    "star_count": 4.3,
    "rating_count": 6,
    "category_name": "Media companies"
  }
]