releases

4 rows where repo = 299143849

✎ 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
31864793 https://github.com/simonw/datasette-dateutil/releases/tag/0.1 simonw 9599 MDc6UmVsZWFzZTMxODY0Nzkz 0.1 main 0.1 0 0 2020-09-28T00:14:27Z 2020-09-28T00:16:10Z - Initial release. datasette-dateutil 299143849    
31918957 https://github.com/simonw/datasette-dateutil/releases/tag/0.2 simonw 9599 MDc6UmVsZWFzZTMxOTE4OTU3 0.2 main 0.2 0 0 2020-09-29T06:39:54Z 2020-09-29T06:41:03Z - New `dateutil_rrule()` and `dateutil_rrule_date()` SQL functions. #1 - New `dateutil_dates_between()` SQL function. #1 datasette-dateutil 299143849    
31966141 https://github.com/simonw/datasette-dateutil/releases/tag/0.2.1 simonw 9599 MDc6UmVsZWFzZTMxOTY2MTQx 0.2.1 main 0.2.1 0 0 2020-09-30T01:06:50Z 2020-09-30T01:07:35Z - Documentation showing how to use these functions in conjunction with `json_each()` to join against other tables. #2 datasette-dateutil 299143849    
60664068 https://github.com/simonw/datasette-dateutil/releases/tag/0.3 simonw 9599 RE_kwDOEdSSqc4DnakE 0.3 main 0.3 0 0 2022-03-01T00:21:06Z 2022-03-01T00:22:13Z - The `dateutil_parse()`, `dateutil_parse_fuzzy()`, `dateutil_parse_dayfirst()` and `dateutil_parse_fuzzy_dayfirst()` functions all now accept an optional second argument specifying a "default" datetime to consider if some of the details are missing. [#5](https://github.com/simonw/datasette-dateutil/issues/5) datasette-dateutil 299143849    

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