milestones
4 rows where number = 1 sorted by created_at
This data as json, CSV (advanced)
Suggested facets: title, description, state, created_at (date), updated_at (date), due_on (date), closed_at (date)
| id | title | description | creator | repo | html_url | node_id | number | open_issues | closed_issues | state | created_at ▼ | updated_at | due_on | closed_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2857392 | Ship first public release | Just addressable content, a full JSON API and pages that don’t look terrible. | simonw 9599 | datasette 107914493 | https://github.com/simonw/datasette/milestone/1 | MDk6TWlsZXN0b25lMjg1NzM5Mg== | 1 | 0 | 49 | closed | 2017-10-23T01:24:24Z | 2019-07-07T20:31:25Z | 2017-11-13T08:00:00Z | 2017-11-14T08:24:21Z |
| 4348046 | 1.0 | 0.15 is already pretty stable - a few small fixes and I'm going to ship 1.0. | simonw 9599 | sqlite-utils 140912432 | https://github.com/simonw/sqlite-utils/milestone/1 | MDk6TWlsZXN0b25lNDM0ODA0Ng== | 1 | 0 | 4 | closed | 2019-05-25T00:11:25Z | 2019-05-25T01:28:06Z | 2019-05-25T01:28:06Z | |
| 5225818 | 1.0 | simonw 9599 | github-to-sqlite 207052882 | https://github.com/dogsheep/github-to-sqlite/milestone/1 | MDk6TWlsZXN0b25lNTIyNTgxOA== | 1 | 0 | 7 | closed | 2020-03-23T01:07:52Z | 2020-05-02T17:56:29Z | 2020-05-02T17:56:29Z | ||
| 5324096 | Apple Photos online and securely browsable | simonw 9599 | dogsheep-photos 256834907 | https://github.com/dogsheep/dogsheep-photos/milestone/1 | MDk6TWlsZXN0b25lNTMyNDA5Ng== | 1 | 2 | 2 | open | 2020-04-18T19:23:12Z | 2020-04-28T16:47:21Z |
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]);