turbot/hackernews

steampipe plugin install hackernewssteampipe plugin install hackernews

Table: hackernews_job

Up to 200 job listings.

Examples

Job stories by score

select
*
from
hackernews_job
order by
score desc

Job stories with most comments

select
*
from
hackernews_job
order by
descendants desc

.inspect hackernews_job

Latest 200 Job 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.