SEC Data 10Q And 10K

SEC data downloaded from the SEC website in bulk

@kaggle.malik1641_sec_data_with_market_cap_added

Table List

1 table(824.07 KB)

A

@kaggle.malik1641_sec_data_with_market_cap_added.a

824.07 KB
64 rows
762 columns
Only the first 100 columns are shown

unnamed_0 Unnamed: 0	accountspayablecurrent_usd AccountsPayableCurrent - USD	accountsreceivablenetcurrent_usd AccountsReceivableNetCurrent - USD	accrualforenvironmentallosscontingencies_usd AccrualForEnvironmentalLossContingencies - USD	accrualforenvironmentallosscontingenciesdiscountrate_pure AccrualForEnvironmentalLossContingenciesDiscountRate - Pure	accrualforenvironmentallosscontingenciesgross_usd AccrualForEnvironmentalLossContingenciesGross - USD	accruedemployeebenefitscurrentandnoncurrent_usd AccruedEmployeeBenefitsCurrentAndNoncurrent - USD	accruedincometaxescurrent_usd AccruedIncomeTaxesCurrent - USD	accumulateddepreciationdepletionandamortizationpropert_4c10e814 AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment - USD	accumulatedothercomprehensiveincomelossforeigncurrency_b959c6aa AccumulatedOtherComprehensiveIncomeLossForeignCurrencyTranslationAdjustmentNetOfTax - USD	accumulatedothercomprehensiveincomelossnetoftax_usd AccumulatedOtherComprehensiveIncomeLossNetOfTax - USD	acquiredfinitelivedintangibleassetamount_usd AcquiredFiniteLivedIntangibleAssetAmount - USD	additionalpaidincapital_usd AdditionalPaidInCapital - USD	adjustmentsnoncashitemstoreconcilenetincomelosstocashp_3400682a AdjustmentsNoncashItemsToReconcileNetIncomeLossToCashProvidedByUsedInOperatingActivitiesOther - USD	adjustmentstoadditionalpaidincapitalsharebasedcompensa_6628af28 AdjustmentsToAdditionalPaidInCapitalSharebasedCompensationRequisiteServicePeriodRecognitionValue - USD	advertisingexpense_usd AdvertisingExpense - USD	allocatedsharebasedcompensationexpense_usd AllocatedShareBasedCompensationExpense - USD	amortizationofintangibleassets_usd AmortizationOfIntangibleAssets - USD	antidilutivesecuritiesexcludedfromcomputationofearning_a26634b0 AntidilutiveSecuritiesExcludedFromComputationOfEarningsPerShareAmount - Shares	assetimpairmentcharges_usd AssetImpairmentCharges - USD	assets_usd Assets - USD	assetscurrent_usd AssetsCurrent - USD	availableforsalesecurities_usd AvailableForSaleSecurities - USD	availableforsalesecuritiesamortizedcost_usd AvailableForSaleSecuritiesAmortizedCost - USD	availableforsalesecuritiesgrossunrealizedgains_usd AvailableForSaleSecuritiesGrossUnrealizedGains - USD	availableforsalesecuritiesnoncurrent_usd AvailableForSaleSecuritiesNoncurrent - USD	buildingsandimprovementsgross_usd BuildingsAndImprovementsGross - USD	businessacquisitioncostofacquiredentitypurchaseprice_usd BusinessAcquisitionCostOfAcquiredEntityPurchasePrice - USD	businessacquisitionproformaearningspersharebasic_usd_shares BusinessAcquisitionProFormaEarningsPerShareBasic - USD/shares	businessacquisitionproformaearningspersharediluted_usd_shares BusinessAcquisitionProFormaEarningsPerShareDiluted - USD/shares	businessacquisitionproformanetincomeloss_usd BusinessAcquisitionProFormaNetIncomeLoss - USD	businessacquisitionproformarevenue_usd BusinessAcquisitionProFormaRevenue - USD	businessacquisitionpurchasepriceallocationamortizablei_cb2e934d BusinessAcquisitionPurchasePriceAllocationAmortizableIntangibleAssets - USD	businessacquisitionpurchasepriceallocationdeferredinco_da4926e0 BusinessAcquisitionPurchasePriceAllocationDeferredIncomeTaxesAssetLiabilityNet - USD	businesscombinationacquisitionrelatedcosts_usd BusinessCombinationAcquisitionRelatedCosts - USD	cashandcashequivalentsatcarryingvalue_usd CashAndCashEquivalentsAtCarryingValue - USD	cashandcashequivalentsperiodincreasedecrease_usd CashAndCashEquivalentsPeriodIncreaseDecrease - USD	commonstockparorstatedvaluepershare_usd_shares CommonStockParOrStatedValuePerShare - USD/shares	commonstocksharesauthorized_shares CommonStockSharesAuthorized - Shares	commonstocksharesissued_shares CommonStockSharesIssued - Shares	commonstockvalue_usd CommonStockValue - USD	comprehensiveincomenetoftax_usd ComprehensiveIncomeNetOfTax - USD	costmethodinvestmentsaggregatecarryingamount_usd CostMethodInvestmentsAggregateCarryingAmount - USD	costofgoodssold_usd CostOfGoodsSold - USD	costofrevenue_usd CostOfRevenue - USD	costsandexpenses_usd CostsAndExpenses - USD	cumulativeeffectofinitialadoptionoffin48_usd CumulativeEffectOfInitialAdoptionOfFIN48 - USD	cumulativeeffectofinitialadoptionofsfas158_usd CumulativeEffectOfInitialAdoptionOfSFAS158 - USD	currentfederaltaxexpensebenefit_usd CurrentFederalTaxExpenseBenefit - USD	currentforeigntaxexpensebenefit_usd CurrentForeignTaxExpenseBenefit - USD	currentstateandlocaltaxexpensebenefit_usd CurrentStateAndLocalTaxExpenseBenefit - USD	debtinstrumentcarryingamount_usd DebtInstrumentCarryingAmount - USD
Mon Oct 05 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	250000000	544000000					38000000			-141000000		7516000000	-1000000						37000000	6573000000	2897000000														1479000000	74000000	0.01	2000000000	565000000	6000000			395000000	518000000
Mon Dec 21 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	307000000	595000000					26000000			-185000000		7552000000	2000000	71000000						7612000000	3961000000														2479000000	1074000000				6000000	-38000000		1692000000	2189000000		-74000000	127000000
Tue Sep 07 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	307000000	595000000					26000000			-185000000		7552000000	2000000	71000000						7612000000	3961000000														2479000000	1074000000				6000000	-38000000		1692000000	2189000000		-74000000	127000000
Wed Mar 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	315000000	628000000								-201000000		7673000000							19000000	7574000000	5519000000														2481000000	2000000	0.01	2000000000	571000000	6000000			421000000	553000000
Mon Jun 07 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	362000000	669000000								-239000000		7802000000							20000000	7767000000	5712000000														2646000000	167000000	0.01	2000000000	576000000	6000000			431000000	560000000	1117000000
Wed Oct 06 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	459000000	790000000								-225000000	399000000	7855000000				13000000	27000000	11000000	20000000	9100000000	5735000000						1507000000	0.71	0.7	248000000	1413000000	419000000	138000000	50000000	2317000000	-162000000	0.01	2000000000	577000000	6000000	219000000		527000000	659000000	1269000000						2177000000
Mon Dec 20 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	499000000	869000000	5000000	0.04	5000000	142000000		1595000000	460000000	-88000000	397000000	7904000000		64000000	45000000		76000000	11000000	7000000	9696000000	6169000000	10000000	4000000	6000000	10000000	1268000000	1507000000	1.87	1.84	648000000	5871000000	417000000	138000000	102000000	2649000000	170000000	0.01	2000000000	579000000	6000000	781000000	80000000	1976000000	2514000000	4878000000	-74000000		-40000000	145000000	12000000	2190000000
Wed Mar 09 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	444000000	854000000								-63000000		8060000000	2000000			28000000	28000000	27000		8044000000	4598000000						1507000000	0.35	0.35	123000000	1743000000			-15000000	2638000000	-11000000	0.01	2000000000	584000000	6000000	218000000		557000000	703000000	1308000000						2138000000
Tue Jun 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	486000000	918000000								278000000		8140000000	4000000			16000000	28000000		5000000	8649000000	5096000000						1507000000	0.25	0.24	87000000	1476000000			13000000	2975000000	326000000	0.01	2000000000	587000000	6000000	541000000		622000000	777000000	1411000000						2144000000
Wed Sep 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	470000000	917000000								271000000		8248000000	9000000			16000000	29000000	11000000		8753000000	5223000000						1507000000	0.71	0.7	248000000	1413000000			11000000	3101000000	452000000	0.01	2000000000	590000000	6000000	323000000		643000000	799000000	1410000000						2168000000


