Michael Nocito / Analyst Portfolio
Portfolio / Hidden Gem Movies

Hidden Gem Movies

Tools   SQL, SQLite, DB Browser
Data   IMDb's full catalogue, 12.6 million titles
What it is   Filtering at scale, and defending every threshold
Out of 751,802 movies, only 347,689 have ever been rated by anyone. Exactly 581 clear every bar.
12.6M
Titles in the catalogue
751,802
Are movies
347,689
Have any rating
581
Hidden gems

The definition, and why each part of it is there

A hidden gem here is a film rated 8.0 or higher, with between 5,000 and 50,000 votes, a runtime of 60 minutes or more, and no adult classification. Every one of those numbers is a decision I have to be able to defend.

RuleWhy
Rated 8.0 or higherThe average movie scores 6.13, so 8.0 is genuinely well above the middle rather than just above average
At least 5,000 votesBelow this a score is a handful of opinions and moves with a single review
At most 50,000 votesAbove this a film is not hidden. This is the line that defines the whole project
60 minutes or moreKeeps shorts and TV segments out of a list about films
No adult titlesDifferent audience, different rating behaviour

The upper vote cap is the one worth arguing about. Move it to 100,000 and the list roughly doubles while getting less hidden. Move it to 20,000 and it shrinks to films almost nobody can find. 50,000 is my call, and the reason it is defensible is that I can say what changes on either side of it.

What the shape of the data does to the question

More than half of IMDb has never been rated at all. That single fact reframes the project. The question is not which films are underrated. It is which films got just enough attention to be judged, and no more.

What I checked

Vote count is a proxy for fame, not a measure of it. A film can be widely watched and rarely rated. IMDb voting skews toward certain audiences and certain eras. The list is honest about what it is, which is films with high scores and low vote counts.

The list skews toward non-English cinema. That is a real finding rather than a fault. Films outside the English-language market clear the "loved but not widely rated" bar far more often, because the rating population is smaller.