Completion Production Intervals

What this is

The repeating production-interval rows of a completion packet: from-depth, to-depth, the bottomhole and lateral labels for multi-lateral wells, and the open-hole flag.

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 9 columns and about 558.2K 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.
• from_depth Top of the producing interval, feet.
• to_depth Bottom of the producing interval, feet.

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

What we add

Identify the completed interval per lateral, which matters for any horizontal well with more than one branch, and measure completed length.

• 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 Formation Records Formation tops as reported on the completion filing.
• Completion Stimulation Materials What was pumped into the well, over what interval, at completion.
• Directional Survey Applications Scanned directional survey filings.