List of Water utility companies in Mexico

[
  {
    "name": "AGUA HERRERA",
    "address": "",
    "phone": "********2828",
    "email": "ag*********@li*********",
    "lat": 20.5283124,
    "lng": -100.817986,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Guanajuato",
    "city": "Celaya",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies,Service establishments,Companies"
  },
  {
    "name": "REGIO SERVICIO AMNBIENTAL, SA DE CV",
    "address": "",
    "phone": "********2360",
    "email": "ve****@rs****",
    "lat": 25.4809101,
    "lng": -99.8141693,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Nuevo León",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies,Service establishments,Companies"
  },
  {
    "name": "WIL",
    "address": "Ci**********",
    "phone": "********8684",
    "email": "Ve****@wi****",
    "lat": 25.6940568,
    "lng": -100.2830024,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Nuevo León",
    "city": "Monterrey",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Hydrosystem de Córdoba",
    "address": "18**********",
    "phone": "********5535",
    "email": "at**********@hi**********",
    "lat": 18.8925732,
    "lng": -96.9475108,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Veracruz",
    "city": null,
    "star_count": 2.1,
    "rating_count": 53,
    "category_name": "Water utility companies,Local government offices"
  },
  {
    "name": "Cespm Zona Comercial VI",
    "address": "Qu**********",
    "phone": "********2660",
    "email": "cs*******@ce**********",
    "lat": 32.5995208,
    "lng": -115.393992,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Baja California",
    "city": "Mexicali",
    "star_count": 3.2,
    "rating_count": 19,
    "category_name": "Water utility companies"
  },
  {
    "name": "PIPAS GASPARÍN",
    "address": "CA**********",
    "phone": "********5315",
    "email": "pi**********@ho*********",
    "lat": 21.173212,
    "lng": -86.8226799,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Quintana Roo",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "TSS Internacional",
    "address": "Ur**********",
    "phone": "********8810",
    "email": "at*********@ts**********",
    "lat": 25.701507,
    "lng": -100.3540401,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Nuevo León",
    "city": "Monterrey",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Agua en Pipas Providencia",
    "address": "Ve**********",
    "phone": "********5810",
    "email": "co******@pi**********",
    "lat": 20.6938469,
    "lng": -103.376754,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Jalisco",
    "city": "Guadalajara",
    "star_count": 3.3,
    "rating_count": 4,
    "category_name": "Water utility companies"
  },
  {
    "name": "AGUA BEDOLLA",
    "address": "FE**********",
    "phone": "********8783",
    "email": "tr**********@ho*********",
    "lat": 20.5655304,
    "lng": -100.3977035,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Querétaro",
    "city": null,
    "star_count": 3.7,
    "rating_count": 6,
    "category_name": "Water utility companies"
  },
  {
    "name": "H2o Pipas",
    "address": "Av**********",
    "phone": "********8499",
    "email": "h2*@ho*********",
    "lat": 21.1949081,
    "lng": -86.81842,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Quintana Roo",
    "city": null,
    "star_count": 1,
    "rating_count": 2,
    "category_name": "Water utility companies"
  },
  {
    "name": "Concesion Integral Agua De Puebla Para Todos",
    "address": "Bl**********",
    "phone": "********8721",
    "email": "we*******@ex*********",
    "lat": 19.04379,
    "lng": -98.1641678,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Puebla",
    "city": "Puebla",
    "star_count": 1,
    "rating_count": 2,
    "category_name": "Water utility companies"
  },
  {
    "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": "Companies,Water utility companies,Service establishments"
  },
  {
    "name": "Cespe",
    "address": "Al**********",
    "phone": "********1472",
    "email": "in*********@ce**********",
    "lat": 31.730399,
    "lng": -116.5788319,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Baja California",
    "city": "Ensenada",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Junghanns Agua de mesa Puebla Sur",
    "address": "Em**********",
    "phone": "********4790",
    "email": "co******@ju**********",
    "lat": 19.0788924,
    "lng": -98.2646941,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Puebla",
    "city": "Puebla",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Pipas de Agua San Luis",
    "address": "C.**********",
    "phone": "********4081",
    "email": "pi**********@ho*********",
    "lat": 20.6308855,
    "lng": -103.452757,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Jalisco",
    "city": "Zapopan",
    "star_count": 1.3,
    "rating_count": 7,
    "category_name": "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": "Servicio De Agua En Pipas Agua Clara",
    "address": "Jo**********",
    "phone": "********8698",
    "email": "ag**********@gm*******",
    "lat": 19.6914978,
    "lng": -101.234741,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Michoacán",
    "city": "Morelia",
    "star_count": 4,
    "rating_count": 5,
    "category_name": "Water utility companies"
  },
  {
    "name": "Hydrocon Total Water Management",
    "address": "Se**********",
    "phone": "********8040",
    "email": "se**********@hy**********",
    "lat": 25.71344,
    "lng": -100.3059434,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Nuevo León",
    "city": "Monterrey",
    "star_count": 4.3,
    "rating_count": 7,
    "category_name": "Water utility companies"
  },
  {
    "name": "Pipas de Agua Gonzalez Team II",
    "address": "Av**********",
    "phone": "********1050",
    "email": "go**********@gm*******",
    "lat": 20.7624665,
    "lng": -103.4362885,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Jalisco",
    "city": "Zapopan",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "SERVICIO TREJO PIPAS DE AGUA POTABLE",
    "address": "Gr**********",
    "phone": "********8815",
    "email": "pi**********@gm*******",
    "lat": 19.4408646,
    "lng": -99.1017091,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 4,
    "rating_count": 8,
    "category_name": "Water utility companies"
  },
  {
    "name": "Transportadora de Liquidos Nayarita",
    "address": "Ro**********",
    "phone": "********7113",
    "email": "pi**********@ho*********",
    "lat": 21.5295372,
    "lng": -104.8721328,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Nayarit",
    "city": "Tepic",
    "star_count": 3,
    "rating_count": 2,
    "category_name": "Water utility companies"
  },
  {
    "name": "Sistema De Agua Potable San José",
    "address": "Em**********",
    "phone": "********4355",
    "email": "bl**********@sc**********",
    "lat": 18.8879826,
    "lng": -99.1479885,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Morelos",
    "city": "Jiutepec",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Municipal Water and Sanitation System",
    "address": "Bl**********",
    "phone": "********1700",
    "email": "co******@si**********",
    "lat": 25.5456652,
    "lng": -103.4525808,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Coahuila",
    "city": null,
    "star_count": 3.4,
    "rating_count": 163,
    "category_name": "Water utility companies,Local government offices"
  },
  {
    "name": "Ciapacov",
    "address": "Av**********",
    "phone": "********2982",
    "email": "co**********@ci**********",
    "lat": 19.2517637,
    "lng": -103.729324,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Colima",
    "city": null,
    "star_count": 3.4,
    "rating_count": 12,
    "category_name": "Water utility companies"
  },
  {
    "name": "Pipas de Agua en Zapopan APZ - Agua en Pipa Zapopan",
    "address": "Av**********",
    "phone": "********6490",
    "email": "co******@pi**********",
    "lat": 20.7263159,
    "lng": -103.3628571,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Jalisco",
    "city": "Zapopan",
    "star_count": 3.8,
    "rating_count": 31,
    "category_name": "Water utility companies"
  },
  {
    "name": "Cassat",
    "address": "Un**********",
    "phone": "********1686",
    "email": "fc**********@gm*******",
    "lat": 19.9117946,
    "lng": -99.2423112,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Hidalgo",
    "city": "Atotonilco de Tula",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "AYALA EQUIPOS DE BOMBEO SA DE CV",
    "address": "C.**********",
    "phone": "********7576",
    "email": "ay**********@gm*******",
    "lat": 19.2477136,
    "lng": -103.6945948,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Colima",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Monterrey Laboratories, S. V. B.C.",
    "address": "Av**********",
    "phone": "********8088",
    "email": "ve****@la**********",
    "lat": 25.67073,
    "lng": -100.278887,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Nuevo León",
    "city": "Monterrey",
    "star_count": 3.7,
    "rating_count": 11,
    "category_name": "Water treatment plants,Water utility companies"
  },
  {
    "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": "PURIFICADORA BIENPURA",
    "address": "Av**********",
    "phone": "********3790",
    "email": "ma**@ex*********",
    "lat": 19.3126417,
    "lng": -99.2253273,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 2.3,
    "rating_count": 9,
    "category_name": "Water utility companies"
  }
]