issue_comments

Table actions

2 rows where author_association = "CONTRIBUTOR", issue = 505409694 and user = 280924 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

  • ttung · 2 ✖

issue 1

  • OrderedDict --> dict, some python3.5 cleanup too · 2 ✖

author_association 1

  • CONTRIBUTOR · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
545301953 https://github.com/pydata/xarray/pull/3389#issuecomment-545301953 https://api.github.com/repos/pydata/xarray/issues/3389 MDEyOklzc3VlQ29tbWVudDU0NTMwMTk1Mw== ttung 280924 2019-10-23T07:07:10Z 2019-10-23T07:07:10Z CONTRIBUTOR

No idea if there are any other ones; you're probably right.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   OrderedDict --> dict, some python3.5 cleanup too 505409694
544606329 https://github.com/pydata/xarray/pull/3389#issuecomment-544606329 https://api.github.com/repos/pydata/xarray/issues/3389 MDEyOklzc3VlQ29tbWVudDU0NDYwNjMyOQ== ttung 280924 2019-10-21T16:52:32Z 2019-10-21T16:52:32Z CONTRIBUTOR

FYI, python 3.6 does not guarantee that dicts are ordered. CPython 3.6 happens to have that implementation but pypy, for instance, is not required to follow that. Python 3.7, however, mandates that dicts are ordered.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   OrderedDict --> dict, some python3.5 cleanup too 505409694

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]);