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

SizeCat11 all

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_pt

FY Data a_MCL b_MRDL c_TT d_MR e_Other f_Total

2006 Viols 16,432 7 4,091 133,580 40,318 194,428

SysInViol 9,747 3 2,288 33,831 17,076 50,102PopInViol 18,624,638 46,344 16,833,806 56,256,258 24,292,412 89,375,580

2005 Viols 16,762 5 4,391 216,671 23,931 261,760

SysInViol 9,656 5 2,390 37,550 13,033 50,982PopInViol 20,122,529 424,969 17,130,742 66,443,843 23,909,388 96,487,846

2004 Viols 11,975 6 3,264 172,444 18,025 205,714

SysInViol 8,462 4 2,078 35,990 11,000 47,879PopInViol 15,898,377 3,617 16,770,458 54,653,220 18,155,414 83,480,002

2003 Viols 11,357 1 3,552 136,423 21,814 173,147

SysInViol 8,169 1 2,198 35,077 12,111 47,506PopInViol 16,891,410 2,250 17,149,658 53,407,776 13,152,308 86,070,297

2002 Viols 10,866 3,754 158,897 14,325 187,842

SysInViol 8,056 2,260 36,947 9,683 48,696

PopInViol 9,607,384 9,471,681 36,224,452 18,004,289 61,094,886

2001 Viols 11,085 3,866 135,124 13,227 163,302

SysInViol 7,849 2,343 38,634 9,670 49,599PopInViol 12,084,069 15,744,000 56,621,050 25,982,116 82,650,874

2000 Viols 10,405 4,196 110,378 11,759 136,738

SysInViol 7,718 2,439 36,974 9,762 48,078PopInViol 12,731,172 15,655,261 38,515,091 13,997,776 67,975,759

1999 Viols 11,833 2,697 120,446 1,910 136,886

SysInViol 8,155 1,375 32,770 1,213 38,782PopInViol 12,018,179 15,950,804 22,933,854 2,627,929 41,981,775

1998 Viols 12,863 2,969 108,599 4,028 128,459

SysInViol 8,490 1,298 29,927 2,171 36,452PopInViol 11,107,412 18,568,309 31,408,505 2,560,537 52,589,390

1997 Viols 12,561 3,324 125,215 3,424 144,524

SysInViol 8,776 1,335 33,069 1,940 39,903PopInViol 14,667,407 22,154,296 30,696,363 4,041,508 62,221,925

Reported violations by violation type

 FY 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 '98 FY 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_VOC

FY Data a_MCL d_MR

2006 Viols 69 32,992

SysInViol 31 1,080PopInViol 125,113 1,695,670

2005 Viols 50 57,450

SysInViol 34 2,348PopInViol 175,860 3,707,714

2004 Viols 98 44,024

SysInViol 56 1,843PopInViol 197,547 4,205,496

2003 Viols 78 30,047

SysInViol 53 1,294PopInViol 160,316 5,157,166

2002 Viols 61 38,771

SysInViol 50 1,792PopInViol 85,405 4,145,401

2001 Viols 74 28,530

SysInViol 52 1,261PopInViol 479,456 5,181,865

2000 Viols 66 26,341

SysInViol 44 1,050PopInViol 673,518 3,595,978

1999 Viols 68 27,053

SysInViol 43 1,171PopInViol 108,443 2,141,214

1998 Viols 80 22,068

SysInViol 46 968PopInViol 65,276 917,796

1997 Viols 123 23,622

SysInViol 79 994PopInViol 365,751 2,250,383

list 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 '98 FY 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/Rule

 FY 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)Viols FYCType_pt CName CCode 1998 1999 2000 2001 2002 2003 2004 2005 20a_TCR Coliform (Pre-TCR) 3000 1 1 2 1 27 5 2

Coliform (TCR) 3100 11,317 10,335 8,986 9,644 9,101 9,041 9,093 9,113 9,3

a_TCR Total 11,318 10,336 8,988 9,645 9,128 9,046 9,095 9,113 9,3

b1_SWTR Turbidity 0100 217 115 51 103 68 10 4 6 

b1_SWTR Total 217 115 51 103 68 10 4 6 

e_St1_DBP Bromate 1011 

2

Carbon, Total-Organic 2920 2 1

Chloramine 1006 3

Chlorine 0999 1 1 1

Chlorine dioxide 1008 5 3 

Chlorite 1009 1 7 

DBP Stage 1 0400 

