_analyze_tables_
350 rows sorted by num_blank
This data as json, CSV (advanced)
Link | table | column | total_rows | num_null | num_blank ▼ | num_distinct | most_common | least_common |
---|---|---|---|---|---|---|---|---|
commits,repo | commits | repo | 3784 | 0 | 0 | 16 | [[107914493, 2314], [140912432, 901], [207052882, 176], [206156866, 132], [197431109, 61], [256834907, 41], [205429375, 36], [197882382, 30], [213286752, 22], [303218369, 19]] | [[209590345, 1], [206649770, 6], [611552758, 9], [206202864, 10], [214746582, 13], [248903544, 13], [303218369, 19], [213286752, 22], [197882382, 30], [205429375, 36]] |
commits,sha | commits | sha | 3784 | 0 | 0 | 3784 | ||
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_fts_config,k | commits_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
commits_fts_config,v | commits_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
commits_fts_data,block | commits_fts_data | block | 45 | 0 | 0 | 45 | ||
commits_fts_data,id | commits_fts_data | id | 45 | 0 | 0 | 45 | ||
commits_fts_docsize,id | commits_fts_docsize | id | 3784 | 0 | 0 | 3784 | ||
commits_fts_docsize,sz | commits_fts_docsize | sz | 3784 | 0 | 0 | 123 | [["b'\\x07'", 478], ["b'\\x08'", 454], ["b'\\x06'", 417], ["b'\\t'", 375], ["b'\\x05'", 307], ["b'\\n'", 236], ["b'\\x04'", 219], ["b'\\x03'", 195], ["b'\\x0b'", 151], ["b'\\x0c'", 107]] | [["b'\\x81&'", 1], ["b'\\x81,'", 1], ["b'\\x812'", 1], ["b'\\x819'", 1], ["b'\\x81>'", 1], ["b'\\x81?'", 1], ["b'\\x81['", 1], ["b'\\x81\\\\'", 1], ["b'\\x81h'", 1], ["b'\\x82\\x14'", 1]] |
commits_fts_idx,pgno | commits_fts_idx | pgno | 43 | 0 | 0 | 43 | ||
commits_fts_idx,segid | commits_fts_idx | segid | 43 | 0 | 0 | 1 | [[1, 43]] | |
commits_fts_idx,term | commits_fts_idx | term | 43 | 0 | 0 | 43 | ||
contributors,contributions | contributors | contributions | 131 | 0 | 0 | 23 | [[1, 92], [2, 11], [3, 5], [5, 3], [6, 2], [13, 1], [11, 1], [10, 1], [9, 1], [4, 1]] | [[21, 1], [30, 1], [34, 1], [40, 1], [49, 1], [61, 1], [128, 1], [165, 1], [828, 1], [2011, 1]] |
contributors,repo_id | contributors | repo_id | 131 | 0 | 0 | 16 | [[107914493, 73], [140912432, 30], [207052882, 5], [206156866, 4], [214746582, 3], [205429375, 3], [303218369, 2], [256834907, 2], [213286752, 2], [197431109, 1]] | [[197431109, 1], [197882382, 1], [206202864, 1], [206649770, 1], [209590345, 1], [248903544, 1], [611552758, 1], [213286752, 2], [256834907, 2], [303218369, 2]] |
contributors,user_id | contributors | user_id | 131 | 0 | 0 | 108 | [[9599, 16], [41546558, 2], [536941, 2], [244656, 2], [78035, 2], [50527, 2], [49260, 2], [25778, 2], [21148, 2], [2182, 1]] | [[22578954, 1], [27856297, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [49699333, 1], [56323389, 1], [72577720, 1], [99098079, 1]] |
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]] |
dependents,first_seen_utc | dependents | first_seen_utc | 1658 | 0 | 0 | 1658 | ||
dependents,repo | dependents | repo | 1658 | 0 | 0 | 2 | [[140912432, 888], [107914493, 770]] | |
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]] |
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]] |
issue_comments,author_association | issue_comments | author_association | 9947 | 0 | 0 | 4 | [["OWNER", 7931], ["NONE", 928], ["CONTRIBUTOR", 563], ["MEMBER", 525]] | |
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,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,html_url | issue_comments | html_url | 9947 | 0 | 0 | 9947 | ||
issue_comments,id | issue_comments | id | 9947 | 0 | 0 | 9947 | ||
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]] |
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,node_id | issue_comments | node_id | 9947 | 0 | 0 | 9947 | ||
issue_comments,performed_via_github_app | issue_comments | performed_via_github_app | 9947 | 9947 | 0 | 0 | [[null, 9947]] | |
issue_comments,reactions | issue_comments | reactions | 9947 | 0 | 0 | 21 | [["{\"total_count\": 0, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 9604], ["{\"total_count\": 1, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 199], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 1, \"confused\": 0, \"he...", 37], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 36], ["{\"total_count\": 2, \"+1\": 2, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 18], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 13], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 8], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 7], ["{\"total_count\": 3, \"+1\": 3, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 6], ["{\"total_count\": 2, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 3]] | [["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 1, \"he...", 1], ["{\"total_count\": 15, \"+1\": 7, \"-1\": 0, \"laugh\": 1, \"hooray\": 1, \"confused\": 0, \"h...", 1], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 3, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 3, \"confused\": 0, \"he...", 1], ["{\"total_count\": 5, \"+1\": 2, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 5, \"+1\": 5, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 2, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 2, \"confused\": 0, \"he...", 2], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 2], ["{\"total_count\": 3, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 2]] |
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,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]] |
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]] |
issue_comments_fts_config,k | issue_comments_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
issue_comments_fts_config,v | issue_comments_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
issue_comments_fts_data,block | issue_comments_fts_data | block | 688 | 0 | 0 | 688 | ||
issue_comments_fts_data,id | issue_comments_fts_data | id | 688 | 0 | 0 | 688 | ||
issue_comments_fts_docsize,id | issue_comments_fts_docsize | id | 9947 | 0 | 0 | 9947 | ||
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]] |
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]] |
issue_comments_fts_idx,segid | issue_comments_fts_idx | segid | 943 | 0 | 0 | 6 | [[5, 266], [4, 146], [3, 145], [2, 143], [1, 143], [6, 100]] | |
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]] |
issues,active_lock_reason | issues | active_lock_reason | 2892 | 2892 | 0 | 0 | [[null, 2892]] | |
issues,assignee | issues | assignee | 2892 | 2872 | 0 | 2 | [["None", 2872], [9599, 19], [15178711, 1]] | |
issues,author_association | issues | author_association | 2892 | 0 | 0 | 6 | [["OWNER", 1783], ["CONTRIBUTOR", 444], ["NONE", 393], ["MEMBER", 208], ["FIRST_TIME_CONTRIBUTOR", 62], ["FIRST_TIMER", 2]] | |
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,comments | issues | comments | 2892 | 0 | 0 | 44 | [[1, 721], [0, 546], [2, 456], [3, 328], [4, 205], [5, 122], [6, 99], [7, 74], [8, 53], [9, 51]] | [[31, 1], [33, 1], [34, 1], [36, 1], [40, 1], [42, 1], [47, 1], [49, 1], [51, 1], [54, 1]] |
issues,created_at | issues | created_at | 2892 | 0 | 0 | 2892 | ||
issues,draft | issues | draft | 2892 | 2332 | 0 | 2 | [["None", 2332], [0, 550], [1, 10]] | |
issues,id | issues | id | 2892 | 0 | 0 | 2892 | ||
issues,locked | issues | locked | 2892 | 0 | 0 | 1 | [[0, 2892]] | |
issues,milestone | issues | milestone | 2892 | 2293 | 0 | 33 | [["None", 2293], [3268330, 110], [6026070, 53], [2857392, 49], [5512395, 39], [5533512, 25], [7571612, 24], [8658075, 23], [4305096, 22], [2949431, 21]] | [[9374594, 1], [5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414, 5], [7867486, 6], [3439337, 7], [5225818, 7], [6079500, 7]] |
issues,node_id | issues | node_id | 2892 | 0 | 0 | 2892 | ||
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]] |
issues,performed_via_github_app | issues | performed_via_github_app | 2892 | 2892 | 0 | 0 | [[null, 2892]] | |
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]] |
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,repo | issues | repo | 2892 | 0 | 0 | 16 | [[107914493, 1994], [140912432, 565], [207052882, 79], [206156866, 72], [256834907, 37], [197431109, 36], [197882382, 24], [303218369, 15], [205429375, 15], [611552758, 13]] | [[206202864, 2], [209590345, 2], [248903544, 6], [214746582, 8], [206649770, 12], [213286752, 12], [611552758, 13], [205429375, 15], [303218369, 15], [197882382, 24]] |
issues,state | issues | state | 2892 | 0 | 0 | 2 | [["closed", 2144], ["open", 748]] | |
issues,state_reason | issues | state_reason | 2892 | 1214 | 0 | 3 | [["completed", 1673], ["None", 1214], ["reopened", 4], ["not_planned", 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,type | issues | type | 2892 | 0 | 0 | 2 | [["issue", 2332], ["pull", 560]] | |
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,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]] |
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_fts_config,k | issues_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
issues_fts_config,v | issues_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
issues_fts_data,block | issues_fts_data | block | 420 | 0 | 0 | 420 | ||
issues_fts_data,id | issues_fts_data | id | 420 | 0 | 0 | 420 | ||
issues_fts_docsize,id | issues_fts_docsize | id | 2892 | 0 | 0 | 2892 | ||
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]] |
issues_fts_idx,pgno | issues_fts_idx | pgno | 412 | 0 | 0 | 155 | [[20, 3], [18, 3], [16, 3], [14, 3], [12, 3], [10, 3], [8, 3], [6, 3], [4, 3], [2, 3]] | [[268, 1], [274, 1], [278, 1], [306, 1], [308, 1], [310, 1], [298, 2], [300, 2], [302, 2], [304, 2]] |
issues_fts_idx,segid | issues_fts_idx | segid | 412 | 0 | 0 | 3 | [[1, 152], [2, 149], [3, 111]] | |
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]] |
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_labels,labels_id | issues_labels | labels_id | 3206 | 0 | 0 | 103 | [[727708732, 263], [729585263, 232], [993377884, 209], [750789605, 197], [727708734, 186], [754269786, 176], [947261894, 138], [1970143153, 96], [2374328705, 91], [1379448359, 88]] | [[2051881526, 1], [2245226086, 1], [2418058309, 1], [2459412274, 1], [3609901844, 1], [3750508178, 1], [3867322234, 1], [4795091971, 1], [5243620954, 1], [5243620957, 1]] |
jobs,id | jobs | id | 54 | 0 | 0 | 54 | ||
jobs,if | jobs | if | 54 | 52 | 0 | 1 | [["None", 54]] | |
jobs,name | jobs | name | 54 | 0 | 0 | 12 | [["test", 25], ["deploy", 12], ["build", 5], ["spellcheck", 2], ["documentation-links", 2], ["deploy_docker", 2], ["mirror", 1], ["deploy_static_docs", 1], ["deploy-branch-preview", 1], ["Analyze", 1]] | [["Analyze", 1], ["deploy-branch-preview", 1], ["deploy_static_docs", 1], ["mirror", 1], ["prettier", 1], ["scheduled", 1], ["deploy_docker", 2], ["documentation-links", 2], ["spellcheck", 2], ["build", 5]] |
jobs,needs | jobs | needs | 54 | 41 | 0 | 2 | [["None", 41], ["[\"test\"]", 11], ["[\"deploy\"]", 2]] | |
jobs,repo | jobs | repo | 54 | 0 | 0 | 12 | [[107914493, 16], [140912432, 7], [207052882, 5], [206156866, 4], [303218369, 3], [248903544, 3], [213286752, 3], [205429375, 3], [197882382, 3], [197431109, 3]] | [[256834907, 1], [197431109, 3], [197882382, 3], [205429375, 3], [213286752, 3], [248903544, 3], [303218369, 3], [611552758, 3], [206156866, 4], [207052882, 5]] |
jobs,runs-on | jobs | runs-on | 54 | 0 | 0 | 3 | [["ubuntu-latest", 50], ["macos-latest", 2], ["${{ matrix.os }}", 2]] | |
jobs,strategy | jobs | strategy | 54 | 30 | 0 | 7 | [["None", 30], ["{\"matrix\": {\"python-version\": [3.6, 3.7, 3.8, 3.9]}}", 10], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\"]}}", 6], ["{\"matrix\": {\"python-version\": [\"3.8\", \"3.9\", \"3.10\", \"3.11\"]}}", 4], ["{\"matrix\": {\"python-version\": [3.7, 3.8]}}", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\"], \"os\": [\"ubu...", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\"], \"numpy\": [0...", 1], ["{\"fail-fast\": false, \"matrix\": {\"language\": [\"python\"]}}", 1]] | |
jobs,workflow | jobs | workflow | 54 | 0 | 0 | 41 | [[20702, 4], [20695, 2], [20693, 2], [20691, 2], [20689, 2], [20687, 2], [20684, 2], [20681, 2], [20678, 2], [20676, 2]] | [[20705, 1], [20706, 1], [20707, 1], [20708, 1], [20709, 1], [20710, 1], [20711, 1], [20713, 1], [20714, 1], [20715, 1]] |
labels,color | labels | color | 103 | 0 | 0 | 71 | [["a2eeef", 13], ["d73a4a", 11], ["0075ca", 8], ["ffffff", 2], ["e4e669", 2], ["008672", 2], ["0EE038", 1], ["083993", 1], ["0366d6", 1], ["006b75", 1]] | [["e6e6e6", 1], ["e8be84", 1], ["ecc7fc", 1], ["ee0701", 1], ["f759cf", 1], ["fc79af", 1], ["fc8b0a", 1], ["fcbabb", 1], ["fcd0c4", 1], ["fcecc4", 1]] |
labels,default | labels | default | 103 | 0 | 0 | 2 | [[0, 54], [1, 49]] | |
labels,id | labels | id | 103 | 0 | 0 | 103 | ||
labels,name | labels | name | 103 | 0 | 0 | 56 | [["enhancement", 14], ["bug", 12], ["documentation", 10], ["research", 4], ["invalid", 3], ["help wanted", 3], ["ci", 3], ["question", 2], ["duplicate", 2], ["design", 2]] | [["release", 1], ["search", 1], ["security", 1], ["small", 1], ["support", 1], ["templates", 1], ["tests", 1], ["tracking-issue", 1], ["usability", 1], ["windows", 1]] |
labels,node_id | labels | node_id | 103 | 0 | 0 | 103 | ||
labels,url | labels | url | 103 | 0 | 0 | 103 | ||
labels_fts,name | labels_fts | name | 103 | 0 | 0 | 56 | [["enhancement", 14], ["bug", 12], ["documentation", 10], ["research", 4], ["invalid", 3], ["help wanted", 3], ["ci", 3], ["question", 2], ["duplicate", 2], ["design", 2]] | [["release", 1], ["search", 1], ["security", 1], ["small", 1], ["support", 1], ["templates", 1], ["tests", 1], ["tracking-issue", 1], ["usability", 1], ["windows", 1]] |
labels_fts_config,k | labels_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
labels_fts_config,v | labels_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
labels_fts_data,block | labels_fts_data | block | 3 | 0 | 0 | 3 | ||
labels_fts_data,id | labels_fts_data | id | 3 | 0 | 0 | 3 | ||
labels_fts_docsize,id | labels_fts_docsize | id | 103 | 0 | 0 | 103 | ||
labels_fts_docsize,sz | labels_fts_docsize | sz | 103 | 0 | 0 | 9 | [["b'\\x01\\x00'", 47], ["b'\\x01\\x04'", 25], ["b'\\x02\\x00'", 11], ["b'\\x01\\x05'", 11], ["b'\\x03\\x00'", 2], ["b'\\x02\\x04'", 2], ["b'\\x01\\x07'", 2], ["b'\\x01\\x06'", 2], ["b'\\x01\\r'", 1]] | |
labels_fts_idx,pgno | labels_fts_idx | pgno | 1 | 0 | 0 | 1 | [[2, 1]] | |
labels_fts_idx,segid | labels_fts_idx | segid | 1 | 0 | 0 | 1 | [[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]) );