EZRRC
Cart Sign in

Wellbore Query Data

Queryable Delimited

The fifty-nine column extract behind the Commission's own public wellbore query.

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 EWA subscription file: a wide, comma-delimited denormalisation of the wellbore, operator, lease and permit data that powers RRC's online well search.

It is convenient precisely because it is pre-joined — operator name, field name, lease name, plugging and 14(b)(2) status all sit on one row.

What you can do with it

Get a wide, human-readable well list without doing the joins yourself, including the 14(b)(2) extension detail that is not published anywhere else.

Gotchas

What is loaded and archived here is the undated OG_WELLBORE_EWA_Report.csv from RRC's folder, which the Commission wrote in December 2020 and has not touched since: the newest plug date in the table is 2020-11-10. The same folder holds a dated copy for every month after that, OG_WELLBORE_EWA_Report_YYYY-MM-DD.csv, 72 of them to 2026-08-04, and it is that series the monthly cadence describes. Upstream is being switched to the dated series; until it is, treat this table as a December 2020 snapshot, not a current one.

Being a denormalisation, it is a point-in-time snapshot: the operator name on a row is the operator today, not the operator when the well was drilled.

Record layout

120 columns.

texas.wellbore_query 60 columns

This is the table you get when you download or query Wellbore Query Data.

# Column Type RRC name Meaning Lookup
1 district text — District —
2 county_code text — County code —
3 api_no text — API number —
4 county_name text — County name —
5 oil_gas_code text — Oil gas code —
6 lease_name text — Lease name —
7 field_number text — Field number —
8 field_name text — Field name —
9 lease_number text — Lease number —
10 well_no_display text — Well number display —
11 oil_unit_number text — Oil unit number —
12 operator_name text — Operator name —
13 operator_number text — Operator number —
14 wb_water_land_code text — Wb water land code —
15 multi_comp_flag text — Multi comp flag —
16 api_depth integer — API depth —
17 wb_shut_in_date text — Wb shut in date —
18 wb_14b2_flag text — Wb 14b2 flag —
19 well_type_name text — Well type name —
20 wl_shut_in_date text — Wl shut in date —
21 plug_date text — Plug date —
22 plug_lease_name text — Plug lease name —
23 plug_operator_name text — Plug operator name —
24 recent_permit text — Recent permit —
25 recent_permit_lease_name text — Recent permit lease name —
26 recent_permit_operator_no text — Recent permit operator number —
27 on_schedule text — On schedule —
28 og_wellbore_ewa_id text — OG wellbore ewa ID —
29 w2_g1_filed_date text — W2 g1 filed date —
30 w2_g1_date text — W2 g1 date —
31 completion_date text — Completion date —
32 w3_file_date text — W3 file date —
33 created_by text — Created by —
34 created_dt text — Created date —
35 modified_by text — Modified by —
36 modified_dt text — Modified date —
37 well_no text — Well number —
38 p5_renewal_month text — P5 renewal month —
39 p5_renewal_year text — P5 renewal year —
40 p5_org_status text — P5 org status —
41 curr_inact_yrs integer — Curr inact yrs —
42 curr_inact_mos integer — Curr inact mos —
43 wl_14b2_ext_status text — Wl 14b2 ext status —
44 wl_14b2_mech_integ text — Wl 14b2 mech integ —
45 wl_14b2_plg_ord_sf text — Wl 14b2 plg ord sf —
46 wl_14b2_pollution text — Wl 14b2 pollution —
47 wl_14b2_fldops_hold text — Wl 14b2 fldops hold —
48 wl_14b2_h15_prob text — Wl 14b2 h15 prob —
49 wl_14b2_h15_delq text — Wl 14b2 h15 delq —
50 wl_14b2_oper_delq text — Wl 14b2 operator delq —
51 wl_14b2_dist_sfp text — Wl 14b2 district sfp —
52 wl_14b2_dist_sf_clnup text — Wl 14b2 district sf clnup —
53 wl_14b2_dist_st_plg text — Wl 14b2 district st plg —
54 wl_14b2_good_faith text — Wl 14b2 good faith —
55 wl_14b2_well_other text — Wl 14b2 well other —
56 surf_eqp_viol text — Surf eqp viol —
57 w3x_viol text — W3x viol —
58 h15_status_code text — H15 status code —
59 orig_completion_dt text — Orig completion date —
60 ingested_at timestamp — Ingested at —

wellbore_query 60 columns

This is the table you get when you download or query Wellbore Query Data.

