EZRRC
Cart Sign in

Oil Detail Well — W-10 Tests

The same two W-10 tests, one row per test, for joining and charting.

What this is:

The DW-TST-INFO group of OLA028K normalised: 171,948 rows, two for each of the 85,974 wells on the detail-well tape. test_ordinal 1 is the previous test and 2 the most recent, in the order the manual gives them. The same values are also flattened onto the well row as test1_ and test2_ columns in Oil Detail Well.

How it is laid out:

The Railroad Commission publishes this as EBCDIC (IBM cp037). IBM mainframe encoding (cp037). Opening it as text gives you nonsense; it has to be transcoded first. We decode it into a table you can open anywhere. It has 12 columns and about 171.5K rows.

The columns you will most likely want:

  • district RRC district the well is in, in the ledger's spelling.
  • field_no The eight-digit RRC field number.
  • operator_no P-5 organization number of the lease operator.
  • lease_no The five-digit RRC oil lease number.
  • rec_no Identifier of the multi-well group, one character.
  • well_no The operator's well number, right-justified in six bytes as the tape wrote it.

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

What we add:

Chart a well's tested potential between its last two tests, or aggregate potential and water across the wells of a unit without unpivoting anything.

  • 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:

Every well has both rows even when a test is empty, which is why 171,948 is exactly twice 85,974. test_date is null on 690 of the previous tests and 663 of the most recent ones. oil_bbl is the well's working POTENTIAL in barrels per calendar day, not production.

The full page lists every trap in this dataset.

Get it:

People who want this usually want: