Electric Vehicle Population Data

Electric Vehicle Population Data in Washington State: BEVs and PHEVs registered

@kaggle.gunapro_electric_vehicle_population_data

Table List

1 table(2.66 MB)

Electric Vehicle Population Data

@kaggle.gunapro_electric_vehicle_population_data.electric_vehicle_population_data

2.66 MB
130443 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	base_msrp Base MSRP	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
5YJXCAE26J	Yakima	Yakima	WA	98908	2018	TESLA	MODEL X	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	238		14	141151601	POINT (-120.56916 46.58514)	PACIFICORP	53077001100
JHMZC5F37M	Kitsap	Poulsbo	WA	98370	2021	HONDA	CLARITY	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	47		23	171566447	POINT (-122.64681 47.73689)	PUGET SOUND ENERGY INC	53035090400
5YJ3E1EB0K	King	Seattle	WA	98199	2019	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	220		36	9426525	POINT (-122.40092 47.65908)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033005803
1N4AZ0CP5D	King	Seattle	WA	98119	2013	NISSAN	LEAF	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	75		36	211807760	POINT (-122.3684 47.64586)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033005804
5YJSA1E21H	Thurston	Lacey	WA	98516	2017	TESLA	MODEL S	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	210		22	185810306	POINT (-122.75379 47.06316)	PUGET SOUND ENERGY INC	53067012226
JHMZC5F1XJ	Thurston	Olympia	WA	98506	2018	HONDA	CLARITY	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	47		22	153785726	POINT (-122.87741 47.05997)	PUGET SOUND ENERGY INC	53067012211
3FA6P0PU1G	Thurston	Tumwater	WA	98501	2016	FORD	FUSION	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	19		22	347508836	POINT (-122.89166 47.03956)	PUGET SOUND ENERGY INC	53067010802
WA1F2AFY8P	Thurston	Lacey	WA	98516	2023	AUDI	Q5 E	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	23		22	227213871	POINT (-122.75379 47.06316)	PUGET SOUND ENERGY INC	53067012225
1FADP5CU0E	Thurston	Rochester	WA	98579	2014	FORD	C-MAX	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	19		20	229811151	POINT (-123.08743 46.82175)	PUGET SOUND ENERGY INC	53067012710
5YJSA1CP1D	Kitsap	Bremerton	WA	98312	2013	TESLA	MODEL S	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	208	69900	26	164768075	POINT (-122.66122 47.56573)	PUGET SOUND ENERGY INC	53035081100


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