Get the data

Heads up on Original: the Commission does not publish this table on its own. It publishes Production Data Query Dump, which this was parsed out of — so Original gets you that whole file, not just this table. Every other format is this table alone.

Free. You will be asked to confirm an email address before the files are built — that is the only gate, and it is there so we can tell you when a large export is ready.

Preview the first 100 rows

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.

Seventeen million rows breaking each lease-month's volume out by disposition code: sold to a purchaser, run to a pipeline, used as lease fuel, vented or flared, injected, put into storage, lost in processing.

Production tells you how much came out of the ground. Disposition tells you what happened to it.

What you can do with it

Measure flaring and venting by lease, operator, field or district — the disposition codes are the only public source for that.

Reconcile produced volume against disposed volume, and see how much gas is used as lease fuel rather than sold.

Gotchas

Each disposition code is its own column, not a row — the table is very wide rather than long. Oil, gas, condensate and casinghead gas each have their own set.

Disposition should sum to production plus opening balance minus closing balance, and does not always. Discrepancies are real filings, not parsing errors.

A lease number is only unique with the oil/gas code and the district in it. Oil lease 027587 in District 08 and gas lease 027587 in District 08 are different leases; so is oil lease 027587 in District 09.

district_no here is RRC's INTERNAL district numbering (01-14, 20), not the designation the industry prints. Internal 07 is District 6E, 08 is 7B, 09 is 7C, 10 is District 08, 11 is 8A, 13 is 09 and 14 is District 10. The district directory is the lookup; reading the number as a label is wrong.

Volumes are whole numbers in the reporting unit — barrels for liquids, MCF for gas. There are no implied decimals here, unlike the EBCDIC ledgers.

Cycle year and cycle month are separate columns; cycle_year_month is the two of them concatenated as YYYYMM and is the cheapest thing to range on.

Production is reported by lease, not by well. A lease can be one well or two hundred.

Record layout

53 columns.

`pdq_og_lease_disp_cycle` 53 columns

