| key |
id |
string* |
= |
Unique identifier to represent each company. |
| timeline |
changeDatetime |
dateTime |
=< >= |
Last modification date and time of a physical row in UTC format. |
|
ciqCompanyId |
long(-2147483648,2147483647) |
|
Unique universal identifier assigned to a company. |
| filter_list |
ciqCompanyIdUltimateParent |
long(-2147483648,2147483647) |
= |
CiqcompanyId of the entity’s ultimate parent. |
|
city |
string(100) |
|
Name of City where the company is headquartered. |
| filter_list |
companyName |
string(300) |
= |
Company name. |
|
companyNameUltimateParent |
string(300) |
|
Company Name of the entity's ultimate parent. |
| link |
companyStatusTypeId |
CompanyStatusType |
|
Unique identifier that provides the status of the company (e.g., Operating, Bankrupt, Acquired). |
| link |
companyTypeId |
CompanyType |
|
An identifier that denotes the type of the given company (e.g., Public, Private, Investment Firm, Foundation). |
| link |
countryId |
Country |
|
Unique identifier to represent country where the company is headquartered. |
| link |
countryIdIncorporation |
Country |
|
Unique identifier to represent country of incorporation. |
| link |
countrySubDivisionId |
CountrySubDivision |
|
A unique identifier that identifies a smaller administrative region, such as a state, province, canton, or territory, where the company is headquartered. |
| link |
countrySubDivisionIdIncorporation |
CountrySubDivision |
|
A unique identifier that identifies a smaller administrative region such as a state, province, canton, or territory, where the company is incorporated. |
|
dayFounded |
long(1,31) |
|
Day on which company was founded. |
|
keyInstn |
long(-2147483648,2147483647) |
|
Unique identifier assigned to a company. KeyInstitution (KeyInstn) is a supplementary company identifier to a company which is mapped to ciqcompanyID. |
|
monthFounded |
long(1,12) |
|
Month in which company was founded. |
|
officeFaxValue |
string(30) |
|
Fax number of the headquarters. |
|
officePhoneValue |
string(40) |
|
Main phone number of the headquarters. |
|
otherPhoneValue |
string(40) |
|
Other phone number of the headquarters. |
|
postalCode |
string(50) |
|
Postal code of the headquarters. |
| link |
simpleIndustryId |
SimpleIndustry |
|
Unique identifier to represent industry for a company. |
|
streetAddress |
string(300) |
|
First line of the street address for the headquarters. |
|
streetAddress2 |
string(300) |
|
Second line of the street address for the headquarters. |
|
streetAddress3 |
string(300) |
|
Third line of the street address for the headquarters. |
|
streetAddress4 |
string(300) |
|
Fourth line of the street address for the headquarters. |
| link |
templateTypeId |
TemplateType |
|
Unique identifier for the template type. Defines the template in which a company's financials were collected (e.g. Bank, Industrial, Insurance). |
|
webPage |
string(500) |
|
Website URL of the company. |
|
yearFounded |
long(1000,2099) |
|
Year in which company was founded. |