Netflix TV Shows And Movies

Movies and TV Shows listings on Netflix (July, 2022)

@kaggle.victorsoeiro_netflix_tv_shows_and_movies

Table List

2 tables(3.21 MB)

Titles

@kaggle.victorsoeiro_netflix_tv_shows_and_movies.titles

1.22 MB
5850 rows
15 columns

id Id	title Title	type Type	description Description	release_year Release Year	age_certification Age Certification	runtime Runtime	genres Genres	production_countries Production Countries	seasons Seasons	imdb_id Imdb Id	imdb_score Imdb Score	imdb_votes Imdb Votes	tmdb_popularity Tmdb Popularity	tmdb_score Tmdb Score
ts300399	Five Came Back: The Reference Films	SHOW	This collection includes 12 World War II-era propaganda films — many of which are graphic and offensive — discussed in the docuseries "Five Came Back."	1945	TV-MA	51	['documentation']	['US']	1	nan			0.6
tm84618	Taxi Driver	MOVIE	A mentally unstable Vietnam War veteran works as a night-time taxi driver in New York City where the perceived decadence and sleaze feed his urge for violent action.	1976	R	114	['drama', 'crime']	['US']		tt0075314	8.2	808582	40.965	8.179
tm154986	Deliverance	MOVIE	Intent on seeing the Cahulawassee River before it's turned into one huge lake, outdoor fanatic Lewis Medlock takes his friends on a river-rafting trip they'll never forget into the dangerous American back-country.	1972	R	109	['drama', 'action', 'thriller', 'european']	['US']		tt0068473	7.7	107673	10.01	7.3
tm127384	Monty Python and the Holy Grail	MOVIE	King Arthur, accompanied by his squire, recruits his Knights of the Round Table, including Sir Bedevere the Wise, Sir Lancelot the Brave, Sir Robin the Not-Quite-So-Brave-As-Sir-Lancelot and Sir Galahad the Pure. On the way, Arthur battles the Black Knight who, despite having had all his limbs chopp…	1975	PG	91	['fantasy', 'action', 'comedy']	['GB']		tt0071853	8.2	534486	15.461	7.811
tm120801	The Dirty Dozen	MOVIE	12 American military prisoners in World War II are ordered to infiltrate a well-guarded enemy château and kill the Nazi officers vacationing there. The soldiers, most of whom are facing death sentences for a variety of violent crimes, agree to the mission and the possible commuting of their sentence…	1967	nan	150	['war', 'action']	['GB', 'US']		tt0061578	7.7	72662	20.398	7.6
ts22164	Monty Python's Flying Circus	SHOW	A British sketch comedy series with the shows being composed of surreality, risqué or innuendo-laden humour, sight gags and observational sketches without punchlines.	1969	TV-14	30	['comedy', 'european']	['GB']	4	tt0063929	8.8	73424	17.617	8.306
tm70993	Life of Brian	MOVIE	Brian Cohen is an average young Jewish man, but through a series of ridiculous events, he gains a reputation as the Messiah. When he's not dodging his followers or being scolded by his shrill mother, the hapless Brian has to contend with the pompous Pontius Pilate and acronym-obsessed members of a s…	1979	R	94	['comedy']	['GB']		tt0079470	8	395024	17.77	7.8
tm14873	Dirty Harry	MOVIE	When a madman dubbed 'Scorpio' terrorizes San Francisco, hard-nosed cop, Harry Callahan – famous for his take-no-prisoners approach to law enforcement – is tasked with hunting down the psychopath. Harry eventually collars Scorpio in the process of rescuing a kidnap victim, only to see him walk on te…	1971	R	102	['thriller', 'action', 'crime']	['US']		tt0066999	7.7	155051	12.817	7.5
tm119281	Bonnie and Clyde	MOVIE	In the 1930s, bored waitress Bonnie Parker falls in love with an ex-con named Clyde Barrow and together they start a violent crime spree through the country, stealing cars and robbing banks.	1967	R	110	['crime', 'drama', 'action']	['US']		tt0061418	7.7	112048	15.687	7.5
tm98978	The Blue Lagoon	MOVIE	Two small children and a ship's cook survive a shipwreck and find safety on an idyllic tropical island. Soon, however, the cook dies and the young boy and girl are left on their own. Days become years and Emmeline and Richard make a home for themselves surrounded by exotic creatures and nature's bea…	1980	R	104	['romance', 'action', 'drama']	['US']		tt0080453	5.8	69844	50.324	6.156


CREATE TABLE titles (
  "id" VARCHAR,
  "title" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR,
  "release_year" BIGINT,
  "age_certification" VARCHAR,
  "runtime" BIGINT,
  "genres" VARCHAR,
  "production_countries" VARCHAR,
  "seasons" DOUBLE,
  "imdb_id" VARCHAR,
  "imdb_score" DOUBLE,
  "imdb_votes" DOUBLE,
  "tmdb_popularity" DOUBLE,
  "tmdb_score" DOUBLE
);