Baselight

Living Conditions - Cities And Greater Cities

Eurostat code: urb_clivcon · (1989 - 2024)

@eurostat.urb_clivcon

Living Conditions - Cities And Greater Cities - Unpivoted
@eurostat.urb_clivcon.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.

  • 715.47 KB
  • 164329 rows
  • 5 columns
freq

Freq

indic_ur

Indic Ur

cities

Cities

time_period

Time Period

value

Value

AnnualPrivate households (excluding institutional households)Vilnius1989242254
AnnualPrivate households (excluding institutional households)Warszawa1989640090
AnnualPrivate households (excluding institutional households)Łódź1989342235
AnnualPrivate households (excluding institutional households)Kraków1989254521
AnnualPrivate households (excluding institutional households)Wrocław1989222708
AnnualPrivate households (excluding institutional households)Poznań1989206424
AnnualPrivate households (excluding institutional households)Gdańsk1989159513
AnnualPrivate households (excluding institutional households)Szczecin1989144519
AnnualPrivate households (excluding institutional households)Bydgoszcz1989130197
AnnualPrivate households (excluding institutional households)Lublin1989113254

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

Share link

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