Wellbore Well Identifiers

What this is

Record type 11. The oil-schedule identity of a wellbore: oil/gas code, district, lease number and well number on the lease.

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 8 columns and about 667.1K 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 identifier is an oil lease identifier.
• oil_district District of the oil lease.
• oil_lse_number Oil lease number.

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

What we add

Resolve which lease and well-on-lease an API number corresponds to, which is what production data is reported against.

• 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.

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.