Reddit’s presidential race: Candidate mentions in comments
Nov 13, 2015 · 1 min read
Update: Reddit’s Upvoted made a full feature on this chart with added commentaries: https://upvoted.com/2015/11/14/which-2016-presidential-candidates-are-redditors-talking-about/
Quick visualization while flying between countries, updated with reddit’s October data thanks to /u/stuck_in_the_matrix:
The BigQuery query:
SELECT DATE(USEC_TO_TIMESTAMP(UTC_USEC_TO_WEEK(created_utc*1000*1000,1))) week, SUM(body CONTAINS "Bernie Sanders") BernieSanders,SUM(body CONTAINS "Ben Carson") BenCarson,SUM(body CONTAINS "Hillary Clinton") HillaryClinton,SUM(body CONTAINS "Donald Trump") DonaldTrump,SUM(body CONTAINS "Rand Paul") RandPaul,SUM(body CONTAINS "Jim Webb") JimWebb,SUM(body CONTAINS "Ted Cruz") TedCruz,SUM(body CONTAINS "Jeb Bush") JebBush,SUM(body CONTAINS "Paul Ryan") PaulRyan,SUM(body CONTAINS "Marco Rubio") MarcoRubio,SUM(body CONTAINS "Chris Christie") ChrisChristie,SUM(body CONTAINS "Carly Fiorina") CarlyFiorinaFROM TABLE_QUERY([fh-bigquery:reddit_comments], 'REGEXP_MATCH(table_id, "2015_..$")')
GROUP BY 1
ORDER BY 1
Find more data and topics like these on reddit.com/r/bigquery, or follow me at @felipehoffa.
Update: Reddit’s Upvoted made a full feature on this chart with added commentaries:
