IMDb Top 10,000 adjusted to my specifications (Part I)

Created by LeSchpountz.
Favorited 2 times, disliked 0 times, added to 2 watchlists.
.
A little number game. What have I done?
.
On April 9, 2023 I pulled data from IMDb ( www.imdb.com/interfaces/ ). Now the data does not all fit in a csv or excel file. That's why I decided to use Power Pivot to filter out the film types (movie, short, tv-MiniSeries, tv-Movie) that are most important to me. So I had a list of over 90,000 films. (I only included films with at least 250 votes and a rating of 2.5).
.
Basically, my focus is on the type "movie".
.
Therefore, in the first step of my specification, I assigned malus points (penalty points, minus points) for "shorts", "tv-MiniSeries" and "tv-Movies" as well as for the genres "Adult" and "Documentary". In the case of the "shorts", the penalty points even increased the shorter the film is. In my opinion, I only accept a film that is longer than 5 minutes.
.
In the second step, I gave plus and minus points depending on data ("most favorite movies" and "most official lists") on ICM ( www.icheckmovies.com/ ).
.
In the third step, I then also added a weighting by year to account for the significant distortion of timeliness in online vote counts. This weight was "votes x (1+((1977 minus the release year of the movie)/100)". I copied this great idea (adapted a bit at my discretion) from the Letterboxd user Prof. Ratigan.
.
I chose the year 1977 because from 1977 the VHS format for video recorders became more and more established and the home video recorder market became established as a result.
.
In the fourth step, I used the IMDb formula* for the "weighted rating" to adjust the film rating I had already specified.
.
*weighted rating (WR) = (v ÷ (v+m)) × R + (m ÷ (v+m)) × C
where:
R = my specified average for the movie (mean) = (Rating)
v = my specified number of votes for the movie = (votes)
m = minimum votes required to be listed in the Top 10,000 (currently 999)
C = the minimum vote across the whole report (currently 4.9)
.
And now the following is the result, have fun with it.
Filter
-
1 new
The Shawshank Redemption
1994, in 24 top lists Check -
2 new
The Godfather
1972, in 42 top lists Check -
3 new
Schindler's List
1993, in 35 top lists Check -
4 new
The Lord of the Rings: The Return of the King
2003, in 29 top lists Check -
5 new
The Godfather Part II
1974, in 32 top lists Check -
6 new
The Dark Knight
2008, in 27 top lists Check -
7 new
12 Angry Men
1957, in 30 top lists Check -
8 new
Pulp Fiction
1994, in 38 top lists Check -
9 new
The Lord of the Rings: The Fellowship of the Ring
2001, in 31 top lists Check -
10 new
The Lord of the Rings: The Two Towers
2002, in 26 top lists Check -
11 new
Il buono, il brutto, il cattivo
1966 — a.k.a. The Good, the Bad and the Ugly, in 28 top lists Check -
12 new
Forrest Gump
1994, in 25 top lists Check -
13 new
Inception
2010, in 21 top lists Check -
14 new
Fight Club
1999, in 19 top lists Check -
15 new
One Flew Over the Cuckoo's Nest
1975, in 35 top lists Check -
16 new
Goodfellas
1990, in 31 top lists Check -
17 new
The Matrix
1999, in 30 top lists Check -
18 new
Star Wars: Episode V - The Empire Strikes Back
1980, in 25 top lists Check -
19 new
Star Wars
1977, in 40 top lists Check -
20 new
Sen to Chihiro no kamikakushi
2001 — a.k.a. Spirited Away, in 39 top lists Check -
21 new
The Silence of the Lambs
1991, in 36 top lists Check -
22 new
Shichinin no samurai
1954 — a.k.a. Seven Samurai, in 36 top lists Check -
23 new
Saving Private Ryan
1998, in 28 top lists Check -
24 new
Se7en
1995, in 29 top lists Check -
25 new
It's a Wonderful Life
1946, in 33 top lists Check -
26 new
Terminator 2: Judgment Day
1991, in 25 top lists Check -
27 new
Cidade de Deus
2002 — a.k.a. City of God, in 22 top lists Check -
28 new
La vita è bella
1997 — a.k.a. Life Is Beautiful, in 22 top lists Check -
29 new
The Green Mile
1999, in 15 top lists Check -
30 new
Interstellar
2014, in 13 top lists Check -
31 new
Apocalypse Now
1979, in 37 top lists Check -
32 new
Psycho
1960, in 39 top lists Check -
33 new
Casablanca
1942, in 39 top lists Check -
34 new
Gladiator
2000, in 25 top lists Check -
35 new
Alien
1979, in 30 top lists Check -
36 new
Back to the Future
1985, in 25 top lists Check -
37 new
Rear Window
1954, in 31 top lists Check -
38 new
The Departed
2006, in 20 top lists Check -
39 new
C'era una volta il West
1968 — a.k.a. Once Upon a Time in the West, in 28 top lists Check -
40 new
Léon
1994 — a.k.a. Léon: The Professional, in 23 top lists Check -
41 new
The Usual Suspects
1995, in 24 top lists Check -
42 new
The Pianist
2002, in 21 top lists Check -
43 new
The Lion King
1994, in 24 top lists Check -
44 new
Seppuku
1962 — a.k.a. Hara-Kiri, in 16 top lists Check -
45 new
Modern Times
1936, in 30 top lists Check -
46 new
City Lights
1931, in 34 top lists Check -
47 new
Gisaengchung
2019 — a.k.a. Parasite, in 22 top lists -
48 new
The Prestige
2006, in 14 top lists Check -
49 new
Nuovo Cinema Paradiso
1988 — a.k.a. Cinema Paradiso, in 19 top lists Check -
50 new
Hotaru no haka
1988 — a.k.a. Grave of the Fireflies, in 21 top lists Check