🏥Nation Medical Expenditure - 🩺Medical

Is medical expenditure increasing or decreasing?

@kaggle.yutodennou_nation_medical_expenditure_in_japan

Table List

1 table(15.21 KB)

National Medical Expenditure

@kaggle.yutodennou_nation_medical_expenditure_in_japan.national_medical_expenditure

15.21 KB
67 rows
12 columns

year Year	nationalmedicalexpenditure NationalMedicalExpenditure	nationalmedicalexpenditure_growthrate NationalMedicalExpenditure GrowthRate	nationalmedicalexpenditure_perperson NationalMedicalExpenditure PerPerson	nationalmedicalexpenditure_perperson_growthrate NationalMedicalExpenditure PerPerson GrowthRate	grossdomesticproduct GrossDomesticProduct	grossdomesticproduct_growthrate GrossDomesticProduct GrowthRate	nationalincome NationalIncome	nationalincome_growthrate NationalIncome GrowthRate	ratioof_nationalmedicalexpenditure_pergdp RatioOf NationalMedicalExpenditure PerGDP	ratioof_nationalmedicalexpenditure_pernationalincome RatioOf NationalMedicalExpenditure PerNationalIncome	totalpopulation TotalPopulation
2020	429665	-3.2	340600	-3.2	5355099	-3.9			8.02		126146000
2019	443895	2.3	351800	2.5	5573065	0.2	4006470	-0.4	7.97	11.08	126167000
2018	433949	0.8	343200	1	5563037	0.1	4022687	0.4	7.8	10.79	126443000
2017	430710	2.2	339900	2.4	5557219	2	4005164	2.1	7.75	10.75	126706000
2016	421381	-0.5	332000	-0.4	5448272	0.8	3922939	-0.1	7.73	10.74	126933000
2015	423644	3.8	333300	3.8	5407394	3.3	3926293	4.2	7.83	10.79	127095000
2014	408071	1.9	321100	2	5234183	2.1	3766776	1.1	7.8	10.83	127083000
2013	400610	2.2	314700	2.3	5126856	2.7	3725700	4	7.81	10.75	127298000
2012	392117	1.6	307500	1.9	4994239	-0.1	3581562	0.2	7.85	10.95	127515000
2011	385850	3.1	301900	3.3	5000405	-1	3574735	-2	7.72	10.79	127799000


CREATE TABLE national_medical_expenditure (
  "year" BIGINT,
  "nationalmedicalexpenditure" BIGINT,
  "nationalmedicalexpenditure_growthrate" DOUBLE,
  "nationalmedicalexpenditure_perperson" BIGINT,
  "nationalmedicalexpenditure_perperson_growthrate" DOUBLE,
  "grossdomesticproduct" DOUBLE,
  "grossdomesticproduct_growthrate" DOUBLE,
  "nationalincome" DOUBLE,
  "nationalincome_growthrate" DOUBLE,
  "ratioof_nationalmedicalexpenditure_pergdp" DOUBLE,
  "ratioof_nationalmedicalexpenditure_pernationalincome" DOUBLE,
  "totalpopulation" BIGINT
);