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

What this is:

The W-MONTH group of the OLA013K well record: 2,905,616 rows, fourteen months for each of the 207,544 wells, and the largest table EZRRC decodes out of an EBCDIC tape.

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 37 columns and about 2.9M rows.

The columns you will most likely want:

district RRC district of the well this month belongs to, in the ledger's spelling.
field_no Field number the well produces from.
operator_no P-5 number of the lease operator.
lease_no The five-digit oil lease number.
well_no The operator's well number, right-justified in six bytes as the tape wrote it.
month_ordinal Which of the fourteen month slots in the well record this row came from, 1 to 14, oldest first.

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

What we add:

Build a well-level allowable history for a lease or a field, find wells whose potential or gas-oil ratio moved, and identify wells shut in for a delinquent W-10 -- 185,461 well-months on the current tape.

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:

gas_allow is null where the tape carried all nines, RRC's 'no limit': 15,742 of 2,905,616 rows. potential is the well's working potential in barrels per calendar day.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

Oil Ledger — Wells Every oil well on the proration schedule, with its depth, status and last test.
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.