EZRRC
Cart Sign in

P-18 Skim Oil / Condensate Report

Every barrel of oil skimmed off produced water, and the lease it was credited back to.

What this is:

The P-18 report: hydrocarbon liquids recovered at saltwater disposal and skim-oil systems, which never appear as lease production because they were skimmed downstream. 45,825 filings across the seventeen monthly releases published so far. The heart of it is the allocation table -- 3,419,471 rows saying which lease or drilling permit each barrel of skimmed liquid was credited back to, with the water that lease sent in.

How it is laid out:

The Railroad Commission publishes this as JSON. Structured JSON. We decode it into a table you can open anywhere. It has 100 columns and about 45.8K rows.

The columns you will most likely want:

  • report_month The month RRC PUBLISHED the file this row came out of, as one YYYYMM integer, taken from the file's name.
  • report_seq The filing's position in its month's file, from 1.
  • source_file The JSON file this filing was read out of, e.g. 'p18dataload_june-2026.json'.
  • district_code The district designation split out of `system_serial_number` by EZRRC -- 01-06, 6E, 7B, 7C, 08, 8A, 09, 10.
  • serial_no The serial split out of `system_serial_number` by EZRRC, as a whole number. Null wherever `district_code` is.
  • period_yyyymm The month the filing REPORTS ON, as one YYYYMM integer, and the column to take a date range on.

…and 94 more, all documented on the full page.

What we add:

Filter the filings by operator, system, district, county, reporting period or purpose, and export them with all five child tables: the lease allocations, the disposal wells behind the system, the gatherers who took the liquid, the out-of-state water and the associated systems it was injected through.

There is more on the full page, including what this joins to.

  • Decoded out of the Commission's original format into something Excel opens.
  • Filterable before you download, so you can take one county instead of the whole state.
  • The Commission's single-letter codes translated into words.

Worth knowing before use:

Skim oil is RECOVERED volume, not produced volume. Adding it to lease production double counts. A month's file is the filings RRC APPROVED that month, not the filings FOR it.

The full page lists every trap in this dataset.

Get it:

People who want this usually want: