TMDB Dataset
From Old to 2024 movies
@kaggle.fornotesnew_tmdb_dataset
From Old to 2024 movies
@kaggle.fornotesnew_tmdb_dataset
idId | titleTitle | vote_averageVote Average | vote_countVote Count | statusStatus | release_dateRelease Date | revenueRevenue | runtimeRuntime | budgetBudget | imdb_idImdb Id | original_languageOriginal Language | original_titleOriginal Title | overviewOverview | popularityPopularity | taglineTagline | genresGenres | production_companiesProduction Companies | production_countriesProduction Countries | spoken_languagesSpoken Languages | castCast | directorDirector | director_of_photographyDirector Of Photography | writersWriters | producersProducers | music_composerMusic Composer | adultAdult | backdrop_pathBackdrop Path | homepageHomepage | poster_pathPoster Path | keywordsKeywords |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Ariel | 7.1 | 318 | Released | Fri Oct 21 1988 00:00:00 GMT+0000 (Coordinated Universal Time) | 73 | tt0094675 | fi | Ariel | After the coal mine he works at closes and his father commits suicide, a Finnish man leaves for the city to make a living but there, he is framed and imprisoned for various crimes. | 16.788 | nan | Drama, Comedy, Romance, Crime | Villealfa Filmproductions | Finland | suomi | Kari Helaseppä, Susanna Haavisto, Hannu Kivisalo, Heikki Salomaa, Tarja Keinänen, Juuso Hirvikangas, Mikko Remes, Hanna Jokinen, Heikki Anttila, Jaakko Talaskivi, Marja Packalén, Markku Rantala, Jouko Lumme, Pekka Wilen, Turo Pajala, Tomi Salmela, Timo Toikka, Olli Varja, Jyrki Olsonen, Veikko Uusim… | Aki Kaurismäki | Timo Salminen | Aki Kaurismäki | Aki Kaurismäki | nan | /dQL2wJZo05GDd21VgOacMeCuyZy.jpg | nan | /ojDg0PGvs6R9xYFodRct2kdI6wC.jpg | prison, underdog, helsinki, finland, factory worker, prisoner, falling in love | |||
3 | Shadows in Paradise | 7.3 | 360 | Released | Fri Oct 17 1986 00:00:00 GMT+0000 (Coordinated Universal Time) | 74 | tt0092149 | fi | Varjoja paratiisissa | Nikander, a rubbish collector and would-be entrepreneur, finds his plans for success dashed when his business associate dies. One evening, he meets Ilona, a down-on-her-luck cashier, in a local supermarket. Falteringly, a bond begins to develop between them. | 32.465 | nan | Drama, Comedy, Romance | Villealfa Filmproductions | Finland | suomi, English, svenska | Helmeri Pellonpää, Tanja Talaskivi, Esko Nikkari, Ulla Kuosmanen, Olli Varja, Marja-Leena Hukkanen, Marina Martinoff, Kati Outinen, Jussi Tiitinen, Eskil Mansikka, Matti Pellonpää, Sirkka Silin, Ari Korhonen, Mari Rantasila, Haije Alanoja, Erkki Rissanen, Svante Korkiakoski, Bertta Pellonpää, Kylli … | Aki Kaurismäki | Timo Salminen | Aki Kaurismäki | Mika Kaurismäki | nan | /l94l89eMmFKh7na2a1u5q67VgNx.jpg | nan | /nj01hspawPof0mJmlgfjuLyJuRN.jpg | helsinki, finland, salesclerk, garbage | |||
5 | Four Rooms | 5.8 | 2578 | Released | Sat Dec 09 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | 4257354 | 98 | 4000000 | tt0113101 | en | Four Rooms | It's Ted the Bellhop's first night on the job...and the hotel's very unusual guests are about to place him in some outrageous predicaments. It seems that this evening's room service is serving up one unbelievable happening after another. | 24.747 | Twelve outrageous guests. Four scandalous requests. And one lone bellhop, in his first day on the job, who's in for the wildest New year's Eve of his life. | Comedy | Miramax, A Band Apart | United States of America | English | Kimberly Blair, Sammi Davis, Paul Skemp, Bruce Willis, Lili Taylor, Lana McKissack, Amanda de Cadenet, David Proval, Unruly Julie McClean, Tim Roth, Valeria Golino, Kathy Griffin, Jennifer Beals, Paul Calderon, Quinn Hellerman, Patricia Vonne, Quentin Tarantino, Madonna, Marisa Tomei, Marc Lawrence,… | Alexandre Rockwell, Quentin Tarantino, Allison Anders, Robert Rodriguez | Andrzej Sekula, Rodrigo García, Guillermo Navarro, Phil Parmet | Alexandre Rockwell, Quentin Tarantino, Allison Anders, Robert Rodriguez | Alexandre Rockwell, Lawrence Bender, Quentin Tarantino | Combustible Edison | /f2t4JbUvQIjUF5FstG1zZFAp02N.jpg | https://www.miramax.com/movie/four-rooms/ | /75aHn1NOYXh4M7L5shoeQ6NGykP.jpg | hotel, new year's eve, witch, bet, sperm, hotel room, anthology, los angeles, california, hoodlum, multiple storylines, woman director | |
6 | Judgment Night | 6.5 | 326 | Released | Fri Oct 15 1993 00:00:00 GMT+0000 (Coordinated Universal Time) | 12136938 | 109 | 21000000 | tt0107286 | en | Judgment Night | Four young friends, while taking a shortcut en route to a local boxing match, witness a brutal murder which leaves them running for their lives. | 14.955 | Don't move. Don't whisper. Don't even breathe. | Action, Crime, Thriller | Largo Entertainment, JVC, Universal Pictures | United States of America | English | Doug Wert, Michael DeLorenzo, Everlast, Christine Harnos, Raichle Watt, Eugene Williams, Michael Scranton, Emilio Estevez, Donovan D. Ross, Angela Alvarado, Peter Greene, Robert S. Neville, Jeremy Piven, Sean O'Grady, Nigel Gibbs, David L. Crowley, Michael Wiseman, Stuart Abramson, Will Zahrn, Mark … | Stephen Hopkins | Peter Levy | Jere Cunningham, Lewis Colick | Marilyn Vance, Gene Levy, Lloyd Segan | Alan Silvestri | /bGMqHn0H2UY6SPZ5Vch4YJM2jDO.jpg | nan | /3rvvpS9YPM5HB2f4HYiNiJVtdam.jpg | drug dealer, chicago, illinois, escape, one night, boxing | |
8 | Life in Loops (A Megacities RMX) | 7.5 | 27 | Released | Sun Jan 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time) | 80 | 42000 | tt0825671 | en | Life in Loops (A Megacities RMX) | Timo Novotny labels his new project an experimental music documentary film, in a remix of the celebrated film Megacities (1997), a visually refined essay on the hidden faces of several world ""megacities"" by leading Austrian documentarist Michael Glawogger. Novotny complements 30 % of material take… | 3.203 | A Megacities remix. | Documentary | inLoops | Austria | English, हिन्दी, 日本語, Pусский, Español | nan | Timo Novotny | Wolfgang Thaler | Michael Glawogger, Timo Novotny | Ulrich Gehmacher, Timo Novotny | nan | nan | http://lifeinloops.com | /x7Sz339F2oC8mBf0DHCQpKizXaL.jpg | megacities | ||
9 | Sunday in August | 7.135 | 26 | Released | Thu Sep 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time) | 15 | tt0425473 | de | Sonntag im August | nan | 2.729 | nan | Drama | nan | Germany | Deutsch | Rita Lengyel, Milton Welsh | Marc Meyer, Anna Haas | Peter Polsak-Lohmann | Marc Meyer | Marc Meyer | Christian Biegai | nan | nan | nan | dying and death, sailboat | |||
11 | Star Wars | 8.204 | 20206 | Released | Wed May 25 1977 00:00:00 GMT+0000 (Coordinated Universal Time) | 775398007 | 121 | 11000000 | tt0076759 | en | Star Wars | Princess Leia is captured and held hostage by the evil Imperial forces in their effort to take over the galactic Empire. Venturesome Luke Skywalker and dashing captain Han Solo team together with the loveable robot duo R2-D2 and C-3PO to rescue the beautiful princess and restore peace and justice in… | 100.49 | A long time ago in a galaxy far, far away... | Adventure, Action, Science Fiction | Lucasfilm Ltd., 20th Century Fox | United States of America | English | Kenny Baker, William Hootkins, Drewe Henley, David Ankrum, Linda Jones, Lightning Bear, Leslie Schofield, Janice Burchette, Don Henderson, Mahjoub, Morgan Upton, Hal Wamsley, Fred Wood, Lorne Peterson, Joe Johnston, Carrie Fisher, Rusty Goffe, Mark Hamill, Graham Ashley, Ted Burnett, Malcolm Tierney… | George Lucas | Gilbert Taylor | George Lucas | George Lucas, Gary Kurtz, Rick McCallum | John Williams | /zqkmTXzjkAgXmEWLRsY4UpTWCeo.jpg | http://www.starwars.com/films/star-wars-episode-iv-a-new-hope | /6FfCtAuVAW8XJjZ7eWeLibRLWTw.jpg | empire, galaxy, rebellion, android, hermit, smuggling (contraband), freedom, rebel, rescue mission, space, planet, desert, super power, oppression, space opera, wizard, totalitarianism | |
12 | Finding Nemo | 7.821 | 18826 | Released | Fri May 30 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 940335536 | 100 | 94000000 | tt0266543 | en | Finding Nemo | Nemo, an adventurous young clownfish, is unexpectedly taken from his Great Barrier Reef home to a dentist's office aquarium. It's up to his worrisome father Marlin and a friendly but forgetful fish Dory to bring Nemo home -- meeting vegetarian sharks, surfer dude turtles, hypnotic jellyfish, hungry … | 124.166 | There are 3.7 trillion fish in the ocean. They're looking for one. | Animation, Family | Pixar | United States of America | English | Alexander Gould, Susan Blu, Michaela Jill Murphy, LuLu Ebeling, Geoffrey Rush, Ellen DeGeneres, Mickie McGowan, Lili Ishida, Stephen Root, Leland Grossman, Brad Garrett, Bobby Block, Annelise Nolting, Marc John Jefferies, Joe Ranft, Ben Stanton, Caroline Kindred, Aaron Fors, Laraine Newman, Evan Sab… | Andrew Stanton | Sharon Calahan, Jeremy Lasky | Bob Peterson, Will Csaklos, Andrew Stanton, Jim Capobianco, Ronnie del Carmen, Blake Tucker, David Reynolds, Adam Bronstein | John Lasseter, Graham Walters | Thomas Newman | /h3uqFk7sZRJvLZDdLiFB9qwbL07.jpg | http://movies.disney.com/finding-nemo | /ggQ6o8X5984OCh3kZi2UIJQJY5y.jpg | sydney, australia, parent child relationship, anthropomorphism, harbor, underwater, shark, pelican, fish tank, great barrier reef, sea turtle, missing child, aftercreditsstinger, duringcreditsstinger, short term memory loss, clownfish, father son reunion, protective father | |
13 | Forrest Gump | 8.475 | 26852 | Released | Thu Jun 23 1994 00:00:00 GMT+0000 (Coordinated Universal Time) | 677387716 | 142 | 55000000 | tt0109830 | en | Forrest Gump | A man with a low IQ has accomplished great things in his life and been present during significant historic events—in each case, far exceeding what anyone imagined he could do. But despite all he has achieved, his one true love eludes him. | 90.364 | The world will never be the same once you've seen it through the eyes of Forrest Gump. | Comedy, Drama, Romance | Paramount Pictures, The Steve Tisch Company, Wendy Finerman Productions | United States of America | English | Angela Lomas, Michael Kemmerling, Steve DeRelian, Harold G. Herthum, Michael Conner Humphreys, Deborah McTeer, Aloysius Gigl, Jack Bowden, Lonnie Hamilton, Tim Perry, Dick Cavett, Elizabeth Hanks, Haley Joel Osment, Scott Oliver, John William Galt, Ben Waddel, Brendan Shanahan, Paulie DiCocco, Troy … | Robert Zemeckis | Don Burgess | Winston Groom, Eric Roth | Steve Starkey, Wendy Finerman, Steve Tisch | Alan Silvestri | /qdIMHd4sEfJSckfVJfKQvisL02a.jpg | https://www.paramountmovies.com/movies/forrest-gump | /arw2vcBveWOVZr6pxd9XTd1TdQa.jpg | vietnam war, vietnam veteran, mentally disabled, friendship, usa president, washington dc, usa, post-traumatic stress disorder (ptsd), waitress, china, based on novel or book, hippie, single parent, parent child relationship, optimism, 1970s, drug addiction, autism, alabama, black panther party, bus… | |
14 | American Beauty | 8.019 | 11767 | Released | Wed Sep 15 1999 00:00:00 GMT+0000 (Coordinated Universal Time) | 356296601 | 122 | 15000000 | tt0169547 | en | American Beauty | Lester Burnham, a depressed suburban father in a mid-life crisis, decides to turn his hectic life around after developing an infatuation with his daughter's attractive friend. | 115.253 | Look closer. | Drama | DreamWorks Pictures, Jinks/Cohen Company | United States of America | English | Carolina Lancaster, Heather Joy Sher, Alison Faulk, John Cho, Sam Robards, Fort Atkinson, Bruce Cohen, Allison Janney, Peter Gallagher, Kent Faulcon, Scott Bakula, Krista Goodsitt, Lily Houtkin, Sue Casey, Ara Celi, Tom Miller, Mona Leah, Kevin Spacey, Brenda Wehle, Dennis Anderson, Thomas J. Armstr… | Sam Mendes | Conrad L. Hall | Alan Ball | Bruce Cohen, Dan Jinks | Thomas Newman | /DztBnZaqmla2sGUW9s8AyOmskT.jpg | nan | /wby9315QzVKdW9BonAefg8jGTTb.jpg | estate agent, adultery, coming out, first time, virgin, cheating, parent child relationship, age difference, midlife crisis, cheerleader, dark comedy, rose, satire, dysfunctional family, suburbia, coming of age, sexual fantasy, dysfunctional marriage, marijuana, loneliness, love affair, exercise, ex… |
CREATE TABLE tmdb_dataset (
"id" BIGINT,
"title" VARCHAR,
"vote_average" DOUBLE,
"vote_count" DOUBLE,
"status" VARCHAR,
"release_date" TIMESTAMP,
"revenue" DOUBLE,
"runtime" DOUBLE,
"budget" DOUBLE,
"imdb_id" VARCHAR,
"original_language" VARCHAR,
"original_title" VARCHAR,
"overview" VARCHAR,
"popularity" DOUBLE,
"tagline" VARCHAR,
"genres" VARCHAR,
"production_companies" VARCHAR,
"production_countries" VARCHAR,
"spoken_languages" VARCHAR,
"cast" VARCHAR,
"director" VARCHAR,
"director_of_photography" VARCHAR,
"writers" VARCHAR,
"producers" VARCHAR,
"music_composer" VARCHAR,
"adult" BOOLEAN,
"backdrop_path" VARCHAR,
"homepage" VARCHAR,
"poster_path" VARCHAR,
"keywords" VARCHAR
);
Anyone who has the link will be able to view this.