Schema

Column names use the lowercase Athena names. dtype describes the Athena SQL type. See Datasets for querying and downloading.

Sample values illustrate each column and may come from different rows. null indicates a missing value in the sample. Long values are abbreviated.

XBRL

simple_xbrl

XBRL facts flattened into rows. Requires an XBRL subscription.

taxonomy and name identify the fact, for example us-gaap and Revenues. Tags can differ between companies and reporting periods. value can contain numeric or text facts; use TRY_CAST(value AS DOUBLE) for numeric analysis and inspect unit.

dimensions records the fact's dimensions and members, such as business segments or geography. Each entry has dimension, type, and value fields. members is a legacy field; use dimensions.

For consolidated totals, select undimensioned facts with dimensions IS NULL OR CARDINALITY(dimensions) = 0. Checking only for NULL excludes facts whose dimensions are an empty array. Apply this scope filter before deduplicating disclosures.

Join on accessionnumber to sec_accession_cik_table for CIKs and sec_submission_details_table for filing types and report dates. This table has no CIK or ticker column. Use filer_metadata to resolve a ticker to a CIK.

Use period_start_date and period_end_date to identify the reported period. A company's fiscal year need not match the calendar year. filingdate is when the filing was filed, not the end of the fact's reporting period.

Period strings can include a time suffix. For date calculations, use TRY_CAST(SUBSTR(period_start_date, 1, 10) AS DATE) and the equivalent for period_end_date. Athena durations use date_diff('day', start_date, end_date); subtracting dates produces an interval, not an integer day count.

Facts are reported as filed. The same period can appear in multiple filings, including amendments and comparative disclosures. Choose the appropriate fact, unit, dimensions, and period, then deduplicate disclosures before constructing a time series. Summing or averaging repeated disclosures can double-count revenue.

Example

Discover Apple's reported revenue tags and contexts:

SELECT
    x.accessionnumber,
    s.submissiontype,
    x.filingdate,
    x.taxonomy,
    x.name,
    x.period_start_date,
    x.period_end_date,
    x.unit,
    TRY_CAST(x.value AS DOUBLE) AS value,
    x.dimensions
FROM simple_xbrl x
JOIN sec_submission_details_table s
  ON x.accessionnumber = s.accessionnumber
WHERE x.accessionnumber IN (
    SELECT accessionnumber
    FROM sec_accession_cik_table
    WHERE cik = 320193
      AND filingdate >= '2020-01-01'
)
  AND x.filingdate >= '2020-01-01'
  AND s.submissiontype IN ('10-K', '10-K/A')
  AND x.taxonomy = 'us-gaap'
  AND LOWER(x.name) LIKE '%revenue%'
ORDER BY x.period_end_date DESC, x.filingdate DESC
LIMIT 100

Inspect the returned tags, units, periods, and dimensions before choosing a consolidated annual revenue series. The result is a sample of reported facts.

Metadata

These tables require a Metadata subscription.

filer_metadata

SEC filer profiles, including current names, ticker symbols, exchanges, industry codes, and addresses. Includes companies and individuals without tickers.

cik is numeric, without leading-zero padding. tickers and exchanges are arrays, not scalar strings. Missing values can be null.

Resolve a ticker before looking up its filings:

SELECT cik, name, tickers
FROM filer_metadata
WHERE CONTAINS(tickers, 'AAPL')
LIMIT 10

sec_accession_cik_table

CIKs associated with each filing. A filing can have more than one associated CIK. Use this table to find a company's filings or connect filing-level data to filer profiles.

accessionnumber and cik are numeric, without dashes or leading-zero padding. For example, Apple's CIK is 320193. Join accessionnumber to simple_xbrl.accessionnumber or sec_submission_details_table.accessionnumber, and cik to filer_metadata.cik.

When filtering facts for one company, an IN subquery on accessionnumber avoids duplicating fact rows because a filing has multiple associated CIKs.

sec_submission_details_table

