Oil Ledger — Wells — what it is, in short

What this is:

The WELL records of OLA013K: 207,544 rows, one per well on a lease that takes well allowables. Each carries the well's total depth and lowest perforation, how it is produced -- flowing, pumping, gas lift -- its completion date, the date of its last W-10 test, its standing under the plugging rule, and the special allowables, bonuses and exceptions attached to it.

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 41 columns and about 207.5K rows.

The columns you will most likely want:

district RRC district the well is in, as the ledger tape writes it: 01-06, 06E, 07B, 07C, 08, 08A, 09, 10.
field_no The eight-digit field number the well produces from.
operator_no P-5 organization number of the lease operator.
lease_no The five-digit oil lease number the well is on.
offshore Land, bay, offshore or a combination, on the field record's code list.
well_no The operator's well number, six bytes and positional: the tape right-justifies it and the loader keeps the leading blanks while dropping the trailing ones, so well 1 arrives as ' 1' and 1H as ' 1H'.

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

What we add:

Find every well in a field or on a lease with its depth and producing method, see which wells are shut in and under what exception, and read the date of the last test that set each well's allowable.

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:

well_no is right-justified in six bytes: 174,528 of the 207,544 rows carry leading blanks, so well 1 is stored as ' 1'. Two wells can differ only in their padding, which is why it is kept. Trim before joining anywhere. The district is the ledger's spelling (06E, 07B, 07C, 08A).

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

Oil Ledger — Well Months Fourteen months of allowable, acreage, potential and gas-oil ratio for every scheduled oil well.
Oil Ledger — Leases Every oil lease on the proration schedule, with its gatherers and its balances.
Oil Ledger The oil proration schedule: every oil field in Texas and the allowable it prorates.
P-5 Organization (ASCII) Every organization with an RRC operator number: name, status, type and address.
PDQ Well Completion Directory The wells that make up each lease, with API numbers and shut-in status.
PDQ Lease Production by Cycle Monthly oil, gas, condensate and casinghead gas production for every Texas lease since 1993.