gold_organizations
Master register of the companies behind the wells: operators, service companies, midstream, integrated and downstream groups. One row per organization, deduplicated across regions and name variants; operator id columns across the well, production, and permit tables reference it by organization_id. Where a company was acquired, merged, or renamed, successor_id points to the organization that carries on.
Access tier: public_aggregate
Public. These rows are the public layer: aggregate series and reference records such as companies, formations and rig counts. Where a page publishes them you can read them on the website, and a free account can export the aggregate series behind a view (10 a month).
Primary key: organization_id
Region codes: organizations
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
organization_id |
string | no | Stable organization identifier (opaque slug). Operator id columns across our tables join to this. |
name |
string | no | Canonical organization name. |
short_name |
string | yes | Shorter display name, where one is in common use. |
organization_type |
string | no | Kind of business. `e_and_p` = exploration & production (well operators); `integrated` = majors spanning upstream to downstream; `placeholder` = internal bucket for unattributable operators rather than a real company.
Values: e_and_p · integrated · downstream · midstream · service · government · power_generation · placeholder · other. |
is_public |
boolean | yes | True when the organization is publicly listed; NULL where not yet researched. |
ticker |
string | yes | Stock ticker, for public companies. |
exchange |
string | yes | Listing exchange, for public companies. |
website |
string | yes | Company website. |
country |
string | yes | Country of registration or head office (ISO 3166-1 alpha-2). |
state_province |
string | yes | Head-office state or province, where known. |
status |
string | no | Lifecycle status. `inactive` = dormant but still extant; `acquired`, `merged`, and `renamed` mean the entity ended in that event: follow successor_id to the continuing organization; `unknown` = not yet researched.
Values: active · inactive · acquired · merged · dissolved · renamed · unknown. |
successor_id |
string | yes | For acquired, merged, or renamed organizations: the organization_id that carries on. Follow the chain to reach the current entity. |
successor_effective_date |
date | yes | Date the succession took effect. |
parent_organization_id |
string | yes | The organization this one rolls up to for company-level totals: a parent or holding company. Node identity is unchanged: production stays attributed to the operating entity. NULL where no parent is recorded: the company may be independent, not yet researched, or part of an affiliate group that has no holding company, so NULL does not mean independent. |
How these numbers are built is on methodology; the machine twin of this page is data-dictionary.json.