SEC Investment Company Index

Snowflake table name : CYBERSYN.SEC_INVESTMENT_COMPANY_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
COMPANY_SERIES_CLASS_ID	Unique identifier that combines the CIK (identifier for investment fund), series, and class.	VARCHAR	a97cc0b1c7d804f551a90de6c4ace50b
REPORTING_FILE_NUMBER	SEC-assigned number with an 811- prefix assigned to filers registered under the Investment Company Act of 1940.	VARCHAR	811-01716
CIK	Central Index Key, a unique identifier for corporations registered with the United States Securities and Exchange Commission (SEC).	VARCHAR	0000081443
COMPANY_NAME	The name of the investment company, as entered by the filer.	VARCHAR	AB CAP FUND, INC.
ORGANIZATION_TYPE	Organizational structure of a registran (e.g., open-end mutual fund filer).	VARCHAR	N-1A/Open-end Mutual Fund Filer
SERIES_ID	Unique identifier assigned by the SEC to each series of an investment company; a series represents a distinct portfolio within an investment company - each series has its own set of financial statements and investment objectives. The format is an "S" followed by nine digits.	VARCHAR	S000050223
SERIES_NAME	Name of the investment company series, as entered by the filer (may not correspond to the exact legal name of the series).	VARCHAR	AB International Strategic Core Portfolio
CLASS_ID	Unique identifier assigned by the SEC to each class of a series of an investment company. Within each series, there can be multiple classes of shares. These classes may differ in terms of fee structures, minimum investment amounts, and other characteristics. The format is a "C" followed by nine digits.	VARCHAR	C000158548
CLASS_NAME	Name of the investment company series class.	VARCHAR	Class Z
CLASS_TICKER	The stock market symbol (if any) for a class. An investment company series may include 1+ share classes with differing sales charges and expenses. This is not a required field and will not be available for every registrant.	VARCHAR	CBACX
STREET_ADDRESS	Name and number of the street address of the investment company.	VARCHAR	ALLIANCEBERNSTEIN LP, 1345 AVENUE OF THE AMERICAS
CITY	The city of the investment company.	VARCHAR	NEW YORK
STATE_GEO_ID	A unique identifier for a state, joinable to the GEOGRAPHY_INDEX table, representing the primary geography for the variable.	VARCHAR	geoId/17
ZIP_GEO_ID	A unique identifier for a zip code, joinable to the GEOGRAPHY_INDEX table, representing the primary geography for the variable.	VARCHAR	zip/60606
REPORTED_YEAR	The year the information was reported.	DATE	2015-12-31
FIRST_SEEN	The first seen date of the unique combination of CIK, series, and class.	VARCHAR	2015
LAST_SEEN	The most recent seen date of the unique combination of CIK, series, and class.	VARCHAR	2024