Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

42.6 MB across 201 parts, newest sealed 7 November 2026 at 03:27 UTC. The first build wrote 201 parts and 227,184 rows.

All 4 checks passed.
  • One row per company period passed.
  • Enough company periods passed.
  • Net income mostly present passed.
  • Revenue mostly present passed.

cik

integer

SEC Central Index Key of the filer.

Histogram: 1750 to 270609.125, 31,064; 270609.125 to 539468.25, 4,555; 539468.25 to 808327.375, 17,657; 808327.375 to 1077186.5, 51,152; 1077186.5 to 1346045.625, 31,818; 1346045.625 to 1614904.75, 48,090; 1614904.75 to 1883763.875, 35,717; 1883763.875 to 2152623, 7,131
17502152623
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
5,256 · 2.3% of valid
Min
1750
25%
827052
Median
1128361
75%
1534154
Max
2152623

ticker

string

The issuer's main ticker on a US exchange, from the SEC ticker list.

  • ACN0%
  • ALL0%
  • AROC0%
  • Other (5,058)
Valid
223,890 · 98.6%
Missing
3,294 · 1.4%
Distinct
5,070 · 2.3% of valid

tickers_all

string

Every US-exchange ticker of the issuer, comma separated.

  • ACN0%
  • ALL, ALL-PB, ALL-PH, ALL-PI, ALL-PJ0%
  • AROC0%
  • Other (5,058)
Valid
223,890 · 98.6%
Missing
3,294 · 1.4%
Distinct
5,070 · 2.3% of valid

company_name

string

Company name (issuer, brand).

  • Spectrum Brands Holdings, Inc.0%
  • Star Equity Holdings, Inc.0%
  • DAWSON GEOPHYSICAL CO0%
  • Other (5,233)
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
5,245 · 2.3% of valid

filer_name

string

The filer's name as the XBRL facts give it.

  • Spectrum Brands Holdings, Inc.0%
  • COMMUNITY WEST BANCSHARES0%
  • Bristow Group Inc.0%
  • Other (9,021)
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
9,033 · 4% of valid

frame

string

SEC calendar frame: CY2024Q1 for a calendar quarter, CY2024 for a calendar year. Fiscal periods are mapped to the nearest calendar period.

  • CY20252%
  • CY20242%
  • CY20232%
  • Other (71)
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
83 · 0% of valid

period_type

string

quarter or year (annual).

  • quarter76%
  • year24%
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

calendar_year

integer

Calendar year of the frame.

Histogram: 2010 to 2012, 18,170; 2012 to 2014, 21,971; 2014 to 2016, 23,858; 2016 to 2018, 25,949; 2018 to 2020, 28,384; 2020 to 2022, 30,699; 2022 to 2024, 32,266; 2024 to 2026, 45,887
20102026
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
17 · 0% of valid
Min
2010
25%
2015
Median
2019
75%
2023
Max
2026

calendar_quarter

integer

Calendar quarter 1 to 4 of the frame; empty for annual rows.

Histogram: 1 to 1.75, 49,468; 1.75 to 2.5, 50,263; 2.5 to 3.25, 48,790; 3.25 to 4, 25,192
14
Valid
173,713 · 76.5%
Missing
53,471 · 23.5%
Distinct
4 · 0% of valid
Min
1
25%
1
Median
2
75%
3
Max
4

period_start

date

First day of the reported period.

  • 2025-01-013%
  • 2024-01-013%
  • 2023-01-013%
  • Other (2,193)
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
2,205 · 1% of valid

period_end

date

Last day of the reported period (fiscal quarter or year end).

  • 2019-12-312%
  • 2020-12-312%
  • 2025-12-312%
  • Other (1,834)
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
1,846 · 0.8% of valid

balance_sheet_date

date

Date of the balance sheet joined to this period (the calendar quarter end frame).

  • 2019-12-312%
  • 2020-12-312%
  • 2025-12-312%
  • Other (1,927)
