A semantic map of all 3.5M story titles ever submitted to Hacker News

Post by clured » Wed, Apr 28, 2021, 3:58 PM UTC

Post by minimaxir » Wed, Apr 28, 2021, 4:54 PM UTC

gautamsomani wrote: post #2

How did you extract all this data?

   SELECT DISTINCT title FROM `bigquery-public-data.hacker_news.full`
   WHERE type = "story"
   AND NOT dead

Post by gautamsomani » Sat, May 01, 2021, 12:36 PM UTC

minimaxir wrote: post #3

gautamsomani wrote: post #2

How did you extract all this data?

You can get the titles pretty easily from BigQuery: SELECT DISTINCT title FROM `bigquery-public-data.hacker_news.full` WHERE type = "story" AND NOT dead