Letterboxd Movie Ratings Data

Scraped letterboxd ratings data with users/ratings/movie data.

@kaggle.samlearner_letterboxd_movie_ratings_data

Table List

3 tables(246.44 MB)

Movie Data

Ratings Export

Users Export

Movie Data

@kaggle.samlearner_letterboxd_movie_ratings_data.movie_data

82.53 MB
285963 rows
19 columns

n__id Id	genres Genres	image_url Image Url	imdb_id Imdb Id	imdb_link Imdb Link	movie_id Movie Id	movie_title Movie Title	original_language Original Language	overview Overview	popularity Popularity	production_countries Production Countries	release_date Release Date	runtime Runtime	spoken_languages Spoken Languages	tmdb_id Tmdb Id	tmdb_link Tmdb Link	vote_average Vote Average	vote_count Vote Count	year_released Year Released
5fc85f606758f69634496fd3	["Music","Animation"]	film-poster/4/6/4/4/4/0/464440-football-freaks-0-230-0-345-crop	nan	nan	football-freaks	Football Freaks	en	Football crazy, football mad. Don’t watch this off-beat jukebox cartoon expecting any conventional soccer action. Equal parts Disney, Dali and Duchamp, this abstract mix of black and white photos and alternative comix style animation is accompanied by a medley of doo-wop classics and documentary sou…	0.6	["United Kingdom"]	Sun Dec 05 1971 00:00:00 GMT+0000 (Coordinated Universal Time)		[]	535272	https://www.themoviedb.org/movie/535272/			1971
5fc85ff26758f696344ace0c	[]	film-poster/2/4/5/5/0/0/245500-aftermath-0-230-0-345-crop	tt0586129	http://www.imdb.com/title/tt0586129/maindetails	aftermath-1960	Aftermath	en	Aftermath was the pilot for an unsold TV series called The Code of Jonathan West; it aired as part of The General Electric Theater. The film takes place just after the Civil War, in a small southern town – war-ravaged, impoverished, and seething with hatred and resentment.	0.6	[]	Sun Apr 17 1960 00:00:00 GMT+0000 (Coordinated Universal Time)	22	[]	318331	https://www.themoviedb.org/movie/318331/	8	1	1960
5fc85f606758f69634496fcd	["Drama"]	film-poster/9/3/3/1/8/93318-where-chimneys-are-seen-0-230-0-345-crop	tt0045731	http://www.imdb.com/title/tt0045731/maindetails	where-chimneys-are-seen	Where Chimneys Are Seen	ja	Gosho’s most celebrated film both in Japan and the West, Where Chimneys Are Seen is perhaps the most compelling example of his concern for, and insights into, the everyday lives of lower-middle-class people. Based on Rinzo Shiina’s novel of the absurd, the film depicts the lives of two couples again…	1.568	["Japan"]	Thu Mar 05 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	108	["日本語"]	117779	https://www.themoviedb.org/movie/117779/	6.6	10	1953
5fc85f606758f69634496fd1	["Drama"]	nan	tt0187327	http://www.imdb.com/title/tt0187327/maindetails	the-musicians-daughter	The Musician's Daughter	en	Carl Wagner's good wife was dying. His heart bled at the thought of losing her, his life-long loyal helpmate. And his opera was almost completed, after spending months of weary hours to make it perfect. A pretty daughter tried in vain to brighten the overhanging gloom. Finally the composer, after a …	0.6	["United States of America"]	Tue Dec 12 1911 00:00:00 GMT+0000 (Coordinated Universal Time)	15	[]	560377	https://www.themoviedb.org/movie/560377/			1911
5fc85f606758f69634496fd4	["Documentary"]	film-poster/4/5/4/6/0/3/454603-50-years-of-fabulous-0-230-0-345-crop	tt4769914	http://www.imdb.com/title/tt4769914/maindetails	50-years-of-fabulous	50 Years of Fabulous	en	50 Years of Fabulous recounts the rich history of the Imperial Council, the oldest LGBT charity organization in the world. Founded in San Francisco by renown activist, drag queen and performer Jose Sarria, the Council has helped shaped LGBT life and social history in San Francisco and beyond through…	0.6	[]	Thu May 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	75	[]	525187	https://www.themoviedb.org/movie/525187/			2018
5fc85ff26758f696344ace3a	["Romance"]	film-poster/5/6/1/5/2/56152-where-love-has-gone-0-230-0-345-crop	tt0058745	http://www.imdb.com/title/tt0058745/maindetails	where-love-has-gone	Where Love Has Gone	en	A divorced couple's teen-age daughter stands trial for stabbing her mother's latest lover.	2.304	["United States of America"]	Mon Nov 02 1964 00:00:00 GMT+0000 (Coordinated Universal Time)	111	["English"]	73348	https://www.themoviedb.org/movie/73348/	6.1	11	1964
5fc85ff26758f696344ace38	["Drama","Thriller"]	film-poster/4/7/8/4/4/5/478445-severance-0-230-0-345-crop	tt0096074	http://www.imdb.com/title/tt0096074/maindetails	severance-1988	Severance	en	Ray Ponti is a down and out father, a man trapped by his past and frightened of his future. Cly is a streetwise runaway, waiting tables by day and stripping by night. Both are fighting for existence in the slime-bowl of New York's gutters, where drugs and prostitution are the only currency. Ray is …	0.6	[]	Fri Jan 01 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	95	[]	549624	https://www.themoviedb.org/movie/549624/			1988
5fc85ff26758f696344ace53	[]	nan	tt9618868	http://www.imdb.com/title/tt9618868/maindetails	terra-di-transito	Terra di transito	it	nan	0.6	["Italy"]	Thu Sep 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)		[]	419541	https://www.themoviedb.org/movie/419541/	5	2	2014
5fc85ff26758f696344ace64	["Music","Documentary"]	film-poster/1/1/2/2/5/4/112254-mc5-kick-out-the-jams-0-230-0-345-crop	tt0477449	http://www.imdb.com/title/tt0477449/maindetails	mc5-kick-out-the-jams	MC5: Kick Out the Jams	en	Kick Out the Jams features many never before seen films of the MC5 as created by Leni Sinclair & conceptual artist Cary Loren during the peak of their career.	0.6	[]	Tue Sep 07 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	40	["English"]	148778	https://www.themoviedb.org/movie/148778/	9	1	1999
5fc85ff26758f696344ace6c	["Drama"]	film-poster/2/2/6/2/1/7/226217-sharing-the-secret-0-230-0-345-crop	tt0240894	http://www.imdb.com/title/tt0240894/maindetails	sharing-the-secret	Sharing the Secret	en	A teenage girl who feels she must always seem happy for her parents and friends secretly binges and purges.	3.531	["United States of America"]	Wed May 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	90	["English"]	299024	https://www.themoviedb.org/movie/299024/	6.9	10	2000


CREATE TABLE movie_data (
  "n__id" VARCHAR,
  "genres" VARCHAR,
  "image_url" VARCHAR,
  "imdb_id" VARCHAR,
  "imdb_link" VARCHAR,
  "movie_id" VARCHAR,
  "movie_title" VARCHAR,
  "original_language" VARCHAR,
  "overview" VARCHAR,
  "popularity" DOUBLE,
  "production_countries" VARCHAR,
  "release_date" TIMESTAMP,
  "runtime" DOUBLE,
  "spoken_languages" VARCHAR,
  "tmdb_id" DOUBLE,
  "tmdb_link" VARCHAR,
  "vote_average" DOUBLE,
  "vote_count" DOUBLE,
  "year_released" DOUBLE
);