Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

724 kB across 6 parts, newest sealed 5 November 2026 at 23:08 UTC.

The first build wrote 6 parts and 13,244 rows.

ONE_ROW_PER_SYMBOL passed.

LISTED_UNIVERSE_SIZE passed.

MOST_ROWS_HAVE_CIK passed.

symbol

string

Exchange ticker symbol as Nasdaq Trader lists it (ACT symbol), such as AAPL or BRK.B.

  • A0%
  • AA0%
  • AAA0%
  • Other (13,232)
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
13,244 · 100% of valid

sec_ticker

string

The same ticker written the SEC way, with a dash for the class or series, such as BRK-B; used to join SEC data.

  • A0%
  • AA0%
  • AAA0%
  • Other (13,232)
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
13,244 · 100% of valid

security_name

string

The security's full listed name, such as Apple Inc. - Common Stock.

  • Array Digital Infrastructure, Inc. 5.500% Senior Notes due 20700%
  • Crawford & Company Common Stock0%
  • Embotelladora Andina S.A. Common Stock0%
  • Other (13,222)
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
13,234 · 99.9% of valid

exchange

string

The listing exchange: Nasdaq, NYSE, NYSE American, NYSE Arca, Cboe BZX, IEX, NYSE Texas or Texas Stock Exchange.

  • Nasdaq42%
  • NYSE22%
  • NYSE Arca21%
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
6 · 0% of valid

exchange_code

string

Nasdaq Trader's one-letter exchange code (Q Nasdaq, N NYSE, A NYSE American, P NYSE Arca, Z Cboe BZX, V IEX).

  • Q42%
  • N22%
  • P21%
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
6 · 0% of valid

nasdaq_market_tier

string

For Nasdaq listings, the market tier: Global Select, Global Market or Capital Market.

  • Global Market44%
  • Capital Market30%
  • Global Select26%
Valid
5,603 · 42.3%
Missing
7,641 · 57.7%
Distinct
3 · 0.1% of valid

security_type

string

What kind of security this is: common stock, etf, preferred, adr, warrant, unit, right, debt, etn or other, from the listed name and ETF flag.

  • etf44%
  • common40%
  • preferred4%
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
10 · 0.1% of valid

is_etf

boolean

True for exchange-traded funds (ETFs), as the exchange flags them.

  • false56%
  • true44%
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

round_lot

integer

Round lot size in shares.

Histogram: 1 to 13.375, 24; 13.375 to 25.75, 0; 25.75 to 38.125, 0; 38.125 to 50.5, 283; 50.5 to 62.875, 0; 62.875 to 75.25, 0; 75.25 to 87.625, 0; 87.625 to 100, 12,937
1100
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
4 · 0% of valid
Min
1
25%
100
Median
100
75%
100
Max
100

financial_status

string

Nasdaq's financial status flag when not normal: D deficient, E delinquent, Q bankrupt, G deficient and bankrupt, H deficient and delinquent, J delinquent and bankrupt, K all three.

  • D94%
  • E4%
  • H2%
Valid
344 · 2.6%
Missing
12,900 · 97.4%
Distinct
3 · 0.9% of valid

cik

integer

SEC Central Index Key of the issuer, joined from the SEC ticker list; empty when the SEC does not list the ticker (most ETFs).

Histogram: 1750 to 270731, 561; 270731 to 539712, 87; 539712 to 808693, 312; 808693 to 1077674, 1,081; 1077674 to 1346655, 762; 1346655 to 1615636, 1,289; 1615636 to 1884617, 1,688; 1884617 to 2153598, 1,738
17502153598
Valid
7,518 · 56.8%
Missing
5,726 · 43.2%
Distinct
6,049 · 80.5% of valid
Min
1750
25%
1045450
Median
1551901
75%
1863127
Max
2153598

cik10

string

The CIK zero-padded to ten digits, as SEC data URLs need it.

  • 00009279711%
  • 00013933110%
  • 00000708580%
  • Other (6,037)
Valid
7,518 · 56.8%
Missing
5,726 · 43.2%
Distinct
6,049 · 80.5% of valid

sec_company_name

string

The issuer's name as the SEC records it (company, brand).

  • BANK OF MONTREAL /CAN/1%
  • Public Storage0%
  • BANK OF AMERICA CORP /DE/0%
  • Other (6,037)
Valid
7,518 · 56.8%
Missing
5,726 · 43.2%
Distinct
6,049 · 80.5% of valid

sic_code

string

Standard Industrial Classification code from the issuer's latest XBRL filing.

  • 677010%
  • 28348%
  • 67985%
  • Other (377)
Valid
6,868 · 51.9%
Missing
6,376 · 48.1%
Distinct
389 · 5.7% of valid

sic_industry

string

The SEC's industry title for the SIC code, such as SEMICONDUCTORS & RELATED DEVICES (industry, sector).

  • BLANK CHECKS11%
  • PHARMACEUTICAL PREPARATIONS8%
  • REAL ESTATE INVESTMENT TRUSTS5%
  • Other (361)
Valid
6,778 · 51.2%
Missing
6,466 · 48.8%
Distinct
373 · 5.5% of valid

sic_office

string

The SEC review office for the SIC code, such as Office of Technology.

  • Office of Finance12%
  • Office of Manufacturing12%
  • Office of Technology12%
  • Other (1)
Valid
6,778 · 51.2%
Missing
6,466 · 48.8%
Distinct
13 · 0.2% of valid

sic_division

string

Broad sector from the SIC code range: Manufacturing, Finance, insurance and real estate, Services, Mining, oil and gas, and so on.

  • Finance, insurance and real estate34%
  • Manufacturing32%
  • Services16%
Valid
6,868 · 51.9%
Missing
6,376 · 48.1%
Distinct
9 · 0.1% of valid

business_country

string

Country code of the issuer's business address.

  • US87%
  • CA3%
  • CN2%
  • Other (41)
Valid
6,185 · 46.7%
Missing
7,059 · 53.3%
Distinct
53 · 0.9% of valid

business_state

string

US state or province code of the issuer's business address (headquarters).

  • CA16%
  • NY15%
  • TX10%
  • Other (46)
Valid
5,534 · 41.8%
Missing
7,710 · 58.2%
Distinct
58 · 1% of valid

business_city

string

City of the issuer's business address (headquarters).

  • NEW YORK9%
  • HOUSTON2%
  • DALLAS2%
  • Other (1,579)
Valid
6,948 · 52.5%
Missing
6,296 · 47.5%
Distinct
1,591 · 22.9% of valid

incorporation_country

string

Country code of incorporation.

  • US69%
  • KY16%
  • CA4%
  • Other (39)
Valid
6,255 · 47.2%
Missing
6,989 · 52.8%
Distinct
51 · 0.8% of valid

incorporation_state

string

State of incorporation, such as DE for Delaware.

  • DE59%
  • MD8%
  • NV6%
  • Other (46)
Valid
4,533 · 34.2%
Missing
8,711 · 65.8%
Distinct
58 · 1.3% of valid

fiscal_year_end_mmdd

string

Fiscal year end as month and day, MMDD, such as 1231 or 0930.

  • 123183%
  • 06304%
  • 03313%
Valid
6,940 · 52.4%
Missing
6,304 · 47.6%
Distinct
12 · 0.2% of valid

filer_status

string

SEC filer category: large accelerated, accelerated, non-accelerated, smaller reporting.

  • non-accelerated46%
  • large accelerated40%
  • accelerated14%
Valid
6,769 · 51.1%
Missing
6,475 · 48.9%
Distinct
3 · 0% of valid

latest_xbrl_form

string

Form of the issuer's latest XBRL financial filing in the last four quarters, such as 10-Q, 10-K, 20-F or 40-F.

  • 10-Q77%
  • 20-F8%
  • 6-K7%
  • Other (12)
Valid
6,951 · 52.5%
Missing
6,293 · 47.5%
Distinct
24 · 0.3% of valid

latest_xbrl_period

date

Balance-sheet date of that filing.

  • 2026-06-3082%
  • 2025-12-319%
  • 2026-07-314%
  • Other (3)
Valid
6,951 · 52.5%
Missing
6,293 · 47.5%
Distinct
15 · 0.2% of valid

latest_xbrl_filed

date

Date that filing was filed.

  • 2026-08-0611%
  • 2026-08-147%
  • 2026-08-057%
  • Other (169)
Valid
6,951 · 52.5%
Missing
6,293 · 47.5%
Distinct
181 · 2.6% of valid

former_name

string

The issuer's most recent former name, if it changed.

  • BANKAMERICA CORP/DE/0%
  • COMMODITIES & CURRENCIES TRUST0%
  • MORGAN STANLEY DEAN WITTER & CO0%
  • Other (2,998)
Valid
3,604 · 27.2%
Missing
9,640 · 72.8%
Distinct
3,010 · 83.5% of valid

edgar_url

string

Link to the issuer's EDGAR filing list.

  • https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=00009279711%
  • https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=00013933110%
  • https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=00000708580%
  • Other (6,037)
Valid
7,518 · 56.8%
Missing
5,726 · 43.2%
Distinct
6,049 · 80.5% of valid

submissions_url

string

The SEC submissions JSON for the issuer, with every filing.

  • https://data.sec.gov/submissions/CIK0000927971.json1%
  • https://data.sec.gov/submissions/CIK0001393311.json0%
  • https://data.sec.gov/submissions/CIK0000070858.json0%
  • Other (6,037)
Valid
7,518 · 56.8%
Missing
5,726 · 43.2%
Distinct
6,049 · 80.5% of valid

companyfacts_url

string

The SEC XBRL company facts JSON for the issuer.

  • https://data.sec.gov/api/xbrl/companyfacts/CIK0000927971.json1%
  • https://data.sec.gov/api/xbrl/companyfacts/CIK0001393311.json0%
  • https://data.sec.gov/api/xbrl/companyfacts/CIK0000070858.json0%
  • Other (6,037)
Valid
7,518 · 56.8%
Missing
5,726 · 43.2%
Distinct
6,049 · 80.5% of valid

directory_date

date

Date of the Nasdaq Trader directory this row came from.

  • 2026-11-05100%
Valid
13,244 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid

Support

Talk to Mostly Right

Loading chat…