Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

938 kB across 1 part, newest sealed 1 November 2026 at 17:06 UTC.

The first build wrote 1 part and 5,168 rows.

ONE_ROW_PER_CIK passed.

ENOUGH_COMPANIES passed.

cik

integer

SEC Central Index Key of the company.

Histogram: 1750 to 270534, 450; 270535 to 539319, 63; 539320 to 808103, 242; 808104 to 1076888, 726; 1076889 to 1345673, 502; 1345674 to 1614457, 899; 1614458 to 1883242, 1,321; 1883243 to 2152026, 965
17502152026
Valid
5,168 · 100%
Missing
0 · 0%
Distinct
5,168 · 100% of valid
Min
1750
25%
1026662
Median
1533924
75%
1828365
Max
2152026

filer_name

string

Company name on the SEC filings behind these figures.

5,088 distinct values, no chart

Valid
5,168 · 100%
Missing
0 · 0%
Distinct
5,088 · 98.5% of valid

fy_frame

string

SEC calendar frame of the latest fiscal year, such as CY2025.

  • CY202598%
  • CY20241%
  • CY20230%
Valid
4,777 · 92.4%
Missing
391 · 7.6%
Distinct
9 · 0.2% of valid

fy_year

integer

Calendar year of the latest fiscal year.

Histogram: 2017 to 2018, 7; 2019 to 2019, 3; 2020 to 2020, 12; 2021 to 2021, 11; 2022 to 2022, 12; 2023 to 2023, 13; 2024 to 2024, 45; 2025 to 2025, 4,674
20172025
Valid
4,777 · 92.4%
Missing
391 · 7.6%
Distinct
9 · 0.2% of valid
Min
2017
25%
2025
Median
2025
75%
2025
Max
2025

fy_end

date

Last day of the latest fiscal year.

Timeline per year: 2018-01-01, 6; 2019-01-01, 3; 2020-01-01, 9; 2021-01-01, 15; 2022-01-01, 10; 2023-01-01, 13; 2024-01-01, 33; 2025-01-01, 4,254; 2026-01-01, 434
2018-01-012026-01-01

per year

Valid
4,777 · 92.4%
Missing
391 · 7.6%
Distinct
89 · 1.9% of valid

fy_revenue

decimal

Revenue for the latest fiscal year.

Histogram: -56201422 to 89566323755.75, 3,863; 89566323755.75 to 179188848933.5, 18; 179188848933.5 to 268811374111.25, 10; 268811374111.25 to 358433899289, 5; 358433899289 to 448056424466.75, 6; 448056424466.75 to 537678949644.5, 0; 537678949644.5 to 627301474822.25, 0; 627301474822.25 to 716924000000, 2
-56201422.00716924000000.00
Valid
3,904 · 75.5%
Missing
1,264 · 24.5%
Distinct
3,834 · 98.2% of valid
Min
-56201422.00
25%
50731000.00
Median
515458000.00
75%
2809000000.00
Max
716924000000.00

fy_gross_profit

decimal

Gross profit for the latest fiscal year.

Histogram: -1256386000 to 48514662250, 2,552; 48514662250 to 98285710500, 8; 98285710500 to 148056758750, 0; 148056758750 to 197827807000, 7; 197827807000 to 247598855250, 1; 247598855250 to 297369903500, 0; 297369903500 to 347140951750, 0; 347140951750 to 396912000000, 2
-1256386000.00396912000000.00
Valid
2,570 · 49.7%
Missing
2,598 · 50.3%
Distinct
2,555 · 99.4% of valid
Min
-1256386000.00
25%
11137000.00
Median
205599000.00
75%
1048342000.00
Max
396912000000.00

fy_operating_income

decimal

Operating income for the latest fiscal year.

Histogram: -17723146000 to 1123497250, 3,496; 1123497250 to 19970140500, 319; 19970140500 to 38816783750, 9; 38816783750 to 57663427000, 0; 57663427000 to 76510070250, 0; 76510070250 to 95356713500, 2; 95356713500 to 114203356750, 0; 114203356750 to 133050000000, 4
-17723146000.00133050000000.00
Valid
3,830 · 74.1%
Missing
1,338 · 25.9%
Distinct
3,802 · 99.3% of valid
Min
-17723146000.00
25%
-23922000.00
Median
-600646.00
75%
160000000.00
Max
133050000000.00

fy_net_income

decimal

Net income for the latest fiscal year.

Histogram: -14506939000 to -4286071625, 6; -4286071625 to 5934795750, 2,401; 5934795750 to 16155663125, 37; 16155663125 to 26376530500, 9; 26376530500 to 36597397875, 2; 36597397875 to 46818265250, 0; 46818265250 to 57039132625, 0; 57039132625 to 67260000000, 1
-14506939000.0067260000000.00
Valid
2,456 · 47.5%
Missing
2,712 · 52.5%
Distinct
2,438 · 99.3% of valid
Min
-14506939000.00
25%
-31041659.00
Median
6938000.00
75%
220264000.00
Max
67260000000.00

fy_eps

decimal

Diluted earnings per share for the latest fiscal year.

Histogram: -163173 to -142353.18375, 1; -142353.18375 to -121533.36749999999, 0; -121533.36749999999 to -100713.55125, 0; -100713.55125 to -79893.735000000001, 1; -79893.735000000001 to -59073.918749999997, 0; -59073.918749999997 to -38254.102500000001, 0; -38254.102500000001 to -17434.286250000001, 0; -17434.286250000001 to 3385.5300000000002, 4,232
-163173.00003385.5300
Valid
4,234 · 81.9%
Missing
934 · 18.1%
Distinct
1,663 · 39.3% of valid
Min
-163173.0000
25%
-1.0100
Median
0.1400
75%
2.4400
Max
3385.5300

fy_ocf

decimal

Operating cash flow for the latest fiscal year.

Histogram: -147782000000 to -108720125000, 1; -108720125000 to -69658250000, 0; -69658250000 to -30596375000, 2; -30596375000 to 8465500000, 4,535; 8465500000 to 47527375000, 83; 47527375000 to 86589250000, 1; 86589250000 to 125651125000, 3; 125651125000 to 164713000000, 3
-147782000000.00164713000000.00
Valid
4,628 · 89.6%
Missing
540 · 10.4%
Distinct
4,580 · 99% of valid
Min
-147782000000.00
25%
-6745000.00
Median
25671000.00
75%
311237000.00
Max
164713000000.00

fy_capex

decimal

Capital expenditure for the latest fiscal year.

Histogram: -149900000 to 11299712500, 3,159; 11299712500 to 22749325000, 10; 22749325000 to 34198937500, 2; 34198937500 to 45648550000, 0; 45648550000 to 57098162500, 1; 57098162500 to 68547775000, 1; 68547775000 to 79997387500, 1; 79997387500 to 91447000000, 1
-149900000.0091447000000.00
Valid
3,175 · 61.4%
Missing
1,993 · 38.6%
Distinct
2,852 · 89.8% of valid
Min
-149900000.00
25%
573500.00
Median
7634000.00
75%
70063000.00
Max
91447000000.00

fy_fcf

decimal

Free cash flow for the latest fiscal year.

Histogram: -147782000000 to -111870000000, 1; -111870000000 to -75958000000, 0; -75958000000 to -40046000000, 2; -40046000000 to -4134000000, 12; -4134000000 to 31778000000, 4,604; 31778000000 to 67690000000, 4; 67690000000 to 103602000000, 4; 103602000000 to 139514000000, 1
-147782000000.00139514000000.00
Valid
4,628 · 89.6%
Missing
540 · 10.4%
Distinct
4,575 · 98.9% of valid
Min
-147782000000.00
25%
-9937682.00
Median
12387298.00
75%
243798000.00
Max
139514000000.00

fy_buybacks

decimal

Share buybacks in the latest fiscal year.

Histogram: -82400000 to 11266775000, 2,034; 11266775000 to 22615950000, 12; 22615950000 to 33965125000, 2; 33965125000 to 45314300000, 1; 45314300000 to 56663475000, 1; 56663475000 to 68012650000, 0; 68012650000 to 79361825000, 0; 79361825000 to 90711000000, 1
-82400000.0090711000000.00
Valid
2,051 · 39.7%
Missing
3,117 · 60.3%
Distinct
1,693 · 82.5% of valid
Min
-82400000.00
25%
3100000.00
Median
40270000.00
75%
266000000.00
Max
90711000000.00

fy_dividends

decimal

Dividends paid in the latest fiscal year.

Histogram: -2080000000 to 1190250000, 1,556; 1190250000 to 4460500000, 105; 4460500000 to 7730750000, 22; 7730750000 to 11001000000, 9; 11001000000 to 14271250000, 4; 14271250000 to 17541500000, 3; 17541500000 to 20811750000, 0; 20811750000 to 24082000000, 1
-2080000000.0024082000000.00
Valid
1,700 · 32.9%
Missing
3,468 · 67.1%
Distinct
1,586 · 93.3% of valid
Min
-2080000000.00
25%
11934000.00
Median
62550000.00
75%
267000000.00
Max
24082000000.00

fy_rnd

decimal

Research and development expense in the latest fiscal year.

Histogram: 0 to 7635875000, 2,053; 7635875000 to 15271750000, 10; 15271750000 to 22907625000, 2; 22907625000 to 30543500000, 0; 30543500000 to 38179375000, 2; 38179375000 to 45815250000, 0; 45815250000 to 53451125000, 0; 53451125000 to 61087000000, 2
0.0061087000000.00
Valid
2,069 · 40%
Missing
3,099 · 60%
Distinct
2,014 · 97.3% of valid
Min
0.00
25%
5500000.00
Median
29858000.00
75%
126937000.00
Max
61087000000.00

fy_revenue_growth

decimal

Latest fiscal year revenue growth against the year before, in percent.

Histogram: -193.96000000000001 to 203788.61874999999, 3,775; 203788.61874999999 to 407771.19750000001, 1; 407771.19750000001 to 611753.77625, 0; 611753.77625 to 815736.35499999998, 0; 815736.35499999998 to 1019718.93375, 1; 1019718.93375 to 1223701.5125, 0; 1223701.5125 to 1427684.0912499998, 0; 1427684.0912499998 to 1631666.6699999999, 1
-193.961631666.67
Valid
3,778 · 73.1%
Missing
1,390 · 26.9%
Distinct
2,902 · 76.8% of valid
Min
-193.96
25%
-2.33
Median
6.54
75%
18.79
Max
1631666.67

fy_ni_growth

decimal

Latest fiscal year net income growth, in percent.

Histogram: -389037.5 to -320668.99249999999, 1; -320668.99249999999 to -252300.48499999999, 0; -252300.48499999999 to -183931.97750000001, 0; -183931.97750000001 to -115563.47, 1; -115563.47 to -47194.962499999994, 1; -47194.962499999994 to 21173.544999999998, 1,360; 21173.544999999998 to 89542.052499999991, 2; 89542.052499999991 to 157910.56, 1
-389037.50157910.56
Valid
1,366 · 26.4%
Missing
3,802 · 73.6%
Distinct
1,326 · 97.1% of valid
Min
-389037.50
25%
-46.17
Median
0.55
75%
30.20
Max
157910.56

fy_eps_growth

decimal

Latest fiscal year diluted EPS growth, in percent.

Histogram: -25224.32 to -11187.398749999998, 5; -11187.398749999998 to 2849.5225000000028, 2,264; 2849.5225000000028 to 16886.443750000002, 9; 16886.443750000002 to 30923.365000000002, 0; 30923.365000000002 to 44960.286250000005, 0; 44960.286250000005 to 58997.207500000004, 0; 58997.207500000004 to 73034.128750000003, 0; 73034.128750000003 to 87071.050000000003, 1
-25224.3287071.05
Valid
2,279 · 44.1%
Missing
2,889 · 55.9%
Distinct
2,052 · 90% of valid
Min
-25224.32
25%
-44.44
Median
2.73
75%
30.58
Max
87071.05

fy_ebitda

decimal

Operating income plus depreciation and amortization for the latest fiscal year, US dollars (EBITDA).

Histogram: -16137597000 to 4095977625, 3,691; 4095977625 to 24329552250, 126; 24329552250 to 44563126875, 6; 44563126875 to 64796701500, 1; 64796701500 to 85030276125, 0; 85030276125 to 105263850750, 1; 105263850750 to 125497425375, 0; 125497425375 to 145731000000, 5
-16137597000.00145731000000.00
Valid
3,830 · 74.1%
Missing
1,338 · 25.9%
Distinct
3,809 · 99.5% of valid
Min
-16137597000.00
25%
-18441243.00
Median
1612000.00
75%
238171000.00
Max
145731000000.00

fy_cost_of_revenue

decimal

Cost of revenue (cost of goods and services sold) for the latest fiscal year, US dollars.

Histogram: 0 to 66924375000, 2,481; 66924375000 to 133848750000, 14; 133848750000 to 200773125000, 3; 200773125000 to 267697500000, 5; 267697500000 to 334621875000, 1; 334621875000 to 401546250000, 2; 401546250000 to 468470625000, 0; 468470625000 to 535395000000, 1
0.00535395000000.00
Valid
2,507 · 48.5%
Missing
2,661 · 51.5%
Distinct
2,487 · 99.2% of valid
Min
0.00
25%
20122013.00
Median
211259000.00
75%
1439800000.00
Max
535395000000.00

fy_sga

decimal

Selling, general and administrative expense for the latest fiscal year, US dollars.

Histogram: 0 to 18492875000, 1,613; 18492875000 to 36985750000, 12; 36985750000 to 55478625000, 1; 55478625000 to 73971500000, 1; 73971500000 to 92464375000, 0; 92464375000 to 110957250000, 0; 110957250000 to 129450125000, 0; 129450125000 to 147943000000, 1
0.00147943000000.00
Valid
1,628 · 31.5%
Missing
3,540 · 68.5%
Distinct
1,620 · 99.5% of valid
Min
0.00
25%
52767000.00
Median
242400000.00
75%
844300000.00
Max
147943000000.00

fy_income_tax

decimal

Income tax expense for the latest fiscal year, US dollars.

Histogram: -4386375000 to -506078125, 13; -506078125 to 3374218750, 4,079; 3374218750 to 7254515625, 19; 7254515625 to 11134812500, 1; 11134812500 to 15015109375, 1; 15015109375 to 18895406250, 2; 18895406250 to 22775703125, 4; 22775703125 to 26656000000, 2
-4386375000.0026656000000.00
Valid
4,121 · 79.7%
Missing
1,047 · 20.3%
Distinct
3,409 · 82.7% of valid
Min
-4386375000.00
25%
0.00
Median
2778000.00
75%
48284000.00
Max
26656000000.00

fy_interest_expense

decimal

Interest expense for the latest fiscal year, US dollars.

Histogram: -1812000000 to 6766250000, 852; 6766250000 to 15344500000, 0; 15344500000 to 23922750000, 0; 23922750000 to 32501000000, 0; 32501000000 to 41079250000, 0; 41079250000 to 49657500000, 0; 49657500000 to 58235750000, 0; 58235750000 to 66814000000, 1
-1812000000.0066814000000.00
Valid
853 · 16.5%
Missing
4,315 · 83.5%
Distinct
813 · 95.3% of valid
Min
-1812000000.00
25%
1360967.00
Median
20158000.00
75%
131000000.00
Max
66814000000.00

fy_da

decimal

Depreciation, depletion and amortization for the latest fiscal year, US dollars.

Histogram: 0 to 8219500000, 2,455; 8219500000 to 16439000000, 8; 16439000000 to 24658500000, 3; 24658500000 to 32878000000, 1; 32878000000 to 41097500000, 0; 41097500000 to 49317000000, 0; 49317000000 to 57536500000, 0; 57536500000 to 65756000000, 1
0.0065756000000.00
Valid
2,468 · 47.8%
Missing
2,700 · 52.2%
Distinct
2,384 · 96.6% of valid
Min
0.00
25%
3379000.00
Median
28760000.00
75%
163699000.00
Max
65756000000.00

fy_sbc

decimal

Share-based compensation for the latest fiscal year, US dollars.

Histogram: -4500000 to 3115187500, 3,800; 3115187500 to 6234875000, 6; 6234875000 to 9354562500, 2; 9354562500 to 12474250000, 1; 12474250000 to 15593937500, 1; 15593937500 to 18713625000, 0; 18713625000 to 21833312500, 2; 21833312500 to 24953000000, 1
-4500000.0024953000000.00
Valid
3,813 · 73.8%
Missing
1,355 · 26.2%
Distinct
3,508 · 92% of valid
Min
-4500000.00
25%
2602175.00
Median
11849000.00
75%
38601000.00
Max
24953000000.00

fy_eps_basic

decimal

Basic earnings per share for the latest fiscal year, US dollars.

Histogram: -163173 to -142244.89874999999, 1; -142244.89874999999 to -121316.7975, 0; -121316.7975 to -100388.69624999999, 0; -100388.69624999999 to -79460.595000000001, 1; -79460.595000000001 to -58532.493750000001, 0; -58532.493750000001 to -37604.392500000002, 0; -37604.392500000002 to -16676.291249999998, 0; -16676.291249999998 to 4251.8100000000004, 4,310
-163173.00004251.8100
Valid
4,312 · 83.4%
Missing
856 · 16.6%
Distinct
1,701 · 39.4% of valid
Min
-163173.0000
25%
-1.0500
Median
0.1300
75%
2.4700
Max
4251.8100

q_frame

string

SEC calendar frame of the latest quarter, such as CY2026Q2.

  • CY2026Q275%
  • CY2026Q318%
  • CY2026Q14%
  • Other (23)
Valid
4,657 · 90.1%
Missing
511 · 9.9%
Distinct
35 · 0.8% of valid

q_year

integer

Calendar year of the latest quarter.

Histogram: 2017 to 2018, 12; 2019 to 2019, 10; 2020 to 2020, 9; 2021 to 2021, 12; 2022 to 2023, 31; 2024 to 2024, 11; 2025 to 2025, 53; 2026 to 2026, 4,519
20172026
Valid
4,657 · 90.1%
Missing
511 · 9.9%
Distinct
10 · 0.2% of valid
Min
2017
25%
2026
Median
2026
75%
2026
Max
2026

q_quarter

integer

Calendar quarter number of the latest quarter.

Histogram: 1 to 1, 238; 2 to 2, 3,536; 3 to 3, 843; 4 to 4, 40
14
Valid
4,657 · 90.1%
Missing
511 · 9.9%
Distinct
4 · 0.1% of valid
Min
1
25%
2
Median
2
75%
2
Max
4

q_end

date

Last day of the latest quarter.

Timeline per year: 2018-01-01, 12; 2019-01-01, 10; 2020-01-01, 8; 2021-01-01, 13; 2022-01-01, 9; 2023-01-01, 22; 2024-01-01, 11; 2025-01-01, 50; 2026-01-01, 4,522
2018-01-012026-01-01

per year

Valid
4,657 · 90.1%
Missing
511 · 9.9%
Distinct
92 · 2% of valid

q_revenue

decimal

Revenue for the latest quarter.

Histogram: -361990706 to 24926258132.25, 3,511; 24926258132.25 to 50214506970.5, 20; 50214506970.5 to 75502755808.75, 10; 75502755808.75 to 100791004647, 4; 100791004647 to 126079253485.25, 6; 126079253485.25 to 151367502323.5, 1; 151367502323.5 to 176655751161.75, 0; 176655751161.75 to 201944000000, 2
-361990706.00201944000000.00
Valid
3,554 · 68.8%
Missing
1,614 · 31.2%
Distinct
3,459 · 97.3% of valid
Min
-361990706.00
25%
23363000.00
Median
198954000.00
75%
943490000.00
Max
201944000000.00

q_net_income

decimal

Net income for the latest quarter.

Histogram: -19376899000 to -9493786625, 1; -9493786625 to 389325750, 4,238; 389325750 to 10272438125, 357; 10272438125 to 20155550500, 3; 20155550500 to 30038662875, 6; 30038662875 to 39921775250, 1; 39921775250 to 49804887625, 0; 49804887625 to 59688000000, 1
-19376899000.0059688000000.00
Valid
4,607 · 89.1%
Missing
561 · 10.9%
Distinct
4,464 · 96.9% of valid
Min
-19376899000.00
25%
-5627000.00
Median
2158000.00
75%
52666000.00
Max
59688000000.00

q_eps

decimal

Diluted EPS for the latest quarter.

Histogram: -152717402 to -129529231.75, 1; -129529231.75 to -106341061.5, 0; -106341061.5 to -83152891.25, 0; -83152891.25 to -59964721, 0; -59964721 to -36776550.75, 0; -36776550.75 to -13588380.5, 0; -13588380.5 to 9599789.75, 3,929; 9599789.75 to 32787960, 1
-152717402.000032787960.0000
Valid
3,931 · 76.1%
Missing
1,237 · 23.9%
Distinct
846 · 21.5% of valid
Min
-152717402.0000
25%
-0.1800
Median
0.1300
75%
0.8900
Max
32787960.0000

q_revenue_growth

decimal

Latest quarter revenue against the same quarter a year earlier, in percent.

Histogram: -209.34999999999999 to 696771.36875000002, 3,443; 696771.36875000002 to 1393752.0875000001, 0; 1393752.0875000001 to 2090732.8062500001, 0; 2090732.8062500001 to 2787713.5250000004, 0; 2787713.5250000004 to 3484694.2437499999, 0; 3484694.2437499999 to 4181674.9625000004, 0; 4181674.9625000004 to 4878655.6812500004, 0; 4878655.6812500004 to 5575636.4000000004, 1
-209.355575636.40
Valid
3,444 · 66.6%
Missing
1,724 · 33.4%
Distinct
2,767 · 80.3% of valid
Min
-209.35
25%
-0.23
Median
8.45
75%
23.23
Max
5575636.40

q_ni_growth

decimal

Latest quarter net income growth year over year, in percent.

Histogram: -183926.04000000001 to 158336.41250000001, 2,533; 158336.41250000001 to 500598.86499999999, 0; 500598.86499999999 to 842861.3175, 0; 842861.3175 to 1185123.77, 0; 1185123.77 to 1527386.2225000001, 0; 1527386.2225000001 to 1869648.675, 0; 1869648.675 to 2211911.1275000004, 0; 2211911.1275000004 to 2554173.5800000001, 1
-183926.042554173.58
Valid
2,534 · 49%
Missing
2,634 · 51%
Distinct
2,436 · 96.1% of valid
Min
-183926.04
25%
-37.64
Median
9.55
75%
51.01
Max
2554173.58

q_eps_growth

decimal

Latest quarter diluted EPS growth year over year, in percent.

Histogram: -12000 to -9337.5, 1; -9337.5 to -6675, 2; -6675 to -4012.5, 1; -4012.5 to -1350, 12; -1350 to 1312.5, 2,188; 1312.5 to 3975, 24; 3975 to 6637.5, 1; 6637.5 to 9300, 2
-12000.009300.00
Valid
2,231 · 43.2%
Missing
2,937 · 56.8%
Distinct
1,698 · 76.1% of valid
Min
-12000.00
25%
-28.57
Median
11.54
75%
50.00
Max
9300.00

q_shares

decimal

Diluted shares in the latest quarter.

Histogram: 0 to 392521787750000, 3,986; 392521787750000 to 785043575500000, 0; 785043575500000 to 1177565363250000, 0; 1177565363250000 to 1570087151000000, 0; 1570087151000000 to 1962608938750000, 0; 1962608938750000 to 2355130726500000, 0; 2355130726500000 to 2747652514250000, 0; 2747652514250000 to 3140174302000000, 1
03140174302000000
Valid
3,987 · 77.1%
Missing
1,181 · 22.9%
Distinct
3,938 · 98.8% of valid
Min
0
25%
21338903
Median
58284000
75%
151895000
Max
3140174302000000

q_filing_url

string

Link to the SEC filing behind the latest quarter.

4,657 distinct values, no chart

Valid
4,657 · 90.1%
Missing
511 · 9.9%
Distinct
4,657 · 100% of valid

q_derived

boolean

True when the latest quarter is a fiscal fourth quarter derived as the fiscal-year figure minus the three quarters before it.

  • false99%
  • true1%
Valid
5,168 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

revenue_ttm

decimal

Trailing twelve months revenue.

Histogram: -1506476000 to 98363708500, 3,725; 98363708500 to 198233893000, 19; 198233893000 to 298104077500, 8; 298104077500 to 397974262000, 5; 397974262000 to 497844446500, 5; 497844446500 to 597714631000, 0; 597714631000 to 697584815500, 0; 697584815500 to 797455000000, 2
-1506476000.00797455000000.00
Valid
3,764 · 72.8%
Missing
1,404 · 27.2%
Distinct
3,733 · 99.2% of valid
Min
-1506476000.00
25%
64213000.00
Median
613807000.00
75%
3144934000.00
Max
797455000000.00

net_income_ttm

decimal

Trailing twelve months net income.

Histogram: -11739000000 to 485875000, 2,005; 485875000 to 12710750000, 418; 12710750000 to 24935625000, 17; 24935625000 to 37160500000, 1; 37160500000 to 49385375000, 1; 49385375000 to 61610250000, 0; 61610250000 to 73835125000, 0; 73835125000 to 86060000000, 1
-11739000000.0086060000000.00
Valid
2,443 · 47.3%
Missing
2,725 · 52.7%
Distinct
2,430 · 99.5% of valid
Min
-11739000000.00
25%
-31041659.00
Median
8475682.00
75%
259995000.00
Max
86060000000.00

eps_ttm

decimal

Trailing twelve months diluted EPS.

Histogram: -163173 to 2923252.0337499999, 4,119; 2923252.0337499999 to 6009677.0674999999, 0; 6009677.0674999999 to 9096102.1012500003, 0; 9096102.1012500003 to 12182527.135, 0; 12182527.135 to 15268952.168749999, 0; 15268952.168749999 to 18355377.202500001, 0; 18355377.202500001 to 21441802.236249998, 0; 21441802.236249998 to 24528227.27, 1
-163173.000024528227.2700
Valid
4,120 · 79.7%
Missing
1,048 · 20.3%
Distinct
1,692 · 41.1% of valid
Min
-163173.0000
25%
-0.7500
Median
0.3500
75%
3.1600
Max
24528227.2700

quarters_after_fy

integer

Quarters reported after the latest fiscal year.

Histogram: 0 to 2, 3,679; 3 to 4, 1,081; 5 to 6, 11; 7 to 8, 4; 9 to 11, 0; 12 to 13, 1; 14 to 15, 0; 16 to 17, 1
017
Valid
4,777 · 92.4%
Missing
391 · 7.6%
Distinct
10 · 0.2% of valid
Min
0
25%
2
Median
2
75%
2
Max
17

bs_date

date

Date of the latest balance sheet.

Timeline per year: 2018-01-01, 11; 2019-01-01, 5; 2020-01-01, 9; 2021-01-01, 6; 2022-01-01, 7; 2023-01-01, 10; 2024-01-01, 22; 2025-01-01, 416; 2026-01-01, 4,507
2018-01-012026-01-01

per year

Valid
4,993 · 96.6%
Missing
175 · 3.4%
Distinct
89 · 1.8% of valid

total_assets

decimal

Total assets on the latest balance sheet.

Histogram: 7323 to 626883631407.625, 4,970; 626883631407.625 to 1253767255492.25, 7; 1253767255492.25 to 1880650879576.875, 2; 1880650879576.875 to 2507534503661.5, 2; 2507534503661.5 to 3134418127746.125, 1; 3134418127746.125 to 3761301751830.75, 1; 3761301751830.75 to 4388185375915.375, 0; 4388185375915.375 to 5015069000000, 1
7323.005015069000000.00
Valid
4,984 · 96.4%
Missing
184 · 3.6%
Distinct
4,969 · 99.7% of valid
Min
7323.00
25%
142255198.00
Median
978006000.00
75%
5449100000.00
Max
5015069000000.00

total_liabilities

decimal

Total liabilities on the latest balance sheet.

Histogram: 0 to 580058875000, 4,400; 580058875000 to 1160117750000, 3; 1160117750000 to 1740176625000, 1; 1740176625000 to 2320235500000, 2; 2320235500000 to 2900294375000, 1; 2900294375000 to 3480353250000, 1; 3480353250000 to 4060412125000, 0; 4060412125000 to 4640471000000, 1
0.004640471000000.00
Valid
4,409 · 85.3%
Missing
759 · 14.7%
Distinct
4,383 · 99.4% of valid
Min
0.00
25%
21131000.00
Median
327391000.00
75%
2748785000.00
Max
4640471000000.00

equity

decimal

Shareholders' equity on the latest balance sheet.

Histogram: -10783000000 to 84053625000, 4,875; 84053625000 to 178890250000, 17; 178890250000 to 273726875000, 6; 273726875000 to 368563500000, 1; 368563500000 to 463400125000, 1; 463400125000 to 558236750000, 1; 558236750000 to 653073375000, 1; 653073375000 to 747910000000, 2
-10783000000.00747910000000.00
Valid
4,904 · 94.9%
Missing
264 · 5.1%
Distinct
4,887 · 99.7% of valid
Min
-10783000000.00
25%
18792447.00
Median
312294000.00
75%
1629555000.00
Max
747910000000.00

cash

decimal

Cash and cash equivalents on the latest balance sheet, US dollars; for banks, cash and due from banks plus interest-bearing deposits.

Histogram: 0 to 43697375000, 4,911; 43697375000 to 87394750000, 6; 87394750000 to 131092125000, 0; 131092125000 to 174789500000, 1; 174789500000 to 218486875000, 2; 218486875000 to 262184250000, 1; 262184250000 to 305881625000, 0; 305881625000 to 349579000000, 2
0.00349579000000.00
Valid
4,923 · 95.3%
Missing
245 · 4.7%
Distinct
4,781 · 97.1% of valid
Min
0.00
25%
10131000.00
Median
76900000.00
75%
319855000.00
Max
349579000000.00

sti

decimal

Short-term investments (marketable securities, current) on the latest balance sheet, US dollars.

Histogram: 0 to 26095500000, 1,149; 26095500000 to 52191000000, 5; 52191000000 to 78286500000, 2; 78286500000 to 104382000000, 0; 104382000000 to 130477500000, 0; 130477500000 to 156573000000, 0; 156573000000 to 182668500000, 0; 182668500000 to 208764000000, 1
0.00208764000000.00
Valid
1,157 · 22.4%
Missing
4,011 · 77.6%
Distinct
1,065 · 92% of valid
Min
0.00
25%
9200000.00
Median
72231000.00
75%
293480907.00
Max
208764000000.00

lti

decimal

Long-term (noncurrent) marketable or held-to-maturity securities on the latest balance sheet, US dollars.

Histogram: 0 to 10514750000, 235; 10514750000 to 21029500000, 3; 21029500000 to 31544250000, 0; 31544250000 to 42059000000, 0; 42059000000 to 52573750000, 1; 52573750000 to 63088500000, 0; 63088500000 to 73603250000, 0; 73603250000 to 84118000000, 1
0.0084118000000.00
Valid
240 · 4.6%
Missing
4,928 · 95.4%
Distinct
227 · 94.6% of valid
Min
0.00
25%
10276000.00
Median
97959000.00
75%
315489953.00
Max
84118000000.00

cash_and_sti

decimal

Cash plus short-term investments on the latest balance sheet, US dollars.

Histogram: 0 to 43697375000, 4,905; 43697375000 to 87394750000, 9; 87394750000 to 131092125000, 2; 131092125000 to 174789500000, 1; 174789500000 to 218486875000, 2; 218486875000 to 262184250000, 1; 262184250000 to 305881625000, 1; 305881625000 to 349579000000, 2
0.00349579000000.00
Valid
4,923 · 95.3%
Missing
245 · 4.7%
Distinct
4,782 · 97.1% of valid
Min
0.00
25%
11674035.00
Median
97500000.00
75%
400758000.00
Max
349579000000.00

cash_and_investments

decimal

Cash plus short-term and long-term investments on the latest balance sheet, US dollars: the broad cash pile.

Histogram: 0 to 43697375000, 4,905; 43697375000 to 87394750000, 7; 87394750000 to 131092125000, 3; 131092125000 to 174789500000, 2; 174789500000 to 218486875000, 2; 218486875000 to 262184250000, 1; 262184250000 to 305881625000, 1; 305881625000 to 349579000000, 2
0.00349579000000.00
Valid
4,923 · 95.3%
Missing
245 · 4.7%
Distinct
4,782 · 97.1% of valid
Min
0.00
25%
12222000.00
Median
101469000.00
75%
414000000.00
Max
349579000000.00

total_debt

decimal

Total borrowings on the latest balance sheet, US dollars: the combined debt concept when tagged, else long-term plus current borrowings, else the single borrowing line the filer reports. Finance leases are separate.

Histogram: 0 to 57565375000, 3,318; 57565375000 to 115130750000, 21; 115130750000 to 172696125000, 3; 172696125000 to 230261500000, 2; 230261500000 to 287826875000, 0; 287826875000 to 345392250000, 1; 345392250000 to 402957625000, 2; 402957625000 to 460523000000, 2
0.00460523000000.00
Valid
3,349 · 64.8%
Missing
1,819 · 35.2%
Distinct
3,125 · 93.3% of valid
Min
0.00
25%
22500000.00
Median
358789000.00
75%
2220900000.00
Max
460523000000.00

long_term_debt

decimal

Long-term borrowings, noncurrent portion, on the latest balance sheet, US dollars.

Histogram: -219518000 to 47702421750, 2,779; 47702421750 to 95624361500, 27; 95624361500 to 143546301250, 3; 143546301250 to 191468241000, 3; 191468241000 to 239390180750, 0; 239390180750 to 287312120500, 0; 287312120500 to 335234060250, 2; 335234060250 to 383156000000, 1
-219518000.00383156000000.00
Valid
2,815 · 54.5%
Missing
2,353 · 45.5%
Distinct
2,647 · 94% of valid
Min
-219518000.00
25%
46477087.00
Median
493000000.00
75%
2493382000.00
Max
383156000000.00

current_debt

decimal

Borrowings due within a year, including short-term borrowings and commercial paper, on the latest balance sheet, US dollars.

Histogram: 0 to 9053750000, 2,120; 9053750000 to 18107500000, 17; 18107500000 to 27161250000, 1; 27161250000 to 36215000000, 0; 36215000000 to 45268750000, 2; 45268750000 to 54322500000, 1; 54322500000 to 63376250000, 0; 63376250000 to 72430000000, 1
0.0072430000000.00
Valid
2,142 · 41.4%
Missing
3,026 · 58.6%
Distinct
1,755 · 81.9% of valid
Min
0.00
25%
1651000.00
Median
16400778.00
75%
230000000.00
Max
72430000000.00

finance_lease_liabilities

decimal

Finance (capital) lease liabilities on the latest balance sheet, US dollars; kept apart from debt unless the filer tags them together.

Histogram: 0 to 8871625000, 950; 8871625000 to 17743250000, 3; 17743250000 to 26614875000, 0; 26614875000 to 35486500000, 0; 35486500000 to 44358125000, 0; 44358125000 to 53229750000, 0; 53229750000 to 62101375000, 0; 62101375000 to 70973000000, 1
0.0070973000000.00
Valid
954 · 18.5%
Missing
4,214 · 81.5%
Distinct
851 · 89.2% of valid
Min
0.00
25%
791000.00
Median
7000000.00
75%
45776169.00
Max
70973000000.00

net_cash

decimal

Cash plus short-term investments minus total debt, US dollars, only when both sides are reported; negative is net debt.

Histogram: -250608000000 to -201909500000, 2; -201909500000 to -153211000000, 1; -153211000000 to -104512500000, 2; -104512500000 to -55814000000, 13; -55814000000 to -7115500000, 279; -7115500000 to 41583000000, 3,030; 41583000000 to 90281500000, 1; 90281500000 to 138980000000, 1
-250608000000.00138980000000.00
Valid
3,329 · 64.4%
Missing
1,839 · 35.6%
Distinct
3,316 · 99.6% of valid
Min
-250608000000.00
25%
-1465400000.00
Median
-108305000.00
75%
11293000.00
Max
138980000000.00

current_assets

decimal

Current assets on the latest balance sheet.

Histogram: 245 to 46833125214.375, 4,023; 46833125214.375 to 93666250183.75, 26; 93666250183.75 to 140499375153.125, 8; 140499375153.125 to 187332500122.5, 3; 187332500122.5 to 234165625091.875, 1; 234165625091.875 to 280998750061.25, 1; 280998750061.25 to 327831875030.625, 0; 327831875030.625 to 374665000000, 1
245.00374665000000.00
Valid
4,063 · 78.6%
Missing
1,105 · 21.4%
Distinct
4,040 · 99.4% of valid
Min
245.00
25%
28394000.00
Median
260651000.00
75%
1253800000.00
Max
374665000000.00

current_liabilities

decimal

Current liabilities on the latest balance sheet.

Histogram: 0 to 32247750000, 3,985; 32247750000 to 64495500000, 37; 64495500000 to 96743250000, 7; 96743250000 to 128991000000, 6; 128991000000 to 161238750000, 4; 161238750000 to 193486500000, 0; 193486500000 to 225734250000, 0; 225734250000 to 257982000000, 1
0.00257982000000.00
Valid
4,040 · 78.2%
Missing
1,128 · 21.8%
Distinct
4,015 · 99.4% of valid
Min
0.00
25%
11059000.00
Median
100540000.00
75%
714000000.00
Max
257982000000.00

inventory

decimal

Inventory, net, on the latest balance sheet, US dollars.

Histogram: 0 to 7700000000, 2,103; 7700000000 to 15400000000, 26; 15400000000 to 23100000000, 11; 23100000000 to 30800000000, 3; 30800000000 to 38500000000, 1; 38500000000 to 46200000000, 1; 46200000000 to 53900000000, 0; 53900000000 to 61600000000, 1
0.0061600000000.00
Valid
2,146 · 41.5%
Missing
3,022 · 58.5%
Distinct
2,123 · 98.9% of valid
Min
0.00
25%
7632000.00
Median
75673735.00
75%
480600000.00
Max
61600000000.00

goodwill

decimal

Goodwill on the latest balance sheet, US dollars.

Histogram: 0 to 14955750000, 2,487; 14955750000 to 29911500000, 65; 29911500000 to 44867250000, 11; 44867250000 to 59823000000, 11; 59823000000 to 74778750000, 5; 74778750000 to 89734500000, 3; 89734500000 to 104690250000, 1; 104690250000 to 119646000000, 2
0.00119646000000.00
Valid
2,585 · 50%
Missing
2,583 · 50%
Distinct
2,520 · 97.5% of valid
Min
0.00
25%
26913697.00
Median
238337000.00
75%
1318500000.00
Max
119646000000.00

bs_shares

decimal

Diluted shares on the latest balance sheet row.

Histogram: 0 to 36424113375, 4,306; 36424113375 to 72848226750, 1; 72848226750 to 109272340125, 3; 109272340125 to 145696453500, 1; 145696453500 to 182120566875, 0; 182120566875 to 218544680250, 0; 218544680250 to 254968793625, 0; 254968793625 to 291392907000, 1
0291392907000
Valid
4,312 · 83.4%
Missing
856 · 16.6%
Distinct
4,260 · 98.8% of valid
Min
0
25%
19809801
Median
56878000
75%
153600000
Max
291392907000

Support

Talk to Mostly Right

Loading chat…