Name: Electric Vehicle Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Electric Vehicle Data

Electric vehicle

Electric Vehicle is a vehicle that uses one or more electric motors for propulsion. It can be powered by a collector system, with electricity from extravehicular sources, or it can be powered autonomously by a battery (sometimes charged by solar panels, or by converting fuel to electricity using fuel cells or a generator)EVs include, but are not limited to, road and rail vehicles, surface and underwater vessels, electric aircraft , and electric spacecraft. For road vehicles, together with other emerging automotive technologies such as autonomous driving, connected vehicles, and shared mobility, EVs form a future mobility vision called Connected, Autonomous, Shared, and Electric (CASE) Mobility.

This dataset shows the Battery Electric Vehicles (BEVs) and Plug-in Hybrid Electric Vehicles (PHEVs) that are currently registered through Washington State Department of Licensing (DOL)

About the columns

VIN (1-10)- Vehicle Identification Number of the vehicle mentioned in the dataset.
County- Name from where the data is gathered.
City- Cities Name from where the data is gathered.
State- State Name from where the data is gathered.
Postal Code- The postal code from where the data is Present.
Model Year- Manufacturing year of the model mentioned in the data set.
Make- Manufacturer of the vehicle.
Model- Model Name of the mentioned vehicle.
Electric Vehicle Type- Type of the vehicle present in the dataset.
Clean Alternative Fuel Vehicle (CAFV) Eligibility- Clean Alternative for the data present in this dataset.
Electric Range- The range the car provides.
Base MSRP- Base cost without any accessories.
Legislative District- Legislative District it falls under.
DOL Vehicle ID- Department of Licensing issues Vehicle ID.
Vehicle Location- Vehicle coordinates.
Electric Utility- Electricity provider.
2020 Census Tract- Census area or district defined for the purpose of taking a census.

Tables

Electric Vehicle Population Data

@kaggle.jainaru_electric_vehicle_population.electric_vehicle_population_data

3.82 MB
181,458 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
);