4 rows where repo = 303218369

View and edit SQL

Suggested facets: created_at (date), published_at (date)

id ▼ html_url node_id tag_name target_commitish name draft author prerelease created_at published_at body repo reactions
32428098 https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.1 MDc6UmVsZWFzZTMyNDI4MDk4 0.1 main 0.1 0 simonw 9599 0 2020-10-11T21:46:09Z 2020-10-11T21:47:39Z - Initial release, with support for importing ENEX files. evernote-to-sqlite 303218369  
32429687 https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.2 MDc6UmVsZWFzZTMyNDI5Njg3 0.2 main 0.2 0 simonw 9599 0 2020-10-12T00:05:21Z 2020-10-12T00:07:24Z - Notes now use an ID derived from a hash of their contents. #3 - Date columns are now in ISO format, and indexd. #4 - Notes and resources table now have full-text search configured. #4 - Improved how OCR is stored in the database, only storing the most confident matches. #6 evernote-to-sqlite 303218369  
37946829 https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3 MDc6UmVsZWFzZTM3OTQ2ODI5 0.3 main 0.3 0 simonw 9599 0 2021-02-11T22:14:01Z 2021-02-11T22:16:20Z - Correctly handle entities in XHTML notes. [#9](https://github.com/dogsheep/evernote-to-sqlite/issues/9) - Fixed a bug importing ENEX files on Windows. Thanks, [dskrad](https://github.com/dskrad). [#11](https://github.com/dogsheep/evernote-to-sqlite/issues/11) evernote-to-sqlite 303218369  
37947725 https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3.1 MDc6UmVsZWFzZTM3OTQ3NzI1 0.3.1 main 0.3.1 0 simonw 9599 0 2021-02-11T22:38:21Z 2021-02-11T22:40:40Z - Explicitly open file using utf-8 encoding - thanks, RiverZhou. [#10](https://github.com/dogsheep/evernote-to-sqlite/pull/10) - Fix import error if note has no "updated" element - thanks, Matej Korosec. [#8](https://github.com/dogsheep/evernote-to-sqlite/pull/8) evernote-to-sqlite 303218369  

Advanced export

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

CSV options:

CREATE TABLE [releases] (
   [html_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [tag_name] TEXT,
   [target_commitish] TEXT,
   [name] TEXT,
   [draft] INTEGER,
   [author] INTEGER REFERENCES [users]([id]),
   [prerelease] INTEGER,
   [created_at] TEXT,
   [published_at] TEXT,
   [body] TEXT,
   [repo] INTEGER REFERENCES [repos]([id])
, [reactions] TEXT);
CREATE INDEX [idx_releases_repo]
                ON [releases] ([repo]);
CREATE INDEX [idx_releases_author]
                ON [releases] ([author]);