← All tables

gold_producing_units

The register of producing units coarser than a single well (an FPSO, an oil-sands project, a field, or a whole country), used where a source reports production at that level rather than per well. Each unit carries its grain, jurisdiction, and operator. Volumes live in gold_unit_production; the gold.production view unifies well-grain and unit-grain series into one all-grain read 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
Region codes: ab, colombia, ecuador, eia, eia_intl, guyana, mexico, nl_offshore, ok

Columns

Column	Type	Nullable	Description
producing_unit_id	string	no	Globally unique producing-unit identifier (opaque string), this table's primary key. Never parse substrings out of it. This register stores only units coarser than a well; in the unified gold.production view, well-grain series carry the well's well_id in this role.
grain	string	no	The unit's metering grain, the level at which its production is reported: facility (e.g. an FPSO), project (e.g. an oil-sands mine), field, lease (a regulator lease/unit reporting entity), block (a licensed concession/exploitation block), operator (one operator's whole reported portfolio in a jurisdiction, where the source publishes no finer split), state (a state-level series where no finer source exists), or country. Wells are never stored in this register; the unified gold.production view carries grain 'well' for well-grain series. Values: facility · project · field · lease · block · operator · state · country.
name	string	no	Human-readable unit name (e.g. "Liza Unity", "Guyana"). Casing follows the publishing source (some regulators publish upper-case names, others title-case), and names are not unique: unit_id is the key, and the same name can appear in more than one country or casing. Compare or de-duplicate names case-insensitively.
country	string	no	Country code (ISO 3166-1 alpha-2, upper-case, e.g. GY).
region	string	yes	State, province, or sub-national area where applicable; NULL for supra-regional or national units (e.g. a country-grain row).
parent_unit_id	string	yes	The unit's parent in the roll-up hierarchy, e.g. a facility points at its country roll-up unit; the country unit has NULL (top). The hierarchy is ragged rather than a fixed tree (one FPSO can serve many fields). Production is never double-counted along this chain: no unit carries production while an ancestor also does. The chain follows how volumes are actually reported and aggregated, which is not always the same as licensing or concession geography: where a regulator meters a field into a different block than the concession catalogue lists it under, the parent shown here is the one whose reported volumes contain it.
operator	string	yes	The company operating this unit today, as a canonical company name: one current value per unit, with mergers and acquisitions applied as of today. May lag a recent transfer, because it is taken from the latest operator on file. For the operator during a particular month, read operator on gold_unit_production, which carries the owner at that month. NULL when unresolved, or where no operator applies at this unit's grain (e.g. state or national roll-ups).
operator_id	string	yes	Stable company identifier for operator: the owner as of today. Join key to the organizations register (gold_organizations). NULL when the operator name cannot be resolved to a registered organization, or where no operator applies at this grain.
latitude	float64	yes	Representative point for the unit (WGS84), e.g. an FPSO's mooring location. NULL where no single representative point applies (e.g. a country unit).
longitude	float64	yes	Representative point longitude (WGS84). Sourced as a pair with latitude.

Region-specific columns

Extra columns a single region's source adds.

eia (1 column)

Column	Type	Description
source	string	Who reported these volumes. `eia` for this container: the U.S. Energy Information Administration, whose state-level series covers producing states that publish no well-level data of their own.

eia_intl (1 column)

Column	Type	Description
source	string	Who reported these volumes. `eia` for this container: the U.S. Energy Information Administration, whose International Energy Statistics cover producing countries that publish no well-level data of their own.

mexico (2 columns)

Column	Type	Description
campo_sih	string
ubicacion	string

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