Economy And Finance - Cities And Greater Cities

Eurostat code: urb_cecfi · (1991 - 2022)

@eurostat.urb_cecfi

Table List

2 tables(153.86 KB)

Economy And Finance - Cities And Greater Cities - Raw

Economy And Finance - Cities And Greater Cities - Unpivoted

Economy And Finance - Cities And Greater Cities - Unpivoted

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

66.15 KB
9158 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	All companies	Antwerpen (greater city)	1991	31483
Annual	All companies	Gent	1991	14514
Annual	All companies	Charleroi (greater city)	1991	11383
Annual	All companies	Liège (greater city)	1991	12332
Annual	All companies	Brugge	1991	7583
Annual	All companies	Cyprus	1991	31753
Annual	All companies	Lefkosia (greater city)	1991	9444
Annual	All companies	Berlin	1991	85100
Annual	All companies	Hamburg	1991	49900
Annual	All companies	München	1991	43200


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.