12

Total Haloacetic Acids (HAA5) 2456 1 10 100 256 1,577 1,3

TTHM 2950 21 132 329 2,712 2,3

e_St1_DBP Total 31 1 235 593 4,317 3,6

g_TTHM_pre_St1 Bromodichloromethane 2943 2

Bromoform 2942 2Chloroform 2941 1 2

Dibromochloromethane 2944 2TTHM 2950 13 38 28 41 16 10 2 1

g_TTHM_pre_St1 Total 13 39 28 41 16 10 2 9

h_VOC 1,1,1-Trichloroethane 2981 3 1 2

1,1,2-Trichloroethane 2985 3 2 2 1

1,1-Dichloroethylene 2977 4 10 9 12 4 5 13 7 

1,2-Dichloroethane 2980 3 3 1 3 1 5 2 

1,2-Dichloropropane 2983 3Benzene 2990 7 1 1 3 4 7 2 4 

Carbon tetrachloride 2982 2 3 1 4 1 2 2 3 

cis-1,2-Dichloroethylene 2380 2 1 2 

Dichloromethane; methylene chloride 2964 5 9 4 7 7 7 14 6 

Ethylbenzene 2992 1 1Styrene 2996 1

Reported MCL & MRDL Viols, by Contaminant

 FY 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) abo 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  FY 2002 data from SDWIS FY02Q4, frozen Jan '03 (Chem M/Rs are from FY03Q1) list of fie 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) rememb 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 33 22 16 13 11 26 27 16 

Toluene 2991 1Trichloroethylene 2984 17 17 27 22 23 23 31 12 

Vinyl chloride 2976 2 3 7 7 4 2

Xylenes, Total 2955 

p-Dichlorobenzene 2969 

h_VOC Total 80 68 66 74 61 78 98 50 

I_SOC 1,2-Dibromo-3-chloropropane; DBCP 2931 2 1 1 1 

2,3,7,8-TCDD (Dioxin) 2063 1Alachlor; Lasso 2051 1Atrazine 2050 11 12 5 2 5 5 8 

Benzo(a)pyrene 2306 1Bis(2-ethylhexyl) phthalate 2298 2 1 2 1 1 Di(2-ethylhexyl) phthalate 2039 2 1 2 8 5 5 8 12 

Dinoseb 2041 

2

Ethylene dibromide (EDB) 2946 8 3 4 2 4 10 10 10 

gamma-BHC; Lindane 2010 1 3 1 1

Heptachlor epoxide 2067 1 1

Hexachlorobenzene; HCB 2274 2Pentachlorophenol 2326 1 2

Total Polychlorinated Biphenyls (PCB) 2383 2 1 1 1

Toxaphene 2020 2 1

Simazine 2037 

I_SOC Total 19 29 18 11 13 26 29 35 

j1_Nitrates Nitrate 1040 612 663 669 452 538 610 662 730 7

Nitrate-Nitrite 1038 60 127 130 61 54 151 201 204 1

Nitrite 1041 5 2 5 4 3 6 7 9 

j1_Nitrates Total 677 792 804 517 595 767 870 943 9

j2_Arsenic Arsenic 1005 14 24 14 27 36 29 72 96 4

j2_Arsenic Total 14 24 14 27 36 29 72 96 4

j3_Other_IOC Antimony, Total 1074 7 1 1 3 6 9 6 9 

Asbestos 1094 6 6 1 2 5 

Barium 1010 11 5 13 19 19 20 15 18 

Beryllium, Total 1075 1 2 3 6 1 5 12 

Cadmium 1015 3 1 1 6 8 7 11 6 

Chromium 1020 7 6 3 

Cyanide, Free 1024 2 1 1 2 2

Fluoride 1025 81 64 49 143 334 231 252 433 3

Mercury 1035 2 4 8 7 3 6 

Selenium 1045 17 30 8 7 17 17 15 20 

Thallium, Total 1085 6 9 1 7 17 7 5 8 

j3_Other_IOC Total 140 124 78 197 415 300 316 517 3

k_Rads Combined Radium (-226 & -228) 4010 196 195 225 252 275 515 514 707 6

Combined Uranium 4006 21 181 2

Gross Alpha, Excl. Radon & U 4000 125 109 121 192 168 119 82 236 3
k_Rads Gross Beta Particle Activity 4100 1 1 

k_Rads Total 321 304 347 444 443 634 618 1,124 1,2

Not_Regulated Aldicarb sulfone 2044 1

