SEC Public Company Identifiers and Filing Index v.1.0.0
10,194 Database Records
The SEC Public Company Identifiers and Filing Index connects SEC filer identities with published ticker and exchange associations plus practical recent filing metadata. It preserves zero-padded CIKs, ticker punctuation, share-class distinctions, multiple securities per filer, official SEC entity and SIC fields, incorporation and fiscal-year-end values, former names, and the latest filing accession, date, and form. The SQLite edition adds normalized former-name and recent-filing tables for efficient joins without turning the package into a filing-text archive.
Table Schema Database Field Statistics
Release structure
SEC Public Company Identifiers and Filing Index
Review the published tables, record coverage, and field names included with release 1.0.0.
- Database
- #802
- Version
- 1.0.0
- Format
- XML schema
Data dictionary
Tables and fields
| Field | Type | Required | Description |
|---|---|---|---|
| cik | string | Yes | SEC Central Index Key preserved as a zero-padded 10-character string. |
| entity_name | string | Yes | Current SEC filer name from the official submissions payload. |
| ticker | string | Yes | Ticker exactly as published in the SEC ticker and exchange association file. |
| exchange | string | Yes | Exchange association exactly as published by the SEC. |
| entity_type | string | Yes | SEC submissions entityType value, preserved without reclassification. |
| sic_code | string | No | SEC Standard Industrial Classification code, preserved as text. |
| sic_description | string | No | SEC description associated with the filer SIC code. |
| state_of_incorporation | string | No | SEC state or country of incorporation code. |
| fiscal_year_end | string | No | SEC fiscal-year-end value in MMDD form when reported. |
| former_names | string | No | Deterministically flattened JSON array of former SEC names and dates; normalized in SQLite. |
| former_name_date | string | No | Most recent former-name date, or null when no former name is reported. |
| latest_filing_date | string | Yes | Most recent filing date in the current SEC submissions array. |
| latest_accession_number | string | Yes | Accession number paired with latest_filing_date and latest_form_type. |
| latest_form_type | string | Yes | SEC form paired with the selected latest filing. |
| sec_submissions_url | string | Yes | Official data.sec.gov submissions API URL for the filer. |
| source_as_of | string | Yes | UTC retrieval timestamp shared by all rows in this build. |
Release at a glance
What is inside this database
Review verified record totals, geographic coverage, classifications, and field completeness for SEC Public Company Identifiers and Filing Index.
cikSEC Central Index Key preserved as a zero-padded 10-character string.
- Distinct
- 7,835
- Missing
- 0.0%
entity_nameCurrent SEC filer name from the official submissions payload.
- Distinct
- 7,834
- Missing
- 0.0%
tickerTicker exactly as published in the SEC ticker and exchange association file.
- Distinct
- 10,194
- Missing
- 0.0%
exchangeExchange association exactly as published by the SEC.
- Distinct
- 4
- Missing
- 0.0%
entity_typeSEC submissions entityType value, preserved without reclassification.
- Distinct
- 3
- Missing
- 0.0%
sic_codeSEC Standard Industrial Classification code, preserved as text.
- Distinct
- 400
- Missing
- 12.9%
sic_descriptionSEC description associated with the filer SIC code.
- Distinct
- 399
- Missing
- 13.0%
state_of_incorporationSEC state or country of incorporation code.
- Distinct
- 116
- Missing
- 12.7%
fiscal_year_endSEC fiscal-year-end value in MMDD form when reported.
- Distinct
- 85
- Missing
- 5.1%
former_namesDeterministically flattened JSON array of former SEC names and dates; normalized in SQLite.
- Distinct
- 3,998
- Missing
- 51.0%
former_name_dateMost recent former-name date, or null when no former name is reported.
- Distinct
- 2,665
- Missing
- 51.0%
latest_filing_dateMost recent filing date in the current SEC submissions array.
- Distinct
- 440
- Missing
- 0.0%
latest_accession_numberAccession number paired with latest_filing_date and latest_form_type.
- Distinct
- 7,816
- Missing
- 0.0%
latest_form_typeSEC form paired with the selected latest filing.
- Distinct
- 131
- Missing
- 0.0%
sec_submissions_urlOfficial data.sec.gov submissions API URL for the filer.
- Distinct
- 7,835
- Missing
- 0.0%
source_as_ofUTC retrieval timestamp shared by all rows in this build.
- Distinct
- 1
- Missing
- 0.0%
Exchange
- Nasdaq4,364
- NYSE3,299
- OTC2,497
- CBOE34
Null
Showing the 12 largest groups from 16 represented values.
- Former Name Date5,201
- Former Names5,201
- Sic Description1,324
- Sic Code1,319
- State Of Incorporation1,291
- Fiscal Year End524
- Cik0
- Entity Name0
- Ticker0
- Exchange0
- Entity Type0
- Latest Filing Date0
Records Information
Each of the 10,194 records represents one exact CIK, ticker, and exchange association published by the SEC at the source retrieval time. The records cover 7,835 filers. Multiple tickers, share classes, and exchanges remain separate. Associations are not labeled as active listings, and SEC entityType values are not expanded into invented company classifications.
Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.
RECENT DATA UPDATES
U.S. Jewelers and Jewelry Store Locations Database
38,557 Jewelry retail locations
v. 2.0.0
Updated 19 hours ago
v. 2.0.0
Updated 19 hours ago
U.S. Pet Boarding and Kennel Locations Database
6,859 Pet boarding locations
v. 2.0.0
Updated 19 hours ago
v. 2.0.0
Updated 19 hours ago
U.S. Animal Hospital Locations Database
2,990 Animal hospital locations
v. 2.0.0
Updated 19 hours ago
v. 2.0.0
Updated 19 hours ago
U.S. Veterinarian Practice Locations Database
39,007 Veterinarian practice locations
v. 2.0.0
Updated 19 hours ago
v. 2.0.0
Updated 19 hours ago
Custom Data Solutions
Tell us the industry, geography, fields, and format you need. We can help assemble a practical dataset for your project.
Discuss your data needs