Skip to content

Instantly share code, notes, and snippets.

@alexggordon

alexggordon/big-query-reddit.sql

Last active August 29, 2015 14:24
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alexggordon/7b56353dcf8044a7a5f9 to your computer and use it in GitHub Desktop.
Save alexggordon/7b56353dcf8044a7a5f9 to your computer and use it in GitHub Desktop.
Download ZIP
Big Query Most Downvoted Reddit Comment
Raw
big-query-reddit.sql
SELECT score,
subreddit,
link_id,
body,
author
FROM [fh-bigquery:reddit_comments.2007],
[fh-bigquery:reddit_comments.2008],
[fh-bigquery:reddit_comments.2009],
[fh-bigquery:reddit_comments.2010],
[fh-bigquery:reddit_comments.2011],
[fh-bigquery:reddit_comments.2012],
[fh-bigquery:reddit_comments.2013],
[fh-bigquery:reddit_comments.2014],
[fh-bigquery:reddit_comments.2015_01],
[fh-bigquery:reddit_comments.2015_02],
[fh-bigquery:reddit_comments.2015_03],
[fh-bigquery:reddit_comments.2015_04],
[fh-bigquery:reddit_comments.2015_05]
order by score asc
LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment