gold_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 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
Region codes: activity
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
source |
string | no | Which published series the row belongs to. 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. |
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.