Baselight

Perception Survey Results

Eurostat code: urb_percep$dv_981

@eurostat.urb_percep_dv_981

Perception Survey Results - Unpivoted
@eurostat.urb_percep_dv_981.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

  • 23.21 KB
  • 9215 rows
  • 6 columns
freq

Freq

indic_ur

Indic Ur

unit

Unit

cities

Cities

time_period

Time Period

value

Value

AnnualCultural facilities such as concert halls, theatres, museums and libraries in the city: very satisfiedPercentageWien (greater city)200974.1
AnnualCultural facilities such as concert halls, theatres, museums and libraries in the city: very satisfiedPercentageGraz200952.8
AnnualCultural facilities such as concert halls, theatres, museums and libraries in the city: very satisfiedPercentageBruxelles/Brussel (greater city)200931.3
AnnualCultural facilities such as concert halls, theatres, museums and libraries in the city: very satisfiedPercentageAntwerpen (greater city)200947.1
AnnualCultural facilities such as concert halls, theatres, museums and libraries in the city: very satisfiedPercentageLiège (greater city)200926.1
AnnualCultural facilities such as concert halls, theatres, museums and libraries in the city: very satisfiedPercentageSofia200921.4
AnnualCultural facilities such as concert halls, theatres, museums and libraries in the city: very satisfiedPercentageBurgas200918.7
AnnualCultural facilities such as concert halls, theatres, museums and libraries in the city: very satisfiedPercentageLefkosia (greater city)200916.6
AnnualCultural facilities such as concert halls, theatres, museums and libraries in the city: very satisfiedPercentagePraha200940.1
AnnualCultural facilities such as concert halls, theatres, museums and libraries in the city: very satisfiedPercentageOstrava200928.7

CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_ur" VARCHAR,
  "unit" VARCHAR,
  "cities" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.