Over half a million tweets related to #gameofthrones while it was on.
sqlite> SELECT DATETIME(ROUND(created_at/3600)*3600, 'unixepoch') AS date,count(*) from tweet GROUP BY date ORDER BY date ASC;
2019-05-20 03:00:00|580381
2019-05-20 04:00:00|349928
2019-05-20 05:00:00|232875
Conversation
Replying to
But are the comments positive or negative? I've never see #GameOfThrones and if the finale sucked (like The Sopranos), then I probably won't start watching it. But if it's a good finale (like Buffy The Vampire Slayer), then maybe I'll start watching.
1
1
Replying to
That will be an interesting study in itself -- so my goal is to create a dataset for researchers to use if they're interested. From the sample I observed, the sentiment was overwhelmingly negative (most people seem to really dislike the writing for this season)
1