EU SPI 2020 Scores And Other Statistics

REGIO-B1-PAPERS@ec.europa.eu

@esifunds.jhi2_4z9w

Table List

1 table(50.19 KB)

Table 1

@esifunds.jhi2_4z9w.table_1

50.19 KB
240 rows
27 columns

country_code Country Code	nuts1_code Nuts1 Code	region_label Region Label	region_name Region Name	nutrition_and_care Nutrition And Care	water_and_sanitation Water And Sanitation	shelter Shelter	personal_security Personal Security	basic_knowledge Basic Knowledge	ict_access Ict Access	health_and_wellness Health And Wellness	environmental_quality Environmental Quality	personal_rights Personal Rights	personal_freedom_and_choice Personal Freedom And Choice	tolerance_inclusion Tolerance Inclusion	advanced_education Advanced Education	basic_sub_index Basic Sub Index	foundation_sub_index Foundation Sub Index	opportunity_sub_index Opportunity Sub Index	eu_spi Eu Spi	country_code_1 Country Code 1	national_basic_sub_index National Basic Sub Index	national_foundation_sub_index National Foundation Sub Index	national_opportunity_sub National Opportunity Sub	national_eu_spi National Eu Spi	gdp_per_capita_2018_pps_eu27 Gdp Per Capita 2018 Pps Eu27	population Population
AT	AT1	AT11	Burgenland	86.34	96.34	91.75	82.15	68.7	78.84	70.48	41.98	54.72	73.26	70.27	53.06	89.06	64.17	62.5	71.42	AT	87.89	66.67	68.35	74	90	292683.3333333333
AT	AT1	AT12	Niederösterreich	88.21	96.28	90.77	76.9	62.8	84.09	70.31	43.73	54.89	75.43	71.63	61.02	87.89	64.37	65.48	72.2	AT	87.89	66.67	68.35	74	107	1671321
AT	AT1	AT13	Wien	84.32	95.97	79.9	72.14	82.53	83.84	72.33	31.04	58.12	72.35	70.5	99.2	82.86	65.27	74.33	73.98	AT	87.89	66.67	68.35	74	150	1884616.3333333333
AT	AT2	AT21	Kärnten	87.58	97.11	91.54	84.76	72.85	77.91	73.27	45.73	49.46	75.46	67.16	63.39	90.19	66.77	63.51	73.03	AT	87.89	66.67	68.35	74	110	560971.3333333334
AT	AT2	AT22	Steiermark	87.98	96.98	89.19	84.4	73.91	77.41	71.64	41.03	57.15	76.03	68.32	74.53	89.58	65.06	68.8	74.11	AT	87.89	66.67	68.35	74	118	1240188
AT	AT3	AT31	Oberösterreich	89.44	97.49	92.68	81.81	74.99	82.25	74.65	43.45	55.66	77.93	67.76	63.48	90.26	67.9	65.96	74.32	AT	87.89	66.67	68.35	74	131	1473572
AT	AT3	AT32	Salzburg	88.43	97.01	88.83	80.44	90.73	81	76.46	49.64	55.43	78.21	67.78	74.03	88.58	73.59	68.58	76.69	AT	87.89	66.67	68.35	74	154	552354.3333333334
AT	AT3	AT33	Tirol	88.92	97.7	88.26	82.01	75.52	85.5	76.83	47.79	56.02	78.41	67.96	77.53	89.14	70.62	69.67	76.23	AT	87.89	66.67	68.35	74	136	750666
AT	AT3	AT34	Vorarlberg	89.41	97.61	90.98	81.79	62.68	81.5	76.04	45.4	55.23	78.59	68.09	58.36	89.86	65.62	64.76	72.97	AT	87.89	66.67	68.35	74	143	391596.6666666667
BE	BE1	BE10	Rég. de Bruxelles-Cap./Brussels Hfst. Gew.	85.63	92.54	84.72	51.34	72.28	78.3	75.13	40.9	51.91	60.41	61.87	77.57	77.63	65.67	62.61	68.49	BE	78.55	68.14	60.76	68.96	203	1206625.6666666667


CREATE TABLE table_1 (
  "country_code" VARCHAR,
  "nuts1_code" VARCHAR,
  "region_label" VARCHAR,
  "region_name" VARCHAR,
  "nutrition_and_care" DOUBLE,
  "water_and_sanitation" DOUBLE,
  "shelter" DOUBLE,
  "personal_security" DOUBLE,
  "basic_knowledge" DOUBLE,
  "ict_access" DOUBLE,
  "health_and_wellness" DOUBLE,
  "environmental_quality" DOUBLE,
  "personal_rights" DOUBLE,
  "personal_freedom_and_choice" DOUBLE,
  "tolerance_inclusion" DOUBLE,
  "advanced_education" DOUBLE,
  "basic_sub_index" DOUBLE,
  "foundation_sub_index" DOUBLE,
  "opportunity_sub_index" DOUBLE,
  "eu_spi" DOUBLE,
  "country_code_1" VARCHAR,
  "national_basic_sub_index" DOUBLE,
  "national_foundation_sub_index" DOUBLE,
  "national_opportunity_sub" DOUBLE,
  "national_eu_spi" DOUBLE,
  "gdp_per_capita_2018_pps_eu27" BIGINT,
  "population" DOUBLE
);