Expenditure On Road Transport Vehicles And Road Infrastructure

Eurostat code: road_ec_invest · (1992 - 2023)

@eurostat.road_ec_invest

Table List

2 tables(56.37 KB)

Expenditure On Road Transport Vehicles And Road Infrastructure - Raw

Expenditure On Road Transport Vehicles And Road Infrastructure - Unpivoted

Expenditure On Road Transport Vehicles And Road Infrastructure - Raw

@eurostat.road_ec_invest.raw

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

37.73 KB
147 rows
36 columns

freq Freq	unit Unit	expend Expend	geo Geo	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	Million euro	Expenditure on infrastructure	Albania																						242.957	207.956	187.571	102.129	172.669	182.652	188.889	202.354	298.459	228.981	379.443
Annual	Million euro	Expenditure on infrastructure	Austria															502297	486	863	677	723	742	718	670	2056						1339
Annual	Million euro	Expenditure on infrastructure	Bulgaria																	199	132	103	85	83	278.812	355.967	492.842	488.393	412.875	462.471	449.432	349.473	454.494
Annual	Million euro	Expenditure on infrastructure	Switzerland							5731	6257	6223	6247									8305	8321	8441	6819.105	6784.95	7806.911	7482.113	7401.277	7129.87	7705.861	8314.806	8462.677
Annual	Million euro	Expenditure on infrastructure	Cyprus		444	451	471	388	459	674	65	622	642	1172	1684	1674	1916	2426	2577	349	2918	2494	2692	2113	146.9	180	175.2	180.7	202.9	182.3	185.3	210.1
Annual	Million euro	Expenditure on infrastructure	Czechia		9223	12534	15803	17813	21067	21597	20089	18197	195519	246026	283354	423633	525727	57691	57830	66219	67824	60436	45809	36387	1160.97	1191.095	1570.109	1616.516	1705.519	1915.959	2365.485	2524.778	2955.733	2903.932	3865.522
Annual	Million euro	Expenditure on infrastructure	Germany																						7655	6600	6463	7560	8950	10350	10473	10862	11127	11860	12879
Annual	Million euro	Expenditure on infrastructure	Denmark	5083	5697	6136	6643	7386	6768	7082	7444	8239	8884	7944				14112	13028	12286					1967.042	1897.435	1894.164	2019.288	2183.207	2235.416	2048.191	2254.3	2112.949	2292.462
Annual	Million euro	Expenditure on infrastructure	Estonia				7271	10462	1076	14616	13119	15306	19344	35605
Annual	Million euro	Expenditure on infrastructure	Spain			771524	693266	667234	661634	796421	720121	802710	924781	7032532	7360304	7244489	855925	839612	777013	85225	942162	78506	596614	536174	4651.107	4358	4393	3880	3690	3518	3625	3660	3773	5303


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