DrillerDB Data & Research
DrillerDB maintains a compiled database of 18,029,601 North American water-well records, drawn from public well-completion and well-log records. Coverage spans all 50 U.S. states and 6 Canadian provinces (Ontario, Alberta, Quebec, Saskatchewan, British Columbia, and New Brunswick). Each record is normalized to one common schema, geocoded, and linked back to the source document it came from. This page documents what the dataset contains, how it is sourced, and how to cite it. The record count was verified against the database on July 2, 2026.
The corpus holds 18,029,601 water-well records spanning 50 U.S. states and 6 Canadian provinces. Every record carries the fields listed in the next section where the source log reported them: location, well construction, geology, and provenance. Coverage is uneven by jurisdiction because it tracks what each state or provincial agency has published and digitized, not the number of wells that physically exist.
Record counts per U.S. state, figures as of 2026-07-02 and recomputed quarterly. These counts total 16,108,916 records on file across the 50 U.S. states. Canadian province counts are listed separately below.
| Rank | State | Records on file |
|---|---|---|
| 1 | Florida | 1,839,284 |
| 2 | Michigan | 1,170,091 |
| 3 | Washington | 1,165,043 |
| 4 | California | 1,050,979 |
| 5 | Ohio | 872,000 |
| 6 | Wisconsin | 870,761 |
| 7 | Texas | 704,394 |
| 8 | Colorado | 656,114 |
| 9 | Oregon | 594,331 |
| 10 | Iowa | 487,059 |
| 11 | Maryland | 466,819 |
| 12 | Pennsylvania | 417,259 |
| 13 | Indiana | 414,953 |
| 14 | Minnesota | 404,063 |
| 15 | Illinois | 390,473 |
| 16 | Kansas | 313,236 |
| 17 | Montana | 295,732 |
| 18 | New Mexico | 277,209 |
| 19 | Nebraska | 266,626 |
| 20 | Oklahoma | 243,801 |
| 21 | Arizona | 240,008 |
| 22 | Louisiana | 218,702 |
| 23 | Wyoming | 214,104 |
| 24 | Idaho | 207,834 |
| 25 | Missouri | 194,670 |
| 26 | Mississippi | 181,279 |
| 27 | Tennessee | 175,053 |
| 28 | Delaware | 173,502 |
| 29 | Nevada | 144,782 |
| 30 | New York | 144,498 |
| 31 | Massachusetts | 127,011 |
| 32 | Vermont | 120,070 |
| 33 | North Carolina | 117,857 |
| 34 | New Hampshire | 111,532 |
| 35 | North Dakota | 110,136 |
| 36 | Kentucky | 105,714 |
| 37 | New Jersey | 104,999 |
| 38 | Arkansas | 96,044 |
| 39 | Maine | 94,685 |
| 40 | Utah | 91,223 |
| 41 | South Dakota | 78,246 |
| 42 | Alaska | 40,601 |
| 43 | Alabama | 38,408 |
| 44 | Virginia | 19,937 |
| 45 | Georgia | 15,591 |
| 46 | South Carolina | 14,146 |
| 47 | West Virginia | 12,810 |
| 48 | Connecticut | 7,926 |
| 49 | Hawaii | 5,300 |
| 50 | Rhode Island | 2,021 |
| Records on file by state (50 states) | 16,108,916 |
Record counts for the 6 Canadian provinces in the dataset, verified live against the database on July 2, 2026.
| Rank | Province | Records on file |
|---|---|---|
| 1 | Ontario | 936,820 |
| 2 | Alberta | 351,000 |
| 3 | Quebec | 262,101 |
| 4 | Saskatchewan | 146,529 |
| 5 | British Columbia | 130,369 |
| 6 | New Brunswick | 51,877 |
| Records on file across provinces (6 provinces) | 1,878,696 |
The dataset holds 18,029,601 North American records (verified July 2, 2026): 16,108,916 across the 50 U.S. states and 1,878,696 across the 6 Canadian provinces. The remaining 41,989 records are a Montana oil-and-gas source code that is excluded from the water-well per-state figures. Per-state U.S. figures are recomputed quarterly (most recently 2026-07-02).
Each record follows one common schema. Not every source log fills every field, so a given record carries the values its originating document reported. The fields group into four categories:
The records are compiled from public well-completion and well-log records published by state and provincial water-resource agencies and geological surveys. Licensed drillers file these reports with the state or province after a well is completed, and those agencies publish them as public records. DrillerDB collects those published records; it does not generate the underlying measurements.
Every record retains the URL of the originating source document, so any single value can be traced back to the record it came from. Records from different states and provinces arrive in different formats and field names, so each one is normalized to a single common schema and geocoded to latitude and longitude. Where a source log leaves a field blank, that field stays empty in the record rather than being estimated.
Per-state U.S. statistics, including the coverage counts in the U.S. table above, are recomputed quarterly or after a major state ingest. The most recent recompute was 2026-07-02. When a state's sub-district source codes exist, they are summed into a single state total during that step, which is why the per-state counts are labeled as records on file by state rather than a live total. The Canadian province counts were verified live on July 2, 2026.
Provenance: public state and provincial well-completion and well-log records.
Processing: normalized to one common schema and geocoded; source URL retained per record.
Refresh cadence: quarterly, or after a major state ingest. Last statistics recompute: 2026-07-02.
This dataset reflects what public agencies have published, not a complete inventory of every well ever drilled. Before citing a figure, understand what it does and does not capture:
If you reference these records in an article, report, or extension publication, the citation below is ready to copy. Replace the access month and year with the date you retrieved the data.
DrillerDB. (2026). Well Records Database [data set]. Retrieved July 2026 from https://drillerdb.com/data
DrillerDB well records database, drillerdb.com/data
When you cite a specific figure, such as a state record count, note the date you accessed it. The counts change as new state records are ingested. The canonical URL for this dataset is drillerdb.com/data.
Three free tools let you inspect the underlying records directly, so you can verify a figure before you cite it rather than taking a summary on trust.
Visual, nationwide exploration of the records. Search an area and open individual wells to see their depth, construction, and source log.
Enter an address to get the static water level and typical well depth computed from nearby recorded wells.
Look up a specific well by address and open its full record, including the link to the originating source document.
Public health departments, state ground-water associations, and extension programs are welcome to use the free tools above in their own resident-education and outreach work. The Water Table Depth lookup and Well Map answer the questions residents most often bring to a county office, and they can be linked directly from your own pages.
For well-owner outreach that needs a licensed professional, the DrillerDB directory lists verified water-well contractors in all 50 states, which you can point residents to when a well needs service or a record needs interpretation. Browse it at drillerdb.com/find-drillers.
For questions about the methodology, a citation, or access to data beyond what is published on this page, email the DrillerDB research team. Tell us what you are working on and what you need, and we will follow up.
Email research@drillerdb.comSubject line: Research or data inquiry. We read every message and reply to genuine research and citation inquiries.
For bulk data, research extracts, or commercial licensing, see our Data licensing page.
