milestones
2 rows where "created_at" is on date 2020-09-20 sorted by creator
This data as json, CSV (advanced)
Suggested facets: updated_at (date)
closed_at (date) 2 ✖
- 2020-09-22 1
- 2020-11-06 1
repo 1 ✖
id | title | description | creator ▼ | repo | html_url | node_id | number | open_issues | closed_issues | state | created_at | updated_at | due_on | closed_at |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5896742 | 2.19 | simonw 9599 | sqlite-utils 140912432 | https://github.com/simonw/sqlite-utils/milestone/2 | MDk6TWlsZXN0b25lNTg5Njc0Mg== | 2 | 0 | 3 | closed | 2020-09-20T04:23:57Z | 2020-09-22T01:35:48Z | 2020-09-22T01:35:48Z | ||
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 |
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]);