cik int64 4.9k 1.69M | ticker stringlengths 1 6 ⌀ | company stringlengths 6 30 | location stringlengths 5 5 | sic int64 1.04k 4.95k | industry stringclasses 7
values | latest_period_end stringdate 2025-12-31 00:00:00 2026-09-30 00:00:00 | aro_latest_usd float64 3.33B 15B | aro_basis stringclasses 2
values | aro_1y_prior_usd float64 3.55B 12.7B ⌀ | aro_change_1y_usd float64 -1,389,000,000 2.32B ⌀ | aro_growth_1y_pct float64 -13.57 18.3 ⌀ | aro_3y_prior_usd float64 2.45B 12.7B ⌀ | aro_5y_prior_usd float64 2.45B 13.6B ⌀ | aro_cagr_5y_pct float64 -5.88 11.8 ⌀ | aro_first_period_end stringdate 2019-03-31 00:00:00 2025-12-31 00:00:00 | aro_first_usd float64 1.43B 13B | total_assets_usd float64 42.6B 449B | aro_pct_of_assets float64 1.61 15.5 | accretion_expense_latest_fy_usd float64 164M 623M ⌀ | new_obligations_incurred_latest_fy_usd float64 0 3.14B ⌀ | obligations_settled_latest_fy_usd float64 6M 1.29B ⌀ | quarters_reported int64 2 31 | flags stringclasses 4
values |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
93,410 | CVX | CHEVRON CORP | US-TX | 2,911 | Petroleum Refining | 2025-12-31 | 14,988,000,000 | AssetRetirementObligation | 12,667,000,000 | 2,321,000,000 | 18.32 | 12,701,000,000 | 13,616,000,000 | 1.94 | 2019-12-31 | 12,832,000,000 | 324,012,000,000 | 4.63 | 617,000,000 | 186,000,000 | 1,109,000,000 | 10 | Settling 5%+ of ARO a year (active decommissioning); ARO of $1B or more |
34,088 | null | EXXON MOBIL CORP | US-TX | 2,911 | Petroleum Refining | 2025-12-31 | 12,518,000,000 | AssetRetirementObligation | 12,032,000,000 | 486,000,000 | 4.04 | 10,491,000,000 | 11,247,000,000 | 2.16 | 2019-12-31 | 11,280,000,000 | 448,980,000,000 | 2.79 | 623,000,000 | 539,000,000 | 1,289,000,000 | 7 | Settling 5%+ of ARO a year (active decommissioning); ARO of $1B or more |
1,326,160 | DUK | Duke Energy CORP | US-NC | 4,931 | Electric & Other Services Combined | 2026-03-31 | 9,610,000,000 | Noncurrent+Current | 9,993,000,000 | -383,000,000 | -3.83 | 12,719,000,000 | 13,008,000,000 | -5.88 | 2019-03-31 | 13,035,000,000 | 198,048,000,000 | 4.85 | 474,000,000 | 18,000,000 | 584,000,000 | 29 | Settling 5%+ of ARO a year (active decommissioning); ARO of $1B or more |
92,122 | SO | SOUTHERN CO | US-GA | 4,911 | Electric Services | 2026-03-31 | 9,566,000,000 | Noncurrent+Current | 9,893,000,000 | -327,000,000 | -3.31 | 10,918,000,000 | 10,685,000,000 | -2.19 | 2019-03-31 | 9,428,000,000 | 157,031,000,000 | 6.09 | 393,000,000 | 6,000,000 | 634,000,000 | 29 | ARO is 5%+ of total assets; Settling 5%+ of ARO a year (active decommissioning); ARO of $1B or more |
1,376,986 | TVE | Tennessee Valley Authority | US-TN | 4,911 | Electric Services | 2026-06-30 | 9,535,000,000 | AssetRetirementObligation | 10,924,000,000 | -1,389,000,000 | -12.72 | 7,122,000,000 | 6,952,000,000 | 6.52 | 2019-03-31 | 4,977,000,000 | 61,644,000,000 | 15.47 | null | 3,136,000,000 | 270,000,000 | 30 | ARO is 5%+ of total assets; ARO of $1B or more |
17,797 | null | DUKE ENERGY PROGRESS, LLC. | US-NC | 4,931 | Electric & Other Services Combined | 2026-09-30 | 9,332,000,000 | AssetRetirementObligation | null | null | null | null | null | null | 2025-12-31 | 9,625,000,000 | 203,863,000,000 | 4.58 | null | null | null | 3 | ARO of $1B or more |
1,163,165 | COP | CONOCOPHILLIPS | US-TX | 2,911 | Petroleum Refining | 2025-12-31 | 8,364,000,000 | AssetRetirementObligation | 8,215,000,000 | 149,000,000 | 1.81 | 6,380,000,000 | 5,573,000,000 | 8.46 | 2019-12-31 | 6,206,000,000 | 121,939,000,000 | 6.86 | 366,000,000 | 162,000,000 | 186,000,000 | 7 | ARO is 5%+ of total assets; ARO of $1B or more |
715,957 | D | DOMINION ENERGY, INC | US-VA | 4,911 | Electric Services | 2025-12-31 | 7,587,000,000 | AssetRetirementObligation | 7,426,000,000 | 161,000,000 | 2.17 | 5,427,000,000 | 5,221,000,000 | 7.76 | 2019-03-31 | 4,985,000,000 | 115,857,000,000 | 6.55 | 329,000,000 | 252,000,000 | 351,000,000 | 12 | ARO is 5%+ of total assets; ARO of $1B or more |
1,164,727 | NEM | NEWMONT Corp /DE/ | US-CO | 1,040 | Gold and Silver Ores | 2026-09-30 | 6,310,000,000 | AssetRetirementObligation | 6,809,000,000 | -499,000,000 | -7.33 | 6,822,000,000 | 3,812,000,000 | 10.61 | 2019-03-31 | 2,337,000,000 | 58,183,000,000 | 10.85 | 307,000,000 | null | null | 31 | ARO is 5%+ of total assets; ARO of $1B or more |
75,488 | PCG-PA | PACIFIC GAS & ELECTRIC Co | US-CA | 4,931 | Electric & Other Services Combined | 2026-09-30 | 5,654,000,000 | Noncurrent+Current | null | null | null | null | null | null | 2025-12-31 | 5,439,000,000 | 147,295,000,000 | 3.84 | null | null | null | 2 | ARO of $1B or more |
1,004,980 | PCG | PG&E Corp | US-CA | 4,931 | Electric & Other Services Combined | 2026-06-30 | 5,581,000,000 | Noncurrent+Current | 5,499,000,000 | 82,000,000 | 1.49 | 5,971,000,000 | 6,554,000,000 | -3.16 | 2019-03-31 | 6,055,000,000 | 145,076,000,000 | 3.85 | 290,000,000 | 0 | 21,000,000 | 30 | ARO of $1B or more |
7,323 | EAI | ENTERGY ARKANSAS, LLC | US-LA | 4,911 | Electric Services | 2026-09-30 | 5,120,495,000 | Noncurrent+Current | null | null | null | null | null | null | 2025-12-31 | 4,947,530,000 | 81,855,495,000 | 6.26 | null | null | null | 3 | ARO is 5%+ of total assets; ARO of $1B or more |
65,984 | ETR | ENTERGY CORP /DE/ | US-LA | 4,911 | Electric Services | 2026-03-31 | 5,004,090,000 | Noncurrent+Current | 4,765,021,000 | 239,069,000 | 5.02 | 4,325,106,000 | 6,528,450,000 | -5.18 | 2019-03-31 | 6,577,180,000 | 75,804,140,000 | 6.6 | 243,100,000 | 41,100,000 | 707,800,000 | 29 | ARO is 5%+ of total assets; Settling 5%+ of ARO a year (active decommissioning); ARO of $1B or more |
28,385 | null | DTE Electric Co | US-MI | 4,911 | Electric Services | 2026-09-30 | 4,727,000,000 | Noncurrent+Current | null | null | null | null | null | null | 2025-12-31 | 4,469,000,000 | 57,594,000,000 | 8.21 | null | null | null | 3 | ARO is 5%+ of total assets; ARO of $1B or more |
936,340 | DTE | DTE ENERGY CO | US-MI | 4,911 | Electric Services | 2026-03-31 | 4,536,000,000 | Noncurrent+Current | 4,119,000,000 | 417,000,000 | 10.12 | 3,509,000,000 | 2,879,000,000 | 9.52 | 2019-03-31 | 2,500,000,000 | 55,108,000,000 | 8.23 | 239,000,000 | 32,000,000 | 10,000,000 | 29 | ARO is 5%+ of total assets; ARO of $1B or more |
1,692,819 | VST | Vistra Corp. | US-TX | 4,911 | Electric Services | 2026-06-30 | 4,269,000,000 | AssetRetirementObligation | 4,099,000,000 | 170,000,000 | 4.15 | 2,453,000,000 | 2,449,000,000 | 11.76 | 2019-03-31 | 2,370,000,000 | 42,603,000,000 | 10.02 | 194,000,000 | null | 96,000,000 | 30 | ARO is 5%+ of total assets; ARO of $1B or more |
797,468 | OXY | OCCIDENTAL PETROLEUM CORP /DE/ | US-TX | 1,311 | Crude Petroleum & Natural Gas | 2026-06-30 | 4,056,000,000 | Noncurrent+Current | 3,825,000,000 | 231,000,000 | 6.04 | 3,667,000,000 | 3,949,000,000 | 0.54 | 2019-03-31 | 1,430,000,000 | 80,358,000,000 | 5.05 | 212,000,000 | 138,000,000 | 536,000,000 | 30 | ARO is 5%+ of total assets; Settling 5%+ of ARO a year (active decommissioning); ARO of $1B or more |
37,634 | null | FLORIDA POWER & LIGHT CO | US-FL | 4,911 | Electric Services | 2026-09-30 | 3,939,000,000 | Noncurrent+Current | null | null | null | null | null | null | 2025-12-31 | 3,669,000,000 | 245,052,000,000 | 1.61 | null | null | null | 3 | ARO of $1B or more |
86,521 | null | SAN DIEGO GAS & ELECTRIC CO | US-CA | 4,931 | Electric & Other Services Combined | 2026-09-30 | 3,876,000,000 | Noncurrent+Current | null | null | null | null | null | null | 2025-12-31 | 3,743,000,000 | 118,024,000,000 | 3.28 | null | null | null | 2 | ARO of $1B or more |
92,487 | null | SOUTHWESTERN ELECTRIC POWER CO | US-OH | 4,911 | Electric Services | 2026-09-30 | 3,825,000,000 | AssetRetirementObligation | null | null | null | null | null | null | 2025-12-31 | 3,712,000,000 | 125,695,000,000 | 3.04 | null | null | null | 2 | ARO of $1B or more |
1,032,208 | SRE | SEMPRA | US-CA | 4,932 | Gas & Other Services Combined | 2026-03-31 | 3,773,000,000 | Noncurrent+Current | 3,751,000,000 | 22,000,000 | 0.59 | 3,564,000,000 | 3,121,000,000 | 3.87 | 2019-03-31 | 2,795,000,000 | 113,518,000,000 | 3.32 | 164,000,000 | 10,000,000 | 58,000,000 | 29 | ARO of $1B or more |
753,308 | NEE | NEXTERA ENERGY INC | US-FL | 4,911 | Electric Services | 2026-03-31 | 3,730,000,000 | Noncurrent+Current | 3,708,000,000 | 22,000,000 | 0.59 | 3,285,000,000 | 2,902,000,000 | 5.15 | 2019-03-31 | 3,350,000,000 | 221,424,000,000 | 1.68 | 177,000,000 | 102,000,000 | 53,000,000 | 29 | ARO of $1B or more |
4,904 | AEP | AMERICAN ELECTRIC POWER CO INC | US-OH | 4,911 | Electric Services | 2026-03-31 | 3,607,000,000 | Noncurrent+Current | 3,551,600,000 | 55,400,000 | 1.56 | 2,877,500,000 | 2,483,700,000 | 7.75 | 2019-03-31 | 2,317,300,000 | 117,776,000,000 | 3.06 | 170,000,000 | 45,000,000 | 103,000,000 | 29 | ARO of $1B or more |
823,768 | WM | WASTE MANAGEMENT INC | US-TX | 4,953 | Refuse Systems | 2026-09-30 | 3,366,000,000 | AssetRetirementObligation | null | null | null | null | null | null | 2025-12-31 | 3,305,000,000 | 46,519,000,000 | 7.24 | null | null | null | 2 | ARO is 5%+ of total assets; ARO of $1B or more |
72,903 | XEL | XCEL ENERGY INC | US-MN | 4,931 | Electric & Other Services Combined | 2026-09-30 | 3,330,000,000 | Noncurrent+Current | 3,853,000,000 | -523,000,000 | -13.57 | 3,332,000,000 | 3,094,000,000 | 1.48 | 2019-03-31 | 2,599,000,000 | 90,717,000,000 | 3.67 | 178,000,000 | 16,000,000 | 6,000,000 | 31 | ARO of $1B or more |
Asset Retirement Obligation Ledger: free sample (Tensorust LLC)
497 public companies' asset retirement obligations, $244.0B of booked cleanup and decommissioning liability, with growth, share of assets and cash settled each year.
Headline: Asset retirement obligations are the booked cost of plugging wells, decommissioning plants, closing mines and restoring sites, a liability that grows every year it is not settled.
This repository is a free teaser, not the dataset. It holds 25 example rows and a summary table with no names in it. The full file has 497 rows and is sold by Tensorust LLC: https://tensorust.com/datasets/sec-aro-ledger/.
Files here
| file | what it is |
|---|---|
sample.csv |
25 rows of the full file (the same sample shown on tensorust.com) |
summary_by_location.csv |
row counts and totals by location across the full file, no entity names (groups with fewer than 3 rows are folded into "Other") |
Summary by location (largest groups)
| Location | rows | Asset retirement obligations, latest (USD) |
|---|---|---|
| US-TX | 108 | 71,292,593,268 |
| US-CA | 43 | 25,728,553,770 |
| Other (groups under 3 rows) | 37 | 4,458,452,908 |
| US-NY | 30 | 3,179,771,344 |
| US-CO | 21 | 9,037,455,000 |
| US-MA | 20 | 4,664,703,780 |
| US-PA | 19 | 3,754,669,000 |
| US-OK | 15 | 3,626,225,001 |
| US-OH | 14 | 8,794,339,236 |
| US-TN | 13 | 10,137,101,254 |
| US-VA | 12 | 9,309,081,289 |
| US-IL | 12 | 2,309,380,000 |
| TOTAL | 497 | 244,033,907,396 |
Full table: summary_by_location.csv.
What the full file has
- 497 rows
- Key fields: cik, ticker, company, location, sic, industry, latest_period_end, aro_latest_usd, aro_basis, aro_1y_prior_usd
- Parquet and CSV, a README with sources, method and limits, and the build script
- Free 25-row sample (no personal contact data)
Coverage: 497 SEC registrants that tag an asset retirement obligation in XBRL with a balance dated June 30, 2024 or later, 2019 onward history. SEC XBRL frames fetched Nov 6 2026; balances are each company's latest reported quarter end; built Nov 6 2026.
Columns in the full file
| column | meaning |
|---|---|
cik |
SEC CIK |
ticker |
Ticker (Tensorust ontology SEC ticker table) |
company |
Registrant name |
location |
SEC business location code |
sic |
SIC code |
industry |
SEC SIC description |
latest_period_end |
Latest quarter end with an ARO balance |
aro_latest_usd |
Latest ARO balance, USD |
aro_basis |
XBRL tag the balance came from |
aro_1y_prior_usd |
Balance at the same quarter one year earlier (within 100 days) |
aro_change_1y_usd |
One-year change, USD |
aro_growth_1y_pct |
One-year growth, percent |
aro_3y_prior_usd |
Balance three years earlier |
aro_5y_prior_usd |
Balance five years earlier |
aro_cagr_5y_pct |
Five-year compound annual growth, percent |
aro_first_period_end |
Earliest balance date in the 2019+ window |
aro_first_usd |
Earliest balance in the 2019+ window |
total_assets_usd |
Total assets at the latest period |
aro_pct_of_assets |
ARO as a percent of total assets |
accretion_expense_latest_fy_usd |
Accretion expense, latest calendar-year frame |
new_obligations_incurred_latest_fy_usd |
New obligations incurred, latest calendar-year frame |
obligations_settled_latest_fy_usd |
Obligations settled (cash out), latest calendar-year frame |
quarters_reported |
Number of quarter-end balances found |
flags |
ARO up 25%+ in a year; ARO 5%+ of assets; settling 5%+ a year; ARO of $1B or more |
Get the full file
| tier | price | includes |
|---|---|---|
| ARO ledger file | $1,500 | All 497 companies with ARO balances, history, growth, share of assets, roll-forward lines and flags. |
| Quarterly refresh | $6,000 a year | Rebuilt after each 10-Q and 10-K season, with companies whose AROs jump 25 percent or settle 5 percent or more in a year flagged. |
| Contractor BD license | $18,000 a year | Quarterly refresh, subsidiary registrants mapped to parents, history back to 2009 on request, and internal use across sales and estimating teams. |
Email mattbusel@tensorust.com with the tier and a billing contact, and we will send a proper invoice (ACH or card). The file is delivered once the invoice is paid. Details and the live sample: https://tensorust.com/datasets/sec-aro-ledger/. All datasets: https://tensorust.com/datasets/
Method and limits
For each company and quarter end the balance is the AssetRetirementObligation tag where present, else noncurrent plus current. Frames place each filing in the calendar quarter closest to its period end, so non-calendar fiscal years are covered. Only companies with a balance dated June 30, 2024 or later are kept. A no-ticker row whose balance is within 1 percent of a listed company's balance within 120 days is dropped as a combined-filing echo. Roll-forward lines use the latest calendar-year frame where the company tags them.
Not a site-level list of wells, plants or mines; it is the company-level balance sheet number. Not every company with decommissioning duties: companies that do not tag an ARO in XBRL or fold it into other liabilities are missing, and private companies are not covered. AROs are discounted present values, not undiscounted cost estimates.
Sources
- SEC XBRL frames API, https://data.sec.gov/api/xbrl/frames/ (us-gaap AssetRetirementObligation, AssetRetirementObligationsNoncurrent, AssetRetirementObligationCurrent, roll-forward concepts and Assets), every calendar-quarter instant frame from CY2019Q1I to the latest available
- SEC submissions API for SIC industry codes, https://data.sec.gov/submissions/
- Tensorust Ontology SEC ticker table
License
The sample and summary here are free to view, analyze and cite with attribution to "Tensorust LLC, https://tensorust.com/datasets/sec-aro-ledger/". The full dataset is licensed separately per tier. No resale or redistribution of Tensorust data without a written license.
Tensorust LLC, Tuckahoe NY. mattbusel@tensorust.com | https://tensorust.com
- Downloads last month
- 43