Completion Formation Records
Queryable Fixed-width
Formation tops as reported on the completion filing.
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 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.
What you can do with it
Build formation-top control from completion filings, and cross-check it against the wellbore database's own formation records.
Gotchas
Formation names are operator free text and are not normalised. Depth and measured depth are separate columns and are not always both filled.
Record layout
8 columns.
cmpl_formation_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 |
formation
|
text | — | Formation name as filed. | — |
| 6 |
depth
|
text measured in ft | — | Depth to the formation, feet. | — |
| 7 |
depth_md
|
text measured in ft | — | Measured depth to the formation, feet. | — |
| 8 |
encountered
|
text | — | Whether the formation was actually encountered. | — |
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 Formation Records joins to Completion Information in Data Format on Tracking number and Packet ID — many rows here share a single row there.
the formation tops reported on the filing
Repeating formation rows of the completion packet. 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-formation-records.tracking_no AND completion-information-data-format.packet_id = completion-formation-records.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_formation_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.