OECD Social Expenditure Database (SOCX)

@owid.social_expenditure

Table List

1 table(1.28 MB)

OECD Social Expenditure Database (SOCX)

@owid.social_expenditure.owid_social_expenditure

1.28 MB
188741 rows
9 columns

country Country	year Year	expenditure_source Expenditure Source	spending_type Spending Type	programme_type_category Programme Type Category	programme_type Programme Type	share_gdp Share Gdp	share_gov_expenditure Share Gov Expenditure	usd_per_person_ppp Usd Per Person Ppp
Australia	1980	Mandatory private and voluntary private	In-cash and in-kind spending	All	Total	1.2209999561309814	3.812000036239624	312.3869934082031
Australia	1980	Mandatory private and voluntary private	In-cash and in-kind spending	Health	Total	1.2209999561309814	3.812000036239624	312.3869934082031
Australia	1980	Mandatory private and voluntary private	In-cash and in-kind spending	Other social policy	Total
Australia	1980	Public	In-cash and in-kind spending	All	Total	10.244000434875488	31.993000030517578	2621.797119140625
Australia	1980	Public	In-cash and in-kind spending	Family	Total	0.9430000185966492	2.944999933242798	241.302001953125
Australia	1980	Public	In-cash and in-kind spending	Health	Total	3.6619999408721924	11.435999870300293	937.1530151367188
Australia	1980	Public	In-cash and in-kind spending	Housing	Total	0.2549999952316284	0.796999990940094	65.30899810791016
Australia	1980	Public	In-cash and in-kind spending	Incapacity related	Total	0.9150000214576721	2.8580000400543213	234.22500610351562
Australia	1980	Public	In-cash and in-kind spending	Old age	Total	3.0989999771118164	9.678000450134277	793.1099853515625
Australia	1980	Public	In-cash and in-kind spending	Old age and survivors	Total	3.6540000438690186	11.41100025177002	935.1640014648438


CREATE TABLE owid_social_expenditure (
  "country" VARCHAR,
  "year" INTEGER,
  "expenditure_source" VARCHAR,
  "spending_type" VARCHAR,
  "programme_type_category" VARCHAR,
  "programme_type" VARCHAR,
  "share_gdp" FLOAT,
  "share_gov_expenditure" FLOAT,
  "usd_per_person_ppp" FLOAT
);