Name: TV Shows
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

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

Air Dates

@kaggle.denizbilginn_tv_shows.air_dates

2.36 MB
324,286 rows
3 columns

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

Created By

@kaggle.denizbilginn_tv_shows.created_by

485.96 kB
50,516 rows
2 columns

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

Created By Types

@kaggle.denizbilginn_tv_shows.created_by_types

690.1 kB
31,852 rows
2 columns

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

Genres

@kaggle.denizbilginn_tv_shows.genres

811.86 kB
143,711 rows
2 columns

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

Genre Types

@kaggle.denizbilginn_tv_shows.genre_types

2.57 kB
20 rows
2 columns

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

Languages

@kaggle.denizbilginn_tv_shows.languages

796.65 kB
113,269 rows
2 columns

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

Language Types

@kaggle.denizbilginn_tv_shows.language_types

3.71 kB
143 rows
2 columns

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

Links

@kaggle.denizbilginn_tv_shows.links

7.76 MB
230,076 rows
3 columns

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

Link Types

@kaggle.denizbilginn_tv_shows.link_types

2.27 kB
3 rows
2 columns

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

Networks

@kaggle.denizbilginn_tv_shows.networks

816.67 kB
108,295 rows
2 columns

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

Network Types

@kaggle.denizbilginn_tv_shows.network_types

60.35 kB
3,398 rows
2 columns

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

Origin Country Types

@kaggle.denizbilginn_tv_shows.origin_country_types

3.98 kB
160 rows
2 columns

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

Production Companies

@kaggle.denizbilginn_tv_shows.production_companies

665.62 kB
86,796 rows
2 columns

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

Production Company Types

@kaggle.denizbilginn_tv_shows.production_company_types

470 kB
21,636 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

653.36 kB
81,691 rows
3 columns

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

Production Country Types

@kaggle.denizbilginn_tv_shows.production_country_types

5.45 kB
183 rows
2 columns

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

Shows

@kaggle.denizbilginn_tv_shows.shows

29.63 MB
162,143 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
);

Show Votes

@kaggle.denizbilginn_tv_shows.show_votes

1.07 MB
162,143 rows
3 columns

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

Spoken Languages

@kaggle.denizbilginn_tv_shows.spoken_languages

787.41 kB
111,686 rows
2 columns

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

Spoken Language Types

@kaggle.denizbilginn_tv_shows.spoken_language_types

3.85 kB
74 rows
2 columns

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

Status

@kaggle.denizbilginn_tv_shows.status

2.31 kB
6 rows
2 columns

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

Types

@kaggle.denizbilginn_tv_shows.types

2.26 kB
7 rows
2 columns

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