PDQ Well Completion Directory

What this is

One of the sixteen delimited tables inside the monthly Production Data Query dump. RRC publishes the dump as a single archive; EZRRC publishes each table inside it separately so you can take the one you need instead of a 3.6 GB zip.

282,000 rows tying a lease and well number to an API county and unique number, with the wellbore and well shut-in dates, the 14(b)(2) status and the wellbore …

How it is laid out

The Railroad Commission publishes this as CSV. Comma-separated text. We decode it into a table you can open anywhere. It has 17 columns and about 820K rows.

The columns you will most likely want:

• oil_gas_code Whether the lease is carried on the oil schedule or the gas schedule.
• district_no RRC's INTERNAL district number, 01 to 14 plus 20 for statewide. This is not the district name the …
• lease_no RRC lease number. Unique only within a district and a schedule, so a lease key is district + …
• well_no Well number within the lease, as the operator designates it.
• api_county_code The three-digit county part of the API number.
• api_unique_no The five-digit unique part of the API number.

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

What we add

Turn lease production into well-level context: which wells are on the lease, which are shut in, and which are subject to 14(b)(2).

Join straight to the wellbore database on the API county and unique number — the two columns are already split the same way.

• 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.
• PDQ Regulatory Lease Directory The lease directory: lease number to lease name, operator, field and well number.
• PDQ Lease Production by Cycle Monthly oil, gas, condensate and casinghead gas production for every Texas lease since 1993.
• Production Data Query Dump The whole PDQ archive: sixteen delimited tables of Texas production from 1993 to today.
• Gas Ledger Twelve months of gas production and fourteen months of allowable, by district group.
• Historical Ledger — Statewide Gas Statewide monthly gas production from 1993 to the present.