IMDb Movies/Shows With Descriptions

Top 8k movies and/or tv shows with descriptions from the 90s and onwards

@kaggle.ishikajohari_imdb_data_with_descriptions

Table List

1 table(2.2 MB)

Imdb

@kaggle.ishikajohari_imdb_data_with_descriptions.imdb

2.2 MB
7850 rows
21 columns

unnamed_0 Unnamed: 0	index Index	tconst Tconst	titletype TitleType	primarytitle PrimaryTitle	originaltitle OriginalTitle	startyear StartYear	endyear EndYear	runtimeminutes RuntimeMinutes	genres Genres	averagerating AverageRating	numvotes NumVotes	ordering Ordering	title Title	region Region	language Language	types Types	attributes Attributes	description Description
		tt0102926	movie	The Silence of the Lambs	The Silence of the Lambs	1991	\N	118	Crime,Drama,Thriller	8.6	1473918	50	The Silence of the Lambs	US	en	\N	\N	Jodie Foster stars as Clarice Starling, a top student at the FBI's training academy. Jack Crawford (Scott Glenn) wants Clarice to interview Dr. Hannibal Lecter (Anthony Hopkins), a brilliant psychiatrist who is also a violent psychopath, serving life behind bars for various acts of murder and cannib…
1	1	tt0103064	movie	Terminator 2: Judgment Day	Terminator 2: Judgment Day	1991	\N	137	Action,Sci-Fi	8.6	1128166	17	Terminator 2: Judgment Day	US	en	dvd	\N	In this sequel set eleven years after "The Terminator," young John Connor (Edward Furlong), the key to civilization's victory over a future robot uprising, is the target of the shape-shifting T-1000 (Robert Patrick), a Terminator sent from the future to kill him. Another Terminator, the revamped T-8…
2	3	tt0110357	movie	The Lion King	The Lion King	1994	\N	88	Adventure,Animation,Drama	8.5	1090882	18	The Lion King 3D	US	en	\N	3-D version	This Disney animated feature follows the adventures of the young lion Simba (Jonathan Taylor Thomas), the heir of his father, Mufasa (James Earl Jones). Simba's wicked uncle, Scar (Jeremy Irons), plots to usurp Mufasa's throne by luring father and son into a stampede of wildebeests. But Simba escape…
3	4	tt0110912	movie	Pulp Fiction	Pulp Fiction	1994	\N	154	Crime,Drama	8.9	2118762	22	Pulp Fiction	US	en	\N	\N	Vincent Vega (John Travolta) and Jules Winnfield (Samuel L. Jackson) are hitmen with a penchant for philosophical discussions. In this ultra-hip, multi-strand crime movie, their storyline is interwoven with those of their boss, gangster Marsellus Wallace (Ving Rhames) ; his actress wife, Mia (Uma Th…
4	5	tt0111161	movie	The Shawshank Redemption	The Shawshank Redemption	1994	\N	142	Drama	9.3	2759621	2	The Shawshank Redemption	US	en	\N	\N	Andy Dufresne (Tim Robbins) is sentenced to two consecutive life terms in prison for the murders of his wife and her lover and is sentenced to a tough prison. However, only Andy knows he didn't commit the crimes. While there, he forms a friendship with Red (Morgan Freeman), experiences brutality of …
5	8	tt0120338	movie	Titanic	Titanic	1997	\N	194	Drama,Romance	7.9	1226536	1	Titanic	US	en	\N	\N	James Cameron's "Titanic" is an epic, action-packed romance set against the ill-fated maiden voyage of the R.M.S. Titanic; the pride and joy of the White Star Line and, at the time, the largest moving object ever built. She was the most luxurious liner of her era -- the "ship of dreams" -- which ult…
6	9	tt0121164	movie	Corpse Bride	Corpse Bride	2005	\N	77	Animation,Drama,Family	7.3	285146	36	Corpse Bride	US	en	\N	\N	Victor (Johnny Depp) and Victoria's (Emily Watson) families have arranged their marriage. Though they like each other, Victor is nervous about the ceremony. While he's in a forest practicing his lines for the wedding, a tree branch becomes a hand that drags him to the land of the dead. It belongs to…
7	14	tt0172495	movie	Gladiator	Gladiator	2000	\N	155	Action,Adventure,Drama	8.5	1542458	43	Gladiator	US	en	\N	\N	Commodus (Joaquin Phoenix) takes power and strips rank from Maximus (Russell Crowe), one of the favored generals of his predecessor and father, Emperor Marcus Aurelius, the great stoical philosopher. Maximus is then relegated to fighting to the death in the gladiator arenas.
8	15	tt0212720	movie	A.I. Artificial Intelligence	A.I. Artificial Intelligence	2001	\N	146	Drama,Sci-Fi	7.2	315458	25	A.I. Artificial Intelligence	US	en	\N	\N	A robotic boy, the first programmed to love, David (Haley Joel Osment) is adopted as a test case by a Cybertronics employee (Sam Robards) and his wife (Frances O'Connor). Though he gradually becomes their child, a series of unexpected circumstances make this life impossible for David. Without final …
9	16	tt0217930	tvMiniSeries	Egypt Uncovered	Egypt	1998	\N	\N	Documentary	8	69	9	Egypt Uncovered	US	en	\N	\N	Examines one of the most enduring civilizations in history.


CREATE TABLE imdb (
  "unnamed_0" BIGINT,
  "index" BIGINT,
  "tconst" VARCHAR,
  "titletype" VARCHAR,
  "primarytitle" VARCHAR,
  "originaltitle" VARCHAR,
  "isadult" BIGINT,
  "startyear" BIGINT,
  "endyear" VARCHAR,
  "runtimeminutes" VARCHAR,
  "genres" VARCHAR,
  "averagerating" DOUBLE,
  "numvotes" BIGINT,
  "ordering" BIGINT,
  "title" VARCHAR,
  "region" VARCHAR,
  "language" VARCHAR,
  "types" VARCHAR,
  "attributes" VARCHAR,
  "isoriginaltitle" BIGINT,
  "description" VARCHAR
);