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

[
  {
    "name": "Aqua Haulics Inc.",
    "address": "",
    "phone": "********2782",
    "email": "pa**@aq**********",
    "lat": 51.2072,
    "lng": -121.9883,
    "url": "ht**********",
    "country": "Canada",
    "state": "British Columbia",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water purification companies,Drinking water fountains,Service establishments,Water utility companies,Companies"
  },
  {
    "name": "Utilities-Water & Sewer",
    "address": "42**********",
    "phone": "********5616",
    "email": "tr******@ci**********",
    "lat": 47.0448756,
    "lng": -122.8227135,
    "url": "ht**********",
    "country": "United States",
    "state": "Washington",
    "city": "Olympia",
    "star_count": 1.4,
    "rating_count": 21,
    "category_name": "Water utility companies"
  },
  {
    "name": "Myrtle Beach Utility Billing",
    "address": "My**********",
    "phone": "********1212",
    "email": "mb*******@ci**********",
    "lat": 33.6964721,
    "lng": -78.8828735,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Myrtle Beach",
    "star_count": 1.3,
    "rating_count": 9,
    "category_name": "Water utility companies"
  },
  {
    "name": "Itron Inc",
    "address": "60**********",
    "phone": "********0616",
    "email": "su*****@it*******",
    "lat": 45.628969,
    "lng": -122.6653929,
    "url": "ht**********",
    "country": "United States",
    "state": "Washington",
    "city": "Vancouver",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Hollister Water & Sewer",
    "address": "12**********",
    "phone": "********4377",
    "email": "pi*@ho**********",
    "lat": 36.8484169,
    "lng": -121.420773,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Hollister",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Mount Pleasant Waterworks",
    "address": "16**********",
    "phone": "********9626",
    "email": "cu**********@mp**********",
    "lat": 32.8108088,
    "lng": -79.8322246,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Mount Pleasant",
    "star_count": 2.6,
    "rating_count": 56,
    "category_name": "Water utility companies"
  },
  {
    "name": "Newnan Utilities",
    "address": "70**********",
    "phone": "********5516",
    "email": "in**@ne**********",
    "lat": 33.3591921,
    "lng": -84.7999493,
    "url": "ht**********",
    "country": "United States",
    "state": "Georgia",
    "city": "Atlanta",
    "star_count": 3.8,
    "rating_count": 124,
    "category_name": "Water utility companies,Utility contractors,Electric Consultants,Corporate campus,Corporate offices,Electric utility companies"
  },
  {
    "name": "Groton Utilities",
    "address": "29**********",
    "phone": "********4000",
    "email": "wa**********@gr**********",
    "lat": 41.3527526,
    "lng": -72.070671,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Groton",
    "star_count": 3,
    "rating_count": 36,
    "category_name": "Electric utility companies,Electric Consultants,Water utility companies"
  },
  {
    "name": "MWRA Advisory Board",
    "address": "2 **********",
    "phone": "********2050",
    "email": "mw*****@mw**********",
    "lat": 42.3754861,
    "lng": -71.053787,
    "url": "ht**********",
    "country": "United States",
    "state": "Massachusetts",
    "city": "Boston",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Horsham Water & Sewer Auth",
    "address": "61**********",
    "phone": "********8011",
    "email": "co*****@ho**********",
    "lat": 40.1905917,
    "lng": -75.1502649,
    "url": "ht**********",
    "country": "United States",
    "state": "Pennsylvania",
    "city": "Philadelphia",
    "star_count": 3.5,
    "rating_count": 11,
    "category_name": "Water utility companies"
  }
]