List of Drinking water fountains in Northern America

[
  {
    "name": "Pure Water Technology of Southwest Virginia",
    "address": "16**********",
    "phone": "********8999",
    "email": "ab******@pu**********",
    "lat": 37.2835011,
    "lng": -80.0297194,
    "url": "ht**********",
    "country": "United States",
    "state": "Virginia",
    "city": "Salem",
    "star_count": 5,
    "rating_count": 7,
    "category_name": "Water treatment suppliers,Drinking water fountains,Ice suppliers"
  },
  {
    "name": "Pet drinking fountains",
    "address": "81**********",
    "phone": "********1114",
    "email": "fo*******@ju**********",
    "lat": 28.2271224,
    "lng": -82.679442,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "New Port Richey",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "ProDrinkingFountains",
    "address": "39**********",
    "phone": "********7937",
    "email": "cu**********@pr**********",
    "lat": 42.380804,
    "lng": -83.429325,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Detroit",
    "star_count": 4.7,
    "rating_count": 3,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Drinking Water Division",
    "address": "41**********",
    "phone": "********7333",
    "email": "Lo**********@ct****",
    "lat": 41.7641143,
    "lng": -72.6896317,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Hartford",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Woosh",
    "address": "20**********",
    "phone": "********6030",
    "email": "zo**********@gm*******",
    "lat": 25.87014,
    "lng": -80.12045,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "USA Drinking Fountain",
    "address": "64**********",
    "phone": "********5045",
    "email": "sa***@us**********",
    "lat": 29.6883806,
    "lng": -95.3155367,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 4.9,
    "rating_count": 9,
    "category_name": "Drinking water fountains,Repair services"
  },
  {
    "name": "International Drinking Water Fountains",
    "address": "41**********",
    "phone": "********9391",
    "email": "in**@id*****",
    "lat": 30.1631914,
    "lng": -81.7487312,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Jacksonville",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains,Fountain contractors,Water softening equipment suppliers"
  },
  {
    "name": "Waterfillz",
    "address": "19**********",
    "phone": "********2030",
    "email": "in**@qw**********",
    "lat": 49.0503195,
    "lng": -122.6931329,
    "url": "ht**********",
    "country": "Canada",
    "state": "British Columbia",
    "city": "Vancouver",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Event venues,Drinking water fountains"
  },
  {
    "name": "BottleFillingStations.com",
    "address": "50**********",
    "phone": "********9600",
    "email": "su*****@bo**********",
    "lat": 42.357,
    "lng": -71.057588,
    "url": "ht**********",
    "country": "United States",
    "state": "Massachusetts",
    "city": "Boston",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Pacific Water Conditioning Service LLC.",
    "address": "96**********",
    "phone": "********4449",
    "email": "wa******@pa**********",
    "lat": 33.574019,
    "lng": -112.104021,
    "url": "ht**********",
    "country": "United States",
    "state": "Arizona",
    "city": "Phoenix",
    "star_count": 1,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Pure Water Place Inc",
    "address": "85**********",
    "phone": "********1833",
    "email": "md******@pu**********",
    "lat": 37.5923206,
    "lng": -77.5626667,
    "url": "ht**********",
    "country": "United States",
    "state": "Virginia",
    "city": "Richmond",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains,Bottled water suppliers,Home health care services,Medical supply stores"
  },
  {
    "name": "Артезианская питьевая вода Артаксия",
    "address": "18**********",
    "phone": "********4-44",
    "email": "he***@my**********",
    "lat": 37.7937445,
    "lng": -122.3968645,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Woosh",
    "address": "10**********",
    "phone": "********6030",
    "email": "zo**********@gm*******",
    "lat": 25.8032918,
    "lng": -80.1245731,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 4,
    "rating_count": 2,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Woosh",
    "address": "46**********",
    "phone": "********6030",
    "email": "zo**********@gm*******",
    "lat": 25.7748896,
    "lng": -80.1317419,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 1.5,
    "rating_count": 2,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Water station (Drinking, Bottle fill, and dog bowl)",
    "address": "27**********",
    "phone": "********3676",
    "email": "fr*****@pa**********",
    "lat": 39.2909613,
    "lng": -76.5842031,
    "url": "ht**********",
    "country": "United States",
    "state": "Maryland",
    "city": "Baltimore",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Woosh",
    "address": "10**********",
    "phone": "********6030",
    "email": "zo**********@gm*******",
    "lat": 25.7958681,
    "lng": -80.1279009,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Sapha Water",
    "address": "64**********",
    "phone": "********0269",
    "email": "in**@sa**********",
    "lat": 35.0495591,
    "lng": -80.6483996,
    "url": "ht**********",
    "country": "United States",
    "state": "North Carolina",
    "city": "Indian Trail",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "101 Water Texas",
    "address": "81**********",
    "phone": "********2189",
    "email": "ro****@10**********",
    "lat": 29.5131752,
    "lng": -98.3985333,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "San Antonio",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Benson Bubbler",
    "address": "20**********",
    "phone": "********7770",
    "email": "31*@po**********",
    "lat": 45.5246736,
    "lng": -122.6723466,
    "url": "ht**********",
    "country": "United States",
    "state": "Oregon",
    "city": "Portland",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "South Yellowhead water",
    "address": "",
    "phone": "********7088",
    "email": "me******@sa*********",
    "lat": 51.998122,
    "lng": -106.3717668,
    "url": "ht**********",
    "country": "Canada",
    "state": "Saskatchewan",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Companies,Service establishments,Drinking water fountains"
  },
  {
    "name": "Woosh",
    "address": "31**********",
    "phone": "********6030",
    "email": "zo**********@gm*******",
    "lat": 25.81362,
    "lng": -80.12666,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Mitchell Pure Water",
    "address": "18**********",
    "phone": "********9300",
    "email": "Mi**********@gm*******",
    "lat": 37.6025217,
    "lng": -120.9393851,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Modesto",
    "star_count": 4.7,
    "rating_count": 12,
    "category_name": "Convenience stores,Drinking water fountains,Water purification companies"
  },
  {
    "name": "Station Boire",
    "address": "23**********",
    "phone": "********0511",
    "email": "in**@st**********",
    "lat": 45.3946076,
    "lng": -72.7334316,
    "url": "ht**********",
    "country": "Canada",
    "state": "Quebec",
    "city": "Granby",
    "star_count": 5,
    "rating_count": 8,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Pure Water Centers of Northern California",
    "address": "Lo**********",
    "phone": "********6601",
    "email": "cu**********@pu**********",
    "lat": 37.3852183,
    "lng": -122.1141298,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Jose",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Geneva Purification Systems",
    "address": "88**********",
    "phone": "********5900",
    "email": "se*****@ge**********",
    "lat": 29.6945654,
    "lng": -95.5404634,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Appliance stores,Plumbers,Water softening equipment suppliers,Drinking water fountains"
  },
  {
    "name": "Woosh",
    "address": "pa**********",
    "phone": "********6030",
    "email": "zo**********@gm*******",
    "lat": 25.8304576,
    "lng": -80.120834,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "BeCause Water",
    "address": "50**********",
    "phone": "********0314",
    "email": "in**@be**********",
    "lat": 42.3569814,
    "lng": -71.0576224,
    "url": "ht**********",
    "country": "United States",
    "state": "Massachusetts",
    "city": "Boston",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Woosh",
    "address": "16**********",
    "phone": "********6030",
    "email": "zo**********@gm*******",
    "lat": 25.7906582,
    "lng": -80.1401687,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Woosh",
    "address": "90**********",
    "phone": "********6030",
    "email": "zo**********@gm*******",
    "lat": 25.77916,
    "lng": -80.13044,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "EcoPure Water Shop",
    "address": "",
    "phone": "********0018",
    "email": "in**@bo**********",
    "lat": 49.1768374,
    "lng": -122.9673636,
    "url": "ht**********",
    "country": "Canada",
    "state": "British Columbia",
    "city": "Vancouver",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Office supply stores,Companies,Water testing services,Water Testing Laboratories,Office equipment suppliers,Service establishments,Water treatment plants,Drinking water fountains"
  }
]