Name: Vehicle Fuel Economy
Creator: Kaggle
License: https://www.apache.org/licenses/

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.24 MB
38,113 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
);