Game Of Thrones: Series Scripts Breakdowns

Analyze what every character says in the serie

@kaggle.anderfj_game_of_thrones_series_scripts_breakdowns

Table List

1 table(1.08 MB)

Got Scripts Breakdown

@kaggle.anderfj_game_of_thrones_series_scripts_breakdowns.got_scripts_breakdown

1.08 MB
22510 rows
8 columns

column1 Column1	season Season	episode Episode	sentence Sentence	name Name	n_serie N Serie	n_season N Season	emision_date Emision Date
1	Season 1	winter is coming	What d’you expect? They’re savages One lot steals a goat from another lot and before you know it, they’re ripping each other to pieces	waymar royce	1	1	Sun Apr 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
2	Season 1	winter is coming	I’ve never seen wildlings do a thing like this I’ve never seen a thing like this, not ever in my life	will	1	1	Sun Apr 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
3	Season 1	winter is coming	How close did you get?	waymar royce	1	1	Sun Apr 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
4	Season 1	winter is coming	Close as any man would	will	1	1	Sun Apr 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
5	Season 1	winter is coming	We should head back to the wall	gared	1	1	Sun Apr 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
6	Season 1	winter is coming	Do the dead frighten you?	royce	1	1	Sun Apr 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
7	Season 1	winter is coming	Our orders were to track the wildlings We tracked them They won’t trouble us no more	gared	1	1	Sun Apr 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
8	Season 1	winter is coming	You don’t think he’ll ask us how they died? Get back on your horse	royce	1	1	Sun Apr 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
9	Season 1	winter is coming	Whatever did it to them could do it to us They even killed the children	will	1	1	Sun Apr 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
10	Season 1	winter is coming	It’s a good thing we’re not children You want to run away south, run away Of course, they will behead you as a deserter If I don’t catch you first Get back on your horse I won’t say it again	royce	1	1	Sun Apr 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)


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