Datasets / Drilling permits

Drilling permits

Permits to drill, re-enter or deepen, from state regulators, with the API number when one was assigned.

Rows: 2,551,504
Coverage: 32 states and 1 federal offshore area
Latest approval: 2026-10-02
Upstream index: 2,800,044

What it is

A permit row tells you who intends to drill where, to what formation and depth, and when the state approved it. New permits are the earliest public signal of activity in an area.

Primary key: Permitid. The source column API10/UWI is delivered as api10_uwi.

Refresh: harvested nightly; latest approval date in the view is 2026-10-02; the view was last built 2026-10-07.

Delivery

API: filter by state, county, API number or update date; JSON pages with a cursor.
Bulk files: Parquet, CSV or JSONL, one file set per state, with a manifest of row counts and checksums.
Agent endpoint: the same rows behind an MCP tool, keyed per agent.

All three are set up for you after the scope is agreed. Read the docs.

Coverage by state

2,551,504 rows in ds9_permits on 2026-10-07; the upstream permit index held 2,800,044 at the census probe. 2 states with fewer than 5 rows are not listed.

Drilling permits by state, measured 2026-10-07
State or area	Rows	Counties	Approval dates
Texas	778,156	275	1957 to 2026-10-02
Pennsylvania	211,876	54	1900 to 2026-09-30
Wyoming	208,679	23	1900 to 2026-10-01
Louisiana	204,940	83	1905 to 2026-09-29
Kansas	188,956	105	1906 to 2026-10-02
Colorado	152,539	56	1895 to 2026-10-01
West Virginia	135,890	53	1900 to 2026-10-02
New Mexico	123,913	31	1901 to 2026-10-02
Illinois	107,975	102	1870 to 2026-08-28
Oklahoma	103,256	74	1901 to 2026-10-02
California	65,228	38	1970 to 2026-10-01
Ohio	41,024	79	1997 to 2026-09-30
Utah	39,191	29	1921 to 2026-10-01
Montana	37,651	52	1890 to 2026-09-30
North Dakota	27,223	25	1978 to 2026-10-02
Alabama	16,054	59	1940 to 2026-09-28
New York	15,446	46	1953 to 2026-04-02
Tennessee	14,764	66	1968 to 2026-08-06
Arkansas	13,842	57	1938 to 2026-08-18
Virginia	13,256	18	1974 to 2026-09-29
Federal offshore, Gulf	13,059	62	1948 to 2026-10-01
Alaska	10,368	61	1902 to 2026-09-29
Missouri	7,505	59	1900 to 2015-02-11
Kentucky	7,333	73	1969 to 2026-09-10
Mississippi	4,144	57	2003 to 2026-09-22
Nebraska	2,172	28	2006 to 2026-09-21
Michigan	2,021	63	2004 to 2026-07-24
South Dakota	1,774	49	1909 to 2024-07-16
Florida	1,278	69	1945 to 2020-03-04
Nevada	828	12	1930 to 2026-02-26
Indiana	525	28	2014 to 2024-03-28
Oregon	330	17	1955 to 2026-08-17
Arizona	303	6	2008 to 2026-07-24

Source: our DS9 silver lakehouse (Enverus feeds of state regulatory and county clerk records), measured 2026-10-07.

Sample record and response

Real record, ds9_permits, permit 37078, extracted 2026-10-07. Contact name, phone and street address are not delivered.

{
  "PermitNumber": "37078",
  "API10/UWI": "3306104620",
  "LeaseName": "ODDIE",
  "WellNumber": "44-7HU",
  "OperatorName": "WHITING OIL AND GAS CORPORATION",
  "StateCodeConformed": "ND",
  "CountyNameConformed": "MOUNTRAIL (ND)",
  "PermitType": "NewDrill",
  "PermitStatus": "Expired",
  "WellType": "OIL & GAS",
  "DrillType": "H",
  "Formation": "BAKKEN",
  "PermitDepth": 10002,
  "PermitDepthUOM": "ft",
  "SubmittedDate": null,
  "ApprovedDate": "2019-10-10",
  "ExpiredDate": "2020-10-09",
  "Section": "07",
  "Township": "154N",
  "Range": "91W",
  "Latitude": 48.170888,
  "Longitude": -102.421963,
  "UpdatedDate": "2024-02-01"
}

Response shape you receive (available on request; no public endpoint answers today).

GET /v1/permits?api10=3306104620

{
  "dataset": "permits",
  "query": {
    "api10": "3306104620"
  },
  "as_of": {
    "view_built": "2026-10-07T07:23:50Z",
    "source_updated": "2024-02-01"
  },
  "coverage": {
    "state": "ND",
    "status": "in_view"
  },
  "provenance": {
    "lakehouse_view": "ds9_permits",
    "upstream": "Enverus feed of state regulatory filings"
  },
  "data": [
    {
      "PermitNumber": "37078",
      "API10/UWI": "3306104620",
      "LeaseName": "ODDIE",
      "WellNumber": "44-7HU",
      "OperatorName": "WHITING OIL AND GAS CORPORATION",
      "StateCodeConformed": "ND",
      "CountyNameConformed": "MOUNTRAIL (ND)",
      "PermitType": "NewDrill",
      "PermitStatus": "Expired",
      "WellType": "OIL & GAS",
      "DrillType": "H",
      "Formation": "BAKKEN",
      "PermitDepth": 10002,
      "PermitDepthUOM": "ft",
      "SubmittedDate": null,
      "ApprovedDate": "2019-10-10",
      "ExpiredDate": "2020-10-09",
      "Section": "07",
      "Township": "154N",
      "Range": "91W",
      "Latitude": 48.170888,
      "Longitude": -102.421963,
      "UpdatedDate": "2024-02-01"
    }
  ],
  "next_cursor": null
}

Fields in a standard delivery

Standard fields; the view holds more, ask for any by name.
Field	Type	Meaning
`Permitid`	text	Primary key
`PermitNumber`	text	State permit number
`API10/UWI (delivered as api10_uwi)`	text	API number assigned at permit, when the state issues one
`LeaseName, WellNumber`	text	Lease name and well number on the permit
`OperatorName`	text	Operator on the permit
`PermitType, PermitStatus`	text	New drill, re-entry, amended; approved, expired, cancelled
`WellType, DrillType`	text	Product and H, V or D
`Formation, PermitDepth, PermitDepthUOM`	text, number	Target formation and permitted depth
`SubmittedDate, ApprovedDate, ExpiredDate`	date	Filing, approval and expiry
`Latitude, Longitude`	number	Surface location, decimal degrees
`Section, Township, Range, Abstract, Survey`	text	Survey location fields as the state uses them
`UpdatedDate`	date	Last change to the row upstream

Known limits

The view held 2,551,504 rows against an upstream index of 2,800,044 on 2026-10-07.
Contact names, phone numbers and operator street addresses are in the source row and are left out of deliveries.
Approval dates before statewide electronic filing are sparse and vary by state.

Request this dataset

Name the states, the fields and how often you need a refresh. We reply with a written scope.

Request access