# Column Type RRC name Meaning Lookup
1 district text — RRC district the record belongs to, written the way RRC prints it (01-06, 6E, 7B, 7C, 08, 8A, 09, 10). —
2 county_code text — County code as this file carries it. —
3 api_no text — The API well number as RRC wrote it in this file. —
4 county_name text — County name. —
5 oil_gas_code text — Whether the lease is carried on the oil schedule or the gas schedule. —
6 lease_name text — Lease name as filed. —
7 field_number text — The eight-digit RRC field number. —
8 field_name text — Field name. —
9 lease_number text — RRC lease number. Unique only within a district and a schedule. —
10 well_no_display text — Well number display —
11 oil_unit_number text — Oil unit number —
12 operator_name text — Operator name as carried in this file. Names drift between filings — join on the operator number, never on the name. —
13 operator_number text — The operator's six-digit RRC P-5 organization number. —
14 wb_water_land_code text — Wb water land code —
15 multi_comp_flag text — Multi comp flag —
16 api_depth integer — API depth —
17 wb_shut_in_date text — Wb shut in date —
18 wb_14b2_flag text — Wb 14b2 flag —
19 well_type_name text — Well type name —
20 wl_shut_in_date text — Wl shut in date —
21 plug_date text — Plug date —
22 plug_lease_name text — Plug lease name —
23 plug_operator_name text — Plug operator name —
24 recent_permit text — Recent permit —
25 recent_permit_lease_name text — Recent permit lease name —
26 recent_permit_operator_no text — Recent permit operator number —
27 on_schedule text — On schedule —
28 og_wellbore_ewa_id text — OG wellbore ewa ID —
29 w2_g1_filed_date text — W2 g1 filed date —
30 w2_g1_date text — W2 g1 date —
31 completion_date text — Completion date —
32 w3_file_date text — W3 file date —
33 created_by text — User or process that created the row in RRC's system. —
34 created_dt text — When the row was created in RRC's system. —
35 modified_by text — User or process that last changed the row in RRC's system. —
36 modified_dt text — When the row was last changed in RRC's system. —
37 well_no text — Well number within the lease, as the operator designates it. —
38 p5_renewal_month text — P5 renewal month —
39 p5_renewal_year text — P5 renewal year —
40 p5_org_status text — P5 org status —
41 curr_inact_yrs integer — Curr inact yrs —
42 curr_inact_mos integer — Curr inact mos —
43 wl_14b2_ext_status text — Wl 14b2 ext status —
44 wl_14b2_mech_integ text — Wl 14b2 mech integ —
45 wl_14b2_plg_ord_sf text — Wl 14b2 plg ord sf —
46 wl_14b2_pollution text — Wl 14b2 pollution —
47 wl_14b2_fldops_hold text — Wl 14b2 fldops hold —
48 wl_14b2_h15_prob text — Wl 14b2 h15 prob —
49 wl_14b2_h15_delq text — Wl 14b2 h15 delq —
50 wl_14b2_oper_delq text — Wl 14b2 operator delq —
51 wl_14b2_dist_sfp text — Wl 14b2 district sfp —
52 wl_14b2_dist_sf_clnup text — Wl 14b2 district sf clnup —
53 wl_14b2_dist_st_plg text — Wl 14b2 district st plg —
54 wl_14b2_good_faith text — Wl 14b2 good faith —
55 wl_14b2_well_other text — Wl 14b2 well other —
56 surf_eqp_viol text — Surf eqp viol —
57 w3x_viol text — W3x viol —
58 h15_status_code text — H15 status code —
59 orig_completion_dt text — Orig completion date —
60 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. —

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.
RRC publishes
Updated once a month (Monthly. Available on the 2nd working day of the month.)
EZRRC re-ingests
Weekly The RRC republishes more often than we pull. For the very latest file, go to the RRC directly.
RRC download link
GoAnywhere MFT
Record layout manual
Our table
texas.wellbore_query

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.

Written about this dataset

  • Understanding API numbers The API well number is the closest thing Texas has to a primary key for a hole in the ground. Here is how it is built, why the RRC stores only part of it, and why the same well legitimately appears under several different numbers. 5 min
  • Completions and wellbores — G-1, W-2 and the 28 record types What was actually built downhole. The completion filings give you casing, perforations, formations and initial tests; the Full Wellbore Database gives you every hole ever drilled in Texas as a 28-record-type hierarchy. 6 min
  • Joining RRC datasets — the practical recipes Nine joins that connect the RRC's separate files into one dataset, with the cardinality of each, the type and padding traps that break them, and worked SQL you can run. 6 min

Also in Oil & Gas Well Data