Datasets / Production headers and the well join

Production headers and the well join

Cumulative and latest production by producing entity, and the join that ties each header to its wells by API number.

Headers: 3,652,452
Coverage: 31 states and 2 federal offshore areas
Latest month: 2026-05
Join match: 58.0%

What it is

A production header summarizes an entity: first and latest month, months produced, cumulative oil, gas and water, latest volumes. Joined to wells on API10 and to units, it answers "what has this well or unit made, and is it still producing."

Refresh: the harvest runs nightly, but the upstream header high-water mark has stayed at 2026-06-30, so recent runs add no newer headers. Latest production month in the view is 2026-05. Monthly volumes month by month are not in this view; ask for them in the request and the reply says what we hold.

Primary key: EntityId, one row per producing entity.

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

3,652,452 production headers in ds9_pdenheaders; the upstream header index held 4,700,690 at the census probe on 2026-10-07. The header harvest high-water mark is 2026-06-30.

Production headers by state, measured 2026-10-07
State or area	Headers	Counties or areas	First production from	Latest month
Texas	1,181,166	265	1932	2026-05
Oklahoma	420,816	78	1963	2026-05
Louisiana	250,588	81	1941	2026-05
California	242,880	60	1977	2026-04
Ohio	212,393	89	1924	2026-03
New Mexico	170,275	32	1945	2026-05
Wyoming	167,999	23	1974	2026-05
Pennsylvania	157,927	55	1961	2026-04
Kentucky	134,543	121	1994	2024-12
West Virginia	113,567	54	1968	2026-03
Colorado	108,682	56	1951	2026-05
Kansas	98,339	98	1966	2026-03
Federal offshore, Gulf	82,054	68	1948	2026-04
Arkansas	42,615	72	1920	2026-04
Montana	39,728	51	1973	2026-05
North Dakota	34,895	52	1951	2026-05
New York	34,494	55	1985	2024-12
Utah	32,892	29	1916	2026-05
Mississippi	30,460	84	1946	2026-05
Nebraska	19,846	92	1949	2026-05
Michigan	16,432	66	1969	2026-05
Alabama	15,378	56	1944	2026-03
Tennessee	13,628	84	1980	2022-12
Virginia	11,556	35	1952	2026-04
Alaska	10,447	86	1919	2026-04
Missouri	2,631	99	1928	2019-06
South Dakota	1,602	50	1954	2026-03
Federal offshore, Pacific	1,531	under 5	1968	2026-04
Florida	1,079	62	1964	2026-04
Arizona	895	14	1954	2021-05
Nevada	732	14	1954	2024-12
Oregon	270	7	1979	2025-12
Maryland	112	under 5	1992	2016-05

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

The well to production join

Method: take each distinct API10 in ds9_wells; it matches when that API10 appears in the API list of any production header. 2,896,681 of 4,997,962 distinct well API numbers match (58.0%). Dry holes, permitted wells never drilled, injection wells and the header gap all lower the share; it is not a producing-well rate.

Wells with at least one production header, measured 2026-10-07
State or area	Distinct API10	With a header	Share
Texas	1,529,849	757,704	49.5%
Oklahoma	510,146	384,305	75.3%
Kansas	468,394	136,950	29.2%
Ohio	274,042	210,896	77.0%
Pennsylvania	271,363	156,456	57.7%
California	253,854	203,646	80.2%
Louisiana	211,579	174,520	82.5%
Wyoming	196,003	144,401	73.7%
West Virginia	162,427	108,549	66.8%
New Mexico	150,134	118,622	79.0%
Illinois	148,973	none	none
Kentucky	144,532	92,500	64.0%
Colorado	126,182	87,349	69.2%
Michigan	89,869	24,262	27.0%
Indiana	61,400	none	none
Arkansas	49,316	38,194	77.4%
Montana	48,056	33,929	70.6%
New York	45,494	33,221	73.0%
North Dakota	43,763	32,460	74.2%
Federal offshore, Gulf	40,223	29,889	74.3%
Utah	38,091	28,575	75.0%
Mississippi	34,519	25,932	75.1%
Nebraska	22,320	17,982	80.6%
Alabama	19,120	14,252	74.5%
Tennessee	15,687	11,865	75.6%
Virginia	13,944	9,374	67.2%
Missouri	12,357	10,509	85.0%
Alaska	6,491	5,458	84.1%
South Dakota	2,058	1,445	70.2%
Nevada	1,590	572	36.0%
Arizona	1,506	854	56.7%
Federal offshore, Pacific	1,338	728	54.4%
Florida	1,254	942	75.1%
Washington	866	none	none
Oregon	713	228	32.0%
Maryland	150	112	74.7%
North Carolina	119	none	none
Iowa	114	none	none
Idaho	97	none	none
Georgia	28	none	none

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_pdenheaders, ApiNo 33061046200000, extracted 2026-10-07.

