EZRRC
Cart Sign in

R-3 Gas Processing Plants (EBCDIC, retired)

Queryable EBCDIC

Every gas plant Texas has known since 1912, and the last two years of R-3 forms. Frozen 2025-08-25.

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

GRA001, the original EBCDIC R-3 extract. RRC retired it on 2025-08-25 and now publishes the same reporting as the JSON dataload beside this entry — but the tape is the only place the history exists, so it is parsed and queryable here rather than sitting as 62 MB of packed decimal — 147,105 records of exactly 422 bytes.

7,183 plants, with their operator, county, type, capacity and the months of their first and last R-3 — a series that starts in 1912 and ends in July 2025. 31,809 remarks hang off them. For the last two years of cycles (2023-08 to 2025-08) it also carries the R-3 form as filed: 29,586 report cycles with intake, disposition of unprocessed gas, residue disposition, sulfur and CO2, liquid production, drip recovery, the barrel balance, detail deliveries and remarks.

RETIRED means retired: RRC will not refresh this file again, and the JSON successor is where new filings arrive. What is here is frozen at 2025-08, which for a historical series is the point.

What you can do with it

Filter the plants by district, county, operator, type, capacity or the month they last filed, and export them with all eleven child tables — the remarks, the report cycles and the seven form sections.

Recover gas plant reporting from before the JSON release began, trace one plant across the 2025 changeover on its printed id, or take the whole list of Texas gas plants with their operators: all 7,138 that carry an operator number resolve in the operator directory.

Gotchas

Retired. RRC no longer refreshes it, so everything here is frozen at 2025-08-25 and the freshness badge will only get older. New R-3 filings are in the JSON dataset beside this one.

The tape keys on RRC's INTERNAL district number, not the printed one: 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09, 14 is District 10. A filter for '08' on the key column returns District 7B. The District filter on this page uses the derived printed code, which is what you want; the internal number is offered separately and labelled as such.

Only the last two years of cycles are on the tape. 7,183 plants have a root record but only 1,756 have any cycle at all and 683 have a Section I, because RRC keeps a rolling window of forms and the plant master forever. A plant with no cycle is not an error.

Section VII's seven per-product columns are ZERO on all 282,600 rows. The manual says so in as many words — "only totals are stored for Section VII" — and the tape carries the columns without ever filling them. Read `total`; the per-product split exists on the paper form and, from 2025-09, in the JSON successor.

texas.r3_r7_pressure is EMPTY. The final tape carries no type-12 record at all, so the R-7 pressure-maintenance table is exported with zero rows. It is published rather than dropped because the segment is declared upstream and a type 12 would decode; the tape being retired means it will stay empty.

Three more things the tape declares and never fills: Section VIII's two totals (the manual says the section is "not used at this time"), both C-1 monthly volumes, and the discrepancy-letter date. All zero or null on all 29,586 cycles.

Two columns need naming carefully. plant_fields is fifty characters of prose — 'JOURDANTON, IMOGENE & CHARLOTTE', 'VARIOUS' — and not field numbers, so it joins to nothing. Section VI's source_name and Section X's delivered_to are likewise names as the filer typed them, not lease or operator keys.

line_no 0 on Sections VI and X means the section was filed with nothing on it: 516 of 1,066 drip rows and 7,282 of 16,719 delivery rows, all of them empty.

Record layout

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

r3_plant 20 columns

This is the table you get when you download or query R-3 Gas Processing Plants (EBCDIC, retired).

