Name: Electric Vehicle Population Dataset
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Electric Vehicle Population Dataset

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). BEV sales during Q2 2023 grew over 50% YoY. One in every 10 cars sold during Q2 2023 was a pure battery electric vehicle (BEV). China remained the leader in global BEV sales followed by USA and Germany. BEV sales in the USA grew by almost 57% YoY, the highest among the top 3 EV markets

Brief Information About the Features of Dataset:

VIN: A Vehicle Identification Number (VIN) is the identifying code for a specific automobile.
Country:. Country where it is Manufactured.
City: location of Company that manufactures Electric Cars.
Postal Code: Pin code is the post office numbering code system used by the postal service.
Model Year: a year in which the car was manufactured.
Make Name of Company.
Model: A vehicle identification number (VIN) is a unique, 17-digit code specific to every vehicle.
Electric Vehicle Type: When talking about EVs, we generally refer to three main types of electric vehicles: hybrid electric vehicles (HEV), plug-in hybrid electric vehicles (PHEV), and battery electric vehicles (BEV).
Clean Alternative Fuel Vehicle: Vegetable oils, such as palm, soybean, sunflower, peanut, and olive, as alternative fuels can be used for diesel engines. As an alternative fuel, vegetable oil is one of the renewable fuels.
Electric Range: All-electric vehicles can typically go between 110 and over 300 miles on a single charge. PHEVs can typically go 15–60 miles on battery power alone; the fuel tank capacity determines their overall range because the engine kicks in when the battery is depleted.
Base MSRP: Manufacturers set a base price for a car or vehicle without add-on products or features. The Manufacturer's Suggested Retail Price (MSRP) is the base price plus additional features.
Legislative District: While the Legislature of every State shall consist of the Governor and the State Legislature, in some of the States, the Legislature shall consist of two Houses, namely, the Legislative Assembly and the Legislative Council, while in the rest, there shall be only one House, namely the legislative assembly.
DOL Vehicle ID: DOL Vehicle ID. A unique identification number for each vehicle is present in the Transactions dataset. Transactions done on the same vehicle will have the same DOL Vehicle ID.
Vehicle Location: In cases where the vehicle was designed for electric motors, they are generally located at the front and/or rear between the wheels. There are short half-shafts connecting the output of the motors to the wheels.
Electric Utility: A corporation, person, agency, authority, or other legal entity or instrumentality aligned with distribution facilities for delivery of electric energy for use primarily by the public.
2020 Census Tract: Census tracts are relatively permanent small-area geographic divisions of a county or statistically equivalent entity defined for the tabulation and presentation of data from the decennial census and selected other statistical programs

Tables

Electric Vehicle Population Data

@kaggle.yashusinghal_electric_vehicle_population_dataset.electric_vehicle_population_data

3.51 MB
166,800 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
);