SEC Broker Dealer Index

Snowflake table name : CYBERSYN.SEC_BROKER_DEALER_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
CIK	Central Index Key (CIK). Ten digit number assigned by the SEC to each registrant that submits filings.	VARCHAR	0001014780
COMPANY_NAME	Name of registrant. This corresponds to the name of the legal entity as of the latest filing date.	VARCHAR	FEIS TRADING CORP.
STREET_ADDRESS	Name and number of the street address of the registrant.	VARCHAR	1370 AVENUE OF THE AMERICAS, SUITE 2601
CITY	The city of the registrant.	VARCHAR	NEW YORK
ZIP	Raw zip code of the registrant.	VARCHAR	60606
COUNTRY_GEO_ID	A unique identifier of the country where the business is headquartered. Joinable to the GEOGRAPHY_INDEX table.	VARCHAR	country/USA
STATE_GEO_ID	A unique identifier of the state where the business is headquartered. Joinable to the GEOGRAPHY_INDEX table.	VARCHAR	geoId/42
ZIP_GEO_ID	A unique identifier of the zip code where the business is headquartered. Joinable to the GEOGRAPHY_INDEX table.	VARCHAR	zip/10105
FILING_TYPE	Form BD is filed to register a broker-dealer or to amend the business details of a previous filing.	VARCHAR	Registration
FILING_DATE	Filing date with the SEC.	DATE	2007-03-31
EARLIEST_FILING_DATE	The earliest filing date, which is usually the registration.	DATE	2007-03-31
LATEST_FILING_DATE	The latest (i.e. most recent) filing date, which is either the date of the registration (if no other filings have been submitted) or the most recent amendment to company information.	DATE	2007-06-30