EZRRC
Cart Sign in

PDQ Field Directory

The field number to field name lookup, with class, discovery date and rules flags.

What this is:

One of the sixteen delimited tables inside the monthly Production Data Query dump. RRC publishes the dump as a single archive; EZRRC publishes each table inside it separately so you can take the one you need instead of a 3.6 GB zip.

How it is laid out:

The Railroad Commission publishes this as CSV. Comma-separated text. We decode it into a table you can open anywhere. It has 33 columns and about 65.8K rows.

The columns you will most likely want:

  • field_no The eight-digit RRC field number.
  • field_name Field name.
  • district_no RRC's INTERNAL district number, 01 to 14 plus 20 for statewide.
  • district_name RRC district as the industry writes it, e.g. 7B, 8A, 6E.
  • field_class
  • field_h2s_flag

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

What we add:

Turn eight-digit field numbers into names, find every field discovered in a given year, and identify sour or offshore fields.

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

Almost every attribute exists twice, prefixed o_ for the oil schedule and g_ for the gas schedule. They frequently differ. A field number is not unique across districts.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

  • Oil & Gas Field Rules Every Texas field with the spacing and density rules the Commission adopted for it.
  • Statewide Field Data The mainframe's field master: every oil and gas field in Texas with its rules, its allocation formulas and 10.5 million rows of allowable and production history.
  • PDQ Field Production by Cycle Field-level monthly production totals.
  • Oil & Gas Field Name & Numbers The eight-digit field number to field name lookup, as RRC publishes it.
  • Oil Ledger The oil proration schedule: every oil field in Texas and the allowable it prorates.
  • Gas Ledger The gas proration schedule: every gas field in Texas and how its allowable is set.