Dataset: Big Bang Theory Episodes

About this Dataset

Big Bang Theory Episodes

Context

Series created by: Chuck Lorre and Bill Prady
Number of seasons: 12
Number of episodes: 279
Original air dates: September 24, 2007 – May 16, 2019
Opening Theme: "Big Bang Theory Theme" by Barenaked Ladies

Content

Data was acquired through downloading IMDb TV episodes datasets and scraping information from Wikipedia.

Acknowledgements

Thanks to IMDb, Wikipedia, and community curators.

Use

It should be easy to join these data files together on Title and Air Date fields to compare (for example) US viewers and IMDb ratings.

Motivation

I wanted to share a dataset about The Big Bang Theory, one of my favorite TV shows to binge watch.

Tables

Big Bang Theory Episodes

@kaggle.bcruise_big_bang_theory_episodes.big_bang_theory_episodes

24.89 KB
279 rows
9 columns


CREATE TABLE big_bang_theory_episodes (
  "season" BIGINT,
  "episode_num_in_season" BIGINT,
  "episode_num_overall" BIGINT,
  "title" VARCHAR,
  "directed_by" VARCHAR,
  "written_by" VARCHAR,
  "original_air_date" TIMESTAMP,
  "prod_code" VARCHAR,
  "us_viewers" DOUBLE
);

Big Bang Theory Imdb

@kaggle.bcruise_big_bang_theory_episodes.big_bang_theory_imdb

40.43 KB
280 rows
7 columns


CREATE TABLE big_bang_theory_imdb (
  "season" BIGINT,
  "episode_num" BIGINT,
  "title" VARCHAR,
  "original_air_date" VARCHAR,
  "imdb_rating" DOUBLE,
  "total_votes" BIGINT,
  "desc" VARCHAR
);