3 ms·
Is there a way to get all Ask HN posts from the HN dataset?
by AznHisoka 10y ago
Is there a way to get all Ask HN posts from the HN dataset?
- minimaxir 10y agoSomething along the lines of: SELECT id, title FROM [bigquery-public-data:hacker_news.full_201510] WHERE title CONTAINS "Ask HN" AND url="" LIMIT 1000 Output: https://docs.google.com/spreadsheets/d/12HZ2DqkR_nl380bpxM0BLgfVfwCzb3l7hBSFKjlPDuw/edit?usp=sharing https://docs.google.com/spreadsheets/d/12HZ2DqkR_nl380bpxM0B...
- thesandlord 10y agoHere is a simple query to get all the titles. SELECT title FROM [bigquery-public-data:hacker_news.stories] where title like '%Ask HN%' LIMIT 1000