Name: Electric Vehicle Population Data
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Electric Vehicle Population Data

The dataset I am sharing provides information on Battery Electric Vehicles (BEVs) and Plug-in Hybrid Electric Vehicles (PHEVs) currently registered through the Washington State Department of Licensing (DOL).

The columns in the dataset include:

VIN (1-10): Partial vehicle identification number consisting of the first 10 digits.
County: The county where the vehicle is registered.
City: The city where the vehicle is registered.
State: The state where the vehicle is registered.
Postal Code: The postal code of the vehicle registration location
Model Year: The year the vehicle was manufactured.
Make: The manufacturer or brand of the vehicle.
Model: The specific model of the vehicle.
Electric Vehicle Type: Indicates whether the vehicle is a Battery Electric Vehicle (BEV) or a Plug-in Hybrid Electric Vehicle (PHEV).
Clean Alternative Fuel Vehicle (CAFV) Eligibility: Indicates if the vehicle is eligible for Clean Alternative Fuel Vehicle benefits.
Electric Range: The range of the vehicle on a full electric charge.
Base MSRP: The manufacturer's suggested retail price for the vehicle.
Legislative District: The legislative district associated with the vehicle registration location.
DOL Vehicle ID: Unique identifier assigned by the Washington State Department of Licensing.
Vehicle Location: The precise location of the vehicle.
Electric Utility: The electric utility company associated with the vehicle.
2020 Census Tract: The census tract where the vehicle is registered.

This dataset was sourced from the data.gov website and aims to contribute to the understanding of electric vehicle adoption and distribution in Washington State.

Tables

Electric Vehicle Population Data

@kaggle.gunapro_electric_vehicle_population_data.electric_vehicle_population_data

2.79 MB
130,443 rows
17 columns

CREATE TABLE electric_vehicle_population_data (
  "vin_1_10" VARCHAR  -- VIN (1-10),
  "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  -- Clean Alternative Fuel Vehicle (CAFV) Eligibility,
  "electric_range" BIGINT,
  "base_msrp" BIGINT,
  "legislative_district" DOUBLE,
  "dol_vehicle_id" BIGINT,
  "vehicle_location" VARCHAR,
  "electric_utility" VARCHAR,
  "n_2020_census_tract" DOUBLE  -- 2020 Census Tract
);