About this Dataset

Electric Vehicle Title And Registration Activity

This shows records of title activity (transactions recording changes of ownership), and registration activity (transactions authorizing vehicles to be used on Washington public roads).
Organization: State of Washington
Last updated: 2020-11-10T17:21:20.810166
Tags: bev, bevs, bolt, car, cars, chevrolet, chevy, clean-energy, department-of-licensing, dol, dol_open_data, electric, electric-vehicle, energy, environment, ev, evs, green-report, hybrid, hybrids, leaf, model-3, nhtsa, nissan, phev, phevs, plug-in, plug-ins, population, rao_ev, rao_open_data, rao_veh, registrations, tesla, titles, vehicle, vehicles, volt

Tables

Table 1

@usgov.state_of_washington_electric_vehicle_title_and_registr_8b975e52.table_1

25.64 MB
1,355,098 rows
34 columns

CREATE TABLE table_1 (
  "clean_alternative_fuel_vehicle_type" VARCHAR,
  "vin_1_10" VARCHAR  -- VIN (1-10),
  "dol_vehicle_id" BIGINT,
  "model_year" BIGINT,
  "make" VARCHAR,
  "model" VARCHAR,
  "primary_use" VARCHAR,
  "electric_range" DOUBLE,
  "odometer_reading" BIGINT,
  "odometer_reading_description" VARCHAR,
  "new_or_used_vehicle" VARCHAR,
  "sale_price" BIGINT,
  "sale_date" VARCHAR,
  "base_msrp" DOUBLE,
  "transaction_type" VARCHAR,
  "transaction_date" VARCHAR,
  "year" BIGINT,
  "county" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postal_code" DOUBLE,
  "n_2019_hb_2042_clean_alternative_fuel_vehicle_cafv_eligibility" VARCHAR  -- 2019 HB 2042: Clean Alternative Fuel Vehicle (CAFV) Eligibility,
  "meets_2019_hb_2042_electric_range_requirement" BOOLEAN,
  "meets_2019_hb_2042_sale_date_requirement" BOOLEAN,
  "meets_2019_hb_2042_sale_price_value_requirement" BOOLEAN,
  "n_2019_hb_2042_battery_range_requirement" VARCHAR  -- 2019 HB 2042: Battery Range Requirement,
  "n_2019_hb_2042_purchase_date_requirement" VARCHAR  -- 2019 HB 2042: Purchase Date Requirement,
  "n_2019_hb_2042_sale_price_value_requirement" VARCHAR  -- 2019 HB 2042: Sale Price/Value Requirement,
  "electric_vehicle_fee_paid" VARCHAR,
  "transportation_electrification_fee_paid" VARCHAR,
  "hybrid_vehicle_electrification_fee_paid" VARCHAR,
  "n_2020_geoid" DOUBLE  -- 2020 GEOID,
  "legislative_district" DOUBLE,
  "electric_utility" VARCHAR
);