5 ms·
HN comments are in bigquery. It's a simple query to extract that data, I just wrote it: https://bigquery.cloud.google.com/savedquery/1008801496706:de6444f61b884
by kozikow 8y ago
HN comments are in bigquery. It's a simple query to extract that data, I just wrote it: https://bigquery.cloud.google.com/savedquery/1008801496706:de6444f61b8842a6b47e2fa79df90ffd https://bigquery.cloud.google.com/savedquery/1008801496706:d... . It seems to be outdated tho...
- cue232s 8y agowhat's outdated? The dataset?
- kozikow 8y agoNever mind - see other comment by minimaxir. You have to use table bigquery-public-data:hacker_news.full rather than comments for up-to-date results.
- minimaxir 8y agoThe `full` table has comments up to recently (May 19th). You just have to add a filter on `type = "comment"`. https://bigquery.cloud.google.com/table/bigquery-public-data:hacker_news.full?tab=schema https://bigquery.cloud.google.com/table/bigquery-public-data...