Safe Drinking Water Information System (SDWIS) Federal Reporting Services (Jan. 1, 2010 to Dec. 31, 2017)
This dataset is made up of seven separate reports from the U.S. Environmental Protection Agency's (USEPA) Safe Drinking Water Information System (SDWIS). Site visits were queried using SDWIS to produce the seven summary reports, one for each year of data from January 1, 2010 to December 31, 2017. This date range was chosen to account for the effects of the Long Term 2 Enhanced Surface Water Treatment Rule (LT2ESWTR) and the Stage 2 Disinfectants and Disinfection Byproducts Rule (DBPR), both of which first became effective in 2009.
The information is stored in .csv tables with a record (row) for each sanitary survey, with columns containing water system identifiers (e.g., water system ID, name, state), survey dates, findings arranged by survey element, and a comment field. Each record contains survey findings in separate fields for each survey element, and more than 95% of the fields are populated. Citation information for this dataset can be found in Data.gov's References section.
Complete Metadata
| accessLevel | public |
|---|---|
| bureauCode |
[
"020:00"
]
|
| contactPoint |
{
"fn": "Austin Heinrich",
"hasEmail": "mailto:heinrich.austin@epa.gov"
}
|
| describedBy | https://pasteur.epa.gov/uploads/10.23719/1531733/documents/SDWA%20Data%20Download%20Summary%20and%20Data%20Element%20Dictionary%20_%20ECHO%20_%20US%20EPA.html |
| describedByType | text/html |
| description | This dataset is made up of seven separate reports from the U.S. Environmental Protection Agency's (USEPA) Safe Drinking Water Information System (SDWIS). Site visits were queried using SDWIS to produce the seven summary reports, one for each year of data from January 1, 2010 to December 31, 2017. This date range was chosen to account for the effects of the Long Term 2 Enhanced Surface Water Treatment Rule (LT2ESWTR) and the Stage 2 Disinfectants and Disinfection Byproducts Rule (DBPR), both of which first became effective in 2009. The information is stored in .csv tables with a record (row) for each sanitary survey, with columns containing water system identifiers (e.g., water system ID, name, state), survey dates, findings arranged by survey element, and a comment field. Each record contains survey findings in separate fields for each survey element, and more than 95% of the fields are populated. Citation information for this dataset can be found in Data.gov's References section. |
| distribution |
[
{
"title": "https://sdwis.epa.gov/ords/sfdw_pub/r/sfdw/sdwis_fed_reports_public/200",
"accessURL": "https://sdwis.epa.gov/ords/sfdw_pub/r/sfdw/sdwis_fed_reports_public/200"
},
{
"title": "water_system_site_visit_01.01.2010_12.31.2010.csv",
"mediaType": "text/csv",
"downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1531733/water_system_site_visit_01.01.2010_12.31.2010.csv"
},
{
"title": "water_system_site_visit_01.01.2011-12.31.2011.csv",
"mediaType": "text/csv",
"downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1531733/water_system_site_visit_01.01.2011-12.31.2011.csv"
},
{
"title": "water_system_site_visit_01.01.2012-12.31.2012.csv",
"mediaType": "text/csv",
"downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1531733/water_system_site_visit_01.01.2012-12.31.2012.csv"
},
{
"title": "water_system_site_visit_01.01.2013-12.31.2013.csv",
"mediaType": "text/csv",
"downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1531733/water_system_site_visit_01.01.2013-12.31.2013.csv"
},
{
"title": "water_system_site_visit_01.01.2014-12.31.2014.csv",
"mediaType": "text/csv",
"downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1531733/water_system_site_visit_01.01.2014-12.31.2014.csv"
},
{
"title": "water_system_site_visit_01.01.2015-12.31.2016.csv",
"mediaType": "text/csv",
"downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1531733/water_system_site_visit_01.01.2015-12.31.2016.csv"
},
{
"title": "water_system_site_visit_01.01.2017-12.31.2017.csv",
"mediaType": "text/csv",
"downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1531733/water_system_site_visit_01.01.2017-12.31.2017.csv"
}
]
|
| identifier | https://doi.org/10.23719/1531733 |
| keyword |
[
"Sanitary Survey",
"drinking water",
"drinking water quality",
"sdwis",
"water"
]
|
| license | https://pasteur.epa.gov/license/sciencehub-license.html |
| modified | 2022-06-01 |
| programCode |
[
"020:000"
]
|
| publisher |
{
"name": "U.S. Environmental Protection Agency",
"subOrganizationOf": {
"name": "U.S. Government"
}
}
|
| references |
[
"https://doi.org/10.1002/awwa.1920",
"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC11360428"
]
|
| rights |
null
|
| title | Safe Drinking Water Information System (SDWIS) Federal Reporting Services (Jan. 1, 2010 to Dec. 31, 2017) |
