This sub-textual structure is used to represent when something occurs, including :
- Fully specified dates: This includes data written out January 1st 2019 or abbreviates such as 01/01/2019.
- Partial dates: More generally defined dates, where the day or month has been omitted, such as January 2019 or 2019.
- Date-like-events: These are typically events used to signify when something occurred in place of a specific date. Common examples may include '[since] our founding' or '[until] he retired'. Such events may also be used in conjunction with a more precise date, such as '[since] our founding in 2010').
Key Notes
- Dates are standardized: To help facilitate comparison, as illustrated in the examples below, all dates are standardize, with months such as February converted to the number 1, covering all the formats we come across, such that 1/1/18, 01/01/2018, 01-01-18 all standardize the same. (Given the initial focus on US SEC filings, a US-date ordering is assumed – the ability to change this will be made available as appropriate as our analysis capabilities expanded to other regions).
- Date-like-events likewise standardized For example, the underlying event of the firm-founding is captured the same, regardless of whether written as 'since our founding' or 'since we were founded'.
Specification
Property | Type | Comments |
---|---|---|
YEAR | Integer | Converted into a 4-digit year (e.g., 2018) |
MONTH | Integer | Values between 1 to 12, with 'January' represented as 1 and 'December' as 12 |
DAY | Integer | Values between 1 to 31 |
AROUND | True/Omitted | Around/approximately |
EVENT | Standardized String | Event that occurs on that day. See below for further details. |
Examples
{
"ORIGINAL":"1984",
"YEAR":1984,
}
{
"ORIGINAL":"around September 2006",
"YEAR":2006,
"MONTH":9,
"AROUND":true,
}
{
"ORIGINAL":"10/01/2006",
"YEAR":2006,
"MONTH":10,
"DAY":1,
}
{
"ORIGINAL":"his retirement in 2005",
"YEAR":2005,
"EVENT":"RETIREMENT",
}
{
"ORIGINAL":"our founding in 2010",
"YEAR":2005,
"EVENT":"COMPANY_FOUNDING",
}
Date-Like Events
Value | Common Examples |
---|---|
COMPANY_FOUNDING |
|
MERGER/ACQUISITIONS |
|
DEPARTURE |
|
JOINING_FIRM |
|
IPO |
|
RETIREMENT |
|