Total Worldwide Passenger Cars Sales

"Exploring Trends and Insights: Total Worldwide Passenger Car Sales Dataset"

@kaggle.sukhmandeepsinghbrar_total_worldwide_passenger_cars_sales

Table List

1 table(28.18 KB)

Scraped Data

@kaggle.sukhmandeepsinghbrar_total_worldwide_passenger_cars_sales.scraped_data

28.18 KB
141 rows
19 columns

country Country	n_2005_sales 2005 Sales	n_2006_sales 2006 Sales	n_2007_sales 2007 Sales	n_2008_sales 2008 Sales	n_2009_sales 2009 Sales	n_2010_sales 2010 Sales	n_2011_sales 2011 Sales	n_2012_sales 2012 Sales	n_2013_sales 2013 Sales	n_2014_sales 2014 Sales	n_2015_sales 2015 Sales	n_2016_sales 2016 Sales	n_2017_sales 2017 Sales	n_2018_sales 2018 Sales	n_2019_sales 2019 Sales	n_2020_sales 2020 Sales	n_2021_sales 2021 Sales	n_2022_sales 2022 Sales
China	3971101	5175961	6297538	6755609	10331315	13757794	14472416	15495240	17927730	19707677	21210339	24376902	24718321	23709782	21472092	20177731	21481537	23563287
India	1106863	1311373	1511812	1545414	1816878	2387197	2510313	2781919	2553979	2570736	2772270	2966637	3229109	3394756	2962115	2433464	3082279	3792356
Japan	4748482	4612318	4325508	4184266	3905310	4203181	3509036	4572333	4562282	4699591	4215889	4146459	4386378	4391160	4301091	3809977	3675698	3448297
USA	7659983	7761592	7562334	6769107	5400890	5635432	6089403	7241900	7585341	7749432	7516826	6872729	6080229	5303580	4719710	3401838	3350050	2858575
Germany	3319259	3467961	3148163	3090040	3807175	2916259	3173634	3082504	2952431	3036773	3206042	3351607	3441262	3435778	3607258	2917678	2622132	2651357
UK	2439717	2344864	2404007	2131795	1994999	2030846	1941253	2044609	2264737	2476435	2633503	2692786	2540617	2367147	2311140	1631064	1647181	1614063
Brazil	1439822	1632947	2085718	2341300	2643862	2856540	2901647	3115223	3040783	2794687	2123009	1676722	1856450	2101884	2262069	1615942	1558467	1576666
France	2118042	2045745	2109672	2091369	2302398	2251669	2204229	1898760	1790456	1795885	1917226	2015177	2110748	2173481	2214280	1650126	1659005	1532035
South Korea	893159	932650	1010790	1017595	1221118	1237482	1293501	1256403	1243868	1359834	1533670	1533813	1526660	1525150	1497035	1618333	1468873	1420486
Italy	2244108	2335462	2494115	2161359	2159465	1961580	1749740	1403010	1304648	1360578	1575737	1824968	1970497	1910025	1916949	1381496	1456674	1316919


CREATE TABLE scraped_data (
  "country" VARCHAR,
  "n_2005_sales" DOUBLE,
  "n_2006_sales" DOUBLE,
  "n_2007_sales" DOUBLE,
  "n_2008_sales" DOUBLE,
  "n_2009_sales" DOUBLE,
  "n_2010_sales" DOUBLE,
  "n_2011_sales" DOUBLE,
  "n_2012_sales" DOUBLE,
  "n_2013_sales" DOUBLE,
  "n_2014_sales" DOUBLE,
  "n_2015_sales" BIGINT,
  "n_2016_sales" DOUBLE,
  "n_2017_sales" DOUBLE,
  "n_2018_sales" DOUBLE,
  "n_2019_sales" DOUBLE,
  "n_2020_sales" DOUBLE,
  "n_2021_sales" DOUBLE,
  "n_2022_sales" DOUBLE
);