Dataset Name: new_constructs_core_earnings_v3
Group: financials
Vendor: New Constructs
Data Starts at: 1999-12-01 00:00:00
Symbol Set: US Equities
Asset Class: Equity
Data Update Time(s): 7:05 AM EST
Data Update Frequency: day
New Constructs Core Earnings Reports - Version 3
Data Contained in this Dataset
| Column | Type | Description |
|---|---|---|
| _seq | uint | Internal sequence number used to keep data rows in order |
| timestamp | string | Timestamp of the Data - America/New York Time. |
| muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. (underlying field is nc_publish_date_actual) |
| symbol | string | Trading Symbol or Ticker |
| ticker_current | string | The current ticker symbol |
| company_name_current | string | The current company name |
| cik_current | string | Central Index Key |
| stock_exchange_current | string | stock_exchange_current |
| market_identifier_code_current | string | Current Market Identifier Code |
| company_status_current | string | Company Status (Current) |
| company_name_on_event_date | string | Company Name On Event (Date) |
| cik_on_event_date | string | Central Index Key at the given point in time |
| stock_exchange_on_event_date | string | Stock exchange at the given timestamp |
| market_identifier_code_on_event_date | string | Market Identifier Code (MIC) at the given timestamp |
| figi | string | FIGI ID. The FIGI code (https://www.openfigi.com) that identifies the stock across related exchanges in the same country. |
| perm_id | string | PermID.org value for this company. Helpful for ticker changes or multiple ticker companies. |
| lei | string | Legal Entity Identifier |
| fiscal_year | string | Fiscal year (ie 2017 2018 2019 2020 2021) |
| fiscal_quarter | string | Fiscal Quarter |
| filing_type | string | Filing Type |
| period_type | string | Period Type |
| period_end_date | string | Period End Date |
| filing_date | string | Filing Date |
| event_date | string | Event Date |
| event_type | string | Event Type |
| event_description | string | Event Description |
| event_record_effect | string | Event Record Effect |
| record_checksum | string | Record Checksum |
| receipt_date_implied_by_event | string | Receipt date implied by event |
| nc_publish_date_implied_by_event | string | NC publish date implied by event |
| receipt_date_actual | string | Receipt date actual |
| nc_publish_date_actual_check | string | Nc publish date actual check |
| data_generation_date | string | Data generation date |
| income_net | double | Income net |
| core_earnings_after_tax | double | core_earnings_after_tax |
| earnings_distortion_total | double | Earnings distortion total |
| earnings_distortion_hidden | double | earnings_distortion_hidden |
| earnings_distortion_reported_pre_tax | double | Earnings distortion reported pre tax |
| earnings_distortion_reported_after_tax | double | Earnings distortion reported after tax |
| tax_distortion | double | Tax distortion |
| earnings_distortion_expenses_foreign_currency | double | Earnings distortion expenses foreign currency |
| earnings_distortion_total_per_assets | double | Earnings distortion total per assets |