Baselight

Car Specification Dataset 1945-2020

Exploring the Evolution of Car Specifications from 1945 to 2020

@kaggle.jahaidulislam_car_specification_dataset_1945_2020

Loading...
Loading...

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
Loading...

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
);

Share link

Anyone who has the link will be able to view this.