Name: TV Series Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

TV Series Dataset

Generation

This dataset is a result of an extensive scraping process that took approximately 10 hours. Each ID in the dataset was fetched from The Movie Database API, resulting in a collection of over 225,000 IDs.

To replicate the dataset, you can utilize my open-source NodeJS application available on GitHub. The application's source code is publicly accessible, allowing you to generate the same dataset on your own.

In case there is significant interest, there is a possibility of setting up an API that enables browsing through all the detailed information obtained from the scraping process. If you would like to express your interest or learn more, feel free to send a message via Twitter.

Missing data

Please note that due to limitations within The Movie Database API, certain data may be missing for some TV series. This primarily affects older and less well-known TV shows.

This dataset includes the following information for each entry:

ID: Unique identifier for the TV series.
Name: Title of the TV series.
Original Name: Original title of the TV series.
Overview: Brief summary or description of the TV series.
Tagline: Catchphrase or memorable line associated with the TV series (if available).
In Production: Indicates whether the TV series is currently in production or
Status: Current status of the TV series (e.g., in production, ended, canceled),
Original Language: Language in which the TV series was originally
Origin Country: Country of origin for the TV
Created By: Name(s) of the individual(s) or organization(s) credited with creating the TV
First Air Date: Date when the TV series first aired.
Last Air Date: Date of the latest episode or season finale.
Number of Episodes: Total number of episodes available for the TV series.
Number of Seasons: Total number of seasons produced for the TV series.
Production Companies: Companies involved in the production of the TV series.
Poster Path: URL of the poster image associated with the TV series. The format of the URL is as follows: https://www.themoviedb.org/t/p/w600_and_h900_bestv2/xxxx.jpg.
Genres: Genre(s) or category to which the TV series belongs.
Vote Average: Average rating given to the TV series by viewers.
Vote Count: Total number of votes received for the TV series.
Popularity: Popularity score or ranking of the TV series.

Please note that certain fields may be missing for some entries, particularly for older and less well-known TV series, due to limitations within The Movie Database API.

Tables

Tvs

@kaggle.bourdier_all_tv_series_details_dataset.tvs

40.98 MB
152,970 rows
188 columns