Valid
224,113 · 98.6%
Missing
3,071 · 1.4%
Distinct
1,939 · 0.9% of valid

accession

string

Accession number of the filing the income facts came from.

  • 0001193125-17-0624190%
  • 0001096906-26-0003950%
  • 0001185185-17-0005950%
  • Other (116,447)
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
116,459 · 51.3% of valid

revenue

decimal

Revenue (sales, top line) for the period, USD: Revenues, else revenue from contracts with customers, else net sales, else revenue net of interest expense for banks.

  • 0.00002%
  • 5000.00000%
  • 200000.00000%
  • Other (148,261)
Valid
186,325 · 82%
Missing
40,859 · 18%
Distinct
148,273 · 79.6% of valid
Min
-3075964000.0000
25%
28243000.0000
Median
209366000.0000
75%
1082500000.0000
Max
716924000000.0000

revenue_concept

string

Which US GAAP concept supplied revenue.

  • Revenues49%
  • RevenueFromContractWithCustomerExcludingAssessedTax30%
  • SalesRevenueNet12%
Valid
186,325 · 82%
Missing
40,859 · 18%
Distinct
5 · 0% of valid

cost_of_revenue

decimal

Cost of revenue (cost of goods sold), USD.

  • 0.00001%
  • 100000.00000%
  • 1000.00000%
  • Other (79,395)
Valid
95,899 · 42.2%
Missing
131,285 · 57.8%
Distinct
79,407 · 82.8% of valid
Min
-153131000.0000
25%
13325000.0000
Median
120600000.0000
75%
649623651.0000
Max
535395000000.0000

gross_profit

decimal

Gross profit, USD; revenue less cost of revenue when not reported.

  • 0.00001%
  • 2000.00000%
  • 4000.00000%
  • Other (92,372)
Valid
119,110 · 52.4%
Missing
108,074 · 47.6%
Distinct
92,384 · 77.6% of valid
Min
-15646000000.0000
25%
12006000.0000
Median
89912000.0000
75%
394566000.0000
Max
396912000000.0000

operating_income

decimal

Operating income (operating profit, EBIT), USD.

  • 0.00000%
  • 58000000.00000%
  • 63000000.00000%
  • Other (115,980)
Valid
169,531 · 74.6%
Missing
57,653 · 25.4%
Distinct
115,992 · 68.4% of valid
Min
-30363000000.0000
25%
-4019719.0000
Median
6433000.0000
75%
91477000.0000
Max
133050000000.0000

net_income

decimal

Net income (profit, earnings) attributable to the parent, USD; else profit or loss.

  • 0.00000%
  • 36000000.00000%
  • 24000000.00000%
  • Other (132,121)
Valid
220,070 · 96.9%
Missing
7,114 · 3.1%
Distinct
132,133 · 60% of valid
Min
-22395000000000.0000
25%
-3646036.0000
Median
5756000.0000
75%
64399000.0000
Max
1620000000000.0000

eps_basic

decimal

Basic earnings per share, USD.

  • 0.00001%
  • 0.01001%
  • -0.01001%
  • Other (6,118)
Valid
187,543 · 82.6%
Missing
39,641 · 17.4%
Distinct
6,130 · 3.3% of valid
Min
-152717402.0000
25%
-0.0800
Median
0.3000
75%
1.0000
Max
108438984.0000

eps_diluted

decimal

Diluted earnings per share (EPS), USD.

  • 0.00001%
  • 0.01001%
  • -0.01001%
  • Other (5,837)
Valid
183,964 · 81%
Missing
43,220 · 19%
Distinct
5,849 · 3.2% of valid
Min
-152717402.0000
25%
-0.0700
Median
0.3000
75%
0.9900
Max
223207000.0000

diluted_shares

decimal

