Home

Notable Event Dates

Here is a list of noteworthy event dates that are interesting to study.

• Paradise Papers - Nov. 5, 2017
• NFL Protests - Sept. 24, 2017
• Las Vegas Shooting - Oct 1, 2017

Notes for use outside of tool set

Ways of obtaining additional information about events that don't fit within a tool.

Submissions containing the most comments using a term

If you've found an unusually high number of comments mentioning a term, it can be helpful to list the submissions under which those comments were logged and the associated submission titles. This is good for determining if such a term or phrase was used frequently under a narrow or broad range of submissions.

SELECT 
    RIGHT(c.parent_id, 6), 
    COUNT(c.id),
    reddit_submissions.title
FROM subreddit_name c
LEFT JOIN reddit_submissions ON reddit_submissions.id = RIGHT(parent_id, 6)
WHERE c.created_utc BETWEEN '2017-01-01 00:00:00' AND '2017-12-31 23:59:59' 
    AND (c.body LIKE '% interesting query %')
GROUP BY RIGHT(c.parent_id, 6), reddit_submissions.title
ORDER BY count(c.id) DESC;