アメリカ合衆国の水道会社のリスト

[
  {
    "name": "Northern Water",
    "address": "72**********",
    "phone": "********3406",
    "email": "ac***@no**********",
    "lat": 40.1388639,
    "lng": -105.9079226,
    "url": "ht**********",
    "country": "United States",
    "state": "Colorado",
    "city": "Granby",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Pennsylvania American Water Co",
    "address": "90**********",
    "phone": "********3382",
    "email": "la**********@am*********",
    "lat": 40.8586446,
    "lng": -80.2557938,
    "url": "ht**********",
    "country": "United States",
    "state": "Pennsylvania",
    "city": "Ellport",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Hinsdale Water Billing",
    "address": "19**********",
    "phone": "********7020",
    "email": "ut**********@vi**********",
    "lat": 41.8042925,
    "lng": -87.9280833,
    "url": "ht**********",
    "country": "United States",
    "state": "Illinois",
    "city": "Chicago",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Montague Water Conservation",
    "address": "12**********",
    "phone": "********3371",
    "email": "mw**@at*****",
    "lat": 41.7279147,
    "lng": -122.5280909,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Montague",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Bulk Water Station (NWWSD)",
    "address": "15**********",
    "phone": "********9090",
    "email": "di******@nw*******",
    "lat": 41.3752263,
    "lng": -83.737793,
    "url": "ht**********",
    "country": "United States",
    "state": "Ohio",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Sayreville Water Department",
    "address": "45**********",
    "phone": "********7049",
    "email": "wa***@sa**********",
    "lat": 40.4578915,
    "lng": -74.3681792,
    "url": "ht**********",
    "country": "United States",
    "state": "New Jersey",
    "city": "Sayreville",
    "star_count": 4,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Lincoln Water System - Service Center",
    "address": "20**********",
    "phone": "********7551",
    "email": "we*****@li**********",
    "lat": 40.8329124,
    "lng": -96.6825942,
    "url": "ht**********",
    "country": "United States",
    "state": "Nebraska",
    "city": "Lincoln",
    "star_count": 3.1,
    "rating_count": 24,
    "category_name": "Water utility companies"
  },
  {
    "name": "Puyallup Utility Billing",
    "address": "33**********",
    "phone": "********5550",
    "email": "co********@pu**********",
    "lat": 47.1893029,
    "lng": -122.2934379,
    "url": "ht**********",
    "country": "United States",
    "state": "Washington",
    "city": "Tacoma",
    "star_count": 1.5,
    "rating_count": 13,
    "category_name": "Water utility companies"
  },
  {
    "name": "Sanford Water & Sewer Department",
    "address": "42**********",
    "phone": "********5090",
    "email": "Wi**********@sa**********",
    "lat": 28.7997767,
    "lng": -81.2727319,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Orlando",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Seattle Water Department",
    "address": "Se**********",
    "phone": "********3000",
    "email": "SP**********@se*********",
    "lat": 47.6164947,
    "lng": -122.3198988,
    "url": "ht**********",
    "country": "United States",
    "state": "Washington",
    "city": "Seattle",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Water utility companies"
  }
]