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

The dataset contains over 1.75 million vehicles that have appeared in movies

@kaggle.alexandervarlamov_cars_trucks_bikes_buses_in_movies

Table List

1 table(83.28 MB)

Cars In Movies

@kaggle.alexandervarlamov_cars_trucks_bikes_buses_in_movies.cars_in_movies

83.28 MB
1756636 rows
21 columns

car_id Car Id	car_full_name Car Full Name	car_name Car Name	car_year Car Year	brand Brand	movie_title Movie Title	movie_type Movie Type	movie_years_and_episodes Movie Years And Episodes	imdb_link IMDb Link	class Class	car_type Car Type	car_origin Car Origin	car_built_in Car Built In	car_made_for Car Made For	time_in_movie Time In Movie	car_stars Car Stars	movie_eng_title Movie Eng Title	movie_original_title Movie Original Title	car_image_link Car Image Link	movie_year Movie Year	imdb_movie_id IMDb Movie Id
1	1966 Ford Mustang	Ford Mustang	1966	Ford	The Flood: Who Will Save Our Children?	Movie made for TV	1993	https://www.imdb.com/title/tt0106930/	Cars	Convertible	Australia	nan	Australia	nan	Minor action vehicle or used in only a short scene	The Flood: Who Will Save Our Children?	The Flood: Who Will Save Our Children?	https://www.imcdb.org/i000001.jpg	1993	tt0106930
2	1983 Ford LTD Crown Victoria	Ford LTD Crown Victoria	1983	Ford	The Flood: Who Will Save Our Children?	Movie made for TV	1993	https://www.imdb.com/title/tt0106930/	Cars	Sedan	USA	nan	nan	nan	Background vehicle	The Flood: Who Will Save Our Children?	The Flood: Who Will Save Our Children?	https://www.imcdb.org/i000002.jpg	1993	tt0106930
3	1989 Ford F-250 Ambulance	Ford F-250 Ambulance	1989	Ford	The Flood: Who Will Save Our Children?	Movie made for TV	1993	https://www.imdb.com/title/tt0106930/	Cars	Ambulance	Australia	Australia	Australia	nan	Minor action vehicle or used in only a short scene	The Flood: Who Will Save Our Children?	The Flood: Who Will Save Our Children?	https://www.imcdb.org/i000003.jpg	1993	tt0106930
4	1971 Cadillac Sedan DeVille	Cadillac Sedan DeVille	1971	Cadillac	The Flood: Who Will Save Our Children?	Movie made for TV	1993	https://www.imdb.com/title/tt0106930/	Cars	Sedan	USA	nan	nan	nan	Background vehicle	The Flood: Who Will Save Our Children?	The Flood: Who Will Save Our Children?	https://www.imcdb.org/i000004.jpg	1993	tt0106930
8	1964 Opel Rekord L [A]	Opel Rekord L	1964	Opel	Le casse	Movie	1971	https://www.imdb.com/title/tt0068347/	Cars	Sedan	Germany	nan	nan	nan	Vehicle used a lot by a main character or for a long time	Le casse	Le casse	https://www.imcdb.org/i000008.jpg	1971	tt0068347
9	1975 Chevrolet C-10	Chevrolet C-10	1975	Chevrolet	Mad Max	Movie	1979	https://www.imdb.com/title/tt0079501/	Cars	Pick-up	USA	nan	nan	00:29:06	Minor action vehicle or used in only a short scene	Mad Max	Mad Max	https://www.imcdb.org/i000009.jpg	1979	tt0079501
10	1960 Ford Falcon Wagon Deluxe [XK]	Ford Falcon Wagon Deluxe	1960	Ford	Mad Max	Movie	1979	https://www.imdb.com/title/tt0079501/	Cars	Wagon	Australia	Australia	Australia	nan	Background vehicle	Mad Max	Mad Max	https://www.imcdb.org/i000010.jpg	1979	tt0079501
11	1961 Ford Falcon Utility [XK]	Ford Falcon Utility	1961	Ford	Mad Max	Movie	1979	https://www.imdb.com/title/tt0079501/	Cars	Pick-up	Australia	Australia	Australia	nan	Minor action vehicle or used in only a short scene	Mad Max	Mad Max	https://www.imcdb.org/i000011.jpg	1979	tt0079501
12	1999 Jeep Grand Cherokee Limited [WJ]	Jeep Grand Cherokee Limited	1999	Jeep	One Night at McCool's	Movie	2001	https://www.imdb.com/title/tt0203755/	Cars	Off-road / SUV	USA	nan	nan	01:15:50	Vehicle used by a character or in a car chase	One Night at McCool's	One Night at McCool's	https://www.imcdb.org/i000012.jpg	2001	tt0203755
13	1992 Geo Metro [SF310]	Geo Metro	1992	Geo	One Night at McCool's	Movie	2001	https://www.imdb.com/title/tt0203755/	Cars	Hatchback	USA	USA	USA	00:35:30	Vehicle used a lot by a main character or for a long time	One Night at McCool's	One Night at McCool's	https://www.imcdb.org/i000013.jpg	2001	tt0203755


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