← All tables

gold_organization_event_wells

The specific wells covered by a scoped organization event. When an asset transfer moves only part of a company's assets, this holds the frozen set of wells the deal covered as of its effective date. Most events apply to whole organizations and need no well list, so this table is small and may be empty.

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: event_id, well_id
Region codes: organizations

Columns

Column	Type	Nullable	Description
event_id	string	no	The scoped event (join to gold_organization_events).
well_id	string	no	A well covered by the event (join to gold_wells).
source	string	yes	How the well entered the set: `curated` = hand-specified, `admin_filter` = selected by administrative attributes, `geometry` = selected by geographic footprint, `well_list` = imported from a published deal well list. Values: curated · admin_filter · geometry · well_list.

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