BEVs Population Data

This dataset shows the Battery Electric Vehicles (BEVs)

@kaggle.feryrwnn_bev_population_data

Table List

1 table(502.94 KB)

Bev Population Data

@kaggle.feryrwnn_bev_population_data.bev_population_data

502.94 KB
33501 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
3C3CFFGE2H	Benton	Richland	WA	99354	2017	FIAT	500	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	84	8	102570471	POINT (-119.26844 46.31484)	BONNEVILLE POWER ADMINISTRATION\|\|CITY OF RICHLAND - (WA)	53005010500
3C3CFFGE8E	Benton	West Richland	WA	99353	2014	FIAT	500	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	87	8	212371813	POINT (-119.33836 46.29696)	BONNEVILLE POWER ADMINISTRATION\|\|PUD NO 1 OF BENTON COUNTY	53005010705
3C3CFFGE1G	Benton	West Richland	WA	99353	2016	FIAT	500	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	84	8	270139397	POINT (-119.33836 46.29696)	BONNEVILLE POWER ADMINISTRATION\|\|PUD NO 1 OF BENTON COUNTY	53005010705
3C3CFFGE1E	Benton	West Richland	WA	99353	2014	FIAT	500	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	87	8	269971271	POINT (-119.33836 46.29696)	BONNEVILLE POWER ADMINISTRATION\|\|PUD NO 1 OF BENTON COUNTY	53005010705
3C3CFFGE8G	Benton	Richland	WA	99352	2016	FIAT	500	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	84	8	156458200	POINT (-119.27372 46.27391)	BONNEVILLE POWER ADMINISTRATION\|\|CITY OF RICHLAND - (WA)	53005010820
3C3CFFGE8H	Benton	Benton City	WA	99320	2017	FIAT	500	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	84	16	131369423	POINT (-119.48756 46.26543)	BONNEVILLE POWER ADMINISTRATION\|\|PUD NO 1 OF BENTON COUNTY	53005011801
3C3CFFGE3F	Chelan	Leavenworth	WA	98826	2015	FIAT	500	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	87	12	474783501	POINT (-120.65754 47.5982)	PUD NO 1 OF CHELAN COUNTY	53007960203
3C3CFFGE3D	Chelan	Wenatchee	WA	98801	2013	FIAT	500	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	87	12	125590888	POINT (-120.30522 47.41494)	PUD NO 1 OF CHELAN COUNTY	53007960700
3C3CFFGEXF	Chelan	Wenatchee	WA	98801	2015	FIAT	500	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	87	12	151799791	POINT (-120.30522 47.41494)	PUD NO 1 OF CHELAN COUNTY	53007961102
3C3CFFGE3F	Chelan	Wenatchee	WA	98801	2015	FIAT	500	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	87	12	133427717	POINT (-120.30522 47.41494)	PUD NO 1 OF CHELAN COUNTY	53007961303


CREATE TABLE bev_population_data (
  "vin_1_10" VARCHAR,
  "county" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postal_code" BIGINT,
  "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" BIGINT
);