Dataset: Vehicle Fuel Economy

About this Dataset

Vehicle Fuel Economy

This dataset offers a comprehensive look into the fuel economy in automotive world, exploring details about various vehicles spanning different years, makes, and models. It includes information on engine specifications, fuel types, transmission systems, and even factors like fuel economy, CO2 emissions, and technological features.

Tables

Fuel

@kaggle.sahirmaharajj_fuel_economy.fuel

1.18 MB
38113 rows
81 columns


CREATE TABLE fuel (
  "vehicle_id" BIGINT,
  "year" BIGINT,
  "make" VARCHAR,
  "model" VARCHAR,
  "class" VARCHAR,
  "drive" VARCHAR,
  "transmission" VARCHAR,
  "transmission_type" VARCHAR,
  "engine_index" BIGINT,
  "engine_descriptor" VARCHAR,
  "engine_cylinders" DOUBLE,
  "engine_displacement" DOUBLE,
  "turbocharger" VARCHAR,
  "supercharger" VARCHAR,
  "fuel_type" VARCHAR,
  "fuel_type_1" VARCHAR,
  "fuel_type_2" VARCHAR,
  "city_mpg_ft1" BIGINT,
  "unrounded_city_mpg_ft1" DOUBLE,
  "city_mpg_ft2" BIGINT,
  "unrounded_city_mpg_ft2" DOUBLE,
  "city_gasoline_consumption_cd" DOUBLE,
  "city_electricity_consumption" DOUBLE,
  "city_utility_factor" DOUBLE,
  "highway_mpg_ft1" BIGINT,
  "unrounded_highway_mpg_ft1" DOUBLE,
  "highway_mpg_ft2" BIGINT,
  "unrounded_highway_mpg_ft2" DOUBLE,
  "highway_gasoline_consumption_cd" DOUBLE,
  "highway_electricity_consumption" DOUBLE,
  "highway_utility_factor" DOUBLE,
  "unadjusted_city_mpg_ft1" DOUBLE,
  "unadjusted_highway_mpg_ft1" DOUBLE,
  "unadjusted_city_mpg_ft2" DOUBLE,
  "unadjusted_highway_mpg_ft2" DOUBLE,
  "combined_mpg_ft1" BIGINT,
  "unrounded_combined_mpg_ft1" DOUBLE,
  "combined_mpg_ft2" BIGINT,
  "unrounded_combined_mpg_ft2" DOUBLE,
  "combined_electricity_consumption" DOUBLE,
  "combined_gasoline_consumption_cd" DOUBLE,
  "combined_utility_factor" DOUBLE,
  "annual_fuel_cost_ft1" BIGINT,
  "annual_fuel_cost_ft2" BIGINT,
  "gas_guzzler_tax" VARCHAR,
  "save_or_spend_5_year" BIGINT,
  "annual_consumption_in_barrels_ft1" DOUBLE,
  "annual_consumption_in_barrels_ft2" DOUBLE,
  "tailpipe_co2_ft1" BIGINT,
  "tailpipe_co2_in_grams_mile_ft1" DOUBLE,
  "tailpipe_co2_ft2" BIGINT,
  "tailpipe_co2_in_grams_mile_ft2" DOUBLE,
  "fuel_economy_score" BIGINT,
  "ghg_score" BIGINT,
  "ghg_score_alt_fuel" BIGINT,
  "my_mpg_data" VARCHAR,
  "x2d_passenger_volume" BIGINT,
  "x2d_luggage_volume" BIGINT,
  "x4d_passenger_volume" BIGINT,
  "x4d_luggage_volume" BIGINT,
  "hatchback_passenger_volume" BIGINT,
  "hatchback_luggage_volume" BIGINT,
  "start_stop_technology" VARCHAR,
  "alternative_fuel_technology" VARCHAR,
  "electric_motor" VARCHAR,
  "manufacturer_code" VARCHAR,
  "gasoline_electricity_blended_cd" BOOLEAN,
  "vehicle_charger" VARCHAR,
  "alternate_charger" VARCHAR,
  "hours_to_charge_120v" BIGINT,
  "hours_to_charge_240v" DOUBLE,
  "hours_to_charge_ac_240v" DOUBLE,
  "composite_city_mpg" BIGINT,
  "composite_highway_mpg" BIGINT,
  "composite_combined_mpg" BIGINT,
  "range_ft1" BIGINT,
  "city_range_ft1" DOUBLE,
  "highway_range_ft1" DOUBLE,
  "range_ft2" VARCHAR,
  "city_range_ft2" DOUBLE,
  "highway_range_ft2" DOUBLE
);