releases
3 rows where repo = 530399214
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75697720 | https://github.com/simonw/datasette-sitemap/releases/tag/0.1 | simonw 9599 | RE_kwDOH50_7s4Egw44 | 0.1 | main | 0.1 | 0 | 0 | 2022-08-29T22:18:35Z | 2022-08-29T22:19:49Z | - Initial release: configure a SQL query to return a `/sitemap.xml` for your site. [#1](https://github.com/simonw/datasette-sitemap/issues/1) | datasette-sitemap 530399214 | ||
| 75699195 | https://github.com/simonw/datasette-sitemap/releases/tag/0.1.1 | simonw 9599 | RE_kwDOH50_7s4EgxP7 | 0.1.1 | main | 0.1.1 | 0 | 0 | 2022-08-29T22:35:37Z | 2022-08-29T22:36:22Z | - Fixed error on `/robot.txt` page. [#2](https://github.com/simonw/datasette-sitemap/issues/2) | datasette-sitemap 530399214 | ||
| 75809087 | https://github.com/simonw/datasette-sitemap/releases/tag/1.0 | simonw 9599 | RE_kwDOH50_7s4EhME_ | 1.0 | main | 1.0 | 0 | 0 | 2022-08-30T17:56:48Z | 2022-08-30T17:59:53Z | - This plugin now interacts correctly with the [datasette-block-robots](https://datasette.io/plugins/datasette-block-robots) plugin, adding the `Sitemap:` reference to the existing `robots.txt` file if that other plugin is installed. [#4](https://github.com/simonw/datasette-sitemap/issues/4) - Now registers a new [sitemap_extra_paths() plugin hook](https://github.com/simonw/datasette-sitemap/blob/1.0/README.md#adding-paths-to-the-sitemap-from-other-plugins) which other plugins can use to contribute to `/sitemap.xml`. [#5](https://github.com/simonw/datasette-sitemap/issues/5) | datasette-sitemap 530399214 |
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]);