# Column Type Bytes RRC name Meaning Lookup
1 district key join text 3-4 GR-DISTRICT The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. e.g. 09 RRC district (internal number)
2 serial_no key join smallint 5-8 GR-SERIAL-NUMBER The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. e.g. 22 —
3 district_code join text — — The district as RRC prints it -- 01-06, 7B, 7C, 08, 8A, 09, 10 -- derived by EZRRC from the tape's internal number. Null on the 46 roots whose internal number is 20, which no conversion table covers. This is the spelling every other RRC product uses, including the JSON successor. e.g. 7C RRC district (printed designation)
4 plant_id join text — — The plant id RRC prints and every other product uses: the district designation, a hyphen and the four-digit serial, '7C-0286'. EZRRC derives it from the two key columns; the tape carries only the subscript and the serial. Null on the 46 roots whose subscript is 20, which is in no conversion table -- those records are otherwise empty and look like reserved rows. This is the column that joins the tape to the JSON successor, where it is called `serial_number`. e.g. 7C-0022 —
5 operator_no join integer 9-14 GR-OPERATOR-NUMBER The P-5 organization number of the plant operator. Every one of the 7,138 plants that carries one resolves in the operator directory, over 1,825 distinct organizations. 45 roots hold zero, which is the tape's way of writing 'none'. e.g. 195959 —
6 county_code join smallint 15-17 GR-COUNTY The three-digit RRC county code as a whole number, so Andrews is 3 and not '003'. 209 distinct counties appear; 45 roots hold zero. Zero-pad it to three characters to join the county directory, which all 7,138 non-zero plants then match. e.g. 105 —
7 plant_name text 18-49 GR-PLANT-NAME The plant's name as RRC carries it, up to 32 characters -- 'JOURDANTON GAS PLANT', 'SOUTHWEST OZONA'. Not unique: several plants in District 01 are called 'FASHING'. e.g. SOUTHWEST OZONA —
8 plant_type text 50 GR-PLANT-TYPE What kind of plant: G natural gasoline (987), O other (6,111), C cycling (21), P pressure maintenance (19). 45 roots carry nothing. 'Other' dominating is not an error -- most of the 7,183 records are compressor and drip stations rather than processing plants. e.g. G —
9 avg_intake_capacity integer measured in MCF/d 56-62 GR-PLANT-AVG-INTAKE-CAPACITY The plant's average intake capacity in MCF per day, as reported. Zero on 4,827 of the 7,183 records, which for a drip station is a fact rather than a gap. The largest on the tape is 5,500,000 (DOS PICOS GAS PLANT, 08-3989). e.g. 3036200 —
10 offshore text 63 GR-PLANT-OFFSHORE-INDICATOR 'Y' on exactly one plant in the whole file and 'N' on the other 7,137. Not a column to filter Texas offshore activity by. e.g. N —
11 phone_area_code text 64-66 GR-PLANT-TELE-AREA-CODE The area code of the plant's contact telephone number, as three separate columns on the tape. Filled on all 7,183 records, which for a plant that last filed in the 1980s means a number nobody answers. —
12 phone_prefix text 67-69 GR-PLANT-TELE-PREFIX The exchange of the plant's contact telephone number, as three separate columns on the tape. Filled on all 7,183 records, which for a plant that last filed in the 1980s means a number nobody answers. —
13 phone_suffix text 70-73 GR-PLANT-TELE-SUFFIX The line number of the plant's contact telephone number, as three separate columns on the tape. Filled on all 7,183 records, which for a plant that last filed in the 1980s means a number nobody answers. —
14 plant_fields text 74-123 GR-PLANT-FIELDS Fifty characters of free text naming the fields the plant takes gas from -- 'JOURDANTON, IMOGENE & CHARLOTTE', or 'VARIOUS', or 'N/A'. Prose, not field numbers: there is no key in here and it cannot be joined to the field directory. Filled on 5,769 of the 7,183 records. e.g. VARIOUS —
15 r3_yyyymm integer 124-129 GR-R3-DATE The month of the plant's FIRST R-3 filing, as one YYYYMM integer. The series runs 1912-02 to 2025-07; two records predate 1950, which the manual's own history does not explain. Null on 437. e.g. 196101 —
16 r5_yyyymm integer 130-135 GR-R5-DATE The month of the plant's R-5 (plant permit application), as one YYYYMM integer. Null where no R-5 was filed. e.g. 200207 —
17 r5_status text 136 GR-R5-STATUS What became of the R-5: F final (4,954), A approved (221), D denied (1). Blank on 1,998 where none was filed, and '0' on 9 records, which the manual does not document. e.g. F —
18 last_r3_yyyymm integer 137-142 GR-LAST-R3-REPORT-FILED-DATE The month of the plant's LAST R-3 filing, as one YYYYMM integer, and the fastest way to tell a live plant from a closed one. Null on 757 records. Two rows carry a month past 2026 -- 2083-02 is the highest -- which is a keying error at RRC, not a decode fault. e.g. 202401 —
19 delinquent_letter_date date 143-150 GR-R3-DELINQUENT-LTR-DATE When RRC last sent this plant a delinquency letter for a missing R-3. Present on 883 of the 7,183 plants, from 2002-02-06 to 2025-03-24. —
20 letter_type smallint 151 GR-R3-LETTER-TYPE Which delinquency letter: 3, 6 and 9 are the 30-, 60- and 90-day letters, 0 means none was sent. The file also holds '1' on 472 records, which the manual does not document. The manual prints position 136 for this item, for the FILLER after it and for GR-R5-STATUS -- three fields at one byte, which cannot be. It is at 151, where the byte holds exactly 0/1/3/6/9. e.g. 0 —

r3_cycle 15 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text — — The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. e.g. 14 RRC district (internal number)
2 serial_no key join smallint — — The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. e.g. 1330 —
3 cycle_yyyymm key join integer 3-6 GR-CYCLE-KEY The month this report is for, as one YYYYMM integer: 202508 is August 2025. The tape writes it as four digits (YYMM) with a century pivot at 70, and the loader expands it. The final tape carries 25 cycles, 2023-08 through 2025-08 -- RRC retired the file on 2025-08-25 and there will be no 26th. e.g. 202507 —
4 sec6_gas_well_total integer 7-10 GR-R3-SEC-VI-GAS-WELL-TOT Section VI total: gas wells whose drip or scrubber recovery this cycle carries. The per-source detail is in r3_section6_drip. —
5 sec6_oil_well_total integer 11-14 GR-R3-SEC-VI-OIL-WELL-TOT Section VI total: oil wells, same as above. —
6 sec6_barrels_total bigint measured in bbl 15-20 GR-R3-SEC-VI-BARRELS-TOT Section VI total barrels of drip and scrubber liquid recovered this cycle. Non-zero on 299 of the 29,586 cycles. —
7 sec8_receive_total bigint measured in MCF 21-26 GR-R3-SEC-VIII-RECEIVE-TOT Section VIII total. The manual says the section is 'not used at this time' and the tape agrees: zero on all 29,586 cycles. The JSON successor does carry Section VIII, as texas.r3_report_liquid_statement. —
8 sec8_deliver_total bigint measured in MCF 27-32 GR-R3-SEC-VIII-DELIVER-TOT Section VIII total. The manual says the section is 'not used at this time' and the tape agrees: zero on all 29,586 cycles. The JSON successor does carry Section VIII, as texas.r3_report_liquid_statement. —
9 sec9_total bigint measured in MCF 33-38 GR-R3-SEC-IX-TOTAL Section IX total: gas injected. Non-zero on 37 of the 29,586 cycles -- the tape stores the total only, and the well-by-well detail the JSON successor carries has no segment here. —
10 sec10_unprocessed_total bigint measured in MCF 39-44 GR-R3-SEC-X-UNPROCESS-TOT Section X total: unprocessed gas delivered, in MCF. Non-zero on 435 cycles; the line-by-line detail is in r3_section10_deliveries. —
11 sec10_residue_total bigint measured in MCF 45-50 GR-R3-SEC-X-RESIDUE-TOT Section X total: residue gas delivered, in MCF. Non-zero on 5,753 cycles, which makes it the busiest of the four Section X figures. e.g. 432 —
12 c1_plant_fuel_monthly_vol bigint measured in MCF 51-56 GR-C1-PLT-FUEL-MONTHLY-VOL A Form C-1 monthly volume in MCF. Zero on all 29,586 cycles of the final tape, so the C-1 side of the GR database was never populated in the copy RRC published. —
13 c1_manufactured_monthly_vol bigint measured in MCF 57-62 GR-C1-MANUFAC-MONTHLY-VOL A Form C-1 monthly volume in MCF. Zero on all 29,586 cycles of the final tape, so the C-1 side of the GR database was never populated in the copy RRC published. —
14 corrected_report_flag text 63 GR-R3-CORRECTED-REPORT-FLAG 'N' on 17,270 cycles and '0' on 12,316. Nothing on the tape is flagged as a corrected report, so this column cannot be used to find one -- the JSON successor records the same idea as a purpose ('Corrected') and does populate it. e.g. N —
15 discrepancy_letter_date date 64-71 GR-R3-DISCREPANCY-LTR-DATE When RRC wrote to the plant about a discrepancy in this cycle's R-3. Null on all 29,586 cycles of the final tape. —

