turbot/hackernews

steampipe plugin install hackernewssteampipe plugin install hackernews
On This Page
Get Involved

Table: hackernews_best

500 of the latest "best" stories.

Examples

Best stories by score

select
*
from
hackernews_best
order by
score desc

Best stories with most comments

select
*
from
hackernews_best
order by
descendants desc

.inspect hackernews_best

Best 500 stories.

NameTypeDescription
bytextThe username of the item's author.
deadbooleanTrue if the item is dead.
deletedbooleanTrue if the item is deleted.
descendantsbigintIn the case of stories or polls, the total comment count.
idbigintThe item's unique id.
kidsjsonbThe ids of the item's comments, in ranked display order.
parentbigintThe comment's parent: either another comment or the relevant story.
partsjsonbA list of related pollopts, in display order.
pollbigintThe pollopt's associated poll.
scorebigintThe story's score, or the votes for a pollopt.
texttextThe comment, story or poll text. HTML.
timetimestamp without time zoneTimestamp when the item was created.
titletextThe title of the story, poll or job. HTML.
typetextThe type of item. One of "job", "story", "comment", "poll", or "pollopt".
urltextThe URL of the story.