Baselight
Sign In

Perception Survey Results

Eurostat code: urb_percep$dv_283

@eurostat.urb_percep_dv_283

Perception Survey Results - Unpivoted
@eurostat.urb_percep_dv_283.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.

  • 12.95 KB
  • 2736 rows
  • 6 columns
freq

Freq

indic_ur

Indic Ur

unit

Unit

cities

Cities

time_period

Time Period

value

Value

AnnualSports facilities such as sport fields and indoor sport halls in the city: very satisfiedPercentageWien (greater city)200920.8
AnnualSports facilities such as sport fields and indoor sport halls in the city: very satisfiedPercentageGraz200918.3
AnnualSports facilities such as sport fields and indoor sport halls in the city: very satisfiedPercentageBruxelles/Brussel (greater city)200914.3
AnnualSports facilities such as sport fields and indoor sport halls in the city: very satisfiedPercentageAntwerpen (greater city)200924.5
AnnualSports facilities such as sport fields and indoor sport halls in the city: very satisfiedPercentageLiège (greater city)20098.7
AnnualSports facilities such as sport fields and indoor sport halls in the city: very satisfiedPercentageSofia200910.6
AnnualSports facilities such as sport fields and indoor sport halls in the city: very satisfiedPercentageBurgas200914.6
AnnualSports facilities such as sport fields and indoor sport halls in the city: very satisfiedPercentageLefkosia (greater city)200918.5
AnnualSports facilities such as sport fields and indoor sport halls in the city: very satisfiedPercentagePraha200921.6
AnnualSports facilities such as sport fields and indoor sport halls in the city: very satisfiedPercentageOstrava200926.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.