Completion Stimulation Materials

What this is:

The repeating material rows of a completion packet — the AKM records: the depth interval treated, the material used and the code describing the amount and process. Half a million rows describing acid, fracture and other stimulation treatments as reported on the completion form.

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 523.7K 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 treated interval, feet.
• to_depth Bottom of the treated interval, feet.

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

What we add:

Study stimulation practice by field, operator and year, and find the treated interval for a specific completion.

• 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 Production Intervals The intervals a completion produces through, including open-hole sections.
• Directional Survey Applications Scanned directional survey filings.