Comment on Show HN: Top PDFs and Papers Submitted to Hacker NewsComments−minimaxir7yHmm. Reverse-engineering this page with BigQuery is surfacing a lot more results than the page itself (for 2019 atleast).https://docs.google.com/spreadsheets/d/1he6ca0BBYbj2ZEOEpu8L... #standardSQL SELECT id, title, url, score FROM `bigquery-public-data.hacker_news.full` WHERE timestamp > '2019-01-01' AND REGEXP_CONTAINS(url, '.pdf|arxiv.org') ORDER BY score desc−seedie7yThanks to your post I just learned about the big query public datasets https://www.reddit.com/r/bigquery/wiki/datasets
Comments
Hmm. Reverse-engineering this page with BigQuery is surfacing a lot more results than the page itself (for 2019 atleast).
https://docs.google.com/spreadsheets/d/1he6ca0BBYbj2ZEOEpu8L...
Thanks to your post I just learned about the big query public datasets https://www.reddit.com/r/bigquery/wiki/datasets