[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