Completion Stimulation Materials
Queryable Fixed-width
What was pumped into the well, over what interval, at completion.
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 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.
What you can do with it
Study stimulation practice by field, operator and year, and find the treated interval for a specific completion.
Gotchas
The material description is free text and the amount is encoded rather than numeric — read the amount/material/process code before summing anything.
This is the completion form's account of the treatment, not a FracFocus disclosure; the two do not always agree.
Record layout
8 columns.
cmpl_akm_data
8 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 |
from_depth
|
text measured in ft | — | Top of the treated interval, feet. | — |
| 6 |
to_depth
|
text measured in ft | — | Bottom of the treated interval, feet. | — |
| 7 |
material_used
|
text | — | Free-text description of the material pumped — acid, sand, water, gel. | — |
| 8 |
amt_material_process_code
|
text | — | What was done to the interval. 'Fracture' identifies a frac job. Stored decoded from the RRC material/process code. | — |
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 Stimulation Materials joins to Completion Information in Data Format on Tracking number and Packet ID — many rows here share a single row there.
what was pumped into it
Repeating material rows: the interval treated and the material used. 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-stimulation-materials.tracking_no AND completion-information-data-format.packet_id = completion-stimulation-materials.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_akm_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.