EU Social Progress Index 2020

REGIO-B1-PAPERS@ec.europa.eu

@esifunds.n_99vh_w4e7

Table List

1 table(13.15 KB)

Table 1

@esifunds.n_99vh_w4e7.table_1

13.15 KB
1000 rows
9 columns

region_code Region Code	region_name Region Name	nuts_name Nuts Name	index Index	component Component	value Value	country Country	national_value National Value	country_appear Country Appear
AT	Austria	AT - Austria	EU_SPI	EU SOCIAL PROGRESS INDEX	74	Austria	74	1
AT	Austria	AT - Austria	BASIC SUB-INDEX	BASIC SUB-INDEX	87.9	Austria	87.9	1
AT	Austria	AT - Austria	BASIC SUB-INDEX	Nutrition and Care	87.6	Austria	87.6	1
AT	Austria	AT - Austria	BASIC SUB-INDEX	Water and Sanitation	96.8	Austria	96.8	1
AT	Austria	AT - Austria	BASIC SUB-INDEX	Shelter	88.3	Austria	88.3	1
AT	Austria	AT - Austria	BASIC SUB-INDEX	Personal Security	79.3	Austria	79.3	1
AT	Austria	AT - Austria	FOUNDATION SUB-INDEX	FOUNDATION SUB-INDEX	66.7	Austria	66.7	1
AT	Austria	AT - Austria	FOUNDATION SUB-INDEX	Basic Knowledge	74.3	Austria	74.3	1
AT	Austria	AT - Austria	FOUNDATION SUB-INDEX	ICT Access	82	Austria	82	1
AT	Austria	AT - Austria	FOUNDATION SUB-INDEX	Health and Wellness	73	Austria	73	1


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