releases

4 rows where repo = 374846311

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: body, 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
44366023 https://github.com/eyeseast/datasette-geojson/releases/tag/v0.2.0 eyeseast 25778 MDc6UmVsZWFzZTQ0MzY2MDIz v0.2.0 main Hello, World 0 0 2021-06-09T18:03:59Z 2021-06-09T18:09:41Z   datasette-geojson 374846311    
44368677 https://github.com/eyeseast/datasette-geojson/releases/tag/v0.2.1 eyeseast 25778 MDc6UmVsZWFzZTQ0MzY4Njc3 v0.2.1 main   0 0 2021-06-09T18:11:51Z 2021-06-09T18:56:21Z   datasette-geojson 374846311    
44527742 https://github.com/eyeseast/datasette-geojson/releases/tag/v0.3.0 eyeseast 25778 MDc6UmVsZWFzZTQ0NTI3NzQy v0.3.0 main Automatically parse spatialite's geometry blob 0 0 2021-06-13T00:02:32Z 2021-06-13T00:04:19Z - Spatialite's geometry blob is now automatically parsed into GeoJSON, so the same query will output GeoJSON with and without Spatialite. datasette-geojson 374846311    
59739939 https://github.com/eyeseast/datasette-geojson/releases/tag/v0.3.1 eyeseast 25778 RE_kwDOFlezZ84Dj48j v0.3.1 main Handle nulls 0 0 2022-02-16T20:01:35Z 2022-02-16T20:02:49Z ## What's Changed * Handle nulls in https://github.com/eyeseast/datasette-geojson/pull/11 **Full Changelog**: https://github.com/eyeseast/datasette-geojson/compare/v0.3.0...v0.3.1 datasette-geojson 374846311    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);