Electric Vehicle Population

my dataset is about vehicle eletric in development in your world atuallly

@kaggle.willianoliveiragibin_electric_vehicle_population

Table List

1 table(3.03 MB)

Electric Vehicle Population Data

@kaggle.willianoliveiragibin_electric_vehicle_population.electric_vehicle_population_data

3.03 MB
150482 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
KM8K33AGXL	King	Seattle	WA	98103	2020	HYUNDAI	KONA	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	258	43	249675142	POINT (-122.34301 47.659185)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	53033004800
1C4RJYB61N	King	Bothell	WA	98011	2022	JEEP	GRAND CHEROKEE	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	25	1	233928502	POINT (-122.20578 47.762405)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033021804
1C4RJYD61P	Yakima	Yakima	WA	98908	2023	JEEP	GRAND CHEROKEE	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	25	14	229675939	POINT (-120.6027202 46.5965625)	PACIFICORP	53077002900
5YJ3E1EA7J	King	Kirkland	WA	98034	2018	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	215	45	104714466	POINT (-122.209285 47.71124)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033021903
WBY7Z8C5XJ	Thurston	Olympia	WA	98501	2018	BMW	I3	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	97	22	185498386	POINT (-122.89692 47.043535)	PUGET SOUND ENERGY INC	53067010700
5YJ3E1EAXL	Snohomish	Marysville	WA	98271	2020	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	266	38	124595523	POINT (-122.1713847 48.10433)	PUGET SOUND ENERGY INC	53061940001
2C4RC1N77H	King	Kent	WA	98042	2017	CHRYSLER	PACIFICA	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	33	47	1815593	POINT (-122.111625 47.36078)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033031707
5YJYGDEE3L	King	Woodinville	WA	98072	2020	TESLA	MODEL Y	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	291	45	124760555	POINT (-122.151665 47.75855)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033021906
5YJ3E1EA1J	Island	Coupeville	WA	98239	2018	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	215	10	125048003	POINT (-122.6880708 48.2179983)	PUGET SOUND ENERGY INC	53029971000
7SAYGDEF0P	King	Bellevue	WA	98004	2023	TESLA	MODEL Y	Battery Electric Vehicle (BEV)	Eligibility unknown as battery range has not been researched		48	240416207	POINT (-122.201905 47.61385)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	53033023806


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