EZRRC
Cart Sign in

Gas Ledger

Queryable EBCDIC

The gas proration schedule: every gas field in Texas and how its allowable is set.

Get the data

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

GSA020K, the gas master tape. Three volumes of 2120-byte EBCDIC records covering districts 1-3, 4-6 and 7B-10, decoded here into four tables: a record for every gas FIELD and one for every gas WELL, each with fourteen months carried inside the record.

This dataset is the field records: 42,133 of them, with the field's discovery date and depth, whether it is associated with an oil field, the class that decides how its allowable is calculated, its balancing rule, its spacing and unit acreage, and its cumulative gas and condensate production. The fourteen months of allocation factors are Gas Ledger Field Months, and the wells are Gas Ledger Wells.

There is no lease level here, and that is the point: gas is scheduled well by well because gas wells report production by well, where oil leases report by lease.

What you can do with it

Read how each gas field's allowable is set -- prorated, exempt, one-well, 100% open flow -- and rank the state's gas fields by cumulative production. Cumulative condensate beside cumulative gas is the cheapest way to find the liquids-rich fields.

Gotchas

The district is spelled the tape's way -- 07B, 07C, 08A -- where the G-10 file and PDQ write 7B, 7C, 8A. The August 2026 gas tape carries twelve districts and no 6E at all.

The four remark lines are gone: every one of the 42,133 rows carries the sentence 'GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.' in line_info_1 and nothing in the other three. The file is telling you where the remarks went.

Some discovery dates are impossible -- the earliest parses to the year 0028 -- so treat an implausible one as eight bad digits. 757 rows have no parseable date at all and carry disc_date_raw instead.

field_depth here is the SHALLOWEST perforation in the discovery well. The oil ledger's field record carries the deepest. Same column name in spirit, opposite meaning.

allocation is an encoded fifteen-digit formula, not a number, and is stored as text: three parts of a three-digit percentage and a two-digit factor code. total_forecast, print_as_is and cum_prod_error_sw are empty in every row.

Record layout

180 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_field 47 columns

