North America rig-count momentum by state/province (weekly, Baker Hughes)
Weekly rig-count momentum for 26 US states, Canadian provinces and NL Offshore from Baker Hughes' North America Rotary Rig Count report (keyless XLSX, 2024-01-05 -> present), aggregated from the workbook's county x basin x trajectory detail rows. Per state-week: total/oil/gas/misc rigs, week-over-week / 4-week / 52-week changes and YoY percent, a trailing-52-week z-score, a documented 5-state activity_regime classifier, and a documented 0-100 activity_score composite. Who joins this: a sales team joins week_ending + region_code to rep quotas and pipeline to weight energy-region territories (TX, NM, ND, AB) by drilling momentum; a subscription business selling into oilfield services joins churn/expansion to region_code for demand-regime features. Source: Baker Hughes.
Les titres et les descriptions proviennent des sources de données, en anglais.
- Source
- Baker Hughes
- Lignes
- 2 935
- Colonnes
- 19
- Cadence de la source
- Hebdomadaire
- Dernière actualisation
- 1 oct. 2026
- Thème
- energy
| Colonne | Type | Description |
|---|---|---|
| week_ending | string | Survey week (usually Friday; shifted earlier when Friday is a holiday), ISO date. Primary join key: a business joins its own weekly series on this date. (unit: ISO date) |
| country_code | string | ISO alpha-3 country code (USA / CAN). (unit: ISO 3166-1 alpha-3) |
| country | string | Canonical country name (United States / Canada). |
| region | string | State/province display name (e.g. Texas, Alberta). |
| region_code | string | USPS code for US states, Canada Post code for provinces, NL-OFF for NL Offshore, CAN-UNK/US-UNK for the rare upstream-unclassified rig (exactly one in workbook history: CANADA, week of 2026-09-11). Join key for state/province-grain business tables. (unit: code) |
| total_rigs | integer | Active rotary rigs in the geography-week (sum of the workbook's county x basin x trajectory detail rows). The anchor series for every derived feature. (unit: rigs) |
| oil_rigs | integer | Rigs drilling for oil. (unit: rigs) |
| gas_rigs | integer | Rigs drilling for gas. (unit: rigs) |
| misc_rigs | integer | Rigs drilling for other targets. (unit: rigs) |
| oil_share_pct | float | 100 * oil_rigs / total_rigs. (unit: percent) |
| rigs_wow | integer | Week-over-week change in total rigs. (unit: rigs) |
| rigs_4w_chg | integer | 4-week change in total rigs. (unit: rigs) |
| rigs_yoy_chg | integer | 52-week change in total rigs. (unit: rigs) |
| rigs_yoy_pct | float | 52-week percent change in total rigs. Null when the year-ago total is 0 or missing. (unit: percent) |
| zscore_52w | float | Z-score of total rigs against the trailing 52 weeks (exclusive of the current week). Null until 52 weeks of history exist. (unit: z-score) |
| activity_regime | string | Documented 5-state classifier on zscore_52w: deep_contraction (<= -1.5), contracting (-1.5, -0.5], neutral (-0.5, +0.5), expanding (+0.5, +1.5], boom (> +1.5). (unit: category) |
| activity_score | float | Documented 0-100 composite: clip(0.6 * level_pctile_156w + 0.4 * (50 + 25 * zcap), 0, 100), where level_pctile_156w is the 0-100 percentile rank of the rig total within the trailing up-to-156 weeks (min 52 weeks of history) and zcap = clip(zscore_52w, -2, +2). High = hot and accelerating drilling: a demand tailwind for energy-region businesses. Null until 52 weeks of history exist. (unit: 0-100 score) |
| source_url | string | Exact Baker Hughes report URL behind this row's provenance. (unit: URL) |
| row_hash | string | Deterministic 16-hex row id: sha256('BHRIG|<dataset>|<week_ending>|<geo>'). (unit: hash) |
10 premières lignes d’exemple — un aperçu, pas le jeu de données complet.
| week_ending | country_code | country | region | region_code | total_rigs | oil_rigs | gas_rigs | misc_rigs | oil_share_pct | rigs_wow | rigs_4w_chg | rigs_yoy_chg | rigs_yoy_pct | zscore_52w | activity_regime | activity_score | source_url | row_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2024-01-05 | CAN | Canada | Alberta | AB | 91 | 45 | 46 | 0 | 49,5 | — | — | — | — | — | — | — | https://rigcount.bakerhughes.com/static-files/f686dcd4-6693-44a3-8a39-4d9a329f0679 | fe1e9632847ddae4 |
| 2024-01-05 | CAN | Canada | British Columbia | BC | 20 | 0 | 20 | 0 | 0 | — | — | — | — | — | — | — | https://rigcount.bakerhughes.com/static-files/f686dcd4-6693-44a3-8a39-4d9a329f0679 | 37d915c8b4b98698 |
| 2024-01-05 | CAN | Canada | Manitoba | MB | 1 | 1 | 0 | 0 | 100 | — | — | — | — | — | — | — | https://rigcount.bakerhughes.com/static-files/f686dcd4-6693-44a3-8a39-4d9a329f0679 | b9f2daccb7ead500 |
| 2024-01-05 | CAN | Canada | NL Offshore | NL-OFF | 1 | 1 | 0 | 0 | 100 | — | — | — | — | — | — | — | https://rigcount.bakerhughes.com/static-files/f686dcd4-6693-44a3-8a39-4d9a329f0679 | b7367d68a14d3033 |
| 2024-01-05 | CAN | Canada | Saskatchewan | SK | 12 | 11 | 1 | 0 | 91,7 | — | — | — | — | — | — | — | https://rigcount.bakerhughes.com/static-files/f686dcd4-6693-44a3-8a39-4d9a329f0679 | 3f862b3b7a4edad2 |
| 2024-01-05 | USA | United States | Alaska | AK | 10 | 9 | 1 | 0 | 90 | — | — | — | — | — | — | — | https://rigcount.bakerhughes.com/static-files/f686dcd4-6693-44a3-8a39-4d9a329f0679 | 99a5222df161f3d5 |
| 2024-01-05 | USA | United States | California | CA | 4 | 2 | 1 | 1 | 50 | — | — | — | — | — | — | — | https://rigcount.bakerhughes.com/static-files/f686dcd4-6693-44a3-8a39-4d9a329f0679 | 392190eb5ca932f1 |
| 2024-01-05 | USA | United States | Colorado | CO | 17 | 13 | 4 | 0 | 76,5 | — | — | — | — | — | — | — | https://rigcount.bakerhughes.com/static-files/f686dcd4-6693-44a3-8a39-4d9a329f0679 | f7813c185c254072 |
| 2024-01-05 | USA | United States | Kansas | KS | 1 | 1 | 0 | 0 | 100 | — | — | — | — | — | — | — | https://rigcount.bakerhughes.com/static-files/f686dcd4-6693-44a3-8a39-4d9a329f0679 | e1eea38eca6d4ba1 |
| 2024-01-05 | USA | United States | Louisiana | LA | 42 | 15 | 27 | 0 | 35,7 | — | — | — | — | — | — | — | https://rigcount.bakerhughes.com/static-files/f686dcd4-6693-44a3-8a39-4d9a329f0679 | 2c8b3201f89fce52 |
Profilé le 1 oct. 2026 à partir de l’instantané 20261001T222553Z-b9d4e0a6eb90
Mesuré- Complétude
- 88,9 %
- Lignes
- 2 935
- Colonnes
- 19
- Colonnes incomplètes
- 7
| Colonne | Manquant | Distinctes | Plage | Distribution |
|---|---|---|---|---|
| week_endingvarchar | 0 % | 150 | — |
|
| country_codevarchar | 0 % | 2 | — |
|
| countryvarchar | 0 % | 2 | — |
|
| regionvarchar | 0 % | 24 | — |
|
| region_codevarchar | 0 % | 31 | — |
|
| total_rigsbigint | 0 % | 239 | 1 → 308médiane 13 | 28 hors du 1er–99e centile |
| oil_rigsbigint | 0 % | 189 | 0 → 276médiane 8 | 28 hors du 1er–99e centile |
| gas_rigsbigint | 0 % | 59 | 0 → 63médiane 3 | 30 hors du 1er–99e centile |
| misc_rigsbigint | 0 % | 5 | 0 → 4médiane 0 | 12 hors du 1er–99e centile |
| oil_share_pctdouble | 0 % | 323 | 0 → 100médiane 72,7 | |
| rigs_wowbigint | 0,92 % | 38 | -46 → 74médiane 0 | 53 hors du 1er–99e centile |
| rigs_4w_chgbigint | 3,6 % | 75 | -65 → 107médiane 0 | 57 hors du 1er–99e centile |
| rigs_yoy_chgbigint | 39,7 % | 79 | -60 → 45médiane 0 | 31 hors du 1er–99e centile |
| rigs_yoy_pctdouble | 39,7 % | 442 | -83,33 → 300médiane 0 | 34 hors du 1er–99e centile |
| zscore_52wdouble | 42,4 % | 565 | -7,07 → 7,07médiane -0,09 | 34 hors du 1er–99e centile |
| activity_regimevarchar | 42,4 % | 5 | — |
|
| activity_scoredouble | 42,4 % | 967 | 0,5 → 100médiane 48,8 | 27 hors du 1er–99e centile |
| source_urlvarchar | 0 % | 1 | — |
|
| row_hashvarchar | 0 % | 2 659 | — |
|
- Actuelle
20261001T222553Z-b9d4e0a6eb90 · sha256 b9d4e0a6eb90…
2 935 lignes · premier instantané
Dirigez n’importe quel LLM vers le point d’accès des métadonnées — la documentation ci-dessus est aussi lisible par machine (JSON-LD + Croissant).
curl "https://datazimuts.com/v1/datasets/bh_rig_activity_signals/na_rig_activity_state_weekly" | jq '{title, rows, columns_count, license}'import requests
ds = requests.get("https://datazimuts.com/v1/datasets/bh_rig_activity_signals/na_rig_activity_state_weekly").json()
print(ds["title"], ds["rows"], "rows")
# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
print(row)Point d’accès API : https://datazimuts.com/v1/datasets/bh_rig_activity_signals/na_rig_activity_state_weekly
Astuce : récupérez /llms.txt pour le catalogue complet lisible par machine.
D’où viennent ces données et ce qui en a été fait. Le travail des autres apparaît sous forme de décomptes ; seuls les projets partagés sont nommés.
Citer cet instantané
Épinglé à l’instantané 20261001T222553Z-b9d4e0a6eb90 et à son empreinte, pour que vos lecteurs obtiennent exactement les données utilisées.
Baker Hughes. (2026). North America rig-count momentum by state/province (weekly, Baker Hughes) [Data set, snapshot 20261001T222553Z-b9d4e0a6eb90, sha256 b9d4e0a6eb90]. Datazimuts. Retrieved 2026-10-02, from https://datazimuts.com/fr/datasets/bh_rig_activity_signals/na_rig_activity_state_weekly?snapshot=20261001T222553Z-b9d4e0a6eb90
@misc{dz_bh_rig_activity_signals_na_rig_activity__b9d4e0a6,
title = {{North America rig-count momentum by state/province (weekly, Baker Hughes)}},
author = {{Baker Hughes}},
year = {2026},
publisher = {Datazimuts},
howpublished = {\url{https://datazimuts.com/fr/datasets/bh_rig_activity_signals/na_rig_activity_state_weekly?snapshot=20261001T222553Z-b9d4e0a6eb90}},
note = {Snapshot 20261001T222553Z-b9d4e0a6eb90, sha256 b9d4e0a6eb90e218ac6d994e9d62d3960bf9a4c5d31a2ce522ae0cf2077510cc; accessed 2026-10-02}
}Intégrer un tableau ou un graphique
Collez ce code dans n’importe quelle page. L’intégration est épinglée au même instantané, suit le thème clair ou sombre du lecteur et affiche toujours la source, la licence et un lien de retour.
<iframe src="https://datazimuts.com/embed/chart?dataset=bh_rig_activity_signals%2Fna_rig_activity_state_weekly&lang=fr&theme=auto&snapshot=20261001T222553Z-b9d4e0a6eb90&x=week_ending&y=total_rigs&agg=avg" title="North America rig-count momentum by state/province (weekly, Baker Hughes)" width="100%" height="380" style="border:0" loading="lazy"></iframe>
Posez une question sur ce jeu de données. Les réponses viennent uniquement de sa fiche, de son profil mesuré et de son historique, et citent les faits utilisés.