Wellbore Casing Records
Queryable Fixed-width
Every casing string set in every Texas well: size, depth, hole size and cement.
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
Record type 05. One row per casing string: the casing diameter as a whole number plus a fraction, the depth it was set to, the hole size it went into, how much cement was pumped and how the top of cement was determined.
1.7 million casing strings. This is the dataset behind almost every groundwater-protection question asked about Texas wells.
What you can do with it
Check whether surface casing was set below the base of usable-quality water, compare cement volumes against hole volume, and find wells whose casing programme is unusual for their field.
Gotchas
Casing and hole diameters are stored as three separate integers — a whole number, a fraction numerator and a fraction denominator. 9 5/8 inch casing is 9, 5 and 8. Reassemble before you compare anything.
The cement measurement code says whether the amount is sacks or cubic feet. Summing the column without reading that code mixes units.
Record layout
17 columns. Byte positions are 1-based and come from the RRC record layout, so you can check our decoding against the original file yourself.
wb_casings
17 columns
| # | Column | Type | Bytes | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|---|
| 1 |
api_county
key
join
|
text | — | — | The three-digit county component of the API number. For offshore wells this is the nearest onshore county, not the well's actual location. | — |
| 2 |
api_unique
key
join
|
text | — | — | The five-digit well component of the API number. Unique only in combination with the county code. | — |
| 3 |
casing_count
key
|
smallint | 3-5 | WB-CASING-COUNT |
Sequence of this casing string within the bore. | — |
| 4 |
cas_inch
|
integer | 6-7 | WB-CAS-INCH |
Casing diameter, whole inches. | — |
| 5 |
cas_frac_num
|
integer | 8-9 | WB-CAS-FRAC-NUM |
Numerator of the fractional part of the casing diameter. | — |
| 6 |
cas_frac_denom
|
integer | 10-11 | WB-CAS-FRAC-DENOM |
Denominator of the fractional part of the casing diameter. | — |
| 7 |
casing_depth_set
|
integer measured in ft | 20-24 | WB-CASING-DEPTH-SET |
Depth the string was set to, feet. | — |
| 8 |
mlti_stg_tool_dpth
|
integer measured in ft | 25-29 | WB-MLTI-STG-TOOL-DPTH |
Multi-stage cementing tool depth, feet. | — |
| 9 |
amount_of_cement
|
integer | 30-34 | WB-AMOUNT-OF-CEMENT |
Amount of cement pumped; the unit is in the cement measurement column. | — |
| 10 |
cement_measurement
|
text | 35 | WB-CEMENT-MEASUREMENT |
Unit the cement amount is in: sacks, cubic yards or feet. | Cement quantity unit |
| 11 |
hole_inch
|
integer | 36-37 | WB-HOLE-INCH |
Hole diameter, whole inches. | — |
| 12 |
hole_frac_num
|
integer | 38-39 | WB-HOLE-FRAC-NUM |
Numerator of the fractional part of the hole diameter. | — |
| 13 |
hole_frac_denom
|
integer | 40-41 | WB-HOLE-FRAC-DENOM |
Denominator of the fractional part of the hole diameter. | — |
| 14 |
top_of_cement_casing
|
text | 43-49 | WB-TOP-OF-CEMENT-CASING |
Reported top of cement behind this string. | — |
| 15 |
amount_casing_left
|
integer measured in ft | 50-54 | WB-AMOUNT-CASING-LEFT |
Casing left in the hole, feet. | — |
| 16 |
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. | — |
| 17 |
cas_wt_table
|
text measured in lb/ft | 12-19 | WB-CAS-WT-TABLE |
Casing weight in pounds per foot (the layout allows two entries). | — |
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.
Cement quantity unit 3 values
Read by cement_measurement
The unit the casing record's cement amount is expressed in.
| Code | Means |
|---|---|
S |
Sacks |
Y |
Cubic yards |
F |
Feet |
Source: RRC manual WBA091, WBCASE record, WB-CEMENT-MEASUREMENT
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.
Wellbore Casing Records joins to Full Wellbore Database (ASCII) on API county and API unique — many rows here share a single row there.
its casing strings
One row per casing string set in the hole, with size, depth and cement. Keyed on the API county and unique number, which is how every record type in WBA091 hangs off its root record.
full-wellbore-ascii.api_county = wellbore-casing.api_county AND full-wellbore-ascii.api_unique = wellbore-casing.api_unique
Where this comes from
- Published by
- Texas Railroad Commission — the original page
- Original format
- Fixed-width Columns are byte ranges with no separators, described only in a scanned record layout.
- Update cadence
- Updated once a week (Weekly, with the wellbore database.)
- RRC download link
- GoAnywhere MFT
- Record layout manual
- Our table
texas.wb_casings
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.