EZRRC
Cart Sign in

RRC district (proration ledger spelling)

rrc.district_ledger

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.

14 of 14 codes

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

Columns that use these codes

Dataset Column Meaning
Gas Ledger district RRC district of the field this month belongs to, in the ledger's spelling.
Gas Ledger district 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.
Gas Ledger district 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.
Gas Ledger district RRC district of the well this month belongs to, in the ledger's spelling.
Gas Ledger — Field Months district RRC district of the field this month belongs to, in the ledger's spelling.
Gas Ledger — Well Months district RRC district of the well this month belongs to, in the ledger's spelling.
Gas Ledger — Wells district 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.
Oil Detail Well district RRC district the well is in, as the ledger tape writes it: 01-06, 06E, 07B, 07C, 08, 08A, 09, 10, with the leading zero PDQ does not use. District 08 holds 28,882 of the 85,974 rows and 08A another 26,298 -- multi-well units are largely a Permian waterflood story.
Oil Detail Well district RRC district the well is in, in the ledger's spelling.
Oil Detail Well — W-10 Tests district RRC district the well is in, in the ledger's spelling.
Oil Ledger district RRC district the lease is in, as the ledger tape writes it: 01-06, 06E, 07B, 07C, 08, 08A, 09, 10. PDQ writes the lettered four without the leading zero.
Oil Ledger district RRC district the field is in, as the ledger tape writes it: 01-06, 06E, 07B, 07C, 08, 08A, 09, 10 -- the lettered four carry a leading zero the W-10, the G-10 and PDQ do not use. In the key because the record carries it, not because it is needed: field numbers are unique on their own in all 33,939 rows.
Oil Ledger district RRC district of the field this month belongs to, in the ledger's spelling.
Oil Ledger district RRC district of the lease this month belongs to, in the ledger's spelling.
Oil Ledger district RRC district of the multi-well group this month belongs to, in the ledger's spelling.
Oil Ledger district RRC district the multi-well group is in, in the ledger's spelling.
Oil Ledger district RRC district the well is in, as the ledger tape writes it: 01-06, 06E, 07B, 07C, 08, 08A, 09, 10. 50,492 of the 207,544 wells are in the lettered four, which the W-10 and PDQ write without the leading zero.
Oil Ledger district RRC district of the well this month belongs to, in the ledger's spelling.
Oil Ledger — Field Months district RRC district of the field this month belongs to, in the ledger's spelling.
Oil Ledger — Lease Months district RRC district of the lease this month belongs to, in the ledger's spelling.
Oil Ledger — Leases district RRC district the lease is in, as the ledger tape writes it: 01-06, 06E, 07B, 07C, 08, 08A, 09, 10. PDQ writes the lettered four without the leading zero.
Oil Ledger — Multi-Well Group Months district RRC district of the multi-well group this month belongs to, in the ledger's spelling.
Oil Ledger — Multi-Well Groups district RRC district the multi-well group is in, in the ledger's spelling.
Oil Ledger — Well Months district RRC district of the well this month belongs to, in the ledger's spelling.
Oil Ledger — Wells district RRC district the well is in, as the ledger tape writes it: 01-06, 06E, 07B, 07C, 08, 08A, 09, 10. 50,492 of the 207,544 wells are in the lettered four, which the W-10 and PDQ write without the leading zero.

Where this mapping came from: 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