Weighted average diluted shares outstanding.

  • 0.00000%
  • 20000000.00000%
  • 10000000.00000%
  • Other (135,246)
Valid
174,212 · 76.7%
Missing
52,972 · 23.3%
Distinct
135,258 · 77.6% of valid
Min
-5.1400
25%
19434000.0000
Median
51800000.0000
75%
143100000.0000
Max
3543602532000000.0000

research_development_expense

decimal

Research and development (R&D) expense, USD.

  • 0.00001%
  • 1000000.00000%
  • 7000000.00000%
  • Other (45,667)
Valid
73,190 · 32.2%
Missing
153,994 · 67.8%
Distinct
45,679 · 62.4% of valid
Min
-7739000.0000
25%
2121000.0000
Median
10934000.0000
75%
41995000.0000
Max
61087000000.0000

sga_expense

decimal

Selling, general and administrative (SG&A) expense, USD.

  • 0.00000%
  • 105000000.00000%
  • 87000000.00000%
  • Other (58,665)
Valid
81,326 · 35.8%
Missing
145,858 · 64.2%
Distinct
58,677 · 72.2% of valid
Min
-152000000.0000
25%
16718000.0000
Median
73466000.0000
75%
278174000.0000
Max
147943000000.0000

income_tax_expense

decimal

Income tax expense, USD.

  • 0.00007%
  • 2000.00000%
  • 1000.00000%
  • Other (59,528)
Valid
175,979 · 77.5%
Missing
51,205 · 22.5%
Distinct
59,540 · 33.8% of valid
Min
-34831000000.0000
25%
10000.0000
Median
2830000.0000
75%
24025000.0000
Max
3158873000000.0000

interest_expense

decimal

Interest expense, USD.

  • 0.00002%
  • 1000.00000%
  • 2000.00000%
  • Other (47,280)
Valid
113,715 · 50.1%
Missing
113,469 · 49.9%
Distinct
47,292 · 41.6% of valid
Min
-2070000000.0000
25%
692000.0000
Median
6279000.0000
75%
32944000.0000
Max
81321000000.0000

depreciation_amortization

decimal

Depreciation, depletion and amortization (D&A), USD.

  • 0.00000%
  • 200000.00000%
  • 100000.00000%
  • Other (40,635)
Valid
72,977 · 32.1%
Missing
154,207 · 67.9%
Distinct
40,647 · 55.7% of valid
Min
-162416000.0000
25%
1953000.0000
Median
14522000.0000
75%
74800000.0000
Max
65756000000.0000

stock_based_compensation

decimal

Share-based (stock-based) compensation, USD.

  • 0.00001%
  • 9000000.00000%
  • 4000000.00000%
  • Other (36,179)
Valid
95,170 · 41.9%
Missing
132,014 · 58.1%
Distinct
36,191 · 38% of valid
Min
-144600000.0000
25%
762000.0000
Median
3714000.0000
75%
14900000.0000
Max
24953000000.0000

operating_cash_flow

decimal

Net cash from operating activities (operating cash flow), USD.

  • 0.00000%
  • -2000000.00000%
  • 154000000.00000%
  • Other (77,825)
Valid
95,901 · 42.2%
Missing
131,283 · 57.8%
Distinct
77,837 · 81.2% of valid
Min
-251839000000.0000
25%
-3052152.0000
Median
13855000.0000
75%
161600000.0000
Max
164713000000.0000

capex

decimal

Capital expenditure: payments for property, plant and equipment, USD.

  • 0.00002%
  • 2000.00000%
  • 6000.00000%
  • Other (37,565)
Valid
76,259 · 33.6%
Missing
150,925 · 66.4%
Distinct
37,577 · 49.3% of valid
Min
-417751000.0000
25%
607000.0000
Median
6114000.0000
75%
43077000.0000
Max
91447000000.0000

free_cash_flow

decimal

