releases

12 rows where repo = 237321267

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: html_url, tag_name, target_commitish, name, body, 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
23275372 https://github.com/simonw/geojson-to-sqlite/releases/tag/0.1a simonw 9599 MDc6UmVsZWFzZTIzMjc1Mzcy 0.1a master 0.1a 0 0 2020-01-31T00:57:53Z 2020-01-31T01:34:54Z Initial release, missing some of the features documented in the README. geojson-to-sqlite 237321267    
23278882 https://github.com/simonw/geojson-to-sqlite/releases/tag/0.1 simonw 9599 MDc6UmVsZWFzZTIzMjc4ODgy 0.1 master 0.1 0 0 2020-01-31T03:08:45Z 2020-01-31T06:37:32Z First non-alpha release. All documented features are now implemented. geojson-to-sqlite 237321267    
23278899 https://github.com/simonw/geojson-to-sqlite/releases/tag/0.1.1 simonw 9599 MDc6UmVsZWFzZTIzMjc4ODk5 0.1.1 master 0.1.1 0 0 2020-01-31T06:38:17Z 2020-01-31T06:39:07Z Fixed table creation bug with `--spatialite` option, #6 geojson-to-sqlite 237321267    
23314228 https://github.com/simonw/geojson-to-sqlite/releases/tag/0.1.2 simonw 9599 MDc6UmVsZWFzZTIzMzE0MjI4 0.1.2 master 0.1.2 0 0 2020-02-01T22:05:22Z 2020-02-01T22:06:43Z Upgraded for [sqlite-utils 2.2](https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v2-2). geojson-to-sqlite 237321267    
23576497 https://github.com/simonw/geojson-to-sqlite/releases/tag/0.2 simonw 9599 MDc6UmVsZWFzZTIzNTc2NDk3 0.2 master 0.2 0 0 2020-02-11T17:07:00Z 2020-02-11T17:08:48Z If the GeoJSON features have an `"id"` property it will now be used as the primary key, unless you specify another primary key using `--pk=property` or you disable primary keys entirely (hence using a SQLite `rowid`) with `--pk=''`. Thanks, Chris Amico. #11 geojson-to-sqlite 237321267    
43023999 https://github.com/simonw/geojson-to-sqlite/releases/tag/0.3 simonw 9599 MDc6UmVsZWFzZTQzMDIzOTk5 0.3 main 0.3 0 0 2021-05-17T00:14:20Z 2021-05-17T00:14:27Z - New `--nl` option for consuming newline-delimited GeoJSON - thanks, Chris Amico! [#13](https://github.com/simonw/geojson-to-sqlite/issues/13) - New `--spatial-index` option which creates the table using SpatiaLite and adds a spatial index for the geometry column. [#17](https://github.com/simonw/geojson-to-sqlite/issues/17) geojson-to-sqlite 237321267    
43310657 https://github.com/simonw/geojson-to-sqlite/releases/tag/0.3.1 simonw 9599 MDc6UmVsZWFzZTQzMzEwNjU3 0.3.1 main 0.3.1 0 0 2021-05-20T19:14:38Z 2021-05-20T19:15:44Z - Fixed bug where the `id` column did not come first in the table schema. [#20](https://github.com/simonw/geojson-to-sqlite/issues/20) geojson-to-sqlite 237321267    
60953146 https://github.com/simonw/geojson-to-sqlite/releases/tag/1.0 simonw 9599 RE_kwDODiU8M84DohI6 1.0 main 1.0 0 0 2022-03-04T02:12:12Z 2022-03-04T02:14:16Z - New `--properties` option for writing GeoJSON properties to a JSON column called `properties` - or use `--properties=props` to write to a column called `props`. Thanks, [Chris Amico](https://github.com/eyeseast). [#25](https://github.com/simonw/geojson-to-sqlite/issues/25) geojson-to-sqlite 237321267    
64180728 https://github.com/simonw/geojson-to-sqlite/releases/tag/1.0.1 simonw 9599 RE_kwDODiU8M84D01H4 1.0.1 main 1.0.1 0 0 2022-04-12T02:17:38Z 2022-04-12T02:19:54Z - Fixed bug where `--spatialite` option failed with an error if the GeoJSON features being loaded consisted of just a geometry with no properties. [#30](https://github.com/simonw/geojson-to-sqlite/issues/30) geojson-to-sqlite 237321267    
64180854 https://github.com/simonw/geojson-to-sqlite/releases/tag/1.0.1 simonw 9599 RE_kwDODiU8M84D01J2 1.0.1 main 1.0.1 0 0 2022-04-12T02:21:26Z 2022-04-12T02:22:01Z - Fixed bug where `--spatialite` option failed with an error if the GeoJSON features being loaded consisted of just a geometry with no properties. [#30](https://github.com/simonw/geojson-to-sqlite/issues/30) geojson-to-sqlite 237321267    
64323072 https://github.com/simonw/geojson-to-sqlite/releases/tag/1.1 simonw 9599 RE_kwDODiU8M84D1X4A 1.1 main 1.1 0 0 2022-04-13T04:55:59Z 2022-04-13T05:00:09Z - Command can now accept more than one GeoJSON file. The contents of all of the files will be inserted into the same table. [#21](https://github.com/simonw/geojson-to-sqlite/issues/21) - Using the `--spatial-index` option against the same database twice no longer triggers an error. - Now depends on [sqlite-utils 3.23](https://sqlite-utils.datasette.io/en/stable/changelog.html#v3-23) on higher, taking advantage of the SpatiaLite utilities in that library. Thanks, [Chris Amico](https://github.com/eyeseast). [#28](https://github.com/simonw/geojson-to-sqlite/issues/28) geojson-to-sqlite 237321267    
64416477 https://github.com/simonw/geojson-to-sqlite/releases/tag/1.1.1 simonw 9599 RE_kwDODiU8M84D1urd 1.1.1 main 1.1.1 0 0 2022-04-13T23:37:53Z 2022-04-13T23:39:25Z - Fixed a bug where a `_tmp` column remained after importing a geometry with no additional properties. [#30](https://github.com/simonw/geojson-to-sqlite/issues/30) - Added `--version` option to show the current installed version of the tool. [#32](https://github.com/simonw/geojson-to-sqlite/issues/32) geojson-to-sqlite 237321267    

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