Completion Information in Data Format — what it is, in short

What this is:

The completion packet, published nightly. Each packet is a header — operator, lease, field, well, API number, dates, depths, the initial potential test — followed by repeating rows for casing strings, formation tops, production intervals and the materials pumped during stimulation.

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 101 columns and about 528.2K rows.

The columns you will most likely want:

file_batch_date The nightly batch this packet arrived in.
tracking_no The completion packet's RRC tracking number.
packet_id Identifier of the completion packet this row belongs to.
record_id Identifier of the G-1 or W-2 record inside the packet.
district RRC district the record belongs to, written the way RRC prints it (01-06, 6E, 7B, 7C, 08, 8A, 09, 10).
county_code County code as this file carries it.

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

What we add:

See a well's initial potential test: oil, gas and water rates, choke size, gravity and calculated 24-hour rate. Find recently completed wells by spud, work-completed or completion date, and track how long operators are taking between spud and first production.

There is more on the full page, including what this joins to.

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.
The Commission's single-letter codes translated into words.
Mapped — download it straight into Google Earth or QGIS.

Worth knowing before use:

This file writes the API number as eight fused digits (county then unique) with no state prefix and no dashes, while the permit and wellbore files write it as 42-XXX-XXXXX. They do not join without reformatting. Numeric measurements are stored as text exactly as filed, so depths and rates can contain blanks, ranges and notes.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

Full Wellbore Database (ASCII) Every well ever assigned an API number in Texas, with casing, tubing, perforations, formations, plugging and inactive-well tests.
P-5 Organization (ASCII) Every organization with an RRC operator number: name, status, type and address.
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.
Completion Stimulation Materials What was pumped into the well, over what interval, at completion.