Alpha, Dissolved 4040 

3

Aluminum 1002 2 4 

Arsenic-73 4152 1 1

Bromide 1004 3Chloride 1017 3 2 13 13 34 73 

Chloromethane 2210 1 1 3 1 

Color 1905 1 1 2 1 3 

Combined Uranium 4006 2 1 1 2 1

Conductivity @ 25 C U-MHO 1064 1Copper 1022 6 1

Dichlorodifluoromethane 2212 1 1 Fecal Coliform 3013 1Giardia lamblia 3008 1Gross Alpha Particle Activity 4109 1 160 164 92 

Gross Alpha, Incl. Radon & U 4002 3 1 61 Hardness, Carbonate 1916 1Iron 1028 2 3 14 9 15 17 

Lead 1030 22 2 6 4 3 

Manganese 1032 1 1 1 3 5 7 16 

Maximum Total Trihalomethane Potential 2949 1Methyl-tert-Butyl-Ether (MTBE) 2251 1 2 3 9 12 

m-Xylene 2995 1Nickel 1036 4 3 3 2 3 4 4 

o-Xylene 2997 1Phenol 2331 6 3 Radium-226 4020 5 5 4 3 12 1 1 11 

Radium-228 4030 4 2 1 4 2 5 2 4 

Silver 1050 

1

Sodium 1052 2 7 29 226 

Sulfate 1055 5 1 1 4 4 4 

Total Dissolved Solids (TDS) 1930 

2

Odor 1920 pH 1925 Zinc 1095 Bromomethane 2214 

Not_Regulated Total 54 12 11 25 60 223 284 545 2
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-06Q
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 qrtrs. FY05Q4-06Q
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-06
VCode VName Vtype

1 MCL, Single Sample MCL2 MCL, Average MCL x3 Monitoring, Regular MR4 Monitoring, Check/Repeat/Confirmation MR5 Notification, State Other6 Notification, Public Other7 Treatment Techniques Other8 Variance/Exemption/Other Compliance Other9 Record Keeping Other FBR 0500 IESWTR 0300

10 Operations Report Other * codes in red are required for monitoring only11 Non-Acute MRDL MRDL DBP 0999, 1006/ 08

12 Treatment Technique No Certif. Operator TT DBP 0400

13 Acute MRDL MRDL DBP 1008

21 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 MR DBP 0400, 0999, 1006/ 08/ 09/ 11, 2456, 2920, 2950

28 Sanitary Survey (TCR) Other SS, TCR 310029 M&R Filter Profile/CPE Failure MR IESWTR 030031 Monitoring, Routine/Repeat (SWTR-Unfilt) MR36 Monitoring, Routine/Repeat (SWTR-Filter) MR37 Treatment Technique State Prior Approval TT x DBP 0400 last updated 9/2005

38 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 TT DBP 2920

47 Treatment Technique Uncovered Reservoir TT IESWTR 51 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) MR X

55 Follow-up & Routine Tap WQP M&R (deleted) MR X56 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) TT X61 SOWT Recommendation (deleted) TT X62 SOWT Installation (deleted) TT X63 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 Other

TCR 3100

SWTR 0200

CCR 7000

LCR 1022,1030LCR 5000LCR 5000PN 7500IESWTR 0300FBR 0500SWTR 0200IESWTR 0300

Applicable rules and contaminant codes (CCodes)

Nitrates 1038, 1040, 1041

Other IOC 1005/ 10/ 15/ 20/ 24/ 25/ 35/ 36*/ 45/ 74/ 75/ 85/ 94

Rads 4000/ 06/ 10, 4100/ 01/02/ 74

 Coliform (Pre-TCR) 3000

Other VOC 2378/ 80, 2955/ 64/ 68/ 69/ 76/ 77/ 79/ 80/ 81/ 82/ 83/ 84/ 85/ 87/ 89/ 90/ 91/ 92/ 96

SOC 2005/ 

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/ 59

DBP 1009, 1011, 2456, 2950

TTHM pre-'02 2941/ 42/ 43/ 44, 2950

Violations counted in a fiscal year have a compliance period overlapping some part of that year. That is, violations must have a start on or prior to the end of the fiscal year (sept 30th) and an end date on or after the beginning of the fiscal year (October 1st). FY2003 violations, for example, must have a compliance period begin date <= 09/30/2003 and a compliance period end date >=10/01/2002. Violations can cover more than one fiscal year.