Dataset: Full TMDb TV Shows Dataset 2024 (150K Shows)

About this Dataset

Full TMDb TV Shows Dataset 2024 (150K Shows)

The TMDB (The Movie Database) is a widely-used resource for movie and TV show data, providing valuable information such as ratings, plot summaries, and more.

This dataset contains a collection of 150,000 tv shows from the TMDB database, collected and cleaned.

Dataset will be updated weekly. If you find this dataset valuable, don't forget to leave an upvote 😊❤️

Interesting Task Ideas:

This dataset opens up a wide range of possibilities for data analysts and data scientists. Here are some ideas to get you started:

Explore trends in TV show popularity based on vote count and average.
Analyze TV show genres to identify the most popular genres or combinations of genres.
Investigate the relationship between TV show ratings and the number of seasons and episodes.
Build a recommendation system that suggests TV shows based on a user's favorite genres or languages.
Predict the success of a TV show based on features like vote count, average, and popularity.
Identify the most prolific TV show creators or production companies based on the number of shows they have created.
Explore the distribution of TV show run times and investigate whether episode duration affects the overall ratings.
Investigate TV show production trends across different countries and networks.
Analyze the relationship between TV show language and popularity, and investigate the popularity of non-English shows.
Track the status of TV shows (in production or not) and analyze their popularity over time.
Develop a language analysis model to identify sentiment or themes from TV show overviews.

Checkout my other datasets

Poverty-Level Wages in the USA Dataset

Health Insurance Coverage in the USA

Median and Avg Hourly Wages in the USA

US Cost of Living Dataset

13K Reddit Tips

Photo by Nicolas J Leclercq on Unsplash

Tables

Tmdb Tv Dataset V3

@kaggle.asaniczka_full_tmdb_tv_shows_dataset_2023_150k_shows.tmdb_tv_dataset_v3

40.41 MB
168639 rows
29 columns


CREATE TABLE tmdb_tv_dataset_v3 (
  "id" BIGINT,
  "name" VARCHAR,
  "number_of_seasons" BIGINT,
  "number_of_episodes" BIGINT,
  "original_language" VARCHAR,
  "vote_count" BIGINT,
  "vote_average" DOUBLE,
  "overview" VARCHAR,
  "adult" BOOLEAN,
  "backdrop_path" VARCHAR,
  "first_air_date" TIMESTAMP,
  "last_air_date" TIMESTAMP,
  "homepage" VARCHAR,
  "in_production" BOOLEAN,
  "original_name" VARCHAR,
  "popularity" DOUBLE,
  "poster_path" VARCHAR,
  "type" VARCHAR,
  "status" VARCHAR,
  "tagline" VARCHAR,
  "genres" VARCHAR,
  "created_by" VARCHAR,
  "languages" VARCHAR,
  "networks" VARCHAR,
  "origin_country" VARCHAR,
  "spoken_languages" VARCHAR,
  "production_companies" VARCHAR,
  "production_countries" VARCHAR,
  "episode_run_time" BIGINT
);