i listened the Apollo and Relay team duke it out on GraphQL radio yesterday and it was pretty cool. it seems they will reach an uneasy convergence.
meanwhile the apollo team’s tooling is solid. i am messing around on their playground today: https://launchpad.graphql.com/3xp1vx3lv
i forked graphiql to do some of my own tweaks! also PR’ed to fix a doc: https://github.com/graphql/graphiql/issues/619
two awesome sidebar components:
- https://github.com/balloob/react-sidebar/blob/master/package.json small
- https://github.com/negomi/react-burger-menu/blob/master/package.json full featured
GOT data thread:
Hey guys,
I’m doing a project that requires good GOT data and so I naturally turned to what everyone knows, the API of Ice and Fire. Unfortunately I soon found concerning holes in the data, for example most (but not all!) of the Mother, Father, and Spouse fields are blank even for the main characters. As a non-book reader I was also worried about double entry - apparently Daenerys is -not- the first of her name(first, second)? and other careless mistakes.
So while I appreciate AoIAF I am looking to supplement my data with more datasets. I don’t have the time/skill to write scrapers for the wikia or the wiki. Anyway I decided to share the resources I found in case future people need this too, and also please chime in with anything I may have missed. I went five pages deep into two google searches and picked out useful looking stuff. Here goes.
- Jeffrey Lancaster’s all the things - Writeup here This thing is a fucking masterpiece - Sankey diagram!!! and has like 20 views. i want to buy shares in it.
- neo4j data scrape from wikia/wikipedia
- books data for network analysis - blog here
- AoIaF Data cleaned by IBM/and here - writeup here
- AFFC Share Copy Character database, no family relationships only house relationships
- OrientDB scrape of the Wikia - has a ton of relations which is great, but in a proprietary db format
- GOT Transcripts - what it says on the tin. dead simple.
- Season Recaps - number of lines in season 6 by character . Here are show appearances over 5 seasons
- Character Data scraped from wikia up to season 5. may have usable python code
- Screentime Data from IMDB
- Battles, deaths, death predictions only battle dataset available. some handy Python crunching of this data explained here and more usage here and here
- Deaths - source from Time
- Episode data from wikipedia
- Character Data in excel with screentime and status and actor and episode rating
- Betrayals from venngage
3 Looker blogs were a good source for finding some of the above (weren’t on google) and wanted to give credit.
Visualizations w/o raw data (may need extra work to chase down the raw data, im not interested in the pretty charts if I cant reproduce them/use them myself)
- https://flowingdata.com/tag/game-of-thrones/ Collection of various things
- https://blog.twitter.com/en_us/topics/insights/2016/game-of-thrones-viz.html Tweet mentions
- https://datasaurus-rex.com/datavisualization/game-of-thrones-interactive-viz-mkii GoT Deaths (holy shit, this one is really good. Go here if your browser doesnt like the first link like me. HAND CODED by THIS GUY)
- http://patorjk.com/vis/chaos-ladder/ appearances over time, up to season 4
- http://news.northeastern.edu/2017/08/the-game-of-thrones-social-network/ GOT as social network
- http://deathtimeline.com/ scrapable example
- https://github.com/neo4j-examples/game-of-thrones proprietary neo4j format but from AoIaF
- https://www.nytimes.com/interactive/2017/08/09/upshot/game-of-thrones-chart.html user looks rating