Dataset: TV Shows

About this Dataset

TV Shows

Welcome to TV Shows database, the database includes information of approximately 160K shows. The data of the database is updated in Jan 2024.

I carefully pre-processed the database as 3NF. I gather the dataset from Asaniczka's dataset and the I pre-processed it.
https://www.kaggle.com/datasets/asaniczka/full-tmdb-tv-shows-dataset-2023-150k-shows

You can use this database to research human taste tendencies, AI applications and more...

There is a ER diagram, you can use forward checking to create whole database clearly. The ER diagram created in MySQL. After creating the database, you can upload CSV tables to the SQL tables.

Interesting Task Ideas:

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.

Please feel free to ask any questions about the data in the discussion section.

Tables

Networks

@kaggle.denizbilginn_tv_shows.networks

797.53 KB
108295 rows
2 columns


CREATE TABLE networks (
  "show_id" BIGINT,
  "network_type_id" BIGINT
);

Genres

@kaggle.denizbilginn_tv_shows.genres

792.83 KB
143711 rows
2 columns


CREATE TABLE genres (
  "show_id" BIGINT,
  "genre_type_id" BIGINT
);

Origin Country Types

@kaggle.denizbilginn_tv_shows.origin_country_types

3.89 KB
160 rows
2 columns


CREATE TABLE origin_country_types (
  "origin_country_type_id" BIGINT,
  "origin_country_name" VARCHAR
);

Spoken Language Types

@kaggle.denizbilginn_tv_shows.spoken_language_types

3.76 KB
74 rows
2 columns


CREATE TABLE spoken_language_types (
  "spoken_language_type_id" BIGINT,
  "spoken_language_name" VARCHAR
);

Language Types

@kaggle.denizbilginn_tv_shows.language_types

3.62 KB
143 rows
2 columns


CREATE TABLE language_types (
  "language_type_id" BIGINT,
  "language_name" VARCHAR
);

Genre Types

@kaggle.denizbilginn_tv_shows.genre_types

2.51 KB
20 rows
2 columns


CREATE TABLE genre_types (
  "genre_type_id" BIGINT,
  "genre_name" VARCHAR
);

Production Company Types

@kaggle.denizbilginn_tv_shows.production_company_types

458.99 KB
21636 rows
2 columns


CREATE TABLE production_company_types (
  "production_company_type_id" BIGINT,
  "production_company_name" VARCHAR
);

Production Countries

@kaggle.denizbilginn_tv_shows.production_countries

638.05 KB
81691 rows
3 columns


CREATE TABLE production_countries (
  "show_id" BIGINT,
  "production_country_type_id" BIGINT,
  "origin_country_type_id" BIGINT
);

Production Companies

@kaggle.denizbilginn_tv_shows.production_companies

650.02 KB
86796 rows
2 columns


CREATE TABLE production_companies (
  "show_id" BIGINT,
  "production_company_type_id" BIGINT
);

Created By

@kaggle.denizbilginn_tv_shows.created_by

474.57 KB
50516 rows
2 columns


CREATE TABLE created_by (
  "show_id" BIGINT,
  "created_by_type_id" BIGINT
);

Status

@kaggle.denizbilginn_tv_shows.status

2.25 KB
6 rows
2 columns


CREATE TABLE status (
  "status_id" BIGINT,
  "status_name" VARCHAR
);

Spoken Languages

@kaggle.denizbilginn_tv_shows.spoken_languages

768.95 KB
111686 rows
2 columns


CREATE TABLE spoken_languages (
  "show_id" BIGINT,
  "spoken_language_type_id" BIGINT
);

Show Votes

@kaggle.denizbilginn_tv_shows.show_votes

1.02 MB
162143 rows
3 columns


CREATE TABLE show_votes (
  "vote_count" BIGINT,
  "vote_average" DOUBLE,
  "show_id" BIGINT
);

Production Country Types

@kaggle.denizbilginn_tv_shows.production_country_types

5.32 KB
183 rows
2 columns


CREATE TABLE production_country_types (
  "production_country_type_id" BIGINT,
  "production_country_name" VARCHAR
);

Air Dates

@kaggle.denizbilginn_tv_shows.air_dates

2.25 MB
324286 rows
3 columns


CREATE TABLE air_dates (
  "is_first" BIGINT,
  "show_id" BIGINT,
  "date" TIMESTAMP
);

Created By Types

@kaggle.denizbilginn_tv_shows.created_by_types

673.92 KB
31852 rows
2 columns


CREATE TABLE created_by_types (
  "created_by_type_id" BIGINT,
  "created_by_name" VARCHAR
);

Languages

@kaggle.denizbilginn_tv_shows.languages

777.98 KB
113269 rows
2 columns


CREATE TABLE languages (
  "show_id" BIGINT,
  "language_type_id" BIGINT
);

Links

@kaggle.denizbilginn_tv_shows.links

7.4 MB
230076 rows
3 columns


CREATE TABLE links (
  "link_type_id" BIGINT,
  "show_id" BIGINT,
  "link" VARCHAR
);

Shows

@kaggle.denizbilginn_tv_shows.shows

28.25 MB
162143 rows
13 columns


CREATE TABLE shows (
  "show_id" BIGINT,
  "name" VARCHAR,
  "number_of_seasons" BIGINT,
  "number_of_episodes" BIGINT,
  "overview" VARCHAR,
  "adult" BIGINT,
  "in_production" BIGINT,
  "original_name" VARCHAR,
  "popularity" DOUBLE,
  "tagline" VARCHAR,
  "eposide_run_time" BIGINT,
  "type_id" BIGINT,
  "status_id" BIGINT
);

Network Types

@kaggle.denizbilginn_tv_shows.network_types

58.93 KB
3398 rows
2 columns


CREATE TABLE network_types (
  "network_type_id" BIGINT,
  "network_name" VARCHAR
);

Types

@kaggle.denizbilginn_tv_shows.types

2.21 KB
7 rows
2 columns


CREATE TABLE types (
  "type_id" BIGINT,
  "type_name" VARCHAR
);

Link Types

@kaggle.denizbilginn_tv_shows.link_types

2.21 KB
3 rows
2 columns


CREATE TABLE link_types (
  "link_type_id" BIGINT,
  "link_type" VARCHAR
);