issue_comments: 594151327

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/dogsheep/github-to-sqlite/issues/12#issuecomment-594151327 https://api.github.com/repos/dogsheep/github-to-sqlite/issues/12 594151327 MDEyOklzc3VlQ29tbWVudDU5NDE1MTMyNw== 9599 2020-03-03T20:26:15Z 2020-03-03T20:32:23Z MEMBER

Better version (since this also includes JSON array of repository topics): sql CREATE VIEW recent_releases AS select repos.rowid as rowid, json_object("label", repos.full_name, "href", repos.html_url) as repo, json_object( "href", releases.html_url, "label", releases.name ) as release, substr(releases.published_at, 0, 11) as date, releases.body as body_markdown, releases.published_at, coalesce(repos.topics, '[]') as topics from releases join repos on repos.id = releases.repo order by releases.published_at desc That repos.rowid as rowid bit is necessary because otherwise clicking on a link in facet-by-topic doesn't return any results.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 520756546