Full Electric Vehicle Dataset 2024

A comprehensive dataset of Battery and Plug-in Hybrid and Electric Vehicles

@kaggle.sahirmaharajj_electric_vehicle_population

Table List

1 table(3.54 MB)

Electric Vehicle Population Data

@kaggle.sahirmaharajj_electric_vehicle_population.electric_vehicle_population_data

3.54 MB
177866 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
5YJYGDEE1L	King	Seattle	WA	98122	2020	TESLA	MODEL Y	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	291	37	125701579	POINT (-122.30839 47.610365)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033007800
7SAYGDEE9P	Snohomish	Bothell	WA	98021	2023	TESLA	MODEL Y	Battery Electric Vehicle (BEV)	Eligibility unknown as battery range has not been researched		1	244285107	POINT (-122.179458 47.802589)	PUGET SOUND ENERGY INC	53061051938
5YJSA1E4XK	King	Seattle	WA	98109	2019	TESLA	MODEL S	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	270	36	156773144	POINT (-122.34848 47.632405)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033006800
5YJSA1E27G	King	Issaquah	WA	98027	2016	TESLA	MODEL S	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	210	5	165103011	POINT (-122.03646 47.534065)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033032104
5YJYGDEE5M	Kitsap	Suquamish	WA	98392	2021	TESLA	MODEL Y	Battery Electric Vehicle (BEV)	Eligibility unknown as battery range has not been researched		23	205138552	POINT (-122.55717 47.733415)	PUGET SOUND ENERGY INC	53035940100
3FA6P0SU8H	Thurston	Yelm	WA	98597	2017	FORD	FUSION	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	21	2	122057736	POINT (-122.61023 46.94126)	PUGET SOUND ENERGY INC	53067012532
1N4AZ0CP2D	Yakima	Yakima	WA	98903	2013	NISSAN	LEAF	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	75	14	150126840	POINT (-120.477805 46.553505)	PACIFICORP	53077003003
KNAGV4LD9J	Snohomish	Bothell	WA	98012	2018	KIA	OPTIMA	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	29	1	290605598	POINT (-122.1873 47.820245)	PUGET SOUND ENERGY INC	53061052107
1N4AZ0CP8F	Kitsap	Port Orchard	WA	98366	2015	NISSAN	LEAF	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	84	26	137322111	POINT (-122.639265 47.5373)	PUGET SOUND ENERGY INC	53035092400
5UXTA6C03N	King	Auburn	WA	98001	2022	BMW	X5	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	30	47	240226332	POINT (-122.2849393 47.3384055)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033029902


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
);