EZRRC
Cart Sign in

Gas Ledger — Well Months

Queryable EBCDIC

Fourteen months of gas allowable against reported production, well by well.

Get the data

Heads up on Original: the Commission does not publish this table on its own. It publishes Gas Ledger, 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

The MONTHLY-WELL group of the GSA020K well record: 1,973,888 rows, fourteen months for each of the 140,992 gas wells. Each row is the month's gas allowable in MCF and the gas the operator reported on Form P-2, the condensate produced at the lease and how it was disposed of, the potential and pressures in effect for the month, the acres the allowable was calculated on, and the word allowable that prints on the schedule when a well has no number.

What you can do with it

Compare a gas well's allowable against what it produced, month by month; find wells producing under a word allowable such as '14B2 EXT' or 'DLQ G-10'; and pull the pressure and potential history behind the allowable.

Gotchas

word_allow is the readable half of this table: '14B2 EXT' on 331,107 rows, ' SWR 10' on 72,223, '14B DENY' on 71,334, plus 'DLQ G-10', 'PRTL PLG', 'H15 VIOL', ' SHUT IN', 'T. A.', 'INJECT', 'SI MULT' and 'DOMESTIC'. The leading spaces are the tape's right-justification, so match with contains rather than equals.

lmt_allow and highest_daily_prod_lmt are null where the tape carried all nines -- 'no limit' -- which is 98% of rows.

liq_allow, plant_liq, inj_credit, inj_code, red_rate_code, on_shut_list, exc_8609_limit and swr38_acres_code are empty or zero in every row of the current tape.

bal_code and red_rate_code each carry two unrelated code lists in one byte: the balancing code, and a flag for the month a plug-and-abandon or shut-in code was entered. Read the column descriptions before counting them.

month_ordinal is a slot on a rolling tape. Filter on cycle_yyyymm.

Record layout

47 columns. Byte positions are 1-based and come from the RRC record layout, so you can check our decoding against the original file yourself.

gas_ledger_well_month 47 columns

