issues
1 row where "created_at" is on date 2021-06-01 and user = 49699333 sorted by updated_at
This data as json, CSV (advanced)
Suggested facets: updated_at (date)
closed_at (date) 1 ✖
id | node_id | number | title | user | state | locked | assignee | milestone | comments | created_at | updated_at ▼ | closed_at | author_association | pull_request | body | repo | type | active_lock_reason | performed_via_github_app | reactions | draft | state_reason |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
908276134 | MDExOlB1bGxSZXF1ZXN0NjU4OTkxNDA0 | 1352 | Bump black from 21.5b1 to 21.5b2 | dependabot[bot] 49699333 | closed | 0 | 1 | 2021-06-01T13:08:52Z | 2021-06-02T02:56:45Z | 2021-06-02T02:56:44Z | CONTRIBUTOR | simonw/datasette/pulls/1352 | Bumps [black](https://github.com/psf/black) from 21.5b1 to 21.5b2. <details> <summary>Release notes</summary> <p><em>Sourced from <a href="https://github.com/psf/black/releases">black's releases</a>.</em></p> <blockquote> <h2>21.5b2</h2> <h3><em>Black</em></h3> <ul> <li>A space is no longer inserted into empty docstrings (<a href="https://github-redirect.dependabot.com/psf/black/issues/2249">#2249</a>)</li> <li>Fix handling of .gitignore files containing non-ASCII characters on Windows (<a href="https://github-redirect.dependabot.com/psf/black/issues/2229">#2229</a>)</li> <li>Respect <code>.gitignore</code> files in all levels, not only <code>root/.gitignore</code> file (apply <code>.gitignore</code> rules like <code>git</code> does) (<a href="https://github-redirect.dependabot.com/psf/black/issues/2225">#2225</a>)</li> <li>Restored compatibility with Click 8.0 on Python 3.6 when LANG=C used (<a href="https://github-redirect.dependabot.com/psf/black/issues/2227">#2227</a>)</li> <li>Add extra uvloop install + import support if in python env (<a href="https://github-redirect.dependabot.com/psf/black/issues/2258">#2258</a>)</li> <li>Fix --experimental-string-processing crash when matching parens are not found (<a href="https://github-redirect.dependabot.com/psf/black/issues/2283">#2283</a>)</li> <li>Make sure to split lines that start with a string operator (<a href="https://github-redirect.dependabot.com/psf/black/issues/2286">#2286</a>)</li> <li>Fix regular expression that black uses to identify f-expressions (<a href="https://github-redirect.dependabot.com/psf/black/issues/2287">#2287</a>)</li> </ul> <h3><em>Blackd</em></h3> <ul> <li>Add a lower bound for the <code>aiohttp-cors</code> dependency. Only 0.4.0 or higher is supported. (<a href="https://github-redirect.dependabot.com/psf/black/issues/2231">#2231</a>)</li> </ul> <h3><em>Packaging</em></h3> <ul> <li>Release self-contained x86_64 MacOS binaries as part of the GitHub release pipeline (<a href="https://github-redirect.dependabot.com/psf/black/issues/2198">… | datasette 107914493 | pull | {"url": "https://api.github.com/repos/simonw/datasette/issues/1352/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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, [pull_request] TEXT, [body] TEXT, [repo] INTEGER REFERENCES [repos]([id]), [type] TEXT , [active_lock_reason] TEXT, [performed_via_github_app] TEXT, [reactions] TEXT, [draft] INTEGER, [state_reason] 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]);