This is the table you get when you download or query Gas Ledger.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text 2-4 DIST RRC district the field is in, as the ledger tape writes it: 01-06, 07B, 07C, 08, 08A, 09, 10, with the leading zero the W-10 and PDQ do not use. The August 2026 gas tape carries twelve districts and no 06E at all. e.g. 01 RRC district (proration ledger spelling)
2 field_no key join integer 5-12 PERM-FLD-ID The eight-digit RRC field number, five of field and three of reservoir. A gas field associated with an oil field usually shares its number, which is what field_type records. e.g. 256500 —
3 field_name text 32-63 FLD-NAME The field name RRC designated, usually an operator's word plus the formation and depth. 'WILDCAT' covers wells not in a designated field. e.g. A.W.P. (OLMOS) —
4 county_code_1 smallint 64-66 COUNTY(1) First of up to six county codes the field lies in, three digits. Zeros fill from the first empty slot onwards. —
5 county_code_2 smallint 67-69 COUNTY(2) Second county the field lies in, or 0. —
6 county_code_3 smallint 70-72 COUNTY(3) Third county the field lies in, or 0. —
7 county_code_4 smallint 73-75 COUNTY(4) Fourth county the field lies in, or 0. —
8 county_code_5 smallint 76-78 COUNTY(5) Fifth county the field lies in, or 0. —
9 county_code_6 smallint 79-81 COUNTY(6) Sixth county the field lies in, or 0. —
10 disc_date date 82-89 DISC-DATE Date the field's first gas well was completed. Null in 757 of 42,133 rows where the tape gave no month or day. Some parsed values are plainly wrong -- the earliest is in the year 0028 -- so treat an implausible discovery date as a bad eight digits rather than history. e.g. 1982-09-01 —
11 disc_date_raw integer 82-89 DISC-DATE The discovery date as the tape carried it, CCYYMMDD as an integer. The manual notes that a field known only to the year writes the year in the bytes reserved for the day. —
12 field_type text 90 TYPE-F Whether the gas field is associated with an oil field: A associated (10,287 rows), N not (31,846). Classification starts from the gas-oil ratio of the first well and can be changed at a hearing. e.g. A —
13 allow_class text 91 CLASS How the field's allowable is calculated: O one-well field (23,090 rows), S exempt (10,418), F 100% open flow (5,793), blank associated 49(b) (2,219), P prorated (455), K salvage (135), R storage, C cycling, L liquid limit. e.g. F —
14 allocation_code text 92 ALLO-CD Which allocation formula a prorated field uses; the formulas are in the manual's Appendix B. Blank on 41,685 of 42,133 fields, because only prorated fields have one. —
15 spacing_line smallint measured in ft 93-96 LINE-SP Minimum distance in feet a well must be from the nearest lease line. —
16 spacing_well smallint measured in ft 97-100 WELL-SP Minimum distance in feet between wells. —
17 net_allow_code smallint 101 NET-ALLO 1 where the field's wells are on a net allowable -- extra gas allowed because the associated oil field carries a net gas-oil ratio. 115 fields. —
18 bal_rule smallint 102 BAL-RULE Whether the field is under the balancing rule, which lets a gas well overproduce in a peak month and make it up later: 0 not balancing (41,626 rows), 1 regular balancing, 2 special balancing for a 49(b) field, 3 regular with underage carried. —
19 exempt_factor smallint 103 XMT-FACT For associated 49(b) fields only: 1 exempt from the statewide production factor, 0 subject to it. —
20 print_as_is smallint 104 PRINT-AS-IS 1 where the field allowable is set by hand rather than calculated by computer. Zero in every row of the August 2026 tape. —
21 col_head text 105 COL-HEAD Which column headings the field prints under on the proration schedule; the codes are in the manual's Appendix C. —
22 test_codes text 106-117 T-CODE Twelve one-character codes, one per month, saying what G-10 testing the field owes and when: B deliverability with flowing and shut-in wellhead pressure, C deliverability and flowing pressure, D adds potential (Panhandle), E adds bottom-hole pressure, F both, G deliverability only, J an annual test, K the commingling test. A field testing in January and July has codes in bytes 1 and 7. —
23 cum_gas_prod bigint measured in MCF 118-129 CUMU-PROD Cumulative gas production of the field in MCF before the months on this tape. The largest in the August 2026 set is 27.8 billion MCF. The manual warns the Commission verified this only to some extent. e.g. 395845596 —
24 cum_cond_prod bigint measured in bbl 130-139 CUMU-COND-PROD Cumulative condensate production of the field in barrels -- the liquid a gas well produces. Operator-reported and never verified by the Commission, in its own words. e.g. 7767375 —
25 unit_acres smallint measured in acres 140-143 UNIT-ACRES Acres that must be assigned to each proration unit in the field. Statewide Rule 37 is 40; a gas field rule commonly sets much more. —
26 unit_tol smallint measured in acres 144-146 UNIT-TOL Tolerance acres the field rules allow each well beyond the standard unit, for leases whose acreage does not divide exactly. —
27 allocation text 147-161 ALLOCTION The allocation formula as fifteen digits: three parts of a three-digit percentage and a two-digit factor code. Kept as text because it is an encoded formula and not a number -- '100190000000000' is 100% of factor 19. Present on every row; all zeros where the field is not prorated. e.g. 100190000000000 —
28 casing text 162-182 CASING Free-text casing requirement set by field rules or the state water authority to protect fresh water. Filled on 6,821 of 42,133 fields. —
29 diag_type text 183 DIAG-X 'X' when diag_info holds free-text comments about the diagonal rather than a footage. Blank on 36,906 fields. —
30 diag_info text 184-203 DIAG-INFO The diagonal of the proration unit in feet -- corner to corner -- or free text when diag_type is 'X'. Filled on 10,208 fields. —
31 field_depth integer measured in ft 204-208 FG-DEPTH Depth in feet of the shallowest perforation in the field's discovery well. Note it is the shallowest here and the deepest on the oil ledger's field record. e.g. 9446 —
32 wells smallint 209-212 WELLS Number of wells in the field that have been assigned an allowable, as of the last proration schedule. Non-zero on 4,826 fields; the largest is 3,409. e.g. 447 —
33 allow_calc integer measured in MCF 213-220 ALLOW-CALC The field's total allowable in MCF as the computer calculated it, rounded up to whole numbers -- which is why it usually differs from allow_desired. —
34 tol smallint measured in MCF 221-223 TOL The allowable tolerance in MCF per well: how far a well's allowable may deviate when the total is distributed. The standard is 1.5 MCF. Non-zero on ten fields. —
35 allow_desired integer measured in MCF 224-231 ALLOW-DESIRED The field's total allowable in MCF as the proration analyst set it from forecast and prior production. Non-zero on 110 fields. —
36 total_forecast integer 232-239 TOTAL-FORECAST Reserved for future use, in the manual's words. Zero in every row of the August 2026 tape. —
37 offshore smallint 240 OFFSHORE Where the field's discovery well sits: 0 land, 1 state bays and estuaries, 2 state offshore from islands, 3 federal, 4-9 combinations. Only 0, 1, 2 and 4 appear. —
38 field_transfer smallint 241 FLD-TRANS 1 where wells in the field may transfer their allowables to each other. Approval is uncommon: 47 fields. —
39 exempt_balance smallint 242 EX-BAL 1 where the field is exempt from balancing for this six-month period. True of 41,248 of 42,133 fields, which is the other side of bal_rule being 0 on almost all of them. —
40 exempt_gor smallint 243 EX-GOR 1 where the field has an exception to the statutory gas-well definition -- a gas-liquid ratio above 100,000 cubic feet per barrel. 151 fields. —
41 pending_spec_lmt_allow smallint 244 PENDING-SPEC-LMT-ALLOW The special limited allowable wells in the field will carry on the next schedule: 0 none, 1 special three-month monthly, 2 special one-month daily, 3 special three-month high daily. RRC internal. —
42 cum_prod_prior_70 bigint measured in MCF 245-256 CUMU-PROD-PRIOR-70 Cumulative gas production before 1970, in MCF, where RRC recorded it. Non-zero on 9,822 fields. —
43 cum_prod_error_sw text 257 CUMU-PROD-ERROR-SW A switch marking the cumulative production as known bad. Blank in every row of the August 2026 tape. —
44 line_info_1 text 303-368 LINE-INFO(1) The first of four field remark lines. Every one of the 42,133 rows holds the same sentence -- 'GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984.' -- which is the file telling you where the remarks went rather than a remark. e.g. GAS FIELD REMARKS REMOVED AS OF NOVEMBER, 1984. —
45 line_info_2 text 369-434 LINE-INFO(2) The second field remark line. Blank throughout the current tape. —
46 line_info_3 text 435-500 LINE-INFO(3) The third field remark line. Blank throughout. —
47 line_info_4 text 501-566 LINE-INFO(4) The fourth field remark line. Blank throughout. —

