← All tables

gold_unit_production

Monthly production volumes for producing units coarser than a single well (an FPSO, a project, a field, or a whole country), one row per unit per month. This is the companion of the well-grain production table for sources that report at coarser grain; the unit's name, grain, and jurisdiction live on the producing-units register (gold_producing_units). A volume is NULL when that stream isn't reported at this unit's grain (e.g. gas metered nationally while oil is per-facility): NULL means no series at this grain, never zero. The gold.production view unifies this table with well-grain production into one all-grain surface.

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: producing_unit_id, date, period_days
Region codes: ab, colombia, ecuador, eia, eia_intl, guyana, mexico, nl_offshore, ok

Data currency

Regions with a fixed end date in this table (every other listed region updates as its source publishes):

• Mexico: data through 1999-12-01. This table is no longer updated. Mexican production from 2000 onward is published per well in the well production table, not here. This field-level series covers the years before that.

Columns

Column	Type	Nullable	Description
producing_unit_id	string	no	Producing-unit identifier (opaque string, e.g. gy:stabroek:facility:liza-unity): the join key to gold_producing_units, which carries the unit's name, grain, and jurisdiction. Never parse substrings out of it.
date	date	no	Production month, always the first day of the month. Sources that publish daily series are aggregated to the month.
oil_per_month	int64	yes	Oil produced during the month, in barrels (BBL), including condensate. NULL when this unit has no oil series at its grain (e.g. a national roll-up carrying only gas): NULL means not reported at this grain, never zero.
gas_per_month	int64	yes	Natural gas produced during the month, in thousand cubic feet (MCF). NULL when this unit has no gas series at its grain (e.g. an FPSO whose gas is metered only nationally): NULL is not zero; we never fabricate a split the source doesn't report.
water_per_month	int64	yes	Water produced during the month, in barrels (BBL). NULL where the grain has no water series.
producing_days	int16	yes	Days the unit actually produced during this period, as reported by the source. Usually NULL for coarse grains: facility and national series rarely report it. Distinct from period_days (the calendar length of the period): producing_days counts days WITH production.
period_days	int16	no	Calendar length of this row's reporting period, in days: 28-31 for a monthly row, 365 or 366 for an annual one (some agency series report gas only per year). Always derived from the row's own period, so leap years are exact. Divide a volume by this for a daily rate.
operator	string	yes	Company operating this unit during this month, ownership changes (M&A) applied as of this month. For units whose source publishes no per-month operator, populated only where the operator is genuinely constant over the stored span, or inherited from the containing unit (e.g. a field inherits its block's operator); NULL where no operator applies at this grain (e.g. state or national roll-ups).
operator_id	string	yes	Stable company identifier for operator: the owner at this month. Join key to the organizations register. NULL when the operator name does not resolve or no operator applies at this grain.
reported_operator	string	yes	The operator exactly as the regulatory source records it for this unit and month, resolved to a company (no merger succession applied). NULL where the source publishes no operator at this unit's grain.
reported_operator_id	string	yes	Stable company identifier for reported_operator (no merger succession). NULL wherever reported_operator is NULL (see there), and additionally where a published name is not yet mapped to a registered organization, so a NULL id beside a populated reported_operator_entity means an unmapped name, not a missing operator.
reported_operator_entity	string	yes	The operator name exactly as printed by the source for this unit and month, before any cleaning or resolution. NULL where the source publishes no operator at this grain: a populated operator beside a NULL reported_operator_entity means the value was inherited or curated, not printed by the source.
reported_operator_registration_id	string	yes	The regulator's own company registration id as printed by the source for this unit and month (e.g. Oklahoma OTC company number), passed through raw. NULL otherwise.
record_origin	string	no	How this row was derived: the same provenance vocabulary as well-grain production (reported, gap_filled, lease_allocated, period_allocated, reconciled, wellstar_estimated, source_corrupt). Coarse-grain unit rows are typically reported. Values: reported · gap_filled · lease_allocated · period_allocated · reconciled · wellstar_estimated · source_corrupt.

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