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

[
  {
    "name": "Fountain Valley Field Services",
    "address": "17**********",
    "phone": "********4600",
    "email": "in**@fo**********",
    "lat": 33.7119605,
    "lng": -117.9314585,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Huntington Beach",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Water utility companies"
  },
  {
    "name": "Clackamas River Water",
    "address": "16**********",
    "phone": "********9220",
    "email": "cr*@cr*********",
    "lat": 45.400489,
    "lng": -122.568674,
    "url": "ht**********",
    "country": "United States",
    "state": "Oregon",
    "city": "Portland",
    "star_count": 3.9,
    "rating_count": 8,
    "category_name": "Water utility companies"
  },
  {
    "name": "South Florida Water Management",
    "address": "23**********",
    "phone": "********2929",
    "email": "cl***@sf*******",
    "lat": 26.635152,
    "lng": -81.8786087,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Cape Coral",
    "star_count": 4.3,
    "rating_count": 3,
    "category_name": "Environmental health services,Water utility companies"
  },
  {
    "name": "Spring Lake Wastewater Plant",
    "address": "35**********",
    "phone": "********5748",
    "email": "ks*****@to**********",
    "lat": 35.1965264,
    "lng": -78.966113,
    "url": "ht**********",
    "country": "United States",
    "state": "North Carolina",
    "city": "Fayetteville",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies,City government offices"
  },
  {
    "name": "Water & Sewer Billing Office",
    "address": "10**********",
    "phone": "********3974",
    "email": "ma*******@pi**********",
    "lat": 39.8817915,
    "lng": -82.7519068,
    "url": "ht**********",
    "country": "United States",
    "state": "Ohio",
    "city": "Columbus",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Municipal Water District of Orange County",
    "address": "18**********",
    "phone": "********3058",
    "email": "mg******@mw*******",
    "lat": 33.6937456,
    "lng": -117.9448123,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Huntington Beach",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Water utility companies"
  },
  {
    "name": "Northglenn Utilities Department",
    "address": "23**********",
    "phone": "********4051",
    "email": "cu**********@no**********",
    "lat": 39.899568,
    "lng": -105.0154033,
    "url": "ht**********",
    "country": "United States",
    "state": "Colorado",
    "city": "Northglenn",
    "star_count": 3,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Breckenridge Public Utilities",
    "address": "42**********",
    "phone": "********4681",
    "email": "nc******@br**********",
    "lat": 46.2649322,
    "lng": -96.5883879,
    "url": "ht**********",
    "country": "United States",
    "state": "Minnesota",
    "city": "Breckenridge",
    "star_count": 4.7,
    "rating_count": 3,
    "category_name": "Electric utility companies,Water utility companies,Electric Consultants"
  },
  {
    "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": "Tampa Water Department",
    "address": "30**********",
    "phone": "********8811",
    "email": "wa**********@ta*******",
    "lat": 27.9476392,
    "lng": -82.4572026,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Tampa",
    "star_count": 2.6,
    "rating_count": 57,
    "category_name": "Government offices,City government offices,Water utility companies,Public works departments"
  }
]