[STORY] Game of Thrones

[dharashah410]

Ideation

• Decide story pitch with domain experts
  • Does the story idea add value?
  • Is data available?

Prepare

• Data collection and cleaning
• Story insight
• Get story reviewed from domain experts (Is there even a story here?)

Plan

• Structure of the story
• Design the visualization
• Get story reviewed from domain experts (Is the story plan making sense?)

Execute

• Code the visualization
• Write the essay
• Get story reviewed from domain experts

Publish

• Prepare social media images
• Publish
  • Post on site
  • Post on Instagram
  • Post on Facebook
  • Post on Twitter

[dharashah410]

Scrape script of all 7 seasons of Game of Thrones into following CSV tables

Step #1 - Houses. Seed this database from https://github.com/joakimskoog/AnApiOfIceAndFire/blob/master/data/houses.json

Step 2 - Characters, Relationships. Seed this database from https://github.com/joakimskoog/AnApiOfIceAndFire/blob/master/data/characters.json
2.1 characters.csv - Name, Gender, House, Titles, Aliases, HouseId
2.2 relationships.csv - CharacterId, RelatedToCharacterId, Relationship (e.g. Father, Mother, Spouse, Children, etc.]

Step 3 - Table with all episodes
3.1 episodes.csv - Name, Synopsis, Season Number

Step 4 - Locations.csv
4.1

Step 5 - Scenes.csv and Dialogues.csv
5.1 Extract this for each episode from https://genius.com/albums/Game-of-thrones/Season-1-scripts
5.2 A Scene is associated with episode, characters, dialogues, locations

• https://jeffreylancaster.github.io/game-of-thrones/
• https://medium.com/@jeffrey.lancaster/the-ultimate-game-of-thrones-dataset-a100c0cf35fb

Find map?

• Find map of the world in Games of Thrones