test_id |
string |
no |
Globally unique test identifier (opaque string) - this table's primary key. Never parse substrings out of it.
|
well_id |
string |
no |
Join key to the well register. Always populated.
|
test_date |
date |
no |
Date of the test. On shut-in status filings, the reported test date may be the filing's own effective month - the date the declared status takes effect - rather than a measured test's date. Where a source records only one date for a reporting year, it may be that year's first day: a year-precision date rather than a measured test's date.
|
test_type |
string |
yes |
Kind of test: initial_potential, survey, retest, deliverability, or flow_test, a measured flow period (a clean-up or underbalanced-drilling flow, or an unnamed one) with no potential or deliverability determination.
Values: initial_potential · survey · retest · deliverability · flow_test. |
oil_per_day |
float64 |
yes |
Tested oil rate in BBL/d. Includes condensate for gas wells.
|
gas_per_day |
float64 |
yes |
Tested gas rate in MCF/d. Where a test reports an oil rate and its gas-oil ratio but no gas rate, this is either computed from those two reported values or NULL.
|
water_per_day |
float64 |
yes |
Tested water rate in BBL/d.
|
gor |
float64 |
yes |
Gas-oil ratio in cubic feet of gas per barrel of oil (scf/bbl). The test form's own ratio where the form reports a usable one; otherwise computed from the tested gas and oil rates (gas in cubic feet divided by oil in barrels), or NULL. Where it would be computed from a gas rate of 0 beside a positive oil rate, it is NULL unless the source establishes that 0 as a measurement; the gas rate still shows the 0 as filed. Where a test's rates are withheld because its filing reads as a month's volumes typed into the daily boxes, the ratio of the two filed rates is kept where both carry the slip, since the same factor on both leaves it unchanged.
|
oil_gravity |
float64 |
yes |
Oil API gravity in degrees - a product quality indicator. Includes condensate for gas wells, so values above about 45 degrees are normal where the tested fluid is condensate rather than crude.
|
gas_gravity |
float64 |
yes |
Specific gravity of the tested gas, relative to air = 1.0. Dry gas is near 0.6; richer gas carrying more heavy hydrocarbons runs higher, so this is a useful indicator of energy content per unit volume and of natural gas liquids richness. Note that inert gases such as carbon dioxide and nitrogen also raise specific gravity while lowering heating value, so a high value does not by itself mean rich gas.
|
choke_size |
int16 |
yes |
Choke size in 64ths of an inch.
|
flowing_pressure |
int32 |
yes |
Flowing wellhead pressure in psi.
|
shut_in_pressure |
int32 |
yes |
Shut-in wellhead pressure in psi.
|
producing_method |
string |
yes |
Lift type during the test: flowing, pumping, gas_lift, plunger_lift, or esp (electric submersible pump).
Values: flowing · pumping · gas_lift · plunger_lift · esp. |
test_duration_hours |
int16 |
yes |
Hours the well was tested.
|
data_source |
string |
yes |
Which source record the test came from (e.g. rrc_g10, ndic, ocd_well_detail, la_sonris_well_tests). Free text, not a fixed list - new values appear as regions are added.
|
