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.

Preview the first 100 rows

What this is

The ST-1 is the application for a severance tax exemption or reduction. This file carries 12,716 online applications since April 2019: the district, lease, operator and address, the classification and filing type, the current filing status, and the whole procedural trail — received, issued, spud, completion, and up to three submit/reject cycles plus any hearing request.

It is the clearest view there is of how the incentive process actually runs.

What you can do with it

See which applications were approved, which were rejected and how many times, and how long the Commission takes to act.

Find an operator's incentive applications, and join to the regulatory lease directory on district plus lease number for the field and well count.

Gotchas

The district here is the printed designation (7C, 8A), unlike the high-cost gas file which uses the internal number.

filing_status is a bare number with no published code table; status 4 dominates the file. Read the ST-1 user guide before interpreting it.

Online filings only. Applications made on paper before April 2019 are not here.

Record layout

26 columns.

st1_applications 26 columns

# Column Type RRC name Meaning Lookup
1 st1_docket_id key integer The ST-1 docket identifier. Primary key. e.g. 225620
2 district_nbr join text RRC district. e.g. 02 RRC district (printed designation)
3 lease_nbr join text Lease number the application concerns.
4 lease_name text Lease name as filed.
5 operator_p5 join text Applicant's six-digit P-5 operator number.
6 operator_name text Operator name as carried in this file. Names drift between filings — join on the operator number, never on the name.
7 address1 text Applicant address line 1.
8 address2 text Applicant address line 2.
9 city text Applicant city.
10 state text Applicant state.
11 zipcode text Applicant ZIP code.
12 classification text The severance-tax classification applied for.
13 filing_type text Type of ST-1 filing.
14 filing_status text Where the application currently stands.
15 received_dt date Date RRC received the application.
16 issued_dt date Date the certification was issued.
17 spud_dt date Spud date claimed for the well.
18 completion_dt date Completion date claimed for the well.
19 submit_1_dt date Date of the first submission.
20 reject_1_dt date Date of the first rejection.
21 submit_2_dt date Date of the second submission.
22 reject_2_dt date Date of the second rejection.
23 submit_3_dt date Date of the third submission.
24 reject_3_dt date Date of the third rejection.
25 hearing_req_dt date Date a hearing was requested.
26 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_nbr

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.

CodeMeans
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.

ST-1 Application Report joins to P-5 Organization (ASCII) on Operator P5 = ID — many rows here share a single row there.

applied for by

The P-5 number on the ST-1 application, resolved to the organization. 2,932 of 5,000 sampled applications match the current register. Note that the ST-1 file writes its district the way RRC prints it (7C, 8A) while the production data uses the internal number, so ST-1 does NOT join to the PDQ lease directory on district — it looks like it does and the matches are wrong.

st1-application-report.operator_p5 = p5-organization-ascii.id

Where this comes from

Published by
Texas Railroad Commission — the original page
Original format
CSV Comma-separated text.
Update cadence
Updated once a month (Monthly. Available by the 27th.)
RRC download link
GoAnywhere MFT
Record layout manual
Our table
texas.st1_applications

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.