Electric Vehicle Population Data

State of Washington

@usgov.state_of_washington_electric_vehicle_population_data

Table List

1 table(4.44 MB)

Table 1

@usgov.state_of_washington_electric_vehicle_population_data.table_1

4.44 MB
239747 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
1C4JJXP68P	Yakima	Yakima	WA	98901	2023	JEEP	WRANGLER	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	21		15	249905295	POINT (-120.50729 46.60464)	PACIFICORP	53077001601
1G1FY6S03L	Kitsap	Kingston	WA	98346	2020	CHEVROLET	BOLT EV	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	259		23	141133765	POINT (-122.4977 47.79802)	PUGET SOUND ENERGY INC	53035940000
KNDCE3LG9K	King	Seattle	WA	98125	2019	KIA	NIRO	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	239		46	3410074	POINT (-122.30253 47.72656)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033000101
1N4AZ0CP8E	Thurston	Olympia	WA	98506	2014	NISSAN	LEAF	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	84		22	182436474	POINT (-122.87741 47.05997)	PUGET SOUND ENERGY INC	53067012100
5YJXCAE29L	Kitsap	Silverdale	WA	98383	2020	TESLA	MODEL X	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	293		23	1843054	POINT (-122.69275 47.65171)	PUGET SOUND ENERGY INC	53035091206
1G1FX6S02H	Kitsap	Kingston	WA	98346	2017	CHEVROLET	BOLT EV	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	238		23	477830503	POINT (-122.4977 47.79802)	PUGET SOUND ENERGY INC	53035940000
7SAYGDEE4S	Thurston	Olympia	WA	98501	2025	TESLA	MODEL Y	Battery Electric Vehicle (BEV)	Eligibility unknown as battery range has not been researched			22	275305593	POINT (-122.89166 47.03956)	PUGET SOUND ENERGY INC	53067010400
5YJSA1DG8D	Thurston	Olympia	WA	98512	2013	TESLA	MODEL S	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	208	69900	35	188559976	POINT (-122.9131 47.01359)	PUGET SOUND ENERGY INC	53067011821
KNDJX3AE9G	Thurston	Olympia	WA	98506	2016	KIA	SOUL	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	93	31950	22	147089407	POINT (-122.87741 47.05997)	PUGET SOUND ENERGY INC	53067010200
5YJYGDEF7L	King	Seattle	WA	98146	2020	TESLA	MODEL Y	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	291		34	112896577	POINT (-122.36178 47.49408)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033012100


CREATE TABLE table_1 (
  "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" DOUBLE,
  "base_msrp" DOUBLE,
  "legislative_district" DOUBLE,
  "dol_vehicle_id" BIGINT,
  "vehicle_location" VARCHAR,
  "electric_utility" VARCHAR,
  "n_2020_census_tract" DOUBLE
);