_analyze_tables_
350 rows sorted by num_distinct descending
This data as json, CSV (advanced)
Suggested facets: num_blank
Link | table | column | total_rows | num_null | num_blank | num_distinct ▲ | most_common | least_common |
---|---|---|---|---|---|---|---|---|
stars,starred_at | stars | starred_at | 11236 | 0 | 0 | 11232 | [["2022-08-01T04:42:31Z", 2], ["2019-07-10T11:27:06Z", 2], ["2017-11-14T13:01:37Z", 2], ["2017-11-14T05:14:41Z", 2], ["2017-11-14T00:23:15Z", 1], ["2017-11-14T00:17:38Z", 1], ["2017-11-14T00:16:53Z", 1], ["2017-11-14T00:10:35Z", 1], ["2017-11-13T22:01:43Z", 1], ["2017-11-13T21:59:52Z", 1]] | [["2023-07-17T12:31:56Z", 1], ["2023-07-18T03:11:42Z", 1], ["2023-07-18T07:03:32Z", 1], ["2023-07-18T11:42:48Z", 1], ["2023-07-18T12:58:25Z", 1], ["2023-07-18T14:08:36Z", 1], ["2023-07-18T14:26:52Z", 1], ["2023-07-18T15:50:47Z", 1], ["2023-07-19T00:32:21Z", 1], ["2023-07-19T01:56:04Z", 1]] |
users,id | users | id | 10621 | 0 | 0 | 10621 | ||
users,node_id | users | node_id | 10621 | 0 | 0 | 10621 | ||
users,avatar_url | users | avatar_url | 10621 | 0 | 0 | 10621 | ||
users_fts_docsize,id | users_fts_docsize | id | 10621 | 0 | 0 | 10621 | ||
users,login | users | login | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
users,html_url | users | html_url | 10621 | 0 | 0 | 10620 | [["https://github.com/fineheard", 2], ["https://github.com/0nyr", 1], ["https://github.com/0nebody", 1], ["https://github.com/0ndrec", 1], ["https://github.com/0ihsan", 1], ["https://github.com/0asa", 1], ["https://github.com/0987031613dow", 1], ["https://github.com/03b8", 1], ["https://github.com/00mjk", 1], ["https://github.com/0-vortex", 1]] | [["https://github.com/zxygithub", 1], ["https://github.com/zy528", 1], ["https://github.com/zyuanlim", 1], ["https://github.com/zz", 1], ["https://github.com/zz0x", 1], ["https://github.com/zz2115", 1], ["https://github.com/zzeleznick", 1], ["https://github.com/zzkt", 1], ["https://github.com/zzl0", 1], ["https://github.com/zzlgreat", 1]] |
users,name | users | name | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
users_fts,login | users_fts | login | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
users_fts,name | users_fts | name | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
issue_comments,html_url | issue_comments | html_url | 9947 | 0 | 0 | 9947 | ||
issue_comments,id | issue_comments | id | 9947 | 0 | 0 | 9947 | ||
issue_comments,node_id | issue_comments | node_id | 9947 | 0 | 0 | 9947 | ||
issue_comments_fts_docsize,id | issue_comments_fts_docsize | id | 9947 | 0 | 0 | 9947 | ||
issue_comments,created_at | issue_comments | created_at | 9947 | 0 | 0 | 9946 | [["2021-01-04T19:52:40Z", 2], ["2017-10-23T15:28:11Z", 1], ["2017-10-23T02:28:31Z", 1], ["2017-10-23T02:18:36Z", 1], ["2017-10-23T02:16:33Z", 1], ["2017-10-23T02:15:41Z", 1], ["2017-10-23T01:35:17Z", 1], ["2017-10-23T01:20:30Z", 1], ["2017-10-23T01:15:24Z", 1], ["2017-10-23T01:09:05Z", 1]] | [["2023-07-14T16:26:27Z", 1], ["2023-07-14T17:02:03Z", 1], ["2023-07-17T02:23:32Z", 1], ["2023-07-17T17:14:20Z", 1], ["2023-07-17T17:24:19Z", 1], ["2023-07-17T21:27:41Z", 1], ["2023-07-17T21:42:37Z", 1], ["2023-07-18T11:47:21Z", 1], ["2023-07-18T19:08:50Z", 1], ["2023-07-18T22:41:37Z", 1]] |
issue_comments,updated_at | issue_comments | updated_at | 9947 | 0 | 0 | 9946 | [["2021-01-04T19:52:40Z", 2], ["2017-10-23T19:23:29Z", 1], ["2017-10-23T15:28:11Z", 1], ["2017-10-23T02:29:05Z", 1], ["2017-10-23T02:18:36Z", 1], ["2017-10-23T02:16:33Z", 1], ["2017-10-23T02:15:41Z", 1], ["2017-10-23T01:35:17Z", 1], ["2017-10-23T01:20:30Z", 1], ["2017-10-23T01:15:24Z", 1]] | [["2023-07-14T16:32:49Z", 1], ["2023-07-14T17:02:03Z", 1], ["2023-07-17T02:23:32Z", 1], ["2023-07-17T17:14:20Z", 1], ["2023-07-17T17:25:12Z", 1], ["2023-07-17T21:27:41Z", 1], ["2023-07-17T21:42:37Z", 1], ["2023-07-18T11:47:21Z", 1], ["2023-07-18T19:08:50Z", 1], ["2023-07-18T22:41:37Z", 1]] |
issue_comments,body | issue_comments | body | 9947 | 0 | 0 | 9853 | [["Thanks!", 30], ["That fixed it.", 6], ["Tracking ticket: #1023", 5], ["Thanks for this!", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["@dependabot recreate", 4], ["Just needs documentation now.", 3], ["Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-al...", 3], ["Blocked on #37", 3]] | [["you should have a look at Roda written in ruby . ", 1], ["| addr | opcode | p1 | p2 | p3 | p4 | p5 | c...", 1], ["❤️ thanks!", 1], ["🎉 Thanks so much @simonw ! 🎉 ", 1], ["👋 could I help somehow for this to be merged? As Big Sur is going to be more us...", 1], ["👋 Any update on getting this merged?\r\n\r\nAlternatively, is there a work around fo...", 1], ["👋 I'd be interested in building this out in Q1 or Q2 of 2020 if nobody has tackl...", 1], ["👍 I'd like this too! ", 1], ["🤯 this is beautiful. Thanks @simonw !", 1], ["🤷♂️ @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 1]] |
issue_comments_fts,body | issue_comments_fts | body | 9947 | 0 | 0 | 9853 | [["Thanks!", 30], ["That fixed it.", 6], ["Tracking ticket: #1023", 5], ["Thanks for this!", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["@dependabot recreate", 4], ["Just needs documentation now.", 3], ["Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-al...", 3], ["Blocked on #37", 3]] | [["you should have a look at Roda written in ruby . ", 1], ["| addr | opcode | p1 | p2 | p3 | p4 | p5 | c...", 1], ["❤️ thanks!", 1], ["🎉 Thanks so much @simonw ! 🎉 ", 1], ["👋 could I help somehow for this to be merged? As Big Sur is going to be more us...", 1], ["👋 Any update on getting this merged?\r\n\r\nAlternatively, is there a work around fo...", 1], ["👋 I'd be interested in building this out in Q1 or Q2 of 2020 if nobody has tackl...", 1], ["👍 I'd like this too! ", 1], ["🤯 this is beautiful. Thanks @simonw !", 1], ["🤷♂️ @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 1]] |
stars,user | stars | user | 11236 | 0 | 0 | 9675 | [[100658940, 10], [366688, 10], [178424, 10], [41546558, 9], [948118, 9], [7476523, 8], [161718, 8], [128885, 8], [46511, 8], [14772, 8]] | [[132673404, 1], [134146004, 1], [134528840, 1], [134682577, 1], [135533341, 1], [136005892, 1], [137419843, 1], [137427584, 1], [139175847, 1], [139538131, 1]] |
commits,sha | commits | sha | 3784 | 0 | 0 | 3784 | ||
commits_fts_docsize,id | commits_fts_docsize | id | 3784 | 0 | 0 | 3784 | ||
commits,author_date | commits | author_date | 3784 | 0 | 0 | 3781 | [["2022-12-15T17:34:07Z", 2], ["2022-03-15T15:36:35Z", 2], ["2021-07-30T00:44:16Z", 2], ["2017-10-24T02:36:44Z", 1], ["2017-10-24T02:25:48Z", 1], ["2017-10-24T02:00:37Z", 1], ["2017-10-23T16:02:40Z", 1], ["2017-10-23T15:28:00Z", 1], ["2017-10-23T00:41:19Z", 1], ["2017-10-23T00:39:03Z", 1]] | [["2023-07-08T18:40:19Z", 1], ["2023-07-08T19:50:22Z", 1], ["2023-07-08T20:08:09Z", 1], ["2023-07-09T01:03:25Z", 1], ["2023-07-09T01:03:41Z", 1], ["2023-07-09T01:04:14Z", 1], ["2023-07-09T01:05:05Z", 1], ["2023-07-09T01:13:36Z", 1], ["2023-07-09T01:14:06Z", 1], ["2023-07-10T19:24:26Z", 1]] |
commits,message | commits | message | 3784 | 0 | 0 | 3679 | [["Fixed typo", 12], ["Applied Black", 11], ["Typo fix", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 6], ["Release 0.4", 4], ["Release 0.3", 4], ["Fixed typo in release notes", 4], ["Changelog badge", 4]] | [["view-instance permission for debug URLs, closes #833", 1], ["where= and where_args= parameters to search() and search_sql()\n\nCloses #441", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["will, not may - refs #468", 1], ["word-break: break-word;", 1], ["word-wrap: anywhere on links in cells, refs #1805", 1], ["workflow_dispatch", 1], ["x button for clearing filters, refs #1016", 1], ["xfail documentation unit tests for view classes, refs #299\n\nMore documentation u...", 1], ["© 2017-2021", 1]] |
commits_fts,message | commits_fts | message | 3784 | 0 | 0 | 3679 | [["Fixed typo", 12], ["Applied Black", 11], ["Typo fix", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 6], ["Release 0.4", 4], ["Release 0.3", 4], ["Fixed typo in release notes", 4], ["Changelog badge", 4]] | [["view-instance permission for debug URLs, closes #833", 1], ["where= and where_args= parameters to search() and search_sql()\n\nCloses #441", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["will, not may - refs #468", 1], ["word-break: break-word;", 1], ["word-wrap: anywhere on links in cells, refs #1805", 1], ["workflow_dispatch", 1], ["x button for clearing filters, refs #1016", 1], ["xfail documentation unit tests for view classes, refs #299\n\nMore documentation u...", 1], ["© 2017-2021", 1]] |
commits,committer_date | commits | committer_date | 3784 | 0 | 0 | 3656 | [["2018-05-16T15:27:24Z", 23], ["2022-12-17T21:47:55Z", 18], ["2020-10-27T19:39:55Z", 11], ["2018-04-09T05:10:22Z", 9], ["2020-06-01T01:16:42Z", 8], ["2022-12-31T18:52:37Z", 6], ["2022-01-06T06:24:53Z", 6], ["2020-11-06T18:30:41Z", 6], ["2019-07-03T03:23:05Z", 5], ["2018-05-14T03:04:23Z", 5]] | [["2023-07-08T18:00:08Z", 1], ["2023-07-08T18:22:21Z", 1], ["2023-07-08T18:35:15Z", 1], ["2023-07-08T18:40:19Z", 1], ["2023-07-08T19:50:22Z", 1], ["2023-07-08T20:08:09Z", 1], ["2023-07-09T01:05:05Z", 1], ["2023-07-09T01:13:36Z", 1], ["2023-07-09T01:14:06Z", 1], ["2023-07-10T19:24:26Z", 1]] |
issues,id | issues | id | 2892 | 0 | 0 | 2892 | ||
issues,node_id | issues | node_id | 2892 | 0 | 0 | 2892 | ||
issues,created_at | issues | created_at | 2892 | 0 | 0 | 2892 | ||
issues_fts_docsize,id | issues_fts_docsize | id | 2892 | 0 | 0 | 2892 | ||
issues,reactions | issues | reactions | 2892 | 2 | 0 | 2890 | [["None", 2], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/5/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/4/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/3/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/2/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/13/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/12/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/11/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/10/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/1/re...", 1]] | [["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/90/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/91/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/92/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/93/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/94/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/95/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/96/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/97/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/98/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/99/reactions\", ...", 1]] |
issues,title | issues | title | 2892 | 0 | 0 | 2877 | [["Update deploying.rst", 2], ["Update README.md", 2], ["Test against Python 3.11-dev", 2], ["TemplateAssertionError: no filter named 'tojson'", 2], ["Support for generated columns", 2], ["Magic parameters for canned queries", 2], ["Drop support for Python 3.6", 2], ["Configure sphinx.ext.extlinks for issues", 2], ["Add paths for homebrew on Apple silicon", 2], ["Add SpatiaLite helpers to CLI", 2]] | [["utils.parse_metadata() should be a documented internal function", 1], ["v0.54 500 error from sql query in custom template; code worked in v0.53; found a...", 1], ["validating the sql", 1], ["view_name = \"query\" for the query page", 1], ["when hashed urls are turned on, the _memory db has improperly long-lived cache e...", 1], ["word-wrap: anywhere resulting in weird display", 1], ["xml.etree.ElementTree.Parse Error - mismatched tag", 1], ["xml.etree.ElementTree.ParseError: not well-formed (invalid token)", 1], ["{\"$file\": ...} mechanism is broken", 1], ["{{ csrftoken() }} doesn't work with datasette.render_template()", 1]] |
issues_fts,title | issues_fts | title | 2892 | 0 | 0 | 2877 | [["Update deploying.rst", 2], ["Update README.md", 2], ["Test against Python 3.11-dev", 2], ["TemplateAssertionError: no filter named 'tojson'", 2], ["Support for generated columns", 2], ["Magic parameters for canned queries", 2], ["Drop support for Python 3.6", 2], ["Configure sphinx.ext.extlinks for issues", 2], ["Add paths for homebrew on Apple silicon", 2], ["Add SpatiaLite helpers to CLI", 2]] | [["utils.parse_metadata() should be a documented internal function", 1], ["v0.54 500 error from sql query in custom template; code worked in v0.53; found a...", 1], ["validating the sql", 1], ["view_name = \"query\" for the query page", 1], ["when hashed urls are turned on, the _memory db has improperly long-lived cache e...", 1], ["word-wrap: anywhere resulting in weird display", 1], ["xml.etree.ElementTree.Parse Error - mismatched tag", 1], ["xml.etree.ElementTree.ParseError: not well-formed (invalid token)", 1], ["{\"$file\": ...} mechanism is broken", 1], ["{{ csrftoken() }} doesn't work with datasette.render_template()", 1]] |
issues,updated_at | issues | updated_at | 2892 | 0 | 0 | 2782 | [["2019-05-29T21:39:12Z", 7], ["2022-03-19T04:04:49Z", 5], ["2022-02-05T00:04:26Z", 5], ["2021-06-17T18:12:32Z", 5], ["2018-07-24T04:53:20Z", 5], ["2022-01-13T22:21:29Z", 4], ["2021-06-17T18:14:24Z", 4], ["2021-06-17T18:12:31Z", 4], ["2020-10-23T19:44:06Z", 4], ["2020-09-30T20:36:12Z", 4]] | [["2023-07-12T16:38:28Z", 1], ["2023-07-13T09:30:50Z", 1], ["2023-07-13T15:24:18Z", 1], ["2023-07-14T17:02:03Z", 1], ["2023-07-17T02:23:32Z", 1], ["2023-07-17T16:18:25Z", 1], ["2023-07-17T21:42:37Z", 1], ["2023-07-18T11:47:21Z", 1], ["2023-07-18T19:08:50Z", 1], ["2023-07-18T22:41:37Z", 1]] |
issues,body | issues | body | 2892 | 13 | 99 | 2778 | [["", 99], ["None", 13], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] | [["ujson is already a dependency of Sanic, and should be quite a bit faster.", 1], ["uvicorn-0.8 relies on websockets-0.7 which lacks python-3.8 compatiblity", 1], ["v0.54 500 error in sql query template; code worked in v0.53; found a workaround\r...", 1], ["vegaEmbed is a LOT of code (it bundles d3)\r\n\r\nInspired by this tweet: https://tw...", 1], ["view-source:https://calands.datasettes.com/calands/CPAD_2020a_SuperUnits.geojson...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["would it be possible to:\r\n- remove uvicorn mandatory dependancy ?\r\n- eventually ...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1], ["👋 trying to upgrade the formula to use the latest release, but runs into some r...", 1], ["👋 thank you for an incredibly useful project! \r\n\r\nI have noticed that my deploye...", 1]] |
issues_fts,body | issues_fts | body | 2892 | 13 | 99 | 2778 | [["", 99], ["None", 13], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] | [["ujson is already a dependency of Sanic, and should be quite a bit faster.", 1], ["uvicorn-0.8 relies on websockets-0.7 which lacks python-3.8 compatiblity", 1], ["v0.54 500 error in sql query template; code worked in v0.53; found a workaround\r...", 1], ["vegaEmbed is a LOT of code (it bundles d3)\r\n\r\nInspired by this tweet: https://tw...", 1], ["view-source:https://calands.datasettes.com/calands/CPAD_2020a_SuperUnits.geojson...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["would it be possible to:\r\n- remove uvicorn mandatory dependancy ?\r\n- eventually ...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1], ["👋 trying to upgrade the formula to use the latest release, but runs into some r...", 1], ["👋 thank you for an incredibly useful project! \r\n\r\nI have noticed that my deploye...", 1]] |
issue_comments,issue_url | issue_comments | issue_url | 9947 | 0 | 0 | 2346 | [["https://api.github.com/repos/simonw/datasette/issues/782", 54], ["https://api.github.com/repos/simonw/datasette/issues/1293", 51], ["https://api.github.com/repos/simonw/datasette/issues/1999", 49], ["https://api.github.com/repos/simonw/datasette/issues/1893", 48], ["https://api.github.com/repos/simonw/datasette/issues/1439", 48], ["https://api.github.com/repos/simonw/datasette/issues/983", 47], ["https://api.github.com/repos/simonw/datasette/issues/1518", 45], ["https://api.github.com/repos/simonw/datasette/issues/1249", 45], ["https://api.github.com/repos/simonw/datasette/issues/272", 42], ["https://api.github.com/repos/simonw/datasette/issues/699", 40]] | [["https://api.github.com/repos/simonw/sqlite-utils/issues/563", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/565", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/58", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/6", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/63", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/68", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/75", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/83", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/85", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/91", 1]] |
issue_comments,issue | issue_comments | issue | 9947 | 0 | 0 | 2346 | [[627794879, 54], [849978964, 51], [1551694938, 49], [1450363982, 48], [973139047, 48], [712260429, 47], [1058072543, 45], [824064069, 45], [324188953, 42], [582526961, 40]] | [[1718576761, 1], [1718612569, 1], [1720096994, 1], [1733198948, 1], [1740026046, 1], [1777548699, 1], [1784794489, 1], [1785360409, 1], [1786258502, 1], [1803264272, 1]] |
issues,closed_at | issues | closed_at | 2892 | 748 | 0 | 2084 | [["None", 748], ["2020-10-29T22:01:39Z", 3], ["2019-06-30T23:50:55Z", 2], ["2019-05-01T23:01:57Z", 2], ["2019-02-24T04:02:20Z", 2], ["2018-08-05T00:14:57Z", 2], ["2018-07-26T05:16:00Z", 2], ["2018-05-22T19:35:22Z", 2], ["2018-05-04T18:05:04Z", 2], ["2018-04-13T18:18:59Z", 2]] | [["2023-06-14T23:11:47Z", 1], ["2023-06-25T23:25:51Z", 1], ["2023-06-27T18:50:08Z", 1], ["2023-06-29T14:31:54Z", 1], ["2023-06-29T14:48:10Z", 1], ["2023-06-29T15:24:13Z", 1], ["2023-07-03T04:58:21Z", 1], ["2023-07-03T05:42:30Z", 1], ["2023-07-08T20:08:13Z", 1], ["2023-07-09T01:19:42Z", 1]] |
issues_labels,issues_id | issues_labels | issues_id | 3206 | 0 | 0 | 2033 | [[775666296, 7], [647103735, 6], [323658641, 6], [1122557010, 5], [726094754, 5], [725184645, 5], [652961907, 5], [582526961, 5], [573755726, 5], [317714268, 4]] | [[1784794489, 1], [1786243905, 1], [1795051447, 1], [1795187493, 1], [1795219865, 1], [1796830110, 1], [1798901709, 1], [1801394744, 1], [1808116827, 1], [1808215339, 1]] |
issues,number | issues | number | 2892 | 0 | 0 | 2009 | [[2, 16], [1, 16], [6, 14], [5, 14], [4, 14], [3, 14], [8, 13], [7, 13], [10, 12], [9, 12]] | [[2095, 1], [2096, 1], [2097, 1], [2098, 1], [2099, 1], [2100, 1], [2101, 1], [2102, 1], [2103, 1], [2104, 1]] |
emojis,name | emojis | name | 1877 | 0 | 0 | 1877 | ||
emojis,url | emojis | url | 1877 | 0 | 0 | 1834 | [["https://github.githubassets.com/images/icons/emoji/unicode/1f4a9.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f44a.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f34a.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f42c.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f41d.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f3ee.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f3c3.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f314.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f1ec-1f1e7.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f1ea-1f1fa.png?v8", 2]] | [["https://github.githubassets.com/images/icons/emoji/unicode/2b06.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b07.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b1b.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b1c.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b50.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b55.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3030.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/303d.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3297.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3299.png?v8", 1]] |
emojis,image | emojis | image | 1877 | 0 | 0 | 1750 | [["b'Not Found\\n'", 83], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 3], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 3], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 3], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x04\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x03\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x03\\x00\\x00\\...", 2]] | [["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00K\\x00\\x00\\x00K\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00P\\x00\\x00\\x00P\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00P\\x00\\x00\\x00P\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00P\\x00\\x00\\x00P\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00\\x80\\x00\\x00\\x00\\x80\\x08\\x06\\x0...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00\\x80\\x00\\x00\\x00\\x80\\x08\\x06\\x0...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x03 \\x00\\x00\\x01\\xe0\\x01\\x03\\x00\\x...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x03\\xe8\\x00\\x00\\x02X\\x08\\x03\\x00\\x...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x04\\xb0\\x00\\x00\\x03 \\x08\\x02\\x00\\x...", 1]] |
dependents,first_seen_utc | dependents | first_seen_utc | 1658 | 0 | 0 | 1658 | ||
issues_fts_docsize,sz | issues_fts_docsize | sz | 2892 | 0 | 0 | 1520 | [["b'\\x07\\x00'", 19], ["b'\\x06\\x00'", 16], ["b'\\x05\\x00'", 15], ["b'\\x04\\x00'", 14], ["b'\\x08\\x02'", 13], ["b'\\x07\\x02'", 13], ["b'\\t\\x00'", 13], ["b'\\x05\\x02'", 11], ["b'\\x04\\x02'", 10], ["b'\\x03\\x00'", 9]] | [["b'\\x14\\x81M'", 1], ["b'\\x14\\x81e'", 1], ["b'\\x14\\x82\\x11'", 1], ["b'\\x14o'", 1], ["b'\\x14z'", 1], ["b'\\x15\\x84='", 1], ["b'\\x15g'", 1], ["b'\\x15h'", 1], ["b'\\x16\\x06'", 1], ["b'\\x196'", 1]] |
repos,id | repos | id | 1329 | 0 | 0 | 1329 | ||
repos,node_id | repos | node_id | 1329 | 0 | 0 | 1329 | ||
repos,full_name | repos | full_name | 1329 | 0 | 0 | 1329 | ||
repos,html_url | repos | html_url | 1329 | 0 | 0 | 1329 | ||
repos,created_at | repos | created_at | 1329 | 0 | 0 | 1329 | ||
repos_fts_docsize,id | repos_fts_docsize | id | 1329 | 0 | 0 | 1329 | ||
dependents,dependent | dependents | dependent | 1658 | 0 | 0 | 1328 | [[138329050, 2], [112050382, 2], [107914493, 2], [99911706, 2], [79072630, 2], [51720846, 2], [51665750, 2], [24275324, 2], [18156953, 2], [5832996, 2]] | [[663556926, 1], [663586533, 1], [664178911, 1], [664727381, 1], [664733539, 1], [664753575, 1], [664756551, 1], [664757179, 1], [665383572, 1], [665620099, 1]] |
repos,updated_at | repos | updated_at | 1329 | 0 | 0 | 1317 | [["2021-11-24T19:31:59Z", 3], ["2022-12-10T00:06:05Z", 2], ["2022-11-21T08:21:35Z", 2], ["2022-10-31T13:47:34Z", 2], ["2022-09-01T10:42:32Z", 2], ["2022-07-18T23:51:45Z", 2], ["2022-07-06T18:40:32Z", 2], ["2022-02-28T23:42:41Z", 2], ["2021-09-11T10:57:40Z", 2], ["2020-10-31T14:01:13Z", 2]] | [["2023-07-13T21:14:27Z", 1], ["2023-07-14T19:45:37Z", 1], ["2023-07-14T19:47:49Z", 1], ["2023-07-15T07:05:31Z", 1], ["2023-07-15T19:41:49Z", 1], ["2023-07-17T00:58:30Z", 1], ["2023-07-17T09:23:52Z", 1], ["2023-07-18T08:42:15Z", 1], ["2023-07-18T15:50:48Z", 1], ["2023-07-19T01:56:05Z", 1]] |
repos,pushed_at | repos | pushed_at | 1329 | 0 | 0 | 1312 | [["2019-11-08T13:36:41Z", 6], ["2022-08-18T07:41:34Z", 2], ["2022-04-23T21:22:30Z", 2], ["2022-03-02T00:48:14Z", 2], ["2022-02-28T23:42:38Z", 2], ["2021-11-10T08:58:09Z", 2], ["2021-09-26T22:32:21Z", 2], ["2021-09-11T10:57:37Z", 2], ["2020-10-31T13:33:52Z", 2], ["2019-11-09T20:10:09Z", 2]] | [["2023-07-13T19:29:56Z", 1], ["2023-07-13T21:59:01Z", 1], ["2023-07-14T00:47:11Z", 1], ["2023-07-14T01:36:21Z", 1], ["2023-07-14T17:33:52Z", 1], ["2023-07-14T18:01:50Z", 1], ["2023-07-14T21:25:15Z", 1], ["2023-07-14T23:22:55Z", 1], ["2023-07-17T01:20:34Z", 1], ["2023-07-18T10:32:23Z", 1]] |
repos,name | repos | name | 1329 | 0 | 0 | 1113 | [["til", 31], ["cloud-data-quality", 31], ["datasette", 20], ["covid19-dashboard", 17], ["omspy", 10], ["devops_aula07", 9], ["cloudgoat", 9], ["calishot", 8], ["devops-aula07", 7], ["TIL", 7]] | [["yeet", 1], ["yt-fts", 1], ["yumyum", 1], ["z1007816", 1], ["zctaimpacts", 1], ["zero-server", 1], ["zeusops-attendance-analysis", 1], ["zeusops-attendance-bot", 1], ["zhaobai", 1], ["zoned-receiving", 1]] |
repos_fts,name | repos_fts | name | 1329 | 0 | 0 | 1113 | [["til", 31], ["cloud-data-quality", 31], ["datasette", 20], ["covid19-dashboard", 17], ["omspy", 10], ["devops_aula07", 9], ["cloudgoat", 9], ["calishot", 8], ["devops-aula07", 7], ["TIL", 7]] | [["yeet", 1], ["yt-fts", 1], ["yumyum", 1], ["z1007816", 1], ["zctaimpacts", 1], ["zero-server", 1], ["zeusops-attendance-analysis", 1], ["zeusops-attendance-bot", 1], ["zhaobai", 1], ["zoned-receiving", 1]] |
repos,owner | repos | owner | 1329 | 0 | 0 | 805 | [[9599, 193], [25778, 17], [53015001, 14], [44060760, 13], [15178711, 13], [28694175, 12], [1223, 12], [39538958, 9], [5802411, 9], [193185, 7]] | [[127496762, 1], [127565535, 1], [128680267, 1], [128963156, 1], [129124879, 1], [131779294, 1], [131845973, 1], [132527556, 1], [133026375, 1], [139249755, 1]] |
issue_comments_fts_idx,term | issue_comments_fts_idx | term | 943 | 0 | 0 | 785 | [["b'0a0'", 6], ["b''", 6], ["b'0tho'", 5], ["b'0thea'", 5], ["b'0httpt'", 5], ["b'0worka'", 4], ["b'0uu'", 4], ["b'0off'", 4], ["b'0ite'", 4], ["b'030'", 3]] | [["b'0\\xe1'", 1], ["b'0widths'", 1], ["b'0withoutr'", 1], ["b'0wouldn'", 1], ["b'0writem'", 1], ["b'0writer'", 1], ["b'0wrot'", 1], ["b'0yc'", 1], ["b'0youg'", 1], ["b'0yours'", 1]] |
repos,description | repos | description | 1329 | 431 | 0 | 771 | [["None", 431], ["Data Quality Engine for BigQuery", 31], ["A site that displays up to date COVID-19 stats, powered by fastpages.", 18], ["Improved Order Management System for stock trading", 10], ["An open source multi-tool for exploring and publishing data", 9], ["Today I Learned", 8], ["CloudGoat is Rhino Security Labs' \"Vulnerable by Design\" AWS deployment tool", 7], ["Save data from Pinboard to a SQLite database.", 6], ["Tool to index and serve HTML files. Powered by Datasette.", 5], ["A tool for exploring and publishing data", 5]] | [["自托管 Webfont 字体生成接口", 1], ["論文をChatGPTに要約させて毎日Slackに配信させるツール", 1], ["🌍 Import geographic and spatial data from files into a SpatiaLite DB", 1], ["🎓 coding exercises from leetcode, hackerrank, codesignal etc.", 1], ["👨⚕️ health stats from my apple watch", 1], ["📝 Today I Learned", 1], ["📦 course materials, demos, and hands-outs for all the courses I have taken till...", 1], ["📦 data crawler", 1], ["📰 Today I Learned", 1], ["📻 my notes on various topics", 1]] |
repos_fts,description | repos_fts | description | 1329 | 431 | 0 | 771 | [["None", 431], ["Data Quality Engine for BigQuery", 31], ["A site that displays up to date COVID-19 stats, powered by fastpages.", 18], ["Improved Order Management System for stock trading", 10], ["An open source multi-tool for exploring and publishing data", 9], ["Today I Learned", 8], ["CloudGoat is Rhino Security Labs' \"Vulnerable by Design\" AWS deployment tool", 7], ["Save data from Pinboard to a SQLite database.", 6], ["Tool to index and serve HTML files. Powered by Datasette.", 5], ["A tool for exploring and publishing data", 5]] | [["自托管 Webfont 字体生成接口", 1], ["論文をChatGPTに要約させて毎日Slackに配信させるツール", 1], ["🌍 Import geographic and spatial data from files into a SpatiaLite DB", 1], ["🎓 coding exercises from leetcode, hackerrank, codesignal etc.", 1], ["👨⚕️ health stats from my apple watch", 1], ["📝 Today I Learned", 1], ["📦 course materials, demos, and hands-outs for all the courses I have taken till...", 1], ["📦 data crawler", 1], ["📰 Today I Learned", 1], ["📻 my notes on various topics", 1]] |
repos,size | repos | size | 1329 | 0 | 0 | 700 | [[8, 36], [0, 36], [3, 33], [9, 28], [11, 27], [4, 25], [7, 23], [5, 23], [10, 22], [17, 17]] | [[791181, 1], [1124434, 1], [1205836, 1], [1215453, 1], [1216794, 1], [1289400, 1], [3264862, 1], [3875967, 1], [5200284, 1], [5204108, 1]] |
issue_comments_fts_data,id | issue_comments_fts_data | id | 688 | 0 | 0 | 688 | ||
issue_comments_fts_data,block | issue_comments_fts_data | block | 688 | 0 | 0 | 688 | ||
issues,pull_request | issues | pull_request | 2892 | 2332 | 0 | 560 | [["None", 2332], ["dogsheep/dogsheep.github.io/pulls/3", 1], ["dogsheep/dogsheep.github.io/pulls/1", 1], ["dogsheep/dogsheep-photos/pulls/37", 1], ["dogsheep/dogsheep-photos/pulls/36", 1], ["dogsheep/dogsheep-photos/pulls/31", 1], ["dogsheep/dogsheep-photos/pulls/30", 1], ["dogsheep/dogsheep-photos/pulls/29", 1], ["dogsheep/dogsheep-beta/pulls/35", 1], ["dogsheep/apple-notes-to-sqlite/pulls/13", 1]] | [["simonw/sqlite-utils/pulls/60", 1], ["simonw/sqlite-utils/pulls/64", 1], ["simonw/sqlite-utils/pulls/65", 1], ["simonw/sqlite-utils/pulls/67", 1], ["simonw/sqlite-utils/pulls/72", 1], ["simonw/sqlite-utils/pulls/75", 1], ["simonw/sqlite-utils/pulls/78", 1], ["simonw/sqlite-utils/pulls/80", 1], ["simonw/sqlite-utils/pulls/9", 1], ["simonw/sqlite-utils/pulls/96", 1]] |
pull_requests,id | pull_requests | id | 560 | 0 | 0 | 560 | ||
pull_requests,node_id | pull_requests | node_id | 560 | 0 | 0 | 560 | ||
pull_requests,created_at | pull_requests | created_at | 560 | 0 | 0 | 560 | ||
pull_requests,head | pull_requests | head | 560 | 0 | 0 | 560 | ||
pull_requests,url | pull_requests | url | 560 | 0 | 0 | 560 | ||
pull_requests_fts_docsize,id | pull_requests_fts_docsize | id | 560 | 0 | 0 | 560 | ||
pull_requests,merge_commit_sha | pull_requests | merge_commit_sha | 560 | 1 | 0 | 559 | [["None", 1], ["0499f174c063283aa9b589d475a32077aaf7adc5", 1], ["03cc697b6b3d0983618c29ee75b45b5e0ac91139", 1], ["03b35d70e281ea48bd9b8058738ed87b13cea2de", 1], ["02f5c4d69d7b4baebde015c56e5bc62923f33314", 1], ["025b4024b1b43ea034b7fd331c30740165ff75f2", 1], ["022cdd97a9ddab1a152e23e1e1c42e78c1ed0fa9", 1], ["01369176b0a8943ab45292ffc6f9c929b80a00e8", 1], ["013496862f4d4b441ab61255242b838b24287607", 1], ["00e59ec461dc0150772b999c7cc15fcb9b507d58", 1]] | [["f8ffac8787e299a62c99ed1ce914cd5ace84ad94", 1], ["f92d823766872a6fd7e76c5249a6b2de1ab0f447", 1], ["f96e55bce55d26c4d5b198edc536e1b8e9bbea43", 1], ["f99a23652910b03ac4669bbbb35a9b484451aabb", 1], ["fb3abeceb2785a582d2c120c7c1bf7dc3cd1de05", 1], ["fb57d4474cb1fdaef260e244b1b6f470f1992e40", 1], ["fc3660cfad7668dbce6ead12766e048fc1f78b11", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fda4dad23a0494890267fbe8baf179e2b56ee914", 1], ["ffff3a4c5398a9f40b61d59736f386444da19289", 1]] |
pull_requests,updated_at | pull_requests | updated_at | 560 | 0 | 0 | 558 | [["2020-05-27T20:21:56Z", 3], ["2017-11-21T20:55:05Z", 1], ["2017-11-19T20:30:24Z", 1], ["2017-11-18T03:15:57Z", 1], ["2017-11-17T15:16:34Z", 1], ["2017-11-17T15:12:29Z", 1], ["2017-11-17T03:50:52Z", 1], ["2017-11-15T03:08:04Z", 1], ["2017-11-15T02:03:01Z", 1], ["2017-11-14T02:24:54Z", 1]] | [["2023-05-31T18:45:26Z", 1], ["2023-06-26T08:21:00Z", 1], ["2023-06-29T14:31:55Z", 1], ["2023-06-29T14:31:59Z", 1], ["2023-06-29T14:40:35Z", 1], ["2023-07-08T01:58:13Z", 1], ["2023-07-10T13:49:31Z", 1], ["2023-07-11T13:06:16Z", 1], ["2023-07-12T16:38:28Z", 1], ["2023-07-13T09:30:50Z", 1]] |
pull_requests,title | pull_requests | title | 560 | 0 | 0 | 556 | [["Use Read the Docs action v1", 2], ["Update deploying.rst", 2], ["Update README.md", 2], ["Add paths for homebrew on Apple silicon", 2], ["--crossdb option for joining across databases", 1], ["'datasette --get' option, refs #926", 1], ["\"permissions\" blocks in metadata.json/yaml", 1], ["\"datasette publish cloudrun\" command to publish to Google Cloud Run", 1], [" Import pysqlite3 if available, closes #360 ", 1], [" Don't duplicate simple primary keys in the link column", 1]] | [["table.update() method", 1], ["test commit", 1], ["test_insert_upsert_all_empty_list", 1], ["tiny typo in customization docs", 1], ["twitter-to-sqlite import command, refs #4", 1], ["upsert new rows with constraints, fixes #514", 1], ["use inspect data for hash and file size", 1], ["use jsonify_if_need for sql updates", 1], ["use single quotes for string literals, fixes #2001", 1], ["use universal command", 1]] |
pull_requests_fts,title | pull_requests_fts | title | 560 | 0 | 0 | 556 | [["Use Read the Docs action v1", 2], ["Update deploying.rst", 2], ["Update README.md", 2], ["Add paths for homebrew on Apple silicon", 2], ["--crossdb option for joining across databases", 1], ["'datasette --get' option, refs #926", 1], ["\"permissions\" blocks in metadata.json/yaml", 1], ["\"datasette publish cloudrun\" command to publish to Google Cloud Run", 1], [" Import pysqlite3 if available, closes #360 ", 1], [" Don't duplicate simple primary keys in the link column", 1]] | [["table.update() method", 1], ["test commit", 1], ["test_insert_upsert_all_empty_list", 1], ["tiny typo in customization docs", 1], ["twitter-to-sqlite import command, refs #4", 1], ["upsert new rows with constraints, fixes #514", 1], ["use inspect data for hash and file size", 1], ["use jsonify_if_need for sql updates", 1], ["use single quotes for string literals, fixes #2001", 1], ["use universal command", 1]] |
pull_requests,number | pull_requests | number | 560 | 0 | 0 | 517 | [[8, 4], [5, 4], [67, 3], [65, 3], [15, 3], [6, 3], [9, 2], [7, 2], [4, 2], [1, 2]] | [[2075, 1], [2076, 1], [2077, 1], [2080, 1], [2082, 1], [2083, 1], [2096, 1], [2098, 1], [2099, 1], [2100, 1]] |
issue_comments_fts_docsize,sz | issue_comments_fts_docsize | sz | 9947 | 0 | 0 | 508 | [["b'\\x0f'", 216], ["b'\\x12'", 209], ["b'\\x10'", 203], ["b'\\x0e'", 199], ["b'\\x0c'", 188], ["b'\\r'", 184], ["b'\\x16'", 180], ["b'\\x13'", 176], ["b'\\x15'", 163], ["b'\\x0b'", 162]] | [["b'\\x8a\\x0b'", 1], ["b'\\x8b\"'", 1], ["b'\\x8b5'", 1], ["b'\\x8bh'", 1], ["b'\\x8c\\x05'", 1], ["b'\\x8fK'", 1], ["b'\\x927'", 1], ["b'\\x92}'", 1], ["b'\\x9f\\\\'", 1], ["b'\\xb3.'", 1]] |
pull_requests,body | pull_requests | body | 560 | 10 | 54 | 496 | [["", 54], ["None", 10], ["Refs #744", 2], ["\r\n\r\nRefs #90 ", 1], ["\r\n\r\nDeletes all rows in the table (if it exists) before inserting new rows.\r\nSQL...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] | [["sqlite \"IS\" is equivalent to SQL \"IS NOT DISTINCT FROM\"\r\n\r\ncloses #423", 1], ["sqlite foreign keys can be compound, but that is not as well supported by datase...", 1], ["the `--connection` parameter has become positional", 1], ["the library deal with Postgres type jsonb as dictionary, add dict type as a TEXT...", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["this var `app` isn't actually used? unless init it does some side-effect outside...", 1], ["tiny tweak to make this easier to visually parse—I think it matches your style i...", 1], ["to keep the data write from failing if it came across an error during processing...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1]] |
pull_requests_fts,body | pull_requests_fts | body | 560 | 10 | 54 | 496 | [["", 54], ["None", 10], ["Refs #744", 2], ["\r\n\r\nRefs #90 ", 1], ["\r\n\r\nDeletes all rows in the table (if it exists) before inserting new rows.\r\nSQL...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] | [["sqlite \"IS\" is equivalent to SQL \"IS NOT DISTINCT FROM\"\r\n\r\ncloses #423", 1], ["sqlite foreign keys can be compound, but that is not as well supported by datase...", 1], ["the `--connection` parameter has become positional", 1], ["the library deal with Postgres type jsonb as dictionary, add dict type as a TEXT...", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["this var `app` isn't actually used? unless init it does some side-effect outside...", 1], ["tiny tweak to make this easier to visually parse—I think it matches your style i...", 1], ["to keep the data write from failing if it came across an error during processing...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1]] |
pull_requests,closed_at | pull_requests | closed_at | 560 | 90 | 0 | 470 | [["None", 90], ["2017-11-21T20:55:05Z", 1], ["2017-11-18T03:15:50Z", 1], ["2017-11-18T00:53:43Z", 1], ["2017-11-17T14:22:56Z", 1], ["2017-11-17T13:29:22Z", 1], ["2017-11-17T03:50:52Z", 1], ["2017-11-15T03:08:04Z", 1], ["2017-11-15T02:03:01Z", 1], ["2017-11-13T22:16:55Z", 1]] | [["2023-05-08T21:13:37Z", 1], ["2023-05-08T21:27:10Z", 1], ["2023-05-08T21:53:58Z", 1], ["2023-05-15T13:59:36Z", 1], ["2023-05-21T16:19:30Z", 1], ["2023-05-21T18:41:56Z", 1], ["2023-05-21T20:57:23Z", 1], ["2023-05-26T00:18:44Z", 1], ["2023-06-25T23:25:51Z", 1], ["2023-06-29T14:31:54Z", 1]] |
pull_requests,base | pull_requests | base | 560 | 0 | 0 | 422 | [["f09d611782a8372cfb002792dfa727325afb4db6", 7], ["1b697539f5b53cec3fe13c0f4ada13ba655c88c7", 6], ["0b4a28691468b5c758df74fa1d72a823813c96bf", 5], ["b7257a21bf3dfa7353980f343c83a616da44daa7", 4], ["a4bb2abce0764d49d255e5379f9e9c70981834ca", 4], ["8c401ee0f054de2f568c3a8302c9223555146407", 4], ["71e36e1cf034b96de2a8e6652265d782d3fdf63b", 4], ["5890a20c374fb0812d88c9b0ef26a838bfa06c76", 4], ["11b352b4d52fd02a422776edebb14f12e4994d3b", 4], ["0f7192b6154edb576c41b55bd3f2a3f53e5f436a", 4]] | [["f7289174e66ae4d91d57de94bbd9d09fabf7aff4", 1], ["f825e2012109247fa246e2b938f8174069e574f1", 1], ["f8277d0fb9c05a88a9ff01d996e31d55f0f0a645", 1], ["fa8eb0bf1b113ab17ede9cd107b7c3bd5cde39c3", 1], ["faea5093b865031f650da7da6539430f732f511a", 1], ["fb988ace7c7e2bee5ac142a0eab22431d0675a77", 1], ["fcf43589eb6a1f1d0432772a639fd35711c48e0c", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fe5b6ea95a973534fe8a44907c0ea2449aae7602", 1], ["fff89772b4404995400e33fe1d269050717ff4cf", 1]] |
issues_fts_data,id | issues_fts_data | id | 420 | 0 | 0 | 420 | ||
issues_fts_data,block | issues_fts_data | block | 420 | 0 | 0 | 420 | ||
issues,user | issues | user | 2892 | 0 | 0 | 401 | [[9599, 1991], [49699333, 70], [536941, 32], [45057, 26], [27856297, 22], [25778, 22], [82988, 18], [192568, 16], [7908073, 14], [3243482, 14]] | [[57859326, 1], [69208826, 1], [76450761, 1], [80409402, 1], [83080728, 1], [87192257, 1], [91880982, 1], [102635518, 1], [111973926, 1], [130708713, 1]] |
pull_requests_fts_docsize,sz | pull_requests_fts_docsize | sz | 560 | 0 | 0 | 396 | [["b'\\x07\\x00'", 13], ["b'\\x08\\x02'", 11], ["b'\\x07\\x02'", 11], ["b'\\x06\\x00'", 11], ["b'\\x04\\x00'", 11], ["b'\\x05\\x02'", 10], ["b'\\x04\\x02'", 10], ["b'\\x06\\x02'", 8], ["b'\\x05\\x00'", 8], ["b'\\x03\\x00'", 6]] | [["b'\\x11\\x89.'", 1], ["b'\\x11\\x896'", 1], ["b'\\x11\\x89<'", 1], ["b'\\x11\\x89`'", 1], ["b'\\x11\\x89s'", 1], ["b'\\x11\\x8a\\r'", 1], ["b'\\x11\\x8a\\x1e'", 1], ["b'\\x11\\x8ax'", 1], ["b'\\x14z'", 1], ["b'\\x15g'", 1]] |
pull_requests,merged_at | pull_requests | merged_at | 560 | 178 | 0 | 382 | [["None", 178], ["2017-11-21T20:55:05Z", 1], ["2017-11-18T03:15:50Z", 1], ["2017-11-18T00:53:43Z", 1], ["2017-11-17T14:22:56Z", 1], ["2017-11-17T13:29:22Z", 1], ["2017-11-17T03:50:52Z", 1], ["2017-11-15T03:08:04Z", 1], ["2017-11-15T02:03:01Z", 1], ["2017-11-13T22:16:55Z", 1]] | [["2023-04-13T01:44:43Z", 1], ["2023-05-08T21:10:01Z", 1], ["2023-05-08T21:13:37Z", 1], ["2023-05-08T21:53:58Z", 1], ["2023-05-21T16:19:30Z", 1], ["2023-05-21T18:41:56Z", 1], ["2023-05-21T20:57:22Z", 1], ["2023-05-26T00:18:44Z", 1], ["2023-06-25T23:25:51Z", 1], ["2023-06-29T14:31:54Z", 1]] |
issues_fts_idx,term | issues_fts_idx | term | 412 | 0 | 0 | 373 | [["b'0tho'", 3], ["b'0nota'", 3], ["b'0forb'", 3], ["b'0a0'", 3], ["b''", 3], ["b'0beg'", 2], ["b'0asc'", 2], ["b'0andr'", 2], ["b'0adde'", 2], ["b'010'", 2]] | [["b'0withe'", 1], ["b'0withi'", 1], ["b'0worka'", 1], ["b'0worker'", 1], ["b'0worko'", 1], ["b'0www2'", 1], ["b'0wy'", 1], ["b'0yer'", 1], ["b'0your'", 1], ["b'0yours'", 1]] |
tags,sha | tags | sha | 368 | 0 | 0 | 368 | ||
issue_comments,user | issue_comments | user | 9947 | 0 | 0 | 367 | [[9599, 8456], [22429695, 204], [536941, 79], [25778, 70], [45057, 39], [82988, 35], [3243482, 26], [193185, 24], [95570, 24], [192568, 22]] | [[49702524, 1], [52261150, 1], [60892516, 1], [63653929, 1], [76450761, 1], [76528036, 1], [80409402, 1], [89400147, 1], [95520595, 1], [102771161, 1]] |
releases,html_url | releases | html_url | 344 | 0 | 0 | 344 | ||
releases,id | releases | id | 344 | 0 | 0 | 344 | ||
releases,node_id | releases | node_id | 344 | 0 | 0 | 344 | ||
releases,created_at | releases | created_at | 344 | 0 | 0 | 344 | ||
releases,published_at | releases | published_at | 344 | 0 | 0 | 344 | ||
releases_fts_docsize,id | releases_fts_docsize | id | 344 | 0 | 0 | 344 | ||
releases,body | releases | body | 344 | 0 | 8 | 337 | [["", 8], ["* Added custom project links to the [PyPI listing](https://pypi.org/project/sqli...", 1], ["* Added `github-to-sqlite repos` command, #3 ", 1], ["* Added `followers-ids` and `friends-ids` subcommands", 1], ["* Added `--since_id` and `--since` to `user-timeline` command, refs #20\r\n* `--si...", 1], ["* Added --since option, closes #3 ", 1], ["* favorites command now populates `favorited_by` table - #14 \r\n* favorites `--...", 1], ["### Plugins and internals\r\n\r\n- New plugin hook: [filters_from_request(request,...", 1], ["# 0.13 (2017-11-24)\r\n\r\n - Search now applies to current filters.\r\n \r\n Com...", 1], [" - Better mechanism for handling errors; 404s for missing table/database\r\n \r...", 1]] | [["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-1", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-3", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7-1", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-10", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-11", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-8", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-9", 1]] |
releases_fts,body | releases_fts | body | 344 | 0 | 8 | 337 | [["", 8], ["* Added custom project links to the [PyPI listing](https://pypi.org/project/sqli...", 1], ["* Added `github-to-sqlite repos` command, #3 ", 1], ["* Added `followers-ids` and `friends-ids` subcommands", 1], ["* Added `--since_id` and `--since` to `user-timeline` command, refs #20\r\n* `--si...", 1], ["* Added --since option, closes #3 ", 1], ["* favorites command now populates `favorited_by` table - #14 \r\n* favorites `--...", 1], ["### Plugins and internals\r\n\r\n- New plugin hook: [filters_from_request(request,...", 1], ["# 0.13 (2017-11-24)\r\n\r\n - Search now applies to current filters.\r\n \r\n Com...", 1], [" - Better mechanism for handling errors; 404s for missing table/database\r\n \r...", 1]] | [["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-1", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-3", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7-1", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-10", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-11", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-8", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-9", 1]] |
issue_comments_fts_idx,pgno | issue_comments_fts_idx | pgno | 943 | 0 | 0 | 288 | [[24, 6], [22, 6], [20, 6], [16, 6], [14, 6], [12, 6], [10, 6], [8, 6], [6, 6], [2, 6]] | [[626, 1], [628, 1], [630, 1], [632, 1], [636, 1], [638, 1], [640, 1], [642, 1], [644, 1], [646, 1]] |
releases,name | releases | name | 344 | 0 | 0 | 279 | [["0.2", 8], ["0.3", 7], ["0.4", 6], ["0.1", 6], ["0.7", 4], ["0.5", 4], ["0.3.1", 4], ["0.3.2", 3], ["0.1a", 3], ["0.10", 3]] | [["Datasette 0.29", 1], ["Datasette 0.31", 1], ["Datasette 0.32", 1], ["Datasette 0.33", 1], ["Datasette 0.34", 1], ["Datasette 0.35", 1], ["Datasette 0.36", 1], ["Datasette 0.37", 1], ["Datasette 0.37.1", 1], ["Initial release", 1]] |
releases_fts,name | releases_fts | name | 344 | 0 | 0 | 279 | [["0.2", 8], ["0.3", 7], ["0.4", 6], ["0.1", 6], ["0.7", 4], ["0.5", 4], ["0.3.1", 4], ["0.3.2", 3], ["0.1a", 3], ["0.10", 3]] | [["Datasette 0.29", 1], ["Datasette 0.31", 1], ["Datasette 0.32", 1], ["Datasette 0.33", 1], ["Datasette 0.34", 1], ["Datasette 0.35", 1], ["Datasette 0.36", 1], ["Datasette 0.37", 1], ["Datasette 0.37.1", 1], ["Initial release", 1]] |
tags,name | tags | name | 368 | 0 | 0 | 274 | [["0.2", 10], ["0.1", 10], ["0.3", 8], ["0.4", 7], ["0.7", 5], ["0.5", 5], ["0.3.1", 5], ["0.1a", 5], ["0.6", 4], ["0.10", 4]] | [["3.32.1", 1], ["3.33", 1], ["3.4", 1], ["3.4.1", 1], ["3.5", 1], ["3.6", 1], ["3.7", 1], ["3.8", 1], ["3.9", 1], ["3.9.1", 1]] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [_analyze_tables_] ( [table] TEXT, [column] TEXT, [total_rows] INTEGER, [num_null] INTEGER, [num_blank] INTEGER, [num_distinct] INTEGER, [most_common] TEXT, [least_common] TEXT, PRIMARY KEY ([table], [column]) );