r3_plant_remark 4 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text — — The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. e.g. 01 RRC district (internal number)
2 serial_no key join smallint — — The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. e.g. 9 —
3 remark_seq key smallint 3-5 GR-R3-REMARK-KEY RRC's own remark number within the plant, from 1. A remark long enough to wrap occupies several rows in order. e.g. 2 —
4 remark text 6-75 GR-R3-REMARK Seventy characters of free text about the plant itself, not about any one cycle -- 'FORMERLY HUMBLE', 'FINAL R-3 FOR EXXON CORP. FILED 11-84. PLT CLSD.'. Order by remark_seq to read a wrapped remark whole; the tape does not mark where one ends. e.g. FINAL R-3 FOR EXXON CORP. FILED 11-84. PLT CLSD. —

r3_r7_pressure 17 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text — — The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. RRC district (internal number)
2 serial_no key join smallint — — The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. —
3 cycle_yyyymm key join integer — — The month this report is for, as one YYYYMM integer: 202508 is August 2025. The tape writes it as four digits (YYMM) with a century pivot at 70, and the loader expands it. The final tape carries 25 cycles, 2023-08 through 2025-08 -- RRC retired the file on 2025-08-25 and there will be no 26th. —
4 intake_gas_well_gas integer measured in MCF 3-7 GR-R7-GAS-WELL-GAS R-7 pressure maintenance: gas-well gas taken in, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
5 intake_casinghead_gas integer measured in MCF 8-12 GR-R7-CASINGHEAD-GAS R-7 pressure maintenance: casinghead gas taken in, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
6 intake_residue integer measured in MCF 13-17 GR-R7-RESIDUE R-7 pressure maintenance: residue gas taken in, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
7 intake_pipe_line integer measured in MCF 18-22 GR-R7-PIPE-LINE R-7 pressure maintenance: pipeline gas taken in, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
8 intake_total bigint measured in MCF 23-28 GR-R7-INTAKE-TOTAL R-7 pressure maintenance: total gas taken in, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
9 disp_fuel_system integer measured in MCF 29-33 GR-R7-FUEL-SYSTEM R-7 pressure maintenance: gas used in the fuel system, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
10 disp_plant_fuel integer measured in MCF 34-38 GR-R7-PLANT-FUEL R-7 pressure maintenance: gas burned as plant fuel, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
11 disp_gas_lift integer measured in MCF 39-43 GR-R7-GAS-LIFT R-7 pressure maintenance: gas used for gas lift, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
12 disp_pressure_maint integer measured in MCF 44-48 GR-R7-PRESSURE-MAINT R-7 pressure maintenance: gas used for pressure maintenance, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
13 disp_repressuring integer measured in MCF 49-53 GR-R7-REPRESSURING R-7 pressure maintenance: gas used for repressuring, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
14 disp_trans_line integer measured in MCF 54-58 GR-R7-TRANS-LINE R-7 pressure maintenance: gas sent to a transmission line, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
15 disp_vented integer measured in MCF 59-63 GR-R7-VENTED R-7 pressure maintenance: gas vented or flared, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
16 disp_total bigint measured in MCF 64-69 GR-R7-TOTAL-DISP R-7 pressure maintenance: total gas disposed of, in MCF. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —
17 injection_wells integer 70-72 GR-R7-NUMBER-INJ-WELLS R-7 pressure maintenance: the count of injection wells. The whole table is EMPTY -- the final grf047 carries no type-12 record at all -- and it is published anyway because the segment is declared upstream so that one would decode rather than be counted as an unknown record. The tape is retired, so it will stay empty. —

r3_section10_deliveries 8 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text — — The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. e.g. 14 RRC district (internal number)
2 serial_no key join smallint — — The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. e.g. 1330 —
3 cycle_yyyymm key join integer — — The month this report is for, as one YYYYMM integer: 202508 is August 2025. The tape writes it as four digits (YYMM) with a century pivot at 70, and the loader expands it. The final tape carries 25 cycles, 2023-08 through 2025-08 -- RRC retired the file on 2025-08-25 and there will be no 26th. e.g. 202507 —
4 line_no key smallint 3-5 GR-SEC-X-KEY The printed line number of this Section X entry. 7,282 of the 16,719 rows carry 0, which is the tape's way of writing 'the section was filed with nothing on it' -- those rows name nobody and deliver nothing. e.g. 1 —
5 delivered_to text 6-37 GR-SEC-X-DELIVERED-TO Thirty-two characters naming who the gas went to -- 'CITY OF DUMAS', a pipeline, a plant. A name as the filer typed it, not an operator number: it cannot be joined to the operator directory. e.g. CITY OF DUMAS —
6 use_code text 38 GR-SEC-X-USE-CODE What the gas was for: T transmission line (8,231 rows), P processing plant (1,206). Null on the 7,282 empty lines. e.g. T —
7 unprocessed_gas integer measured in MCF 39-43 GR-SEC-X-UNPROCESSED-GAS Unprocessed gas delivered on this line, in MCF. e.g. 0 —
8 residue_gas integer measured in MCF 44-48 GR-SEC-X-RESIDUE-GAS Residue gas delivered on this line, in MCF. e.g. 432 —