gas_ledger_field_month 16 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset — it is published separately as Gas Ledger — Field Months.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text 2-4 DIST RRC district of the field 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 PERM-FLD-ID The eight-digit field number this month belongs to. e.g. 256500 —
3 month_ordinal key smallint — — Which of the fourteen month slots in the field record this row came from, 1 to 14, oldest first. The tape rolls every cycle, so the ordinal is a position and not a date; cycle_yyyymm is the month. e.g. 14 —
4 cycle_yyyymm integer 583-588 FLD-DATE The schedule month this row is for, CCYYMM. The August 2026 tape runs 202506 to 202607 and every one of the 42,133 fields carries all fourteen. e.g. 202607 —
5 change smallint 589 F-CHANGE 1 when the field number changed this month. Zero in every row of the August 2026 tape. —
6 per_well_code smallint 590-591 PER-WELL-CD The per-well allocation factor code for fields with per-well in the formula; the codes are in the manual's Appendix B. —
7 per_well integer measured in MCF 592-595 PER-WELL The per-well allowable in MCF for a prorated field with per-well in its formula. Non-zero on 51 of 589,862 rows -- prorated gas fields are rare. —
8 acres_code smallint 596-597 AC-CD The acreage allocation factor code, one of 02, 03, 07-12 per the manual. —
9 acreage_factor numeric 598-605 ACRG-FACT The acreage factor amount, seven whole numbers and seven decimals. For a wildcat field it holds the number of days in the month instead, which is how a wildcat allowable is figured. —
10 other_code smallint 606-607 OTHER-CD The allocation factor code for a field using something other than per-well or acres. —
11 other_factor numeric 608-613 OTHER-FACT The amount of that other factor, with seven implied decimals. For a wildcat field it holds the monthly production factor. —
12 sw_split numeric 614-615 SW-SPLIT A second statewide production factor for the month, where one took effect mid-month. Zero throughout the August 2026 tape. —
13 split_date smallint 616-617 SPLIT-DATE Day of the month the second production factor took effect. Zero throughout. —
14 special_lmt_allow smallint 618 SPECIAL-LMT-ALLOW The type of special limited allowable assigned to wells in the field: 0 none, 1 special three-month monthly, 2 special one-month daily, 3 special three-month high daily. Non-zero on 501,161 of 589,862 rows, which makes it the most-used code in this table. e.g. 1 —
15 sw_exc_206_code smallint 619 SW-EXC-206-CODE 2 where House Bill 206 -- the rule against producing more than twice the allowable in a month -- was suspended for this month. Zero throughout the current tape. —
16 sw_exc_8609_limit smallint 620-621 SW-EXC-8609-LIMIT The statewide multiple of the monthly allowable that wells with an exception may produce: '04' is four times, '00' unlimited. Zero throughout the current tape. —

