Balance Sheet Of Chinese Companies (2006-2022)

Balance Sheet of all Chinese publicly trading companies from year 2006 to 2022

@kaggle.wentinglu_structured_chinese_company_balance_sheet

Table List

2 tables(18.88 MB)

Financial Statement

@kaggle.wentinglu_structured_chinese_company_balance_sheet.financial_statement

18.8 MB
196488 rows
13 columns

announcement_date Announcement Date	ticker Ticker	asset_cash_and_cash_equivalents Asset-Cash And Cash Equivalents	asset_account_receivable Asset-Account Receivable	asset_inventory Asset-inventory	asset_total_asset Asset-total Asset	asset_total_asset_growth_rate Asset-total Asset Growth Rate	liability_account_payable Liability-Account Payable	liability_advance_from_customers Liability-Advance From Customers	liability_total_liability Liability-total Liability	liability_liability_growth_rate Liability-liability Growth Rate	debt_ratio Debt Ratio	total_investors_equity Total Investors Equity
Fri Apr 07 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	sz000989	488181547.46	116138935.05	186162243.28	1341121163.76	1.0472150713	77986432.74	14863133.03	237599437.69	48.167747588	17.7164781312	1103521726.07
Sat Apr 08 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	sz000620	4398211.76	2686288.71	23410946.85	242086973.71	-58.0505186818	36283850.39	23250040.99	653513304.38	36.3220997504	269.9498012491	-411426330.67
Mon Apr 10 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	sz000402	1250995794.73	493278635.44	5080751512.7	8867466711.22	47.5920965137	442405755.27	1117493061.35	6520723951.79	63.9119662724	73.5353643171	2346742759.43
Mon Apr 10 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	sh600561	80898552.31	17863406.17	6230296.46	832783778.01	24.0193949943	36389719.15	7914773.36	417705271.01	38.2316886351	50.1577098449	415078507
Tue Apr 11 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	sz000690	86702207.72	192686189.43	233177938.91	1980865428.35	31.4510677995	18338684.05	37980167.18	1410393862.76	33.8369087084	71.2008924268	570471565.59
Tue Apr 11 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	sh600066	887985280.38	359857346.9	651231571.61	2795152888.43	23.5572321372	635151216.92	174732227.04	1394932310.96	32.9770408725	49.9054029114	1400220577.47
Tue Apr 11 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	sh600211	92120648.95	51849434.96	69332816.04	822004440.86	-0.1888584562	60621839.58	3610465.58	429789095.5	10.5398726247	52.2854955687	392215345.36
Tue Apr 11 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	sh600546	133080966.56	340846095.64	809699323.87	1678865766.09	45.1716593101	431721728.64	512391671.6	1054881968.17	91.6899974137	62.8330143765	623983797.92
Wed Apr 12 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	sh600118	483710369.15	22348377.39	180955036.2	986046168.65	-5.8760286922	23368456.78	452598363.46	579865322.52	-5.3938904362	58.8071168426	406180846.13
Wed Apr 12 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	sz000568	336960652.74	44300347.06	1061638555.5	2591591207.46	2.3367259499	71445604.42	213792267.16	931554224.93	0.4259680257	35.9452610523	1660036982.53


CREATE TABLE financial_statement (
  "announcement_date" TIMESTAMP,
  "ticker" VARCHAR,
  "asset_cash_and_cash_equivalents" DOUBLE,
  "asset_account_receivable" DOUBLE,
  "asset_inventory" DOUBLE,
  "asset_total_asset" DOUBLE,
  "asset_total_asset_growth_rate" DOUBLE,
  "liability_account_payable" DOUBLE,
  "liability_advance_from_customers" DOUBLE,
  "liability_total_liability" DOUBLE,
  "liability_liability_growth_rate" DOUBLE,
  "debt_ratio" DOUBLE,
  "total_investors_equity" DOUBLE
);