Liste der Wasserversorgungsunternehmen in Nordamerika

[
  {
    "name": "JAPAMA",
    "address": "81**********",
    "phone": "********0404",
    "email": "cc*@ja**********",
    "lat": 26.1133465,
    "lng": -109.0232739,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Sinaloa",
    "city": "Ahome",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "JAPAMA - Junta de Agua Potable y Alcantarillado del Municipio de Ahome",
    "address": "Es**********",
    "phone": "********0404",
    "email": "cc*@ja**********",
    "lat": 25.794943,
    "lng": -108.9922823,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Sinaloa",
    "city": "Ahome",
    "star_count": 2.2,
    "rating_count": 84,
    "category_name": "Water utility companies,Local government offices"
  },
  {
    "name": "CEA Oficina Central",
    "address": "Av**********",
    "phone": "********0600",
    "email": "lr*******@ce**********",
    "lat": 20.5908914,
    "lng": -100.414288,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Querétaro",
    "city": null,
    "star_count": 3.8,
    "rating_count": 756,
    "category_name": "Water utility companies"
  },
  {
    "name": "Pipas de Agua en Puebla ABC",
    "address": "Ca**********",
    "phone": "********7872",
    "email": "pi**********@gm*******",
    "lat": 19.0050461,
    "lng": -98.24493,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Puebla",
    "city": "Puebla",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Sideapa Módulo de Pago Sucursal Chapala",
    "address": "C.**********",
    "phone": "********0115",
    "email": "at**********@si**********",
    "lat": 25.5764164,
    "lng": -103.5233358,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Durango",
    "city": "Ciudad Lerdo",
    "star_count": 4,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Oomapas de Cajeme",
    "address": "Bl**********",
    "phone": "********9497",
    "email": "pa***@oo**********",
    "lat": 27.4824426,
    "lng": -109.9407195,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Sonora",
    "city": null,
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies,Local government offices"
  },
  {
    "name": "Pipas de Agua Alek's Oaxaca",
    "address": "",
    "phone": "********0653",
    "email": "pi********@ho*********",
    "lat": 17.0651694,
    "lng": -96.7342624,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Oaxaca",
    "city": "Oaxaca",
    "star_count": 2.6,
    "rating_count": 28,
    "category_name": "Service establishments,Companies,Water utility companies"
  },
  {
    "name": "Aqua Jaker Corporativo",
    "address": "Av**********",
    "phone": "********0310",
    "email": "co******@aq**********",
    "lat": 25.6532644,
    "lng": -100.2754703,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Nuevo León",
    "city": "Monterrey",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "OOMAPAS DE CAJEME",
    "address": "Ca**********",
    "phone": "********8383",
    "email": "pa***@oo**********",
    "lat": 27.4972771,
    "lng": -109.9312092,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Sonora",
    "city": null,
    "star_count": 1.6,
    "rating_count": 25,
    "category_name": "Water utility companies"
  },
  {
    "name": "Huixquilucan WATER SYSTEM",
    "address": "Ca**********",
    "phone": "********6868",
    "email": "co******@sa********",
    "lat": 19.405576,
    "lng": -99.3133837,
    "url": "ht**********",
    "country": "Mexico",
    "state": "México",
    "city": "Huixquilucan",
    "star_count": 3.2,
    "rating_count": 45,
    "category_name": "Water utility companies"
  }
]