Is there a way to get all Ask HN posts from the HN dataset?
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_nl380bpxM0B... SELECT title FROM [bigquery-public-data:hacker_news.stories]
where title like '%Ask HN%' LIMIT 1000