[
  {
    "id": "cmrksejq9000hjt08vknl9f7n",
    "pwsid": "AZ0413027",
    "name": "City of Phoenix Water Services Department",
    "city": "Phoenix",
    "state": "AZ",
    "zipCodes": "85001,85002,85003,85004,85006,85007,85008,85009,85012,85013,85014,85015,85016,85017,85018,85019,85020,85021,85022,85023",
    "county": "Maricopa",
    "population": 1626000,
    "systemType": "Community",
    "sourceType": "Mixed",
    "treatmentStatus": "Treated",
    "latitude": 33.4484,
    "longitude": -112.074,
    "website": "https://www.phoenix.gov/waterservices",
    "notes": "Sources: Salt River Project, Colorado River (via CAP), and groundwater.",
    "createdAt": "2026-07-14T15:09:24.705Z",
    "updatedAt": "2026-08-15T19:18:38.468Z"
  },
  {
    "id": "cmrksejpy000fjt08kobvfvig",
    "pwsid": "CA1910052",
    "name": "Los Angeles Department of Water and Power",
    "city": "Los Angeles",
    "state": "CA",
    "zipCodes": "90001,90002,90003,90004,90005,90006,90007,90008,90011,90012,90013,90015,90017,90019,90020,90024,90026,90028,90042,90048",
    "county": "Los Angeles",
    "population": 3902000,
    "systemType": "Community",
    "sourceType": "Mixed",
    "treatmentStatus": "Treated",
    "latitude": 34.0522,
    "longitude": -118.2437,
    "website": "https://www.ladwp.com",
    "notes": "Sources: LA Aqueduct (Owens Valley), California Aqueduct, Colorado River Aqueduct, local groundwater.",
    "createdAt": "2026-07-14T15:09:24.695Z",
    "updatedAt": "2026-08-15T19:18:38.436Z"
  },
  {
    "id": "cmrksejqs000ljt087ootkg2p",
    "pwsid": "CA3610008",
    "name": "San Diego Water Department",
    "city": "San Diego",
    "state": "CA",
    "zipCodes": "92101,92102,92103,92104,92105,92106,92107,92108,92109,92110,92111,92113,92114,92115,92116,92117,92119,92120,92121,92122",
    "county": "San Diego",
    "population": 1386000,
    "systemType": "Community",
    "sourceType": "Mixed",
    "treatmentStatus": "Treated",
    "latitude": 32.7157,
    "longitude": -117.1611,
    "website": "https://www.sandiego.gov/public-utilities",
    "notes": "Sources: Imported (Colorado River, Northern CA) and local surface water.",
    "createdAt": "2026-07-14T15:09:24.724Z",
    "updatedAt": "2026-08-15T19:18:38.533Z"
  },
  {
    "id": "cmskhngju0015l5098xck8250",
    "pwsid": "CA3810011",
    "name": "San Francisco Public Utilities Commission",
    "city": "San Francisco",
    "state": "CA",
    "zipCodes": "94101,94102,94103,94104,94105,94107,94108,94109,94110,94111,94112,94114,94115,94116,94117,94118,94121,94122,94123,94124",
    "county": "San Francisco",
    "population": 870000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 37.7749,
    "longitude": -122.4194,
    "website": "https://www.sfwater.org",
    "notes": "Source: Hetch Hetchy Reservoir (Yosemite) with local reservoirs. Mostly unfiltered, UV + chlorine.",
    "createdAt": "2026-08-08T14:48:07.051Z",
    "updatedAt": "2026-08-15T19:18:38.701Z"
  },
  {
    "id": "cmskhngji0012l5098jqheodg",
    "pwsid": "CO0116400",
    "name": "Denver Water",
    "city": "Denver",
    "state": "CO",
    "zipCodes": "80201,80202,80203,80204,80205,80206,80207,80208,80209,80210,80211,80212,80214,80216,80218,80219,80220,80221,80222,80223",
    "county": "Denver",
    "population": 760000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 39.7392,
    "longitude": -104.9903,
    "website": "https://www.denverwater.org",
    "notes": "Sources: South Platte River, Blue River, Williams Fork River, Fraser River, Ralston Creek.",
    "createdAt": "2026-08-08T14:48:07.038Z",
    "updatedAt": "2026-08-15T19:18:38.650Z"
  },
  {
    "id": "cmrksejqi000jjt08xap8wzmw",
    "pwsid": "FL6020055",
    "name": "Miami-Dade Water and Sewer Department",
    "city": "Miami",
    "state": "FL",
    "zipCodes": "33101,33109,33110,33124,33125,33126,33127,33128,33129,33130,33131,33132,33133,33134,33135,33136,33137,33138,33139,33140",
    "county": "Miami-Dade",
    "population": 2356000,
    "systemType": "Community",
    "sourceType": "Ground",
    "treatmentStatus": "Treated",
    "latitude": 25.7617,
    "longitude": -80.1918,
    "website": "https://www.miamidade.gov/water",
    "notes": "Sources: Biscayne Aquifer (groundwater).",
    "createdAt": "2026-07-14T15:09:24.715Z",
    "updatedAt": "2026-08-15T19:18:38.502Z"
  },
  {
    "id": "cmskhngjm0013l509oaq7uuio",
    "pwsid": "GA2410000",
    "name": "City of Atlanta Department of Watershed Management",
    "city": "Atlanta",
    "state": "GA",
    "zipCodes": "30301,30302,30303,30304,30305,30306,30307,30308,30309,30310,30311,30312,30313,30314,30315,30316,30317,30318,30319,30324",
    "county": "Fulton",
    "population": 506000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 33.749,
    "longitude": -84.388,
    "website": "https://www.atlantawatershed.org",
    "notes": "Sources: Chattahoochee River and Lake Lanier.",
    "createdAt": "2026-08-08T14:48:07.042Z",
    "updatedAt": "2026-08-15T19:18:38.666Z"
  },
  {
    "id": "cmrksejpf000djt08dbv11kwl",
    "pwsid": "IL0316040",
    "name": "City of Chicago Department of Water Management",
    "city": "Chicago",
    "state": "IL",
    "zipCodes": "60601,60602,60603,60604,60605,60606,60607,60608,60609,60610,60611,60612,60613,60614,60615,60616,60617,60618,60619,60620",
    "county": "Cook",
    "population": 2716000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 41.8781,
    "longitude": -87.6298,
    "website": "https://www.chicago.gov/city/en/depts/water.html",
    "notes": "Draws from Lake Michigan, one of the largest surface water systems in the US.",
    "createdAt": "2026-07-14T15:09:24.676Z",
    "updatedAt": "2026-08-15T19:18:38.383Z"
  },
  {
    "id": "cmskhngl0001fl5092dw8pbnh",
    "pwsid": "IN5260001",
    "name": "Citizens Energy Group (Indianapolis Water)",
    "city": "Indianapolis",
    "state": "IN",
    "zipCodes": "46201,46202,46203,46204,46205,46206,46208,46214,46216,46217,46218,46219,46220,46221,46222,46224,46225,46226,46227,46228",
    "county": "Marion",
    "population": 876000,
    "systemType": "Community",
    "sourceType": "Mixed",
    "treatmentStatus": "Treated",
    "latitude": 39.7684,
    "longitude": -86.1581,
    "website": "https://www.citizensenergygroup.com",
    "notes": "Sources: White River, Fall Creek, Geist Reservoir, Morse Reservoir, and groundwater aquifers.",
    "createdAt": "2026-08-08T14:48:07.092Z",
    "updatedAt": "2026-08-15T19:18:38.864Z"
  },
  {
    "id": "cmskhngkn001cl5093rclvcir",
    "pwsid": "LA1100000",
    "name": "New Orleans Sewerage and Water Board",
    "city": "New Orleans",
    "state": "LA",
    "zipCodes": "70112,70113,70114,70115,70116,70117,70118,70119,70122,70124,70125,70127,70128,70129,70130,70131,70148,70150,70163,70165",
    "county": "Orleans",
    "population": 390000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 29.9511,
    "longitude": -90.0715,
    "website": "https://www.swbno.org",
    "notes": "Source: Mississippi River. Vulnerable to storm surges and infrastructure failures.",
    "createdAt": "2026-08-08T14:48:07.079Z",
    "updatedAt": "2026-08-15T19:18:38.817Z"
  },
  {
    "id": "cmskhngjz0016l509arjgpzws",
    "pwsid": "MA6000000",
    "name": "Massachusetts Water Resources Authority",
    "city": "Boston",
    "state": "MA",
    "zipCodes": "02101,02102,02103,02104,02105,02108,02109,02110,02111,02113,02114,02115,02116,02118,02119,02120,02121,02122,02124,02125",
    "county": "Suffolk",
    "population": 650000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 42.3601,
    "longitude": -71.0589,
    "website": "https://www.mwra.com",
    "notes": "Source: Quabbin and Wachusett Reservoirs. Serves 3.1 million people in Greater Boston.",
    "createdAt": "2026-08-08T14:48:07.055Z",
    "updatedAt": "2026-08-15T19:18:38.717Z"
  },
  {
    "id": "cmskhngix000yl5091uglhwxz",
    "pwsid": "MI0003850",
    "name": "City of Flint Water Department",
    "city": "Flint",
    "state": "MI",
    "zipCodes": "48501,48502,48503,48504,48505,48506,48507,48529,48532,48550",
    "county": "Genesee",
    "population": 97000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 43.0125,
    "longitude": -83.6875,
    "website": "https://www.cityofflint.com/water/",
    "notes": "Flint River source. Site of the 2014-2019 lead contamination crisis after source water switch without corrosion control.",
    "createdAt": "2026-08-08T14:48:07.017Z",
    "updatedAt": "2026-08-15T19:18:38.581Z"
  },
  {
    "id": "cmskhngja0010l5098x7uof8i",
    "pwsid": "MI0003880",
    "name": "Detroit Water and Sewerage Department",
    "city": "Detroit",
    "state": "MI",
    "zipCodes": "48201,48202,48203,48204,48205,48206,48207,48208,48209,48210,48211,48212,48213,48214,48215,48216,48217,48219,48221,48224",
    "county": "Wayne",
    "population": 670000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 42.3314,
    "longitude": -83.0458,
    "website": "https://dwsd.org",
    "notes": "Source: Detroit River. Serves most of Southeast Michigan. Also supplied Flint before the 2014 switch.",
    "createdAt": "2026-08-08T14:48:07.030Z",
    "updatedAt": "2026-08-15T19:18:38.616Z"
  },
  {
    "id": "cmskhngkj001bl5099p1aurrm",
    "pwsid": "MN0100002",
    "name": "City of Minneapolis Water Treatment & Distribution",
    "city": "Minneapolis",
    "state": "MN",
    "zipCodes": "55401,55402,55403,55404,55405,55406,55407,55408,55409,55411,55412,55413,55414,55415,55416,55417,55418,55419,55420,55421",
    "county": "Hennepin",
    "population": 425000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 44.9778,
    "longitude": -93.265,
    "website": "https://www.minneapolismn.gov/resident-resources/water/",
    "notes": "Source: Mississippi River. Ultrafiltration + granular activated carbon treatment.",
    "createdAt": "2026-08-08T14:48:07.075Z",
    "updatedAt": "2026-08-15T19:18:38.801Z"
  },
  {
    "id": "cmskhngkw001el509r6pi2zae",
    "pwsid": "MO6010810",
    "name": "City of St. Louis Water Division",
    "city": "St. Louis",
    "state": "MO",
    "zipCodes": "63101,63102,63103,63104,63105,63106,63107,63108,63109,63110,63111,63112,63113,63115,63116,63118,63119,63120,63121,63133",
    "county": "St. Louis",
    "population": 300000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 38.627,
    "longitude": -90.1994,
    "website": "https://www.stlwater.com",
    "notes": "Sources: Missouri and Mississippi Rivers. Two treatment plants serving the city.",
    "createdAt": "2026-08-08T14:48:07.088Z",
    "updatedAt": "2026-08-15T19:18:38.848Z"
  },
  {
    "id": "cmskhngl5001gl5091x7d746m",
    "pwsid": "NC0160010",
    "name": "Charlotte Water",
    "city": "Charlotte",
    "state": "NC",
    "zipCodes": "28201,28202,28203,28204,28205,28206,28207,28208,28209,28210,28211,28212,28213,28215,28216,28217,28226,28227,28244,28262",
    "county": "Mecklenburg",
    "population": 872000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 35.2271,
    "longitude": -80.8431,
    "website": "https://www.charlottewater.gov",
    "notes": "Source: Catawba River (Mountain Island Lake and Lake Norman).",
    "createdAt": "2026-08-08T14:48:07.097Z",
    "updatedAt": "2026-08-15T19:18:38.879Z"
  },
  {
    "id": "cmskhngj6000zl509ws7ixpss",
    "pwsid": "NJ0712001",
    "name": "Newark Department of Water and Sewer Utilities",
    "city": "Newark",
    "state": "NJ",
    "zipCodes": "07101,07102,07103,07104,07105,07106,07107,07108,07111,07112",
    "county": "Essex",
    "population": 282000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 40.7357,
    "longitude": -74.1724,
    "website": "https://www.newarknj.gov/water",
    "notes": "Source: Pequannock/Wanaque watersheds. Experienced elevated lead levels in 2016-2019 due to lead service lines.",
    "createdAt": "2026-08-08T14:48:07.026Z",
    "updatedAt": "2026-08-15T19:18:38.601Z"
  },
  {
    "id": "cmskhngk60018l509jnq11yrg",
    "pwsid": "NV7011000",
    "name": "Las Vegas Valley Water District",
    "city": "Las Vegas",
    "state": "NV",
    "zipCodes": "89101,89102,89103,89104,89106,89107,89108,89109,89110,89113,89115,89117,89118,89119,89120,89121,89122,89123,89129,89131",
    "county": "Clark",
    "population": 641000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 36.1699,
    "longitude": -115.1398,
    "website": "https://www.lvvwd.com",
    "notes": "Source: Lake Mead (Colorado River). Facing declining water levels due to prolonged drought.",
    "createdAt": "2026-08-08T14:48:07.063Z",
    "updatedAt": "2026-08-15T19:18:38.748Z"
  },
  {
    "id": "cmrksejpu000ejt080y970g62",
    "pwsid": "NY7003493",
    "name": "New York City Department of Environmental Protection",
    "city": "New York",
    "state": "NY",
    "zipCodes": "10001,10002,10003,10004,10005,10011,10012,10013,10021,10024,10025,10036",
    "county": "New York",
    "population": 8336000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 40.7128,
    "longitude": -74.006,
    "website": "https://www.nyc.gov/site/dep/index.page",
    "notes": "Sources: Catskill/Delaware and Croton watersheds. Mostly unfiltered, UV + chlorine disinfection.",
    "createdAt": "2026-07-14T15:09:24.690Z",
    "updatedAt": "2026-08-15T19:18:38.420Z"
  },
  {
    "id": "cmrksejqn000kjt08j98pd69w",
    "pwsid": "OH1800312",
    "name": "City of Columbus Division of Water",
    "city": "Columbus",
    "state": "OH",
    "zipCodes": "43201,43202,43203,43204,43205,43206,43207,43209,43210,43211,43212,43213,43214,43215,43219,43220,43221,43222,43223,43224",
    "county": "Franklin",
    "population": 898000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 39.9612,
    "longitude": -82.9988,
    "website": "https://www.columbus.gov/utilities",
    "notes": "Sources: Scioto River and Big Walnut Creek.",
    "createdAt": "2026-07-14T15:09:24.720Z",
    "updatedAt": "2026-08-15T19:18:38.517Z"
  },
  {
    "id": "cmskhngks001dl50968qq03nv",
    "pwsid": "OH1800010",
    "name": "Greater Cincinnati Water Works",
    "city": "Cincinnati",
    "state": "OH",
    "zipCodes": "45201,45202,45203,45204,45205,45206,45207,45208,45209,45211,45212,45213,45214,45215,45216,45217,45218,45219,45220,45224",
    "county": "Hamilton",
    "population": 300000,
    "systemType": "Community",
    "sourceType": "Mixed",
    "treatmentStatus": "Treated",
    "latitude": 39.1031,
    "longitude": -84.512,
    "website": "https://www.cincinnati-oh.gov/water",
    "notes": "Sources: Ohio River and Great Miami Aquifer. Pioneered granular activated carbon treatment.",
    "createdAt": "2026-08-08T14:48:07.084Z",
    "updatedAt": "2026-08-15T19:18:38.832Z"
  },
  {
    "id": "cmskhngkb0019l509nabys8dp",
    "pwsid": "OR4100150",
    "name": "Portland Water Bureau",
    "city": "Portland",
    "state": "OR",
    "zipCodes": "97201,97202,97203,97204,97205,97206,97209,97210,97211,97212,97213,97214,97215,97216,97217,97218,97219,97220,97221,97222",
    "county": "Multnomah",
    "population": 654000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 45.5152,
    "longitude": -122.6784,
    "website": "https://www.portland.gov/water",
    "notes": "Source: Bull Run Watershed. Unfiltered, UV + chlorine disinfection. Among cleanest large systems in US.",
    "createdAt": "2026-08-08T14:48:07.067Z",
    "updatedAt": "2026-08-15T19:18:38.765Z"
  },
  {
    "id": "cmskhngk30017l509usb3bq4c",
    "pwsid": "PA3000000",
    "name": "Pittsburgh Water and Sewer Authority",
    "city": "Pittsburgh",
    "state": "PA",
    "zipCodes": "15201,15202,15203,15204,15205,15206,15207,15208,15209,15210,15211,15212,15213,15214,15215,15216,15217,15218,15219,15220",
    "county": "Allegheny",
    "population": 305000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 40.4406,
    "longitude": -79.9959,
    "website": "https://www.pgh2o.com",
    "notes": "Source: Allegheny River. Experienced lead exceedances and violations 2016-2019.",
    "createdAt": "2026-08-08T14:48:07.059Z",
    "updatedAt": "2026-08-15T19:18:38.732Z"
  },
  {
    "id": "cmrksejqe000ijt08ex91qnro",
    "pwsid": "PA1510001",
    "name": "Philadelphia Water Department",
    "city": "Philadelphia",
    "state": "PA",
    "zipCodes": "19102,19103,19104,19106,19107,19111,19114,19115,19116,19118,19119,19120,19121,19122,19123,19124,19125,19127,19128,19129",
    "county": "Philadelphia",
    "population": 1574000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 39.9526,
    "longitude": -75.1652,
    "website": "https://www.phila.gov/water",
    "notes": "Sources: Schuylkill and Delaware Rivers.",
    "createdAt": "2026-07-14T15:09:24.710Z",
    "updatedAt": "2026-08-15T19:18:38.484Z"
  },
  {
    "id": "cmskhngkf001al5091psg765w",
    "pwsid": "TN0000015",
    "name": "Metro Nashville Water Services",
    "city": "Nashville",
    "state": "TN",
    "zipCodes": "37201,37202,37203,37204,37205,37206,37207,37208,37209,37210,37211,37212,37214,37215,37216,37217,37218,37219,37220,37221",
    "county": "Davidson",
    "population": 694000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 36.1627,
    "longitude": -86.7816,
    "website": "https://www.nashville.gov/Water-Services",
    "notes": "Source: Cumberland River (J. Percy Priest Lake and Old Hickory Lake).",
    "createdAt": "2026-08-08T14:48:07.071Z",
    "updatedAt": "2026-08-15T19:18:38.782Z"
  },
  {
    "id": "cmskgw2fj000numos8t5eskaz",
    "pwsid": "TX2200012",
    "name": "Fort Worth Water Department",
    "city": "Fort Worth",
    "state": "TX",
    "zipCodes": "76137,76101,76102,76103,76104,76105,76106,76107,76108,76109,76110,76111,76112,76114,76115,76116,76117,76118,76119,76120",
    "county": "Tarrant",
    "population": 950000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 32.7555,
    "longitude": -97.3308,
    "website": "https://www.fortworthtexas.gov/departments/water",
    "notes": "Draws from Lake Worth, Eagle Mountain Lake, Lake Bridgeport, and Cedar Creek Reservoir.",
    "createdAt": "2026-08-08T14:26:49.039Z",
    "updatedAt": "2026-08-15T19:18:38.566Z"
  },
  {
    "id": "cmskhngjq0014l5094buvrr9y",
    "pwsid": "TX0570017",
    "name": "Dallas Water Utilities",
    "city": "Dallas",
    "state": "TX",
    "zipCodes": "75201,75202,75203,75204,75205,75206,75207,75208,75209,75210,75211,75212,75214,75215,75216,75217,75218,75219,75220,75224",
    "county": "Dallas",
    "population": 1304000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 32.7767,
    "longitude": -96.797,
    "website": "https://dallascityhall.com/departments/waterutilities",
    "notes": "Sources: Ray Hubbard, Lewisville, Grapevine, Ray Roberts, and Tawakoni lakes.",
    "createdAt": "2026-08-08T14:48:07.046Z",
    "updatedAt": "2026-08-15T19:18:38.682Z"
  },
  {
    "id": "cmrksejq3000gjt086ytzwm2j",
    "pwsid": "TX1010337",
    "name": "City of Houston Public Works",
    "city": "Houston",
    "state": "TX",
    "zipCodes": "77001,77002,77003,77004,77005,77006,77007,77008,77009,77010,77011,77012,77013,77014,77015,77016,77018,77019,77020,77021",
    "county": "Harris",
    "population": 2303000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 29.7604,
    "longitude": -95.3698,
    "website": "https://www.publicworks.houstontx.gov",
    "notes": "Sources: Lake Houston, Lake Conroe, Trinity River.",
    "createdAt": "2026-07-14T15:09:24.700Z",
    "updatedAt": "2026-08-15T19:18:38.452Z"
  },
  {
    "id": "cmrksejqy000mjt08dr2a3psg",
    "pwsid": "WA5376550",
    "name": "Seattle Public Utilities",
    "city": "Seattle",
    "state": "WA",
    "zipCodes": "98101,98102,98103,98104,98105,98106,98107,98108,98109,98112,98115,98116,98117,98118,98119,98121,98122,98125,98126,98133",
    "county": "King",
    "population": 753000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 47.6062,
    "longitude": -122.3321,
    "website": "https://www.seattle.gov/utilities",
    "notes": "Sources: Cedar River and Tolt River watersheds.",
    "createdAt": "2026-07-14T15:09:24.730Z",
    "updatedAt": "2026-08-15T19:18:38.550Z"
  },
  {
    "id": "cmskhngje0011l509vrwdjdn4",
    "pwsid": "WI1110000",
    "name": "Milwaukee Water Works",
    "city": "Milwaukee",
    "state": "WI",
    "zipCodes": "53201,53202,53203,53204,53205,53206,53207,53208,53209,53210,53211,53212,53213,53214,53215,53216,53217,53218,53219,53220",
    "county": "Milwaukee",
    "population": 600000,
    "systemType": "Community",
    "sourceType": "Surface",
    "treatmentStatus": "Treated",
    "latitude": 43.0389,
    "longitude": -87.9065,
    "website": "https://www.milwaukee.gov/water",
    "notes": "Source: Lake Michigan. Site of 1993 Cryptosporidium outbreak, largest waterborne disease outbreak in US history.",
    "createdAt": "2026-08-08T14:48:07.034Z",
    "updatedAt": "2026-08-15T19:18:38.633Z"
  }
]