Length Of State, Provincial And Communal Roads

Eurostat code: road_if_roadsc · (1970 - 2023)

@eurostat.road_if_roadsc

Table List

2 tables(98.62 KB)

Length Of State, Provincial And Communal Roads - Raw

Length Of State, Provincial And Communal Roads - Unpivoted

Length Of State, Provincial And Communal Roads - Raw

@eurostat.road_if_roadsc.raw

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

66.87 KB
160 rows
58 columns

freq Freq	unit Unit	tra_infr Tra Infr	geo Geo	n_1979 1979	n_1980 1980	n_1981 1981	n_1982 1982	n_1983 1983	n_1984 1984	n_1985 1985	n_1986 1986	n_1987 1987	n_1988 1988	n_1989 1989	n_1990 1990	n_1991 1991	n_1992 1992	n_1993 1993	n_1994 1994	n_1995 1995	n_1996 1996	n_1997 1997	n_1998 1998	n_1999 1999	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	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	Kilometre	Communal roads	Austria															71000	71000	71000	71000	71000	71000	71053	71059													88750	88753	88759	97745	102463	100633	94146	91238	90250	91916	92242
Annual	Kilometre	Communal roads	Belgium	109837	110258	110186	112079	115006	117860	119000	120000	121000	122000	123200	124100	125000	125900	125900	126800	127600	128200	129400	130300	130900	131520	132540	133330	134130	134940	135745	136559	137379	137870	138000	138869
Annual	Kilometre	Communal roads	Bulgaria												29918
Annual	Kilometre	Communal roads	Switzerland										51197	51197	51197	51197	51197	51197	51197	51197	51197	51197	51397	51397	51397	51397	51438	51446	51446	51446	51446	51446	51506	51615	51622	51668	51721	51819	51814	51828	51849	51863	51880	51927			65194	65405.882
Annual	Kilometre	Communal roads	Cyprus																2428	2839	3015	3103	3155	3221	3271	3352	3404	3481	3577	3666	3732	4181	4210	4254	4296	4766	4773	4795	4815	4830	4854	4891	4935	4950	4990	5047	5083
Annual	Kilometre	Communal roads	Czechia															68737	69270	66449	70520	72300	72300	72300	72300	72300	72300	72927	72927	72927	74919	74919	74919	74919	74919	74919	74919	74919	74919	74919	74919	74919	74919	74919	74919	74919	74919	74919
Annual	Kilometre	Communal roads	Germany	311000	313000	315000	317000	319000	320000	318000	319000	321000	323000	325000
Annual	Kilometre	Communal roads	Denmark	56691	57359	57857	58065	58238	58554	58509	58529	58816	58816		59168	59259	59447	59532	59642	59711	59710	59861	59882	59995	60018	60240	60328				61024	69331	69492			70089	70269	70561	70627	70646	70705	70817	70840	70900	70967	70935	70985
Annual	Kilometre	Communal roads	Estonia																																18398	18328	18398	18398	18445	18398	18398	18220	18237	18398	18398	48723	48799	48822
Annual	Kilometre	Communal roads	Spain	67283	68326	68982	69509	70419	60962	54514	54514	59586	59558	63927	64479	64660	64802	65972	66966	66984	66634	66781	68499	68160	68126	67987	69479	68862	68854	68791	68839	68366	67948	68000	67827	67439	67400	67368	68040	67605	67038	67191	67120	66923	67109	66949	67110	67097


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "tra_infr" 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
);