{
  "ApiNo": "33061046200000",
  "ApiList": [
    "3306104620"
  ],
  "PdenName": "ODDIE",
  "PdenType": "COM",
  "ProdType": "O&G",
  "CurrOperName": "WHITING OIL AND GAS CORPORATION",
  "StateCodeConformed": "ND",
  "CountyNameConformed": "MOUNTRAIL (ND)",
  "Field": "SANISH",
  "Formation": "MIDDLE BAKKEN (BAKKEN POOL)",
  "FirstProdDate": "2020-09-01",
  "LastProdDate": "2026-04-01",
  "MonthsProduced": 68,
  "LiqCum": 414296.0,
  "GasCum": 934814.0,
  "WtrCum": 61786.0,
  "LatestLiq": 2037,
  "LatestGas": 12098.0,
  "Status": "ACTIVE",
  "UpdatedDate": "2026-06-30"
}

Joined response shape you receive (available on request; no public endpoint answers today). Values are the real rows.

GET /v1/well-production?api10=3306104620

{
  "dataset": "well-production",
  "query": {
    "api10": "3306104620"
  },
  "as_of": {
    "wells_view_built": "2026-10-07T07:22:59Z",
    "headers_view_built": "2026-10-06T07:16:16Z",
    "headers_high_water_mark": "2026-06-30 12:24:48"
  },
  "coverage": {
    "state": "ND",
    "status": "in_view"
  },
  "provenance": {
    "lakehouse_views": [
      "ds9_wells",
      "ds9_pdenheaders",
      "ds9_landtrac_units"
    ]
  },
  "data": [
    {
      "well": {
        "API10": "3306104620",
        "WellName": "ODDIE",
        "WellNumber": "44-7HU",
        "CurrentOperator": "WHITING O&G",
        "SpudDate": "2019-12-08",
        "CompletionDate": "2020-04-02",
        "lastProductionDate": "2026-07-01"
      },
      "production": [
        {
          "ApiNo": "33061046200000",
          "PdenName": "ODDIE",
          "PdenType": "COM",
          "Formation": "MIDDLE BAKKEN (BAKKEN POOL)",
          "FirstProdDate": "2020-09-01",
          "LastProdDate": "2026-04-01",
          "MonthsProduced": 68,
          "LiqCum": 414296.0,
          "GasCum": 934814.0,
          "WtrCum": 61786.0
        }
      ],
      "unit": {
        "unit_id": 443194,
        "unit_name": "ODDIE",
        "acres": 2560.0,
        "instrument": "Compulsory Unit"
      },
      "match": {
        "key": "API10",
        "headers_matched": 1,
        "units_matched": 1
      }
    }
  ],
  "next_cursor": null
}

The well row reports last production 2026-07; the header reports 2026-04. The two feeds are refreshed on different schedules. A delivery carries both, each with its own date, and does not pick one.

Fields in a standard delivery

Standard fields; the view holds more, ask for any by name.
Field	Type	Meaning
`EntityId`	text	Primary key, one row per producing entity
`ApiNo, ApiList`	text, list	14-digit API on the header and every API10 it covers; ApiList is the join key to wells
`PdenName, PdenType`	text	Producing entity name; COM completion, LEASE lease level, and others
`CurrOperName`	text	Current operator of the entity
`Field, Formation`	text	Field and producing formation
`FirstProdDate, LastProdDate`	date	First and latest production month
`MonthsProduced`	integer	Months with production
`LiqCum, GasCum, WtrCum`	number	Cumulative liquids (bbl), gas (mcf), water (bbl)
`LatestLiq, LatestGas`	number	Volumes for the latest reported month: liquids bbl, gas mcf
`Status`	text	Entity status
`UpdatedDate`	date	Last change upstream

Known limits

The view held 3,652,452 headers against an upstream index of 4,700,690 on 2026-10-07; a well without a header may still produce.
Monthly volumes by month are not in the header view. Ask for them if you need a time series; the reply says what we hold.
Lease-level headers in some states cover several wells; ApiList carries every API10 on the lease.
Volumes are as reported to the state and are not reallocated or adjusted.

Request this dataset

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

Request access