List of Drinking water fountains in Mexico

[
  {
    "name": "Pipas tepic",
    "address": "Mo**********",
    "phone": "********0754",
    "email": "pi********@gm*******",
    "lat": 21.5132337,
    "lng": -104.9180795,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Nayarit",
    "city": "Tepic",
    "star_count": 4.5,
    "rating_count": 8,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Bombeo Alfonso Reyes, Servicios de Agua y Drenaje de Monterrey, I.P.D",
    "address": "He**********",
    "phone": "********6999",
    "email": "pt****@sa*********",
    "lat": 25.6461783,
    "lng": -100.3073341,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Nuevo León",
    "city": "Monterrey",
    "star_count": 1,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Pipas de agua Vázquez",
    "address": "AV**********",
    "phone": "********3092",
    "email": "pi**********@gm*******",
    "lat": 20.6124141,
    "lng": -103.4285387,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Jalisco",
    "city": "Zapopan",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies,Drinking water fountains"
  },
  {
    "name": "Planta Potabilizadora POZO Purisima 5",
    "address": "C.**********",
    "phone": "********0016",
    "email": "ra**********@sa**********",
    "lat": 19.34168,
    "lng": -99.0090239,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 3,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "GOT WATER",
    "address": "Av**********",
    "phone": "********5286",
    "email": "ve****@go**********",
    "lat": 32.6286715,
    "lng": -115.4240575,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Baja California",
    "city": "Mexicali",
    "star_count": 3.7,
    "rating_count": 3,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Wassermatic Premium",
    "address": "Aq**********",
    "phone": "********4914",
    "email": "wa**********@gm*******",
    "lat": 19.2506341,
    "lng": -103.7279697,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Colima",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Agua Inmaculada \"Miguel Hidalgo\"",
    "address": "Av**********",
    "phone": "********2482",
    "email": "co**********@ag**********",
    "lat": 18.8445641,
    "lng": -98.9360841,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Morelos",
    "city": "Cuautla",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Suministro de agua potable San Luis",
    "address": "",
    "phone": "********3089",
    "email": "su**********@gm*******",
    "lat": 22.1140769,
    "lng": -100.9159303,
    "url": "ht**********",
    "country": "Mexico",
    "state": "San Luis Potosí",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Companies,Drinking water fountains,Service establishments"
  },
  {
    "name": "WaterGush",
    "address": "Ca**********",
    "phone": "********0181",
    "email": "in**@wa**********",
    "lat": 18.9898996,
    "lng": -98.3508841,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Puebla",
    "city": "Santa Clara",
    "star_count": 4.1,
    "rating_count": 12,
    "category_name": "Fountain contractors,Drinking water fountains"
  },
  {
    "name": "Agua Suprema",
    "address": "Ca**********",
    "phone": "********9666",
    "email": "ag**********@gm*******",
    "lat": 32.58562,
    "lng": -115.472831,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Baja California",
    "city": "Mexicali",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Dispensador de Productos de Limpieza y Agua Purificada Hidromatic",
    "address": "C.**********",
    "phone": "********5499",
    "email": "ve**********@gm*******",
    "lat": 20.6758382,
    "lng": -105.2045875,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Jalisco",
    "city": "Puerto Vallarta",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Cleaning products suppliers,Drinking water fountains"
  },
  {
    "name": "FILTROS Y PURIFICADORES DE MÉXICO NIKKEN",
    "address": "",
    "phone": "********7075",
    "email": "se**********@ni**********",
    "lat": 23.5541269,
    "lng": -102.6205,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Zacatecas",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Service establishments,Drinking water fountains,Companies"
  },
  {
    "name": "Aquaware",
    "address": "",
    "phone": "********8293",
    "email": "in**@aq*********",
    "lat": 23.5541269,
    "lng": -102.6205,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Zacatecas",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Service establishments,Drinking water fountains,Companies"
  },
  {
    "name": "Tanque Circuito Centenario",
    "address": "Ru**********",
    "phone": "********0115",
    "email": "at**********@si**********",
    "lat": 25.5654036,
    "lng": -103.4850348,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Durango",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "AGUA EN PIPA LA CAÑADA",
    "address": "CA**********",
    "phone": "********8973",
    "email": "ll********@gm*******",
    "lat": 16.755076,
    "lng": -93.167641,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Chiapas",
    "city": "Tuxtla",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains,Water mills"
  },
  {
    "name": "Planta purificadora de agua automática",
    "address": "In**********",
    "phone": "********3140",
    "email": "ve****@pu**********",
    "lat": 19.4508365,
    "lng": -99.1176252,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "LUA",
    "address": "Bl**********",
    "phone": "********1006",
    "email": "lu*@gr**********",
    "lat": 25.5702928,
    "lng": -103.4213005,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Coahuila",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "PLANTA CLORACION T DEL OLIVAR",
    "address": "La**********",
    "phone": "********0301",
    "email": "ra**********@sa**********",
    "lat": 19.2519222,
    "lng": -99.0067858,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "One Water Mexico",
    "address": "",
    "phone": "********7585",
    "email": "IN**@AL**********",
    "lat": 20.6147442,
    "lng": -100.4229958,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Querétaro",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Companies,Drinking water fountains,Service establishments"
  },
  {
    "name": "Pipas de Agua en Cuernavaca",
    "address": "Ju**********",
    "phone": "********9583",
    "email": "l_********@ho*********",
    "lat": 18.9106909,
    "lng": -99.2105277,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Morelos",
    "city": "Cuernavaca",
    "star_count": 4.9,
    "rating_count": 16,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Aquality Pipas de Agua Potable",
    "address": "Av**********",
    "phone": "********8102",
    "email": "aq**********@gm*******",
    "lat": 19.2044215,
    "lng": -99.149134,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Berfrasa",
    "address": "Ho**********",
    "phone": "********0504",
    "email": "we*******@be**********",
    "lat": 16.8516953,
    "lng": -99.8483602,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Guerrero",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "ALMACEN SOAPSC",
    "address": "Ni**********",
    "phone": "********7797",
    "email": "di******@so**********",
    "lat": 18.837643,
    "lng": -98.937174,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Morelos",
    "city": "Cuautla",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Wassermatic Premium",
    "address": "Av**********",
    "phone": "********8946",
    "email": "at******@wa**********",
    "lat": 19.2780552,
    "lng": -103.7633322,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Colima",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Pipa de agua potable expréss 24 hrs",
    "address": "C.**********",
    "phone": "********1214",
    "email": "sm*****@su**********",
    "lat": 27.9747306,
    "lng": -111.0267537,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Sonora",
    "city": "Heroica Guaymas",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Suministro de Agua Potable ABC Servicios Integrales SA de CV",
    "address": "",
    "phone": "********9121",
    "email": "b.******@ab**********",
    "lat": 19.3584577,
    "lng": -99.3463895,
    "url": "ht**********",
    "country": "Mexico",
    "state": "México",
    "city": "Huixquilucan",
    "star_count": 4.3,
    "rating_count": 3,
    "category_name": "Drinking water fountains,Companies,Service establishments"
  },
  {
    "name": "Fuentes Bailarinas",
    "address": "Br**********",
    "phone": "********5113",
    "email": "pr*******@fu**********",
    "lat": 19.395602,
    "lng": -99.096907,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "AGUA DE MANANTIAL SANTA CECILIA",
    "address": "Av**********",
    "phone": "********1237",
    "email": "ad**********@gm*******",
    "lat": 16.7541492,
    "lng": -93.0919913,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Chiapas",
    "city": "Tuxtla",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "H2O Pipas de Agua en Cancun",
    "address": "",
    "phone": "********0427",
    "email": "in**@h2**********",
    "lat": 21.1213982,
    "lng": -86.8564038,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Quintana Roo",
    "city": null,
    "star_count": 3.7,
    "rating_count": 20,
    "category_name": "Drinking water fountains,Service establishments,Companies"
  },
  {
    "name": "elephent water",
    "address": "Eu**********",
    "phone": "********7474",
    "email": "co******@el**********",
    "lat": 19.6539981,
    "lng": -99.0959156,
    "url": "ht**********",
    "country": "Mexico",
    "state": "México",
    "city": "Coacalco",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Bottled water suppliers,Drinking water fountains"
  }
]