releases

4 rows where repo = 281481347

✎ 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
28797259 https://github.com/simonw/datasette-copyable/releases/tag/0.1 simonw 9599 MDc6UmVsZWFzZTI4Nzk3MjU5 0.1 main 0.1 0 0 2020-07-21T19:04:17Z 2020-07-21T19:06:04Z * Initial release datasette-copyable 281481347    
28803002 https://github.com/simonw/datasette-copyable/releases/tag/0.2 simonw 9599 MDc6UmVsZWFzZTI4ODAzMDAy 0.2 main 0.2 0 0 2020-07-21T21:51:21Z 2020-07-21T21:52:57Z - TSV format is now compatible with Google Sheets and Excel. #3 - Table headings are now included in the formatted tables. #2 - Added a "Copy" button for copying the data to your clipboard. #1 - Plugin now has a live demo at https://fivethirtyeight.datasettes.com/ datasette-copyable 281481347    
31289890 https://github.com/simonw/datasette-copyable/releases/tag/0.3 simonw 9599 MDc6UmVsZWFzZTMxMjg5ODkw 0.3 main 0.3 0 0 2020-09-14T22:16:57Z 2020-09-14T22:17:41Z - Now depends on Datasette 0.49. datasette-copyable 281481347    
33958019 https://github.com/simonw/datasette-copyable/releases/tag/0.3.1 simonw 9599 MDc6UmVsZWFzZTMzOTU4MDE5 0.3.1 main 0.3.1 0 0 2020-11-14T21:44:37Z 2020-11-14T21:45:10Z - Fixed 500 error with `.copyable?_labels=on`. #4 datasette-copyable 281481347    

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