Guides

Lightcast Companies

Data Dictionary

Column NameSnowflakeBig QueryDatabricksParquetComment
ACME_IDVARCHARSTRINGSTRINGSTRINGLegacy organization ID
ADDRESSVARCHARSTRINGSTRINGSTRINGStreet address for the organization's primary physical address
ADDRESS_ADMIN0_DIVISIONVARCHARSTRINGSTRINGSTRINGNorth American geographic divisions (e.g. New England)
ADDRESS_ADMIN0_REGIONVARCHARSTRINGSTRINGSTRINGNorth American geographic regions (e.g. Northeast)
ADDRESS_CITYVARCHARSTRINGSTRINGSTRINGCity of an organization's primary physical address
ADDRESS_POSTALCODEVARCHARSTRINGSTRINGSTRINGPostal/zip code of an organization's primary physical address
ADDRESS_REGION_CODEVARCHARSTRINGSTRINGSTRINGInternational ISO 3-digit geographic code for geographic region containing the organization's primary physical address
ADDRESS_REGION_NAMEVARCHARSTRINGSTRINGSTRINGInternational ISO geographic name (e.g. Europe) for geographic region containing the organization's primary physical address
ADDRESS_SUBREGION_CODEVARCHARSTRINGSTRINGSTRINGInternational ISO geographic subregion codes for geographic region containing the organization's primary physical address
ADDRESS_SUBREGION_NAMEVARCHARSTRINGSTRINGSTRINGInternational ISO geographic subregion name (e.g. Eastern Europe) for geographic region containing the organization's primary physical address
ANZSICVARCHARSTRINGSTRINGSTRINGAustralian and New Zealand Standard Industrial Classification (ANZSIC) 2006 (Revision 2.0), 4-digit code
CIK_CODEVARCHARSTRINGSTRINGSTRINGCompany 10-digit CIK (Central Index Key)
COMPANY_DESCRIPTIONVARCHARSTRINGSTRINGSTRINGDescription of company activities
COMPANY_EMAILVARCHARSTRINGSTRINGSTRINGCompany main information email
COMPANY_IDVARCHARSTRINGSTRINGSTRINGLife to death unique record identifier
COMPANY_NAMEVARCHARSTRINGSTRINGSTRINGCommonly used or trade style name of organization
COMPANY_NAME_ALTERNATEVARCHARSTRINGSTRINGSTRINGAlternate company name such as different spellings
COMPANY_OPERATING_STATUSVARCHARSTRINGSTRINGSTRINGActive or inactive
COMPANY_PHONEVARCHARSTRINGSTRINGSTRINGOrganization's primary phone number
COMPANY_PREVIOUS_NAMEVARCHARSTRINGSTRINGSTRINGPrevious name of company
COMPANY_REGISTERED_NAMEVARCHARSTRINGSTRINGSTRINGLegal/registered business name
COMPLETENESS_SCOREFLOATFLOATDOUBLEFLOATPercentage score indicating the completeness of key firmographic fields
CREATED_DATEDATEDATEDATEDATEDate the organization record was created
CUSIPVARCHARSTRINGSTRINGSTRINGCompany 9-character alphanumeric identifier for financial securities (stocks, bonds, etc.) in the U.S. and Canada
DOMAINVARCHARSTRINGSTRINGSTRINGDomain of the organization
GLOBAL_HEADCOUNTNUMBERBIGNUMERICDECIMALDECIMALOrganization's total worldwide employees
GLOBAL_HEADCOUNT_RANGEVARCHARSTRINGSTRINGSTRINGRange of the organization's total worldwide employees
GLOBAL_REVENUENUMBERBIGNUMERICDECIMALDECIMALOrganization's annual global revenue in U.S. dollars
GLOBAL_REVENUE_RANGEVARCHARSTRINGSTRINGSTRINGRange of the organization's annual global revenue in U.S. dollars
HOLDING_IDVARCHARSTRINGSTRINGSTRINGUnique identifier of holding parent company
IMMEDIATE_PARENT_COUNTRYVARCHARSTRINGSTRINGSTRINGCountry of the immediate parent organization's primary physical location
IMMEDIATE_PARENT_IDVARCHARSTRINGSTRINGSTRINGUnique identifier of the immediate parent organization
IMMEDIATE_PARENT_NAMEVARCHARSTRINGSTRINGSTRINGName of the immediate parent organization
IPEDS_IDVARCHARSTRINGSTRINGSTRINGUnique identifier assigned by the US National Center for Education Statistics (NCES)
IS_BRANDBOOLEANBOOLEANBOOLEANBOOLEANIs brand or trademark record of another entity
IS_EDUCATIONBOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the organization is an educational institution
IS_EXPORTERBOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the organization is a goods or service international exporter
IS_FORTUNE100BOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the company is part of the current Fortune 100
IS_FORTUNE1000BOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the company is part of the current Fortune 1000
IS_FORTUNE500BOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the company is part of the current Fortune 500
IS_FRANCHISEBOOLEANBOOLEANBOOLEANBOOLEANIndicates whether a company belongs to a franchise
IS_GOVERNMENTBOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the organization is a government organization
IS_IMPORTERBOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the organization is a goods or service international importer
IS_JOB_BOARDBOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the organization is a job board
IS_LATEST_VERSIONBOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the record is from the latest database release
IS_NON_PROFITBOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the organization is a non-profit entity
IS_PUBLICLY_TRADEDBOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the organization is a publicly traded company
IS_STAFFINGBOOLEANBOOLEANBOOLEANBOOLEANIndicates whether the organization is a staffing/recruitment company
LAA_ADMIN_AREA_1VARCHARSTRINGSTRINGSTRINGState/Province/Region code of the organization's primary physical address (e.g. US06) based on the global Lightcast Administrative Area framework
LAA_ADMIN_AREA_1_NAMEVARCHARSTRINGSTRINGSTRINGState/Province/Region name of the organization's primary physical address (e.g. California) based on the global Lightcast Administrative Area framework
LAA_ADMIN_AREA_2VARCHARSTRINGSTRINGSTRINGSub-national Level 2 geographic identifier code (e.g., County level in the US) based on the global Lightcast Administrative Area framework
LAA_ADMIN_AREA_2_NAMEVARCHARSTRINGSTRINGSTRINGSub-national Level 2 geographic identifier name (e.g., County level in the US) based on the global Lightcast Administrative Area framework
LAA_COUNTRYVARCHARSTRINGSTRINGSTRING2-digit country code of the organization's primary address (e.g. US) based on the global Lightcast Administrative Area framework
LAA_COUNTRY_NAMEVARCHARSTRINGSTRINGSTRINGCountry name of the organization's primary address (e.g. United States) based on the global Lightcast Administrative Area framework
LAA_METROVARCHARSTRINGSTRINGSTRINGMetropolitan Area code based on the global Lightcast Administrative Area framework
LAA_METRO_NAMEVARCHARSTRINGSTRINGSTRINGMetropolitan Area name based on the global Lightcast Administrative Area framework
LAST_UPDATE_DATEDATEDATEDATEDATEDate when a record was last changed in any field
LATITUDEFLOATFLOATDOUBLEFLOATLatitude of the organization's primary address
LINKEDIN_URLVARCHARSTRINGSTRINGSTRINGOrganization's LinkedIn profile URL
LONGITUDEFLOATFLOATDOUBLEFLOATLongitude of the organization's primary address
NACE_REV2VARCHARSTRINGSTRINGSTRINGStatistical Classification of Economic Activities in the European Community (NACE Rev. 2) code
NAICS_2VARCHARSTRINGSTRINGSTRINGNorth American Industry Classification System (NAICS) 2022, 2-digit code
NAICS_3VARCHARSTRINGSTRINGSTRINGNorth American Industry Classification System (NAICS) 2022, 3-digit code
NAICS_6VARCHARSTRINGSTRINGSTRINGPrimary North American Industry Classification System (NAICS) 2022, 6-digit code
NAICS_6_2017VARCHARSTRINGSTRINGSTRINGNorth American Industry Classification System (NAICS) 2017, 6-digit code
NAICS_6_DESCRIPTIONVARCHARSTRINGSTRINGSTRINGOfficial title of NAICS code in most recent classification version
NAICS_6_SECONDARYVARCHARSTRINGSTRINGSTRINGSecondary North American Industry Classification System (NAICS) 2022, 6-digit code
NAICS_6_SECONDARY_DESCRIPTIONVARCHARSTRINGSTRINGSTRINGOfficial title of NAICS code in most recent classification version
NAICS_6_TERTIARYVARCHARSTRINGSTRINGSTRINGTertiary North American Industry Classification System (NAICS) 2022, 6-digit code
NAICS_6_TERTIARY_DESCRIPTIONVARCHARSTRINGSTRINGSTRINGOfficial title of NAICS code in most recent classification version
NATIONAL_BUSINESS_IDVARCHARSTRINGSTRINGSTRINGNational business registration number
NUMBER_OF_OFFICESNUMBERBIGNUMERICDECIMALDECIMALNumber of locations underneath the company including itself
ROLEVARCHARSTRINGSTRINGSTRINGHierarchy type (holding, headquarters, subsidiary, branch, standalone)
SIC87_4DVARCHARSTRINGSTRINGSTRINGStandard Industrial Classification (SIC) 1987, 4-digit industry code
SSIC2015VARCHARSTRINGSTRINGSTRINGSingapore Standard Industrial Classification (SSIC) 2015, 5-digit code
SSIC2020VARCHARSTRINGSTRINGSTRINGSingapore Standard Industrial Classification (SSIC) 2020, 5-digit code
STOCK_EXCHANGEVARCHARSTRINGSTRINGSTRINGPrimary stock exchange on which the organization's shares are traded
TICKER_SYMBOLVARCHARSTRINGSTRINGSTRINGOrganization's primary stock ticker symbol
TWITTERVARCHARSTRINGSTRINGSTRINGOrganization's primary X (formerly Twitter) profile URL
UK_SIC_1VARCHARSTRINGSTRINGSTRINGUK Standard Industrial Classification (SIC) 2007, 1-digit section code
UK_SIC_2VARCHARSTRINGSTRINGSTRINGUK Standard Industrial Classification (SIC) 2007, 2-digit division code
UK_SIC_5VARCHARSTRINGSTRINGSTRINGUK Standard Industrial Classification of Economic Activities (SIC) 2007, 5-digit code
ULTIMATE_PARENT_COUNTRYVARCHARSTRINGSTRINGSTRINGCountry of phsyical location of ultimate parent organization
ULTIMATE_PARENT_IDVARCHARSTRINGSTRINGSTRINGUnique ID of ultimate parent record
ULTIMATE_PARENT_NAMEVARCHARSTRINGSTRINGSTRINGName of ultimate parent organization
VERSIONVARCHARSTRINGSTRINGSTRINGIndicates whether the record belongs to the latest database version
WEBSITEVARCHARSTRINGSTRINGSTRINGOrganization's primary website URL
YEAR_FOUNDEDNUMBERBIGNUMERICDECIMALDECIMALYear the organization was founded

Updated about 4 hours ago

Did this page help you?