Completion Formation Records

What this is

The repeating formation rows of a completion packet: formation name, depth, measured depth and whether the formation was encountered.

Four million rows — the largest of the completion child tables.

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 8 columns and about 4M 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.
• formation Formation name as filed.
• depth Depth to the formation, feet.

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

What we add

Build formation-top control from completion filings, and cross-check it against the wellbore database's own formation records.

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

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 Casing Records Casing strings 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.