Record layout for `pdq_og_lease_disp_cycle` — 53 columns
#	Column	Type	RRC name	Meaning	Lookup
1	`oil_gas_code` key join	text	—	Whether the lease is carried on the oil schedule or the gas schedule.	Oil or gas schedule
2	`district_no` key join	text	—	RRC's INTERNAL district number, 01 to 14 plus 20 for statewide. This is not the district name the industry uses: internal 07 is District 6E, 08 is 7B, 09 is 7C, 10 is District 08, 11 is 8A, 13 is 09 and 14 is District 10. Join to the district directory rather than reading it as a label.	RRC district (internal number)
3	`lease_no` key join	text	—	RRC lease number. Unique only within a district and a schedule, so a lease key is district + oil/gas code + lease number.	—
4	`cycle_year`	text	—	Production cycle year, four digits.	—
5	`cycle_month`	text	—	Production cycle month, two digits.	—
6	`operator_no` join	text	—	The operator's six-digit RRC P-5 organization number. Join to the P-5 Organization dataset for the company's name, address and P-5 status.	—
7	`field_no` join	text	—	The eight-digit RRC field number. The field's name is not in most files; join to the field directory to get it.	—
8	`cycle_year_month` key	text	—	Production cycle as YYYYMM. This is the column to filter a date range on.	—
9	`lease_oil_dispcd00_vol`	bigint measured in bbl	—	Lease oil dispcd00 vol	—
10	`lease_oil_dispcd01_vol`	bigint measured in bbl	—	Lease oil dispcd01 vol	—
11	`lease_oil_dispcd02_vol`	bigint measured in bbl	—	Lease oil dispcd02 vol	—
12	`lease_oil_dispcd03_vol`	bigint measured in bbl	—	Lease oil dispcd03 vol	—
13	`lease_oil_dispcd04_vol`	bigint measured in bbl	—	Lease oil dispcd04 vol	—
14	`lease_oil_dispcd05_vol`	bigint measured in bbl	—	Lease oil dispcd05 vol	—
15	`lease_oil_dispcd06_vol`	bigint measured in bbl	—	Lease oil dispcd06 vol	—
16	`lease_oil_dispcd07_vol`	bigint measured in bbl	—	Lease oil dispcd07 vol	—
17	`lease_oil_dispcd08_vol`	bigint measured in bbl	—	Lease oil dispcd08 vol	—
18	`lease_oil_dispcd09_vol`	bigint measured in bbl	—	Lease oil dispcd09 vol	—
19	`lease_oil_dispcd99_vol`	bigint measured in bbl	—	Lease oil dispcd99 vol	—
20	`lease_gas_dispcd01_vol`	bigint measured in MCF	—	Lease gas dispcd01 vol	—
21	`lease_gas_dispcd02_vol`	bigint measured in MCF	—	Lease gas dispcd02 vol	—
22	`lease_gas_dispcd03_vol`	bigint measured in MCF	—	Lease gas dispcd03 vol	—
23	`lease_gas_dispcd04_vol`	bigint measured in MCF	—	Lease gas dispcd04 vol	—
24	`lease_gas_dispcd05_vol`	bigint measured in MCF	—	Lease gas dispcd05 vol	—
25	`lease_gas_dispcd06_vol`	bigint measured in MCF	—	Lease gas dispcd06 vol	—
26	`lease_gas_dispcd07_vol`	bigint measured in MCF	—	Lease gas dispcd07 vol	—
27	`lease_gas_dispcd08_vol`	bigint measured in MCF	—	Lease gas dispcd08 vol	—
28	`lease_gas_dispcd09_vol`	bigint measured in MCF	—	Lease gas dispcd09 vol	—
29	`lease_gas_dispcd99_vol`	bigint measured in MCF	—	Lease gas dispcd99 vol	—
30	`lease_cond_dispcd00_vol`	bigint measured in bbl	—	Lease cond dispcd00 vol	—
31	`lease_cond_dispcd01_vol`	bigint measured in bbl	—	Lease cond dispcd01 vol	—
32	`lease_cond_dispcd02_vol`	bigint measured in bbl	—	Lease cond dispcd02 vol	—
33	`lease_cond_dispcd03_vol`	bigint measured in bbl	—	Lease cond dispcd03 vol	—
34	`lease_cond_dispcd04_vol`	bigint measured in bbl	—	Lease cond dispcd04 vol	—
35	`lease_cond_dispcd05_vol`	bigint measured in bbl	—	Lease cond dispcd05 vol	—
36	`lease_cond_dispcd06_vol`	bigint measured in bbl	—	Lease cond dispcd06 vol	—
37	`lease_cond_dispcd07_vol`	bigint measured in bbl	—	Lease cond dispcd07 vol	—
38	`lease_cond_dispcd08_vol`	bigint measured in bbl	—	Lease cond dispcd08 vol	—
39	`lease_cond_dispcd99_vol`	bigint measured in bbl	—	Lease cond dispcd99 vol	—
40	`lease_csgd_dispcde01_vol`	bigint measured in MCF	—	Lease csgd dispcde01 vol	—
41	`lease_csgd_dispcde02_vol`	bigint measured in MCF	—	Lease csgd dispcde02 vol	—
42	`lease_csgd_dispcde03_vol`	bigint measured in MCF	—	Lease csgd dispcde03 vol	—
43	`lease_csgd_dispcde04_vol`	bigint measured in MCF	—	Lease csgd dispcde04 vol	—
44	`lease_csgd_dispcde05_vol`	bigint measured in MCF	—	Lease csgd dispcde05 vol	—
45	`lease_csgd_dispcde06_vol`	bigint measured in MCF	—	Lease csgd dispcde06 vol	—
46	`lease_csgd_dispcde07_vol`	bigint measured in MCF	—	Lease csgd dispcde07 vol	—
47	`lease_csgd_dispcde08_vol`	bigint measured in MCF	—	Lease csgd dispcde08 vol	—
48	`lease_csgd_dispcde99_vol`	bigint measured in MCF	—	Lease csgd dispcde99 vol	—
49	`district_name`	text	—	RRC district as the industry writes it, e.g. 7B, 8A, 6E.	—
50	`lease_name`	text	—	Lease name as filed.	—
51	`operator_name`	text	—	Operator name as carried in this file. Names drift between filings — join on the operator number, never on the name.	—
52	`field_name`	text	—	Field name.	—
53	`ingested_at`	timestamptz	—	When the upstream pipeline last wrote this row. Not an RRC field — it is EZRRC's provenance stamp, and it is what the freshness badge is measured against.	—

Code lookups used here

Every coded column in this dataset resolves to a real lookup table, so a well code of G can be read as what it actually means.

RRC district (internal number) 14 values

Read by district_no

RRC's internal sequential district numbering, 01 to 14 plus 20 for statewide. The production data, the UIC database and the high-cost gas certifications all use this. Internal 07 is District 6E, 08 is 7B, 09 is 7C, 10 is District 08, 11 is 8A, 13 is 09 and 14 is District 10. There is no internal 12.

