Population Density By Other Typologies

Eurostat code: urt_d3dens · (2018 - 2023)

@eurostat.urt_d3dens

Table List

2 tables(24.47 KB)

Population Density By Other Typologies - Raw

Population Density By Other Typologies - Unpivoted

Population Density By Other Typologies - Unpivoted

@eurostat.urt_d3dens.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.

9.76 KB
2162 rows
5 columns

freq Freq	terrtypo Terrtypo	geo Geo	time_period Time Period	value Value
Annual	Border regions	Austria	2018	121
Annual	Border regions	Belgium	2018	321
Annual	Border regions	Bulgaria	2018	45
Annual	Border regions	Switzerland	2018	210
Annual	Border regions	Czechia	2018	121
Annual	Border regions	Germany	2018	188
Annual	Border regions	Denmark	2018	84
Annual	Border regions	Estonia	2018	20
Annual	Border regions	Greece	2018	37
Annual	Border regions	Spain	2018	52


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

Share link

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