EZRRC
Cart Sign in

Historical Ledger — Gas Well Months

42.9 million gas well-months, 1993 to 2024: allowable, word allowable, production, overage and the well's type that month.

What this is:

The 02 LDGSDATA segment of S.LDF900GS on its own: 42,897,545 rows, one per gas RRC id per reporting cycle, from January 1993 to June 2024. This is the table the Historical Ledger exists for, and it is published separately because a download is of one table and nobody wants the 219,384 balance rows when what they came for is the history.

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 40 columns and about 42.9M 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.
  • gas_rrc_id The well's RRC gas identifier as a whole number.
  • cycle_yyyymm The reporting cycle this row belongs to, as a whole number: 202406 is June 2024.
  • operator_no The six-digit P-5 operator number for THIS cycle, which is what makes the file a history rather than a snapshot: a lease that changed hands in 2007 has one number before and another after.
  • field_no The five-digit RRC field number for this cycle, as a whole number.
  • field_reservoir_no The three-digit reservoir number under the field, the low end of RRC's eight-digit field key.

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

What we add:

Chart one well's allowable against its production for thirty-one years; find every month in a field where the allowable was denied rather than assigned; total gas by district and year across the whole state; or take a single year -- 1,400,000-odd rows -- and join it to the P-5 directory to see who was operating what.

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

PRODUCTION IS WET, the volume charged against the allowable. The dry figure PDQ publishes is this minus the code-9 disposition on the parent dataset's hist_gas_disposition table: in cycle 202406 that identity holds on 141,447 of 141,466 wells. FILTER ON THE CYCLE.

The full page lists every trap in this dataset.

Get it:

People who want this usually want: