Wellbore Tubing Records

What this is

Record type 07. The production tubing in a wellbore: size as whole inches plus a fraction, the depth it is set to and where the packer sits.

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 9 columns and about 469.8K 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.
• segment_counter Sequence of this tubing string within the bore.
• tubing_inches Tubing diameter, whole inches.
• tubing_frac_num Numerator of the fractional part of the tubing diameter.
• tubing_frac_denom Denominator of the fractional part of the tubing diameter.

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

What we add

Establish the completion configuration of a well, and check that a packer is set above a perforated interval as an injection permit requires.

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

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.