Dataset: Cars, Trucks, Bikes, Buses In Movies (1900-2024)

About this Dataset

Cars, Trucks, Bikes, Buses In Movies (1900-2024)

The dataset includes over 1.75 million vehicles that have appeared in films (1900-2024). It features brands, classes, body types, and various other characteristics. Each vehicle is linked to a specific film, the time it appears on screen, and a link to the exact frame where the vehicle was shown. Of the total, 1.49 million are cars, while the rest include motorcycles, trucks, buses, bicycles, and more. The data is sourced from the website https://www.imcdb.org.

Field Descriptions:

Brand: Vehicle brand
Car Full Name: Full name of the vehicle, including the year of manufacture
Car Id: Vehicle ID
Car Name: Name of the vehicle
Car Origin: Country of origin of the vehicle
Car Built In: Country where the vehicle was manufactured
Car Made For: Country for which the vehicle was produced
Car Image Link: Link to images of the vehicle in the film frame
Car Type: Body type
Car Year: Year production started for the vehicle
Car Stars: Role of the vehicle in the film (main, significant, background, etc.)
Class: Type of vehicle
IMDb Movie Id: Movie ID on imdb.com
IMDb Link: Link to the film on imdb.com
Movie Title: Full title of the film
Movie Eng Title: Title of the film in English
Movie Original Title: Original title of the film
Movie Type: Type of film
Movie Years and Episodes: Years of film production and episodes (multiple years and episodes are typical for series)
Time in Movie: Duration the vehicle appears on screen
Movie Year: Year the film was released

Tables

Cars In Movies

@kaggle.alexandervarlamov_cars_trucks_bikes_buses_in_movies.cars_in_movies

83.28 MB
1756636 rows
21 columns


CREATE TABLE cars_in_movies (
  "car_id" BIGINT,
  "car_full_name" VARCHAR,
  "car_name" VARCHAR,
  "car_year" DOUBLE,
  "brand" VARCHAR,
  "movie_title" VARCHAR,
  "movie_type" VARCHAR,
  "movie_years_and_episodes" VARCHAR,
  "imdb_link" VARCHAR,
  "class" VARCHAR,
  "car_type" VARCHAR,
  "car_origin" VARCHAR,
  "car_built_in" VARCHAR,
  "car_made_for" VARCHAR,
  "time_in_movie" VARCHAR,
  "car_stars" VARCHAR,
  "movie_eng_title" VARCHAR,
  "movie_original_title" VARCHAR,
  "car_image_link" VARCHAR,
  "movie_year" DOUBLE,
  "imdb_movie_id" VARCHAR
);