| key |
id |
string(20)* |
= |
Unique identifier to represent each eventid. |
| timeline |
lastUpdated |
dateTime |
=< >= |
The date and time the last data modification took place. |
|
additionalInformation |
string(5000) |
|
The comment providing additional information related to the event. |
| filter_list |
ciqCompanyId |
long(-2147483648,2147483647) |
= |
Unique identifier used to distinctly recognize each target company, ensuring distinct identification and traceability within the dataset. |
| link |
ciqPrimaryIndustry |
CiqPrimaryIndustry |
|
Information related to primary industry assigned in CIQ database to the target company. |
| filter_list |
companyNameTarget |
string(200) |
= |
Company name of the target company. |
|
companyStatus |
CompanyStatus |
|
Companytype during the lifecycle of the event. Example: operating, reorganizing, acquired. |
|
companyType |
CompanyType |
|
Companytype during the lifecycle of the event. Example: public, private, investment firm, . |
| filter_list |
countryCode |
string(2) |
= |
ISO code (iso3166a2) for country where the company is headquartered. |
|
currencyISOCode |
string(3) |
|
A unique identifier used to specify the currency associated with a event, facilitating precise financial reporting. |
|
endDate |
date |
|
End date for entity is the actual end date of the alternatename, provided by the vendor. This will be help to mention that it is historical and no longer active. |
| filter_list |
eventAnnouncedDate |
string(15) |
=< >= |
Provides the most precise announcement date based on available information. This may include just the year of the announcement, the month, or even the day, as known. |
|
eventAnnouncedMonth |
long(1,12) |
|
The month number when the event details are publicly disclosed. |
| filter_list |
eventAnnouncedYear |
long(1900,2300) |
=< >= |
The year when the event details are publicly disclosed. |
| filter_list |
eventClosingDate |
string(15) |
=< >= |
The date when the event is completed. This may include just the year of the announcement, the month, or even the day, as known. |
|
eventClosingMonth |
long(1,12) |
|
The month when the events is completed. |
| filter_list |
eventClosingYear |
long(1900,2300) |
=< >= |
The year when the event is completed. |
| filter_list |
eventExpectedClosingDate |
string(15) |
=< >= |
The anticipated date by which the event is expected to be completed.This may include just the year of the announcement, the month, or even the day, as known. |
|
eventExpectedClosingMonth |
long(1,12) |
|
The anticipated month number by which the event is expected to be completed. |
|
eventExpectedClosingYear |
long(1900,2300) |
|
The year by which the event is expected to be completed. |
|
eventId |
string(20) |
|
Unique universal identifier assigned to a event. |
|
eventInvestmentValue |
decimal{15,6} |
|
The value that represents the total investment as a part of the event. [Magnitude: $M] |
| link |
eventPrimaryFeature |
EventPrimaryFeature |
= |
The descriptive name for event's primary feature such as acquisition of equity stake, buyback of debt securities, ipo, venture capital, and more, to categorize events characteristics. |
| link |
eventStatus |
EventStatus |
= |
The current status of the event. Example : announced, closed, cancelled etc. |
|
eventSummary |
string(10000) |
|
The comprehensive comment summarizing the entire event, including all details from the announcement stage to the most recent update. |
| link |
eventType |
EventType |
= |
Information related to the type of event captured for a given eventid. example merger/ipo/namechange. |
| link |
miPrimaryIndustry |
MIPrimaryIndustry |
|
Industry classification as per MI for the target company like chemicals, construction materials, metals and mining etc. |
|
previousName |
string(100) |
|
Stores the alternate historical name of the entity in english language. |
|
startDate |
date |
|
Start date for entity is the actual start date of the alternatename, provided by the vendor. |