Recent Hacker News items
Start from a bounded source-native sample before adding filters or aggregates.
SELECT hn_id, title, original_author, original_timestamp, uri FROM hackernews.items WHERE title != '' ORDER BY hn_id DESC LIMIT 20;
Source
Query Hacker News with SQL
Every Hacker News story and comment, queryable with read-only SQL — source-native records, timestamps, authors, scores, and a live tail.
Surface
Query surfaces
hackernews.items
Public Hacker News item API and archive-derived source-native records.
Best for
phrase coinage and terminology diffusion
author-level activity and score histories
public discussion around technical topics
Fields
hn_idkindtitlepayloadoriginal_authororiginal_timestampupvotescomment_countstory_hn_iduri
Queries
Author activity over time
Aggregate public Hacker News posts and comments by author and year.
SELECT toYear(original_timestamp) AS year,
count() AS items,
sum(ifNull(upvotes, 0)) AS upvotes
FROM hackernews.items
WHERE original_author = 'pg'
AND original_timestamp IS NOT NULL
GROUP BY year
ORDER BY year DESC
LIMIT 20;