北アメリカの水道会社のリスト

[
  {
    "name": "City of West Kelowna - Water Services",
    "address": "25**********",
    "phone": "********2246",
    "email": "in**@we**********",
    "lat": 49.8627903,
    "lng": -119.588141,
    "url": "ht**********",
    "country": "Canada",
    "state": "British Columbia",
    "city": "West Kelowna",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Cortaro Water Users Association",
    "address": "12**********",
    "phone": "********3233",
    "email": "in**@ma**********",
    "lat": 32.4529822,
    "lng": -111.2261992,
    "url": "ht**********",
    "country": "United States",
    "state": "Arizona",
    "city": "Marana",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "City of Coppell Water Billing",
    "address": "25**********",
    "phone": "********3695",
    "email": "H2******@co**********",
    "lat": 32.9758639,
    "lng": -96.9912398,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Dallas",
    "star_count": 3,
    "rating_count": 12,
    "category_name": "Water utility companies"
  },
  {
    "name": "Mt Holly Water Billing",
    "address": "40**********",
    "phone": "********3943",
    "email": "da*********@mt********",
    "lat": 35.2965218,
    "lng": -81.0102813,
    "url": "ht**********",
    "country": "United States",
    "state": "North Carolina",
    "city": "Mount Holly",
    "star_count": 1.2,
    "rating_count": 6,
    "category_name": "Water utility companies"
  },
  {
    "name": "Central Arkansas Water",
    "address": "22**********",
    "phone": "********5161",
    "email": "ne**********@ca*******",
    "lat": 34.7435719,
    "lng": -92.2690853,
    "url": "ht**********",
    "country": "United States",
    "state": "Arkansas",
    "city": "Little Rock",
    "star_count": 2.1,
    "rating_count": 215,
    "category_name": "Water utility companies"
  },
  {
    "name": "Myers Water Plant",
    "address": "14**********",
    "phone": "********0200",
    "email": "dr******@ma*******",
    "lat": 30.7219337,
    "lng": -88.2600335,
    "url": "ht**********",
    "country": "United States",
    "state": "Alabama",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Underground Utilities",
    "address": "10**********",
    "phone": "********6155",
    "email": "hu**********@ta********",
    "lat": 30.4460649,
    "lng": -84.2827276,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Tallahassee",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Van Buren Twp Water Department",
    "address": "46**********",
    "phone": "********8925",
    "email": "in**@va**********",
    "lat": 42.2332376,
    "lng": -83.4949171,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": null,
    "star_count": 4,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Mesilla Public Works",
    "address": "22**********",
    "phone": "********8244",
    "email": "ut*******@me**********",
    "lat": 32.2765932,
    "lng": -106.7942866,
    "url": "ht**********",
    "country": "United States",
    "state": "New Mexico",
    "city": "Las Cruces",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Constructions,Water utility companies"
  },
  {
    "name": "Coral Springs Water Department",
    "address": "95**********",
    "phone": "********1825",
    "email": "sb****@co**********",
    "lat": 26.271997,
    "lng": -80.2537056,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 1.9,
    "rating_count": 14,
    "category_name": "Water utility companies"
  }
]