US Stocks Fundamentals (XBRL)

Fundamental data for 12,129 companies based on XBRL

@kaggle.usfundamentals_us_stocks_fundamentals

Table List

2 tables(30.09 MB)

Indicators By Company

@kaggle.usfundamentals_us_stocks_fundamentals.indicators_by_company

29.78 MB
1907883 rows
9 columns

company_id Company Id	indicator_id Indicator Id	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015
1000045	AccountsPayableAndAccruedLiabilitiesCurrentAndNoncurrent	6612429	7405579	8924919	7841070	5839000
1000045	AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment		2111343	2242703	2236449	2462000
1000045	AdjustmentForAmortization		-11482251	-13490892	-13852305	-13811000
1000045	Assets	257236034	263835468	283429579	302528591	325309000
1000045	AssetsHeldForSaleAtCarryingValue	1373001	1203664	1696330
1000045	AssetsOfDisposalGroupIncludingDiscontinuedOperation				1746887	2148000
1000045	Cash	2803054	2797716	2635036	3388193	1849000
1000045	CashAndCashEquivalentsAtCarryingValue	2803054	2797716
1000045	CashAndCashEquivalentsPeriodIncreaseDecrease	785514	-5338
1000045	CashPeriodIncreaseDecrease			-162680	753157	-1539000


CREATE TABLE indicators_by_company (
  "company_id" BIGINT,
  "indicator_id" VARCHAR,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE
);