Drilling Permit Master and Trailer

What this is:

OGA049M's MASTER FILE TAPE, daf802.txt.gz, and the deepest dataset on this site: 993,336 W-1 applications with all fourteen trailer segments of RRC's IMS drilling-permit database hanging off them. The permit segment's issue dates start at 1976-05-28; the applications carry received dates back to 1922, on records rebuilt from the old drilling-permit master.

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 240 columns and about 994.4K rows.

The columns you will most likely want:

• status_no The seven-digit status number RRC assigns to a W-1 application when it arrives.
• status_seq The amendment sequence, which counts DOWN from 99: 99 is the original filing, 98 the first amendment, 97 the second.
• county_code Three-digit county code of the county the drilling operation is to take place in, AS THE OPERATOR REPORTED IT on the W-1.
• lease_name Lease name as the operator wrote it on the W-1, up to 32 characters.
• district RRC district as the operator reported it, stored as the internal ADP code: 07 is District 6E, 08 is 7B, 09 is 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10.
• operator_no The operator's six-digit P-5 organization number as reported on the W-1.

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

What we add:

Reconstruct a permit's whole life — the original filing and every amendment, what the operator asked for, what the Commission approved, when it was issued, extended, spudded, expired or cancelled. Read the restrictions.

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:

• Drilling Permit Master and Trailer — Daily File (with latitudes and longitudes) Every drilling permit application, refreshed nightly, with surface and bottomhole coordinates.
• 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.
• P-5 Organization (ASCII) Every organization with an RRC operator number: name, status, type and address.
• Drilling Permit Master Every approved W-1 since 1976 as one flat row per permit — 950,665 of them.
• Drilling Permits Pending Approval (with latitudes and longitudes) Applications the Commission has received but not yet acted on, kept extract by extract.
• Drilling Permit (W-1) Imaged Files Scanned W-1 permit forms and the plats filed with them.