Statewide Production Data — Oil

What this is:

PDA001, the oil half: PDF100, a 102-byte EBCDIC tape of the Commission's live production database.

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 135 columns and about 176K rows.

The columns you will most likely want:

• district RRC district as an INTERNAL district number, 01 to 14 -- not the designation the industry prints.
• lease_no The RRC oil lease number as a whole number, so PDQ's '02092' is 2092 here.
• oil_code The tape's own record marker, 'O' for an oil lease, on all 176,035 rows.
• movable_balance Barrels in storage on the lease that were produced within the allowable and so may legally be moved off it.
• beginning_oil_status Oil overproduction, in barrels, carried into the oldest cycle the tape still holds -- the balance that rolled off with the months that are no longer here.
• beginning_csghd_status The same for casinghead gas, in MCF: the overproduction the lease brought into the window.

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

What we add:

Ask what a lease was allowed to produce and what it did -- by district, by month, for the whole state -- and then ask where the oil went: 592,889 truck dispositions and 467,793 pipeline ones sit in the disposition table beside the production.

There is more on the full page, including what this joins to.

• 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.

People who want this usually want:

• Historical Ledger — Statewide Oil Every Texas oil lease's month back to January 1993 — allowable, production, movable balance and dispositions. 60.4 million rows.
• PDQ Regulatory Lease Directory The lease directory: lease number to lease name, operator, field and well number.
• PDQ Lease Production by Cycle Monthly oil, gas, condensate and casinghead gas production for every Texas lease since 1993.
• Certificate of Authorization P-4 (Oil and Gas) Who gathers, buys and nominates each Texas lease's oil and gas, and every P-4 behind it.
• Statewide Oil Well Database Every oil well on the proration schedule, with 26 months of allowables and its W-10 tests.
• PDQ Lease Summary (master) One row per lease with the first and last production cycle it ever reported.