Baselight
Sign In

The Movies Dataset

Metadata on over 45,000 movies. 26 million ratings from over 270,000 users.

@kaggle.rounakbanik_the_movies_dataset

Movies Metadata
@kaggle.rounakbanik_the_movies_dataset.movies_metadata

  • 16.43 MB
  • 45466 rows
  • 24 columns
adult

Adult

belongs_to_collection

Belongs To Collection

budget

Budget

genres

Genres

homepage

Homepage

id

Id

imdb_id

Imdb Id

original_language

Original Language

original_title

Original Title

overview

Overview

popularity

Popularity

poster_path

Poster Path

production_companies

Production Companies

production_countries

Production Countries

release_date

Release Date

revenue

Revenue

runtime

Runtime

spoken_languages

Spoken Languages

status

Status

tagline

Tagline

title

Title

video

Video

vote_average

Vote Average

vote_count

Vote Count

False{'id': 10194, 'name': 'Toy Story Collection', 'poster_path': '/7G9915LfUQ2lVfwMEEhDsn3kT4B.jpg', 'backdrop_path': '/9FBwqcd9IRruEDUrTdcaafOMKUq.jpg'}30000000[{'id': 16, 'name': 'Animation'}, {'id': 35, 'name': 'Comedy'}, {'id': 10751, 'name': 'Family'}]http://toystory.disney.com/toy-story862tt0114709enToy StoryLed by Woody, Andy's toys live happily in his room until Andy's birthday brings Buzz Lightyear onto the scene. Afraid of losing his place in Andy's heart, Woody plots against Buzz. But when circumstances separate Buzz and Woody from their owner, the duo eventually learns to put aside their differenc…21.946943/rhIRbceoE9lR4veEXuwCC2wARtG.jpg[{'name': 'Pixar Animation Studios', 'id': 3}][{'iso_3166_1': 'US', 'name': 'United States of America'}]1995-10-3037355403381[{'iso_639_1': 'en', 'name': 'English'}]ReleasednanToy StoryFalse7.75415
Falsenan65000000[{'id': 12, 'name': 'Adventure'}, {'id': 14, 'name': 'Fantasy'}, {'id': 10751, 'name': 'Family'}]nan8844tt0113497enJumanjiWhen siblings Judy and Peter discover an enchanted board game that opens the door to a magical world, they unwittingly invite Alan -- an adult who's been trapped inside the game for 26 years -- into their living room. Alan's only hope for freedom is to finish the game, which proves risky as all thre…17.015539/vzmL6fP7aPKNKPRTFnZmiUfciyV.jpg[{'name': 'TriStar Pictures', 'id': 559}, {'name': 'Teitler Film', 'id': 2550}, {'name': 'Interscope Communications', 'id': 10201}][{'iso_3166_1': 'US', 'name': 'United States of America'}]1995-12-15262797249104[{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'fr', 'name': 'Français'}]ReleasedRoll the dice and unleash the excitement!JumanjiFalse6.92413
False{'id': 119050, 'name': 'Grumpy Old Men Collection', 'poster_path': '/nLvUdqgPgm3F85NMCii9gVFUcet.jpg', 'backdrop_path': '/hypTnLot2z8wpFS7qwsQHW1uV8u.jpg'}0[{'id': 10749, 'name': 'Romance'}, {'id': 35, 'name': 'Comedy'}]nan15602tt0113228enGrumpier Old MenA family wedding reignites the ancient feud between next-door neighbors and fishing buddies John and Max. Meanwhile, a sultry Italian divorcée opens a restaurant at the local bait shop, alarming the locals who worry she'll scare the fish away. But she's less interested in seafood than she is in cook…11.7129/6ksm1sjKMFLbO7UY2i6G1ju9SML.jpg[{'name': 'Warner Bros.', 'id': 6194}, {'name': 'Lancaster Gate', 'id': 19464}][{'iso_3166_1': 'US', 'name': 'United States of America'}]1995-12-22101[{'iso_639_1': 'en', 'name': 'English'}]ReleasedStill Yelling. Still Fighting. Still Ready for Love.Grumpier Old MenFalse6.592
Falsenan16000000[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'name': 'Drama'}, {'id': 10749, 'name': 'Romance'}]nan31357tt0114885enWaiting to ExhaleCheated on, mistreated and stepped on, the women are holding their breath, waiting for the elusive "good man" to break a string of less-than-stellar lovers. Friends and confidants Vannah, Bernie, Glo and Robin talk it all out, determined to find a better way to breathe.3.859495/16XOMpEaLWkrcPqSQqhTmeJuqQl.jpg[{'name': 'Twentieth Century Fox Film Corporation', 'id': 306}][{'iso_3166_1': 'US', 'name': 'United States of America'}]1995-12-2281452156127[{'iso_639_1': 'en', 'name': 'English'}]ReleasedFriends are the people who let you be yourself... and never let you forget it.Waiting to ExhaleFalse6.134
False{'id': 96871, 'name': 'Father of the Bride Collection', 'poster_path': '/nts4iOmNnq7GNicycMJ9pSAn204.jpg', 'backdrop_path': '/7qwE57OVZmMJChBpLEbJEmzUydk.jpg'}0[{'id': 35, 'name': 'Comedy'}]nan11862tt0113041enFather of the Bride Part IIJust when George Banks has recovered from his daughter's wedding, he receives the news that she's pregnant ... and that George's wife, Nina, is expecting too. He was planning on selling their home, but that's a plan that -- like George -- will have to change with the arrival of both a grandchild and…8.387519/e64sOI48hQXyru7naBFyssKFxVd.jpg[{'name': 'Sandollar Productions', 'id': 5842}, {'name': 'Touchstone Pictures', 'id': 9195}][{'iso_3166_1': 'US', 'name': 'United States of America'}]1995-02-1076578911106[{'iso_639_1': 'en', 'name': 'English'}]ReleasedJust When His World Is Back To Normal... He's In For The Surprise Of His Life!Father of the Bride Part IIFalse5.7173
Falsenan60000000[{'id': 28, 'name': 'Action'}, {'id': 80, 'name': 'Crime'}, {'id': 18, 'name': 'Drama'}, {'id': 53, 'name': 'Thriller'}]nan949tt0113277enHeatObsessive master thief, Neil McCauley leads a top-notch crew on various insane heists throughout Los Angeles while a mentally unstable detective, Vincent Hanna pursues him without rest. Each man recognizes and respects the ability and the dedication of the other even though they are aware their cat-…17.924927/zMyfPUelumio3tiDKPffaUpsQTD.jpg[{'name': 'Regency Enterprises', 'id': 508}, {'name': 'Forward Pass', 'id': 675}, {'name': 'Warner Bros.', 'id': 6194}][{'iso_3166_1': 'US', 'name': 'United States of America'}]1995-12-15187436818170[{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'es', 'name': 'Español'}]ReleasedA Los Angeles Crime SagaHeatFalse7.71886
Falsenan58000000[{'id': 35, 'name': 'Comedy'}, {'id': 10749, 'name': 'Romance'}]nan11860tt0114319enSabrinaAn ugly duckling having undergone a remarkable change, still harbors feelings for her crush: a carefree playboy, but not before his business-focused brother has something to say about it.6.677277/jQh15y5YB7bWz1NtffNZmRw0s9D.jpg[{'name': 'Paramount Pictures', 'id': 4}, {'name': 'Scott Rudin Productions', 'id': 258}, {'name': 'Mirage Enterprises', 'id': 932}, {'name': 'Sandollar Productions', 'id': 5842}, {'name': 'Constellation Entertainment', 'id': 14941}, {'name': 'Worldwide', 'id': 55873}, {'name': 'Mont Blanc Entertain…[{'iso_3166_1': 'DE', 'name': 'Germany'}, {'iso_3166_1': 'US', 'name': 'United States of America'}]1995-12-15127[{'iso_639_1': 'fr', 'name': 'Français'}, {'iso_639_1': 'en', 'name': 'English'}]ReleasedYou are cordially invited to the most surprising merger of the year.SabrinaFalse6.2141
Falsenan0[{'id': 28, 'name': 'Action'}, {'id': 12, 'name': 'Adventure'}, {'id': 18, 'name': 'Drama'}, {'id': 10751, 'name': 'Family'}]nan45325tt0112302enTom and HuckA mischievous young boy, Tom Sawyer, witnesses a murder by the deadly Injun Joe. Tom becomes friends with Huckleberry Finn, a boy with no future and no family. Tom has to choose between honoring a friendship or honoring an oath because the town alcoholic is accused of the murder. Tom and Huck go thr…2.561161/sGO5Qa55p7wTu7FJcX4H4xIVKvS.jpg[{'name': 'Walt Disney Pictures', 'id': 2}][{'iso_3166_1': 'US', 'name': 'United States of America'}]1995-12-2297[{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'de', 'name': 'Deutsch'}]ReleasedThe Original Bad Boys.Tom and HuckFalse5.445
Falsenan35000000[{'id': 28, 'name': 'Action'}, {'id': 12, 'name': 'Adventure'}, {'id': 53, 'name': 'Thriller'}]nan9091tt0114576enSudden DeathInternational action superstar Jean Claude Van Damme teams with Powers Boothe in a Tension-packed, suspense thriller, set against the back-drop of a Stanley Cup game.Van Damme portrays a father whose daughter is suddenly taken during a championship hockey game. With the captors demanding a billion d…5.23158/eoWvKD60lT95Ss1MYNgVExpo5iU.jpg[{'name': 'Universal Pictures', 'id': 33}, {'name': 'Imperial Entertainment', 'id': 21437}, {'name': 'Signature Entertainment', 'id': 23770}][{'iso_3166_1': 'US', 'name': 'United States of America'}]1995-12-2264350171106[{'iso_639_1': 'en', 'name': 'English'}]ReleasedTerror goes into overtime.Sudden DeathFalse5.5174
False{'id': 645, 'name': 'James Bond Collection', 'poster_path': '/HORpg5CSkmeQlAolx3bKMrKgfi.jpg', 'backdrop_path': '/6VcVl48kNKvdXOZfJPdarlUGOsk.jpg'}58000000[{'id': 12, 'name': 'Adventure'}, {'id': 28, 'name': 'Action'}, {'id': 53, 'name': 'Thriller'}]http://www.mgm.com/view/movie/757/Goldeneye/710tt0113189enGoldenEyeJames Bond must unmask the mysterious head of the Janus Syndicate and prevent the leader from utilizing the GoldenEye weapons system to inflict devastating revenge on Britain.14.686036/5c0ovjT41KnYIHYuF4AWsTe3sKh.jpg[{'name': 'United Artists', 'id': 60}, {'name': 'Eon Productions', 'id': 7576}][{'iso_3166_1': 'GB', 'name': 'United Kingdom'}, {'iso_3166_1': 'US', 'name': 'United States of America'}]1995-11-16352194034130[{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'ru', 'name': 'Pусский'}, {'iso_639_1': 'es', 'name': 'Español'}]ReleasedNo limits. No fears. No substitutes.GoldenEyeFalse6.61194

CREATE TABLE movies_metadata (
  "adult" VARCHAR,
  "belongs_to_collection" VARCHAR,
  "budget" VARCHAR,
  "genres" VARCHAR,
  "homepage" VARCHAR,
  "id" VARCHAR,
  "imdb_id" VARCHAR,
  "original_language" VARCHAR,
  "original_title" VARCHAR,
  "overview" VARCHAR,
  "popularity" VARCHAR,
  "poster_path" VARCHAR,
  "production_companies" VARCHAR,
  "production_countries" VARCHAR,
  "release_date" VARCHAR,
  "revenue" DOUBLE,
  "runtime" DOUBLE,
  "spoken_languages" VARCHAR,
  "status" VARCHAR,
  "tagline" VARCHAR,
  "title" VARCHAR,
  "video" VARCHAR,
  "vote_average" DOUBLE,
  "vote_count" DOUBLE
);

Share link

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