[
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "18427",
  "facility_name": "TREATMENT PLANT #1",
  "state_facility_id": "TP01",
  "facility_activity_code": "I",
  "facility_deactivation_date": "1997-10-13 00:00:00",
  "facility_type_code": "TP",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "18819",
  "facility_name": "CC FROM DES MOINES WW, IA7727031",
  "state_facility_id": "CC01",
  "facility_activity_code": "I",
  "facility_deactivation_date": "2025-03-28 00:00:00",
  "facility_type_code": "CC",
  "submission_status_code": "Y",
  "is_source_ind": "Y",
  "water_type_code": "SW",
  "availability_code": "O",
  "seller_treatment_code": "F",
  "seller_pwsid": "IA7727031",
  "seller_pws_name": "DES MOINES WATER WORKS",
  "filtration_status_code": "FIL",
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": "N"
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "25163",
  "facility_name": "GENERAL PWS FACILITY",
  "state_facility_id": "OT01",
  "facility_activity_code": "A",
  "facility_deactivation_date": null,
  "facility_type_code": "OT",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "27388",
  "facility_name": "CC TO LIVING HISTORY 1900, IA7727988",
  "state_facility_id": "CC02",
  "facility_activity_code": "I",
  "facility_deactivation_date": "2002-10-22 00:00:00",
  "facility_type_code": "OT",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "27389",
  "facility_name": "CC TO LIVING HIST CONF CENTER, IA7727986",
  "state_facility_id": "CC03",
  "facility_activity_code": "I",
  "facility_deactivation_date": "2002-10-22 00:00:00",
  "facility_type_code": "OT",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "30601",
  "facility_name": "COMBINED DISTRIBUTION SYSTEM",
  "state_facility_id": "CDS0817",
  "facility_activity_code": "A",
  "facility_deactivation_date": null,
  "facility_type_code": "DS",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "33378",
  "facility_name": "ELEVATED STORAGE - 1 MG",
  "state_facility_id": "ST01",
  "facility_activity_code": "A",
  "facility_deactivation_date": null,
  "facility_type_code": "ST",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "33379",
  "facility_name": "ELEVATED STORAGE - 2 MG",
  "state_facility_id": "ST02",
  "facility_activity_code": "A",
  "facility_deactivation_date": null,
  "facility_type_code": "ST",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "35024",
  "facility_name": "BOOSTER PUMP 104TH AND DOUGLAS",
  "state_facility_id": "PF01",
  "facility_activity_code": "I",
  "facility_deactivation_date": "2018-12-04 00:00:00",
  "facility_type_code": "PF",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "3504",
  "facility_name": "DISTRIBUTION SYSTEM",
  "state_facility_id": "950",
  "facility_activity_code": "A",
  "facility_deactivation_date": null,
  "facility_type_code": "DS",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "35101",
  "facility_name": "PUMP STATION (TENNEY)",
  "state_facility_id": "PF02",
  "facility_activity_code": "A",
  "facility_deactivation_date": null,
  "facility_type_code": "PF",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "36122",
  "facility_name": "CC TO ROCKLYN MHP, IA7780601",
  "state_facility_id": "CC04",
  "facility_activity_code": "A",
  "facility_deactivation_date": null,
  "facility_type_code": "OT",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "36706",
  "facility_name": "URBANDALE BOOSTER",
  "state_facility_id": "PF03",
  "facility_activity_code": "A",
  "facility_deactivation_date": null,
  "facility_type_code": "PF",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "37018",
  "facility_name": "CC FROM CIWW(DMWW), IA7727033",
  "state_facility_id": "CC05",
  "facility_activity_code": "A",
  "facility_deactivation_date": null,
  "facility_type_code": "CC",
  "submission_status_code": "Y",
  "is_source_ind": "Y",
  "water_type_code": "SW",
  "availability_code": "P",
  "seller_treatment_code": "F",
  "seller_pwsid": "IA7727033",
  "seller_pws_name": "CIWW (DMWW)",
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
},
{
  "pwsid": "IA7780042",
  "primacy_agency_code": "IA",
  "epa_region": "07",
  "facility_id": "7077",
  "facility_name": "SS FROM DES MOINES WW, IA7727031",
  "state_facility_id": "01",
  "facility_activity_code": "I",
  "facility_deactivation_date": "2025-03-28 00:00:00",
  "facility_type_code": "SS",
  "submission_status_code": "Y",
  "is_source_ind": "N",
  "water_type_code": null,
  "availability_code": null,
  "seller_treatment_code": null,
  "seller_pwsid": null,
  "seller_pws_name": null,
  "filtration_status_code": null,
  "pws_activity_code": "A",
  "pws_deactivation_date": null,
  "pws_type_code": "CWS",
  "is_source_treated_ind": null
}
]