CREATE TABLE a (
  "unnamed_0" TIMESTAMP,
  "accountspayablecurrent_usd" BIGINT,
  "accountsreceivablenetcurrent_usd" BIGINT,
  "accrualforenvironmentallosscontingencies_usd" DOUBLE,
  "accrualforenvironmentallosscontingenciesdiscountrate_pure" DOUBLE,
  "accrualforenvironmentallosscontingenciesgross_usd" DOUBLE,
  "accruedemployeebenefitscurrentandnoncurrent_usd" DOUBLE,
  "accruedincometaxescurrent_usd" DOUBLE,
  "accruedincometaxesnoncurrent_usd" DOUBLE,
  "accumulateddepreciationdepletionandamortizationpropert_4c10e814" DOUBLE,
  "accumulatedothercomprehensiveincomelossavailableforsal_ec2fd3e7" DOUBLE,
  "accumulatedothercomprehensiveincomelosscumulativechang_cdfe125e" DOUBLE,
  "accumulatedothercomprehensiveincomelossdefinedbenefitp_5cc78673" DOUBLE,
  "accumulatedothercomprehensiveincomelossforeigncurrency_b959c6aa" DOUBLE,
  "accumulatedothercomprehensiveincomelossnetoftax_usd" BIGINT,
  "acquiredfinitelivedintangibleassetamount_usd" DOUBLE,
  "additionalpaidincapital_usd" BIGINT,
  "adjustmentforamortization_usd" DOUBLE,
  "adjustmentsnoncashitemstoreconcilenetincomelosstocashp_3400682a" DOUBLE,
  "adjustmentstoadditionalpaidincapitalother_usd" DOUBLE,
  "adjustmentstoadditionalpaidincapitalsharebasedcompensa_6628af28" DOUBLE,
  "adjustmentstoadditionalpaidincapitaltaxeffectfromshare_8123d051" DOUBLE,
  "adjustmenttoadditionalpaidincapitalincometaxeffectfrom_fd203483" DOUBLE,
  "advertisingexpense_usd" DOUBLE,
  "allocatedsharebasedcompensationexpense_usd" DOUBLE,
  "allowancefordoubtfulaccountsreceivablewriteoffs_usd" DOUBLE,
  "amortizationofintangibleassets_usd" DOUBLE,
  "antidilutivesecuritiesexcludedfromcomputationofearning_a26634b0" DOUBLE,
  "aocilosscashflowhedgecumulativegainlossaftertax_usd" DOUBLE,
  "assetimpairmentcharges_usd" DOUBLE,
  "assets_usd" BIGINT,
  "assetscurrent_usd" BIGINT,
  "assetsfairvaluedisclosure_usd" DOUBLE,
  "assetsfairvaluedisclosurenonrecurring_usd" DOUBLE,
  "assetsofdisposalgroupincludingdiscontinuedoperation_usd" DOUBLE,
  "assetsofdisposalgroupincludingdiscontinuedoperationcurrent_usd" DOUBLE,
  "availableforsalesecurities_usd" DOUBLE,
  "availableforsalesecuritiesamortizedcost_usd" DOUBLE,
  "availableforsalesecuritiesgrossunrealizedgains_usd" DOUBLE,
  "availableforsalesecuritiesgrossunrealizedloss_usd" DOUBLE,
  "availableforsalesecuritiesgrossunrealizedlosses1_usd" DOUBLE,
  "availableforsalesecuritiesnoncurrent_usd" DOUBLE,
  "availableforsalesecuritiesgrossunrealizedgain_usd" DOUBLE,
  "bankacceptancesexecuted_usd" DOUBLE,
  "buildingsandimprovementsgross_usd" DOUBLE,
  "businessacquisitioncostofacquiredentitypurchaseprice_usd" DOUBLE,
  "businessacquisitionproformaearningspersharebasic_usd_shares" DOUBLE,
  "businessacquisitionproformaearningspersharediluted_usd_shares" DOUBLE,
  "businessacquisitionproformanetincomeloss_usd" DOUBLE,
  "businessacquisitionproformarevenue_usd" DOUBLE,
  "businessacquisitionpurchasepriceallocationamortizablei_cb2e934d" DOUBLE,
  "businessacquisitionpurchasepriceallocationdeferredinco_da4926e0" DOUBLE,
  "businessacquisitionsproformanetincomeloss_usd" DOUBLE,
  "businessacquisitionsproformarevenue_usd" DOUBLE,
  "businesscombinationacquisitionrelatedcosts_usd" DOUBLE,
  "businesscombinationconsiderationtransferred1_usd" DOUBLE,
  "businesscombinationcontingentconsiderationarrangements_93518735" DOUBLE,
  "businesscombinationstepacquisitionequityinterestinacqu_8b050e4f" DOUBLE,
  "businesscombinationstepacquisitionequityinterestinacqu_f40ac499" DOUBLE,
  "businessexitcosts1_usd" DOUBLE,
  "capitalizedcomputersoftwaregross_usd" DOUBLE,
  "capitalleaseobligationscurrent_usd" DOUBLE,
  "capitalleaseobligationsnoncurrent_usd" DOUBLE,
  "capitalleasesnetinvestmentindirectfinancingleasesdefer_905db966" DOUBLE,
  "capitalleasesnetinvestmentindirectfinancingleasesiniti_897c0af6" DOUBLE,
  "cashandcashequivalentsatcarryingvalue_usd" BIGINT,
  "cashandcashequivalentsatcarryingvalueincludingdisconti_f6a80d0f" DOUBLE,
  "cashandcashequivalentsperiodincreasedecrease_usd" DOUBLE,
  "cashcashequivalentsrestrictedcashandrestrictedcashequi_de615e97" DOUBLE,
  "cashcashequivalentsrestrictedcashandrestrictedcashequi_3a682bce" DOUBLE,
  "cashflowhedgegainlosstobereclassifiedwithintwelvemonths_usd" DOUBLE,
  "commitmentsandcontingencies_usd" DOUBLE,
  "commonstockdividendspersharecashpaid_usd_shares" DOUBLE,
  "commonstockdividendspersharedeclared_usd_shares" DOUBLE,
  "commonstockparorstatedvaluepershare_usd_shares" DOUBLE,
  "commonstocksharesauthorized_shares" DOUBLE,
  "commonstocksharesissued_shares" DOUBLE,
  "commonstocksharesoutstanding_shares" DOUBLE,
  "commonstockvalue_usd" BIGINT,
  "comprehensiveincomenetoftax_usd" DOUBLE,
  "comprehensiveincomenetoftaxincludingportionattributabl_74562e8c" DOUBLE,
  "contractwithcustomerassetnet_usd" DOUBLE,
  "contractwithcustomerliability_usd" DOUBLE,
  "contractwithcustomerliabilityincreasedecreaseforcontra_7aa6be6c" DOUBLE,
  "contractwithcustomerliabilityrevenuerecognized_usd" DOUBLE,
  "costmethodinvestments_usd" DOUBLE,
  "costmethodinvestmentsaggregatecarryingamount_usd" DOUBLE,
  "costmethodinvestmentsoriginalcost_usd" DOUBLE,
  "costmethodinvestmentsrealizedgainloss_usd" DOUBLE,
  "costofgoodsandservicessold_usd" DOUBLE,
  "costofgoodssold_usd" DOUBLE,
  "costofrevenue_usd" DOUBLE,
  "costsandexpenses_usd" DOUBLE,
  "cumulativeeffectofinitialadoptionoffin48_usd" DOUBLE,
  "cumulativeeffectofinitialadoptionofsfas158_usd" DOUBLE,
  "cumulativeeffectofnewaccountingprincipleinperiodofadoption_usd" DOUBLE,
  "currentfederaltaxexpensebenefit_usd" DOUBLE,
  "currentforeigntaxexpensebenefit_usd" DOUBLE,
  "currentstateandlocaltaxexpensebenefit_usd" DOUBLE,
  "debtinstrumentcarryingamount_usd" DOUBLE
);