The Movies Dataset

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

@kaggle.rounakbanik_the_movies_dataset

Table List

7 tables(246.68 MB)

Credits

Links

Ratings

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-story	862	tt0114709	en	Toy Story	Led 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-30	373554033	81	[{'iso_639_1': 'en', 'name': 'English'}]	Released	nan	Toy Story	False	7.7	5415
False	nan	65000000	[{'id': 12, 'name': 'Adventure'}, {'id': 14, 'name': 'Fantasy'}, {'id': 10751, 'name': 'Family'}]	nan	8844	tt0113497	en	Jumanji	When 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-15	262797249	104	[{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'fr', 'name': 'Français'}]	Released	Roll the dice and unleash the excitement!	Jumanji	False	6.9	2413
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'}]	nan	15602	tt0113228	en	Grumpier Old Men	A 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-22		101	[{'iso_639_1': 'en', 'name': 'English'}]	Released	Still Yelling. Still Fighting. Still Ready for Love.	Grumpier Old Men	False	6.5	92
False	nan	16000000	[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'name': 'Drama'}, {'id': 10749, 'name': 'Romance'}]	nan	31357	tt0114885	en	Waiting to Exhale	Cheated 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-22	81452156	127	[{'iso_639_1': 'en', 'name': 'English'}]	Released	Friends are the people who let you be yourself... and never let you forget it.	Waiting to Exhale	False	6.1	34
False	{'id': 96871, 'name': 'Father of the Bride Collection', 'poster_path': '/nts4iOmNnq7GNicycMJ9pSAn204.jpg', 'backdrop_path': '/7qwE57OVZmMJChBpLEbJEmzUydk.jpg'}	0	[{'id': 35, 'name': 'Comedy'}]	nan	11862	tt0113041	en	Father of the Bride Part II	Just 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-10	76578911	106	[{'iso_639_1': 'en', 'name': 'English'}]	Released	Just When His World Is Back To Normal... He's In For The Surprise Of His Life!	Father of the Bride Part II	False	5.7	173
False	nan	60000000	[{'id': 28, 'name': 'Action'}, {'id': 80, 'name': 'Crime'}, {'id': 18, 'name': 'Drama'}, {'id': 53, 'name': 'Thriller'}]	nan	949	tt0113277	en	Heat	Obsessive 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-15	187436818	170	[{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'es', 'name': 'Español'}]	Released	A Los Angeles Crime Saga	Heat	False	7.7	1886
False	nan	58000000	[{'id': 35, 'name': 'Comedy'}, {'id': 10749, 'name': 'Romance'}]	nan	11860	tt0114319	en	Sabrina	An 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-15		127	[{'iso_639_1': 'fr', 'name': 'Français'}, {'iso_639_1': 'en', 'name': 'English'}]	Released	You are cordially invited to the most surprising merger of the year.	Sabrina	False	6.2	141
False	nan	0	[{'id': 28, 'name': 'Action'}, {'id': 12, 'name': 'Adventure'}, {'id': 18, 'name': 'Drama'}, {'id': 10751, 'name': 'Family'}]	nan	45325	tt0112302	en	Tom and Huck	A 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-22		97	[{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'de', 'name': 'Deutsch'}]	Released	The Original Bad Boys.	Tom and Huck	False	5.4	45
False	nan	35000000	[{'id': 28, 'name': 'Action'}, {'id': 12, 'name': 'Adventure'}, {'id': 53, 'name': 'Thriller'}]	nan	9091	tt0114576	en	Sudden Death	International 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-22	64350171	106	[{'iso_639_1': 'en', 'name': 'English'}]	Released	Terror goes into overtime.	Sudden Death	False	5.5	174
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/	710	tt0113189	en	GoldenEye	James 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-16	352194034	130	[{'iso_639_1': 'en', 'name': 'English'}, {'iso_639_1': 'ru', 'name': 'Pусский'}, {'iso_639_1': 'es', 'name': 'Español'}]	Released	No limits. No fears. No substitutes.	GoldenEye	False	6.6	1194


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