releases

4 rows where repo = 221802296

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target_commitish, 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
21492081 https://github.com/simonw/datasette-template-sql/releases/tag/0.1 simonw 9599 MDc6UmVsZWFzZTIxNDkyMDgx 0.1 master 0.1 0 0 2019-11-14T23:33:28Z 2019-11-14T23:42:58Z First working version. datasette-template-sql 221802296    
25743791 https://github.com/simonw/datasette-template-sql/releases/tag/1.0 simonw 9599 MDc6UmVsZWFzZTI1NzQzNzkx 1.0 master 1.0 0 0 2020-04-21T23:28:25Z 2020-04-21T23:29:43Z * Backwards incompatible change: the second argument to the `sql()` function is now expected to be an optional list or dictionary of SQL parameters. Previously the second argument was the name of the database to run the query against - this should now be passed as a named `database=` argument instead. datasette-template-sql 221802296    
25746285 https://github.com/simonw/datasette-template-sql/releases/tag/1.0.1 simonw 9599 MDc6UmVsZWFzZTI1NzQ2Mjg1 1.0.1 master 1.0.1 0 0 2020-04-22T01:56:45Z 2020-04-22T01:57:02Z * Improved README datasette-template-sql 221802296    
37061922 https://github.com/simonw/datasette-template-sql/releases/tag/1.0.2 simonw 9599 MDc6UmVsZWFzZTM3MDYxOTIy 1.0.2 main 1.0.2 0 0 2021-01-29T02:28:00Z 2021-01-29T02:29:57Z - Updated for compatibility with latest Datasette. [#3](https://github.com/simonw/datasette-template-sql/issues/3) datasette-template-sql 221802296    

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