← All tables

gold_well_type_curves

Stored type curves: for each cohort (basin-by-formation, plus coarser analog pools), the peak-normalized median decline shape by month-on-production with a p10/p90 donor-dispersion band. Scale a curve by a well's own peak to get that well's expected profile. The basin and region-analog curves are the ones that drive our new-well and total-supply projections; the two sub_region grains (model and descriptive) describe an area's own wells without feeding any projection. curve_grain, n_donors and is_extrapolated tell you the cohort grain, how many wells back the curve, and where the tail is extrapolated rather than donor-backed.

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: atom_def_version, curve_grain, curve_key_hash, stream, mop
Region codes: ab, ak, al, ar, argentina, bc, brazil, ca, co, gom, ks, la, mb, mexico, ms, mt, nd, nm, oh, ok, pa, sk, tx, ut, wv, wy

Columns

Column	Type	Nullable	Description
atom_def_version	string	no	Version of the frozen cohort definition the curve was built over. Part of the primary key: a rebuild under a new cohort definition is a new curve, not a rewrite.
curve_grain	string	no	The grain of the cohort behind this curve: sub_region_formation (finest: subdivision x formation), sub_region_formation_descriptive (the same subdivision x formation cohort measured over ALL its wells: published for areas, typically low-rate stripper counties, whose representative-well pool is too thin for a model curve; descriptive of what the area's wells did, not an input to any forecast), basin_formation (basin x formation), region_analog (state/province x trajectory x stream, the coarsest same-region pool), cross_region_analog (a pool borrowed from an analog region). Coarser grains back wells whose own cohort is too thin. Values: sub_region_formation · sub_region_formation_descriptive · basin_formation · region_analog · cross_region_analog.
curve_key_hash	string	no	Stable identifier of the curve's cohort (opaque 12-character code), the curve id. Never parse it.
stream	string	no	'oil' | 'gas'. One curve per (grain, stream). Values: oil · gas.
mop	int16	no	Month on production, starting at 1: the curve's x-axis.
norm_rate	float64	no	The cohort's median rate at this month, as a fraction of each well's own peak rate (each donor well is scaled by its own peak before the cohort median is taken; stored to 6 decimals). Multiply by a well's peak rate to get that well's expected profile. Between 0 and 1: the curve's maximum is typically below 1.0 because donors peak at different months. Not strictly declining in early months (the empirical median can rise for conventional and workover cohorts), but always declining in the terminal tail.
norm_rate_p10	float64	yes	Optimistic band (petroleum convention, the higher normalized rate): the spread across the cohort's wells, not model error. NULL at months where too few wells report to define it.
norm_rate_p90	float64	yes	Pessimistic band (petroleum convention, the lower normalized rate). NULL at months where too few wells report.
is_extrapolated	bool	no	False where enough cohort wells back this month of the curve; true where the value is extrapolated: before the first well-supported month (held flat) or past the last (the constant-decline tail).
n_donors	int32	no	Number of wells contributing to the curve. Constant per curve.
terminal_decline_per_month	float64	no	The constant monthly decline applied past the last well-supported month (bounded between 0.1% and 10% per month, so the tail always declines). Constant per curve.
state_or_province	string	no	The cohort's state or province (always present: region grain or finer).
sub_region	string	yes	The administrative subdivision one level below state_or_province (US: county, disambiguated across states; Alberta/Saskatchewan: municipal district; Gulf of Mexico: protraction area). NULL except for curves at the sub_region_formation and sub_region_formation_descriptive grains, and NULL for country-modeled regions whose province or state is already the state_or_province axis.
basin	string	yes	Cohort basin. NULL at the region_analog / cross_region_analog grains.
trajectory_group	string	no	'horizontal' | 'other'. Always present.
sub_formation	string	yes	Cohort sub-formation. NULL where the cohort is not split by sub-formation.
vintage_bucket	string	yes	The cohort's well-vintage grouping. NULL where the cohort is not split by vintage.

How these numbers are built is on methodology; the machine twin of this page is data-dictionary.json.