Free cash flow (FCF): operating cash flow less capex, USD.

  • 0.00000%
  • -22000000.00000%
  • -56000000.00000%
  • Other (76,841)
Valid
95,901 · 42.2%
Missing
131,283 · 57.8%
Distinct
76,853 · 80.1% of valid
Min
-251839000000.0000
25%
-6685000.0000
Median
5893000.0000
75%
113149000.0000
Max
139514000000.0000

buybacks

decimal

Share repurchases (buybacks), USD.

  • 0.000020%
  • 100000000.00000%
  • 50000000.00000%
  • Other (21,937)
Valid
46,957 · 20.7%
Missing
180,227 · 79.3%
Distinct
21,949 · 46.7% of valid
Min
-22581000000.0000
25%
196000.0000
Median
11291000.0000
75%
115000000.0000
Max
94949000000.0000

dividends_paid

decimal

Dividends paid, USD.

  • 0.00006%
  • 3000000.00000%
  • 19000000.00000%
  • Other (26,151)
Valid
46,025 · 20.3%
Missing
181,159 · 79.7%
Distinct
26,163 · 56.8% of valid
Min
-2729000000.0000
25%
4512000.0000
Median
24400000.0000
75%
112316000.0000
Max
24082000000.0000

total_assets

decimal

Total assets at the period's quarter end, USD.

  • 0.00000%
  • 1000.00000%
  • 25000.00000%
  • Other (180,525)
Valid
211,955 · 93.3%
Missing
15,229 · 6.7%
Distinct
180,537 · 85.2% of valid
Min
0.0000
25%
211611587.0000
Median
1336489000.0000
75%
5984942000.0000
Max
5091545000000.0000

current_assets

decimal

Current assets, USD.

  • 0.00000%
  • 25000.00000%
  • 3012000000.00000%
  • Other (132,439)
Valid
165,525 · 72.9%
Missing
61,659 · 27.1%
Distinct
132,451 · 80% of valid
Min
0.0000
25%
60721000.0000
Median
339551000.0000
75%
1392442000.0000
Max
374665000000.0000

total_liabilities

decimal

Total liabilities, USD.

  • 0.00000%
  • 1000.00000%
  • 2000.00000%
  • Other (143,819)
Valid
170,930 · 75.2%
Missing
56,254 · 24.8%
Distinct
143,831 · 84.1% of valid
Min
-2241000.0000
25%
49070794.0000
Median
594593000.0000
75%
3289445000.0000
Max
4719177000000.0000

current_liabilities

decimal

Current liabilities, USD.

  • 0.00000%
  • 721000000.00000%
  • 874000000.00000%
  • Other (123,191)
Valid
165,006 · 72.6%
Missing
62,178 · 27.4%
Distinct
123,203 · 74.7% of valid
Min
0.0000
25%
18899000.0000
Median
145538000.0000
75%
793937000.0000
Max
335734599000.0000

equity

decimal

Stockholders' equity (book value), USD.

  • 0.00000%
  • 5000001.00000%
  • 5000008.00000%
  • Other (175,132)
Valid
214,854 · 94.6%
Missing
12,330 · 5.4%
Distinct
175,144 · 81.5% of valid
Min
-23552000000.0000
25%
54838000.0000
Median
399673000.0000
75%
1681600000.0000
Max
747910000000.0000

cash

decimal

Cash and cash equivalents, USD.

  • 0.00001%
  • 1000.00000%
  • 25000.00000%
  • Other (137,356)
Valid
214,357 · 94.4%
Missing
12,827 · 5.6%
Distinct
137,368 · 64.1% of valid
Min
-77987000.0000
25%
16856000.0000
Median
83094000.0000
75%
332716000.0000
Max
759869000000.0000

short_term_investments

decimal

Short-term investments, USD.

  • 0.00007%
  • 5000000.00000%
  • 50000000.00000%
  • Other (16,556)
