releases
2 rows where repo = 288629766
This data as json, CSV (advanced)
Suggested facets: created_at (date), published_at (date)
| id ▼ | html_url | author | node_id | tag_name | target_commitish | name | draft | prerelease | created_at | published_at | body | repo | reactions | mentions_count |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29845641 | https://github.com/simonw/datasette-schema-versions/releases/tag/0.1 | simonw 9599 | MDc6UmVsZWFzZTI5ODQ1NjQx | 0.1 | main | 0.1 | 0 | 0 | 2020-08-19T04:04:33Z | 2020-08-19T04:05:17Z | - Initial release | datasette-schema-versions 288629766 | ||
| 49381684 | https://github.com/simonw/datasette-schema-versions/releases/tag/0.2 | simonw 9599 | RE_kwDOETQkBs4C8YE0 | 0.2 | main | 0.2 | 0 | 0 | 2021-09-11T02:42:33Z | 2021-09-11T02:44:32Z | - Added an item to the global menu for the `root` user. [#1](https://github.com/simonw/datasette-schema-versions/issues/1) - Don't include `_internal`. [#2](https://github.com/simonw/datasette-schema-versions/issues/2) - Now offers HTML at `/-/schema-versions` and JSON at `/-/schema-versions.json`. [#3](https://github.com/simonw/datasette-schema-versions/issues/3) | datasette-schema-versions 288629766 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [releases] (
[html_url] TEXT,
[id] INTEGER PRIMARY KEY,
[author] INTEGER REFERENCES [users]([id]),
[node_id] TEXT,
[tag_name] TEXT,
[target_commitish] TEXT,
[name] TEXT,
[draft] INTEGER,
[prerelease] INTEGER,
[created_at] TEXT,
[published_at] TEXT,
[body] TEXT,
[repo] INTEGER REFERENCES [repos]([id])
, [reactions] TEXT, [mentions_count] INTEGER);
CREATE INDEX [idx_releases_repo]
ON [releases] ([repo]);
CREATE INDEX [idx_releases_author]
ON [releases] ([author]);