pull_requests
2 rows where user = 34257249
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1122872569 | PR_kwDOAMm_X85C7az5 | 7291 | closed | 0 | typo in xarray/doc/user-guide/reshaping.rst | templiert 34257249 | Closes #7289 | 2022-11-15T13:12:41Z | 2023-02-14T17:13:46Z | 2022-11-15T15:20:42Z | 2022-11-15T15:20:42Z | df909b444991c3d76210d018e5268de541b8e17b | 0 | f2bb1277be1a6e1ef56a3c7a4045be12103075f0 | f2fab8b32004f0587bc86872f21a06458922f619 | CONTRIBUTOR | xarray 13221727 | https://github.com/pydata/xarray/pull/7291 | ||||
| 1569911612 | PR_kwDOAMm_X85dkvM8 | 8363 | closed | 0 | docs: add searchable word "asterisk" | templiert 34257249 | 2023-10-23T20:37:59Z | 2023-10-23T21:44:13Z | 2023-10-23T21:44:07Z | 2023-10-23T21:44:07Z | eb749448f9513517230090b2cb0e3521ccb4f20f | 0 | d6f09e2839c81ffe05956f93ac9d6a1274ebedf6 | 7a68281fdf1ff11541d1165501ad72bb096cd48c | CONTRIBUTOR | xarray 13221727 | https://github.com/pydata/xarray/pull/8363 |
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]);