Amped Up: Electric Car Data⚡⚡🔋

Mapping EV Adoption & Exploring Electric Vehicle Trends.

@kaggle.vijayveersingh_amped_up_electric_car_data

Table List

1 table(4.43 MB)

Electric Vehicle Population Data

@kaggle.vijayveersingh_amped_up_electric_car_data.electric_vehicle_population_data

4.43 MB
220225 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
5YJ3E1EA5L	King	Seattle	WA	98133	2020	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	266	46	249903111	POINT (-122.35029 47.71871)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033000602
5UX43EU08R	King	Seattle	WA	98125	2024	BMW	X5	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	39	46	264762606	POINT (-122.30253 47.72656)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033000102
5UX43EU06R	King	Seattle	WA	98102	2024	BMW	X5	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	39	43	275506031	POINT (-122.32427 47.63433)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033006600
5YJ3E1EA1J	King	Kirkland	WA	98034	2018	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	215	1	117023581	POINT (-122.22901 47.72201)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033022300
1G1RA6E43C	Thurston	Olympia	WA	98501	2012	CHEVROLET	VOLT	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	35	35	158415498	POINT (-122.89166 47.03956)	PUGET SOUND ENERGY INC	53067011821
1V2CMPE88P	Yakima	Selah	WA	98942	2023	VOLKSWAGEN	ID.4	Battery Electric Vehicle (BEV)	Eligibility unknown as battery range has not been researched		15	236596720	POINT (-120.53145 46.65405)	PACIFICORP	53077003200
KNDAFFS57R	Yakima	Yakima	WA	98908	2024	KIA	EV9	Battery Electric Vehicle (BEV)	Eligibility unknown as battery range has not been researched		14	268712349	POINT (-120.60272 46.59656)	PACIFICORP	53077002804
5YJ3E1EC3L	Kitsap	Poulsbo	WA	98370	2020	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	308	23	109793470	POINT (-122.64681 47.73689)	PUGET SOUND ENERGY INC	53035090502
KNDCE3LG9L	Kitsap	Poulsbo	WA	98370	2020	KIA	NIRO	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	239	23	245762604	POINT (-122.64681 47.73689)	PUGET SOUND ENERGY INC	53035091205
KNDCC3LG4N	Yakima	Yakima	WA	98908	2022	KIA	NIRO	Battery Electric Vehicle (BEV)	Eligibility unknown as battery range has not been researched		15	183177326	POINT (-120.60272 46.59656)	PACIFICORP	53077003400


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