r3_section11_remark 5 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text — — The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. e.g. 06 RRC district (internal number)
2 serial_no key join smallint — — The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. e.g. 786 —
3 cycle_yyyymm key join integer — — The month this report is for, as one YYYYMM integer: 202508 is August 2025. The tape writes it as four digits (YYMM) with a century pivot at 70, and the loader expands it. The final tape carries 25 cycles, 2023-08 through 2025-08 -- RRC retired the file on 2025-08-25 and there will be no 26th. e.g. 202507 —
4 remark_seq key smallint 3-5 GR-R3-XI-REMARK-KEY RRC's remark number within the cycle, from 1. A remark long enough to wrap occupies several rows in order. e.g. 1 —
5 remark text 6-75 GR-R3-XI-REMARK Seventy characters of free text about THIS cycle's report -- 'PROCESS UPSETS/POWER FAILURES', 'EXCESS FUEL/UNSELLABLE RESIDUE'. Usually the reason gas was vented. Order by remark_seq to read a wrapped remark whole. e.g. PROCESS UPSETS/POWER FAILURES —

r3_section1_intake 28 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text — — The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. e.g. 14 RRC district (internal number)
2 serial_no key join smallint — — The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. e.g. 1330 —
3 cycle_yyyymm key join integer — — The month this report is for, as one YYYYMM integer: 202508 is August 2025. The tape writes it as four digits (YYMM) with a century pivot at 70, and the loader expands it. The final tape carries 25 cycles, 2023-08 through 2025-08 -- RRC retired the file on 2025-08-25 and there will be no 26th. e.g. 202507 —
4 wells_gwg integer 3-5 GR-SEC-I-GWG-WELLS Line 1: gas wells produced into the system this cycle. e.g. 1 —
5 wells_cas integer 6-8 GR-SEC-I-CAS-WELLS Line 1: casinghead (oil) wells produced into the system this cycle. —
6 wells_total integer 9-12 GR-SEC-I-TOTAL-WELLS Line 1: total wells produced. A count, not a volume. e.g. 1 —
7 gathering_gwg integer measured in MCF 13-17 GR-SEC-I-GWG-GATHER Line 2, gas-well gas: gas taken into the gathering system. In MCF. —
8 gathering_cas integer measured in MCF 18-22 GR-SEC-I-CAS-GATHER Line 2, casinghead gas: gas taken into the gathering system. In MCF. —
9 gathering_total bigint measured in MCF 23-28 GR-SEC-I-TOTAL-GATHER Line 2, total: gas taken into the gathering system. In MCF. Non-zero on 5,928 cycles. e.g. 767 —
10 deliveries_gwg integer measured in MCF 29-33 GR-SEC-I-GWG-DELIVER Line 3, gas-well gas: gas delivered out of the gathering system. In MCF. —
11 deliveries_cas integer measured in MCF 34-38 GR-SEC-I-CAS-DELIVER Line 3, casinghead gas: gas delivered out of the gathering system. In MCF. —
12 deliveries_total bigint measured in MCF 39-44 GR-SEC-I-TOTAL-DELIVER Line 3, total: gas delivered out of the gathering system. In MCF. —
13 plant_process_gwg integer measured in MCF 45-49 GR-SEC-I-GWG-PROCESS Line 4, gas-well gas: gas passed from the gathering system to the plant for processing. In MCF. —
14 plant_process_cas integer measured in MCF 50-54 GR-SEC-I-CAS-PROCESS Line 4, casinghead gas: gas passed from the gathering system to the plant for processing. In MCF. —
15 plant_process_total bigint measured in MCF 55-60 GR-SEC-I-TOTAL-PROCESS Line 4, total: gas passed from the gathering system to the plant for processing. In MCF. Non-zero on 5,809 cycles. e.g. 767 —
16 plant_meters_gwg integer measured in MCF 61-65 GR-SEC-I-GWG-METERS Line 5, gas-well gas: plant intake as the plant's own meters read it. In MCF. —
17 plant_meters_cas integer measured in MCF 66-70 GR-SEC-I-CAS-METERS Line 5, casinghead gas: plant intake as the plant's own meters read it. In MCF. —
18 plant_meters_total bigint measured in MCF 71-76 GR-SEC-I-TOTAL-METERS Line 5, total: plant intake as the plant's own meters read it. In MCF. e.g. 767 —
19 loss_gain_gwg integer measured in MCF 77-81 GR-SEC-I-GWG-LOSS-GAIN Line 6, gas-well gas: the difference between lines 4 and 5 -- the metering loss or gain, which may be negative. In MCF. —
20 loss_gain_cas integer measured in MCF 82-86 GR-SEC-I-CAS-LOSS-GAIN Line 6, casinghead gas: the difference between lines 4 and 5 -- the metering loss or gain, which may be negative. In MCF. —
21 loss_gain_total bigint measured in MCF 87-92 GR-SEC-I-TOTAL-LOSS-GAIN Line 6, total: the difference between lines 4 and 5 -- the metering loss or gain, which may be negative. In MCF. Non-zero on 2,186 cycles. —
22 vapors integer measured in MCF 93-97 GR-SEC-I-VAPORS Line 7: refinery and storage vapors taken in, in MCF. Non-zero on 14 of the 8,573 cycles. —
23 other_plants_vol integer measured in MCF 98-102 GR-SEC-I-OTHER-PLANTS-VOL Line 8: gas received from other processing plants, in MCF. Non-zero on 205 cycles. WHICH plants it came from is in r3_section1_other_plant, up to four per cycle. —
24 main_line integer measured in MCF 127-131 GR-SEC-I-MAIN-LINE Line 9: gas taken from a main transmission line, in MCF. Non-zero on 404 cycles. —
25 withdrawn_storage integer measured in MCF 132-136 GR-SEC-I-WITHDRAWN-STORAGE Line 10: gas withdrawn from underground storage, in MCF. Non-zero on 14 cycles. —
26 import_from_states integer measured in MCF 137-141 GR-SEC-I-IMPORT-FROM-STATES Line 11: gas imported from another state, in MCF. Non-zero on 135 cycles; import_state_code says which state. —
27 import_state_code text 142-143 GR-SEC-I-IMPORT-STATE-CODE Two letters naming the state line 11's gas came from: NM (70 cycles), OK (42), LA (23). Null on the 8,438 cycles that imported nothing. The manual also lists MX, AZ, AR and KS, none of which appears on the final tape. —
28 net_gas bigint measured in MCF 144-149 GR-SEC-I-NET-GAS Line 12: net gas to the plant for processing, in MCF -- the sum the whole section builds to. Non-zero on 6,605 of the 8,573 cycles. e.g. 767 —

