home / github / issues

Menu
  • Search all tables
  • GraphQL API

issues: 275089535

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
275089535 MDU6SXNzdWUyNzUwODk1MzU= 121 ?_json=foo&_json=bar query string argument 9599 closed 0     4 2017-11-18T16:09:55Z 2018-05-31T13:48:12Z 2018-05-28T18:11:51Z OWNER  

Causes the specified columns in the output to be treated as JSON, and returned deserialized in the .json or .jsono response.

This will be particularly powerful when combined with https://sqlite.org/json1.html

107914493 issue    
{
    "url": "https://api.github.com/repos/simonw/datasette/issues/121/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  completed

Links from other tables

  • 1 row from issues_id in issues_labels
  • 4 rows from issue in issue_comments
Powered by Datasette · Queries took 1.045ms · About: github-to-sqlite