issue_comments: 550388354

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/4#issuecomment-550388354 https://api.github.com/repos/dogsheep/github-to-sqlite/issues/4 550388354 MDEyOklzc3VlQ29tbWVudDU1MDM4ODM1NA== 9599 2019-11-06T16:26:55Z 2019-11-06T16:26:55Z MEMBER

Here's a query I figured out using a window function that shows cumulative stargazers over time: sql select yyyymmdd, sum(n) over ( order by yyyymmdd rows unbounded preceding ) as cumulative_count from ( select substr(starred_at, 0, 11) as yyyymmdd, count(*) as n from stars group by yyyymmdd )

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