SEC Data 10Q And 10K
SEC data downloaded from the SEC website in bulk
@kaggle.malik1641_sec_data_with_market_cap_added
SEC data downloaded from the SEC website in bulk
@kaggle.malik1641_sec_data_with_market_cap_added
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
);
Anyone who has the link will be able to view this.