EZRRC
Cart Sign in

Drilling Permit Master and Trailer — End of Month File (with latitudes and longitudes)

The same permits as the nightly file, cut once a month as a stable snapshot.

What this is

The end-of-month cut of the OGA049M permit file. Identical layout to the daily file; the difference is that it is a fixed, citable snapshot taken on the last day of the month rather than a moving target.

Use it when a number has to still be the same number next quarter — monthly permit counts, year-over-year comparisons, anything that goes in a report someone will check.

How it is laid out

The Railroad Commission publishes this as Fixed-width ASCII. Columns are byte ranges with no separators, described only in a scanned record layout. We decode it into a table you can open anywhere. It has 28 columns and about 115K rows.

The columns you will most likely want:

  • received_date Date RRC received the application.
  • amended_date Date the permit was amended, if it ever was.
  • issue_date Date RRC issued the permit. This is the date the industry counts.
  • status_no RRC's status (permit application) number. With sequence_no it is the primary key of this table.
  • sequence_no Sequence within the status number, for amended and re-issued permits.
  • county_code County name, despite the column name. The pipeline resolves the three-digit code against national.us_county on load and stores …

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

What we add

Build a stable monthly permit time series, and reconcile against the Commission's own published counts, which are cut from this file.

Count permits by operator, county or field for any month since the file begins, and watch the leading indicator everyone in the industry watches …

  • 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.
  • Mapped — download it straight into Google Earth or QGIS.

Worth knowing before you use it

Because it is a month-end cut, a permit issued on the 30th and amended on the 2nd appears in its pre-amendment state. The nightly file is the one that reflects today.

county_code holds the county NAME, not a numeric code. RRC's own layout calls the field a code and the file contains 'Midland'. This is …

The full page lists every trap in this dataset.

Get it

People who want this usually want