TAXONOMY COMPANY

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
CIK	VARCHAR	STRING	STRING	STRING	The Central Index Key (CIK) is used on the SEC's computer systems to identify corporations and individual people who have filed disclosure with the SEC.
CITY	VARCHAR	STRING	STRING	STRING	The city of the company headquarters.
CUSIP	VARCHAR	STRING	STRING	STRING	A CUSIP is a nine-character numeric or alphanumeric code that identifies North American financial security for the purposes of facilitating clearing and settlement of trades.
EMPLOYEE_COUNT_GROUP	VARCHAR	STRING	STRING	STRING	ID of the global employee count group.
EMPLOYEE_COUNT_GROUP_NAME	VARCHAR	STRING	STRING	STRING	The range of global employee counts that define the employee count group.
FIGI	VARCHAR	STRING	STRING	STRING	The FIGI code belonging to the company.
ID	VARCHAR	STRING	STRING	STRING	ID of the company.
IS_FORTUNE100	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Indicates whether the company is part of the Fortune 100.
IS_FORTUNE1000	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Indicates whether the company is part of the Fortune 1000.
IS_FORTUNE500	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Indicates whether the company is part of the Fortune 500.
IS_GOVERNMENT	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Indicates whether the organization is a government organization.
IS_NON_PROFIT	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Indicates whether the organization is a non-profit organization.
IS_PUBLICLY_TRADED	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Indicates whether the organization is publicly traded.
IS_STAFFING	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Indicates whether the company is a staffing or recruitment agency.
LATEST_VERSION	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Indicates whether the version is the latest Taxonomy version. This is relative to the taxonomy itself. To know the version a dataset is on, please see the dataset meta (for example, GLOBAL.POSTINGS_META).
LINKEDINURL	VARCHAR	STRING	STRING	STRING	LinkdIn URL of the company.
NAICS2	VARCHAR	STRING	STRING	STRING	The 2-digit NAICS of the company.
NAICS6	VARCHAR	STRING	STRING	STRING	The 6-digit NAICS of the company.
NAME	VARCHAR	STRING	STRING	STRING	Name of the company.
POSTAL_CODE	VARCHAR	STRING	STRING	STRING	Postal code of the company.
REVENUE_GROUP	VARCHAR	STRING	STRING	STRING	ID of the annual revenue group.
REVENUE_GROUP_NAME	VARCHAR	STRING	STRING	STRING	The range of annual revenue in US dollars that defines the annual revenue group.
STATE	VARCHAR	STRING	STRING	STRING	The state of the company headquarters if the headquarters is in the US. If the headquarters is not in the US, then the region or province (for example, British Colombia or England).
STOCKEXCHANGE	VARCHAR	STRING	STRING	STRING	Denotes the stock exchange that the company is listed on, where applicable.
TICKERSYMBOL	VARCHAR	STRING	STRING	STRING	Denotes the stock exchange ticker symbol of the company (where applicable).
UK_SIC	VARCHAR	STRING	STRING	STRING	UK SIC of the company.
VERSION	VARCHAR	STRING	STRING	STRING	Taxonomy version.
WEBSITE	VARCHAR	STRING	STRING	STRING	Website of the company.