Completion Production Intervals
Queryable Fixed-width
The intervals a completion produces through, including open-hole sections.
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 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.
What you can do with it
Identify the completed interval per lateral, which matters for any horizontal well with more than one branch, and measure completed length.
Gotchas
The lateral label is how a multi-lateral completion distinguishes its branches. Ignoring it double-counts intervals for the same well.
Record layout
9 columns.
cmpl_production_interval_data
9 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 producing interval, feet. | — |
| 6 |
to_depth
|
text measured in ft | — | Bottom of the producing interval, feet. | — |
| 7 |
bottom_hole_label
|
text | — | Bottomhole label, for wells with more than one bottomhole location. | — |
| 8 |
lateral_label
|
text | — | Lateral label, for multi-lateral horizontal wells. | — |
| 9 |
open_hole
|
text | — | Y when the interval is open hole rather than perforated. | — |
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 Production Intervals joins to Completion Information in Data Format on Tracking number and Packet ID — many rows here share a single row there.
the intervals it produces through
Repeating production-interval rows, including the lateral label that separates the branches of a multi-lateral well. 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-production-intervals.tracking_no AND completion-information-data-format.packet_id = completion-production-intervals.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_production_interval_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.