Length Of Paved And Unpaved Roads

Eurostat code: road_if_bsurfa · (1970 - 2023)

@eurostat.road_if_bsurfa

Table List

2 tables(66.58 KB)

Length Of Paved And Unpaved Roads - Raw

Length Of Paved And Unpaved Roads - Unpivoted

Length Of Paved And Unpaved Roads - Raw

@eurostat.road_if_bsurfa.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

49.87 KB
99 rows
58 columns

freq Freq	tra_infr Tra Infr	unit Unit	geo Geo	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Annual	Unpaved roads	Kilometre	Bosnia and Herzegovina					1051	1051	1044	1007	991	1008	553	529	553	553	533
Annual	Unpaved roads	Kilometre	Belgium	47620	48262
Annual	Unpaved roads	Kilometre	Bulgaria	279	279	277	277	273	266	274	253	285	320	319	318	319	327	341
Annual	Unpaved roads	Kilometre	Switzerland
Annual	Unpaved roads	Kilometre	Cyprus			4278	4273	4251	4249	4246	4229	4224	4242	4242	4238	4245	4224
Annual	Unpaved roads	Kilometre	Czechia
Annual	Unpaved roads	Kilometre	Spain						2028	1552	638	564	1033	1032	1032	1032	531	534
Annual	Unpaved roads	Kilometre	Finland	27176	27145	27160	27130	27152		27233	27236	27245	27266	27219	27261	27263	27317	27339
Annual	Unpaved roads	Kilometre	Georgia									230	209	209	209	209
Annual	Unpaved roads	Kilometre	Croatia	2784	2784	2631	2478	2414	2409	2322	2267	2218	2036	1917	1861	1691	1561	1489


CREATE TABLE raw (
  "freq" VARCHAR,
  "tra_infr" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1970" DOUBLE,
  "n_1971" DOUBLE,
  "n_1972" DOUBLE,
  "n_1973" DOUBLE,
  "n_1974" DOUBLE,
  "n_1975" DOUBLE,
  "n_1976" DOUBLE,
  "n_1977" DOUBLE,
  "n_1978" DOUBLE,
  "n_1979" DOUBLE,
  "n_1980" DOUBLE,
  "n_1981" DOUBLE,
  "n_1982" DOUBLE,
  "n_1983" DOUBLE,
  "n_1984" DOUBLE,
  "n_1985" DOUBLE,
  "n_1986" DOUBLE,
  "n_1987" DOUBLE,
  "n_1988" DOUBLE,
  "n_1989" DOUBLE,
  "n_1990" DOUBLE,
  "n_1991" DOUBLE,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);