milestones
3 rows where closed_issues = 8, creator = 9599, open_issues = 0 and state = "closed"
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date), closed_at (date)
repo 2
state 1
- closed · 3 ✖
id ▼ | title | description | creator | repo | html_url | node_id | number | open_issues | closed_issues | state | created_at | updated_at | due_on | closed_at |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5234079 | Datasette 0.39 | simonw 9599 | datasette 107914493 | https://github.com/simonw/datasette/milestone/12 | MDk6TWlsZXN0b25lNTIzNDA3OQ== | 12 | 0 | 8 | closed | 2020-03-24T22:15:09Z | 2020-03-25T04:19:33Z | 2020-03-25T04:07:02Z | ||
5897911 | 2.20 | simonw 9599 | sqlite-utils 140912432 | https://github.com/simonw/sqlite-utils/milestone/3 | MDk6TWlsZXN0b25lNTg5NzkxMQ== | 3 | 0 | 8 | closed | 2020-09-20T22:06:21Z | 2020-11-06T23:52:09Z | 2020-11-06T23:52:09Z | ||
8303187 | Datasette 0.62 | simonw 9599 | datasette 107914493 | https://github.com/simonw/datasette/milestone/25 | MI_kwDOBm6k_c4AfrJT | 25 | 0 | 8 | closed | 2022-08-14T05:11:39Z | 2022-11-14T06:01:19Z | 2022-08-14T18:03:28Z |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [milestones] ( [id] INTEGER PRIMARY KEY, [title] TEXT, [description] TEXT, [creator] INTEGER REFERENCES [users]([id]), [repo] INTEGER REFERENCES [repos]([id]) , [html_url] TEXT, [node_id] TEXT, [number] INTEGER, [open_issues] INTEGER, [closed_issues] INTEGER, [state] TEXT, [created_at] TEXT, [updated_at] TEXT, [due_on] TEXT, [closed_at] TEXT); CREATE INDEX [idx_milestones_repo] ON [milestones] ([repo]); CREATE INDEX [idx_milestones_creator] ON [milestones] ([creator]);