Datasets
Coverage by state, measured from the lakehouse.
Every number here comes from a query against our silver views on 2026-10-07. A state not listed has no rows in that view, or fewer than 5.
- Measured
- 2026-10-07
- Census run
- 2026-10-07 07:34 UTC
- Level
- State only
- Floor
- cells under 5 not shown
The five datasets
Wells
Well headers: API number, operator, location, depths, spud, completion and status.
5,408,445 rows38 states and 2 federal offshore areaslatest spud 2026-09-30
Drilling permits
Permits to drill: permit number, operator, target, depth, approval and expiry dates.
2,551,504 rows32 states and 1 federal offshore arealatest approval 2026-10-02
Pooled units
Unit name, acres, operator, unit type and the API number of a unit well.
294,984 units10 statesview last built 2026-07-18
Production headers and the well join
Cumulative and latest oil, gas and water by producing entity, joined to wells on API10. Month-by-month volumes are not in this view; ask and we say what we hold.
3,652,452 headers31 states and 2 federal offshore areaslatest month 2026-05
Texas county clerk index
Recorded instrument index: type, file date, book and page, parties, legal description.
93,880,858 rowsTexas, 144 countieslatest file date 2026-10-01
Rows by state
"Wells with a header" is the share of distinct API10 well numbers in a state that match at least one production header. "none" means the view holds no rows there.
| State or area | Wells | Permits | Units | Production headers | Wells with a header | County index |
|---|---|---|---|---|---|---|
| Texas | 1,711,187 | 778,156 | 227,378 | 1,181,166 | 49.5% | 93,880,858 |
| Oklahoma | 529,577 | 103,256 | none | 420,816 | 75.3% | none |
| Kansas | 469,259 | 188,956 | none | 98,339 | 29.2% | none |
| Ohio | 274,734 | 41,024 | 4,465 | 212,393 | 77.0% | none |
| Pennsylvania | 273,600 | 211,876 | 8,263 | 157,927 | 57.7% | none |
| California | 253,854 | 65,228 | none | 242,880 | 80.2% | none |
| Louisiana | 245,192 | 204,940 | 4,359 | 250,588 | 82.5% | none |
| Wyoming | 199,867 | 208,679 | 5,243 | 167,999 | 73.7% | none |
| West Virginia | 181,016 | 135,890 | 3,017 | 113,567 | 66.8% | none |
| Illinois | 173,255 | 107,975 | none | none | none | none |
| New Mexico | 163,576 | 123,913 | 14,109 | 170,275 | 79.0% | none |
| Colorado | 146,940 | 152,539 | 12,089 | 108,682 | 69.2% | none |
| Kentucky | 144,617 | 7,333 | none | 134,543 | 64.0% | none |
| Michigan | 118,448 | 2,021 | none | 16,432 | 27.0% | none |
| Federal offshore, Gulf | 84,530 | 13,059 | none | 82,054 | 74.3% | none |
| Indiana | 61,400 | 525 | none | none | none | none |
| Montana | 50,712 | 37,651 | 781 | 39,728 | 70.6% | none |
| North Dakota | 49,965 | 27,223 | 15,280 | 34,895 | 74.2% | none |
| Arkansas | 49,877 | 13,842 | none | 42,615 | 77.4% | none |
| New York | 45,897 | 15,446 | none | 34,494 | 73.0% | none |
| Utah | 40,579 | 39,191 | none | 32,892 | 75.0% | none |
| Mississippi | 35,749 | 4,144 | none | 30,460 | 75.1% | none |
| Nebraska | 22,369 | 2,172 | none | 19,846 | 80.6% | none |
| Alabama | 19,239 | 16,054 | none | 15,378 | 74.5% | none |
| Tennessee | 15,695 | 14,764 | none | 13,628 | 75.6% | none |
| Virginia | 13,946 | 13,256 | none | 11,556 | 67.2% | none |
| Missouri | 12,357 | 7,505 | none | 2,631 | 85.0% | none |
| Alaska | 11,030 | 10,368 | none | 10,447 | 84.1% | none |
| South Dakota | 2,129 | 1,774 | none | 1,602 | 70.2% | none |
| Nevada | 1,592 | 828 | none | 732 | 36.0% | none |
| Arizona | 1,506 | 303 | none | 895 | 56.7% | none |
| Federal offshore, Pacific | 1,338 | none | none | 1,531 | 54.4% | none |
| Florida | 1,325 | 1,278 | none | 1,079 | 75.1% | none |
| Washington | 866 | none | none | none | none | none |
| Oregon | 713 | 330 | none | 270 | 32.0% | none |
| Maryland | 150 | none | none | 112 | 74.7% | none |
| North Carolina | 119 | none | none | none | none | none |
| Iowa | 114 | none | none | none | none | none |
| Idaho | 97 | none | none | none | none | none |
| Georgia | 28 | none | none | none | none | none |
Source: our DS9 silver lakehouse (Enverus feeds of state regulatory and county clerk records), measured 2026-10-07.
How to read these counts
- Silver is not the upstream feed. Our silver views are built from our own harvest. Each dataset page shows the view count beside the upstream index count from the same day's census.
- A missing row is not proof of absence. If a well or permit is not in the view, it may still exist upstream.
- Counties or areas. Offshore rows count lease areas or blocks, and Alaska counts boroughs and census areas, as the source names them. A count under 5 prints as "under 5".
- Early dates include placeholders. Some source rows carry dates near 1900 that stand in for an unknown date. We pass them through as received.
Machine-readable
The same state-level coverage as a file: coverage.json. It carries no county detail and no records.
Need a state or field that is not here? Say so in the request; the reply tells you whether we hold it.