# Column Type Bytes RRC name Meaning Lookup
1 district key join text 2-4 W-DISTR RRC district of the well this month belongs to, in the ledger's spelling. e.g. 01 RRC district (proration ledger spelling)
2 field_no key join integer 5-12 W-PERM-FLD-ID The eight-digit field number the well produces from. —
3 operator_no key join integer 13-18 OPER-ID P-5 number of the well's operator. —
4 gas_rrc_id key join integer 19-24 WELL-ID The gas well's six-digit statewide RRC identification number. e.g. 273598 —
5 month_ordinal key smallint — — Which of the fourteen month slots in the well record this row came from, 1 to 14, oldest first. A position on a tape that rolls every cycle, not a date. Filter on cycle_yyyymm. e.g. 14 —
6 cycle_yyyymm integer 317-322 W-DATE The schedule month this row is for, CCYYMM. The August 2026 tape runs 202506 to 202607, and all 140,992 wells carry all fourteen. e.g. 202607 —
7 name_change_code smallint 323 NAME-CHANGE-CODE What changed this month: 1 field name, 2 operator name, 3 lease name, 4 well, 5 gas gatherer, 6 a combination, 7 liquid gatherer. —
8 form_rec_code smallint 324 FORM-REC-CODE Whether the month's P-2 gas production report arrived: 0 not received (560,589 rows), 1 received (1,377,011), 2 a corrected P-2, 3 and 4 an allowable change with and without a P-2, 5 a new well too recent to have reported, 9 RRC's monthly-roll flag. —
9 bal_code smallint 325 BAL-CODE Whether the well was balancing this month: 1 regular, 2 special 49(b), 3 underage cancelled at the end of the month. The same byte doubles as the flag for the month a plug-and-abandon code was entered, which is why 4 to 9 appear here too. —
10 exc_206_code smallint 326 EXC-206-CODE Whether the well had an exception to House Bill 206 this month, or was on a liquid limit: 0 none, 1 exception, 3 liquid limit on the oil production factor, 4 a daily liquid limit, 5 a monthly one. —
11 red_rate_code smallint 327 RED-RATE-CODE Whether an overproduced well was allowed to keep producing at a reduced rate, and for how many months (4 is one month through 9 for six); 1 marks the month it was shut in instead. Zero in every row of the August 2026 tape. —
12 tsf_code smallint 328 TSF-CODE Whether the well transferred an allowable this month: 1 to it, 2 from it. —
13 no_supp smallint 329 NO-SUPP 1 where the month's allowable had to be worked out by hand rather than by computer. 1,161 of 1,973,888 rows. —
14 lack smallint 330 LACK Why an allowable was withheld this month: 1 another form lacking (144,078 rows), 2 a delinquent G-10, 3 an incomplete G-10, 4 no production, 5 plugged but still filing for condensate, 6 a delinquent P-2. The tape also carries 7 on 1,282 rows, which the manual does not list. —
15 old_operator_no integer 331-336 OLD-OP-CODE P-5 number of the well's previous operator, where it changed hands. —
16 well_type_mo text 337 W-TYPE-MO The well's status during this particular month, on the same code list as the well record's well_type -- and carrying the same undocumented '(' , on 72,280 rows. —
17 al_code text 338 AL-CODE The allowable code for the month; the list is the manual's Appendix B, which the record layout does not reproduce. The values in use are N, X, K, J, O, R, Z, H, '#', '%' and '(' -- read word_allow beside it, which spells several of them out. e.g. K —
18 word_allow text 339-346 WRD-ALLOW The word allowable printed on the proration schedule when the well has one instead of a number: '14B2 EXT' on 331,107 rows, ' SWR 10' on 72,223, '14B DENY' on 71,334, ' T. A.' , 'DLQ G-10', 'PRTL PLG', 'H15 VIOL', ' SHUT IN', 'INJECT', 'SI MULT', 'DOMESTIC'. The leading spaces are the tape's own right-justification. e.g. '14B DENY' —
19 on_shut_list text 347 ON-SHUT-LST 1 when the operator has been sent a shut-in letter and the well put on the shut-in list. Blank in every row of the August 2026 tape. —
20 no_lmt_allow_sw smallint 348 NO-LMT-ALLOW-SW 1 where the well is exempt from being assigned an '@' limited allowable automatically. 207,310 rows. —
21 allow integer measured in MCF 349-352 ALLOW The month's gas allowable in MCF -- the most the well was permitted to produce. Non-zero on 1,166,578 of 1,973,888 rows. —
22 gas_prod integer measured in MCF 353-356 GAS-PRD Gas the operator reported producing that month on Form P-2, in MCF. —
23 inj_credit integer measured in MCF 357-360 INJ-CREDIT Credit given for gas injected back into the reservoir that month, in MCF. Zero in every row of the August 2026 tape. —
24 inj_code smallint 361 INJ-CODE What kind of injection credit: 1 injection, 2 gas lift, 3 a bank balance. Zero throughout the current tape. —
25 liq_allow integer measured in bbl 362-364 W-LIQ-ALLOW The month's condensate allowable in barrels. Zero in every row of the August 2026 tape -- liquid allowables are set on the well record rather than here. —
26 lease_liq integer measured in bbl 365-367 LSE-LIQ Condensate produced and separated at the well, in barrels, as the operator reported it. Non-zero on 367,212 rows. —
27 plant_liq integer measured in bbl 368-370 PLT-LIQ Condensate allocated to the well at a processing plant, in barrels, for a well producing full stream into a pipeline. Zero in every row of the current tape. —
28 liq_disp_1 integer measured in bbl 371-373 LIQ-DISI Barrels of condensate disposed of by the primary method, which liq_disp_code_1 names. —
29 liq_disp_code_1 smallint 374 LIQ-DISCDI Primary condensate disposition: 0 pipeline (1,817,382 rows), 1 trucks (156,491), 2 tank cars or barge, 3 net oil from tank cleaning, 4 circulating oil, 5 lost, 6 sedimentation, 7 other. —
30 liq_disp_2 integer measured in bbl 375-377 OTH-DISI Barrels of condensate disposed of by the secondary method. Two or more secondary methods are added together and coded 7. —
31 liq_disp_code_2 smallint 378 OTH-DISCDI Secondary condensate disposition, same list except that 0 means no code rather than pipeline. 8 appears on 51,943 rows, which the gas manual's list stops short of. —
32 g4_pote integer measured in MCF 379-382 MO-G4 The well's open-flow potential in MCF in effect for the month -- the G-10 potential rather than the G-1 one on the well record. —
33 g2_daily_test integer measured in MCF/d 383-385 MO-G2 The daily production test for the month. For Panhandle West wells the manual notes this holds the twelve-month peak instead, stored monthly since August 2000. Non-zero on 1,449,491 rows. —
34 bhp integer measured in psi 386-388 MO-BHP The bottom-hole or shut-in pressure in psi used for the month's allocation, from the G-10. Where field rules require both tests, this is the one the formula used. —
35 other_pressure integer measured in psi 389-391 OTHER-PRESI The pressure test not used in the allocation formula, in psi, for wells whose field rules require both. —
36 acres numeric measured in acres 392-395 MO-ACRE Acres assigned to the well for the month, four whole numbers and three decimals. Non-zero on 1,414,581 rows; the largest is 9,346. —
37 acre_ft numeric measured in acre-ft 396-399 MO-ACRE-FT The well's acre-feet value, six whole numbers and one decimal. Non-zero on 3,258 rows. —
38 transfer_allow integer measured in MCF 400-403 TRAN-ALLOW Gas allowable transferred to or from the well, in MCF, where field rules permit transfers. Non-zero on 224 rows. —
39 open_cond integer measured in bbl 404-406 OPEN-COND Condensate stock on hand at the start of the month, in whole barrels. —
40 close_cond integer measured in bbl 407-409 CLOSE-COND Condensate stock on hand at the end of the month, in whole barrels. —
41 lease_pct_reserve numeric 410-413 MO-LEASE-PERCENT-RESERVE The percentage of the field allowable assigned to this lease, based on original reserves, with four implied decimals. Present in every row. —
42 pct_red_rate integer 414-417 PER-CENT-RED-RATE The percentage of its allowable a well on a reduced rate may produce. Zero means the default, which is 50%. —
43 top_sch_allow integer measured in MCF 418-421 MO-TOP-SCH-ALLOW The largest allowable the schedule calculation could have assigned the well this month, in MCF. Non-zero on 1,277,193 rows. —
44 lmt_allow integer measured in MCF 422-425 MO-LMT-ALLOW The calculated monthly limited allowable in MCF. Null where the tape carried all nines -- no limit -- which is 1,940,805 of 1,973,888 rows. —
45 highest_daily_prod_lmt integer measured in MCF/d 426-429 MO-HIGHEST-DAILY-PROD-LMT The highest daily production of the previous twelve months, in MCF, which is what a production limit is calculated from. Null where the tape carried all nines. —
46 exc_8609_limit smallint 430-431 EXC-8609-LIMIT The multiple of the monthly allowable a well with an exception may produce -- '03' is three times. The manual records the item as not in use, and it is zero in every row. —
47 swr38_acres_code text 432 SWR38-ACRES-CODE 'Y' where the well's acreage was granted at a hearing and must not be changed. Blank in every row of the August 2026 tape. —

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 (proration ledger spelling) 14 values

