Baselight
Sign In

Overcrowding Rate By Degree Of Urbanisation - EU-SILC Survey

Eurostat code: tessi174 ยท (2013 - 2024)

@eurostat.tessi174

Overcrowding Rate By Degree Of Urbanisation - EU-SILC Survey - Unpivoted
@eurostat.tessi174.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.

  • 8.62 KB
  • 1251 rows
  • 6 columns
freq

Freq

unit

Unit

deg_urb

Deg Urb

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageCitiesAustria201326.5
AnnualPercentageCitiesBelgium20134.5
AnnualPercentageCitiesBulgaria201351.9
AnnualPercentageCitiesSwitzerland201312.1
AnnualPercentageCitiesCyprus20132.2
AnnualPercentageCitiesCzechia201325.5
AnnualPercentageCitiesGermany201310.4
AnnualPercentageCitiesDenmark201311.7
AnnualPercentageCitiesEuro area - 19 countries (2015-2022)201315
AnnualPercentageCitiesEstonia201324

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "deg_urb" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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