r3_section1_other_plant 7 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text — — The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. e.g. 09 RRC district (internal number)
2 serial_no key join smallint — — The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. e.g. 36 —
3 cycle_yyyymm key join integer — — The month this report is for, as one YYYYMM integer: 202508 is August 2025. The tape writes it as four digits (YYMM) with a century pivot at 70, and the loader expands it. The final tape carries 25 cycles, 2023-08 through 2025-08 -- RRC retired the file on 2025-08-25 and there will be no 26th. e.g. 202506 —
4 ordinal key smallint — — Which of Section I line 8's four slots this row came from, 1 to 4. The tape writes them as a fixed OCCURS 4 group and EZRRC drops the unused ones, which are '000000'; the ordinal is kept so the original order can be recovered. e.g. 1 —
5 other_plant_district join text — — The district SUBSCRIPT of the plant the gas came from, as published -- the same numbering as the row's own `district`, so 09 means District 7C. e.g. 09 RRC district (internal number)
6 other_plant_serial_no join smallint — — Four-digit serial of the plant the gas came from. e.g. 407 —
7 other_plant_id join text — — The other plant's printed id, '7C-0407', derived from the two columns beside it. This is what joins line 8 back to r3_plant. e.g. 7C-0407 —

r3_section2_disposition 33 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text — — The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. e.g. 14 RRC district (internal number)
2 serial_no key join smallint — — The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. e.g. 1129 —
3 cycle_yyyymm key join integer — — The month this report is for, as one YYYYMM integer: 202508 is August 2025. The tape writes it as four digits (YYMM) with a century pivot at 70, and the loader expands it. The final tape carries 25 cycles, 2023-08 through 2025-08 -- RRC retired the file on 2025-08-25 and there will be no 26th. e.g. 202507 —
4 fuel_system_gwg integer measured in MCF 3-7 GR-SEC-II-GWG-FUEL-SYS Line 1, gas-well gas: gas used in the fuel system or on the lease. In MCF. e.g. 2349 —
5 fuel_system_cas integer measured in MCF 8-12 GR-SEC-II-CAS-FUEL-SYS Line 1, casinghead gas: gas used in the fuel system or on the lease. In MCF. —
6 fuel_system_total bigint measured in MCF 13-18 GR-SEC-II-TOTAL-FUEL-SYS Line 1, total: gas used in the fuel system or on the lease. In MCF. Non-zero on 1,334 cycles. e.g. 2349 —
7 gas_lift_gwg integer measured in MCF 19-23 GR-SEC-II-GWG-GAS-LIFT Line 2, gas-well gas: gas used for gas lift. In MCF. —
8 gas_lift_cas integer measured in MCF 24-28 GR-SEC-II-CAS-GAS-LIFT Line 2, casinghead gas: gas used for gas lift. In MCF. —
9 gas_lift_total bigint measured in MCF 29-34 GR-SEC-II-TOTAL-GAS-LIFT Line 2, total: gas used for gas lift. In MCF. Non-zero on 732 cycles. —
10 maintenance_gwg integer measured in MCF 35-39 GR-SEC-II-GWG-MAINT Line 3, gas-well gas: gas used for repressuring and pressure maintenance. In MCF. —
11 maintenance_cas integer measured in MCF 40-44 GR-SEC-II-CAS-MAINT Line 3, casinghead gas: gas used for repressuring and pressure maintenance. In MCF. —
12 maintenance_total bigint measured in MCF 45-50 GR-SEC-II-TOTAL-MAINT Line 3, total: gas used for repressuring and pressure maintenance. In MCF. Non-zero on 22 cycles. —
13 cycled_gwg integer measured in MCF 51-55 GR-SEC-II-GWG-CYCLED Line 4, gas-well gas: gas cycled. In MCF. —
14 cycled_cas integer measured in MCF 56-60 GR-SEC-II-CAS-CYCLED Line 4, casinghead gas: gas cycled. In MCF. —
15 cycled_total bigint measured in MCF 61-66 GR-SEC-II-TOTAL-CYCLED Line 4, total: gas cycled. In MCF. Non-zero on 0 cycles. —
16 underground_storage_gwg integer measured in MCF 67-71 GR-SEC-II-GWG-UNDGRND Line 5, gas-well gas: gas put into underground storage, as the plant meters read it. In MCF. —
17 underground_storage_cas integer measured in MCF 72-76 GR-SEC-II-CAS-UNDGRND Line 5, casinghead gas: gas put into underground storage, as the plant meters read it. In MCF. —
18 underground_storage_total bigint measured in MCF 77-82 GR-SEC-II-TOTAL-UNDGRND Line 5, total: gas put into underground storage, as the plant meters read it. In MCF. Non-zero on 14 cycles. —
19 other_plants_gwg integer measured in MCF 83-87 GR-SEC-II-GWG-OTHR-PLT Line 6, gas-well gas: gas sent to other processing plants. In MCF. —
20 other_plants_cas integer measured in MCF 88-92 GR-SEC-II-CAS-OTHR-PLT Line 6, casinghead gas: gas sent to other processing plants. In MCF. —
21 other_plants_total bigint measured in MCF 93-98 GR-SEC-II-TOTAL-OTHR-PLT Line 6, total: gas sent to other processing plants. In MCF. Non-zero on 517 cycles. —
22 carbon_black_gwg integer measured in MCF 99-103 GR-SEC-II-GWG-CRBN-BLK Line 7, gas-well gas: gas sent to carbon black plants. In MCF. —
23 carbon_black_cas integer measured in MCF 104-108 GR-SEC-II-CAS-CRBN-BLK Line 7, casinghead gas: gas sent to carbon black plants. In MCF. —
24 carbon_black_total bigint measured in MCF 109-114 GR-SEC-II-TOTAL-CRBN-BLK Line 7, total: gas sent to carbon black plants. In MCF. Non-zero on 11 cycles. —
25 transmission_line_gwg integer measured in MCF 115-119 GR-SEC-II-GWG-TRANS-LN Line 8, gas-well gas: gas sent to a transmission line. In MCF. —
26 transmission_line_cas integer measured in MCF 120-124 GR-SEC-II-CAS-TRANS-LN Line 8, casinghead gas: gas sent to a transmission line. In MCF. —
27 transmission_line_total bigint measured in MCF 125-130 GR-SEC-II-TOTAL-TRANS-LN Line 8, total: gas sent to a transmission line. In MCF. Non-zero on 326 cycles. —
28 vented_gwg integer measured in MCF 131-135 GR-SEC-II-GWG-VENTED Line 9, gas-well gas: gas vented or flared. In MCF. —
29 vented_cas integer measured in MCF 136-140 GR-SEC-II-CAS-VENTED Line 9, casinghead gas: gas vented or flared. In MCF. —
30 vented_total bigint measured in MCF 141-146 GR-SEC-II-TOTAL-VENTED Line 9, total: gas vented or flared. In MCF. Non-zero on 323 cycles. —
31 total_gwg bigint measured in MCF 147-152 GR-SEC-II-GWG-TOTAL Line 10: the gas-well-gas column totalled, in MCF. e.g. 2349 —
32 total_cas bigint measured in MCF 153-158 GR-SEC-II-CAS-TOTAL Line 10: the casinghead column totalled, in MCF. —
33 grand_total bigint measured in MCF 159-164 GR-SEC-II-GRAND-TOTAL Line 10: total unprocessed gas disposed of this cycle, in MCF. e.g. 2349 —

