Baselight

Electric Vehicle Population Data

USA Electric Vehicle

@kaggle.mariusborel_electric_vhicule_population_data

Electric Vehicle Population Data
@kaggle.mariusborel_electric_vhicule_population_data.electric_vehicle_population_data

  • 4.14 MB
  • 205439 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

JTMAB3FV3PKitsapSeabeckWA983802023TOYOTARAV4 PRIMEPlug-in Hybrid Electric Vehicle (PHEV)Clean Alternative Fuel Vehicle Eligible4235240684006POINT (-122.8728334 47.5798304)PUGET SOUND ENERGY INC53035091301
1N4AZ1CP6JKitsapBremertonWA983122018NISSANLEAFBattery Electric Vehicle (BEV)Clean Alternative Fuel Vehicle Eligible15135474183811POINT (-122.6961203 47.5759584)PUGET SOUND ENERGY INC53035080700
5YJ3E1EA4LKingSeattleWA981012020TESLAMODEL 3Battery Electric Vehicle (BEV)Clean Alternative Fuel Vehicle Eligible26643113120017POINT (-122.3340795 47.6099315)CITY OF SEATTLE - (WA)|CITY OF TACOMA - (WA)53033007302
1N4AZ0CP8EKingSeattleWA981252014NISSANLEAFBattery Electric Vehicle (BEV)Clean Alternative Fuel Vehicle Eligible8446108188713POINT (-122.304356 47.715668)CITY OF SEATTLE - (WA)|CITY OF TACOMA - (WA)53033000700
1G1FX6S00HThurstonYelmWA985972017CHEVROLETBOLT EVBattery Electric Vehicle (BEV)Clean Alternative Fuel Vehicle Eligible23820176448940POINT (-122.5715761 46.9095798)PUGET SOUND ENERGY INC53067012510
5YJYGDEE5LSnohomishLynnwoodWA980362020TESLAMODEL YBattery Electric Vehicle (BEV)Clean Alternative Fuel Vehicle Eligible29121124511187POINT (-122.287143 47.812199)PUGET SOUND ENERGY INC53061051922
KM8S6DA23NKitsapPoulsboWA983702022HYUNDAISANTA FEPlug-in Hybrid Electric Vehicle (PHEV)Clean Alternative Fuel Vehicle Eligible3123212217764POINT (-122.6368884 47.7469547)PUGET SOUND ENERGY INC53035091100
7FCTGAAA1PSnohomishArlingtonWA982232023RIVIANR1TBattery Electric Vehicle (BEV)Eligibility unknown as battery range has not been researched39252414039POINT (-122.11597 48.194109)PUGET SOUND ENERGY INC53061053507
5YJYGDEE9LKingKentWA980312020TESLAMODEL YBattery Electric Vehicle (BEV)Clean Alternative Fuel Vehicle Eligible29147112668510POINT (-122.201564 47.402358)PUGET SOUND ENERGY INC||CITY OF TACOMA - (WA)53033029405
1N4AZ0CP2FKingKirklandWA980342015NISSANLEAFBattery Electric Vehicle (BEV)Clean Alternative Fuel Vehicle Eligible8445109765204POINT (-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
);