Electric Vehicle Population DataSet

Electric Vehicle Population DataSet - State of Washington

@kaggle.adarshde_electric_vehicle_population_dataset

Table List

1 table(3.86 MB)

Electric Vehicle Population Data

@kaggle.adarshde_electric_vehicle_population_dataset.electric_vehicle_population_data

3.86 MB
191407 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
5YJSA1E22K	King	Seattle	WA	98112	2019	TESLA	MODEL S	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	270	43	202233958	POINT (-122.300312 47.629782)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033006500
3MW39FS05R	Yakima	Zillah	WA	98953	2024	BMW	330E	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	20	15	264425178	POINT (-120.2658133 46.4063477)	PACIFICORP	53077002201
1N4AZ0CP0F	King	Kent	WA	98031	2015	NISSAN	LEAF	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	84	11	114962025	POINT (-122.201564 47.402358)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033029306
5YJSA1H20F	Snohomish	Bothell	WA	98012	2015	TESLA	MODEL S	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	208	1	232724670	POINT (-122.206146 47.839957)	PUGET SOUND ENERGY INC	53061052107
JTMAB3FV1N	Yakima	Yakima	WA	98908	2022	TOYOTA	RAV4 PRIME	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	42	14	221023589	POINT (-120.611068 46.596645)	PACIFICORP	53077000902
5YJ3E1EB6K	King	Redmond	WA	98052	2019	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	220	48	296777442	POINT (-122.1207376 47.6705374)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033022606
5YJ3E1EB0J	Thurston	Yelm	WA	98597	2018	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	215	2	311913577	POINT (-122.5715761 46.9095798)	PUGET SOUND ENERGY INC	53067012422
3FA6P0SU8D	Kitsap	Poulsbo	WA	98370	2013	FORD	FUSION	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	19	23	136752115	POINT (-122.6368884 47.7469547)	PUGET SOUND ENERGY INC	53035090400
5YJSA1E21H	King	Redmond	WA	98052	2017	TESLA	MODEL S	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	210	45	241259105	POINT (-122.1207376 47.6705374)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033032321
5YJ3E1EA4J	Snohomish	Bothell	WA	98012	2018	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	215	1	118035830	POINT (-122.206146 47.839957)	PUGET SOUND ENERGY INC	53061052009


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