Completion Casing Records
Queryable Fixed-width
Casing strings as reported on the completion filing.
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 repeating casing rows of a completion packet: size, weight, depth set, hole size, cement type and amount, slurry volume, top of cement and how it was determined.
This is the completion-time view of casing. The wellbore database's casing records are the Commission's maintained view of the same hole; they do not always agree, and where they disagree the difference is itself informative.
What you can do with it
Audit a well's cementing programme as filed, and compare what the operator reported at completion against what the wellbore database carries today.
Gotchas
Every measurement is stored as text as filed. Weights appear in two columns because operators sometimes report a range.
Rows are ordered within a packet by row number; there is no depth ordering guarantee.
Record layout
17 columns.
cmpl_casing_data
17 columns
| # | Column | Type | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|
| 1 |
tracking_no
key
join
|
text | — | The completion packet's RRC tracking number. | — |
| 2 |
packet_id
key
join
|
text | — | Identifier of the completion packet this row belongs to. | — |
| 3 |
parent_id
key
|
text | — | Identifier of the G-1 or W-2 record this row hangs off. | — |
| 4 |
row_no
key
|
text | — | Sequence number of this row within its parent record. Part of the key. | — |
| 5 |
casing_size
|
text | — | Casing outside diameter, inches, as filed. | — |
| 6 |
weight_lb_per_ft
|
text measured in lb/ft | — | Casing weight, pounds per foot. | — |
| 7 |
weight_lb_per_ft2
|
text measured in lb/ft | — | Second casing weight for a tapered string, pounds per foot. | — |
| 8 |
depth_set
|
text measured in ft | — | Depth the string was set to, feet. | — |
| 9 |
multistage_tool_depth
|
text measured in ft | — | Multi-stage cementing tool depth, feet. | — |
| 10 |
type_of_cement
|
text | — | Cement class or type used. | — |
| 11 |
amount_of_cement
|
text | — | Amount of cement pumped, sacks. | — |
| 12 |
hole_size
|
text | — | Hole diameter, inches. | — |
| 13 |
top_of_cement
|
text measured in ft | — | Reported top of cement behind the string, feet. | — |
| 14 |
slurry_volume
|
text | — | Slurry volume pumped. | — |
| 15 |
casing_type_code
|
text | — | Which string this is — conductor, surface, intermediate, production or tapered production. Stored decoded. | — |
| 16 |
multistage_shoe_depth
|
text measured in ft | — | Multi-stage shoe depth, feet. | — |
| 17 |
top_cement_determine_code
|
text | — | How the top of cement was established. 'Calculation' means it was computed from slurry volume, not measured. | — |
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.
Completion Casing Records joins to Completion Information in Data Format on Tracking number and Packet ID — many rows here share a single row there.
the casing reported on the filing
Repeating casing rows of the completion packet: size, depth set, hole size, cement type and amount. Keyed on the packet's tracking number and packet id, which is the completion file's own hierarchy.
completion-information-data-format.tracking_no = completion-casing-records.tracking_no AND completion-information-data-format.packet_id = completion-casing-records.packet_id
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 every night (Nightly, with the completion file.)
- RRC download link
- GoAnywhere MFT
- Record layout manual
- Our table
texas.cmpl_casing_data
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.