Список Медийные компании в Мексика

[
  {
    "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": "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": "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": "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": "Canal 10",
    "address": "Li**********",
    "phone": "********4257",
    "email": "se*@ca**********",
    "lat": 24.0210009,
    "lng": -104.683222,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Durango",
    "city": "Victoria de Durango",
    "star_count": 3.7,
    "rating_count": 17,
    "category_name": "Media companies"
  },
  {
    "name": "OpenCaseMx",
    "address": "",
    "phone": "********5165",
    "email": "di*******@op**********",
    "lat": 19.3907336,
    "lng": -99.1436127,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 5,
    "rating_count": 39,
    "category_name": "Media companies,Service establishments,Companies"
  },
  {
    "name": "Revista Con Sentido",
    "address": "Mo**********",
    "phone": "********8517",
    "email": "jo**@co**********",
    "lat": 19.4300624,
    "lng": -99.2074831,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Media companies"
  },
  {
    "name": "Medicable",
    "address": "Ch**********",
    "phone": "********0671",
    "email": "co******@me**********",
    "lat": 19.3091854,
    "lng": -99.2303296,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 4.6,
    "rating_count": 20,
    "category_name": "Media companies,Publishers"
  },
  {
    "name": "RADIOYUCATANFM.COM.MX",
    "address": "Ca**********",
    "phone": "********7404",
    "email": "ra**********@gm*******",
    "lat": 20.9760006,
    "lng": -89.6141029,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Yucatán",
    "city": null,
    "star_count": 4.9,
    "rating_count": 60,
    "category_name": "Radio broadcasters,Media companies"
  },
  {
    "name": "Turix Multimedia",
    "address": "",
    "phone": "********9850",
    "email": "co**********@gm*******",
    "lat": 19.3907336,
    "lng": -99.1436127,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Media companies,Service establishments,Companies"
  }
]