RRC district (internal number) — 14 codes and their meanings
Code	Means
`01`	District 01 — San Antonio (internal 01) Internal district number 01, which RRC prints as District 01 and administers from San Antonio.
`02`	District 02 — San Antonio (internal 02) Internal district number 02, which RRC prints as District 02 and administers from San Antonio.
`03`	District 03 — Houston (internal 03) Internal district number 03, which RRC prints as District 03 and administers from Houston.
`04`	District 04 — Corpus Christi (internal 04) Internal district number 04, which RRC prints as District 04 and administers from Corpus Christi.
`05`	District 05 — Kilgore (internal 05) Internal district number 05, which RRC prints as District 05 and administers from Kilgore.
`06`	District 06 — Kilgore (internal 06) Internal district number 06, which RRC prints as District 06 and administers from Kilgore.
`07`	District 6E — Kilgore (internal 07) Internal district number 07, which RRC prints as District 6E and administers from Kilgore.
`08`	District 7B — Abilene (internal 08) Internal district number 08, which RRC prints as District 7B and administers from Abilene.
`09`	District 7C — San Angelo (internal 09) Internal district number 09, which RRC prints as District 7C and administers from San Angelo.
`10`	District 08 — Midland (internal 10) Internal district number 10, which RRC prints as District 08 and administers from Midland.
`11`	District 8A — Midland (internal 11) Internal district number 11, which RRC prints as District 8A and administers from Midland.
`13`	District 09 — Wichita Falls (internal 13) Internal district number 13, which RRC prints as District 09 and administers from Wichita Falls.
`14`	District 10 — Pampa (internal 14) Internal district number 14, which RRC prints as District 10 and administers from Pampa.
`20`	District 20 — State Wide (internal 20) Internal district number 20, which RRC prints as District 20 and administers from State Wide.

Source: Generated from texas.pdq_gp_district.district_no

Oil or gas schedule 2 values

Read by oil_gas_code

Which schedule a lease is carried on. This is not decoration: an oil lease number and a gas lease number can be the same digits and mean different leases, so a lease key is only unique with this code and the district in it.

Oil or gas schedule — 2 codes and their meanings
Code	Means
`O`	Oil Carried on the oil proration schedule; lease numbers are oil lease numbers.
`G`	Gas Carried on the gas proration schedule; lease numbers are gas well IDs.

Source: PDQ Dump user manual; values confirmed as the complete distinct set in texas.pdq_og_lease_cycle.oil_gas_code

What this joins to

The Railroad Commission never states these keys anywhere in the files. They are the reason the data is hard to use, so here they are with the exact columns on both sides.

PDQ Lease Disposition by Cycle joins to PDQ Regulatory Lease Directory on Oil gas code and District number and Lease number — many rows here share a single row there.

disposed of production from the lease

The lease key resolved to a name, operator and field.

pdq-lease-disposition-cycle.oil_gas_code = pdq-regulatory-lease-directory.oil_gas_code AND pdq-lease-disposition-cycle.district_no = pdq-regulatory-lease-directory.district_no AND pdq-lease-disposition-cycle.lease_no = pdq-regulatory-lease-directory.lease_no

PDQ Lease Disposition by Cycle joins to PDQ Lease Production by Cycle on Oil gas code and District number and Lease number and Cycle year month — one row here matches one row there.

was disposed of as

Production says how much came out of the ground; disposition says where it went — sold, flared, injected, used as lease fuel. Same lease and same cycle, one row each.

pdq-lease-cycle.oil_gas_code = pdq-lease-disposition-cycle.oil_gas_code AND pdq-lease-cycle.district_no = pdq-lease-disposition-cycle.district_no AND pdq-lease-cycle.lease_no = pdq-lease-disposition-cycle.lease_no AND pdq-lease-cycle.cycle_year_month = pdq-lease-disposition-cycle.cycle_year_month

Where this comes from

Published by

Texas Railroad Commission — the original page

Original format

CSV Comma-separated text.

RRC publishes

Updated once a month (Last Saturday each month, with the PDQ dump.)

RRC download link

GoAnywhere MFT

Record layout manual

Production Data Query Dump — User Manual

Our table

texas.pdq_og_lease_disp_cycle

EZRRC is an independent mirror of public-domain data published by the Texas Railroad Commission. It is not affiliated with or endorsed by the RRC. For any legal or regulatory purpose, verify against the official RRC release.