Baselight

EU Social Progress Index 2020

REGIO-B1-PAPERS@ec.europa.eu

@esifunds.n_99vh_w4e7

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

ATAustriaAT - AustriaEU_SPIEU SOCIAL PROGRESS INDEX74Austria741
ATAustriaAT - AustriaBASIC SUB-INDEXBASIC SUB-INDEX87.9Austria87.91
ATAustriaAT - AustriaBASIC SUB-INDEXNutrition and Care87.6Austria87.61
ATAustriaAT - AustriaBASIC SUB-INDEXWater and Sanitation96.8Austria96.81
ATAustriaAT - AustriaBASIC SUB-INDEXShelter88.3Austria88.31
ATAustriaAT - AustriaBASIC SUB-INDEXPersonal Security79.3Austria79.31
ATAustriaAT - AustriaFOUNDATION SUB-INDEXFOUNDATION SUB-INDEX66.7Austria66.71
ATAustriaAT - AustriaFOUNDATION SUB-INDEXBasic Knowledge74.3Austria74.31
ATAustriaAT - AustriaFOUNDATION SUB-INDEXICT Access82Austria821
ATAustriaAT - AustriaFOUNDATION SUB-INDEXHealth and Wellness73Austria731

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
);