r3_section3_5_products 34 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text — — The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. e.g. 14 RRC district (internal number)
2 serial_no key join smallint — — The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. e.g. 1330 —
3 cycle_yyyymm key join integer — — The month this report is for, as one YYYYMM integer: 202508 is August 2025. The tape writes it as four digits (YYMM) with a century pivot at 70, and the loader expands it. The final tape carries 25 cycles, 2023-08 through 2025-08 -- RRC retired the file on 2025-08-25 and there will be no 26th. e.g. 202507 —
4 s3_extract_loss integer measured in MCF 3-7 GR-SEC-III-EXTRACT-LOSS Section III line 1: residue gas lost in extraction, in MCF. Non-zero on 4,350 of the 20,027 cycles. e.g. 335 —
5 s3_h2s_loss integer measured in MCF 8-12 GR-SEC-III-H2S-LOSS Section III line 2: residue gas lost as hydrogen sulphide, in MCF. —
6 s3_co2_loss integer measured in MCF 13-17 GR-SEC-III-CO2-LOSS Section III line 3: residue gas lost as carbon dioxide, in MCF. —
7 s3_plant_fuel integer measured in MCF 18-22 GR-SEC-III-PLANT-FUEL Section III line 4: residue gas burned as plant fuel, in MCF. —
8 s3_lease_fuel integer measured in MCF 23-27 GR-SEC-III-LEASE-FUEL Section III line 5: residue gas used as lease fuel, in MCF. —
9 s3_gas_lift integer measured in MCF 28-32 GR-SEC-III-GAS-LIFT Section III line 6: residue gas used for gas lift, in MCF. —
10 s3_repressure integer measured in MCF 33-37 GR-SEC-III-REPRESSURE Section III line 7: residue gas used for repressuring and pressure maintenance, in MCF. —
11 s3_cycled integer measured in MCF 38-42 GR-SEC-III-CYCLED Section III line 8: residue gas cycled, in MCF. —
12 s3_underground integer measured in MCF 43-47 GR-SEC-III-UNDERGROUND Section III line 9: residue gas put into underground storage, in MCF. —
13 s3_carbon_black integer measured in MCF 48-52 GR-SEC-III-CARBON-BLACK Section III line 10: residue gas sent to carbon black plants, in MCF. —
14 s3_other_plants integer measured in MCF 53-57 GR-SEC-III-OTHER-PLANTS Section III line 11: residue gas sent to other processing plants, in MCF. —
15 s3_trans_line integer measured in MCF 58-62 GR-SEC-III-TRANS-LINE Section III line 12: residue gas sent to a transmission line, in MCF. —
16 s3_vented integer measured in MCF 63-67 GR-SEC-III-VENTED Section III line 13: residue gas vented or flared, in MCF. —
17 s3_meter_diff integer measured in MCF 68-72 GR-SEC-III-METER-DIFF Section III line 14: metering difference on the residue gas, in MCF. —
18 s3_water integer measured in MCF 73-77 GR-SEC-III-WATER Section III line 15: residue gas lost as water, in MCF. —
19 s3_nitrogen_loss integer measured in MCF 78-82 GR-SEC-III-NITROGEN-LOSS Section III line 16: residue gas lost as nitrogen, in MCF. Non-zero on 228 cycles. —
20 s3_total bigint measured in MCF 98-103 GR-SEC-III-TOTAL Section III total (lines 1-16): all residue gas disposed of, in MCF. Non-zero on 6,548 of the 20,027 cycles. e.g. 767 —
21 s4_sulfur_tons integer measured in long tons 104-106 GR-SEC-IV-SULFUR-TONS Section IV: sulfur recovered from processing natural gas, in LONG TONS -- the one figure in this table that is not a volume. Non-zero on 34 cycles. —
22 s4_co2_mcf integer measured in MCF 107-111 GR-SEC-IV-CO2-MCF Section IV: carbon dioxide recovered from processing natural gas, in MCF. Non-zero on 32 cycles. —
23 s5_scrubber_back integer measured in bbl 122-126 GR-SEC-V-SCRUBBER-BACK Section V: scrubber oil returned to the system, in barrels. —
24 s5_gwg_condensate integer measured in bbl 127-131 GR-SEC-V-GWG-CONDENSATE Section V line 1: condensate from gas well gas, in barrels. —
25 s5_cas_scrubber integer measured in bbl 132-136 GR-SEC-V-CAS-SCRUBBER Section V line 2: scrubber oil from casinghead gas, in barrels. —
26 s5_plant_cond integer measured in bbl 137-141 GR-SEC-V-PLANT-COND Section V line 3: plant condensate, in barrels. —
27 s5_gasoline integer measured in bbl 142-146 GR-SEC-V-GASOLINE Section V line 4: gasoline produced, in barrels. Non-zero on 2,361 cycles. —
28 s5_butane integer measured in bbl 147-151 GR-SEC-V-BUTANE Section V line 5: butane produced, in barrels. —
29 s5_propane integer measured in bbl 152-156 GR-SEC-V-PROPANE Section V line 6: propane produced, in barrels. —
30 s5_mix integer measured in bbl 157-161 GR-SEC-V-MIX Section V line 7: butane-propane mix produced, in barrels. —
31 s5_iso_butane integer measured in bbl 162-166 GR-SEC-V-ISO-BUTANE Section V line 8: iso-butane produced, in barrels. —
32 s5_ethane integer measured in bbl 167-171 GR-SEC-V-ETHANE Section V line 9: ethane produced, in barrels. Non-zero on 2,466 cycles. —
33 s5_other integer measured in bbl 172-176 GR-SEC-V-OTHER Section V line 10: any other liquid product, in barrels. —
34 s5_total bigint measured in bbl 187-192 GR-SEC-V-TOTAL Section V total (lines 1-10): plant liquid hydrocarbon production, in barrels. Non-zero on 17,957 of the 20,027 cycles, which makes it the single most-filled figure on the tape. e.g. 209 —

