Netflix Movies and Series
gonzandrobles·January 10, 2025
Description
Best movies and tv show on Netflix (May 2022)
Summary
This project contain 6 tables. The main 2 tables are raw_credits and raw_titles.
I build 4 different models using the raw tables.
- Best Movie by Year Netflix = this model contains the best movie by year. The criteria applied to consider this table is at least 25,000 votes ordered by imdb score ranking of 1.
- Best Show by Year Netflix = this model contains the best tv show by year. The criteria applied to consider this table is at least 25,000 votes ordered by imdb score ranking of 1.
- Best Movies Netflix = this model contains all the movies that pass the following criteria:
- at least an imdb score of 6.9
- at least 10,000 votes
- Best Shows Netflix = this model contains all the tv shows that pass the following criteria:
- at least an imdb score of 7.5
- at least 10,000 votes
Models created with dbt and tested in Snowflake.
Basic info
Author
gonzandrobles
Shared withEveryone
CreatedJuly 28, 2022
Size4 MB
LicensePublic Domain
Dictionary6 tables
Original URLGo to check
Published
netflix
movies
tvshow
public datasets
Advanced features