←back to thread

Show HN: Hacker News job trends

(github.com)
371 points timqian | 1 comments | 06 Jul 18 09:23 UTC | HN request time: 0s | source
Show context
lucb1e ◴[06 Jul 18 11:40 UTC] No.17470583[source]▶
A data dump would have been much nicer, I don't want to have to install a package to basically run grep on a dataset. The tool should only be for updating the dataset.
replies(2): >>17470929 #>>17471117 #
kozikow ◴[06 Jul 18 13:16 UTC] No.17471117[source]▶
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:d... . It seems to be outdated tho...
replies(2): >>17471592 #>>17473193 #
1. minimaxir ◴[06 Jul 18 17:17 UTC] No.17473193[source]▶
The `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...