Name: Game Of Thrones: Series Scripts Breakdowns
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Game Of Thrones: Series Scripts Breakdowns

Context

Undoubtedly Game of Thrones is one of the best series of all times. Many things have been already analyzed: wars, screen times, the books... But what about what each and every character in the serie says?
With hundreds of characters and more than 22K sentences, this database aims to help you test your text mining skills.

Content

The content is pretty simple: the databse contains each and every sentence said in the serie together with who has said it, the episode and the season. Besides I have includeded some extra information that might be useful while analyzing, such as the number of episode of the serie and within the season and the date it was broadcasted.

For the time being the dataset includes episodes from Season 1 to Season 7. As soon as the scripts of Season 8 are transcribbed, I will update and upload the database.

Acknowledgements

This dataset would not be possible if it wasn't for the folks of genius.com who have transcribbed all the episodes from the serie.

Inspiration

I dare you to analyze the following:

How does the sentiment of the main characters change with time?
What are the most used words in each important family?
Comparing characters: between Cersei and Daenerys, who says more times the word "kill"? And what about the word "love"?
Is there a pattern in the last words of those characters who have died compared to those who are still alive?

Tables

Got Scripts Breakdown

@kaggle.anderfj_game_of_thrones_series_scripts_breakdowns.got_scripts_breakdown

1.13 MB
22,510 rows
8 columns

CREATE TABLE got_scripts_breakdown (
  "column1" BIGINT,
  "season" VARCHAR,
  "episode" VARCHAR,
  "sentence" VARCHAR,
  "name" VARCHAR,
  "n_serie" BIGINT,
  "n_season" BIGINT,
  "emision_date" TIMESTAMP
);