home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 960292442

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/simonw/sqlite-utils/issues/239#issuecomment-960292442 https://api.github.com/repos/simonw/sqlite-utils/issues/239 960292442 IC_kwDOCGYnMM45POZa 350038 2021-11-03T23:28:55Z 2021-11-03T23:28:55Z NONE

I am super interested in this feature.

After reading the other issues you referenced, I think the right way would be to use the current extract feature and then to use sqlite-utils convert to extract the json object into individual columns

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
816526538  
Powered by Datasette · Queries took 1.113ms · About: github-to-sqlite