items

16,030 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, dead, deleted, by (date)

Next page

CREATE TABLE items (
  -- Required
  id          INTEGER PRIMARY KEY,
  type        TEXT    NOT NULL,

  -- Optional scalar fields
  by          TEXT,
  time        INTEGER,
  text        TEXT,
  dead        INTEGER,       -- BOOLEAN stored as 0/1
  parent      INTEGER,
  poll        INTEGER,
  url         TEXT,
  score       INTEGER,
  title       TEXT,
  descendants INTEGER,
  deleted     INTEGER,       -- BOOLEAN stored as 0/1

  -- Array fields serialised as JSON
  kids        TEXT,          -- JSON array of integers
  parts       TEXT,          -- JSON array of integers

  -- Housekeeping
  cached_at   INTEGER NOT NULL  -- Unix timestamp (ms) of last upsert
);
CREATE INDEX idx_items_type ON items(type);
CREATE INDEX idx_items_by ON items(by);
CREATE INDEX idx_items_time ON items(time DESC);
CREATE INDEX idx_items_parent ON items(parent);
CREATE INDEX idx_items_score ON items(score DESC);