RRC Oil / ICE Inspections and Violations

What this is

The inspections and violations extract, published weekly on Mondays, one file per district. Each row is a violation found at a lease or well: the rule violated and its description, whether it was classed major, whether the operator was compliant on re-inspection, the last enforcement action and its date.

It names the operator, the P-5 number, the lease, the API number and the drilling permit number, so a violation can …

How it is laid out

The Railroad Commission publishes this as Delimited text. Separated text, usually with an unusual delimiter such as a brace. We decode it into a table you can open anywhere. It has 18 columns and about 396.1K rows.

The columns you will most likely want:

• operator_name Operator name as carried in this file. Names drift between filings — join on the operator number, never …
• p5_operator_no The cited operator's six-digit P-5 number.
• district RRC district the record belongs to, written the way RRC prints it (01-06, 6E, 7B, 7C, 08, 8A, …
• oil_lease_gas_well_id Oil lease number or gas well ID the violation was written against.
• lease_fac_name Lease or facility name.
• api_no The API well number as RRC wrote it in this file.

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

What we add

Find an operator's compliance record, count major violations by district, and see how long it takes for a violation to be cleared.

Join to the wellbore and permit datasets to put a violation on a map.

• 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

• P-5 Organization (ASCII) Every organization with an RRC operator number: name, status, type and address.
• Wellbore Drilling Permit Numbers Every drilling permit number ever issued against a wellbore.
• Certificate of Authorization P-4 (Oil and Gas) Which purchaser or transporter is authorised to move product off which lease.
• Oil and Gas Docket Contested cases, rulemakings and hearings before the Commission.
• Oil and Gas Docket Parties The organizations and people named in each docket.
• Oil and Gas Docket Subjects What each docket was actually about, in the Commission's own words.