Car Sales Data

The dataset is useful for analyzing car sales trends over time.

@kaggle.suraj520_car_sales_data

Table List

1 table(89.48 MB)

Car Sales Data

@kaggle.suraj520_car_sales_data.car_sales_data

89.48 MB
2500000 rows
9 columns

date Date	salesperson Salesperson	customer_name Customer Name	car_make Car Make	car_model Car Model	car_year Car Year	sale_price Sale Price	commission_rate Commission Rate	commission_earned Commission Earned
Mon Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Monica Moore MD	Mary Butler	Nissan	Altima	2018	15983	0.070495227704354	1126.73
Wed Mar 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Roberto Rose	Richard Pierce	Nissan	F-150	2016	38474	0.1344388368886588	5172.4
Sat Apr 29 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Ashley Ramos	Sandra Moore	Ford	Civic	2016	33340	0.1145359215866074	3818.63
Sun Sep 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Patrick Harris	Johnny Scott	Ford	Altima	2013	41937	0.0921907218120205	3866.2
Thu Jun 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Eric Lopez	Vanessa Jones	Honda	Silverado	2022	20256	0.1134897925283973	2298.85
Sun Dec 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Terry Perkins MD	John Olsen	Ford	Altima	2015	14769	0.0772469351075994	1140.86
Sun Jun 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Ashley Brown	Tyler Lawson	Honda	F-150	2013	41397	0.1427801204620234	5910.67
Mon Jun 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Norma Watkins	Michael Bond	Ford	Altima	2015	46233	0.071623757918222	3311.38
Fri Sep 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Scott Parker	Stephanie Smith	Ford	Corolla	2021	27337	0.0995036506668146	2720.13
Thu Apr 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Andrew Smith	Ashley Moreno DDS	Ford	Civic	2018	16309	0.1499257819619804	2445.14


CREATE TABLE car_sales_data (
  "date" TIMESTAMP,
  "salesperson" VARCHAR,
  "customer_name" VARCHAR,
  "car_make" VARCHAR,
  "car_model" VARCHAR,
  "car_year" BIGINT,
  "sale_price" BIGINT,
  "commission_rate" DOUBLE,
  "commission_earned" DOUBLE
);