List of Water utility companies in Missouri

[
  {
    "name": "Missouri American Water Co",
    "address": "17**********",
    "phone": "********0820",
    "email": "bu**********@am*********",
    "lat": 38.7594301,
    "lng": -93.7055861,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Warrensburg",
    "star_count": 1.5,
    "rating_count": 21,
    "category_name": "Water utility companies"
  },
  {
    "name": "Water Supply District-Adair County",
    "address": "17**********",
    "phone": "********4280",
    "email": "of****@ad**********",
    "lat": 40.2094989,
    "lng": -92.5906203,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Kirksville",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Lancaster City Water Works",
    "address": "20**********",
    "phone": "********3022",
    "email": "sc*******@ya*******",
    "lat": 40.5224423,
    "lng": -92.5252527,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Lancaster",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Holiday Island Suburban Water",
    "address": "8 **********",
    "phone": "********7211",
    "email": "ne********@hi********",
    "lat": 36.4990892,
    "lng": -93.7512595,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Cassville Water Office",
    "address": "30**********",
    "phone": "********2011",
    "email": "jp******@ci**********",
    "lat": 36.6766094,
    "lng": -93.8698381,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Cassville",
    "star_count": 3,
    "rating_count": 4,
    "category_name": "Water utility companies"
  },
  {
    "name": "Public Water Supply District 16",
    "address": "10**********",
    "phone": "********5537",
    "email": "pw****@co*********",
    "lat": 39.1775049,
    "lng": -94.198987,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 3,
    "rating_count": 2,
    "category_name": "Water utility companies"
  },
  {
    "name": "Public Water Supply District 7",
    "address": "89**********",
    "phone": "********6625",
    "email": "pw*********@fa**********",
    "lat": 38.6356792,
    "lng": -94.4983648,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Water utility companies"
  },
  {
    "name": "Public Water Supply District #5",
    "address": "34**********",
    "phone": "********4800",
    "email": "pw********@gm*******",
    "lat": 37.372214,
    "lng": -89.458567,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "PWSD #10 of Cass County",
    "address": "53**********",
    "phone": "********5381",
    "email": "pw****@fa**********",
    "lat": 38.723453,
    "lng": -94.466308,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Peculiar",
    "star_count": 2,
    "rating_count": 4,
    "category_name": "Water utility companies"
  },
  {
    "name": "La Grange Waterplant",
    "address": "11**********",
    "phone": "********0211",
    "email": "la******@ci**********",
    "lat": 40.0422585,
    "lng": -91.4983623,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Missouri American Water",
    "address": "28**********",
    "phone": "********2782",
    "email": "bu**********@am*********",
    "lat": 38.8193637,
    "lng": -90.3695379,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "St. Louis",
    "star_count": 1,
    "rating_count": 6,
    "category_name": "Water utility companies"
  },
  {
    "name": "Public Water Supply",
    "address": "90**********",
    "phone": "********6033",
    "email": "Ci**********@ke**********",
    "lat": 39.3648549,
    "lng": -94.3367531,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Kearney",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Butler County PWSD #3",
    "address": "31**********",
    "phone": "********5571",
    "email": "in**@bu**********",
    "lat": 36.7478409,
    "lng": -90.3345947,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Poplar Bluff",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Public Water Supply District No. 3",
    "address": "81**********",
    "phone": "********5606",
    "email": "pw*****@pw**********",
    "lat": 39.7816306,
    "lng": -93.0867217,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Brookfield",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Public Water Supply District #3 of Franklin County",
    "address": "15**********",
    "phone": "********5200",
    "email": "in**@fr**********",
    "lat": 38.4710795,
    "lng": -90.8594124,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Villa Ridge",
    "star_count": 1.8,
    "rating_count": 30,
    "category_name": "Water utility companies"
  },
  {
    "name": "VerDouw Regulatory Services",
    "address": "",
    "phone": "********6154",
    "email": "ga**@ve**********",
    "lat": 38.7752254,
    "lng": -90.6132149,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "St. Louis",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies,Service establishments,Companies"
  },
  {
    "name": "Culligan Water Conditioning",
    "address": "11**********",
    "phone": "********2918",
    "email": "me***@cu**********",
    "lat": 39.0846748,
    "lng": -93.7171928,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Higginsville",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Holden Water Department",
    "address": "90**********",
    "phone": "********6343",
    "email": "cu**********@om**********",
    "lat": 38.7108438,
    "lng": -93.9879851,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Holden",
    "star_count": 2.3,
    "rating_count": 6,
    "category_name": "Water utility companies"
  },
  {
    "name": "Missouri American Water Co",
    "address": "32**********",
    "phone": "********3225",
    "email": "bu**********@am*********",
    "lat": 39.4189799,
    "lng": -93.1171679,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Public Water Supply District No.4 Scott County Missouri",
    "address": "66**********",
    "phone": "********2207",
    "email": "cu**********@pw*******",
    "lat": 37.0082607,
    "lng": -89.6006375,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Platte County Regional Sewer District",
    "address": "60**********",
    "phone": "********2052",
    "email": "pc***@pc*******",
    "lat": 39.1917139,
    "lng": -94.6823395,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Parkville",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Missouri American Water Co",
    "address": "10**********",
    "phone": "********1645",
    "email": "bu**********@am*********",
    "lat": 38.8666685,
    "lng": -90.9638955,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Public Water Supply",
    "address": "66**********",
    "phone": "********2500",
    "email": "ad**********@pw********",
    "lat": 38.3518446,
    "lng": -90.427316,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "St. Louis",
    "star_count": 1.6,
    "rating_count": 37,
    "category_name": "Water utility companies"
  },
  {
    "name": "Water Supply District 6",
    "address": "60**********",
    "phone": "********4096",
    "email": "Ma*****@pw*******",
    "lat": 38.4232196,
    "lng": -90.5536254,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "St. Louis",
    "star_count": 2.9,
    "rating_count": 15,
    "category_name": "Water utility companies"
  },
  {
    "name": "Clarence Cannon Wholesale Water Commission",
    "address": "34**********",
    "phone": "********3221",
    "email": "hh***@cl**********",
    "lat": 39.496921,
    "lng": -91.848181,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Missouri American Water Service Center Facility",
    "address": "35**********",
    "phone": "********0820",
    "email": "bu**********@am*********",
    "lat": 39.7324218,
    "lng": -94.7877334,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Saint Joseph",
    "star_count": 3,
    "rating_count": 4,
    "category_name": "Water utility companies"
  },
  {
    "name": "Public Water Supply",
    "address": "4 **********",
    "phone": "********2231",
    "email": "pw*****@em**********",
    "lat": 38.8263729,
    "lng": -93.7421323,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Public Water Supply District 1",
    "address": "22**********",
    "phone": "********4776",
    "email": "pw******@gr*****",
    "lat": 40.5116888,
    "lng": -93.5324576,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Mo-Ark Water Co",
    "address": "12**********",
    "phone": "********5217",
    "email": "mo********@ou*********",
    "lat": 36.5628697,
    "lng": -93.4367947,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Harrisonville Utility Business",
    "address": "30**********",
    "phone": "********8900",
    "email": "bs*********@ha**********",
    "lat": 38.6551244,
    "lng": -94.3470987,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Harrisonville",
    "star_count": 2,
    "rating_count": 4,
    "category_name": "Water utility companies"
  }
]