Oil Ledger — Lease Months — what it is, in short

What this is:

The L-MONTH group of the OLA013K lease record: 1,180,656 rows, twelve months for each of the 98,388 leases. This is the production half of the proration schedule -- the month's oil allowable and the oil the operator reported on Form P-1, how it left the lease and by what method, what was left in storage, and the casinghead gas produced against the lease's gas limit.

How it is laid out:

The Railroad Commission publishes this as EBCDIC (IBM cp037). IBM mainframe encoding (cp037). Opening it as text gives you nonsense; it has to be transcoded first. We decode it into a table you can open anywhere. It has 25 columns and about 1.2M rows.

The columns you will most likely want:

district RRC district of the lease this month belongs to, in the ledger's spelling.
field_no Field number of the lease this month belongs to.
operator_no P-5 number of the lease operator.
lease_no The five-digit oil lease number.
month_ordinal Which of the twelve month slots in the lease record this row came from, 1 to 12, oldest first.
cycle_yyyymm The production month this row reports, CCYYMM.

…and 19 more, all documented on the full page.

What we add:

Compare a lease's reported production against the allowable it was assigned, month by month; find leases that never filed a P-1; and total oil by disposition -- pipeline, truck, skim oil -- rather than by production alone.

Decoded out of the Commission's original format into something Excel opens.
Filterable before you download, so you can take one county instead of the whole state.
The Commission's single-letter codes translated into words.

Worth knowing before use:

Twelve months, not fourteen: the lease record carries twelve where the field, multi-well and well records carry fourteen, and it ends two months earlier. The August 2026 tape runs 202506 to 202605. month_ordinal is a slot on a rolling tape, not a date. Filter on cycle_yyyymm.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

Oil Ledger — Leases Every oil lease on the proration schedule, with its gatherers and its balances.
PDQ Lease Production by Cycle Monthly oil, gas, condensate and casinghead gas production for every Texas lease since 1993.
Production Data Query Dump The whole PDQ archive: sixteen delimited tables of Texas production from 1993 to today.
Gas Ledger The gas proration schedule: every gas field in Texas and how its allowable is set.
Gas Ledger — Field Months Fourteen months of allocation factors and limited-allowable codes for every gas field.
Gas Ledger — Well Months Fourteen months of gas allowable against reported production, well by well.