Baselight

TV Shows

A full, 3NF database that about current TV Shows (Approximately 160K Shows)

@kaggle.denizbilginn_tv_shows

Loading...
Loading...

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:

  1. Explore trends in TV show popularity based on vote count and average.
  2. Analyze TV show genres to identify the most popular genres or combinations of genres.
  3. Investigate the relationship between TV show ratings and the number of seasons and episodes.
  4. Build a recommendation system that suggests TV shows based on a user's favorite genres or languages.
  5. Predict the success of a TV show based on features like vote count, average, and popularity.
  6. Identify the most prolific TV show creators or production companies based on the number of shows they have created.
  7. Explore the distribution of TV show run times and investigate whether episode duration affects the overall ratings.
  8. Investigate TV show production trends across different countries and networks.
  9. Analyze the relationship between TV show language and popularity, and investigate the popularity of non-English shows.
  10. Track the status of TV shows (in production or not) and analyze their popularity over time.
  11. 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
Loading...

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

Genres

@kaggle.denizbilginn_tv_shows.genres
  • 792.83 KB
  • 143711 rows
  • 2 columns
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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

Spoken Languages

@kaggle.denizbilginn_tv_shows.spoken_languages
  • 768.95 KB
  • 111686 rows
  • 2 columns
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

CREATE TABLE languages (
  "show_id" BIGINT,
  "language_type_id" BIGINT
);
@kaggle.denizbilginn_tv_shows.links
  • 7.4 MB
  • 230076 rows
  • 3 columns
Loading...

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
Loading...

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
Loading...

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

Types

@kaggle.denizbilginn_tv_shows.types
  • 2.21 KB
  • 7 rows
  • 2 columns
Loading...

CREATE TABLE types (
  "type_id" BIGINT,
  "type_name" VARCHAR
);
@kaggle.denizbilginn_tv_shows.link_types
  • 2.21 KB
  • 3 rows
  • 2 columns
Loading...

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

Share link

Anyone who has the link will be able to view this.