diff options
author | William Carroll <wpcarro@gmail.com> | 2020-07-26T09·23+0100 |
---|---|---|
committer | William Carroll <wpcarro@gmail.com> | 2020-07-26T09·23+0100 |
commit | d3a337199a4567fe1b3d1c55aab399334d598610 (patch) | |
tree | 27f3c8780a3df6c3cf5f5e89a5a2a64be05ee74d /todo-lists/imdb | |
parent | d0c1645c165d06bbcd3030a20859188b5149e908 (diff) |
Create SQLite database from unwatched movies in imdb-top-250.org
The astute observer may notice that the number of entries in db.sqlite3 is fewer than the number of unwatched movies in imdb-top-250.org. I'm at a lake in Germany with Mimi and Cullen, so we took the intersection of my unwatched movies, Mimi's unwatched movies, and Cullen's unwatched movies.
Diffstat (limited to 'todo-lists/imdb')
-rw-r--r-- | todo-lists/imdb/db.sql | 90 | ||||
-rw-r--r-- | todo-lists/imdb/db.sqlite3 | bin | 0 -> 8192 bytes | |||
-rw-r--r-- | todo-lists/imdb/imdb-top-250.org | 256 |
3 files changed, 346 insertions, 0 deletions
diff --git a/todo-lists/imdb/db.sql b/todo-lists/imdb/db.sql new file mode 100644 index 000000000000..9fa3818a4f84 --- /dev/null +++ b/todo-lists/imdb/db.sql @@ -0,0 +1,90 @@ +CREATE TABLE IF NOT EXISTS Movies ( + title TEXT NOT NULL, + year INTEGER, + PRIMARY KEY (title) +); + +INSERT INTO Movies (title, year) VALUES ('Spirited Away', 2001); +INSERT INTO Movies (title, year) VALUES ('Andhadhun', 2018); +INSERT INTO Movies (title, year) VALUES ('Dangal', 2016); +INSERT INTO Movies (title, year) VALUES ('Avengers: Infinity War', 2019); +INSERT INTO Movies (title, year) VALUES ('Alien', 1979); +INSERT INTO Movies (title, year) VALUES ('The Great Dictator', 1940); +INSERT INTO Movies (title, year) VALUES ('City Lights', 1931); +INSERT INTO Movies (title, year) VALUES ('Kimi no na wa.', NULL); +INSERT INTO Movies (title, year) VALUES ('Taare Zameen Par', 2007); +INSERT INTO Movies (title, year) VALUES ('Babam ve Oglum', 2005); +INSERT INTO Movies (title, year) VALUES ('Aliens', 1986); +INSERT INTO Movies (title, year) VALUES ('Das Boot', 1981); +INSERT INTO Movies (title, year) VALUES ('Witness for the Prosecution', 1957); +INSERT INTO Movies (title, year) VALUES ('Sunset Blvd.', 1950); +INSERT INTO Movies (title, year) VALUES ('Neon Genesis Evangelion: The End of Evangelion', 2005); +INSERT INTO Movies (title, year) VALUES ('Children of Heaven', 1999); +INSERT INTO Movies (title, year) VALUES ('The Bandit', 1996); +INSERT INTO Movies (title, year) VALUES ('To Kill a Mockingbird', 1962); +INSERT INTO Movies (title, year) VALUES ('Lawrence of Arabia', 1962); +INSERT INTO Movies (title, year) VALUES ('Yojimbo', 1961); +INSERT INTO Movies (title, year) VALUES ('North by Northwest', 1959); +INSERT INTO Movies (title, year) VALUES ('Vertigo', 1958); +INSERT INTO Movies (title, year) VALUES ('Singing in the Rain', 1952); +INSERT INTO Movies (title, year) VALUES ('Ikiru', 1952); +INSERT INTO Movies (title, year) VALUES ('Rashomon', 1950); +INSERT INTO Movies (title, year) VALUES ('All About Eve', 1950); +INSERT INTO Movies (title, year) VALUES ('Double Indemnity', 1944); +INSERT INTO Movies (title, year) VALUES ('Citizen Kane', 1941); +INSERT INTO Movies (title, year) VALUES ('M', NULL); +INSERT INTO Movies (title, year) VALUES ('Metropolis', 1927); +INSERT INTO Movies (title, year) VALUES ('The Kid', 1921); +INSERT INTO Movies (title, year) VALUES ('PK', 2014); +INSERT INTO Movies (title, year) VALUES ('Rang De Basanti', 2006); +INSERT INTO Movies (title, year) VALUES ('Howls Moving Castle', 2004); +INSERT INTO Movies (title, year) VALUES ('Come and See', 1985); +INSERT INTO Movies (title, year) VALUES ('Ran', NULL); +INSERT INTO Movies (title, year) VALUES ('Andrei Rublev', 1966); +INSERT INTO Movies (title, year) VALUES ('Judgment at Nuremberg', 1961); +INSERT INTO Movies (title, year) VALUES ('Some Like It Hot', 1959); +INSERT INTO Movies (title, year) VALUES ('Wild Strawberries', 1957); +INSERT INTO Movies (title, year) VALUES ('The Seventh Seal', 1957); +INSERT INTO Movies (title, year) VALUES ('The Bridge on the River Kwai', 1957); +INSERT INTO Movies (title, year) VALUES ('On the Waterfront', 1954); +INSERT INTO Movies (title, year) VALUES ('Dial M for Murder', 1954); +INSERT INTO Movies (title, year) VALUES ('Tokyo Story', 1953); +INSERT INTO Movies (title, year) VALUES ('The Third Man', 1949); +INSERT INTO Movies (title, year) VALUES ('The Treasure of the Sierra Madre', 1948); +INSERT INTO Movies (title, year) VALUES ('Mr. Smith Goes to Washington', 1939); +INSERT INTO Movies (title, year) VALUES ('Sunrise: A Song of Two Humans', 1927); +INSERT INTO Movies (title, year) VALUES ('The General', 1926); +INSERT INTO Movies (title, year) VALUES ('The Gold Rush', 1925); +INSERT INTO Movies (title, year) VALUES ('Sherlock Jr.', 1924); +INSERT INTO Movies (title, year) VALUES ('Wild Tales', 2014); +INSERT INTO Movies (title, year) VALUES ('Hacksaw Ridge', 2016); +INSERT INTO Movies (title, year) VALUES ('Song of the Sea', 2014); +INSERT INTO Movies (title, year) VALUES ('The Help', 2011); +INSERT INTO Movies (title, year) VALUES ('Before Sunset', 2004); +INSERT INTO Movies (title, year) VALUES ('Memories of Murder', 2003); +INSERT INTO Movies (title, year) VALUES ('In the Mood for Love', 2000); +INSERT INTO Movies (title, year) VALUES ('La Haine', 1995); +INSERT INTO Movies (title, year) VALUES ('Before Sunrise', 1995); +INSERT INTO Movies (title, year) VALUES ('Three Colours: Red', 1994); +INSERT INTO Movies (title, year) VALUES ('Akira', 1988); +INSERT INTO Movies (title, year) VALUES ('Laputa: Castle in the Sky', 1986); +INSERT INTO Movies (title, year) VALUES ('Paris, Texas', 1984); +INSERT INTO Movies (title, year) VALUES ('Nausicaa of the Valley of the Wind', 1984); +INSERT INTO Movies (title, year) VALUES ('Gandhi', 1982); +INSERT INTO Movies (title, year) VALUES ('Fanny and Alexander', 1982); +INSERT INTO Movies (title, year) VALUES ('Stalker', 1979); +INSERT INTO Movies (title, year) VALUES ('Rocky', 1976); +INSERT INTO Movies (title, year) VALUES ('Network', 1976); +INSERT INTO Movies (title, year) VALUES ('Butch Cassidy and the Sundance Kid', 1969); +INSERT INTO Movies (title, year) VALUES ('Persona', 1966); +INSERT INTO Movies (title, year) VALUES ('The 400 Blows', 1959); +INSERT INTO Movies (title, year) VALUES ('Ben-Hur', 1959); +INSERT INTO Movies (title, year) VALUES ('The Nights of Cabiria', 1957); +INSERT INTO Movies (title, year) VALUES ('Les Diaboliques', 1955); +INSERT INTO Movies (title, year) VALUES ('The Wages of Fear', 1953); +INSERT INTO Movies (title, year) VALUES ('The Best Years of Our Lives', 1946); +INSERT INTO Movies (title, year) VALUES ('The Maltese Falcon', 1941); +INSERT INTO Movies (title, year) VALUES ('Rebecca', NULL); +INSERT INTO Movies (title, year) VALUES ('The Grapes of Wrath', 1940); +INSERT INTO Movies (title, year) VALUES ('It Happened One Night', 1934); +INSERT INTO Movies (title, year) VALUES ('La passion de Jeanne dArc', 1928); diff --git a/todo-lists/imdb/db.sqlite3 b/todo-lists/imdb/db.sqlite3 new file mode 100644 index 000000000000..9c704810ab00 --- /dev/null +++ b/todo-lists/imdb/db.sqlite3 Binary files differdiff --git a/todo-lists/imdb/imdb-top-250.org b/todo-lists/imdb/imdb-top-250.org new file mode 100644 index 000000000000..59161eec2755 --- /dev/null +++ b/todo-lists/imdb/imdb-top-250.org @@ -0,0 +1,256 @@ +# A few years ago, I set a goal to watch every movie on IMDb.com's "Top 250" +# movies list. The list changes frequently, so I took a snapshot of it so that +# I wouldn't be trying to hit a moving target. +# +# Here is my progress thus far: +* IMDB Top 250 +** DONE The Shawshank Redemption +** DONE The Godfather +** DONE The Dark Knight +** DONE The Godfather: Part II +** DONE The Lord of the Rings: The Return of the King +** DONE Pulp Fiction +** DONE Schindler's List +** DONE The Good, the Bad and the Ugly +** DONE 12 Angry Men +** DONE Inception +** DONE Fight Club +** DONE The Lord of the Rings: The Fellowship of the Ring +** DONE Forrest Gump +** DONE The Lord of the Rings: The Two Towers +** DONE The Matrix +** DONE Goodfellas +** TODO Star Wars: Episode V - The Empire Strikes Back +** DONE One Flew Over the Cuckoo's Nest +** DONE Seven Samurai +** DONE Interstellar +** DONE City of God +** TODO Spirited Away +** DONE Saving Private Ryan +** DONE The Green Mile +** DONE Life Is Beautiful +** DONE The Usual Suspects +** DONE Se7en +** DONE Leon +** DONE The Silence of the Lambs +** TODO Star Wars: Episode IV - A New Hope +** DONE It's a Wonderful Life +** TODO Andhadhun +** TODO Dangal +** DONE Spider-Man: Into the Spider-Verse +** TODO Avengers: Infinity War +** DONE Whiplash +** DONE Untouchable +** DONE The Prestige +** DONE The Departed +** DONE The Pianist +** DONE Memento +** DONE Gladiator +** DONE American History X +** DONE The Lion King +** DONE Terminator 2: Judgment Day +** DONE Cinema Paradiso +** DONE Grave of the Fireflies +** DONE Back to the Future +** DONE Indiana Jones and the Raiders of the Lost Ark +** DONE Apocalypse Now +** TODO Alien +** DONE Once Upon a Time in the West +** DONE Psycho +** DONE Rear Window +** DONE Casablanca +** TODO The Great Dictator +** TODO Modern Times +** TODO City Lights +** TODO Kimi no na wa. +** DONE Coco +** DONE Django Unchained +** DONE The Dark Knight Rises +** DONE 3 Idiots +** TODO Taare Zameen Par +** DONE WALL·E +** TODO Babam ve Oglum +** DONE The Lives of Others +** DONE Old boy +** DONE American Beauty +** DONE Princess Mononoke +** DONE Braveheart +** TODO Aliens +** DONE Once Upon a Time in America +** TODO Das Boot +** DONE The Shining +** DONE Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb +** TODO Witness for the Prosecution +** DONE Paths of Glory +** TODO Sunset Blvd. +** DONE Green Book +** DONE The Hunt +** DONE Jodaeiye Nader az Simin +** DONE Incendies +** DONE Toy Story 3 +** DONE Inglourious Basterds +** DONE Eternal Sunshine of the Spotless Mind +** DONE Amelie +** DONE Snatch +** DONE Requiem for a Dream +** TODO Neon Genesis Evangelion: The End of Evangelion +** DONE L.A. Confidential +** DONE Good Will Hunting +** TODO Bacheha-Ye aseman +** TODO Eskiya +** DONE Toy Story +** DONE Reservoir Dogs +** DONE Full Metal Jacket +** DONE Amadeus +** DONE Scarface +** TODO Star Wars: Episode VI - Return of the Jedi +** DONE Taxi Driver +** DONE Monty Python and the Holy Grail +** DONE The Sting +** DONE A Clockwork Orange +** DONE 2001: A Space Odyssey +** TODO For a Few Dollars More +** TODO To Kill a Mockingbird +** TODO Lawrence of Arabia +** TODO Yojimbo +** DONE The Apartment +** TODO North by Northwest +** TODO Vertigo +** TODO Singin' in the Rain +** TODO Ikiru +** TODO Rashomon +** TODO All About Eve +** TODO Bicycle Thieves +** TODO Double Indemnity +** TODO Citizen Kane +** TODO M +** TODO Metropolis +** TODO The Kid +** DONE Three Billboards Outside Ebbing, Missouri +** DONE Room +** TODO PK +** DONE Inside Out +** DONE El secreto de sus ojos +** DONE Warrior +** DONE Up +** DONE The Wolf of Wall Street +** DONE There Will Be Blood +** DONE Pan's Labyrinth +** DONE V for Vendetta +** TODO Rang De Basanti +** DONE Batman Begins +** DONE Downfall +** TODO Howl's Moving Castle +** DONE A Beautiful Mind +** DONE Lock, Stock and Two Smoking Barrels +** DONE Trainspotting +** DONE Heat +** DONE Casino +** DONE Unforgiven +** TODO Indiana Jones and the Last Crusade +** DONE My Neighbour Totoro +** DONE Die Hard +** TODO Come and See +** TODO Ran +** DONE Blade Runner +** DONE Raging Bull +** TODO The Elephant Man +** DONE Chinatown +** TODO Andrei Rublev +** DONE The Great Escape +** TODO Judgment at Nuremberg +** TODO Some Like It Hot +** TODO Wild Strawberries +** TODO The Seventh Seal +** TODO The Bridge on the River Kwai +** TODO On the Waterfront +** TODO Dial M for Murder +** TODO Tokyo Story +** TODO The Third Man +** TODO The Treasure of the Sierra Madre +** TODO Mr. Smith Goes to Washington +** TODO Gone with the Wind +** TODO Sunrise: A Song of Two Humans +** TODO The General +** TODO The Gold Rush +** TODO Sherlock Jr. +** DONE The Handmaiden +** DONE Logan +** TODO Relatos salvajes +** DONE The Grand Budapest Hotel +** DONE Gone Girl +** TODO Hacksaw Ridge +** TODO 12 Years a Slave +** DONE Guardians of the Galaxy +** DONE Rush +** DONE Spotlight +** TODO Song of the Sea +** TODO The Help +** DONE Prisoners +** DONE Mad Max: Fury Road +** DONE Gran Torino +** TODO Harry Potter and the Deathly Hallows: Part 2 +** DONE Shutter Island +** DONE Hachi: A Dog's Tale +** DONE Mary and Max +** DONE How to Train Your Dragon +** DONE Into the Wild +** DONE No Country for Old Men +** DONE Million Dollar Baby +** DONE Hotel Rwanda +** TODO Before Sunset +** TODO Memories of Murder +** DONE Kill Bill: Vol. 1 +** DONE Finding Nemo +** DONE Catch Me If You Can +** TODO Donnie Darko +** DONE Amores Perros +** DONE Monsters, Inc. +** DONE The Sixth Sense +** DONE The Truman Show +** DONE The Big Lebowski +** TODO In the Mood for Love +** DONE Fargo +** TODO La Haine +** TODO Before Sunrise +** TODO Three Colours: Red +** DONE Jurassic Park +** DONE In the Name of the Father +** DONE Dead Poets Society +** TODO Akira +** DONE The Princess Bride +** TODO Laputa: Castle in the Sky +** DONE Stand by Me +** DONE Platoon +** TODO Paris, Texas +** TODO Nausicaa of the Valley of the Wind +** DONE The Thing +** TODO Gandhi +** TODO Fanny and Alexander +** TODO Stalker +** DONE Life of Brian +** DONE The Deer Hunter +** TODO Rocky +** TODO Network +** TODO Barry Lyndon +** TODO Butch Cassidy and the Sundance Kid +** DONE Cool Hand Luke +** TODO Persona +** TODO The 400 Blows +** TODO Ben-Hur +** TODO The Nights of Cabiria +** TODO Les Diaboliques +** TODO The Wages of Fear +** TODO The Best Years of Our Lives +** TODO The Maltese Falcon +** TODO Rebecca +** TODO The Grapes of Wrath +** TODO It Happened One Night +** TODO La passion de Jeanne d'Arc +** DONE Pirates of the Caribbean: The Curse of the Black Pearl +** DONE Groundhog Day +** DONE Beauty and the Beast +** DONE The Terminator +** DONE Jaws +** DONE The Exorcist +** DONE The Wizard of Oz |