Schema

hackernews.items

The enabled source-native Hacker News relation: public IDs, authors, timestamps, scores, payload text, and links.

Contract

  • Objecthackernews.items
  • Typetable
  • Pathhackernews.items

Best for

phrase diffusion
author histories
technical public-discourse analysis

Fields

  • hn_id
  • kind
  • title
  • payload
  • original_author
  • original_timestamp
  • upvotes
  • comment_count
  • story_hn_id
  • uri

SQL

Recent Hacker News items

Start with the bounded sample published by the live schema.

SELECT hn_id, title, original_author, original_timestamp, uri
FROM hackernews.items
WHERE title != ''
ORDER BY hn_id DESC
LIMIT 20;

Related sources