(github.com)

371 points timqian | 4 comments | 06 Jul 18 09:23 UTC | HN request time: 0.001s | 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 #

1. kozikow ◴[06 Jul 18 13:16 UTC] No.17471117[source]▶

>>17470583 #

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 #

2. cue232s ◴[06 Jul 18 14:25 UTC] No.17471592[source]▶

>>17471117 (TP) #

what's outdated? The dataset?

replies(1): >>17474822 #

3. minimaxir ◴[06 Jul 18 17:17 UTC] No.17473193[source]▶

>>17471117 (TP) #

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...

4. kozikow ◴[06 Jul 18 20:23 UTC] No.17474822[source]▶

>>17471592 #

Never 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.

↑

Show HN: Hacker News job trends