Filing types, filing and report dates, detection timestamps, and XBRL availability flags. Join to other filing-level tables on accessionnumber.

submissiontype contains forms such as 10-K, 10-K/A, and 10-Q. filingdate and reportdate are date strings. detectedtime is a UTC timestamp, not a Unix timestamp number. Detection time, filing date, and report date describe different events.

XML Tables

1_k

document_types: 1-K, 1-K/A

1_z

document_types: 1-Z, 1-Z/A

13fhr

document_types: 13F-HR, 13F-HR/A, 13F-NT, 13F-NT/A

13fhr_other_manager

document_types: 13F-HR, 13F-HR/A, 13F-NT, 13F-NT/A

13fhr_other_manager2

document_types: 13F-HR, 13F-HR/A, 13F-NT, 13F-NT/A

1a

document_types: 1-A, 1-A POS, 1-A/A

1a_co_filer

document_types: 1-A, 1-A POS, 1-A/A

1a_common_equity

document_types: 1-A, 1-A POS, 1-A/A

1a_dealers_jurisdiction

document_types: 1-A, 1-A POS, 1-A/A

1a_debt_securities

document_types: 1-A, 1-A POS, 1-A/A

1a_employees_info

document_types: 1-A, 1-A POS, 1-A/A

1a_issue_jurisdiction

document_types: 1-A, 1-A POS, 1-A/A

1a_preferred_equity

document_types: 1-A, 1-A POS, 1-A/A

1a_securities_issued

document_types: 1-A, 1-A POS, 1-A/A

1a_securities_offered_types

document_types: 1-A, 1-A POS, 1-A/A

1k_item1_info

document_types: 1-K, 1-K/A

1k_summary_info

document_types: 1-K, 1-K/A

1z_signature_tab

document_types: 1-Z, 1-Z/A

24f2nt

document_types: 24F-2NT, 24F-2NT/A

24f2nt_annual_filing_info

document_types: 24F-2NT, 24F-2NT/A

25_nse

document_types: 25-NSE, 25-NSE/A

345

document_types: 3, 3/A, 4, 4/A, 5, 5/A

345_derivative_holding

document_types: 3, 3/A, 4, 4/A, 5, 5/A

345_derivative_security

document_types: 3, 3/A, 4, 4/A, 5, 5/A

345_derivative_transaction

document_types: 3, 3/A, 4, 4/A, 5, 5/A

345_footnote

document_types: 3, 3/A, 4, 4/A, 5, 5/A

345_non_derivative_holding

document_types: 3, 3/A, 4, 4/A, 5, 5/A

345_non_derivative_security

document_types: 3, 3/A, 4, 4/A, 5, 5/A

345_non_derivative_transaction

document_types: 3, 3/A, 4, 4/A, 5, 5/A

345_owner_signature

document_types: 3, 3/A, 4, 4/A, 5, 5/A

345_reporting_owner

document_types: 3, 3/A, 4, 4/A, 5, 5/A

ats_n_ua

document_types: ATS-N-C, ATS-N-W, ATS-N/CA, ATS-N/MA, ATS-N/OFA, ATS-N/UA

Athena queries are currently unavailable because this table's catalog metadata contains duplicate columns. The types below describe the Parquet data; Athena types and sample values are unavailable.

c_a

document_types: C, C-AR, C-AR-W, C-AR/A, C-U, C-U-W, C-W, C/A, C/A-W

c_co_issuer

document_types: C, C-AR, C-AR-W, C-AR/A, C-U, C-U-W, C-W, C/A, C/A-W

c_signature_person

document_types: C, C-AR, C-AR-W, C-AR/A, C-U, C-U-W, C-W, C/A, C/A-W

c_tr

document_types: C-TR, C-TR-W

c_tr_co_issuer

document_types: C-TR, C-TR-W

c_tr_signature_person

document_types: C-TR, C-TR-W

cfportal

document_types: CFPORTAL, CFPORTAL-W, CFPORTAL/A