steampipe plugin install hackernewssteampipe plugin install hackernews

Table: hackernews_user

Query information about users with public activity on Hacker News.


Get information about a user

select * from hackernews_user where id = 'pg'

.inspect hackernews_user

Information about Hacker News registered users who have public activity.

abouttextThe user's optional self-description. HTML.
createdtextCreation timestamp of the user.
idtextThe user's unique username. Case-sensitive. Required.
karmabigintThe user's karma.
submittedjsonbList of the user's stories, polls and comments.