# Pivot table:InventoryViolation typeRuleContaminantGPRAGPRA ST01--rules by 12/2001GPRA ST2--rules 01/2002+



# TotSys X X X X

TotPop X X X X

Viols XXXXXX

SysInViol X X X X X

PopInViol X X X X X

GPRA-%sys X X X

GPRA-%pop X X X



# Members:

I

II

III

IV

V

VI

VII

VIII

IX

X

State

Territory

Tribal

State

PCounty X X X X

CWS

NTNCWS

TNCWS

SW

GW

SW

SWP

GU

GUP

GW

GWP

F

S

L

M

N

P

?

a Very small

b Small

c Medium

d Large

e Very large

a <=100

b 101-500

c 501-1,000

d 1,001-3,300

e 3,301-10,000

f 10,001-50,000

g 50,001-100,000

h 100,001-250,000

i 250,001-500,000

j 500,001-1,000,000

k >1,000,000

FY X X X X X

XXX MCL

XXX MRDL

X X TT

X X M/R

X Other

X Total

a TCR

b1 SWTR

b2 I_LT1_IESWTR

e ST1_ DBP

g TTHM_pre-ST1

h VOC

i SOC

j1 Nitrates

j2 Arsenic

j3 Other_IOC

k Rads

l LCR

CName X Contaminant name

CCode X Contaminant number

PWSID XXX Water system ID#

PWSName X X X Water system name

Frozen database tables:

FY06Q1 was frozen in April 2006 SizeCat2

SizeCat5

all SizeCat11 a <10,000

b >=10,000

Maximum Residual Disinfectant Level 501-3,300

3,301-10,000

Violation type:

Maximum Contaminant Level violation PWSType % of systems not reporting any health-based violations (GPRA applies to CWSs only)

% of population served by systems not reporting any health-based violations (GPRA applies to CWSs only)



# Dimensions: Description of members:

all AK, ID, OR, WA

AS (Am. Samoa), GU (Guam), MP (N. Marianas Islands), PR (Puerto Rico), PW (Palau), VI (Virgin Islands)

NN (Navajo Nation) plus numeric states (01 to 10), which refer to tribal systems in that respective region. IA, KS, MO, NE

FY03Q4 was frozen in January 2004 Other violation, including public notice violation

All violations

Radionuclides Total Coliform Rule

Total Trihalomethanes, a Volatile Organic Chemical (VOC)

FY04Q1 was frozen in April 2004 Vtype

Synthetic Organic Chemicals Treatment Technique violation 

# Measures and dimensions included in the pivot tables Notice :

EPA is aware of inaccuracies and underreporting of some data in the Safe Drinking Water Information System.

We are working with the states to improve the quality of the data.



# Measures:

Number of current, active systems (or, # systems subject to a GPRA measure)

Population served by current, active systems (or, pop served by systems subject to a GPRA measure)

Primary County served by a water system # of violations reported

# of systems reporting violations

Population served by systems reporting violations

AR, LA, NM, OK, TX CT, ME, MA, NH, RI, VT

NJ, NY, PR (Puerto Rico), VI (Virgin Islands)

DE, DC, MD, PA, VA, WV

Private

not specified CO, MT, ND, SD, UT, WY

Federal government

Native American Numeric states (01 to 10) refer to tribal systems in that respective region. AZ, CA, HI, NV, AS (American Samoa), GU (Guam), MP (Northern Marianas Islands), PW (Palau), NN

(Navajo Nation)

includes SW, SWP, GU, GUP

includes GW and GWP EPA_Region

State government

Owner FL, FL, GA, KY, MS, NC, SC, TN

Community Water System

Non-Transient Non-Community Water System

Transient Non-Community Water System IL, IN, MI, MN, OH, WI

Local government

Mixed public/private

etc. Lead and Copper Rule

FY01Q1 will be frozen in early April 2001

FY00Q4 was frozen in early January 2001 FY02Q1 was frozen in early April 2002

FY01Q4 was frozen in January 2002 FY02Q4 was frozen in January 2003 FY03Q1 was frozen in April 2003 all

all all all all

FY04Q4 was frozen in January 2005 Ctype Interim Enhanced Surface Water Treatment Rule and the LT1 (future) Enhanced SWTR

X Other Volatile Organic Chemicals Stage 1 Disinfectants By-Product Rule

TTHM Rule violations, which was replaced by the ST1 DBP Rule Primary source of water:

surface water

purchased surface water

ground water under the influence of surface water

Contaminant type/Rule: FY1994 to FY2003 (GPRA from FY1993 on). A fiscal year (FY) runs from October 1st to September 30th. 10,001-100,000

>100,000

Size category, based on average daily population served:

FY05Q4 was frozen in January 2006 Nitrates

Other Inorganic Chemicals purchased ground water under the influence of surface water

ground water

purchased ground water

Size category, based on average daily population served:

Monitoring or reporting violation Size category, based on average daily population served:

25-500

FY05Q1 was frozen in April 2005 Geography

type all

X all

PSource Gw/sw

X

# EPA_Region (All)

Geography_type (All)

State (All)

PCounty (All)

GwSw (All)

PSource (All)

Owner (All)

SizeCat2 (All)

SizeCat3 (All)

SizeCat11 (All)

SizeCat5

PWSType Data 1_Very_Small 2_Small 3_Medium 4_Large 5_Very_Large Grand Total

CWS TotSys 29,456 14,099 4,746 3,659 389 52,349

TotPop 4,896,638 20,018,221 27,476,958 103,300,712 126,012,965 281,705,494

NTNCWS TotSys 16,260 2,661 108 19 19,048

TotPop 2,260,689 2,670,763 585,699 493,570 6,010,721

TNCWS TotSys 82,404 2,746 107 17 4 85,278

TotPop 7,261,320 2,692,470 580,359 454,222 2,994,000 13,982,371

Total TotSys 128,120 19,506 4,961 3,695 393 156,675

Total TotPop 14,418,647 25,381,454 28,643,016 104,248,504 129,006,965 301,698,586 list of fields:

remember: 

# FY2006 Inventory data

Active, current systems, from SDWIS 06Q3 frozen database



# about:

how to:about:EPA_Region (All)how to:Geography_type (All)list of fields:State (All)remember:PWSType (All)GwSw (All)PSource (All)SizeCat2 (All)SizeCat5 (All)SizeCat11 (All)VType_ptFY Data a_MCL b_MRDL c_TT d_MR e_Other f_Total2006 Viols 16,43274,091133,58040,318194,428SysInViol 9,74732,28833,83117,07650,102PopInViol 18,624,63846,34416,833,80656,256,25824,292,41289,375,5802005 Viols 16,76254,391216,67123,931261,760SysInViol 9,65652,39037,55013,03350,982PopInViol 20,122,529424,96917,130,74266,443,84323,909,38896,487,8462004 Viols 11,97563,264172,44418,025205,714SysInViol 8,46242,07835,99011,00047,879PopInViol 15,898,3773,61716,770,45854,653,22018,155,41483,480,0022003 Viols 11,35713,552136,42321,814173,147SysInViol 8,16912,19835,07712,11147,506PopInViol 16,891,4102,25017,149,65853,407,77613,152,30886,070,2972002 Viols 10,8663,754158,89714,325187,842SysInViol 8,0562,26036,9479,68348,696PopInViol 9,607,3849,471,68136,224,45218,004,28961,094,8862001 Viols 11,0853,866135,12413,227163,302SysInViol 7,8492,34338,6349,67049,599PopInViol 12,084,06915,744,00056,621,05025,982,11682,650,8742000 Viols 10,4054,196110,37811,759136,738SysInViol 7,7182,43936,9749,76248,078PopInViol 12,731,17215,655,26138,515,09113,997,77667,975,7591999 Viols 11,8332,697120,4461,910136,886SysInViol 8,1551,37532,7701,21338,782PopInViol 12,018,17915,950,80422,933,8542,627,92941,981,7751998 Viols 12,8632,969108,5994,028128,459SysInViol 8,4901,29829,9272,17136,452PopInViol 11,107,41218,568,30931,408,5052,560,53752,589,3901997 Viols 12,5613,324125,2153,424144,524SysInViol 8,7761,33533,0691,94039,903PopInViol 14,667,40722,154,29630,696,3634,041,50862,221,925Reported violations by violation typeFY 2005 data from SDWIS FY05Q4, frozen Jan '05 (Chem M/Rs are from FY06Q1)FY 2004 data from SDWIS FY04Q4, frozen Jan '04 (Chem M/Rs are from FY05Q1)FY 1999 data from SDWIS FY99Q4, frozen Jan '00 (Chem M/Rs are from FY00Q1)FY2006 data from SDWIS FY06Q3, frozen Oct '06 (4 qrtrs. FY05Q4-06Q3)FY 1998 data from SDWIS FY98Q4, frozen Jan '99 (Chem M/Rs are from FY99Q1)FY 1997 and earlier data from SDWIS FY98Q1, frozen Apr '98FY 2003 data from SDWIS FY03Q4, frozen Jan '04 (Chem M/Rs are from FY04Q1)FY 2002 data from SDWIS FY02Q4, frozen Jan '03 (Chem M/Rs are from FY03Q1)FY 2001 data from SDWIS FY01Q4, frozen Jan '02 (Chem M/Rs are from FY02Q1)FY 2000 data from SDWIS FY00Q4, frozen Jan '01 (Chem M/Rs are from FY01Q1)EPA_Region (All)Geography_type (All)State (All)PWSType (All)GwSw (All)PSource (All)SizeCat2 (All)SizeCat5 (All)SizeCat11 (All)CType_pt VType_pth_VOCFY Data a_MCL d_MR2006 Viols 6932,992SysInViol 311,080PopInViol 125,1131,695,6702005 Viols 5057,450SysInViol 342,348PopInViol 175,8603,707,7142004 Viols 9844,024SysInViol 561,843PopInViol 197,5474,205,4962003 Viols 7830,047SysInViol 531,294PopInViol 160,3165,157,1662002 Viols 6138,771SysInViol 501,792PopInViol 85,4054,145,4012001 Viols 7428,530SysInViol 521,261PopInViol 479,4565,181,8652000 Viols 6626,341SysInViol 441,050PopInViol 673,5183,595,9781999 Viols 6827,053SysInViol 431,171PopInViol 108,4432,141,2141998 Viols 8022,068SysInViol 46968PopInViol 65,276917,7961997 Viols 12323,622SysInViol 79994PopInViol 365,7512,250,383list of fields:how to:FY 1998 data from SDWIS FY98Q4, frozen Jan '99 (Chem M/Rs are from FY99Q1)FY 2002 data from SDWIS FY02Q4, frozen Jan '03 (Chem M/Rs are from FY03Q1)FY 2001 data from SDWIS FY01Q4, frozen Jan '02 (Chem M/Rs are from FY02Q1)FY 1997 and earlier data from SDWIS FY98Q1, frozen Apr '98FY 2000 data from SDWIS FY00Q4, frozen Jan '01 (Chem M/Rs are from FY01Q1)remember:FY 1999 data from SDWIS FY99Q4, frozen Jan '00 (Chem M/Rs are from FY00Q1)Reported violations by Contaminant type/RuleFY 2005 data from SDWIS FY05Q4, frozen Jan '06 (Chem M/Rs are from FY06Q1)FY 2004 data from SDWIS FY04Q4, frozen Jan '05 (Chem M/Rs are from FY05Q1)FY 2003 data from SDWIS FY03Q4, frozen Jan '04 (Chem M/Rs are from FY04Q1)about:FY2006 data from SDWIS FY06Q3, frozen Oct '06 (4 qrtrs. FY05Q4-06Q3)EPA_Region (All)Geography_type (All)State (All)PWSType (All)PSource (All)SizeCat2 (All)SizeCat5 (All)GwSw (All)SizeCat11 (All)ViolsFYCType_pt CName CCode 1998 1999 2000 2001 2002 2003 2004 2005 2006a_TCR Coliform (Pre-TCR) 3000 11212752Coliform (TCR) 3100 11,31710,3358,9869,6449,1019,0419,0939,1139,349a_TCR Total 11,31810,3368,9889,6459,1289,0469,0959,1139,349b1_SWTR Turbidity 0100 217115511036810462b1_SWTR Total 217115511036810462e_St1_DBP Bromate 101122Carbon, Total-Organic 2920 21Chloramine 10063Chlorine 0999 111Chlorine dioxide 1008 537Chlorite 1009 177DBP Stage 1 0400123Total Haloacetic Acids (HAA5) 2456 1101002561,5771,301TTHM 2950 211323292,7122,374e_St1_DBP Total1312355934,3173,694g_TTHM_pre_St1 Bromodichloromethane 29432Bromoform 29422Chloroform 2941 12Dibromochloromethane 29442TTHM 2950 13382841161021g_TTHM_pre_St1 Total 13392841161029h_VOC 1,1,1-Trichloroethane 2981 3121,1,2-Trichloroethane 2985 32211,1-Dichloroethylene 2977 4109124513761,2-Dichloroethane 2980 331315291,2-Dichloropropane 2983 3Benzene 2990 7113472412Carbon tetrachloride 2982 231412231cis-1,2-Dichloroethylene 2380 2121Dichloromethane; methylene chloride 2964 5947771468Ethylbenzene 2992 11Styrene 2996 1Reported MCL & MRDL Viols, by ContaminantFY 2005 data from SDWIS FY05Q4, frozen Jan '06 (Chem M/Rs are from FY06Q1)FY 2004 data from SDWIS FY04Q4, frozen Jan '05 (Chem M/Rs are from FY05Q1)about:FY2006 data from SDWIS FY06Q3, frozen Oct '06 (4 qrtrs. FY05Q4-06Q3)FY 2003 data from SDWIS FY03Q4, frozen Jan '04 (Chem M/Rs are from FY04Q1)how to:FY 2002 data from SDWIS FY02Q4, frozen Jan '03 (Chem M/Rs are from FY03Q1)list of fields:FY 1998 data from SDWIS FY98Q4, frozen Jan '99 (Chem M/Rs are from FY99Q1)FY 2001 data from SDWIS FY01Q4, frozen Jan '02 (Chem M/Rs are from FY02Q1)remember:FY 2000 data from SDWIS FY00Q4, frozen Jan '01 (Chem M/Rs are from FY01Q1)FY 1999 data from SDWIS FY99Q4, frozen Jan '00 (Chem M/Rs are from FY00Q1)h_VOC Tetrachloroethylene 2987 332216131126271610Toluene 2991 1Trichloroethylene 2984 171727222323311219Vinyl chloride 2976 237742Xylenes, Total 29552p-Dichlorobenzene 29691h_VOC Total 806866746178985069I_SOC 1,2-Dibromo-3-chloropropane; DBCP 2931 211142,3,7,8-TCDD (Dioxin) 2063 1Alachlor; Lasso 2051 1Atrazine 2050 11125255810Benzo(a)pyrene 2306 1Bis(2-ethylhexyl) phthalate 2298 212112Di(2-ethylhexyl) phthalate 2039 2128558123Dinoseb 204121Ethylene dibromide (EDB) 2946 834241010109gamma-BHC; Lindane 2010 1311Heptachlor epoxide 2067 11Hexachlorobenzene; HCB 2274 2Pentachlorophenol 2326 12Total Polychlorinated Biphenyls (PCB) 2383 2111Toxaphene 2020 21Simazine 20373I_SOC Total291918111326293532j1_Nitrates Nitrate 1040 612663669452538610662730739Nitrate-Nitrite 1038 601271306154151201204166Nitrite 1041 525436797j1_Nitrates Total 677792804517595767870943912j2_Arsenic Arsenic 1005 1424142736297296448j2_Arsenic Total 1424142736297296448j3_Other_IOC Antimony, Total 1074 711369696Asbestos 1094 661251Barium 1010 11513191920151822Beryllium, Total 1075 1236151212Cadmium 1015 3116871164Chromium 1020 7632Cyanide, Free 1024 21122Fluoride 1025 816449143334231252433322Mercury 1035 2487362Selenium 1045 1730871717152017Thallium, Total 1085 6917177589j3_Other_IOC Total 14012478197415300316517397k_Rads Combined Radium (-226 & -228) 4010 196195225252275515514707686Combined Uranium 4006 21181216Gross Alpha, Excl. Radon & U 4000 12510912119216811982236374k_Rads Gross Beta Particle Activity 4100 111k_Rads Total 3213043474444436346181,1241,277Not_Regulated Aldicarb sulfone 20441Alpha, Dissolved 404031Aluminum 1002 241Arsenic-73 4152 11Bromide 1004 3Chloride 1017 321313347354Chloromethane 2210 11311Color 1905 112137Combined Uranium 4006 21121Conductivity @ 25 C U-MHO 1064 1Copper 1022 61Dichlorodifluoromethane 2212 112Fecal Coliform 3013 1Giardia lamblia 3008 1Gross Alpha Particle Activity 4109 11601649223Gross Alpha, Incl. Radon & U 4002 31618Hardness, Carbonate 19161Iron 1028 23149151715Lead 1030 2226432Manganese 1032 1113571627Maximum Total Trihalomethane Potential 2949 1Methyl-tert-Butyl-Ether (MTBE) 2251 1239126m-Xylene 2995 1Nickel 1036 43323441o-Xylene 2997 1Phenol 2331 632Radium-226 4020 554312111118Radium-228 4030 4214252410Silver 105011Sodium 1052 272922649Sulfate 1055 5114447Total Dissolved Solids (TDS) 1930216Odor 19203pH 19253Zinc 10951Bromomethane 22141Not_Regulated Total 5412112560223284545259

# Geography_type (All)

State (All)

PCounty (All)

PWSType CWS

GwSw (All)

PSource (All)

SizeCat2 (All)

SizeCat5 (All)

SizeCat11 (All)

EPA_Region

Data FY 01 02 03 04 05 06

GPRA-pop 2006 92.1% 61.0% 93.0% 92.9% 92.2% 87.6%

2005 92.5% 55.3% 93.2% 93.0% 94.1% 87.8%

2004 93.3% 80.2% 84.6% 93.4% 95.6% 92.3%

2003 88.8% 54.1% 95.1% 92.7% 95.0% 92.9%

2002 88.2% 81.3% 97.5% 96.1% 94.0% 93.3%

2001 64.8% 76.5% 97.6% 95.1% 92.5% 95.9%

2000 61.6% 75.6% 96.7% 95.4% 94.7% 96.2%

1999 75.5% 60.9% 97.8% 95.0% 94.7% 95.3%

1998 64.2% 59.6% 96.8% 95.1% 95.3% 94.9%

1997 62.0% 54.7% 96.6% 92.6% 92.0% 92.7%

1996 59.8% 53.0% 92.0% 93.1% 92.5% 94.1%

1995 57.4% 52.4% 91.4% 92.3% 91.5% 88.5%

1994 57.0% 54.6% 86.6% 90.0% 87.6% 86.6%

1993 60.0% 56.4% 85.3% 89.9% 76.6% 91.9%

GPRA-sys 2006 84.3% 87.9% 90.9% 90.9% 90.9% 87.8%

2005 85.7% 86.4% 91.8% 91.0% 92.0% 86.2%

2004 87.0% 89.1% 92.1% 93.7% 93.1% 91.2%

2003 85.9% 88.6% 92.5% 93.1% 93.8% 92.8%

2002 85.5% 89.2% 92.2% 93.8% 92.9% 93.0%

2001 86.7% 88.3% 92.0% 93.8% 91.1% 94.5%

2000 82.7% 89.5% 92.1% 94.8% 91.9% 93.6%

1999 91.1% 87.1% 93.8% 95.9% 93.2% 92.9%

1998 88.9% 86.6% 94.9% 95.4% 92.1% 92.2%

1997 87.1% 88.8% 94.8% 94.8% 91.4% 91.9%

1996 83.3% 86.5% 92.1% 94.3% 90.2% 91.0%

1995 82.7% 85.0% 90.2% 92.4% 88.4% 89.5%

1994 79.4% 83.8% 89.2% 90.6% 87.2% 88.8%

1993 82.4% 83.2% 88.2% 91.7% 88.0% 90.1% 

# Reported health-based violations of drinking

water standards (GPRA)

GPRA applies to CWSs only

FY 2005 data from SDWIS FY05Q4, frozen Jan '06 FY2006 data from SDWIS FY06Q3, frozen Oct '06 (4 qrtrs. FY05Q4-06Q3)

FY 2004 data from SDWIS FY04Q4, frozen Jan '05

FY 2003 data from SDWIS FY03Q4, frozen Jan '04

FY 2002 data from SDWIS FY02Q4, frozen Jan '03

FY 2001 data from SDWIS FY01Q4, frozen Jan '02



# double-click any data cell for PWS information FY 2000 data from SDWIS FY00Q4, frozen Jan '01

FY 1999 data from SDWIS FY99Q4, frozen Jan '00

FY 1998 data from SDWIS FY98Q4, frozen Jan '99

FY 1997 and earlier data from SDWIS FY98Q1, frozen Apr '98

# 07 08 09 10 Grand Total

91.3% 95.7% 98.0% 95.1% 89.4%

91.2% 94.7% 94.6% 94.8% 88.5%

91.5% 91.9% 85.6% 93.4% 90.0%

92.6% 92.5% 98.1% 93.3% 89.6%

94.6% 97.0% 98.7% 91.1% 93.6%

89.7% 94.3% 97.2% 82.9% 90.8%

94.5% 93.6% 94.2% 82.7% 90.7%

94.9% 93.5% 97.0% 93.7% 90.5%

93.8% 92.9% 95.0% 89.1% 89.0%

95.2% 90.7% 94.6% 74.3% 86.5%

94.8% 92.5% 91.2% 74.0% 85.6%

94.5% 89.7% 88.5% 74.8% 83.8%

93.8% 91.0% 89.6% 86.9% 83.0%

92.9% 92.2% 69.4% 84.9% 78.8%

87.8% 90.2% 91.0% 87.3% 89.3%

86.8% 90.3% 91.6% 86.7% 89.2%

88.5% 91.4% 92.1% 87.2% 91.1%

88.6% 92.0% 95.3% 88.4% 91.8%

86.7% 92.2% 95.3% 87.2% 91.6%

87.0% 92.4% 94.1% 87.2% 91.5%

88.2% 92.5% 94.0% 85.3% 91.5%

87.1% 92.0% 94.8% 87.2% 92.3%

86.3% 90.7% 94.4% 84.8% 91.5%

90.3% 91.5% 93.6% 85.1% 91.6%

90.6% 91.0% 90.4% 82.4% 90.1%

89.2% 89.2% 89.9% 84.5% 88.8%

87.6% 88.6% 90.7% 82.9% 87.7%

87.7% 91.9% 84.7% 80.4% 87.6% about:

how to:

list of fields:

remember:

# EPA_Region (All)

Geography_type (All)

State (All)

PCounty (All)

PWSType CWS

GwSw (All)

PSource (All)

SizeCat2 (All)

SizeCat5 (All)

SizeCat11 (All)

Data

FY Viols SysInViol PopInViol TotSys TotPop GPRA-sys GPRA-pop

2006 11,873 5,611 29,827,523 52,349 281,705,494 89.3% 89.4%

2005 12,400 5,688 32,485,318 52,567 281,534,627 89.2% 88.5%

2004 7,514 4,677 27,313,861 52,838 272,495,677 91.1% 90.0%

2003 6,988 4,369 28,509,972 53,363 273,329,400 91.8% 89.6%

2002 7,066 4,503 17,173,463 53,437 267,722,666 91.6% 93.6%

2001 7,702 4,587 24,225,395 53,783 264,145,129 91.5% 90.8%

2000 7,801 4,622 24,644,944 54,072 263,940,363 91.5% 90.7%

1999 7,687 4,164 23,990,648 53,923 253,795,933 92.3% 90.5%

1998 8,796 4,613 27,722,323 54,367 252,530,574 91.5% 89.0%

1997 8,470 4,594 33,580,356 54,684 248,932,198 91.6% 86.5%

1996 10,310 5,436 35,824,645 54,684 248,932,198 90.1% 85.6%

1995 10,742 6,101 40,234,895 54,684 248,932,198 88.8% 83.8%

1994 12,490 6,742 42,307,428 54,684 248,932,198 87.7% 83.0%

1993 11,613 6,778 52,703,036 54,684 248,932,198 87.6% 78.8% 

# double-click any data cell for PWS information FY 2000 data from SDWIS FY00Q4, frozen Jan '01

FY 1999 data from SDWIS FY99Q4, frozen Jan '00

FY 1998 data from SDWIS FY98Q4, frozen Jan '99

FY 1997 and earlier data from SDWIS FY98Q1, frozen Apr '98 FY 2002 data from SDWIS FY02Q4, frozen Jan '03 

# list of fields:

FY 2001 data from SDWIS FY01Q4, frozen Jan '02 

# remember: FY 2004 data from SDWIS FY04Q4, frozen Jan '05 

# about:

FY 2003 data from SDWIS FY03Q4, frozen Jan '04 

# how to: 

# Reported health-based violations of drinking

water standards (GPRA)

GPRA applies to CWSs only

FY 2005 data from SDWIS FY05Q4, frozen Jan '06 FY2006 data from SDWIS FY06Q3, frozen Oct '06 (4 qrtrs. FY05Q4-06 Q

# EPA_Region (All)

Geography_type (All)

State (All)

PCounty (All)

PWSType CWS

GwSw (All)

PSource (All)

SizeCat2 (All)

SizeCat5 (All)

SizeCat11 (All)

Data

FY Viols SysInViol PopInViol TotSys TotPop GPRA-sys GPRA-pop

2006 7,500 4,365 23,838,363 52,349 281,705,494 91.7% 91.5%

2005 7,312 4,372 25,380,920 52,567 281,534,627 91.7% 91.0%

2004 6,670 4,333 21,374,967 52,838 272,495,677 91.8% 92.2%

2003 6,506 4,237 24,702,849 53,363 273,329,400 92.1% 91.0%

2002 7,035 4,486 16,919,997 53,437 267,722,666 91.6% 93.7% FY 1999 data from SDWIS FY99Q4, frozen Jan '00

FY 1998 data from SDWIS FY98Q4, frozen Jan '99

FY 1997 and earlier data from SDWIS FY98Q1, frozen Apr '98



# double-click any data cell for PWS information FY 2001 data from SDWIS FY01Q4, frozen Jan '02 

# list of fields:

FY 2000 data from SDWIS FY00Q4, frozen Jan '01 

# remember: FY 2004 data from SDWIS FY04Q4, frozen Jan '05 

# about:

FY 2003 data from SDWIS FY03Q4, frozen Jan '04 

# how to: 

# GPRA Strategic Targets 01: Reported health-based violations

of drinking water standards in place by 12/2001

GPRA applies to CWSs only

FY 2005 data from SDWIS FY05Q4, frozen Jan '06 FY2006 data from SDWIS FY06Q3, frozen Oct '06 ( 4 q rtrs. FY05Q4-06 Q

# EPA_Region (All)

Geography_type (All)

State (All)

PCounty (All)

PWSType CWS

GwSw (All)

PSource (All)

SizeCat2 (All)

SizeCat5 (All)

SizeCat11 (All)

Data

FY Viols SysInViol PopInViol TotSys TotPop GPRA-sys GPRA-pop

2006 4,373 1,407 8,595,814 52,349 281,705,494 97.3% 96.9%

2005 5,088 1,471 10,465,650 52,567 281,534,627 97.2% 96.3%

2004 844 417 9,324,354 52,838 272,495,677 99.2% 96.6%

2003 482 166 7,228,267 2,406 168,188,253 93.1% 95.7% * Disinfection By-Products (DBP) Rule for CWSs that disinfect



# double-click any data cell for PWS information Applicable rules in FY2004: 

# list of fields:

* Interim Enhanced Surface Water Treatment Rule 

# remember: FY 2004 data from SDWIS FY04Q4, frozen Jan '05 

# about:

FY 2003 data from SDWIS FY03Q4, frozen Jan '04 

# how to: 

# GPRA Strategic Targets 02: Reported health-based violations

of drinking water standards in place after 2001

GPRA applies to CWSs only

FY 2005 data from SDWIS FY05Q4, frozen Jan '06 FY2006 data from SDWIS FY06Q3, frozen Oct '06 (4 qrtrs. FY05Q4-0 6VCode VName Vtype1 MCL, Single Sample MCL2 MCL, Average MCLx3 Monitoring, Regular MR4 Monitoring, Check/Repeat/Confirmation MR5 Notification, State Other6 Notification, Public Other7 Treatment Techniques Other8 Variance/Exemption/Other Compliance Other9 Record Keeping OtherFBR0500IESWTR030010 Operations Report Other* codes in red are required for monitoring only11 Non-Acute MRDL MRDLDBP0999, 1006/ 0812 Treatment Technique No Certif. Operator TTDBP040013 Acute MRDL MRDLDBP100821 MCL, Acute (TCR) MCL22 MCL, Monthly (TCR) MCL23 Monitoring, Routine Major (TCR) MR24 Monitoring, Routine Minor (TCR) MR25 Monitoring, Repeat Major (TCR) MR26 Monitoring, Repeat Minor (TCR) MR27 Monitoring and Reporting Stage 1 MRDBP0400, 0999, 1006/ 08/ 09/ 11, 2456, 2920, 295028 Sanitary Survey (TCR) OtherSS, TCR310029 M&R Filter Profile/CPE Failure MRIESWTR030031 Monitoring, Routine/Repeat (SWTR-Unfilt) MR36 Monitoring, Routine/Repeat (SWTR-Filter) MR37 Treatment Technique State Prior Approval TTxDBP0400last updated 9/200538 M&R Filter Turbidity Reporting MR39 M&R (FBRR) MR40 Treatment Technique (FBRR) TT41 Treatment Technique (SWTR) TT42 Failure to Filter (SWTR) TT43 Treatment Technique Exceeds Turb 1 NTU TT44 Treatment Technique Exceeds Turb 0.3 NTU TT46 Treatment Technique Precursor Removal TTDBP292047 Treatment Technique Uncovered Reservoir TTIESWTR51 Initial Tap Sampling for Pb and Cu MR52 Follow-up and Routine Tap Sampling MR53 Initial Water Quality Parameter WQP M&R MR54 Follow-up & Routine E.P. WQP M&R (deleted)MRX55 Follow-up & Routine Tap WQP M&R (deleted) MRX56 Initial, Follow-up, or Routine SOWT M&R MR57 OCCT Study Recommendation TT58 OCCT Installation/Demonstration TT59 WQP Entry Point Non-Compliance TT60 WQP Entry Point Non-Compliance (deleted) TTX61 SOWT Recommendation (deleted) TTX62 SOWT Installation (deleted) TTX63 MPL Non-Compliance TT64 Lead Service Line Replacement (LSLR) TT65 Public Education TT71 CCR Complete Failure to Report Other72 CCR INADEQUATE REPORTING Other75 PN Violation for NPDWR Violation Other76 Other Non-NPDWR Potential Health Risks OtherTCR3100SWTR0200CCR7000LCR1022,1030LCR5000LCR5000PN7500IESWTR0300FBR0500SWTR0200IESWTR0300Applicable rules and contaminant codes (CCodes)Nitrates1038,1040,1041Other IOC1005/ 10/ 15/20/ 24/ 25/ 35/36*/ 45/ 74/ 75/85/ 94Rads4000/ 06/10, 4100/01/02/74Coliform(Pre-TCR)3000Other VOC2378/ 80,2955/ 64/ 68/69/ 76/ 77/79/ 80/ 81/82/ 83/ 84/85/ 87/ 89/90/ 91/ 92/ 96SOC2005/10/ 15/ 20/31/ 32/ 33/34/ 35/ 36/37/ 39/ 40/41/ 42/43*/44*/ 46/47*/50/ 51/ 63/65/ 67,2105/ 10,2274/ 98,2306/ 26/83/ 88/ 90/92/ 94/ 96/98, 2400,2931/ 46/ 59DBP1009,1011, 2456,2950TTHMpre-'022941/ 42/ 43/44, 2950Violations counted in a fiscal year have acompliance period overlapping some partof that year. That is, violations must havea start on or prior to the end of the fiscalyear (sept 30th) and an end date on orafter the beginning of the fiscal year(October 1st). FY2003 violations, forexample, must have a compliance periodbegin date <= 09/30/2003 and acompliance period end date>=10/01/2002. Violations can cover morethan one fiscal year.