RRC Oil / ICE Inspections and Violations
Queryable Delimited
Inspections that found a violation: which rule, whether it was major, and what enforcement followed.
Get the data
Free. You will be asked to confirm an email address before the files are built — that is the only gate, and it is there so we can tell you when a large export is ready.
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 be tied to a specific hole in the ground.
What you can do with it
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.
Gotchas
Upstream currently holds only a small sample of this extract — 22 rows — because RRC publishes it one district file at a time. Treat it as incomplete until the loader covers every district.
Dates in this file are text as published, not parsed dates.
Absence of a violation is not evidence of compliance; it may only mean no inspection happened.
Record layout
18 columns.
inspections_violations
18 columns
| # | Column | Type | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|
| 1 |
operator_name
|
text | OPERATOR_NAME |
Operator name as carried in this file. Names drift between filings — join on the operator number, never on the name. | — |
| 2 |
p5_operator_no
join
|
text | P5_OPERATOR_NO |
The cited operator's six-digit P-5 number. | — |
| 3 |
district
join
|
text | DISTRICT |
RRC district the record belongs to, written the way RRC prints it (01-06, 6E, 7B, 7C, 08, 8A, 09, 10). | RRC district (printed designation) |
| 4 |
oil_lease_gas_well_id
|
text | OIL_LEASE_GAS_WELL_ID |
Oil lease number or gas well ID the violation was written against. | — |
| 5 |
lease_fac_name
|
text | LEASE_FAC_NAME |
Lease or facility name. | — |
| 6 |
api_no
join
|
text | API_NO |
The API well number as RRC wrote it in this file. | — |
| 7 |
county
|
text | COUNTY |
County the facility is in. | — |
| 8 |
well_no
|
text | WELL_NO |
Well number within the lease, as the operator designates it. | — |
| 9 |
drilling_permit_no
join
|
text | DRILLING_PERMIT_NO |
Drilling permit number, where the violation attaches to a permitted well. | — |
| 10 |
field_name
|
text | FIELD_NAME |
Field name. | — |
| 11 |
violated_rule
|
text | VIOLATED_RULE |
The statewide rule that was violated. | — |
| 12 |
violated_rule_desc
|
text | VIOLATED_RULE_DESC |
Plain-language description of the rule. | — |
| 13 |
major_viol_ind
|
text | MAJOR_VIOL_IND |
Y when RRC classified this as a major violation. | — |
| 14 |
compliant_on_reinsp
|
text | COMPLIANT_ON_REINSP |
Whether the operator was compliant when re-inspected. | — |
| 15 |
last_enf_action
|
text | LAST_ENF_ACTION |
The most recent enforcement action taken. | — |
| 16 |
last_enf_action_date
|
text | LAST_ENF_ACTION_DATE |
Date of that enforcement action. | — |
| 17 |
violation_disc_date
|
text | VIOLATION_DISC_DATE |
Date the violation was discovered. | — |
| 18 |
ingested_at
|
timestamptz | — | When the upstream pipeline last wrote this row. Not an RRC field — it is EZRRC's provenance stamp, and it is what the freshness badge is measured against. | — |
Code lookups used here
Every coded column in this dataset resolves to a real lookup table, so
a well code of G can be read as what it actually means.
RRC district (printed designation) 14 values
Read by district
The district as the Railroad Commission prints it: 01-06, 6E, 7B, 7C, 08, 8A, 09 and 10, plus 20 for statewide. This is what appears on permits, completions, ST-1 filings and inspection reports. It is not interchangeable with the internal district number. A column holding '11' means District 8A under the internal numbering and nothing at all under this one.
| Code | Means |
|---|---|
01 |
District 01 — San Antonio RRC District 01, administered from the San Antonio district office. |
02 |
District 02 — San Antonio RRC District 02, administered from the San Antonio district office. |
03 |
District 03 — Houston RRC District 03, administered from the Houston district office. |
04 |
District 04 — Corpus Christi RRC District 04, administered from the Corpus Christi district office. |
05 |
District 05 — Kilgore RRC District 05, administered from the Kilgore district office. |
06 |
District 06 — Kilgore RRC District 06, administered from the Kilgore district office. |
6E |
District 6E — Kilgore RRC District 6E, administered from the Kilgore district office. |
7B |
District 7B — Abilene RRC District 7B, administered from the Abilene district office. |
7C |
District 7C — San Angelo RRC District 7C, administered from the San Angelo district office. |
08 |
District 08 — Midland RRC District 08, administered from the Midland district office. |
8A |
District 8A — Midland RRC District 8A, administered from the Midland district office. |
09 |
District 09 — Wichita Falls RRC District 09, administered from the Wichita Falls district office. |
10 |
District 10 — Pampa RRC District 10, administered from the Pampa district office. |
20 |
District 20 — State Wide RRC District 20, administered from the State Wide district office. |
Source: Generated from texas.pdq_gp_district.district_name
What this joins to
The Railroad Commission never states these keys anywhere in the files. They are the reason the data is hard to use, so here they are with the exact columns on both sides.
RRC Oil / ICE Inspections and Violations joins to P-5 Organization (ASCII) on P5 operator number = ID — many rows here share a single row there.
cited the operator
The P-5 number of the operator cited in the violation, resolved to the operator directory.
rrc-oil-ice-inspections.p5_operator_no = p5-organization-ascii.id
RRC Oil / ICE Inspections and Violations joins to Wellbore Drilling Permit Numbers on Drilling permit number = Permit number — rows can match many rows in both directions.
cited a well permitted as
The drilling permit number on the violation, matched against the wellbore file's permit list — which is what puts an enforcement action on a specific hole in the ground.
rrc-oil-ice-inspections.drilling_permit_no = wellbore-drilling-permit-numbers.permit_number
Where this comes from
- Published by
- Texas Railroad Commission — the original page
- Original format
- Delimited Separated text, usually with an unusual delimiter such as a brace.
- Update cadence
- Updated once a week (Weekly, on Mondays.)
- RRC download link
- GoAnywhere MFT
- Record layout manual
- Our table
texas.inspections_violations
EZRRC is an independent mirror of public-domain data published by the Texas Railroad Commission. It is not affiliated with or endorsed by the RRC. For any legal or regulatory purpose, verify against the official RRC release.