Dataset: Car Specification Dataset 1945-2020

About this Dataset

Car Specification Dataset 1945-2020

Introduction

This dataset contains a comprehensive list of cars manufactured from 1945 to 2020. It includes details such as make, model, year, engine size, fuel type, transmission type, drivetrain, body style, number of doors, and many more specifications.
The purpose of this dataset is to provide a comprehensive list of car specifications that can be used for various research and analysis purposes, such as market analysis, trend analysis, and predictive modeling.

Dataset Content:

The dataset consists of a single CSV file that contains the following columns:

make: the car manufacturer's name
model: the car model name
year: the year of manufacture
Generation
engine_size: the engine displacement size in liters
fuel_type: the type of fuel used by the car (gasoline, diesel, hybrid, electric, etc.)
transmission: the type of transmission (manual, automatic, CVT, etc.)
drivetrain: the type of drivetrain (front-wheel drive, rear-wheel drive, all-wheel drive, etc.)
body_type: the body type of the car (sedan, SUV, coupe, etc.)
doors: the number of doors the car has
country: the country where the car was manufactured
mpg_city: the car's estimated fuel economy in miles per gallon (city)
mpg_highway: the car's estimated fuel economy in miles per gallon (highway)
horsepower: the car's horsepower rating
torque: the car's torque rating
acceleration: the car's acceleration time from 0 to 60 miles per hour (in seconds)

Tables

Car Dataset 1945–2020

@kaggle.jahaidulislam_car_specification_dataset_1945_2020.car_dataset_1945_2020

2.47 MB
70823 rows
78 columns


CREATE TABLE car_dataset_1945_2020 (
  "id_trim" BIGINT,
  "make" VARCHAR,
  "modle" VARCHAR,
  "generation" VARCHAR,
  "year_from" DOUBLE,
  "year_to" DOUBLE,
  "series" VARCHAR,
  "trim" VARCHAR,
  "body_type" VARCHAR,
  "load_height_mm" DOUBLE,
  "number_of_seats" VARCHAR,
  "length_mm" DOUBLE,
  "width_mm" DOUBLE,
  "height_mm" DOUBLE,
  "wheelbase_mm" DOUBLE,
  "front_track_mm" DOUBLE,
  "rear_track_mm" DOUBLE,
  "curb_weight_kg" DOUBLE,
  "wheel_size_r14" VARCHAR,
  "ground_clearance_mm" DOUBLE,
  "trailer_load_with_brakes_kg" DOUBLE,
  "payload_kg" DOUBLE,
  "back_track_width_mm" DOUBLE,
  "front_track_width_mm" DOUBLE,
  "clearance_mm" VARCHAR,
  "full_weight_kg" DOUBLE,
  "front_rear_axle_load_kg" VARCHAR,
  "max_trunk_capacity_l" DOUBLE,
  "cargo_compartment_length_width_height_mm" VARCHAR,
  "cargo_volume_m3" DOUBLE,
  "minimum_trunk_capacity_l" DOUBLE,
  "maximum_torque_n_m" VARCHAR,
  "injection_type" VARCHAR,
  "overhead_camshaft" VARCHAR,
  "cylinder_layout" VARCHAR,
  "number_of_cylinders" DOUBLE,
  "compression_ratio" DOUBLE,
  "engine_type" VARCHAR,
  "valves_per_cylinder" DOUBLE,
  "boost_type" VARCHAR,
  "cylinder_bore_mm" DOUBLE,
  "stroke_cycle_mm" DOUBLE,
  "engine_placement" VARCHAR,
  "cylinder_bore_and_stroke_cycle_mm" VARCHAR,
  "turnover_of_maximum_torque_rpm" DOUBLE,
  "max_power_kw" DOUBLE,
  "presence_of_intercooler" VARCHAR,
  "capacity_cm3" DOUBLE,
  "engine_hp" DOUBLE,
  "engine_hp_rpm" VARCHAR,
  "drive_wheels" VARCHAR,
  "bore_stroke_ratio" DOUBLE,
  "number_of_gears" DOUBLE,
  "turning_circle_m" DOUBLE,
  "transmission" VARCHAR,
  "mixed_fuel_consumption_per_100_km_l" DOUBLE,
  "range_km" VARCHAR,
  "emission_standards" VARCHAR,
  "fuel_tank_capacity_l" DOUBLE,
  "acceleration_0_100_km_h_s" DOUBLE,
  "max_speed_km_per_h" VARCHAR,
  "city_fuel_per_100km_l" DOUBLE,
  "co2_emissions_g_km" DOUBLE,
  "fuel_grade" VARCHAR,
  "highway_fuel_per_100km_l" DOUBLE,
  "back_suspension" VARCHAR,
  "rear_brakes" VARCHAR,
  "front_brakes" VARCHAR,
  "front_suspension" VARCHAR,
  "steering_type" VARCHAR,
  "car_class" VARCHAR,
  "country_of_origin" VARCHAR,
  "number_of_doors" DOUBLE,
  "safety_assessment" VARCHAR,
  "rating_name" VARCHAR,
  "battery_capacity_kw_per_h" DOUBLE,
  "electric_range_km" DOUBLE,
  "charging_time_h" DOUBLE
);