home / github

Menu
  • GraphQL API
  • Search all tables

issue_comments

Table actions
  • GraphQL API for issue_comments

2 rows where author_association = "MEMBER", issue = 512071129 and user = 4160723 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

  • benbovy · 2 ✖

issue 1

  • jupyterlab dark theme · 2 ✖

author_association 1

  • MEMBER · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
546479671 https://github.com/pydata/xarray/pull/3443#issuecomment-546479671 https://api.github.com/repos/pydata/xarray/issues/3443 MDEyOklzc3VlQ29tbWVudDU0NjQ3OTY3MQ== benbovy 4160723 2019-10-25T19:18:59Z 2019-10-25T19:18:59Z MEMBER

For tables with many columns it might be useful. That’s not the case here, although I’ve found that it helps to track the list of variables when variable data and/or attributes reprs are unfolded. But yeah, it’s a detail.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  jupyterlab dark theme 512071129
546406563 https://github.com/pydata/xarray/pull/3443#issuecomment-546406563 https://api.github.com/repos/pydata/xarray/issues/3443 MDEyOklzc3VlQ29tbWVudDU0NjQwNjU2Mw== benbovy 4160723 2019-10-25T15:45:09Z 2019-10-25T15:45:09Z MEMBER

This looks great, I like it!

Slightly related: I've tried to add hover background color on variable items, using --jp-rendermime-table-row-hover-background, to be consistent with other rich outputs in jupyterlab, but unfortunately I couldn't make it work nicely.

If I remember well, this would need wrapping each variable item (name, dims, values, etc.) in a container, but then this wouldn't work well with display: contents. I might be wrong, though.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  jupyterlab dark theme 512071129

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 30.482ms · About: xarray-datasette