pull_requests
2 rows where user = 1794715
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date), closed_at (date), merged_at (date)
| id ▼ | node_id | number | state | locked | title | user | body | created_at | updated_at | closed_at | merged_at | merge_commit_sha | assignee | milestone | draft | head | base | author_association | auto_merge | repo | url | merged_by |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10239839 | MDExOlB1bGxSZXF1ZXN0MTAyMzk4Mzk= | 1 | closed | 0 | Added setup.py which runs unit tests as necessary. | ebrevdo 1794715 | 2013-11-24T04:10:48Z | 2016-01-04T23:11:54Z | 2013-11-25T20:23:46Z | 2013-11-25T20:23:46Z | 69b70e459fa2ae97fcbb57afb6bc8f26e5694433 | 0 | 752d2795977dfab3853555f0a04fe76f90793def | 01591bfdbb55ef2de9e97188ce8f73fe6f2f5237 | CONTRIBUTOR | xarray 13221727 | https://github.com/pydata/xarray/pull/1 | |||||
| 12970802 | MDExOlB1bGxSZXF1ZXN0MTI5NzA4MDI= | 22 | closed | 0 | Added Scipy netcdf test file for new consistency test. | ebrevdo 1794715 | - Led to finding a small bug in xarray_equals - New dict_equal() function works when dictionary values are np arrays | 2014-02-26T20:23:01Z | 2014-02-27T04:56:07Z | 2014-02-27T04:56:01Z | 2014-02-27T04:56:01Z | e0ef97c09680e38da8b1ff023967c899d3f54b36 | 0 | 9f46afd3106999cc736e05b77b0cbf99012b4929 | 6167e0f3f8617534be0fcf43b9618bd82d431ef4 | CONTRIBUTOR | xarray 13221727 | https://github.com/pydata/xarray/pull/22 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [pull_requests] (
[id] INTEGER PRIMARY KEY,
[node_id] TEXT,
[number] INTEGER,
[state] TEXT,
[locked] INTEGER,
[title] TEXT,
[user] INTEGER REFERENCES [users]([id]),
[body] TEXT,
[created_at] TEXT,
[updated_at] TEXT,
[closed_at] TEXT,
[merged_at] TEXT,
[merge_commit_sha] TEXT,
[assignee] INTEGER REFERENCES [users]([id]),
[milestone] INTEGER REFERENCES [milestones]([id]),
[draft] INTEGER,
[head] TEXT,
[base] TEXT,
[author_association] TEXT,
[auto_merge] TEXT,
[repo] INTEGER REFERENCES [repos]([id]),
[url] TEXT,
[merged_by] INTEGER REFERENCES [users]([id])
);
CREATE INDEX [idx_pull_requests_merged_by]
ON [pull_requests] ([merged_by]);
CREATE INDEX [idx_pull_requests_repo]
ON [pull_requests] ([repo]);
CREATE INDEX [idx_pull_requests_milestone]
ON [pull_requests] ([milestone]);
CREATE INDEX [idx_pull_requests_assignee]
ON [pull_requests] ([assignee]);
CREATE INDEX [idx_pull_requests_user]
ON [pull_requests] ([user]);