Oil Ledger — Multi-Well Group Months — what it is, in short

What this is:

The M-MONTH group of the OLA013K multi-well record: 51,982 rows, fourteen months for each of the 3,713 groups. Each row is the group's daily oil allowable for the month with the codes that say whether it was limited and what kind of group it was assigned to, the casinghead gas allowable beside it, and the two supplemental allowables a proration analyst can issue mid-month.

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 28 columns and about 52K rows.

The columns you will most likely want:

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

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

What we add:

Follow a waterflood unit's allowable through the cycle, including the supplements that changed it after the first of the month.

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 -- 'no limit', 6,318 of 51,982 rows. The supplemental columns are all but unused on the current tape: oil_allow_2 and oil_allow_3 are zero in every row, so a supplement is something this tape records the shape of rather than the fact of.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

Oil Ledger — Multi-Well Groups Waterflood and secondary-recovery groups that take a lease allowable instead of well allowables.
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.