home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 404954672

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-404954672 https://api.github.com/repos/simonw/datasette/issues/342 404954672 MDEyOklzc3VlQ29tbWVudDQwNDk1NDY3Mg== 9599 2018-07-13T21:09:01Z 2018-07-13T21:09:01Z OWNER

So it would look like this: { "databases": { "timezones": { "license": "ODbL", "license_url": "http://opendatacommons.org/licenses/odbl/", "queries": { "by_point": { "title": "Timezones by point", "description": "Find the timezone for a latitude/longitude point", "sql": "select tzid\nfrom\n timezones\nwhere\n within(GeomFromText('POINT(' || :longitude || ' ' || :latitude || ')'), timezones.Geometry)\n and rowid in (\n SELECT pkid FROM idx_timezones_Geometry\n where xmin < :longitude\n and xmax > :longitude\n and ymin < :latitude\n and ymax > :latitude\n )" } } } } }

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
341123355  
Powered by Datasette · Queries took 1.07ms · About: github-to-sqlite