Table: hackernews_items

This table shows data for Hackernews Items.

https://github.com/HackerNews/API#items (opens in a new tab)

The primary key for this table is id. It supports incremental syncs based on the id column.

Columns

NameType
_cq_source_nameutf8
_cq_sync_timetimestamp[us, tz=UTC]
_cq_iduuid
_cq_parent_iduuid
id (PK) (Incremental Key)int64
deletedbool
typeutf8
byutf8
timetimestamp[us, tz=UTC]
textutf8
deadbool
parentint64
kidslist<item: int64, nullable>
urlutf8
scoreint64
titleutf8
partslist<item: int64, nullable>
descendantsint64