RRC Oil / ICE Inspections (Every Inspection)

What this is:

INSPECTIONS.txt, the larger half of RRC's weekly OIL/ICE release and the denominator its violations file has always been missing. One row per completed inspection by an Oil and Gas Division inspector since 1 August 2015: who was inspected, where, when, by which district office, and whether every statewide rule looked at came back compliant.

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 16 columns and about 4M rows.

The columns you will most likely want:

• id EZRRC's row number, and the only key this table has.
• operator_name The operator of the inspected lease, well, facility or site AT THE TIME OF THE INSPECTION -- not whoever operates it now.
• p5_operator_no The operator's six-digit RRC P-5 number as of the inspection.
• district The RRC completion district of the assigned oil lease or gas well ID at the time of the inspection, written the way RRC prints it (01-06, 6E, 7B, 7C, 08, 8A, 09, 10).
• district_office_inspecting The RRC district office whose inspector went out, as a city name.
• oil_lease_gas_well_id The oil lease number or gas well ID of the inspected lease or well at the time of the inspection: five digits for an oil lease (2,573,474 rows), six for a gas well ID (1,317,647).

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

What we add:

Ask the questions the violations file alone cannot answer. How often is an operator actually inspected, not just cited? Which district offices inspect most, and how has that moved since 2015? What share of visits to a lease come back non-compliant?

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:

• RRC Oil / ICE Violations Every statewide rule an RRC inspector wrote up since August 2015: which rule, whether it was major, and what enforcement followed.
• 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.
• Wellbore Drilling Permit Numbers Every drilling permit number ever issued against a wellbore.
• Completion Information in Data Format Forms G-1 and W-2: the filings that turn a drilled hole into a producing well.
• Certificate of Authorization P-4 (Oil and Gas) Who gathers, buys and nominates each Texas lease's oil and gas, and every P-4 behind it.