New Passenger Cars By Type Of Motor Energy And Engine Size

Eurostat code: road_eqr_carmot · (1970 - 2023)

@eurostat.road_eqr_carmot

Table List

2 tables(120.58 KB)

New Passenger Cars By Type Of Motor Energy And Engine Size - Raw

New Passenger Cars By Type Of Motor Energy And Engine Size - Unpivoted

New Passenger Cars By Type Of Motor Energy And Engine Size - Raw

@eurostat.road_eqr_carmot.raw

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

74.08 KB
343 rows
52 columns

freq Freq	unit Unit	mot_nrg Mot Nrg	engine Engine	geo Geo	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	Number	Diesel	From 1 400 to 1 999 cm³	Austria	146817	155684	158020	158103	175893	183821		139508	132001	124222	117739	137282	161650	157799	148732	142434	151225	162344	149980	121008	116686	91970	66672	56687	55645
Annual	Number	Diesel	From 1 400 to 1 999 cm³	Bosnia and Herzegovina															3375	3389	3146	4273	4513	4465	4106	3059	2900	2645	2612
Annual	Number	Diesel	From 1 400 to 1 999 cm³	Belgium						245087	260791	280099	291300	315073	273925	328443		274119	265841	255701	263051	251173	231725	178651	164802	143054	95822	65550
Annual	Number	Diesel	From 1 400 to 1 999 cm³	Switzerland						42515	48165	49100	58300	61600	51500	62400	75300	86300	81336	79089	92336	94116	87773	71414	70843	52168	40286	36445	35748
Annual	Number	Diesel	From 1 400 to 1 999 cm³	Cyprus							781	875	1541	2631	2938	2980	2525	1883	788	2279	3353	4549	4706	4533	4144	2800	1313	417	326
Annual	Number	Diesel	From 1 400 to 1 999 cm³	Czechia																								40744	46863
Annual	Number	Diesel	From 1 400 to 1 999 cm³	Germany						921058	953694	1019668	998646	913397	804386	868989	1079139	1091951	1027556	1073048	1146031	1170332	1019577	866997	1004093	757847	549099	522589	576422
Annual	Number	Diesel	From 1 400 to 1 999 cm³	Estonia		1255	1243	1540	1549	1911		3341	4803	3583	2339	2593	4039	4843	5465	5503	5381	4942	5163	5421	5542	4472	4452	3458	3230
Annual	Number	Diesel	From 1 400 to 1 999 cm³	Greece	1474	1572	1720	1626	3140																				19320
Annual	Number	Diesel	From 1 400 to 1 999 cm³	Spain								881795	882729	638494	545385	568799	466161	401320		498709	569285	621236	594251	498755	409387	308876	248346	190250	172774


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "mot_nrg" VARCHAR,
  "engine" VARCHAR,
  "geo" VARCHAR,
  "n_1970" DOUBLE,
  "n_1975" 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
);