EZRRC
Cart Sign in

Oil Well Status (26 Month W-10)

A rolling window of W-10 oil well status tests, one row per test filed.

What this is:

OLA001K. The W-10 is the periodic test filing that keeps an oil well's allowable current: the well's daily oil, gas and water on the test day, how it was being produced, and — for a well that is not producing — what it is being used for and when it was shut in.

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 31 columns and about 312.3K rows.

The columns you will most likely want:

  • district RRC district the well is in, written the way RRC prints it: 01-06, 6E, 7B, 7C, 08, 8A, 09, 10.
  • lease_no The five-digit oil lease number, unique within its district.
  • well_no The operator's well number on the lease, up to six characters: '1', '1H', '26H'.
  • unit_no Unit identifier, one character; a digit usually names a waterflood grouping.
  • cycle_year Four-digit year of the ADP reporting cycle the W-10 was processed in.
  • cycle_month Two-digit month of the reporting cycle.

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

What we add:

Track how a well's tested potential has moved over the recent cycles, see which wells on a lease are shut in and since when, and find wells whose W-10 is overdue.

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

The window rolls, and it is shorter than the name suggests: the tape fetched in August 2026 held thirteen cycles (July 2025 through July 2026), with the tests themselves reaching back to 2022.

The full page lists every trap in this dataset.

Get it:

People who want this usually want: