releases
1 row where author = 9599 and "published_at" is on date 2019-05-19
This data as json, CSV (advanced)
Suggested facets: created_at (date), published_at (date)
id ▼ | html_url | node_id | tag_name | target_commitish | name | draft | author | prerelease | created_at | published_at | body | repo | reactions |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17450414 | https://github.com/simonw/datasette/releases/tag/0.28 | MDc6UmVsZWFzZTE3NDUwNDE0 | 0.28 | master | Datasette 0.28 | 0 | simonw 9599 | 0 | 2019-05-19T21:37:49Z | 2019-05-19T21:42:28Z | [Datasette 0.28](https://datasette.readthedocs.io/en/stable/changelog.html#v0-28) - a salmagundi of new features! * No longer immutable! Datasette now supports [databases that change](https://datasette.readthedocs.io/en/stable/changelog.html#supporting-databases-that-change). * [Faceting improvements](https://datasette.readthedocs.io/en/stable/changelog.html#faceting-improvements-and-faceting-plugins) including facet-by-JSON-array and the ability to define custom faceting using plugins. * [datasette publish cloudrun](https://datasette.readthedocs.io/en/stable/changelog.html#datasette-publish-cloudrun) lets you publish databasese to Google's new Cloud Run hosting service. * New [register_output_renderer](https://datasette.readthedocs.io/en/stable/changelog.html#register-output-renderer-plugins) plugin hook for adding custom output extensions to Datasette in addition to the default `.json` and `.csv`. * Dozens of other smaller features and tweaks - see [the release notes](https://datasette.readthedocs.io/en/stable/changelog.html#v0-28) for full details. | datasette 107914493 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [releases] ( [html_url] TEXT, [id] INTEGER PRIMARY KEY, [node_id] TEXT, [tag_name] TEXT, [target_commitish] TEXT, [name] TEXT, [draft] INTEGER, [author] INTEGER REFERENCES [users]([id]), [prerelease] INTEGER, [created_at] TEXT, [published_at] TEXT, [body] TEXT, [repo] INTEGER REFERENCES [repos]([id]) , [reactions] TEXT); CREATE INDEX [idx_releases_repo] ON [releases] ([repo]); CREATE INDEX [idx_releases_author] ON [releases] ([author]);