Read by district

The district as the oil and gas proration ledger tapes write it, which is NOT how the rest of the corpus writes it. The ledger pads the lettered districts to three bytes -- 06E, 07B, 07C, 08A -- where the W-10, the G-10 and PDQ's district_name write 6E, 7B, 7C and 8A. That difference is worth a code set of its own because it is invisible in a join: a query matching ledger.district against w10.district returns rows for the ten numeric districts and silently drops the four lettered ones, which are 24% of the oil ledger's wells. Strip the leading zero before joining, or add it coming the other way. `canonical_value` is the internal district number, the same convention rrc.district uses, so a ledger district resolves to the same district in either numbering.

CodeMeans
01 District 01 — San Antonio Written 01 here and 01 elsewhere.
02 District 02 — San Antonio Written 02 here and 02 elsewhere.
03 District 03 — Houston Written 03 here and 03 elsewhere.
04 District 04 — Corpus Christi Written 04 here and 04 elsewhere.
05 District 05 — Kilgore Written 05 here and 05 elsewhere.
06 District 06 — Kilgore Written 06 here and 06 elsewhere.
06E District 6E — Kilgore The ledger writes 06E; the W-10 and PDQ write 6E.
07B District 7B — Abilene The ledger writes 07B; the W-10 and PDQ write 7B.
07C District 7C — San Angelo The ledger writes 07C; the W-10 and PDQ write 7C.
08 District 08 — Midland Written 08 here and 08 elsewhere.
08A District 8A — Midland The ledger writes 08A; the W-10 and PDQ write 8A.
08B District 8B — reserved The manuals list 08B as reserved for future use. No record of any ledger tape has ever carried it.
09 District 09 — Wichita Falls Written 09 here and 09 elsewhere.
10 District 10 — Pampa Written 10 here and 10 elsewhere.

Source: RRC manuals OLA013K, GSA020K and OLA028K (DIST/DIST-NO items); the thirteen spellings in use confirmed as the complete distinct set in texas.oil_ledger_field, texas.oil_ledger_well and texas.oil_detail_well on 2026-08-21

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.

Gas Ledger — Well Months joins to Gas Ledger — Wells on District and Field number and Operator number and Gas RRC ID — many rows here share a single row there.

has fourteen months of allowable and production

The MONTHLY-WELL group of the gas well record: the month's allowable, the gas the operator reported on Form P-2, the condensate, the pressures and the word allowable. All 5,000 sampled wells carry all fourteen.

gas-ledger-wells.district = gas-ledger-well-months.district AND gas-ledger-wells.field_no = gas-ledger-well-months.field_no AND gas-ledger-wells.operator_no = gas-ledger-well-months.operator_no AND gas-ledger-wells.gas_rrc_id = gas-ledger-well-months.gas_rrc_id

Where this comes from

Published by
Texas Railroad Commission — the original page
Original format
EBCDIC IBM mainframe encoding (cp037). Opening it as text gives you nonsense; it has to be transcoded first.
RRC publishes
Updated once a month (Monthly, with the gas ledger.)
RRC download link
GoAnywhere MFT
Record layout manual
Our table
texas.gas_ledger_well_month

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.

Also in Production Data