rig_activity

Active drilling-rig counts, a leading indicator of upcoming supply. Parallel series from independent published sources, each at its native breakdown: the Baker Hughes weekly North America count, the Baker Hughes monthly international count by country, and Mexico's monthly regulator series. Series are never mixed or reconciled, so each row matches the figure its source publishes. Where a source does not break down an axis, that column carries `all`: aggregate only within one source and one period type.

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: source, date, country, state_province_code, area, basin, environment, rig_purpose, target, trajectory, operator
Scope: cross-region registry, one table covering all regions

Columns

Column	Type	Nullable	Description
source	string	no	Which provider published the series: sih or bakerhughes. A series is one source at one cadence, so a provider can carry more than one. Never sum across sources: they are independent measurements of rig activity. Values: sih · bakerhughes.
date	date	no	Start date of the period the count covers.
period	string	no	Reporting cadence of the series: `month` or `week`. Don't mix cadences when aggregating. Values: month · week.
period_end_date	date	no	The date the reported period runs to: for weekly series the source's own week-ending date (holiday weeks shift it earlier in the week), for monthly series the last day of the month. The date column carries the period's start.
country	string	no	Country (ISO 3166-1 alpha-2).
state_province_code	string	no	State or province code; `unassigned` where the source declines to place a rig in any state or province; `all` where the source doesn't split by state.
state_province	string	no	State or province name as the source publishes it; `unassigned` where the source declines to place a rig in any state or province; `all` where the source doesn't split by state.
area	string	no	The source's own sub-state area label (US county, Canadian sub-province area); `unassigned` where the source declines to place a rig; `all` where not broken down.
county_fips	string	yes	Five-digit US county FIPS code where the area is a US county; NULL for Canadian areas, offshore areas, and rows not split by area.
basin	string	no	Source-reported basin, or `all` where not split.
environment	string	no	Operating environment: onshore, offshore water-depth bands, or inland waters; `all` where not split. Values: onshore · offshore · offshore_shallow · offshore_deep · offshore_ultra_deep · inland_waters · all.
rig_purpose	string	no	Purpose of drilling: `development`, `exploration`, `appraisal`; `all` where not split. Values: development · exploration · appraisal · all.
target	string	no	Target hydrocarbon: `oil`, `gas`, or `misc`; `all` where not split. Values: oil · gas · misc · all.
trajectory	string	no	Wellbore trajectory: `horizontal`, `directional`, `vertical`, the source's own `other` residual bucket; `all` where not split. Values: horizontal · directional · vertical · other · all.
operator	string	no	Operator name where the source splits by operator (the Mexico series does); `all` otherwise.
operator_id	string	yes	Our organization id for the operator, where resolvable; NULL otherwise.
active_rigs	float64	no	Average active rigs over the period, as reported by the source. Monthly averages can be fractional.

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