EZRRC
Cart Sign in

Wellbore Perforation Records

The perforated intervals a well is completed through.

What this is

Record type 06. One row per perforated interval: from-depth, to-depth and whether the interval is open hole rather than perforated casing.

It is the most direct statement in the public record of where in the rock a well is actually producing from.

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 7 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.
  • perf_count Sequence of this perforated interval within the bore.
  • from_perf Top of the perforated interval, feet.
  • to_perf Bottom of the perforated interval, feet.
  • open_hole_code 'OH' when the interval is open hole rather than perforated casing.

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

What we add

Determine the completed interval of any well, measure gross completed thickness, and identify wells completed in more than one interval.

  • 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

Depths are measured depth. In a horizontal well the perforated interval is along the lateral, so a 10,000 ft interval is length, not depth.

An open-hole completion is flagged rather than perforated, and its interval means something different.

The full page lists every trap in this dataset.

Get it

People who want this usually want