r3_section6_drip 8 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text — — The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. RRC district (internal number)
2 serial_no key join smallint — — The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. —
3 cycle_yyyymm key join integer — — The month this report is for, as one YYYYMM integer: 202508 is August 2025. The tape writes it as four digits (YYMM) with a century pivot at 70, and the loader expands it. The final tape carries 25 cycles, 2023-08 through 2025-08 -- RRC retired the file on 2025-08-25 and there will be no 26th. —
4 line_no key smallint 3-5 GR-SEC-VI-KEY The printed line number of this Section VI entry. 516 of the 1,066 rows carry 0, which is the tape's way of writing 'the section was filed with nothing on it' -- those rows have no source name and zero barrels. e.g. 0 —
5 source_name text 6-37 GR-SEC-VI-NAME Thirty-two characters naming where the drip or scrubber liquid was recovered -- 'Main Drip Line', a station or a gathering line. Prose, not a lease key: there is no lease number in Section VI and it cannot be joined to anything. Filled on 534 of the 1,066 rows. —
6 gas_wells integer 38-40 GR-SEC-VI-NO-GAS-WELLS Gas wells behind this line's recovery. A count, not a volume. e.g. 0 —
7 oil_wells integer 41-43 GR-SEC-VI-NO-OIL-WELLS Oil wells behind this line's recovery. A count, not a volume. —
8 total_barrels integer measured in bbl 44-47 GR-SEC-VI-TOTAL-BARRELS Barrels of drip and scrubber liquid recovered from this source. Non-zero on 323 of the 1,066 rows. e.g. 0 —

r3_section7_stocks 13 columns

Documented here because RRC ships it in the same file. It is not in a download of this dataset.

