Electric Vehicle Population Dataset

Dataset is about Incresing number of Electrical vehicle in Different countries

@kaggle.yashusinghal_electric_vehicle_population_dataset

Table List

1 table(3.35 MB)

Electric Vehicle Population Data

@kaggle.yashusinghal_electric_vehicle_population_dataset.electric_vehicle_population_data

3.35 MB
166800 rows
17 columns

vin_1_10 VIN (1-10)	county County	city City	state State	postal_code Postal Code	model_year Model Year	make Make	model Model	electric_vehicle_type Electric Vehicle Type	clean_alternative_fuel_vehicle_cafv_eligibility Clean Alternative Fuel Vehicle (CAFV) Eligibility	electric_range Electric Range	legislative_district Legislative District	dol_vehicle_id DOL Vehicle ID	vehicle_location Vehicle Location	electric_utility Electric Utility	n_2020_census_tract 2020 Census Tract
3C3CFFGE4E	Yakima	Yakima	WA	98902	2014	FIAT	500	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	87	14	1593721	POINT (-120.524012 46.5973939)	PACIFICORP	53077000700
5YJXCBE40H	Thurston	Olympia	WA	98513	2017	TESLA	MODEL X	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	200	2	257167501	POINT (-122.817545 46.98876)	PUGET SOUND ENERGY INC	53067012331
3MW39FS03P	King	Renton	WA	98058	2023	BMW	330E	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	20	11	224071816	POINT (-122.1298876 47.4451257)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033025803
7PDSGABA8P	Snohomish	Bothell	WA	98012	2023	RIVIAN	R1S	Battery Electric Vehicle (BEV)	Eligibility unknown as battery range has not been researched		21	260084653	POINT (-122.1873 47.820245)	PUGET SOUND ENERGY INC	53061051927
5YJ3E1EB8L	King	Kent	WA	98031	2020	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	322	33	253771913	POINT (-122.2012521 47.3931814)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033029305
5UX43EU02R	Kitsap	Poulsbo	WA	98370	2024	BMW	X5	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	39	23	259427829	POINT (-122.64177 47.737525)	PUGET SOUND ENERGY INC	53035940100
2C4RC1H7XJ	Kitsap	Port Orchard	WA	98367	2018	CHRYSLER	PACIFICA	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	33	26	477087012	POINT (-122.6847073 47.50524)	PUGET SOUND ENERGY INC	53035092902
1G1FX6S01H	Kitsap	Poulsbo	WA	98370	2017	CHEVROLET	BOLT EV	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	238	23	214494213	POINT (-122.64177 47.737525)	PUGET SOUND ENERGY INC	53035090502
5YJ3E1EA2J	Kitsap	Port Orchard	WA	98366	2018	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	215	26	280785123	POINT (-122.639265 47.5373)	PUGET SOUND ENERGY INC	53035092400
WBY7Z6C59J	King	Duvall	WA	98019	2018	BMW	I3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	114	45	129133343	POINT (-121.9810747 47.7377962)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033032402


CREATE TABLE electric_vehicle_population_data (
  "vin_1_10" VARCHAR,
  "county" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postal_code" DOUBLE,
  "model_year" BIGINT,
  "make" VARCHAR,
  "model" VARCHAR,
  "electric_vehicle_type" VARCHAR,
  "clean_alternative_fuel_vehicle_cafv_eligibility" VARCHAR,
  "electric_range" BIGINT,
  "base_msrp" BIGINT,
  "legislative_district" DOUBLE,
  "dol_vehicle_id" BIGINT,
  "vehicle_location" VARCHAR,
  "electric_utility" VARCHAR,
  "n_2020_census_tract" DOUBLE
);