Valid
24,553 · 10.8%
Missing
202,631 · 89.2%
Distinct
16,568 · 67.5% of valid
Min
0.0000
25%
8265000.0000
Median
55277000.0000
75%
262000000.0000
Max
125916000000.0000

long_term_debt

decimal

Long-term debt, non-current portion, USD.

  • 0.00003%
  • 250000000.00000%
  • 10000000.00000%
  • Other (73,694)
Valid
104,560 · 46%
Missing
122,624 · 54%
Distinct
73,706 · 70.5% of valid
Min
-23806000000.0000
25%
73639000.0000
Median
542020000.0000
75%
2323303000.0000
Max
511653000000.0000

current_debt

decimal

Debt due within a year, USD.

  • 0.00008%
  • 10000000.00001%
  • 4000000.00001%
  • Other (27,667)
Valid
68,975 · 30.4%
Missing
158,209 · 69.6%
Distinct
27,679 · 40.1% of valid
Min
-4710000000.0000
25%
2015434.0000
Median
15057000.0000
75%
124000000.0000
Max
38374000000.0000

total_debt

decimal

Total debt: long-term plus current debt, USD.

  • 0.00002%
  • 10000000.00000%
  • 20000000.00000%
  • Other (78,005)
Valid
112,538 · 49.5%
Missing
114,646 · 50.5%
Distinct
78,017 · 69.3% of valid
Min
-21412000000.0000
25%
59698000.0000
Median
500436000.0000
75%
2235000000.0000
Max
511653000000.0000

inventory

decimal

Inventory, USD.

  • 0.00000%
  • 44000000.00000%
  • 12000000.00000%
  • Other (68,579)
Valid
102,536 · 45.1%
Missing
124,648 · 54.9%
Distinct
68,591 · 66.9% of valid
Min
0.0000
25%
12308000.0000
Median
96100000.0000
75%
474713000.0000
Max
65354000000.0000

goodwill

decimal

Goodwill, USD.

  • 0.00001%
  • 491479000.00000%
  • 990000.00000%
  • Other (58,860)
Valid
130,657 · 57.5%
Missing
96,527 · 42.5%
Distinct
58,872 · 45.1% of valid
Min
-4214000.0000
25%
26642000.0000
Median
205211000.0000
75%
1142757000.0000
Max
50263000000000.0000

fetched_at

timestamp_utc

When the SEC frames were read.

  • 2026-11-07 03:21:58+0011%
  • 2026-11-07 03:11:08+008%
  • 2026-11-07 03:13:20+007%
  • Other (130)
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
142 · 0.1% of valid

net_cash

decimal

Net cash: cash plus short-term investments less total debt, USD.

  • 0.00001%
  • 25000.00000%
  • 1000.00000%
  • Other (162,021)
Valid
214,357 · 94.4%
Missing
12,827 · 5.6%
Distinct
162,033 · 75.6% of valid
Min
-366859000000.0000
25%
-249100000.0000
Median
8517339.0000
75%
109923000.0000
Max
759869000000.0000

gross_margin_pct

decimal

Gross margin, percent of revenue.

  • 100.001%
  • 0.000%
  • 30.290%
  • Other (13,218)
Valid
107,216 · 47.2%
Missing
119,968 · 52.8%
Distinct
13,230 · 12.3% of valid
Min
-1034250.00
25%
22.93
Median
37.94
75%
59.15
Max
2158893.50

operating_margin_pct

decimal

Operating margin, percent of revenue.

  • 4.000%
  • 4.340%
  • 5.080%
  • Other (30,360)
Valid
137,438 · 60.5%
Missing
89,746 · 39.5%
Distinct
30,372 · 22.1% of valid
Min
-5817056.76
25%
-10.44
Median
5.99
75%
15.58
Max
11458333.33

net_margin_pct

decimal

Net margin (profit margin), percent of revenue.

  • 0.000%
  • 0.010%
  • 4.390%
  • Other (34,554)
