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

Raw Data Source

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
Publishedimage
netflix
movies
tvshow
public datasets
Advanced features
Insights
What columns are included in the document?
How many rows does the document contain?
Based on the provided information of the dataset, would it be possible to provide some relevant inquiries?

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

Raw Data Source

Models created with dbt and tested in Snowflake.

Scan the QR code to ask more questions about the paper
© 2025 Powerdrill. All rights reserved.