قائمة شركات المرافق المائية في أمريكا الشمالية

[
  {
    "name": "Mobile Area Water & Sewer",
    "address": "16**********",
    "phone": "********3100",
    "email": "dr******@ma*******",
    "lat": 30.6609001,
    "lng": -88.0380554,
    "url": "ht**********",
    "country": "United States",
    "state": "Alabama",
    "city": "Mobile",
    "star_count": 2,
    "rating_count": 9,
    "category_name": "Water utility companies"
  },
  {
    "name": "Atlanta Water System",
    "address": "22**********",
    "phone": "********0409",
    "email": "wo*******@ex*********",
    "lat": 31.9452578,
    "lng": -92.633454,
    "url": "ht**********",
    "country": "United States",
    "state": "Louisiana",
    "city": "Winnfield",
    "star_count": 3,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Crown Water Treatment Plant",
    "address": "95**********",
    "phone": "********2444",
    "email": "we**********@cl**********",
    "lat": 41.4749259,
    "lng": -81.8805694,
    "url": "ht**********",
    "country": "United States",
    "state": "Ohio",
    "city": "Westlake",
    "star_count": 5,
    "rating_count": 7,
    "category_name": "Water utility companies"
  },
  {
    "name": "Board of Public Utilities",
    "address": "11**********",
    "phone": "********1322",
    "email": "pa******@pa**********",
    "lat": 36.3024119,
    "lng": -88.3246845,
    "url": "ht**********",
    "country": "United States",
    "state": "Tennessee",
    "city": "Paris",
    "star_count": 2.5,
    "rating_count": 35,
    "category_name": "Water utility companies,Public utilities"
  },
  {
    "name": "Bexley Water Department",
    "address": "22**********",
    "phone": "********4270",
    "email": "jm******@be********",
    "lat": 39.9579956,
    "lng": -82.9396107,
    "url": "ht**********",
    "country": "United States",
    "state": "Ohio",
    "city": "Columbus",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Tammany Utilities",
    "address": "21**********",
    "phone": "********6400",
    "email": "ut*******@st********",
    "lat": 30.4173007,
    "lng": -90.0433735,
    "url": "ht**********",
    "country": "United States",
    "state": "Louisiana",
    "city": null,
    "star_count": 1.3,
    "rating_count": 38,
    "category_name": "Water utility companies"
  },
  {
    "name": "Brunswick County Utility Operations Center",
    "address": "Gr**********",
    "phone": "********2657",
    "email": "ut**********@br**********",
    "lat": 34.0255379,
    "lng": -78.2743999,
    "url": "ht**********",
    "country": "United States",
    "state": "North Carolina",
    "city": null,
    "star_count": 3.4,
    "rating_count": 5,
    "category_name": "Water utility companies"
  },
  {
    "name": "Water Management Inc",
    "address": "32**********",
    "phone": "********9995",
    "email": "se*****@wa**********",
    "lat": 35.954032,
    "lng": -86.8283765,
    "url": "ht**********",
    "country": "United States",
    "state": "Tennessee",
    "city": "Franklin",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Oregon Water",
    "address": "53**********",
    "phone": "********7039",
    "email": "kj***@or**********",
    "lat": 41.651327,
    "lng": -83.4201741,
    "url": "ht**********",
    "country": "United States",
    "state": "Ohio",
    "city": "Oregon",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Water utility companies"
  },
  {
    "name": "Mobile Area Water and Sewer System",
    "address": "47**********",
    "phone": "********3100",
    "email": "dr******@ma*******",
    "lat": 30.7184266,
    "lng": -88.150744,
    "url": "ht**********",
    "country": "United States",
    "state": "Alabama",
    "city": "Mobile",
    "star_count": 2,
    "rating_count": 107,
    "category_name": "Water utility companies"
  }
]