CREATE TABLE tvs (
  "n__id" VARCHAR  -- Id,
  "id" BIGINT,
  "name" VARCHAR,
  "original_name" VARCHAR,
  "overview" VARCHAR,
  "tagline" VARCHAR,
  "in_production" BOOLEAN,
  "status" VARCHAR,
  "original_language" VARCHAR,
  "origin_country_0" VARCHAR  -- Origin Country[0],
  "origin_country_1" VARCHAR  -- Origin Country[1],
  "origin_country_2" VARCHAR  -- Origin Country[2],
  "origin_country_3" VARCHAR  -- Origin Country[3],
  "origin_country_4" VARCHAR  -- Origin Country[4],
  "origin_country_5" VARCHAR  -- Origin Country[5],
  "origin_country_6" VARCHAR  -- Origin Country[6],
  "origin_country_7" VARCHAR  -- Origin Country[7],
  "first_air_date" TIMESTAMP,
  "last_air_date" VARCHAR,
  "number_of_episodes" DOUBLE,
  "number_of_seasons" BIGINT,
  "poster_path" VARCHAR,
  "genres_0_id" DOUBLE  -- Genres[0].id,
  "genres_1_id" DOUBLE  -- Genres[1].id,
  "genres_2_id" DOUBLE  -- Genres[2].id,
  "genres_3_id" DOUBLE  -- Genres[3].id,
  "genres_4_id" DOUBLE  -- Genres[4].id,
  "genres_5_id" DOUBLE  -- Genres[5].id,
  "genres_6_id" DOUBLE  -- Genres[6].id,
  "genres_7_id" DOUBLE  -- Genres[7].id,
  "genres_0_name" VARCHAR  -- Genres[0].name,
  "genres_1_name" VARCHAR  -- Genres[1].name,
  "genres_2_name" VARCHAR  -- Genres[2].name,
  "genres_3_name" VARCHAR  -- Genres[3].name,
  "genres_4_name" VARCHAR  -- Genres[4].name,
  "genres_5_name" VARCHAR  -- Genres[5].name,
  "genres_6_name" VARCHAR  -- Genres[6].name,
  "genres_7_name" VARCHAR  -- Genres[7].name,
  "genres_0_id_592134" VARCHAR  -- Genres[0]. Id,
  "genres_1_id_b5e25a" VARCHAR  -- Genres[1]. Id,
  "genres_2_id_127c5b" VARCHAR  -- Genres[2]. Id,
  "genres_3_id_d690ca" VARCHAR  -- Genres[3]. Id,
  "genres_4_id_470b2f" VARCHAR  -- Genres[4]. Id,
  "genres_5_id_c017ae" VARCHAR  -- Genres[5]. Id,
  "genres_6_id_f9cd3f" VARCHAR  -- Genres[6]. Id,
  "genres_7_id_dec80a" VARCHAR  -- Genres[7]. Id,
  "vote_average" DOUBLE,
  "vote_count" BIGINT,
  "popularity" DOUBLE,
  "created_by_0_id" DOUBLE  -- Created By[0].id,
  "created_by_1_id" DOUBLE  -- Created By[1].id,
  "created_by_2_id" DOUBLE  -- Created By[2].id,
  "created_by_3_id" DOUBLE  -- Created By[3].id,
  "created_by_4_id" DOUBLE  -- Created By[4].id,
  "created_by_5_id" DOUBLE  -- Created By[5].id,
  "created_by_6_id" DOUBLE  -- Created By[6].id,
  "created_by_7_id" DOUBLE  -- Created By[7].id,
  "created_by_8_id" DOUBLE  -- Created By[8].id,
  "created_by_9_id" DOUBLE  -- Created By[9].id,
  "created_by_10_id" DOUBLE  -- Created By[10].id,
  "created_by_11_id" DOUBLE  -- Created By[11].id,
  "created_by_12_id" DOUBLE  -- Created By[12].id,
  "created_by_13_id" DOUBLE  -- Created By[13].id,
  "created_by_14_id" DOUBLE  -- Created By[14].id,
  "created_by_15_id" DOUBLE  -- Created By[15].id,
  "created_by_0_name" VARCHAR  -- Created By[0].name,
  "created_by_1_name" VARCHAR  -- Created By[1].name,
  "created_by_2_name" VARCHAR  -- Created By[2].name,
  "created_by_3_name" VARCHAR  -- Created By[3].name,
  "created_by_4_name" VARCHAR  -- Created By[4].name,
  "created_by_5_name" VARCHAR  -- Created By[5].name,
  "created_by_6_name" VARCHAR  -- Created By[6].name,
  "created_by_7_name" VARCHAR  -- Created By[7].name,
  "created_by_8_name" VARCHAR  -- Created By[8].name,
  "created_by_9_name" VARCHAR  -- Created By[9].name,
  "created_by_10_name" VARCHAR  -- Created By[10].name,
  "created_by_11_name" VARCHAR  -- Created By[11].name,
  "created_by_12_name" VARCHAR  -- Created By[12].name,
  "created_by_13_name" VARCHAR  -- Created By[13].name,
  "created_by_14_name" VARCHAR  -- Created By[14].name,
  "created_by_15_name" VARCHAR  -- Created By[15].name,
  "created_by_0_id_034185" VARCHAR  -- Created By[0]. Id,
  "created_by_1_id_92ad9c" VARCHAR  -- Created By[1]. Id,
  "created_by_2_id_2e6859" VARCHAR  -- Created By[2]. Id,
  "created_by_3_id_39fb3e" VARCHAR  -- Created By[3]. Id,
  "created_by_4_id_a7dbd0" VARCHAR  -- Created By[4]. Id,
  "created_by_5_id_286e5d" VARCHAR  -- Created By[5]. Id,
  "created_by_6_id_b393ca" VARCHAR  -- Created By[6]. Id,
  "created_by_7_id_07af29" VARCHAR  -- Created By[7]. Id,
  "created_by_8_id_a5d14f" VARCHAR  -- Created By[8]. Id,
  "created_by_9_id_a1669c" VARCHAR  -- Created By[9]. Id,
  "created_by_10_id_ca4a08" VARCHAR  -- Created By[10]. Id,
  "created_by_11_id_e61cc7" VARCHAR  -- Created By[11]. Id,
  "created_by_12_id_eb7d6e" VARCHAR  -- Created By[12]. Id,
  "created_by_13_id_acf5b8" VARCHAR  -- Created By[13]. Id,
  "created_by_14_id_8e04fc" VARCHAR  -- Created By[14]. Id,
  "created_by_15_id_3ede1b" VARCHAR  -- Created By[15]. Id,
  "production_companies_0_id" DOUBLE  -- Production Companies[0].id,
  "production_companies_1_id" DOUBLE  -- Production Companies[1].id,
  "production_companies_2_id" DOUBLE  -- Production Companies[2].id
);

TV Series Dataset

About this Dataset