_analyze_tables_
350 rows
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 |
|---|---|---|---|---|---|---|---|---|
| _analyze_tables_,column | _analyze_tables_ | column | 350 | 0 | 0 | 153 | [["id", 33], ["name", 17], ["repo", 11], ["term", 10], ["sz", 10], ["segid", 10], ["pgno", 10], ["node_id", 10], ["k", 10], ["block", 10]] | [["uploader", 1], ["use_squash_pr_title_as_default", 1], ["user_id", 1], ["uses", 1], ["visibility", 1], ["watchers", 1], ["watchers_count", 1], ["web_commit_signoff_required", 1], ["with", 1], ["workflow", 1]] |
| _analyze_tables_,least_common | _analyze_tables_ | least_common | 350 | 209 | 0 | 120 | [["None", 209], ["[[\"zxyao145\", 1], [\"zxygithub\", 1], [\"zy528\", 1], [\"zyuanlim\", 1], [\"zz\", 1], [\"...", 4], ["[[364, 1], [388, 1], [410, 1], [682, 1], [1057, 1], [1062, 1], [1260, 1], [1365,...", 3], ["[[\"sqlite foreign keys can be compound, but that is not as well supported by dat...", 2], ["[[\"release\", 1], [\"search\", 1], [\"security\", 1], [\"small\", 1], [\"support\", 1], [...", 2], ["[[\"https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2\", 1], [\"htt...", 2], ["[[\"Datasette 0.62\", 1], [\"Datasette 1.0\", 1], [\"Datasette 1.0a-next\", 1], [\"Data...", 2], ["[[\"Datasette 0.29\", 1], [\"Datasette 0.31\", 1], [\"Datasette 0.32\", 1], [\"Datasett...", 2], ["[[\"Big new features in this release are ASGI support, new plugin hooks for ASGI ...", 2], ["[[\"Awaiting something else to happen first\", 1], [\"Further information is reques...", 2]] | [["[[39452697, 1], [52261150, 1], [56323389, 1], [72577720, 1], [87192257, 1], [918...", 1], ["[[449, 1], [452, 1], [460, 1], [461, 1], [463, 1], [487, 1], [511, 1], [518, 1],...", 1], ["[[49702524, 1], [60892516, 1], [63653929, 1], [76450761, 1], [76528036, 1], [804...", 1], ["[[5234079, 1], [5533512, 1], [5897911, 1], [6055094, 1], [9700784, 1], [4471010,...", 1], ["[[69208826, 1], [76450761, 1], [80409402, 1], [83080728, 1], [87192257, 1], [918...", 1], ["[[722215565, 1], [723559658, 1], [724100681, 1], [724695324, 1], [725878842, 1],...", 1], ["[[841675, 1], [1124434, 1], [1215453, 1], [1216794, 1], [1289400, 1], [2206999, ...", 1], ["[[880, 1], [886, 1], [888, 1], [890, 1], [892, 1], [894, 1], [896, 1], [898, 1],...", 1], ["[[9374594, 1], [5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414,...", 1], ["[[947465681, 1], [1382668283, 1], [1918831023, 1], [2157112227, 1], [2175284252,...", 1]] |
| _analyze_tables_,most_common | _analyze_tables_ | most_common | 350 | 84 | 0 | 207 | [["None", 84], ["[[\"None\", 1502]]", 12], ["[[4, 1]]", 10], ["[[\"version\", 1]]", 10], ["[[\"fineheard\", 2], [\"0nebody\", 1], [\"0ndrec\", 1], [\"0ihsan\", 1], [\"0ax-christin\"...", 4], ["[[2, 1]]", 3], ["[[1, 1]]", 3], ["[[0, 1063], [1, 156], [2, 65], [3, 42], [4, 21], [7, 17], [6, 16], [5, 16], [8, ...", 3], ["[[\"b''\", 1]]", 3], ["[[\"\", 21], [\"None\", 1], [\"Just addressable content, a full JSON API and pages th...", 2]] | [["[[9599, 203], [139249755, 19], [25778, 17], [15178711, 15], [53015001, 14], [440...", 1], ["[[9599, 206], [49699333, 87], [27856297, 21], [45057, 19], [15178711, 9], [53694...", 1], ["[[9599, 2071], [49699333, 87], [536941, 34], [45057, 26], [27856297, 22], [25778...", 1], ["[[9599, 3025], [19864447, 878], [\"None\", 8], [21148, 6], [45057, 5]]", 1], ["[[9599, 355]]", 1], ["[[9599, 35]]", 1], ["[[9599, 3662], [49699333, 53], [45057, 20], [27856297, 17], [\"None\", 8], [151787...", 1], ["[[9599, 8883], [22429695, 240], [536941, 82], [25778, 74], [45057, 39], [4969933...", 1], ["[[971057476, 3], [853484980, 2], [817257851, 2], [804924636, 2], [700944644, 2],...", 1], ["[[null, 1]]", 1]] |
| _analyze_tables_,num_blank | _analyze_tables_ | num_blank | 350 | 0 | 0 | 10 | [[0, 336], [99, 2], [54, 2], [49, 2], [21, 2], [8, 2], [11453, 1], [1502, 1], [321, 1], [119, 1]] | |
| _analyze_tables_,num_distinct | _analyze_tables_ | num_distinct | 350 | 0 | 0 | 123 | [[1, 73], [2, 24], [17, 10], [3, 10], [608, 7], [6, 7], [1502, 6], [355, 6], [16, 6], [0, 5]] | [[1877, 1], [2113, 1], [2137, 1], [2198, 1], [2935, 1], [3042, 1], [3793, 1], [3919, 1], [10368, 1], [12031, 1]] |
| _analyze_tables_,num_null | _analyze_tables_ | num_null | 350 | 0 | 0 | 53 | [[0, 279], [1, 5], [1420, 4], [1265, 4], [608, 2], [496, 2], [14, 2], [13, 2], [10, 2], [8, 2]] | [[1235, 1], [1294, 1], [1374, 1], [1389, 1], [1411, 1], [1435, 1], [1447, 1], [2420, 1], [3023, 1], [10490, 1]] |
| _analyze_tables_,table | _analyze_tables_ | table | 350 | 0 | 0 | 73 | [["repos", 57], ["pull_requests", 23], ["issues", 23], ["milestones", 15], ["releases", 14], ["assets", 14], ["issue_comments", 12], ["steps", 10], ["users", 9], ["commits", 9]] | [["commits_fts", 1], ["issue_comments_fts", 1], ["licenses_fts", 1], ["repos_fts_config", 2], ["repos_fts_data", 2], ["repos_fts_docsize", 2], ["users_fts", 2], ["users_fts_config", 2], ["users_fts_data", 2], ["users_fts_docsize", 2]] |
| _analyze_tables_,total_rows | _analyze_tables_ | total_rows | 350 | 0 | 0 | 38 | [[1502, 61], [1, 43], [3044, 27], [608, 27], [35, 19], [355, 18], [10495, 15], [11453, 13], [3922, 12], [106, 11]] | [[28, 2], [47, 2], [50, 2], [53, 2], [154, 2], [190, 2], [464, 2], [725, 2], [3359, 2], [12035, 3]] |
| assets,browser_download_url | assets | browser_download_url | 1 | 0 | 0 | 1 | [["https://github.com/simonw/datasette/releases/download/0.53/datasette-0.53-macos-...", 1]] | |
| assets,content_type | assets | content_type | 1 | 0 | 0 | 1 | [["application/zip", 1]] | |
| assets,created_at | assets | created_at | 1 | 0 | 0 | 1 | [["2021-01-04T21:26:30Z", 1]] | |
| assets,download_count | assets | download_count | 1 | 0 | 0 | 1 | [[59, 1]] | |
| assets,id | assets | id | 1 | 0 | 0 | 1 | [[30264367, 1]] | |
| assets,label | assets | label | 1 | 1 | 0 | 0 | [[null, 1]] | |
| assets,name | assets | name | 1 | 0 | 0 | 1 | [["datasette-0.53-macos-binary.zip", 1]] | |
| assets,node_id | assets | node_id | 1 | 0 | 0 | 1 | [["MDEyOlJlbGVhc2VBc3NldDMwMjY0MzY3", 1]] | |
| assets,release | assets | release | 1 | 0 | 0 | 1 | [[35131848, 1]] | |
| assets,size | assets | size | 1 | 0 | 0 | 1 | [[8297283, 1]] | |
| assets,state | assets | state | 1 | 0 | 0 | 1 | [["uploaded", 1]] | |
| assets,updated_at | assets | updated_at | 1 | 0 | 0 | 1 | [["2021-01-04T21:26:43Z", 1]] | |
| assets,uploader | assets | uploader | 1 | 0 | 0 | 1 | [[9599, 1]] | |
| assets,url | assets | url | 1 | 0 | 0 | 1 | [["https://api.github.com/repos/simonw/datasette/releases/assets/30264367", 1]] | |
| commits,author | commits | author | 3922 | 8 | 0 | 112 | [[9599, 3662], [49699333, 53], [45057, 20], [27856297, 17], ["None", 8], [15178711, 7], [21148, 7], [198537, 6], [25778, 6], [2657547, 5]] | [[17075617, 1], [22578954, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [37802088, 1], [56323389, 1], [72577720, 1], [99098079, 1]] |
| commits,author_date | commits | author_date | 3922 | 0 | 0 | 3919 | [["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-11-04T00:49:50Z", 1], ["2023-11-04T00:54:37Z", 1], ["2023-11-04T00:58:31Z", 1], ["2023-11-04T00:59:09Z", 1], ["2023-11-04T01:03:42Z", 1], ["2023-11-04T03:55:19Z", 1], ["2023-12-06T18:49:21Z", 1], ["2023-12-08T05:05:27Z", 1], ["2023-12-08T05:22:27Z", 1], ["2023-12-08T05:31:03Z", 1]] |
| commits,committer | commits | committer | 3922 | 8 | 0 | 4 | [[9599, 3025], [19864447, 878], ["None", 8], [21148, 6], [45057, 5]] | |
| commits,committer_date | commits | committer_date | 3922 | 0 | 0 | 3793 | [["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-11-04T00:51:46Z", 1], ["2023-11-04T00:56:34Z", 1], ["2023-11-04T00:58:31Z", 1], ["2023-11-04T00:59:09Z", 1], ["2023-11-04T01:03:42Z", 1], ["2023-11-04T03:55:19Z", 1], ["2023-12-06T18:49:21Z", 1], ["2023-12-08T05:05:27Z", 1], ["2023-12-08T05:22:27Z", 1], ["2023-12-08T05:31:03Z", 1]] |
| commits,message | commits | message | 3922 | 0 | 0 | 3815 | [["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,raw_author | commits | raw_author | 3922 | 0 | 0 | 118 | [["13ae486343ea6454a93114c6f558ffea2f2c6874", 3433], ["2946d096d0cdefdc017559e6b57e87658736e843", 229], ["5df307d91b1167b0aa175853783d760add239497", 53], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 20], ["2edd38cb3801aa07f709f083eba7cbe4f16e0978", 17], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["aa206886100eb0f7f5e54172b068d9dd45885448", 7], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 7], ["90786fb02407ad60f10210c0592ee711a9a36fae", 6], ["106fe7fbf8b80a01038e265a137b3b703422db48", 5]] | [["e7784035c9ce3ef64d906c543907d5025673d054", 1], ["eab1e8f71bd05f2ff2163f024127cc28876dd05d", 1], ["f25304fb12f6d6fab36f551427610ed8e96f0c2f", 1], ["f2f4d10a554519ea00fb44a5f6377123c59e1f22", 1], ["f333c00958a658720cd93e305aac71711b88e52b", 1], ["f3dfe1c3cf166dd0b9b8860a25045107a068c5df", 1], ["f85fb7898f36734a83fd9c8a2c2e96c751920c35", 1], ["f98e0e8fe6ee48ca1f752bb408eecbbd294f9ceb", 1], ["f98fc3edb6941a80a1bf0347a12972fd457ea2fb", 1], ["fcf3b31d4679bb2112170ec4dda53dede33a16b3", 1]] |
| commits,raw_committer | commits | raw_committer | 3922 | 0 | 0 | 6 | [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2778], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 878], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]] | |
| commits,repo | commits | repo | 3922 | 0 | 0 | 16 | [[107914493, 2391], [140912432, 962], [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 | 3922 | 0 | 0 | 3922 | ||
| commits_fts,message | commits_fts | message | 3922 | 0 | 0 | 3815 | [["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 | 47 | 0 | 0 | 47 | ||
| commits_fts_data,id | commits_fts_data | id | 47 | 0 | 0 | 47 | ||
| commits_fts_docsize,id | commits_fts_docsize | id | 3922 | 0 | 0 | 3922 | ||
| commits_fts_docsize,sz | commits_fts_docsize | sz | 3922 | 0 | 0 | 125 | [["b'\\x07'", 497], ["b'\\x08'", 474], ["b'\\x06'", 433], ["b'\\t'", 392], ["b'\\x05'", 312], ["b'\\n'", 242], ["b'\\x04'", 228], ["b'\\x03'", 197], ["b'\\x0b'", 154], ["b'\\x0c'", 108]] | [["b'\\x81&'", 1], ["b'\\x812'", 1], ["b'\\x819'", 1], ["b'\\x81>'", 1], ["b'\\x81?'", 1], ["b'\\x81['", 1], ["b'\\x81\\\\'", 1], ["b'\\x81j'", 1], ["b'\\x81t'", 1], ["b'\\x82\\x14'", 1]] |
| commits_fts_idx,pgno | commits_fts_idx | pgno | 45 | 0 | 0 | 45 | ||
| commits_fts_idx,segid | commits_fts_idx | segid | 45 | 0 | 0 | 1 | [[1, 45]] | |
| commits_fts_idx,term | commits_fts_idx | term | 45 | 0 | 0 | 45 | ||
| contributors,contributions | contributors | contributions | 137 | 0 | 0 | 23 | [[1, 97], [2, 11], [3, 5], [6, 4], [5, 2], [13, 1], [11, 1], [10, 1], [9, 1], [4, 1]] | [[21, 1], [30, 1], [34, 1], [40, 1], [54, 1], [61, 1], [128, 1], [165, 1], [884, 1], [2077, 1]] |
| contributors,repo_id | contributors | repo_id | 137 | 0 | 0 | 16 | [[107914493, 74], [140912432, 35], [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 | 137 | 0 | 0 | 113 | [[9599, 16], [41546558, 2], [15178711, 2], [536941, 2], [244656, 2], [78035, 2], [50527, 2], [49260, 2], [25778, 2], [21148, 2]] | [[27856297, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [37802088, 1], [49699333, 1], [56323389, 1], [72577720, 1], [99098079, 1]] |
| dependents,dependent | dependents | dependent | 1869 | 0 | 0 | 1501 | [[112050382, 2], [107914493, 2], [99911706, 2], [79072630, 2], [51720846, 2], [51665750, 2], [49612682, 2], [24275324, 2], [18156953, 2], [5832996, 2]] | [[722215565, 1], [723559658, 1], [724100681, 1], [724695324, 1], [725878842, 1], [725881885, 1], [726528070, 1], [726877442, 1], [727238894, 1], [728033291, 1]] |
| dependents,first_seen_utc | dependents | first_seen_utc | 1869 | 0 | 0 | 1869 | ||
| dependents,repo | dependents | repo | 1869 | 0 | 0 | 2 | [[140912432, 1039], [107914493, 830]] | |
| 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 | 10495 | 0 | 0 | 4 | [["OWNER", 8358], ["NONE", 996], ["CONTRIBUTOR", 616], ["MEMBER", 525]] | |
| issue_comments,body | issue_comments | body | 10495 | 0 | 0 | 10392 | [["Thanks!", 32], ["That fixed it.", 6], ["Thanks for this!", 6], ["Tracking ticket: #1023", 5], ["Needs documentation.", 5], ["@dependabot recreate", 5], ["Thanks for spotting this!", 4], ["Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-al...", 3], ["Blocked on #37", 3], ["@dependabot rebase", 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 | 10495 | 0 | 0 | 10494 | [["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-12-06T18:36:51Z", 1], ["2023-12-06T19:43:55Z", 1], ["2023-12-06T19:48:26Z", 1], ["2023-12-06T19:49:10Z", 1], ["2023-12-07T01:17:05Z", 1], ["2023-12-07T07:36:33Z", 1], ["2023-12-08T05:07:54Z", 1], ["2023-12-08T05:09:55Z", 1], ["2023-12-08T05:16:44Z", 1], ["2023-12-08T14:50:13Z", 1]] |
| issue_comments,html_url | issue_comments | html_url | 10495 | 0 | 0 | 10495 | ||
| issue_comments,id | issue_comments | id | 10495 | 0 | 0 | 10495 | ||
| issue_comments,issue | issue_comments | issue | 10495 | 0 | 0 | 2472 | [[627794879, 55], [849978964, 51], [1551694938, 49], [1450363982, 48], [973139047, 48], [712260429, 47], [1058072543, 45], [824064069, 45], [324188953, 42], [582526961, 40]] | [[1907281675, 1], [1919296686, 1], [1949756141, 1], [1976986318, 1], [1983600865, 1], [1988525411, 1], [1994857251, 1], [2007893839, 1], [2028698018, 1], [2029908157, 1]] |
| issue_comments,issue_url | issue_comments | issue_url | 10495 | 0 | 0 | 2472 | [["https://api.github.com/repos/simonw/datasette/issues/782", 55], ["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/599", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/6", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/603", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/605", 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 | 10495 | 0 | 0 | 10495 | ||
| issue_comments,performed_via_github_app | issue_comments | performed_via_github_app | 10495 | 10490 | 0 | 2 | [["None", 10490], ["{\"id\": 254, \"slug\": \"codecov\", \"node_id\": \"MDM6QXBwMjU0\", \"owner\": {\"login\": \"co...", 4], ["{\"id\": 29110, \"slug\": \"dependabot\", \"node_id\": \"MDM6QXBwMjkxMTA=\", \"owner\": {\"lo...", 1]] | |
| issue_comments,reactions | issue_comments | reactions | 10495 | 0 | 0 | 23 | [["{\"total_count\": 0, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 10125], ["{\"total_count\": 1, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 214], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 41], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 1, \"confused\": 0, \"he...", 37], ["{\"total_count\": 2, \"+1\": 2, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 20], ["{\"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...", 10], ["{\"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\": 0, \"-1\": 0, \"laugh\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 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\": 4, \"+1\": 4, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"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\": 3, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 2]] |
| issue_comments,updated_at | issue_comments | updated_at | 10495 | 0 | 0 | 10494 | [["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-12-06T18:36:51Z", 1], ["2023-12-06T19:43:55Z", 1], ["2023-12-06T19:49:29Z", 1], ["2023-12-07T01:17:05Z", 1], ["2023-12-07T07:36:33Z", 1], ["2023-12-08T05:05:03Z", 1], ["2023-12-08T05:07:54Z", 1], ["2023-12-08T05:10:31Z", 1], ["2023-12-08T05:17:20Z", 1], ["2023-12-08T14:50:13Z", 1]] |
| issue_comments,user | issue_comments | user | 10495 | 0 | 0 | 393 | [[9599, 8883], [22429695, 240], [536941, 82], [25778, 74], [45057, 39], [49699333, 36], [82988, 35], [3243482, 26], [15178711, 25], [95570, 24]] | [[49702524, 1], [60892516, 1], [63653929, 1], [76450761, 1], [76528036, 1], [80409402, 1], [89400147, 1], [95520595, 1], [102771161, 1], [123451970, 1]] |
| issue_comments_fts,body | issue_comments_fts | body | 10495 | 0 | 0 | 10392 | [["Thanks!", 32], ["That fixed it.", 6], ["Thanks for this!", 6], ["Tracking ticket: #1023", 5], ["Needs documentation.", 5], ["@dependabot recreate", 5], ["Thanks for spotting this!", 4], ["Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-al...", 3], ["Blocked on #37", 3], ["@dependabot rebase", 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 | 725 | 0 | 0 | 725 | ||
| issue_comments_fts_data,id | issue_comments_fts_data | id | 725 | 0 | 0 | 725 | ||
| issue_comments_fts_docsize,id | issue_comments_fts_docsize | id | 10495 | 0 | 0 | 10495 | ||
| issue_comments_fts_docsize,sz | issue_comments_fts_docsize | sz | 10495 | 0 | 0 | 521 | [["b'\\x0f'", 231], ["b'\\x12'", 219], ["b'\\x10'", 210], ["b'\\x0e'", 210], ["b'\\r'", 196], ["b'\\x0c'", 192], ["b'\\x16'", 191], ["b'\\x13'", 185], ["b'\\x15'", 171], ["b'\\x0b'", 169]] | [["b'\\x8b\"'", 1], ["b'\\x8b5'", 1], ["b'\\x8bh'", 1], ["b'\\x8c '", 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 | 1103 | 0 | 0 | 407 | [[24, 6], [22, 6], [20, 6], [16, 6], [14, 6], [12, 6], [10, 6], [8, 6], [6, 6], [2, 6]] | [[880, 1], [886, 1], [888, 1], [890, 1], [892, 1], [894, 1], [896, 1], [898, 1], [900, 1], [902, 1]] |
| issue_comments_fts_idx,segid | issue_comments_fts_idx | segid | 1103 | 0 | 0 | 6 | [[5, 385], [4, 146], [3, 145], [2, 143], [1, 143], [6, 141]] | |
| issue_comments_fts_idx,term | issue_comments_fts_idx | term | 1103 | 0 | 0 | 902 | [["b'0a0'", 6], ["b''", 6], ["b'0tho'", 5], ["b'0thea'", 5], ["b'0simonwi'", 5], ["b'0httpt'", 5], ["b'0haven'", 4], ["b'0forb'", 4], ["b'0comb'", 4], ["b'0andr'", 4]] | [["b'0\\xe1'", 1], ["b'0wel'", 1], ["b'0wherea'", 1], ["b'0whiche'", 1], ["b'0withoutr'", 1], ["b'0wouldn'", 1], ["b'0writem'", 1], ["b'0writer'", 1], ["b'0youg'", 1], ["b'0yours'", 1]] |
| issues,active_lock_reason | issues | active_lock_reason | 3044 | 3044 | 0 | 0 | [[null, 3044]] | |
| issues,assignee | issues | assignee | 3044 | 3023 | 0 | 1 | [["None", 3044]] | |
| issues,author_association | issues | author_association | 3044 | 0 | 0 | 6 | [["OWNER", 1862], ["CONTRIBUTOR", 487], ["NONE", 416], ["MEMBER", 209], ["FIRST_TIME_CONTRIBUTOR", 68], ["FIRST_TIMER", 2]] | |
| issues,body | issues | body | 3044 | 13 | 99 | 2928 | [["", 99], ["None", 13], ["- #2109 ", 3], ["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 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,closed_at | issues | closed_at | 3044 | 784 | 0 | 2198 | [["None", 784], ["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-11-04T00:40:30Z", 1], ["2023-11-04T00:46:30Z", 1], ["2023-11-04T00:49:50Z", 1], ["2023-11-04T00:49:51Z", 1], ["2023-11-04T00:58:02Z", 1], ["2023-11-08T13:19:01Z", 1], ["2023-12-06T18:49:32Z", 1], ["2023-12-08T05:05:27Z", 1], ["2023-12-08T05:07:54Z", 1], ["2023-12-08T05:22:39Z", 1]] |
| issues,comments | issues | comments | 3044 | 0 | 0 | 44 | [[1, 758], [0, 572], [2, 477], [3, 351], [4, 214], [5, 129], [6, 105], [7, 78], [9, 57], [8, 57]] | [[30, 1], [33, 1], [34, 1], [36, 1], [40, 1], [42, 1], [47, 1], [49, 1], [51, 1], [55, 1]] |
| issues,created_at | issues | created_at | 3044 | 0 | 0 | 3044 | ||
| issues,draft | issues | draft | 3044 | 2436 | 0 | 2 | [["None", 2436], [0, 596], [1, 12]] | |
| issues,id | issues | id | 3044 | 0 | 0 | 3044 | ||
| issues,locked | issues | locked | 3044 | 0 | 0 | 1 | [[0, 3044]] | |
| issues,milestone | issues | milestone | 3044 | 2420 | 0 | 34 | [["None", 2420], [3268330, 117], [6026070, 53], [2857392, 49], [5512395, 39], [5533512, 25], [8755003, 24], [7571612, 24], [8658075, 23], [4305096, 22]] | [[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 | 3044 | 0 | 0 | 3044 | ||
| issues,number | issues | number | 3044 | 0 | 0 | 2113 | [[2, 16], [1, 16], [6, 14], [5, 14], [4, 14], [3, 14], [8, 13], [7, 13], [10, 12], [9, 12]] | [[2204, 1], [2205, 1], [2206, 1], [2207, 1], [2208, 1], [2209, 1], [2211, 1], [2212, 1], [2213, 1], [2214, 1]] |
| issues,performed_via_github_app | issues | performed_via_github_app | 3044 | 3044 | 0 | 0 | [[null, 3044]] | |
| issues,pull_request | issues | pull_request | 3044 | 2436 | 0 | 608 | [["None", 2436], ["dogsheep/dogsheep-photos/pulls/38", 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/14", 1], ["dogsheep/apple-notes-to-sqlite/pulls/13", 1]] | [["simonw/sqlite-utils/pulls/604", 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 | 3044 | 2 | 0 | 3042 | [["None", 2], ["{\"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/14/r...", 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 | 3044 | 0 | 0 | 16 | [[107914493, 2098], [140912432, 604], [207052882, 79], [206156866, 73], [256834907, 40], [197431109, 38], [197882382, 24], [303218369, 16], [205429375, 15], [611552758, 14]] | [[206202864, 2], [209590345, 2], [248903544, 6], [214746582, 8], [213286752, 12], [206649770, 13], [611552758, 14], [205429375, 15], [303218369, 16], [197882382, 24]] |
| issues,state | issues | state | 3044 | 0 | 0 | 2 | [["closed", 2260], ["open", 784]] | |
| issues,state_reason | issues | state_reason | 3044 | 1294 | 0 | 3 | [["completed", 1744], ["None", 1294], ["reopened", 5], ["not_planned", 1]] | |
| issues,title | issues | title | 3044 | 0 | 0 | 3020 | [["Bump the python-packages group with 1 update", 5], ["Bump the python-packages group with 3 updates", 3], ["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], ["Bump the python-packages group with 2 updates", 2], ["Bump sphinx, furo, blacken-docs dependencies", 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 | 3044 | 0 | 0 | 2 | [["issue", 2436], ["pull", 608]] | |
| issues,updated_at | issues | updated_at | 3044 | 0 | 0 | 2935 | [["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-12-04T05:26:29Z", 1], ["2023-12-06T15:05:46Z", 1], ["2023-12-06T19:44:04Z", 1], ["2023-12-07T07:36:34Z", 1], ["2023-12-08T05:07:54Z", 1], ["2023-12-08T05:10:31Z", 1], ["2023-12-08T05:17:20Z", 1], ["2023-12-08T05:22:39Z", 1], ["2023-12-08T13:46:24Z", 1], ["2023-12-08T14:50:15Z", 1]] |
| issues,user | issues | user | 3044 | 0 | 0 | 432 | [[9599, 2071], [49699333, 87], [536941, 34], [45057, 26], [27856297, 22], [25778, 22], [15178711, 20], [82988, 18], [192568, 16], [3243482, 14]] | [[69208826, 1], [76450761, 1], [80409402, 1], [83080728, 1], [87192257, 1], [91880982, 1], [102635518, 1], [111973926, 1], [123451970, 1], [130708713, 1]] |
| issues_fts,body | issues_fts | body | 3044 | 13 | 99 | 2928 | [["", 99], ["None", 13], ["- #2109 ", 3], ["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 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,title | issues_fts | title | 3044 | 0 | 0 | 3020 | [["Bump the python-packages group with 1 update", 5], ["Bump the python-packages group with 3 updates", 3], ["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], ["Bump the python-packages group with 2 updates", 2], ["Bump sphinx, furo, blacken-docs dependencies", 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 | 464 | 0 | 0 | 464 |
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]) );