قائمة شركات المرافق المائية في الولايات المتحدة

[
  {
    "name": "Hemet Water Filtration Facility",
    "address": "12**********",
    "phone": "********3777",
    "email": "pe******@em******",
    "lat": 33.7686909,
    "lng": -116.9989781,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Hemet",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Salisbury Rowan Utilities (Customer Service/Billing)",
    "address": "14**********",
    "phone": "********5300",
    "email": "cu**********@sa**********",
    "lat": 35.6523009,
    "lng": -80.4849153,
    "url": "ht**********",
    "country": "United States",
    "state": "North Carolina",
    "city": "Salisbury",
    "star_count": 2.4,
    "rating_count": 38,
    "category_name": "Water utility companies"
  },
  {
    "name": "Greenville Water",
    "address": "40**********",
    "phone": "********6000",
    "email": "cf******@gr**********",
    "lat": 34.8519253,
    "lng": -82.4058682,
    "url": "ht**********",
    "country": "United States",
    "state": "South Carolina",
    "city": "Greenville",
    "star_count": 2,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Crowley Water Department",
    "address": "20**********",
    "phone": "********2201",
    "email": "rc***@ci**********",
    "lat": 32.5791227,
    "lng": -97.3573942,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Fort Worth",
    "star_count": 2.7,
    "rating_count": 12,
    "category_name": "Water utility companies"
  },
  {
    "name": "Yakima Water Treatment Plant",
    "address": "Ya**********",
    "phone": "********6177",
    "email": "mi********@ya**********",
    "lat": 46.6854891,
    "lng": -120.6500086,
    "url": "ht**********",
    "country": "United States",
    "state": "Washington",
    "city": null,
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Brookfield Water Department",
    "address": "45**********",
    "phone": "********7344",
    "email": "he**@br**********",
    "lat": 41.8075573,
    "lng": -87.8592765,
    "url": "ht**********",
    "country": "United States",
    "state": "Illinois",
    "city": "Chicago",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Fayetteville Sewer Maintenance",
    "address": "24**********",
    "phone": "********8386",
    "email": "ut*********@fa**********",
    "lat": 36.0364112,
    "lng": -94.1451721,
    "url": "ht**********",
    "country": "United States",
    "state": "Arkansas",
    "city": "Fayetteville",
    "star_count": 3.8,
    "rating_count": 4,
    "category_name": "Sewage disposal services,Water utility companies"
  },
  {
    "name": "Portland City Water Department",
    "address": "45**********",
    "phone": "********2948",
    "email": "PW**********@po**********",
    "lat": 42.8759915,
    "lng": -84.9010642,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Portland",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Mundelein Water Department",
    "address": "42**********",
    "phone": "********3273",
    "email": "Wa**********@mu**********",
    "lat": 42.270375,
    "lng": -88.0014999,
    "url": "ht**********",
    "country": "United States",
    "state": "Illinois",
    "city": "Chicago",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Parks,Amusement parks,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.7,
    "rating_count": 11,
    "category_name": "Water utility companies"
  }
]