Electric Vehicle Data

EV Population dataset in 2024

@kaggle.jainaru_electric_vehicle_population

Table List

1 table(3.64 MB)

Electric Vehicle Population Data

@kaggle.jainaru_electric_vehicle_population.electric_vehicle_population_data

3.64 MB
181458 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
WAUTPBFF4H	King	Seattle	WA	98126	2017	AUDI	A3	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	16	34	235085336	POINT (-122.374105 47.54468)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033011500
WAUUPBFF2J	Thurston	Olympia	WA	98502	2018	AUDI	A3	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	16	22	237896795	POINT (-122.943445 47.059252)	PUGET SOUND ENERGY INC	53067011100
5YJSA1E22H	Thurston	Lacey	WA	98516	2017	TESLA	MODEL S	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	210	22	154498865	POINT (-122.78083 47.083975)	PUGET SOUND ENERGY INC	53067012226
1C4JJXP62M	Thurston	Tenino	WA	98589	2021	JEEP	WRANGLER	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	25	20	154525493	POINT (-122.85403 46.856085)	PUGET SOUND ENERGY INC	53067012620
5YJ3E1EC9L	Yakima	Yakima	WA	98902	2020	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	308	14	225996361	POINT (-120.524012 46.5973939)	PACIFICORP	53077000800
1C4JJXP66P	Thurston	Olympia	WA	98501	2023	JEEP	WRANGLER	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	21	22	220675367	POINT (-122.89692 47.043535)	PUGET SOUND ENERGY INC	53067010802
1G1RA6S53H	Kitsap	Keyport	WA	98345	2017	CHEVROLET	VOLT	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	53	23	162720022	POINT (-122.6250117 47.7021263)	PUGET SOUND ENERGY INC	53035091100
5YJ3E1EB5L	Snohomish	Mountlake Terrace	WA	98043	2020	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	322	1	6293899	POINT (-122.30842 47.78416)	PUGET SOUND ENERGY INC	53061051302
WA1F2AFY1N	King	Seattle	WA	98119	2022	AUDI	Q5	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	23	36	207620633	POINT (-122.36731 47.6377681)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033005902
1G1RB6S59H	Thurston	Olympia	WA	98501	2017	CHEVROLET	VOLT	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	53	22	237392459	POINT (-122.89692 47.043535)	PUGET SOUND ENERGY INC	53067010700


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