Valid
178,327 · 78.5%
Missing
48,857 · 21.5%
Distinct
34,566 · 19.4% of valid
Min
-10775900.00
25%
-5.55
Median
5.25
75%
14.78
Max
47396186.08

fcf_margin_pct

decimal

Free cash flow margin, percent of revenue.

  • 5.850%
  • 0.000%
  • 5.230%
  • Other (22,523)
Valid
79,351 · 34.9%
Missing
147,833 · 65.1%
Distinct
22,535 · 28.4% of valid
Min
-7616906.45
25%
-8.25
Median
5.60
75%
20.06
Max
457848.28

roe_pct

decimal

Return on equity for the period (not annualized), percent.

  • 0.000%
  • 2.720%
  • 2.430%
  • Other (20,450)
Valid
190,099 · 83.7%
Missing
37,085 · 16.3%
Distinct
20,462 · 10.8% of valid
Min
-59000000000.00
25%
-3.14
Median
2.15
75%
5.57
Max
3700000000.00

debt_to_equity

decimal

Total debt divided by equity (leverage).

  • 0.00003%
  • 0.00040%
  • 0.00010%
  • Other (26,643)
Valid
102,720 · 45.2%
Missing
124,464 · 54.8%
Distinct
26,655 · 25.9% of valid
Min
-11.4990
25%
0.1909
Median
0.5409
75%
1.1069
Max
436452.0000

current_ratio

decimal

Current assets divided by current liabilities (liquidity).

  • 0.00000%
  • 1.22830%
  • 1.01940%
  • Other (62,237)
Valid
164,521 · 72.4%
Missing
62,663 · 27.6%
Distinct
62,249 · 37.8% of valid
Min
0.0000
25%
1.2117
Median
1.9695
75%
3.5593
Max
10291.5641

revenue_growth_yoy_pct

decimal

Revenue growth versus the same period a year earlier (year over year), percent.

  • -100.000%
  • 0.000%
  • 3.790%
  • Other (24,778)
Valid
163,692 · 72.1%
Missing
63,492 · 27.9%
Distinct
24,790 · 15.1% of valid
Min
-39450.16
25%
-3.13
Median
6.39
75%
20.04
Max
130555455.56

net_income_growth_yoy_pct

decimal

Net income (profit, earnings) growth year over year, percent; empty when last year's was not positive.

  • 0.000%
  • -100.000%
  • 6.340%
  • Other (44,821)
Valid
125,842 · 55.4%
Missing
101,342 · 44.6%
Distinct
44,833 · 35.6% of valid
Min
-2373328.48
25%
-40.39
Median
3.36
75%
38.47
Max
2159999900.00

eps_diluted_growth_yoy_pct

decimal

Diluted EPS growth year over year, percent; empty when last year's was not positive.

  • 0.002%
  • 100.001%
  • -100.001%
  • Other (25,182)
Valid
115,178 · 50.7%
Missing
112,006 · 49.3%
Distinct
25,194 · 21.9% of valid
Min
-3043662071.83
25%
-37.50
Median
3.51
75%
35.71
Max
7828968947.62

taxonomy

string

XBRL taxonomy of the facts: us-gaap.

  • us-gaap100%
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid

currency

string

Currency of money columns: USD.

  • USD100%
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid

filing_url

string

Link to the SEC filing index of the accession.

  • https://www.sec.gov/Archives/edgar/data/92416/000119312517062419/0001193125-17-062419-index.htm0%
  • https://www.sec.gov/Archives/edgar/data/1267395/000126739519000008/0001267395-19-000008-index.htm0%
  • https://www.sec.gov/Archives/edgar/data/1417926/000118518517000595/0001185185-17-000595-index.htm0%
  • Other (116,447)
Valid
227,184 · 100%
Missing
0 · 0%
Distinct
116,459 · 51.3% of valid

Support

Talk to Mostly Right

Loading chat…