releases

4 rows where repo = 214299267

✎ View and edit SQL

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
20685181 https://github.com/simonw/datasette-render-timestamps/releases/tag/0.1 simonw 9599 MDc6UmVsZWFzZTIwNjg1MTgx 0.1 master 0.1 0 0 2019-10-10T22:53:49Z 2019-10-14T14:51:38Z Initial release datasette-render-timestamps 214299267    
20685215 https://github.com/simonw/datasette-render-timestamps/releases/tag/0.2 simonw 9599 MDc6UmVsZWFzZTIwNjg1MjE1 0.2 master 0.2 0 0 2019-10-14T14:51:18Z 2019-10-14T14:52:55Z * Ability to [configure date format](https://github.com/simonw/datasette-render-timestamps/blob/0.2/README.md#configuration) - (pull request #1). Thanks, @chris48s! datasette-render-timestamps 214299267    
24740155 https://github.com/simonw/datasette-render-timestamps/releases/tag/1.0 simonw 9599 MDc6UmVsZWFzZTI0NzQwMTU1 1.0 master 1.0 0 0 2020-03-21T21:37:37Z 2020-03-21T21:39:00Z * Optional explicit column configuration - #2 datasette-render-timestamps 214299267    
24740274 https://github.com/simonw/datasette-render-timestamps/releases/tag/1.0.1 simonw 9599 MDc6UmVsZWFzZTI0NzQwMjc0 1.0.1 master 1.0.1 0 0 2020-03-21T21:53:35Z 2020-03-21T21:54:08Z * Updated README datasette-render-timestamps 214299267    

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