List of Cable companies in North America

[
  {
    "name": "MEGA CIS Camino Real",
    "address": "An**********",
    "phone": "********1234",
    "email": "at**********@me**********",
    "lat": 19.0488143,
    "lng": -98.2675163,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Puebla",
    "city": "Puebla",
    "star_count": 3,
    "rating_count": 259,
    "category_name": "Telecommunications service providers,Tele Service Companies,Cable companies"
  },
  {
    "name": "Megacable Plaza Rio",
    "address": "Mi**********",
    "phone": "********0000",
    "email": "at**********@me**********",
    "lat": 19.1068755,
    "lng": -96.1052909,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Veracruz",
    "city": "Boca del Rio",
    "star_count": 3.1,
    "rating_count": 158,
    "category_name": "Cable companies"
  },
  {
    "name": "Needham Channel",
    "address": "25**********",
    "phone": "********6964",
    "email": "in**@ne**********",
    "lat": 42.2757818,
    "lng": -71.2379737,
    "url": "ht**********",
    "country": "United States",
    "state": "Massachusetts",
    "city": "Boston",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Cable companies"
  },
  {
    "name": "CableSouth Media3, LLC",
    "address": "15**********",
    "phone": "********2044",
    "email": "cu**********@sw**********",
    "lat": 31.097789,
    "lng": -92.0624585,
    "url": "ht**********",
    "country": "United States",
    "state": "Louisiana",
    "city": "Mansura",
    "star_count": 1.5,
    "rating_count": 149,
    "category_name": "Cable companies"
  },
  {
    "name": "Vission Cable Santa Rita",
    "address": "Av**********",
    "phone": "********1345",
    "email": "ve****@vi**********",
    "lat": 19.330323,
    "lng": -98.5817569,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Puebla",
    "city": "Santa Rita Tlahuapan",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Cable companies"
  },
  {
    "name": "MEGACABLE AQUILES SERDÁN",
    "address": "Av**********",
    "phone": "********0000",
    "email": "at**********@me**********",
    "lat": 25.7953243,
    "lng": -108.9916687,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Sinaloa",
    "city": "Ahome",
    "star_count": 3.9,
    "rating_count": 80,
    "category_name": "Cable companies"
  },
  {
    "name": "Cable Sur Morelos",
    "address": "Ca**********",
    "phone": "********0385",
    "email": "ca**********@ca**********",
    "lat": 22.2228599,
    "lng": -97.8807135,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Tamaulipas",
    "city": "Tampico",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Cable companies"
  },
  {
    "name": "Tv Azteca",
    "address": "Tr**********",
    "phone": "********1313",
    "email": "co******@tv**********",
    "lat": 23.2131156,
    "lng": -106.3703565,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Sinaloa",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Cable companies"
  },
  {
    "name": "Megacable",
    "address": "Ca**********",
    "phone": "********8922",
    "email": "at**********@me**********",
    "lat": 19.6068736,
    "lng": -99.2926814,
    "url": "ht**********",
    "country": "Mexico",
    "state": "México",
    "city": null,
    "star_count": 2.8,
    "rating_count": 699,
    "category_name": "Cable companies"
  },
  {
    "name": "Tv Azteca",
    "address": "Ar**********",
    "phone": "********1476",
    "email": "co******@tv**********",
    "lat": 23.7198217,
    "lng": -99.145291,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Tamaulipas",
    "city": "Ciudad Victoria",
    "star_count": 3.8,
    "rating_count": 5,
    "category_name": "Cable companies"
  }
]