Table 1.
For each state, we report the number of records in the raw database and the total # of records removed in the quality control step. The number of records removed for each of seven common issues is reported as well.
| State | # Raw Records | Total # Rights Removed | # Invalid Right ID | # Duplicates | # Invalid Flow/Volume | # Invalid Water Source | # Invalid Priority Date | # Invalid Basin | # Invalid Water Use |
|---|---|---|---|---|---|---|---|---|---|
| Idaho | 289704 | 82925 | 12093 | 70813 | 0 | 0 | 19 | 0 | 0 |
| Washington | 37328 | 12534 | 3 | 2960 | 0 | 0 | 8278 | 13 | 1280 |
| Oregon | 189155 | 114 | 0 | 0 | 0 | 0 | 114 | 0 | 0 |
| California | 359495 | 308922* | 0 | 49158 | 256818 | 5 | 0 | 1644 | 43 |
| Colorado | 187888 | 6480 | 0 | 6336 | 142 | 0 | 0 | 0 | 2 |
| Arizona - Well Registry | 212019 | 209802* | 207441 | 486 | 68 | 0 | 1807 | 0 | 0 |
| Arizona - Surface Water Claims | 215001 | 85535 | 0 | 65460 | 10151 | 0 | 8003 | 1109 | 812 |
| Arizona - Statement of Claimant | 125485 | 103438* | 0 | 0 | 99906 | 1465 | 2067 | 0 | 0 |
| Nevada | 28085 | 743* | 0 | 0 | 0 | 0 | 743 | 0 | 0 |
| Utah | 512904 | 44246** | 78 | 0 | 88 | 0 | 30580 | 0 | 13500 |
| New Mexico | 237427 | 79915 | 0 | 0 | 38 | 0 | 79877 | 0 | 0 |
| Montana | 2368941 | 2085423* | 0 | 1409079 | 181290 | 21 | 30715 | 0 | 464318 |
| Wyoming | 266796 | 73656* | 0 | 1911 | 45784 | 0 | 69 | 0 | 25892 |
*Records were added/copied when data was joined.
**There are known record duplicates with unique location coordinates.