Dataset Name: new_constructs_core_earnings_reconciliation
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
Detailed Core Earnings & Earnings Distortion Reconciliation - Proprietary footnotes data on unusual gain/losses that distort consensus earnings and all reported measures of profits.
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. |
| symbol | string | Trading Symbol or Ticker |
| company_name | string | The Company’s Name. May be formal/legal name or some derivative of the company's name. |
| cik | string | Central Index Key |
| figi | string | FIGI ID. The FIGI code (https://www.openfigi.com) that identifies the stock across related exchanges in the same country. |
| stock_exchange | string | Listing Exchange |
| company_status_current | string | company_status_current |
| fiscal_year | uint | Fiscal year (ie 2017 2018 2019 2020 2021) |
| fiscal_quarter | string | The company's fiscal quarter |
| filing_type | string | Filing Type |
| filing_date | string | Filing Date |
| period_end_date | string | period_end_date |
| update_reason | string | update_reason |
| data_generation_date | string | Date the row of data was generated |
| 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_hidden_all_restructuring | double | earnings_distortion_hidden_all_restructuring |
| earnings_distortion_hidden_foreign_currency_pre_tax_total | double | earnings_distortion_hidden_foreign_currency_pre_tax_total |
| earnings_distortion_hidden_oreo_pre_tax_total | double | earnings_distortion_hidden_oreo_pre_tax_total |
| earnings_distortion_hidden_acquisition_merger_pre_tax_total | double | earnings_distortion_hidden_acquisition_merger_pre_tax_total |
| earnings_distortion_hidden_legal_reg_insurance_pre_tax_total | double | earnings_distortion_hidden_legal_reg_insurance_pre_tax_total |
| earnings_distortion_hidden_derivative_pre_tax_total | double | earnings_distortion_hidden_derivative_pre_tax_total |
| earnings_distortion_hidden_other_financing_pre_tax_total | double | earnings_distortion_hidden_other_financing_pre_tax_total |
| earnings_distortion_hidden_other_non_recurring_pre_tax_total | double | earnings_distortion_hidden_other_non_recurring_pre_tax_total |
| earnings_distortion_hidden_pension_non_recurring | double | earnings_distortion_hidden_pension_non_recurring |
| earnings_distortion_hidden_comp_defined_other_pre_tax_total | double | earnings_distortion_hidden_comp_defined_other_pre_tax_total |
| earnings_distortion_eso_expense | double | earnings_distortion_eso_expense |
| earnings_distortion_reported_pre_tax | double | earnings_distortion_reported_pre_tax |
| earnings_distortion_expenses_derivative | double | earnings_distortion_expenses_derivative |
| earnings_distortion_expenses_other_financing | double | earnings_distortion_expenses_other_financing |
| earnings_distortion_expenses_company_defined_other | double | earnings_distortion_expenses_company_defined_other |
| earnings_distortion_expenses_acquisition_merger | double | earnings_distortion_expenses_acquisition_merger |
| earnings_distortion_expenses_legal_regulatory_insurance | double | earnings_distortion_expenses_legal_regulatory_insurance |
| earnings_distortion_expenses_discontinued_operations | double | earnings_distortion_expenses_discontinued_operations |
| earnings_distortion_expenses_foreign_currency | double | earnings_distortion_expenses_foreign_currency |
| earnings_distortion_expenses_oreo | double | earnings_distortion_expenses_oreo |
| earnings_distortion_expenses_other | double | earnings_distortion_expenses_other |
| earnings_distortion_expenses_non_recurring_write_down | double | earnings_distortion_expenses_non_recurring_write_down |
| earnings_distortion_expenses_non_recurring_restructuring | double | earnings_distortion_expenses_non_recurring_restructuring |
| earnings_distortion_expenses_non_recurring_other | double | earnings_distortion_expenses_non_recurring_other |
| contra_earnings_distortion_npbc_recurring_other_in_non_op | double | contra_earnings_distortion_npbc_recurring_other_in_non_op |
| tax_distortion | double | tax_distortion |
| earnings_distortion_reported_after_tax | double | earnings_distortion_reported_after_tax |
| earnings_distortion_charge_after_tax_discontinued_operations | double | earnings_distortion_charge_after_tax_discontinued_operations |
| earnings_distortion_charges_after_tax_other | double | earnings_distortion_charges_after_tax_other |
| income_net | double | income_net |
| wadso_split_adjusted | double | wadso_split_adjusted |
| earnings_distortion_total_per_wadso_split_adjusted | double | earnings_distortion_total_per_wadso_split_adjusted |
| assets_unadjusted | double | assets_unadjusted |
| earnings_distortion_total_per_assets | double | earnings_distortion_total_per_assets |
| revenue | double | Company Revenue |
| earnings_distortion_total_per_revenue | double | earnings_distortion_total_per_revenue |
| earnings_distortion_total_per_income_net | double | earnings_distortion_total_per_income_net |
| cash_tax_rate | double | cash_tax_rate |