Distribution Of Population By Level Of Difficulty In Accessing Public Transport, Income Quintile And Degree Of Urbanisation

Eurostat code: ilc_hcmp06 · (2012 - 2014)

@eurostat.ilc_hcmp06

Table List

2 tables(28.98 KB)

Distribution Of Population By Level Of Difficulty In Accessing Public Transport, Income Quintile And Degree Of Urbanisation - Raw

Distribution Of Population By Level Of Difficulty In Accessing Public Transport, Income Quintile And Degree Of Urbanisation - Unpivoted

Distribution Of Population By Level Of Difficulty In Accessing Public Transport, Income Quintile And Degree Of Urbanisation - Unpivoted

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

13.95 KB
3708 rows
8 columns

freq Freq	unit Unit	lev_diff Lev Diff	deg_urb Deg Urb	quantile Quantile	geo Geo	time_period Time Period	value Value
Annual	Percentage	High	Cities	First quintile	Austria	2012	5.3
Annual	Percentage	High	Cities	First quintile	Belgium	2012	3.5
Annual	Percentage	High	Cities	First quintile	Bulgaria	2012	23.9
Annual	Percentage	High	Cities	First quintile	Switzerland	2012	3.8
Annual	Percentage	High	Cities	First quintile	Cyprus	2012	10.9
Annual	Percentage	High	Cities	First quintile	Czechia	2012	3
Annual	Percentage	High	Cities	First quintile	Germany	2012	3.4
Annual	Percentage	High	Cities	First quintile	Denmark	2012	3.7
Annual	Percentage	High	Cities	First quintile	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2012	7.8
Annual	Percentage	High	Cities	First quintile	Euro area - 18 countries (2014)	2012	7.8


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

Share link

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