turbot/hackernews

steampipe plugin install hackernewssteampipe plugin install hackernews

Table: hackernews_ask_hn

Up to 200 of the latest Ask HN stories.

Examples

Ask HN stories by score

select
*
from
hackernews_ask_hn
order by
score desc

Ask HN stories with most comments

select
*
from
hackernews_ask_hn
order by
descendants desc

.inspect hackernews_ask_hn

Latest 200 Ask HN 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.