issue_comments: 404954202
This data as json
| html_url | issue_url | id | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
|---|---|---|---|---|---|---|---|---|---|---|---|
| https://github.com/simonw/datasette/issues/342#issuecomment-404954202 | https://api.github.com/repos/simonw/datasette/issues/342 | 404954202 | MDEyOklzc3VlQ29tbWVudDQwNDk1NDIwMg== | 9599 | 2018-07-13T21:06:53Z | 2018-07-13T21:07:13Z | OWNER | https://timezones-api.now.sh/-/metadata currently shows this: ``` { "databases": { "timezones": { "license": "ODbL", "license_url": "http://opendatacommons.org/licenses/odbl/", "queries": { "by_point": "select tzid\nfrom\n timezones\nwhere\n within(GeomFromText(\u0027POINT(\u0027 || :longitude || \u0027 \u0027 || :latitude || \u0027)\u0027), timezones.Geometry)\n and rowid in (\n SELECT pkid FROM idx_timezones_Geometry\n where xmin \u003c :longitude\n and xmax \u003e :longitude\n and ymin \u003c :latitude\n and ymax \u003e :latitude\n )" }, "source": "timezone-boundary-builder", "source_url": "https://github.com/evansiroky/timezone-boundary-builder", "tables": { "timezones": { "license": "ODbL", "license_url": "http://opendatacommons.org/licenses/odbl/", "sortable_columns": [ "tzid" ], "source": "timezone-boundary-builder", "source_url": "https://github.com/evansiroky/timezone-boundary-builder" } } } }, "license": "ODbL", "license_url": "http://opendatacommons.org/licenses/odbl/", "source": "timezone-boundary-builder", "source_url": "https://github.com/evansiroky/timezone-boundary-builder", "title": "OpenStreetMap Time Zone Boundaries" } ``` We could support the value part of the `"queries"` array optionally being a dictionary with the same set of metadata fields supported for a table, plus a new `"sql"` key to hold the SQL for the query. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 341123355 |