issue_comments

Table actions

1 row where issue = 789653499 and user = 40218891 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

  • yt87 · 1 ✖

issue 1

  • GH2550 revisited · 1 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
767170277 https://github.com/pydata/xarray/issues/4830#issuecomment-767170277 https://api.github.com/repos/pydata/xarray/issues/4830 MDEyOklzc3VlQ29tbWVudDc2NzE3MDI3Nw== yt87 40218891 2021-01-25T23:06:00Z 2021-01-25T23:06:00Z NONE

One could always set source to str(filename_or_object). In this case: ``` import s3fs

s3 = s3fs.S3FileSystem(anon=True) s3path = 's3://wrf-se-ak-ar5/gfdl/hist/daily/1980/WRFDS_1980-01-02.nc' fileset = s3.open(s3path) fileset fileset.path prints <File-like object S3FileSystem, wrf-se-ak-ar5/gfdl/hist/daily/1980/WRFDS_1980-01-02.nc>

'wrf-se-ak-ar5/gfdl/hist/daily/1980/WRFDS_1980-01-02.nc' ` It is easy to parse the abovefileset`` representation, but there is no guarantee that some other external file representation will be amenable to parsing.

If the fix is only for s3fs, getting path attribute is more elegant, however this would require xarray to be aware of the module.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   GH2550 revisited 789653499

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