gold_well_forecast_months
Our deployed production forecast: one row per well per future month, oil and gas, starting the month after the well's last reported month and extending up to 120 months (truncated at the economic limit). oil_per_month and gas_per_month are expected values: additive across wells, so portfolio sums are portfolio forecasts. p10/p50/p90 bands appear where an uncertainty model backs them (petroleum convention: P10 optimistic). Which model produced a well's forecast lives in gold_well_forecast_provenance.
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: well_id, forecast_month
Region codes: ab, ak, al, ar, argentina, bc, brazil, ca, co, gom, ks, la, mb, mexico, mi, ms, mt, nd, nm, oh, ok, pa, pacific, sk, tx, ut, wv, wy
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
well_id |
string | no | Join key to the well register (gold_wells). |
forecast_month |
date | no | The month being forecast, always the first day of the month. Strictly after the well's last reported production month. |
year |
int16 | no | Calendar year of the forecast month (equals the year of forecast_month). Provided for fast year-level filtering and partition pruning. |
oil_per_month |
int32 | yes | Mean (expected value) oil forecast in BBL/month. Always populated for oil-producing wells. Used directly for NPV calculations and additive for portfolio aggregation (the sum of well means is the portfolio mean). NULL for gas-only wells. |
oil_per_month_p10 |
int32 | yes | Optimistic oil forecast in BBL/month (petroleum convention: a 10% chance of exceeding). NULL where no calibrated uncertainty model backs the well: the band is omitted rather than substituted with the point forecast, so a present band is always a real interval. |
oil_per_month_p50 |
int32 | yes | Median oil forecast in BBL/month. Populated only where a quantile model with sufficient calibration depth backs it; NULL otherwise. Distinct from oil_per_month (the mean): production distributions are skewed, especially late in life, so median and mean legitimately diverge: both are honest values for different questions; don't substitute one for the other. |
oil_per_month_p90 |
int32 | yes | Pessimistic oil forecast in BBL/month (petroleum convention: a 90% chance of exceeding). NULL where no uncertainty model backs the well. |
gas_per_month |
int32 | yes | Mean (expected value) gas forecast in MCF/month. NULL for oil-only wells. Same semantics as oil_per_month. |
gas_per_month_p10 |
int32 | yes | Optimistic gas forecast in MCF/month (petroleum convention: a 10% chance of exceeding). NULL where no uncertainty model backs the well. |
gas_per_month_p50 |
int32 | yes | Median gas forecast in MCF/month. Populated only where a quantile model backs it; for skewed distributions the median differs from the mean. |
gas_per_month_p90 |
int32 | yes | Pessimistic gas forecast in MCF/month (petroleum convention: a 90% chance of exceeding). NULL where no uncertainty model backs the well. |
How these numbers are built is on methodology; the machine twin of this page is data-dictionary.json.