Electric Vehicle Population Data
USA Electric Vehicle
@kaggle.mariusborel_electric_vhicule_population_data
USA Electric Vehicle
@kaggle.mariusborel_electric_vhicule_population_data
vin_1_10VIN (1-10) | countyCounty | cityCity | stateState | postal_codePostal Code | model_yearModel Year | makeMake | modelModel | electric_vehicle_typeElectric Vehicle Type | clean_alternative_fuel_vehicle_cafv_eligibilityClean Alternative Fuel Vehicle (CAFV) Eligibility | electric_rangeElectric Range | base_msrpBase MSRP | legislative_districtLegislative District | dol_vehicle_idDOL Vehicle ID | vehicle_locationVehicle Location | electric_utilityElectric Utility | n_2020_census_tract2020 Census Tract |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
JTMAB3FV3P | Kitsap | Seabeck | WA | 98380 | 2023 | TOYOTA | RAV4 PRIME | Plug-in Hybrid Electric Vehicle (PHEV) | Clean Alternative Fuel Vehicle Eligible | 42 | 35 | 240684006 | POINT (-122.8728334 47.5798304) | PUGET SOUND ENERGY INC | 53035091301 | |
1N4AZ1CP6J | Kitsap | Bremerton | WA | 98312 | 2018 | NISSAN | LEAF | Battery Electric Vehicle (BEV) | Clean Alternative Fuel Vehicle Eligible | 151 | 35 | 474183811 | POINT (-122.6961203 47.5759584) | PUGET SOUND ENERGY INC | 53035080700 | |
5YJ3E1EA4L | King | Seattle | WA | 98101 | 2020 | TESLA | MODEL 3 | Battery Electric Vehicle (BEV) | Clean Alternative Fuel Vehicle Eligible | 266 | 43 | 113120017 | POINT (-122.3340795 47.6099315) | CITY OF SEATTLE - (WA)|CITY OF TACOMA - (WA) | 53033007302 | |
1N4AZ0CP8E | King | Seattle | WA | 98125 | 2014 | NISSAN | LEAF | Battery Electric Vehicle (BEV) | Clean Alternative Fuel Vehicle Eligible | 84 | 46 | 108188713 | POINT (-122.304356 47.715668) | CITY OF SEATTLE - (WA)|CITY OF TACOMA - (WA) | 53033000700 | |
1G1FX6S00H | Thurston | Yelm | WA | 98597 | 2017 | CHEVROLET | BOLT EV | Battery Electric Vehicle (BEV) | Clean Alternative Fuel Vehicle Eligible | 238 | 20 | 176448940 | POINT (-122.5715761 46.9095798) | PUGET SOUND ENERGY INC | 53067012510 | |
5YJYGDEE5L | Snohomish | Lynnwood | WA | 98036 | 2020 | TESLA | MODEL Y | Battery Electric Vehicle (BEV) | Clean Alternative Fuel Vehicle Eligible | 291 | 21 | 124511187 | POINT (-122.287143 47.812199) | PUGET SOUND ENERGY INC | 53061051922 | |
KM8S6DA23N | Kitsap | Poulsbo | WA | 98370 | 2022 | HYUNDAI | SANTA FE | Plug-in Hybrid Electric Vehicle (PHEV) | Clean Alternative Fuel Vehicle Eligible | 31 | 23 | 212217764 | POINT (-122.6368884 47.7469547) | PUGET SOUND ENERGY INC | 53035091100 | |
7FCTGAAA1P | Snohomish | Arlington | WA | 98223 | 2023 | RIVIAN | R1T | Battery Electric Vehicle (BEV) | Eligibility unknown as battery range has not been researched | 39 | 252414039 | POINT (-122.11597 48.194109) | PUGET SOUND ENERGY INC | 53061053507 | ||
5YJYGDEE9L | King | Kent | WA | 98031 | 2020 | TESLA | MODEL Y | Battery Electric Vehicle (BEV) | Clean Alternative Fuel Vehicle Eligible | 291 | 47 | 112668510 | POINT (-122.201564 47.402358) | PUGET SOUND ENERGY INC||CITY OF TACOMA - (WA) | 53033029405 | |
1N4AZ0CP2F | King | Kirkland | WA | 98034 | 2015 | NISSAN | LEAF | Battery Electric Vehicle (BEV) | Clean Alternative Fuel Vehicle Eligible | 84 | 45 | 109765204 | POINT (-122.2026532 47.7210518) | PUGET SOUND ENERGY INC||CITY OF TACOMA - (WA) | 53033021904 |
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" DOUBLE,
"base_msrp" DOUBLE,
"legislative_district" DOUBLE,
"dol_vehicle_id" BIGINT,
"vehicle_location" VARCHAR,
"electric_utility" VARCHAR,
"n_2020_census_tract" DOUBLE
);
Anyone who has the link will be able to view this.