releases

14 rows where repo = 293361514

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target_commitish, name, prerelease, body, mentions_count, 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
30926270 https://github.com/eyeseast/geocode-sqlite/releases/tag/0.1.2 eyeseast 25778 MDc6UmVsZWFzZTMwOTI2Mjcw 0.1.2 master v0.1.2 0 1 2020-09-08T17:48:24Z 2020-09-08T17:50:15Z Basic API is in place, with CLI support for Google, Bing, MapQuest and Nominatum (OSM) geocoders. geocode-sqlite 293361514    
31002895 https://github.com/eyeseast/geocode-sqlite/releases/tag/0.1.3 eyeseast 25778 MDc6UmVsZWFzZTMxMDAyODk1 0.1.3 master v0.1.3 0 1 2020-09-09T19:33:12Z 2020-09-09T19:34:18Z   geocode-sqlite 293361514    
40900177 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.2.0 eyeseast 25778 MDc6UmVsZWFzZTQwOTAwMTc3 v0.2.0 main Better argument and option ordering 0 0 2021-04-03T14:39:37Z 2021-04-03T14:44:11Z Arguments and options now follow a much more sensible order, following the example of other `thing-to-sqlite` tools. For example: ```sh geocode-sqlite nominatum geo.db innout_test \ --location "{full}, {city}, {state} {postcode}" \ --delay 1 \ --user-agent "geocode-sqlite" ``` The order is now: 1. `geocode-sqlite` 2. geocoder, such as `nominatum` 3. database path 4. table name 5. any additional options geocode-sqlite 293361514    
40918023 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.3.0 eyeseast 25778 MDc6UmVsZWFzZTQwOTE4MDIz v0.3.0 main Progress bars 0 0 2021-04-04T16:04:22Z 2021-04-04T16:06:40Z The CLI now shows a progress bar as you geocode. geocode-sqlite 293361514    
41450813 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.4.0 eyeseast 25778 MDc6UmVsZWFzZTQxNDUwODEz v0.4.0 main Label geocoder used for each row 0 0 2021-04-15T01:10:13Z 2021-04-15T01:14:15Z   geocode-sqlite 293361514    
41680056 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.5.0 eyeseast 25778 MDc6UmVsZWFzZTQxNjgwMDU2 v0.5.0 main   0 0 2021-04-20T01:38:25Z 2021-04-20T01:39:33Z Adds Mapbox geocoder. geocode-sqlite 293361514    
43095146 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.5.1 eyeseast 25778 MDc6UmVsZWFzZTQzMDk1MTQ2 v0.5.1 main   0 0 2021-05-18T01:31:57Z 2021-05-18T01:33:26Z   geocode-sqlite 293361514    
60735549 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.5.2 eyeseast 25778 RE_kwDOEXxXas4DnsA9 v0.5.2 main Fix bug updating rowid tables 0 0 2022-03-01T19:48:05Z 2022-03-01T19:49:19Z ## What's Changed * Require click >= 7.0 to hide commands by @1-Byte in https://github.com/eyeseast/geocode-sqlite/pull/20 * Fix error with rowid tables by @eyeseast in https://github.com/eyeseast/geocode-sqlite/pull/27 **Full Changelog**: https://github.com/eyeseast/geocode-sqlite/compare/v0.5.1...v0.5.2 geocode-sqlite 293361514   2
61620820 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.6.0 eyeseast 25778 RE_kwDOEXxXas4DrEJU v0.6.0 main GeoJSON and SpatiaLite support 0 0 2022-03-11T16:57:57Z 2022-03-11T16:58:49Z ## What's Changed * GeoJSON and SpatiaLite support by @eyeseast in https://github.com/eyeseast/geocode-sqlite/pull/23 **Full Changelog**: https://github.com/eyeseast/geocode-sqlite/compare/v0.5.2...v0.6.0 geocode-sqlite 293361514   1
61949501 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.6.1 eyeseast 25778 RE_kwDOEXxXas4DsUY9 v0.6.1 main v0.6.1 0 0 2022-03-16T01:38:54Z 2022-03-16T01:40:34Z ## What's Changed * if no bbox options are passed, `value` is None by @noslouch in https://github.com/eyeseast/geocode-sqlite/pull/30 * Pass --api-key to mapbox test by @eyeseast in https://github.com/eyeseast/geocode-sqlite/pull/33 ## New Contributors * @noslouch made their first contribution in https://github.com/eyeseast/geocode-sqlite/pull/30 **Full Changelog**: https://github.com/eyeseast/geocode-sqlite/compare/v0.6.0...v0.6.1 geocode-sqlite 293361514   2
81563402 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.7.0 eyeseast 25778 RE_kwDOEXxXas4E3I8K v0.7.0 main OpenCage 0 0 2022-10-31T15:03:29Z 2022-10-31T15:07:47Z The [OpenCage](https://opencagedata.com/) geocoding service is now supported. Thanks @sbscully. This library is now tested on Python 3.11. ## What's Changed * Add OpenCage option to CLI by @sbscully in https://github.com/eyeseast/geocode-sqlite/pull/39 ## New Contributors * @sbscully made their first contribution in https://github.com/eyeseast/geocode-sqlite/pull/39 **Full Changelog**: https://github.com/eyeseast/geocode-sqlite/compare/v0.6.1...v0.7.0 geocode-sqlite 293361514   1
82202036 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.8.0 eyeseast 25778 RE_kwDOEXxXas4E5k20 v0.8.0 main Capture raw geocoding response 0 0 2022-11-06T16:58:06Z 2022-11-06T16:59:21Z ## What's Changed * Just a typo! by @shaver in https://github.com/eyeseast/geocode-sqlite/pull/40 * Capture raw geocoding results by @eyeseast in https://github.com/eyeseast/geocode-sqlite/pull/41 ## New Contributors * @shaver made their first contribution in https://github.com/eyeseast/geocode-sqlite/pull/40 **Full Changelog**: https://github.com/eyeseast/geocode-sqlite/compare/v0.7.0...v0.8.0 geocode-sqlite 293361514   2
82202314 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.8.1 eyeseast 25778 RE_kwDOEXxXas4E5k7K v0.8.1 main v0.8.1 0 0 2022-11-06T17:10:17Z 2022-11-06T17:11:24Z ## What's Changed * Raw results in geocode_table, too by @eyeseast in https://github.com/eyeseast/geocode-sqlite/pull/42 **Full Changelog**: https://github.com/eyeseast/geocode-sqlite/compare/v0.8.0...v0.8.1 geocode-sqlite 293361514   1
82298335 https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.8.2 eyeseast 25778 RE_kwDOEXxXas4E58Xf v0.8.2 main v0.8.2 0 0 2022-11-07T17:28:31Z 2022-11-07T17:31:06Z ## What's Changed * Require requests. More forgiving timeout. by @eyeseast in https://github.com/eyeseast/geocode-sqlite/pull/43 **Full Changelog**: https://github.com/eyeseast/geocode-sqlite/compare/v0.8.1...v0.8.2 geocode-sqlite 293361514   1

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