home / github

Menu
  • Search all tables
  • GraphQL API

issue_comments

Table actions
  • GraphQL API for issue_comments

1 row where author_association = "NONE", issue = 523027553 and user = 6815953 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

user 1

  • kuchaale · 1 ✖

issue 1

  • Label row and column titles with units · 1 ✖

author_association 1

  • NONE · 1 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
554742849 https://github.com/pydata/xarray/issues/3534#issuecomment-554742849 https://api.github.com/repos/pydata/xarray/issues/3534 MDEyOklzc3VlQ29tbWVudDU1NDc0Mjg0OQ== kuchaale 6815953 2019-11-17T12:55:26Z 2019-11-17T12:55:26Z NONE

@TomNicholas Is it really necessary to use the label_from_attrs function? It would label row and column titles with standard or long name in addition to units. It seems redundant to me. Nonetheless, there may be also an option how to switch on/off such a functionality.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Label row and column titles with units 523027553

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [issue_comments] (
   [html_url] TEXT,
   [issue_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [updated_at] TEXT,
   [author_association] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [issue] INTEGER REFERENCES [issues]([id])
);
CREATE INDEX [idx_issue_comments_issue]
    ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
    ON [issue_comments] ([user]);
Powered by Datasette · Queries took 16.908ms · About: xarray-datasette