Get the data

Heads up on Original: the Commission does not publish this table on its own. It publishes Statewide Field Data, 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 02 GASSEG segment of the statewide field tape, one row for each of the 42,133 fields carried on the gas schedule. It holds the field's gas discovery date, county and perforation depth, which county's cycle it tests on and how often, what its G-10 must report, whether it is exempt from the minimum gas-oil ratio, whether it sits on land or in the bays, and sixteen cumulative totals of gas, condensate and their allowables.

Those totals are the field's whole production life, in four eras the manual is careful to keep apart: everything to December 1982 in one lump from the conversion to this system, everything from January 1983 up to the months still on the tape, the latest 24 months, and the year to date.

What you can do with it

Rank fields by cumulative gas or condensate, or by what they have produced in the last two years.

Find the gas fields in a county, the ones discovered in a decade, the ones exempt from the minimum GOR, and the ones sitting in state waters.

See when a field first appeared on the gas proration schedule and when RRC approved it as a new field.

Gotchas

The four cumulative families do not add up to one another and must not be summed together. The conversion totals exclude retro P-2 reports; the off-file totals include them; the on-file totals stop two months short so they can be compared with production.

Eight discovery dates decode to a year before 1900 — 0028, 0048, 0052 — which is what the tape's own digits say rather than a parse error: a two-digit year that never got a century. The column is otherwise filled on 41,376 of 42,133 fields.

ledger_month is a property of the tape rather than of the field: every row of the August 2026 file says 6.

The liquid allowable columns are effectively dead — non-zero on six or seven fields, zero everywhere else.

County codes here are SMALLINTs (3, not '003'), so pad before joining them to a county list.

Record layout

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

`fl_gas_field` 40 columns

Record layout for `fl_gas_field` — 40 columns, with byte positions
#	Column	Type	Bytes	RRC name	Meaning	Lookup
1	`district_no` key join	text	—	`FL-DISTRICT`	RRC district as the FL tape stores it, 01 to 14 — the INTERNAL number, not the designation the industry prints. 07 is District 6E, 08 is 7B, 09 is 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10. This is the same numbering PDQ calls district_no, so the two join directly; the printed form is on fl_field.district_name. Code 12 (District 8B) is reserved and no field carries it. e.g. 09	RRC district (internal number)
2	`field_no` key join	integer	—	`FL-NUMBER`	The eight-digit RRC field number: five digits of field, then three of reservoir. Stored as an INTEGER, so the leading zeros are gone — 6,529 of the 65,826 fields have one. Pad it back before joining to PDQ or the Oracle field rules, which key on it as eight characters: lpad(field_no::text, 8, '0'). Padded, all 65,826 fields resolve to the PDQ field directory; unpadded, 59,297 do. e.g. 85279200	—
3	`disc_date`	date	4-11	`FL-GAS-DISC-DATE-1ST-WELL`	Discovery date of the field's first gas well, CCYYMMDD. Filled on 41,376 of the 42,133 gas fields. Eight of them decode to a year before 1900 — 0028, 0048, 0052 — which is what the tape's own digits say rather than a parse error: a two-digit year the mainframe never got a century for. Trim the tail before charting discoveries by year. e.g. 1904-12-31	—
4	`disc_county_code`	smallint	12-14	`FL-GAS-DISC-COUNTY-CODE`	Three-digit RRC county code the field was discovered in. Zero where the mainframe never recorded one. Stored as a SMALLINT, so pad it back to three digits before joining to a county list. e.g. 383	—
5	`perf_1st_well`	integer measured in ft	15-19	`FL-GAS-PERF-1ST-WELL`	Depth in feet at which the discovery well was perforated — the closest thing this file has to a field depth. e.g. 6785	—
6	`type_field_code`	text	20	`FL-TYPE-FIELD-CODE`	'A' associated with an oil field, 'N' non-associated. The manual says the item is no longer maintained; the tape still carries 34,600 N and 7,533 A. e.g. A	—
7	`testing_county`	smallint	29-31	`FL-GAS-TESTING-COUNTY`	County whose testing cycle this field tests on, as a three-digit code. Statewide rule 53 puts every field on a county's cycle, and it is not always the county the field is in.	—
8	`test_frequency`	text	32	`FL-GAS-TEST-FREQUENCY`	'A' annual or 'S' semi-annual G-10 testing. 39,374 fields test semi-annually. e.g. A	—
9	`pri_test_month`	smallint	33-34	`FL-GAS-PRI-ALTER-TEST-MONTH`	Alternate primary testing month, 01-12, where the field does not test with its test county's cycle. Zero means it does.	—
10	`sec_test_month`	smallint	35-36	`FL-GAS-SEC-ALTER-TEST-MONTH`	Alternate secondary testing month for a semi-annual field, 01-12. Zero means it tests with the county.	—
11	`pri_test_g10_required`	text	37	`FL-PRI-TEST-MON-G10-REQUIRE`	What the G-10 must report in the primary test month: 'B' deliverability, flowing and shut-in wellhead pressure; 'C' deliverability and flowing pressure; 'D' adds potential; 'E' adds bottom-hole pressure; 'F' both; 'G' deliverability only; 'J' annual testing; 'K' a commingling test. Every gas well reports gas gravity whatever the code. e.g. J	—
12	`sec_test_g10_required`	text	38	`FL-SEC-TEST-MON-G10-REQUIRE`	The same code list for the secondary test month. 'K' — the commingling test — is what an annually tested field carries here. e.g. K	—
13	`commingling_counter`	integer	41-45	`FL-GAS-COMMINGLING-COUNTER`	Number of wells commingled above ground in the field. The manual says it is not maintained, and 41,000 of the 42,133 rows are zero.	—
14	`exempt_min_gor`	text	46	`FL-GAS-EXEMPT-MINIMUM-GOR`	'Y' on the 151 fields exempt from the minimum gas-oil ratio, which may produce more than one barrel of condensate per 100,000 cubic feet of gas without being reclassified as oil wells.	—
15	`offshore_code`	text	47-48	`FL-OFFSHORE-CODE`	Where the field's discovery well sits: 'L' land (40,823 fields), 'B' bays and estuaries, 'SO' state offshore, 'LB' land and bays, 'BO' bays and offshore, 'AL' all three, 'SF' state and federal. e.g. L	—
16	`cum_gas_prod_to_conv`	bigint measured in MCF	50-56	`FL-CUM-GAS-PRODUCTION-TO-CONV`	Cumulative gas well gas produced from 1970 to December 1982, in MCF: the lump sum the old tapes carried into the FL system at conversion. It does NOT include retro P-2 reports filed twelve months or more late. e.g. 1217098	—
17	`cum_cond_prod_to_conv`	bigint measured in bbl	57-62	`FL-CUM-COND-PRODUCTION-TO-CONV`	Cumulative condensate produced from 1970 to December 1982, in barrels: the lump sum the old tapes carried into the FL system at conversion. It does NOT include retro P-2 reports filed twelve months or more late.	—
18	`cum_gas_allow_to_conv`	bigint measured in MCF	63-69	`FL-CUM-GAS-ALLOWABLE-TO-CONV`	Cumulative gas allowable from 1970 to December 1982, in MCF: the lump sum the old tapes carried into the FL system at conversion. It does NOT include retro P-2 reports filed twelve months or more late.	—
19	`cum_liq_allow_to_conv`	bigint measured in bbl	70-76	`FL-CUM-LIQ-ALLOWABLE-TO-CONV`	Cumulative liquid allowable from 1970 to December 1982, in barrels: the lump sum the old tapes carried into the FL system at conversion. It does NOT include retro P-2 reports filed twelve months or more late. Non-zero on seven fields only.	—
20	`off_file_cum_gas_allow`	bigint measured in MCF	77-83	`FL-OFF-FILE-CUM-GAS-ALLOWABLE`	Cumulative gas allowable in MCF from January 1983 up to the months still on the tape. Anything earlier is in the conversion total.	—
21	`off_file_cum_liq_allow`	bigint measured in bbl	84-90	`FL-OFF-FILE-CUM-LIQ-ALLOWABLE`	Cumulative liquid allowable in barrels from January 1983 up to the months still on the tape. Anything earlier is in the conversion total. Non-zero on six fields only.	—
22	`off_file_cum_gas_prod`	bigint measured in MCF	91-97	`FL-OFF-FILE-CUM-GAS-PROD`	Cumulative gas well gas production in MCF from January 1983 up to the months still on the tape. Anything earlier is in the conversion total. Kept apart from the conversion total because it DOES include every retro P-2 filed.	—
23	`off_file_cum_cond_prod`	bigint measured in bbl	98-103	`FL-OFF-FILE-CUM-COND-PROD`	Cumulative condensate production in barrels from January 1983 up to the months still on the tape. Anything earlier is in the conversion total. Includes retro P-2 reports.	—
24	`on_file_cum_gas_allow`	bigint measured in MCF	104-110	`FL-ON-FILE-CUM-GAS-ALLOWABLE`	The latest 24 months of gas allowable, in MCF. Production reporting lags allowable assignment by about two months, so this total stops two months short and can be compared directly with its opposite number.	—
25	`on_file_cum_liq_allow`	bigint measured in bbl	111-117	`FL-ON-FILE-CUM-LIQ-ALLOWABLE`	The latest 24 months of liquid allowable, in barrels. Production reporting lags allowable assignment by about two months, so this total stops two months short and can be compared directly with its opposite number. Zero in every row.	—
26	`on_file_cum_gas_prod`	bigint measured in MCF	118-124	`FL-ON-FILE-CUM-GAS-PROD`	The latest 24 months of reported gas well gas production, in MCF. Production reporting lags allowable assignment by about two months, so this total stops two months short and can be compared directly with its opposite number.	—
27	`on_file_cum_cond_prod`	bigint measured in bbl	125-130	`FL-ON-FILE-CUM-COND-PROD`	The latest 24 months of reported condensate production, in barrels. Production reporting lags allowable assignment by about two months, so this total stops two months short and can be compared directly with its opposite number.	—
28	`ytd_cum_gas_allow`	bigint measured in MCF	131-136	`FL-YR-TO-DT-CUM-GAS-ALLOWABLE`	Gas allowable so far this calendar year, in MCF. The latest two months are not in it, for the same reporting lag.	—
29	`ytd_cum_liq_allow`	bigint measured in bbl	137-142	`FL-YR-TO-DT-CUM-LIQ-ALLOWABLE`	Liquid allowable so far this calendar year, in barrels. The latest two months are not in it, for the same reporting lag. Zero in every row.	—
30	`ytd_cum_gas_prod`	bigint measured in MCF	143-148	`FL-YR-TO-DT-CUM-GAS-PROD`	Reported gas well gas production so far this calendar year, in MCF. The latest two months are not in it, for the same reporting lag.	—
31	`ytd_cum_cond_prod`	bigint measured in bbl	149-154	`FL-YR-TO-DT-CUM-COND-PROD`	Reported condensate production so far this calendar year, in barrels. The latest two months are not in it, for the same reporting lag.	—
32	`salt_dome_exemption`	text	155	`FL-SALT-DOME-EXEMPTION`	'Y' on the 69 gas fields classified as salt domes, which the statewide spacing rule does not apply to.	—
33	`county_regular_exemption`	text	156	`FL-COUNTY-REGULAR-EXEMPTION`	'Y' on the 3,333 fields exempt as county regular — the small shallow fields of Districts 7B and 09 and McCulloch County, which have their own spacing rules and allowable schedule.	—
34	`ledger_month`	smallint	157-158	`FL-LEDGER-MONTH`	The current ledger month: the most recent month RRC has production reports for. RRC-internal, and a property of the tape rather than of the field — every row of the August 2026 file says 6.	—
35	`new_gas_field_appr_date`	date	159-166	`FL-NEW-GAS-FLD-APPR-DATE`	Date the Commission approved the field as a new gas field, CCYYMMDD. Filled on 7,408 fields.	—
36	`cum_prod_prior_1970`	bigint measured in MCF	167-173	`FL-CUM-PROD-PRIOR-1970`	Everything the field produced before 1970, in MCF, as one lump sum. Zero or absent on the fields discovered since.	—
37	`schedule_start_date`	date	174-181	`FL-GAS-SCHEDULE-START-DATE`	When the field first appeared on the gas proration schedule, CCYYMMDD. Filled on 7,016 fields, 1945 onwards.	—
38	`consolidated_field_flag`	text	182	`FL-GAS-CONSOLIDATED-FIELD-FLAG`	'Y' where this field is a consolidation of earlier ones. 4,553 fields.	—
39	`correlative_interval_from`	integer measured in ft	183-187	`FL-GAS-CORRELATIVE-INTER-FROM`	Top of the correlative interval in feet — the depth window the field's rules apply to. Filled on 602 fields. e.g. 6865	—
40	`correlative_interval_to`	integer measured in ft	188-192	`FL-GAS-CORRELATIVE-INTER-TO`	Bottom of the correlative interval, in feet. Filled on the same 602 fields. e.g. 10605	—

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

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.

Field Gas Information joins to Statewide Field Data on District number and Field number — one row here matches one row there.

is the gas segment of

The gas half of a field's master record, back to the root. All 42,133 gas segments resolve, and no field has two.

statewide-field-gas-information.district_no = statewide-field-data.district_no AND statewide-field-gas-information.field_no = statewide-field-data.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 27th.)

RRC download link

GoAnywhere MFT

Record layout manual

OGA090 — Field Information — Record Layout

Our table

texas.fl_gas_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.