Enhanced US-GAAP Financial Statement Data Set

Refined US-GAAP Data with Outlier Correction, Amendments, and Missing Figures

@kaggle.vadimvanak_step_2

Table List

2 tables(4.93 MB)

Demo Figures

@kaggle.vadimvanak_step_2.demo_figures

11.12 KB
146 rows
7 columns

adsh Adsh	tag Tag	reported_figure Reported Figure	quarterly_figure Quarterly Figure	reported_figure_py Reported Figure Py	quarterly_figure_py Quarterly Figure Py	is_computed Is Computed
32019324000069	AccountsNotesAndLoansReceivableNetCurrent	21837000000	21837000000			true
32019324000069	AccountsPayableAndAccruedLiabilitiesCurrent	45753000000	45753000000			true
32019324000069	AccountsPayableCurrent	45753000000	45753000000
32019324000069	AccountsReceivableNetCurrent	21837000000	21837000000
32019324000069	AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment	71697000000	71697000000
32019324000069	AccumulatedOtherComprehensiveIncomeLossNetOfTax	-8960000000	-8960000000
32019324000069	AdjustmentsNoncashItemsToReconcileNetIncomeLossToCashProvidedByUsedInOperatingActivities	9674000000	4818000000	9673000000	4169000000	true
32019324000069	AdjustmentsToReconcileNetIncomeLossToCashProvidedByUsedInOperatingActivities	5033000000	-946000000	8407000000	4400000000	true
32019324000069	AllocatedShareBasedCompensationExpense	5961000000	2964000000	5591000000	2686000000
32019324000069	Assets	337411000000	337411000000


CREATE TABLE demo_figures (
  "adsh" BIGINT,
  "tag" VARCHAR,
  "reported_figure" DOUBLE,
  "quarterly_figure" DOUBLE,
  "reported_figure_py" DOUBLE,
  "quarterly_figure_py" DOUBLE,
  "is_computed" BOOLEAN
);