gas_ledger_well 70 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset — it is published separately as Gas Ledger — Wells.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text 2-4 W-DISTR RRC district the well is in, as the ledger tape writes it -- 07B, 07C, 08A with the leading zero, where the G-10 file and PDQ write 7B, 7C, 8A. e.g. 01 RRC district (proration ledger spelling)
2 field_no key join integer 5-12 W-PERM-FLD-ID The eight-digit RRC field number the well produces from. e.g. 2001 —
3 operator_no key join integer 13-18 OPER-ID P-5 organization number of the well's operator. e.g. 36043 —
4 gas_rrc_id key join integer 19-24 WELL-ID The gas well's six-digit RRC identification number, which uniquely identifies it statewide: 140,992 distinct values in 140,992 rows. PDQ carries the same number as lease_no for oil_gas_code = 'G', and the G-10 file as rrc_id. It changes if the well is worked over significantly. e.g. 273598 —
5 well_no text 26-31 WELL-NO The operator's well number -- tract, well number and suffix -- right-justified in six bytes, so 123,566 of the 140,992 rows carry leading blanks. Unlike the RRC id it survives a workover. e.g. ' 1H' —
6 lease_name text 32-63 LSE-NAME The lease name from Form P-4, up to 32 characters. Personal names are written last name first. e.g. WHITWORTH —
7 county_code smallint 64-66 CO-CODE Three-digit code of the county the well's perforations are in, which is not necessarily the county of its surface location. e.g. 323 —
8 well_type text 67 W-TYPE Current status: blank regular producing (98,548 rows), K shut-in and dead (30,628), J temporarily abandoned, R dry hole, sealed or non-producing, Z not eligible for an allowable, A abandoned, I injection, H shut-in but capable, D disposal, F no production for three months, N new, S shut-in pending connection, U shut-in awaiting connection. The tape also carries '(' on 5,146 wells, which GSA020K does not list. e.g. K —
9 gas_gatherer_old text 68-72 GAS-GATHER-OLD Five-character code of the gatherer that moved the well's gas before the present one. —
10 gas_gatherer text 73-77 G-GATH Five-character code of the well's present main gas gatherer. Set on 132,873 of 140,992 wells; the company's name is in the operator directory. e.g. TXPLL —
11 full_stream text 78 FULL-S 'X' when the gas goes full stream into a pipeline. 5,379 wells. —
12 gas_split text 79 GAS-SPLIT 'X' when the well has more than one gas gatherer, in which case gas_gatherer_2 and gas_gatherer_3 name them. 7,697 wells. —
13 gas_gatherer_2 text 80-84 GASGATH2I Second gas gatherer, where gas_split is set. —
14 gas_gatherer_3 text 85-89 GASGATH3I Third gas gatherer, where one exists. —
15 liq_gatherer_old text 90-94 LIQ-GATHER-OLD Five-character code of the previous gatherer of the well's condensate. —
16 liq_gatherer text 95-99 L-GATH Five-character code of the well's present condensate gatherer, or the main one where there is more than one. Set on 108,489 wells. —
17 liq_split text 100 LIQ-SPLIT 'X' when the well has more than one condensate gatherer. 26,633 wells. —
18 well_info text 101-122 WELL-INFO Twenty-two characters of remarks about the well from a proration analyst. Set on 7,396 wells. —
19 batch_no text 123 BATCH-NR RRC's internal batch letter for a bundle of P-2 gas production reports. —
20 exc_14b text 124 EXC-14B Why a well with no allowable has not been plugged: 0 no exception (95,203 rows), 1 exception to Statewide Rule 14(B)(2) in effect (29,662), 4 denied, B the inactive side of a multiple completion, P partially plugged, L a legal restriction, U a UIC restriction, and the older 2, 3, 5-9 that RRC stopped using in 1990. The tape also carries 'H' on 3,836 wells (an H-15 violation) and '(' on 5,146, neither of which GSA020K lists. —
21 ex14b_date date 125-132 14B-DATE Date the well's 14(B)(2) exception expires. Empty in every row of the tape fetched in August 2026, even on the 29,662 wells whose exception is in effect. —
22 completion_date date 133-140 CMP-DATE Date the well was completed -- made ready to produce. Present on 135,576 of 140,992 wells. The range runs from a 1900-01-03 placeholder to 2070, so a date outside living memory in either direction is a bad eight digits. e.g. 2013-02-16 —
23 depth integer measured in ft 141-145 W-DEPTH Total depth the well was drilled to, in feet. The deepest here is 26,160. e.g. 5940 —
24 upper_perf integer measured in ft 146-150 UP-PERF Depth in feet of the highest perforation in the completion. —
25 lower_perf integer measured in ft 151-155 LO-PERF Depth in feet of the lowest perforation in the completion. —
26 commingle_code smallint 156 COMMCD Status of the well's commingling permit: 0 not used (74,379 rows), 1 in effect (59,439), 2 terminated, 4-6 the permit-number changes. —
27 commingle_no smallint 157-160 COMM The commingling permit number, or one of RRC's codes: 8888 gas plant, 9696 gas metering, 9595 lease automatic custody transfer. Gas wells only ever commingle under those three. —
28 commingle_date date 161-168 COMN-DTE Date the commingling permit was granted. Set on 66,151 wells. —
29 dpt_code text 169 DPT-CODE Whether the well is excused the G-10 daily production test: 0 regular (108,158 rows), 1 no test necessary, 2 use the G-1 deliverability, 3 use the P-2 production, 4 use the average of four nearby wells, 5 exempt because deliverability is under 100 MCF (30,911). —
30 bhp_code text 170 BHP-CODE Whether the well is excused the G-10 bottom-hole pressure test where field rules require one. 0 regular on all but 155 wells. —
31 sip_code text 171 SIP-CODE Whether the well is excused the G-10 shut-in pressure test: 0 regular (103,502 rows), 1 no test necessary (35,567). —
32 g4_code text 172 G-4-CODE Whether the well is excused the G-10 potential test. Zero -- regular -- in every row of the August 2026 tape. —
33 exc_test text 173 WL-TSTX The well's exception to G-10 testing: 0 none (90,715 rows), 1 no G-10 testing required (31,498), 2 no commingle test, 4 a temporary exception for a new well, 5 and 6 lease automatic custody transfer. The tape also carries 7 on 11,616 wells, which the manual does not list. —
34 g10_due smallint 174-175 G-10-DUE The month the well's next G-10 becomes effective on the schedule. The operator gets three months to test; results are due on the first of the fourth month and effective on the first of the fifth. e.g. 1 —
35 date_last_utilized date 176-183 DTE-L-UTL Date the well was last used. Set on seven wells in the whole August 2026 tape, so read its absence as 'not recorded' rather than 'still producing'. —
36 pa_code smallint 184 WL-PA-CD Why the well left the gas schedule: 4 plugged and abandoned (1,198 rows), 5 worked over to another zone, 6 reclassified to oil, 7 exempt from Statewide Rule 10, 8 a disposal or holding status, 9 plugged and abandoned with no ledger comment (1,002). —
37 pa_date date 185-192 P-A-DATE Date the well was removed from the gas proration schedule. Set on 1,258 wells. —
38 special_allow integer measured in MCF 193-199 SP-ALLOW The amount of the special allowable the Commission assigned the well, in MCF. Non-zero on 62,466 wells. —
39 special_allow_code text 200 SP-AL-CODE What kind of special allowable: blank an associated 49(b) daily rate, C non-hearing daily (57,871 rows), H granted by hearing, D granted by Commission action daily, S monthly, L reduced at the operator's request, P based on the third prior month's production, X exempt, A like D with underage carried, E a Rule 28/29 exception. —
40 liq_allow integer measured in bbl 201-205 LIQ-ALLOW The condensate allowable assigned to the well, in barrels, in fields that have one. Non-zero on 56 wells. —
41 liq_allow_code smallint 206 LIQ-ALLOW-CODE What kind of condensate allowable: 0 none, 3 a limit subject to the oil production factor, 4 a daily limit, 5 a monthly limit. —
42 form_lacking smallint 207 FORM-LACKING Why an allowable is being withheld: 0 nothing lacking (127,318 rows), 1 another form, 2 a delinquent G-10, 3 an incomplete G-10, 4 no production, 5 plugged but still filing P-2s for condensate (1,097), 6 a delinquent P-2. —
43 offshore smallint 208 OFF-SHORE Where the well is: 0 land, 1 state bays and estuaries, 2 state offshore from islands, 3 federal, 4-9 combinations. In practice only 0, 1 and 2 are used. —
44 top_pct numeric 209-213 WL-TOP-PER The percentage of the field's total deliverability this well contributes, three whole numbers and two decimals. Non-zero on 10,123 wells. —
45 royalty_code smallint 214 ROYALTY-CODE Whether the well is on a state lease: 0 not (140,005 rows), 1 school land, 2 university, 3 another state fund. —
46 prior_rinu integer 215-219 PRIOR-RINU Underproduction that had been cancelled and was reinstated at a hearing, for the balancing period before the current one, in MCF. —
47 prior_rinu_yyyymm integer 220-225 PRIOR-RINU-DATE Month that reinstated underage was added to the balance, CCYYMM. —
48 rinu integer 226-230 RINU Underproduction cancelled and then reinstated at a hearing, for the current balancing period, in MCF. —
49 rinu_yyyymm integer 231-236 RINU-DATE Month the current reinstated underage was added to the balance, CCYYMM. —
50 ex14b2_type text 237 EXC-14B2-TYPE How the well's 14(B)(2) exception is covered: B blanket bond, M mini-bond, S single lease, R secondary recovery project, W a W-1X, N none. '0' in every row of the August 2026 tape, which is none of those. —
51 g1_date date 239-246 G-1-DATE Date of the open-flow potential test on the G-1 filed when the well was completed. Present on 127,614 wells. —
52 open_flow integer measured in MCF 247-250 OPEN-FLO The well's G-1 open-flow potential in MCF, from the back-pressure test at completion. Null where the tape carried all nines, which is RRC's 'not reported' -- and that is most of the file: only 43,613 of 140,992 wells have a value. —
53 slope numeric 251-253 SLOPE Slope of the line through the four-point back-pressure test that determines the well's potential, one whole number and four decimals. Non-zero on 9,927 wells. —
54 ratio integer measured in cf/bbl 254-256 RATIO The well's gas-liquid ratio in cubic feet per barrel. The statutory line between a gas well and an oil well is 100,000; the column's maximum here is 99,999, which is the largest five digits will hold rather than a measurement. —
55 gas_gravity numeric 257-258 G-GRAV Specific gravity of the well's gas, air = 1, to three decimals. Stored scaled; the tape wrote it packed with the point implied. —
56 oil_gravity numeric measured in API 259-260 O-GRAV API gravity of the well's condensate, two whole numbers and one decimal. Stored scaled. —
57 beg_gas_status integer measured in MCF 261-265 BGS The well's gas balancing status in MCF before the fourteen months on this tape. Non-zero on 4,858 wells -- balancing applies to a small minority. —
58 beg_liq_status integer measured in bbl 266-270 BLS The well's condensate status in barrels before the fourteen months on this tape. —
59 prior_6 integer measured in MCF 271-275 PRIOR-6 The well's balance at the end of the previous six-month balancing period, in MCF, for wells under the balancing rule. —
60 prior_cancelled_underage integer measured in MCF 276-279 PCU Underproduction cancelled when the previous six-month balance was struck, in MCF. —
61 curr_bal integer measured in MCF 280-284 CURR-BAL The well's balance for the current six-month balancing period, in MCF. —
62 cancelled_underage integer measured in MCF 285-288 CANCEL-G Underproduction cancelled when the current six-month balance was struck, in MCF. —
63 gas_status integer measured in MCF 289-293 G-STATUS Cumulative gas production status as of the last reported period, in MCF. Meaningful only for a well under the balancing rule. —
64 liq_status integer measured in bbl 294-297 L-STATUS Cumulative condensate status as of the last reported period, in barrels. Used only for wells on a liquid limit allowable. —
65 lmt_allow integer measured in MCF 298-301 LMT-ALLOW The well's '@' limited allowable in MCF -- assigned after it underproduced through two consecutive balancing periods. Null where the tape carried all nines, meaning no limit, which is 137,984 of 140,992 wells. —
66 si_amt integer measured in MCF 302-306 SI-AMT Overproduction a shut-in well must make up, in MCF. Zero in every row of the August 2026 tape. —
67 si_code smallint 307 SI-CODE Why the well was shut in: 1 House Bill 206, 2 balancing, 3 liquid balancing. Zero in every row of the current tape. —
68 exc_prod_limit_code smallint 308 EXCEPTION-TO-PROD-LIMIT-CODE Length of an exception to the well's production limit: 1, 2 or 3 months. Zero in every row of the current tape. —
69 exc_prod_limit integer measured in MCF/d 309-312 EXCEPTION-TO-PROD-LIMIT The daily amount allowed under that exception, in MCF, calculated from a G-10. Zero throughout the current tape. —
70 ex14b2_app_no integer 313-316 EXC-14B2-APP-NO Application number of the well's 14(B)(2) coverage, RRC's key into its own exception database. Zero in every row of the current tape. —

gas_ledger_well_month 47 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset — it is published separately as Gas Ledger — Well Months.

# 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, district, district, 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 joins to Gas Ledger — Field Months on District and Field number — one row here matches many rows there.

has fourteen months of allocation factors

The FLD-MONTH group of the gas field record. All 5,000 sampled fields carry all fourteen months.

gas-ledger.district = gas-ledger-field-months.district AND gas-ledger.field_no = gas-ledger-field-months.field_no

Gas Ledger joins to Gas Ledger — Wells on District and Field number — one row here matches many rows there.

contains the gas wells

The WELL records that follow a gas field record on the tape. 1,243 of 5,000 sampled fields have any: the gas ledger registers far more fields than currently have a scheduled well.

gas-ledger.district = gas-ledger-wells.district AND gas-ledger.field_no = gas-ledger-wells.field_no

Gas Ledger joins to PDQ Field Directory on Field number — one row here matches one row there.

is the field

The gas ledger's field number resolved to the field directory for its name and class. All 5,000 sampled gas field records match. These two columns are different types — one is text, the other an integer — so a direct equality is rejected by Postgres. Cast the text side to integer, which also disposes of any leading zeros; casting the integer to text would not, because '000123' and 123 are not equal as text.

gas-ledger.field_no = pdq-field-directory.field_no

Gas Ledger joins to Oil Ledger on District and Field number — one row here matches one row there.

is the gas half of the oil field

A gas field associated with an oil field usually carries the same field number, so the two ledgers meet on it. 1,198 of 5,000 sampled gas fields have an oil ledger record with the same district and number -- close to the 10,287 of 42,133 the gas tape itself marks field_type = 'A' for association. Both sides spell the district the same way, so nothing needs normalising here.

gas-ledger.district = oil-ledger.district AND gas-ledger.field_no = oil-ledger.field_no

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. Available by the 20th.)
RRC download link
GoAnywhere MFT
Record layout manual
Our table
texas.gas_ledger_field

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.

Written about this dataset

  • The RRC oil and gas ledgers (and why PDQ is usually what you want) The oil ledger, the gas ledger, the historical ledgers and the statewide production files are the Commission's mainframe view of production and allowables. Here is what each holds, why they arrive as EBCDIC packed decimal, which questions only they can answer, and why for almost everything else the PDQ tables are the better download. 7 min

Also in Production Data