SEC XBRL Annual Fundamentals — 15 US-GAAP Concepts For Every Filer, Calendar Years 2009–2025

DatasetCSV.GZOpenSECXbrlFundamentalsFinancial StatementsEdgarEquitiesFree

1,152,906 filer-concept-year facts for 16,041 SEC registrants across 15 US-GAAP concepts (revenue, cost of revenue, gross profit, operating income, net income, total assets, liabilities, shareholders' equity, cash, long-term debt, operating cash flow, capital expenditure, diluted EPS and shares outstanding) for calendar years 2009 to 2025, from the SEC's XBRL frames API as of 2026-09-06. Long format: one row per company, concept and calendar-year frame with CIK, entity name, state or country of incorporation, unit, period start and end, value and the accession number of the filing the fact came from, 250 frames fetched. Join to the SEC Company Tickers set on CIK.

Use Cases

Fundamental screens across the whole US filer universe
Point-in-time training data for financial models
Margin, leverage and cash-conversion time series by company
Reconciling vendor fundamentals to the filed source

Methodology

One frames API call per concept and year (CY<year> for duration concepts, CY<year>Q4I for balance-sheet instants); the SEC assigns each filer's fact to the calendar frame closest to its fiscal period, so non-calendar fiscal years appear under the nearest calendar year. Frames the SEC does not publish (e.g. ASC 606 revenue before 2018) are skipped. The frames API carries no fiscal-period, form or filing-date fields, so none are included.

Update Schedule

Static snapshot. Frames change as new filings and restatements arrive; refresh monthly.

Attribution

Source: U.S. Securities and Exchange Commission, XBRL frames API (public domain).

Schema

name	type
cik	integer
entity_name	string
location	string
concept	string
unit	string
frame	string
calendar_year	integer
period_type	string
period_start	date
period_end	date
value	number
accession_number	string

Sample Data

cik	unit	frame	value	concept	location	period_end	entity_name	period_type	calendar_year	accession_number
0000001750	USD	CY2010Q4I	1557227000	Assets	US-IL	2010-11-30	AAR CORP.	instant	2010	0001104659-10-063683
0000001750	USD	CY2011Q4I	1821612000	Assets	US-IL	2011-11-30	AAR CORP.	instant	2011	0001104659-11-070822
0000001750	USD	CY2012Q4I	2189300000	Assets	US-IL	2012-11-30	AAR CORP.	instant	2012	0001104659-12-085900
0000001750	USD	CY2013Q4I	2155900000	Assets	US-IL	2013-11-30	AAR CORP.	instant	2013	0001104659-13-091455
0000001750	USD	CY2014Q4I	2227700000	Assets	US-IL	2014-11-30	AAR CORP.	instant	2014	0001104659-14-087894

Get this via API

# 1. Add dAgentBase once, in any MCP client. No install, no vendor keys.
#    Claude.ai / Claude Desktop: Settings -> Connectors -> Add custom connector
#    Cursor / Claude Code / others: mcp.json
{
  "mcpServers": {
    "dagentbase": {
      "url": "https://dagentbase.com/api/mcp",
      "headers": { "Authorization": "Bearer dm_live_YOUR_KEY" }
    }
  }
}

# 2. Then ask your agent, in plain language:
#    "Preview 'SEC XBRL Annual Fundamentals — 15 US-GAAP Concepts for Every Filer, Calendar Years 2009–2025' and, if it fits, claim it and download the files."
#    Tools it will use: search_listings -> preview_listing -> purchase_listing -> get_download_urls

# 1. Add dAgentBase once, in any MCP client. No install, no vendor keys.
#    Claude.ai / Claude Desktop: Settings -> Connectors -> Add custom connector
#    Cursor / Claude Code / others: mcp.json
{
  "mcpServers": {
    "dagentbase": {
      "url": "https://dagentbase.com/api/mcp",
      "headers": { "Authorization": "Bearer dm_live_YOUR_KEY" }
    }
  }
}

# 2. Then ask your agent, in plain language:
#    "Preview 'SEC XBRL Annual Fundamentals — 15 US-GAAP Concepts for Every Filer, Calendar Years 2009–2025' and, if it fits, claim it and download the files."
#    Tools it will use: search_listings -> preview_listing -> purchase_listing -> get_download_urls

Free

one time · open license

Details

Date Range2009-06-30 — 2026-06-28

Rows1,152,906

Size13 MB

Files1

FormatCSV.GZ

Available formats

CSV.GZ13 MB

Freeopen