Baselight

Big Bang Theory Episodes

The Big Bang Theory Episodes and Ratings

@kaggle.bcruise_big_bang_theory_episodes

Loading...
Loading...

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

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

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
);

Share link

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