Reddit’s presidential race: Candidate mentions in comments

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:

# of comments mentioning candidate

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") CarlyFiorina
FROM 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: