Skip to main content
U.S. flag

An official website of the United States government

Safe Drinking Water Information System (SDWIS) Federal Reports Advanced Search Tool

Published by U.S. EPA Office of Research and Development (ORD) | U.S. Environmental Protection Agency | Catalog Last Checked: April 21, 2026 at 07:57 PM | Dataset Last Updated: June 30, 2017
A database where EPA has compiled data on public drinking water systems and whether they have certain drinking water violations. This data is collected by the states and given to the EPA. This dataset is associated with the following publication: Pennino, M., J. Compton, and S. Leibowitz. Trends in Drinking Water Nitrate Violations Across the United States. ENVIRONMENTAL SCIENCE & TECHNOLOGY. American Chemical Society, Washington, DC, USA, 13450-13460, (2017).

Resources

12 resources available

  • https://ofmpub.epa.gov/apex/sfdw/f?p=108:9:::NO::P9_REPORT:VIO

    FILE
    Visit Page

  • Mean_Annual_NO3_Pop_Served_County_1994-2016_FINAL.csv

    APPLICATION/VND.MS-EXCEL
    Download

  • Mean_Annual_NO3_Violations_County_1994-2016_FINAL.csv

    APPLICATION/VND.MS-EXCEL
    Download

  • SDWIS_GW_NO3_Violations_County_1994-2016_FINAL.csv

    APPLICATION/VND.MS-EXCEL
    Download

  • SDWIS_NO3_Pop_Served_County_1994-2016_FINAL.csv

    APPLICATION/VND.MS-EXCEL
    Download

  • SDWIS_NO3_Violation_Duration_State_1994-2016_FINAL.csv

    APPLICATION/VND.MS-EXCEL
    Download

  • SDWIS_NO3_Violations_County_1994-2016_FINAL.csv

    APPLICATION/VND.MS-EXCEL
    Download

  • SDWIS_NO3_Violations_Over_Time_1994-2016_FINAL.csv

    APPLICATION/VND.MS-EXCEL
    Download

  • SDWIS_Percent_GWSW_Violations_County_1994-2016_FINAL.csv

    APPLICATION/VND.MS-EXCEL
    Download

  • SDWIS_Percent_GW_NO3_Violations_County_1994-2016_FINAL.csv

    APPLICATION/VND.MS-EXCEL
    Download

  • SDWIS_Percent_SW_NO3_Violations_County_1994-2016_FINAL.csv

    APPLICATION/VND.MS-EXCEL
    Download

  • SDWIS_SW_NO3_Violations_County_1994-2016_FINAL.csv

    APPLICATION/VND.MS-EXCEL
    Download

Find Related Datasets

Search by Tags

Click any tag below to search for similar datasets

Complete Metadata
@type dcat:Dataset
accessLevel public
bureauCode 
[
  "020:00"
]
contactPoint 
{
  "fn": "Michael Pennino",
  "hasEmail": "mailto:pennino.michael@epa.gov"
}
description A database where EPA has compiled data on public drinking water systems and whether they have certain drinking water violations. This data is collected by the states and given to the EPA. This dataset is associated with the following publication: Pennino, M., J. Compton, and S. Leibowitz. Trends in Drinking Water Nitrate Violations Across the United States. ENVIRONMENTAL SCIENCE & TECHNOLOGY. American Chemical Society, Washington, DC, USA, 13450-13460, (2017).
distribution 
[
  {
    "title": "https://ofmpub.epa.gov/apex/sfdw/f?p=108:9:::NO::P9_REPORT:VIO",
    "accessURL": "https://ofmpub.epa.gov/apex/sfdw/f?p=108:9:::NO::P9_REPORT:VIO"
  },
  {
    "title": "Mean_Annual_NO3_Pop_Served_County_1994-2016_FINAL.csv",
    "mediaType": "application/vnd.ms-excel",
    "downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1407575/Mean_Annual_NO3_Pop_Served_County_1994-2016_FINAL.csv"
  },
  {
    "title": "Mean_Annual_NO3_Violations_County_1994-2016_FINAL.csv",
    "mediaType": "application/vnd.ms-excel",
    "downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1407575/Mean_Annual_NO3_Violations_County_1994-2016_FINAL.csv"
  },
  {
    "title": "SDWIS_GW_NO3_Violations_County_1994-2016_FINAL.csv",
    "mediaType": "application/vnd.ms-excel",
    "downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1407575/SDWIS_GW_NO3_Violations_County_1994-2016_FINAL.csv"
  },
  {
    "title": "SDWIS_NO3_Pop_Served_County_1994-2016_FINAL.csv",
    "mediaType": "application/vnd.ms-excel",
    "downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1407575/SDWIS_NO3_Pop_Served_County_1994-2016_FINAL.csv"
  },
  {
    "title": "SDWIS_NO3_Violation_Duration_State_1994-2016_FINAL.csv",
    "mediaType": "application/vnd.ms-excel",
    "downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1407575/SDWIS_NO3_Violation_Duration_State_1994-2016_FINAL.csv"
  },
  {
    "title": "SDWIS_NO3_Violations_County_1994-2016_FINAL.csv",
    "mediaType": "application/vnd.ms-excel",
    "downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1407575/SDWIS_NO3_Violations_County_1994-2016_FINAL.csv"
  },
  {
    "title": "SDWIS_NO3_Violations_Over_Time_1994-2016_FINAL.csv",
    "mediaType": "application/vnd.ms-excel",
    "downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1407575/SDWIS_NO3_Violations_Over_Time_1994-2016_FINAL.csv"
  },
  {
    "title": "SDWIS_Percent_GWSW_Violations_County_1994-2016_FINAL.csv",
    "mediaType": "application/vnd.ms-excel",
    "downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1407575/SDWIS_Percent_GWSW_Violations_County_1994-2016_FINAL.csv"
  },
  {
    "title": "SDWIS_Percent_GW_NO3_Violations_County_1994-2016_FINAL.csv",
    "mediaType": "application/vnd.ms-excel",
    "downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1407575/SDWIS_Percent_GW_NO3_Violations_County_1994-2016_FINAL.csv"
  },
  {
    "title": "SDWIS_Percent_SW_NO3_Violations_County_1994-2016_FINAL.csv",
    "mediaType": "application/vnd.ms-excel",
    "downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1407575/SDWIS_Percent_SW_NO3_Violations_County_1994-2016_FINAL.csv"
  },
  {
    "title": "SDWIS_SW_NO3_Violations_County_1994-2016_FINAL.csv",
    "mediaType": "application/vnd.ms-excel",
    "downloadURL": "https://pasteur.epa.gov/uploads/10.23719/1407575/SDWIS_SW_NO3_Violations_County_1994-2016_FINAL.csv"
  }
]
identifier https://doi.org/10.23719/1407575
keyword 
[
  "Clean Water Act",
  "contaminants in water systems",
  "drinking water",
  "maximum contaminant level",
  "nitrate",
  "nitrate in groundwater",
  "public water systems",
  "surface water",
  "violation"
]
license https://pasteur.epa.gov/license/sciencehub-license.html
modified 2017-06-30
programCode 
[
  "020:096"
]
publisher 
{
  "name": "U.S. EPA Office of Research and Development (ORD)",
  "subOrganizationOf": {
    "name": "U.S. Environmental Protection Agency",
    "subOrganizationOf": {
      "name": "U.S. Government"
    }
  }
}
references 
[
  "https://doi.org/10.1021/acs.est.7b04269"
]
rights 
null
title Safe Drinking Water Information System (SDWIS) Federal Reports Advanced Search Tool

data.gov

An official website of the GSA's Technology Transformation Services

Looking for U.S. government information and services?
Visit USA.gov