Car Sales Report

A Detailed Analysis of Global Car Sales Trends

@kaggle.missionjee_car_sales_report

Table List

1 table(567.61 KB)

Car Sales Xlsx Car Data

@kaggle.missionjee_car_sales_report.car_sales_xlsx_car_data

567.61 KB
23906 rows
16 columns

car_id Car Id	date Date	customer_name Customer Name	gender Gender	annual_income Annual Income	dealer_name Dealer Name	company Company	model Model	engine Engine	transmission Transmission	color Color	price Price ($)	dealer_no Dealer No	body_style Body Style	phone Phone	dealer_region Dealer Region
C_CND_000001	Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Geraldine	Male	13500	Buddy Storbeck's Diesel Service Inc	Ford	Expedition	DoubleÂ Overhead Camshaft	Auto	Black	26000	06457-3834	SUV	8264678	Middletown
C_CND_000002	Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Gia	Male	1480000	C & M Motors Inc	Dodge	Durango	DoubleÂ Overhead Camshaft	Auto	Black	19000	60504-7114	SUV	6848189	Aurora
C_CND_000003	Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Gianna	Male	1035000	Capitol KIA	Cadillac	Eldorado	Overhead Camshaft	Manual	Red	31500	38701-8047	Passenger	7298798	Greenville
C_CND_000004	Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Giselle	Male	13500	Chrysler of Tri-Cities	Toyota	Celica	Overhead Camshaft	Manual	Pale White	14000	99301-3882	SUV	6257557	Pasco
C_CND_000005	Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Grace	Male	1465000	Chrysler Plymouth	Acura	TL	DoubleÂ Overhead Camshaft	Auto	Red	24500	53546-9427	Hatchback	7081483	Janesville
C_CND_000006	Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Guadalupe	Male	850000	Classic Chevy	Mitsubishi	Diamante	Overhead Camshaft	Manual	Pale White	12000	85257-3102	Hatchback	7315216	Scottsdale
C_CND_000007	Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Hailey	Male	1600000	Clay Johnson Auto Sales	Toyota	Corolla	Overhead Camshaft	Manual	Pale White	14000	78758-7841	Passenger	7727879	Austin
C_CND_000008	Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Graham	Male	13500	U-Haul CO	Mitsubishi	Galant	DoubleÂ Overhead Camshaft	Auto	Pale White	42000	78758-7841	Passenger	6206512	Austin
C_CND_000009	Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Naomi	Male	815000	Rabun Used Car Sales	Chevrolet	Malibu	Overhead Camshaft	Manual	Pale White	82000	85257-3102	Hardtop	7194857	Pasco
C_CND_000010	Sun Jan 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Grayson	Female	13500	Rabun Used Car Sales	Ford	Escort	DoubleÂ Overhead Camshaft	Auto	Pale White	15000	85257-3102	Passenger	7836892	Scottsdale


CREATE TABLE car_sales_xlsx_car_data (
  "car_id" VARCHAR,
  "date" TIMESTAMP,
  "customer_name" VARCHAR,
  "gender" VARCHAR,
  "annual_income" BIGINT,
  "dealer_name" VARCHAR,
  "company" VARCHAR,
  "model" VARCHAR,
  "engine" VARCHAR,
  "transmission" VARCHAR,
  "color" VARCHAR,
  "price" BIGINT,
  "dealer_no" VARCHAR,
  "body_style" VARCHAR,
  "phone" BIGINT,
  "dealer_region" VARCHAR
);