Completion Casing Records — what it is, in short

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.

How it is laid out:

The Railroad Commission publishes this as Fixed-width ASCII. Columns are byte ranges with no separators, described only in a scanned record layout. We decode it into a table you can open anywhere. It has 17 columns and about 1.1M rows.

The columns you will most likely want:

tracking_no The completion packet's RRC tracking number.
packet_id Identifier of the completion packet this row belongs to.
parent_id Identifier of the G-1 or W-2 record this row hangs off.
row_no Sequence number of this row within its parent record. Part of the key.
casing_size Casing outside diameter, inches, as filed.
weight_lb_per_ft Casing weight, pounds per foot.

…and 11 more, all documented on the full page.

What we add:

Audit a well's cementing programme as filed, and compare what the operator reported at completion against what the wellbore database carries today.

Decoded out of the Commission's original format into something Excel opens.
Filterable before you download, so you can take one county instead of the whole state.

Worth knowing before use:

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.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

Completion Information in Data Format Forms G-1 and W-2: the filings that turn a drilled hole into a producing well.
Full Wellbore Database (ASCII) Every well ever assigned an API number in Texas, with casing, tubing, perforations, formations, plugging and inactive-well tests.
Completion Formation Records Formation tops as reported on the completion filing.
Completion Production Intervals The intervals a completion produces through, including open-hole sections.
Completion Stimulation Materials What was pumped into the well, over what interval, at completion.
Directional Survey Applications Scanned directional survey filings.