2020 EUSPI Dimension And Component Scores

REGIO-B1-PAPERS@ec.europa.eu

@esifunds.njna_i2dz

Table List

1 table(17.74 KB)

Table 1

@esifunds.njna_i2dz.table_1

17.74 KB
1000 rows
13 columns

country_2_digit_iso Country 2 Digit Iso	country Country	country_appear Country Appear	region_code Region Code	region_name Region Name	nuts_name_short Nuts Name Short	nuts_name Nuts Name	index Index	component Component	code1 Code1	component_code_1 Component Code 1	value Value	national_value National Value
AT	Austria	1	AT	Austria	AT - Austria	AT - Austria	EU_SPI	EU SOCIAL PROGRESS INDEX	1	1. EU SOCIAL PROGRESS INDEX	74	74
AT	Austria	1	AT	Austria	AT - Austria	AT - Austria	BASIC SUB-INDEX	BASIC SUB-INDEX	10	10. BASIC SUB-INDEX	87.9	87.9
AT	Austria	1	AT	Austria	AT - Austria	AT - Austria	FOUNDATION SUB-INDEX	FOUNDATION SUB-INDEX	20	20. FOUNDATION SUB-INDEX	66.7	66.7
AT	Austria	1	AT	Austria	AT - Austria	AT - Austria	OPPORTUNITY SUB-INDEX	OPPORTUNITY SUB-INDEX	30	30. OPPORTUNITY SUB-INDEX	68.3	68.3
AT	Austria	1	AT	Austria	AT - Austria	AT - Austria	BASIC SUB-INDEX	Nutrition and Care	11	11. Nutrition and Care	87.6	87.6
AT	Austria	1	AT	Austria	AT - Austria	AT - Austria	BASIC SUB-INDEX	Water and Sanitation	12	12. Water and Sanitation	96.8	96.8
AT	Austria	1	AT	Austria	AT - Austria	AT - Austria	BASIC SUB-INDEX	Shelter	13	13. Shelter	88.3	88.3
AT	Austria	1	AT	Austria	AT - Austria	AT - Austria	BASIC SUB-INDEX	Personal Security	14	14. Personal Security	79.3	79.3
AT	Austria	1	AT	Austria	AT - Austria	AT - Austria	FOUNDATION SUB-INDEX	Basic Knowledge	21	21. Basic Knowledge	74.3	74.3
AT	Austria	1	AT	Austria	AT - Austria	AT - Austria	FOUNDATION SUB-INDEX	ICT Access	22	22. ICT Access	82	82


CREATE TABLE table_1 (
  "country_2_digit_iso" VARCHAR,
  "country" VARCHAR,
  "country_appear" BIGINT,
  "region_code" VARCHAR,
  "region_name" VARCHAR,
  "nuts_name_short" VARCHAR,
  "nuts_name" VARCHAR,
  "index" VARCHAR,
  "component" VARCHAR,
  "code1" BIGINT,
  "component_code_1" VARCHAR,
  "value" DOUBLE,
  "national_value" DOUBLE
);