gold_well_tests
One row per well test - initial potential, deliverability, surveys and retests - with tested oil, gas and water rates, gas-oil ratio as reported, flowing and shut-in pressures, and test duration. Test rates are short-duration measurements; monthly production is the sustained record.
Access tier: portal
Portal. These rows are well-level or producing-unit-level data, or our modelled output at cohort or grid grain. They open with a Portal, Pro or Enterprise plan. The website shows aggregates built from them, never the rows.
Primary key: test_id
Region codes: bc, la, nd, nm, ok, pa, tx, ut
Data currency
Regions with a fixed end date in this table (every other listed region updates as its source publishes):
- British Columbia: data through 2024-10-01. This table is no longer updated.
- North Dakota: data through 2021-04-16. This table is no longer updated.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
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. |
test_type |
string | yes | Kind of test: initial_potential, survey, retest, or deliverability.
Values: initial_potential · survey · retest · deliverability. |
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. |
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 one; otherwise computed from the tested gas and oil rates (gas in cubic feet divided by oil in barrels). |
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. |
Region-specific columns
Extra columns a single region's source adds.
bc (2 columns)
| Column | Type | Description |
|---|---|---|
wa_number |
string | |
aofp_test_method |
string |
la (1 column)
| Column | Type | Description |
|---|---|---|
la_well_serial |
string |
nd (1 column)
| Column | Type | Description |
|---|---|---|
file_no |
int64 |
nm (2 columns)
| Column | Type | Description |
|---|---|---|
pool_id |
string | |
pool_name |
string |
ok (1 column)
| Column | Type | Description |
|---|---|---|
completion_no |
int32 |
pa (2 columns)
| Column | Type | Description |
|---|---|---|
form_type |
string | |
annular_pressure |
int32 |
tx (8 columns)
| Column | Type | Description |
|---|---|---|
well_identifier_id |
string | |
district |
string | |
lease_no |
string | |
well_number |
string | |
type_well |
string | |
shut_in_month |
date | Month the well was declared shut in. On statewide-query W-10 filings this is the filing's effective date, the month the declared status takes effect; on the W-10 tape feeds it is the RRC's own shut-in date field, the date the well was shut in or last utilized. |
sl_adjusted |
boolean | |
sl_proxy |
boolean |
How these numbers are built is on methodology; the machine twin of this page is data-dictionary.json.