# Column Type Bytes RRC name Meaning Lookup
1 district key join text — — The district as the tape keys it: RRC's INTERNAL district number, not the designation the Commission prints. 09 is District 7C, 10 is District 08, 11 is 8A, 13 is District 09 and 14 is District 10 -- the same numbering PDQ and the statewide production tapes use, and the reason a filter for '08' here returns District 7B. `district_code` beside it carries the printed form. 46 roots carry subscript 20, which is in no conversion table. e.g. 04 RRC district (internal number)
2 serial_no key join smallint — — The plant's four-digit serial number within its district. Unique only together with the district: serial 22 exists in several. `plant_id` on the plant row fuses the two into the id RRC prints. e.g. 4298 —
3 cycle_yyyymm key join integer — — The month this report is for, as one YYYYMM integer: 202508 is August 2025. The tape writes it as four digits (YYMM) with a century pivot at 70, and the loader expands it. The final tape carries 25 cycles, 2023-08 through 2025-08 -- RRC retired the file on 2025-08-25 and there will be no 26th. e.g. 202508 —
4 line_no key smallint — — Which of Section VII's ten printed lines this row is, 1 to 10, in copybook order. The tape writes them as a fixed OCCURS 10 group and EZRRC expands it to a row per line, so every cycle in this table has exactly ten. e.g. 1 —
5 line_name text — — The line's name, supplied by EZRRC from the copybook's own order: opening_balance, frozen_stock, total_opening_stock, received, produced, delivered, loss, total_closing_stock, second_frozen_stock, closing_balance. The tape carries the position and no caption. e.g. opening_balance —
6 cond integer measured in bbl — — Barrels of condensate on this Section VII line. ZERO on all 282,600 rows: the manual states plainly that 'only totals are stored for Section VII', and the tape carries the per-product columns without ever filling them. Read `total` instead -- the per-product split exists only on the paper form and, from 2025-09, in the JSON successor. —
7 scrubber integer measured in bbl — — Barrels of scrubber oil on this Section VII line. ZERO on all 282,600 rows: the manual states plainly that 'only totals are stored for Section VII', and the tape carries the per-product columns without ever filling them. Read `total` instead -- the per-product split exists only on the paper form and, from 2025-09, in the JSON successor. —
8 gasoline integer measured in bbl — — Barrels of gasoline on this Section VII line. ZERO on all 282,600 rows: the manual states plainly that 'only totals are stored for Section VII', and the tape carries the per-product columns without ever filling them. Read `total` instead -- the per-product split exists only on the paper form and, from 2025-09, in the JSON successor. —
9 butane integer measured in bbl — — Barrels of butane on this Section VII line. ZERO on all 282,600 rows: the manual states plainly that 'only totals are stored for Section VII', and the tape carries the per-product columns without ever filling them. Read `total` instead -- the per-product split exists only on the paper form and, from 2025-09, in the JSON successor. —
10 propane integer measured in bbl — — Barrels of propane on this Section VII line. ZERO on all 282,600 rows: the manual states plainly that 'only totals are stored for Section VII', and the tape carries the per-product columns without ever filling them. Read `total` instead -- the per-product split exists only on the paper form and, from 2025-09, in the JSON successor. —
11 ethane integer measured in bbl — — Barrels of ethane on this Section VII line. ZERO on all 282,600 rows: the manual states plainly that 'only totals are stored for Section VII', and the tape carries the per-product columns without ever filling them. Read `total` instead -- the per-product split exists only on the paper form and, from 2025-09, in the JSON successor. —
12 other integer measured in bbl — — Barrels of any other product on this Section VII line. ZERO on all 282,600 rows: the manual states plainly that 'only totals are stored for Section VII', and the tape carries the per-product columns without ever filling them. Read `total` instead -- the per-product split exists only on the paper form and, from 2025-09, in the JSON successor. —
13 total bigint measured in bbl — — The line's total across all products, in barrels, and the ONLY figure Section VII actually carries -- see the seven per-product columns above, every one of which is zero on all 282,600 rows. Non-zero on 127,253 rows. Line 9 (second_frozen_stock) is zero everywhere and line 2 (frozen_stock) on all but two. e.g. 0 —

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 (printed designation) 14 values

Read by district_code

The district as the Railroad Commission prints it: 01-06, 6E, 7B, 7C, 08, 8A, 09 and 10, plus 20 for statewide. This is what appears on permits, completions, ST-1 filings and inspection reports. It is not interchangeable with the internal district number. A column holding '11' means District 8A under the internal numbering and nothing at all under this one.

CodeMeans
01 District 01 — San Antonio RRC District 01, administered from the San Antonio district office.
02 District 02 — San Antonio RRC District 02, administered from the San Antonio district office.
03 District 03 — Houston RRC District 03, administered from the Houston district office.
04 District 04 — Corpus Christi RRC District 04, administered from the Corpus Christi district office.
05 District 05 — Kilgore RRC District 05, administered from the Kilgore district office.
06 District 06 — Kilgore RRC District 06, administered from the Kilgore district office.
6E District 6E — Kilgore RRC District 6E, administered from the Kilgore district office.
7B District 7B — Abilene RRC District 7B, administered from the Abilene district office.
7C District 7C — San Angelo RRC District 7C, administered from the San Angelo district office.
08 District 08 — Midland RRC District 08, administered from the Midland district office.
8A District 8A — Midland RRC District 8A, administered from the Midland district office.
09 District 09 — Wichita Falls RRC District 09, administered from the Wichita Falls district office.
10 District 10 — Pampa RRC District 10, administered from the Pampa district office.
20 District 20 — State Wide RRC District 20, administered from the State Wide district office.

Source: Generated from texas.pdq_gp_district.district_name

RRC district (internal number) 14 values

Read by district, district, district, district, district, district, district, district, other_plant_district, district, district, district, district

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.

CodeMeans
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.

R-3 Gas Processing Plants (EBCDIC, retired) joins to P-5 Organization (ASCII) on Operator number = ID — many rows here share a single row there.

operated by

The six-digit P-5 number on the plant record is the operator directory's primary key, and both sides are integers, so no cast is needed. Exact on all 7,138 plants that carry one, over 1,825 distinct organizations; the other 45 roots hold zero, which is the tape's way of writing 'none'. This is the only route from an R-3 to a company. The JSON successor carries no operator number at all, so a modern filing has to come back through the retired tape on the plant id to be attributed.

r3-gas-processing-plants-ebcdic.operator_no = p5-organization-ascii.id

R-3 Gas Processing Plants (EBCDIC, retired) joins to R-3 Gas Processing Plants (JSON) on Plant ID = Serial number — one row here matches many rows there.

is the plant on the retired tape

The two eras of the R-3, joined on the id RRC prints. The EBCDIC tape carries the plant master and the last two years of forms up to 2025-08; the JSON carries every filing approved since. 6,119 of the 6,260 JSON filings resolve to a plant on the tape, and 1,404 of the 1,449 distinct plant ids in the JSON. The 45 that do not are plants RRC registered after the tape was frozen -- there is no other way to be in the JSON and not on the tape, because the tape was never truncated. Going the other way, only 1,404 of the tape's 7,137 identified plants appear in the JSON at all: the rest stopped filing before September 2025, many of them decades before. `plant_id` is EZRRC's derivation on the tape side, built from the internal district number and the serial; `serial_number` is as RRC publishes it. Joining on (district_code, serial_no) instead gives the identical 6,119.

r3-gas-processing-plants-json.serial_number = r3-gas-processing-plants-ebcdic.plant_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
Retired — RRC no longer publishes this (Monthly until RRC retired the file on 08-25-2025.)
RRC download link
GoAnywhere MFT
Record layout manual
Our table
texas.r3_plant

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 Oil & Gas Regulatory Data