issues

Table actions

2 rows where "closed_at" is on date 2016-12-23, comments = 4 and repo = 13221727 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: state, repo, type

id node_id number title user state locked assignee milestone comments created_at updated_at ▲ closed_at author_association active_lock_reason draft pull_request body reactions performed_via_github_app state_reason repo type
193226503 MDU6SXNzdWUxOTMyMjY1MDM= 1150 "ncdump -h" like repr? fmaussion 10050469 closed 0     4 2016-12-02T21:51:36Z 2016-12-23T17:36:54Z 2016-12-23T17:36:54Z MEMBER      

Sometimes it could be useful to have a view of all variables attributes at a glance. For example, this is the repr for ERA-Interim energy fluxes data:

(...) Data variables: slhf (month, latitude, longitude) float64 0.02852 0.02852 0.02852 ... tsr (month, latitude, longitude) float64 -0.0001912 -0.0001912 ... strd (month, latitude, longitude) float64 166.6 166.6 166.6 166.6 ... strc (month, latitude, longitude) float64 -66.23 -66.23 -66.23 ... tisr (month, latitude, longitude) float64 0.0 0.0 0.0 0.0 0.0 0.0 ... ssrd (month, latitude, longitude) float64 -0.0003951 -0.0003951 ... ssrc (month, latitude, longitude) float64 0.0 0.0 0.0 0.0 0.0 0.0 ... str (month, latitude, longitude) float64 -40.65 -40.65 -40.65 ... ttr (month, latitude, longitude) float64 -171.5 -171.5 -171.5 ... tsrc (month, latitude, longitude) float64 0.0 0.0 0.0 0.0 0.0 0.0 ... sshf (month, latitude, longitude) float64 10.46 10.46 10.46 10.46 ... ssr (month, latitude, longitude) float64 0.0 0.0 0.0 0.0 0.0 0.0 ... ttrc (month, latitude, longitude) float64 -174.9 -174.9 -174.9 ... (...) This is what my students will see when they explore the dataset for the first time. It could be nice to have a utility function (e.g. dumph or something) which would have a style closer to ncdump -h:

(...) double ttr(month, latitude, longitude) ; ttr:least_significant_digit = 2L ; ttr:units = "J m**-2" ; ttr:long_name = "Top net thermal radiation" ; ttr:standard_name = "toa_outgoing_longwave_flux" ; double tsrc(month, latitude, longitude) ; tsrc:least_significant_digit = 2L ; tsrc:units = "J m**-2" ; tsrc:long_name = "Top net solar radiation, clear sky" ; double sshf(month, latitude, longitude) ; sshf:least_significant_digit = 2L ; sshf:units = "J m**-2" ; sshf:long_name = "Surface sensible heat flux" ; sshf:standard_name = "surface_upward_sensible_heat_flux" ; double ssr(month, latitude, longitude) ; ssr:least_significant_digit = 2L ; ssr:units = "J m**-2" ; ssr:long_name = "Surface net solar radiation" ; ssr:standard_name = "surface_net_downward_shortwave_flux" ; double ttrc(month, latitude, longitude) ; ttrc:least_significant_digit = 2L ; ttrc:units = "J m**-2" ; ttrc:long_name = "Top net thermal radiation, clear sky" ; (...)

Or is there something like this already?

 
{
    "url": "https://api.github.com/repos/pydata/xarray/issues/1150/reactions",
    "total_count": 2,
    "+1": 2,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   completed xarray 13221727 issue
197057007 MDExOlB1bGxSZXF1ZXN0OTkwMjIzODE= 1178 Fix inconsistent behaviour for xarray.DataArray.rename magonser 14014177 closed 0     4 2016-12-21T23:18:24Z 2016-12-23T17:26:41Z 2016-12-23T17:26:32Z CONTRIBUTOR   0 pydata/xarray/pulls/1178

Attempt to fix #1177

Please let me know, if PR requires further refinement. 

{
    "url": "https://api.github.com/repos/pydata/xarray/issues/1178/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
     xarray 13221727 pull

Advanced export

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

CSV options: 

CREATE TABLE [issues] (
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [number] INTEGER,
   [title] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [state] TEXT,
   [locked] INTEGER,
   [assignee] INTEGER REFERENCES [users]([id]),
   [milestone] INTEGER REFERENCES [milestones]([id]),
   [comments] INTEGER,
   [created_at] TEXT,
   [updated_at] TEXT,
   [closed_at] TEXT,
   [author_association] TEXT,
   [active_lock_reason] TEXT,
   [draft] INTEGER,
   [pull_request] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [state_reason] TEXT,
   [repo] INTEGER REFERENCES [repos]([id]),
   [type] TEXT
);
CREATE INDEX [idx_issues_repo]
    ON [issues] ([repo]);
CREATE INDEX [idx_issues_milestone]
    ON [issues] ([milestone]);
CREATE INDEX [idx_issues_assignee]
    ON [issues] ([assignee]);
CREATE INDEX [idx_issues_user]
    ON [issues] ([user]);