Electric & Alternative Fuel Vehicles US [2023]

Specifications of all Electric and Alternative Fuel Vehicles available in the US

@kaggle.saketpradhan_alternative_fuel_vehicles_in_the_us

Table List

3 tables(153.17 KB)

Alternative Fuel Vehicles Us

Light Duty Vehicles

Medium And Heavy Duty Vehicles

Light Duty Vehicles

@kaggle.saketpradhan_alternative_fuel_vehicles_in_the_us.light_duty_vehicles

97.22 KB
3008 rows
29 columns

vehicle_id Vehicle ID	fuel_id Fuel ID	fuel_configuration_id Fuel Configuration ID	manufacturer_id Manufacturer ID	category_id Category ID	model Model	model_year Model Year	conventional_fuel_economy_city Conventional Fuel Economy City	conventional_fuel_economy_highway Conventional Fuel Economy Highway	conventional_fuel_economy_combined Conventional Fuel Economy Combined	transmission_type Transmission Type	engine_type Engine Type	engine_size Engine Size	engine_cylinder_count Engine Cylinder Count	engine_description Engine Description	manufacturer Manufacturer	manufacturer_url Manufacturer URL	category Category	fuel_code Fuel Code	fuel Fuel	fuel_configuration_name Fuel Configuration Name	phev_type PHEV Type	notes Notes	drivetrain Drivetrain
13044	45	9	365	27	NSX	2022	21	22	21	Auto	SI	3.5L	6	3.5L V6	Acura	http://www.acura.com/	Sedan/Wagon	HYBR	Hybrid Electric	Hybrid Electric	nan	nan	AWD
12854	45	9	377	27	A3	2022	29	38	32	Auto	SI	2.0L	4	2.0L I4	Audi	http://progress.audiusa.com/	Sedan/Wagon	HYBR	Hybrid Electric	Hybrid Electric	nan	nan	FWD
12842	45	9	377	27	A3 quattro	2022	28	36	31	Auto	SI	2.0L	4	2.0L I4	Audi	http://progress.audiusa.com/	Sedan/Wagon	HYBR	Hybrid Electric	Hybrid Electric	nan	nan	AWD
12783	45	9	377	27	A4 allroad quattro	2022	24	30	26	Auto	SI	2.0L	4	2.0L I4	Audi	http://progress.audiusa.com/	Sedan/Wagon	HYBR	Hybrid Electric	Hybrid Electric	nan	nan	AWD
12782	45	9	377	27	A4 quattro	2022	26	34	29	Auto	SI	2.0L	4	2.0L I4	Audi	http://progress.audiusa.com/	Sedan/Wagon	HYBR	Hybrid Electric	Hybrid Electric	nan	nan	AWD
12784	45	9	377	27	A4 S line quattro	2022	24	31	27	Auto	SI	2.0L	4	2.0L I4	Audi	http://progress.audiusa.com/	Sedan/Wagon	HYBR	Hybrid Electric	Hybrid Electric	nan	nan	AWD
12786	45	9	377	27	A5 Cabriolet quattro	2022	23	31	26	Auto	SI	2.0L	4	2.0L I4	Audi	http://progress.audiusa.com/	Sedan/Wagon	HYBR	Hybrid Electric	Hybrid Electric	nan	nan	AWD
12785	45	9	377	27	A5 Coupe quattro	2022	24	31	27	Auto	SI	2.0L	4	2.0L I4	Audi	http://progress.audiusa.com/	Sedan/Wagon	HYBR	Hybrid Electric	Hybrid Electric	nan	nan	AWD
12787	45	9	377	27	A5 Sportback quattro	2022	26	34	29	Auto	SI	2.0L	4	2.0L I4	Audi	http://progress.audiusa.com/	Sedan/Wagon	HYBR	Hybrid Electric	Hybrid Electric	nan	nan	AWD
12788	45	9	377	27	A5 Sportback S line quattro	2022	24	31	27	Auto	SI	2.0L	4	2.0L I4	Audi	http://progress.audiusa.com/	Sedan/Wagon	HYBR	Hybrid Electric	Hybrid Electric	nan	nan	AWD


CREATE TABLE light_duty_vehicles (
  "vehicle_id" BIGINT,
  "fuel_id" BIGINT,
  "fuel_configuration_id" DOUBLE,
  "manufacturer_id" BIGINT,
  "category_id" BIGINT,
  "model" VARCHAR,
  "model_year" BIGINT,
  "alternative_fuel_economy_city" DOUBLE,
  "alternative_fuel_economy_highway" DOUBLE,
  "alternative_fuel_economy_combined" DOUBLE,
  "conventional_fuel_economy_city" DOUBLE,
  "conventional_fuel_economy_highway" DOUBLE,
  "conventional_fuel_economy_combined" DOUBLE,
  "transmission_type" VARCHAR,
  "engine_type" VARCHAR,
  "engine_size" VARCHAR,
  "engine_cylinder_count" DOUBLE,
  "engine_description" VARCHAR,
  "manufacturer" VARCHAR,
  "manufacturer_url" VARCHAR,
  "category" VARCHAR,
  "fuel_code" VARCHAR,
  "fuel" VARCHAR,
  "fuel_configuration_name" VARCHAR,
  "electric_only_range" DOUBLE,
  "phev_total_range" DOUBLE,
  "phev_type" VARCHAR,
  "notes" VARCHAR,
  "drivetrain" VARCHAR
);