Wellbore Completion Records — what it is, in short

What this is

Record type 02 of the wellbore database. One row per completion identifier a wellbore carries: the oil lease number and well number, or the gas district and gas well number, plus the flags that say whether the completion is active, downhole-commingled or covered by a Rule 37 exception.

This is the bridge between a physical wellbore and the lease-level world that production reporting lives in.

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 19 columns and about 1.1M rows.

The columns you will most likely want:

api_county The three-digit county component of the API number. For offshore wells this is the nearest onshore county, not …
api_unique The five-digit well component of the API number. Unique only in combination with the county code.
row_no Sequence number of this row within its parent record. Part of the key.
oil_code 'O' when the completion sits on the oil proration schedule.
oil_district District of the oil lease.
oil_lse_nbr Oil lease number.

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

What we add

Turn an API number into the lease numbers its production is reported under, which is the only way to connect a well to the PDQ production data.

Find wells with multiple completions, and separate active completions from inactive ones.

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.

Worth knowing before you use it

A wellbore can have many completion records, so joining this to the root wellbore row multiplies rows. Oil completions carry a lease number and gas completions carry a gas well number; the same wellbore can have both.

Texas writes the API number four different ways across these files and none of them says so. The …

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.
Completion Information in Data Format Forms G-1 and W-2: the filings that turn a drilled hole into a producing well.
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.