PR (P-1/P-2) Gas Disposition (EBCDIC)
Queryable EBCDIC
The same gas disposition records in the raw mainframe encoding.
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.
What this is
The EBCDIC edition of OGA0861 — identical records, original encoding, published for subscribers whose readers expect it.
What you can do with it
Feed a COBOL reader directly. For anything else take the ASCII edition.
Gotchas
EBCDIC with packed-decimal numerics: the original is unreadable in a text editor. The decoded table here is the same data, and is what you want unless you need the Commission's own encoding.
Verified 2026-08-07: decoded from cp037 the original is byte for byte the ASCII edition with its line endings stripped — 90,986 records of 200 characters in both.
Record layout
56 columns.
texas.pr_gas_disposition
28 columns
This is the table you get when you download or query PR (P-1/P-2) Gas Disposition (EBCDIC).
| # | Column | Type | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|
| 1 |
district
|
text | — | District | — |
| 2 |
gas_well_gas_rrcid
|
text | — | Gas well gas rrcid | — |
| 3 |
report_year
|
text | — | Report year | — |
| 4 |
report_month
|
text | — | Report month | — |
| 5 |
balancing_code
|
text | — | Balancing code | — |
| 6 |
discrepancy_printed_code
|
text | — | Discrepancy printed code | — |
| 7 |
invalid_or_omitted_code
|
text | — | Invalid or omitted code | — |
| 8 |
extraction_loss_code
|
text | — | Extraction loss code | — |
| 9 |
coding_mast_op_number
|
text | — | Coding mast op number | — |
| 10 |
company_tape_op_number
|
text | — | Company tape op number | — |
| 11 |
field_number
|
text | — | Field number | — |
| 12 |
field_name
|
text | — | Field name | — |
| 13 |
lease_name
|
text | — | Lease name | — |
| 14 |
gas_well_gas_number
|
text | — | Gas well gas number | — |
| 15 |
batch_code
|
text | — | Batch code | — |
| 16 |
lease_fld_fuel_systems
|
integer | — | Lease field fuel systems | — |
| 17 |
transmission_line
|
integer | — | Transmission line | — |
| 18 |
processing_plant
|
integer | — | Processing plant | — |
| 19 |
vented_or_flared
|
integer | — | Vented or flared | — |
| 20 |
gas_well_gas_lift
|
integer | — | Gas well gas lift | — |
| 21 |
pressure_maintenance
|
integer | — | Pressure maintenance | — |
| 22 |
carbon_black
|
integer | — | Carbon black | — |
| 23 |
underground_storage
|
integer | — | Underground storage | — |
| 24 |
extraction_loss
|
integer | — | Extraction loss | — |
| 25 |
gas_well_gas_production
|
integer | — | Gas well gas production | — |
| 26 |
gas_well_gas_lift_injected
|
integer | — | Gas well gas lift injected | — |
| 27 |
condensate_production
|
integer | — | Condensate production | — |
| 28 |
ingested_at
|
timestamp | — | Ingested at | — |
pr_gas_disposition
28 columns
This is the table you get when you download or query PR (P-1/P-2) Gas Disposition (EBCDIC).
| # | Column | Type | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|
| 1 |
district
|
text | — | RRC district the record belongs to, written the way RRC prints it (01-06, 6E, 7B, 7C, 08, 8A, 09, 10). | — |
| 2 |
gas_well_gas_rrcid
|
text | — | Gas well gas rrcid | — |
| 3 |
report_year
|
text | — | Report year | — |
| 4 |
report_month
|
text | — | Report month | — |
| 5 |
balancing_code
|
text | — | Balancing code | — |
| 6 |
discrepancy_printed_code
|
text | — | Discrepancy printed code | — |
| 7 |
invalid_or_omitted_code
|
text | — | Invalid or omitted code | — |
| 8 |
extraction_loss_code
|
text | — | Extraction loss code | — |
| 9 |
coding_mast_op_number
|
text | — | Coding mast op number | — |
| 10 |
company_tape_op_number
|
text | — | Company tape op number | — |
| 11 |
field_number
|
text | — | The eight-digit RRC field number. | — |
| 12 |
field_name
|
text | — | Field name. | — |
| 13 |
lease_name
|
text | — | Lease name as filed. | — |
| 14 |
gas_well_gas_number
|
text | — | Gas well gas number | — |
| 15 |
batch_code
|
text | — | Batch code | — |
| 16 |
lease_fld_fuel_systems
|
bigint | — | Lease field fuel systems | — |
| 17 |
transmission_line
|
bigint | — | Transmission line | — |
| 18 |
processing_plant
|
bigint | — | Processing plant | — |
| 19 |
vented_or_flared
|
bigint | — | Vented or flared | — |
| 20 |
gas_well_gas_lift
|
bigint | — | Gas well gas lift | — |
| 21 |
pressure_maintenance
|
bigint | — | Pressure maintenance | — |
| 22 |
carbon_black
|
bigint | — | Carbon black | — |
| 23 |
underground_storage
|
bigint | — | Underground storage | — |
| 24 |
extraction_loss
|
bigint | — | Extraction loss | — |
| 25 |
gas_well_gas_production
|
bigint | — | Gas well gas production | — |
| 26 |
gas_well_gas_lift_injected
|
bigint | — | Gas well gas lift injected | — |
| 27 |
condensate_production
|
bigint | — | Condensate production | — |
| 28 |
ingested_at
|
timestamptz | — | When the upstream pipeline last wrote this row. Not an RRC field — it is EZRRC's provenance stamp, and it is what the freshness badge is measured against. | — |
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.)
- EZRRC re-ingests
- Weekly
- Record layout manual
- Our table
texas.pr_gas_disposition
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.