issue_comments
6 rows where "created_at" is on date 2018-04-26 sorted by node_id
This data as json, CSV (advanced)
Suggested facets: issue_url, issue, updated_at (date)
id | html_url | issue_url | node_id ▼ | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
384500327 | https://github.com/simonw/datasette/issues/239#issuecomment-384500327 | https://api.github.com/repos/simonw/datasette/issues/239 | MDEyOklzc3VlQ29tbWVudDM4NDUwMDMyNw== | simonw 9599 | 2018-04-26T03:18:12Z | 2018-04-26T03:18:20Z | OWNER | ``` { "databases": { "database1": { "tables": { "example_table": { "hidden": true } } } } } ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Support for hidden tables in metadata.json 317760361 | |
384503873 | https://github.com/simonw/datasette/issues/239#issuecomment-384503873 | https://api.github.com/repos/simonw/datasette/issues/239 | MDEyOklzc3VlQ29tbWVudDM4NDUwMzg3Mw== | simonw 9599 | 2018-04-26T03:45:11Z | 2018-04-26T03:45:11Z | OWNER | Documentation: http://datasette.readthedocs.io/en/latest/metadata.html#hiding-tables | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Support for hidden tables in metadata.json 317760361 | |
384512192 | https://github.com/simonw/datasette/issues/229#issuecomment-384512192 | https://api.github.com/repos/simonw/datasette/issues/229 | MDEyOklzc3VlQ29tbWVudDM4NDUxMjE5Mg== | simonw 9599 | 2018-04-26T04:49:46Z | 2018-04-26T04:49:46Z | OWNER | Documentation: http://datasette.readthedocs.io/en/latest/json_api.html#special-table-arguments | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Table view should support ?_size=400 parameter 316123256 | |
384675792 | https://github.com/simonw/datasette/issues/79#issuecomment-384675792 | https://api.github.com/repos/simonw/datasette/issues/79 | MDEyOklzc3VlQ29tbWVudDM4NDY3NTc5Mg== | simonw 9599 | 2018-04-26T15:08:13Z | 2018-04-26T15:08:13Z | OWNER | Docs now live at http://datasette.readthedocs.io/ I still need to document a few more parts of the API before closing this. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add more detailed API documentation to the README 273569068 | |
384676488 | https://github.com/simonw/datasette/issues/44#issuecomment-384676488 | https://api.github.com/repos/simonw/datasette/issues/44 | MDEyOklzc3VlQ29tbWVudDM4NDY3NjQ4OA== | simonw 9599 | 2018-04-26T15:09:57Z | 2018-04-26T15:09:57Z | OWNER | Remaining work for this is tracked in #150 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | ?_group_count=country - return counts by specific column(s) 269731374 | |
384678319 | https://github.com/simonw/datasette/issues/125#issuecomment-384678319 | https://api.github.com/repos/simonw/datasette/issues/125 | MDEyOklzc3VlQ29tbWVudDM4NDY3ODMxOQ== | simonw 9599 | 2018-04-26T15:14:31Z | 2018-04-26T15:14:31Z | OWNER | I shipped this last week as the first plugin: https://simonwillison.net/2018/Apr/20/datasette-plugins/ Demo: https://datasette-cluster-map-demo.datasettes.com/polar-bears-455fe3a/USGS_WC_eartags_output_files_2009-2011-Status Plugin: https://github.com/simonw/datasette-cluster-map | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Plot rows on a map with Leaflet and Leaflet.markercluster 275135393 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [issue_comments] ( [html_url] TEXT, [issue_url] TEXT, [id] INTEGER PRIMARY KEY, [node_id] TEXT, [user] INTEGER REFERENCES [users]([id]), [created_at] TEXT, [updated_at] TEXT, [author_association] TEXT, [body] TEXT, [reactions] TEXT, [issue] INTEGER REFERENCES [issues]([id]) , [performed_via_github_app] TEXT); CREATE INDEX [idx_issue_comments_issue] ON [issue_comments] ([issue]); CREATE INDEX [idx_issue_comments_user] ON [issue_comments] ([user]);
created_at (date) 1 ✖