github
| table | column | total_rows | num_null | num_blank | num_distinct | most_common | least_common |
|---|---|---|---|---|---|---|---|
| _analyze_tables_ | column | 341 | 0 | 0 | 145 | [["id", 33], ["name", 17], ["repo", 11], ["term", 10], ["sz", 10], ["segid", 10], ["pgno", 10], ["node_id", 10], ["k", 10], ["block", 10]] | [["topics", 1], ["total_rows", 1], ["uploader", 1], ["user_id", 1], ["uses", 1], ["visibility", 1], ["watchers", 1], ["watchers_count", 1], ["with", 1], ["workflow", 1]] |
| _analyze_tables_ | least_common | 341 | 211 | 0 | 111 | [["None", 211], ["[[106, 1], [126, 1], [183, 1], [200, 1], [321, 1], [872, 1], [1057, 1], [1062, 1...", 3], ["[[\"python-library\", 1], [\"refactor\", 1], [\"search\", 1], [\"security\", 1], [\"small...", 2], ["[[\"https://travis-ci.org/simonw/datasette/jobs/305929426\\r\\n\\r\\n pkg_resource...", 2], ["[[\"https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2\", 1], [\"htt...", 2], ["[[\"Datasette 0.50\", 1], [\"Datasette 0.52\", 1], [\"Datasette 0.54\", 1], [\"Datasett...", 2], ["[[\"Datasette 0.29\", 1], [\"Datasette 0.31\", 1], [\"Datasette 0.32\", 1], [\"Datasett...", 2], ["[[\"Awaiting something else to happen first\", 1], [\"Further information is reques...", 2], ["[[\"A new visual design, plugin hooks for adding navigation options, better handl...", 2], ["[[\"3.26.1\", 1], [\"3.3\", 1], [\"3.4\", 1], [\"3.4.1\", 1], [\"3.5\", 1], [\"3.6\", 1], [\"...", 2]] | [["[[5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414, 5], [3439337,...", 1], ["[[610, 1], [612, 1], [614, 1], [616, 1], [618, 1], [620, 1], [622, 1], [624, 1],...", 1], ["[[765368, 1], [765924, 1], [766394, 1], [767103, 1], [768388, 1], [768427, 1], [...", 1], ["[[77848345, 1], [81873563, 1], [84056280, 1], [85930339, 1], [86156616, 1], [918...", 1], ["[[8, 3], [9, 3], [10, 3], [11, 3], [7, 6], [6, 7], [5, 37], [4, 38], [3, 40], [2...", 1], ["[[836124846, 1], [838724548, 1], [838755826, 1], [840249513, 1], [841715204, 1],...", 1], ["[[9, 1], [11, 1], [14, 1], [18, 1], [23, 1], [56, 1], [94, 1], [99, 1], [154, 1]...", 1], ["[[91842948, 1], [91912885, 1], [92047518, 1], [93546675, 1], [93766133, 1], [939...", 1], ["[[947465681, 1], [1918831023, 1], [2157112227, 1], [2175284252, 1], [2374328637,...", 1], ["[[98190180, 1], [98228097, 1], [98233413, 1], [98310755, 1], [98478474, 1], [985...", 1]] |
| _analyze_tables_ | most_common | 341 | 89 | 0 | 197 | [["None", 89], ["[[4, 1]]", 10], ["[[\"version\", 1]]", 10], ["[[\"None\", 774]]", 7], ["[[2, 1]]", 3], ["[[1, 1]]", 3], ["[[0, 558], [1, 75], [2, 32], [3, 19], [7, 9], [5, 8], [4, 8], [6, 7], [12, 4], [...", 3], ["[[\"b''\", 1]]", 3], ["[[\"None\", 439]]", 3], ["[[\"None\", 2396]]", 3]] | [["[[9599, 145], [53015001, 13], [25778, 10], [44060760, 9], [5802411, 9], [3810786...", 1], ["[[9599, 15], [41546558, 2], [78035, 2], [50527, 2], [49260, 2], [25778, 2], [211...", 1], ["[[9599, 169], [49699333, 41], [27856297, 21], [45057, 19], [3243482, 7], [265754...", 1], ["[[9599, 1717], [49699333, 41], [45057, 26], [27856297, 22], [536941, 18], [82988...", 1], ["[[9599, 1]]", 1], ["[[9599, 2590], [19864447, 703], [\"None\", 8], [21148, 6], [45057, 5]]", 1], ["[[9599, 28]]", 1], ["[[9599, 3109], [49699333, 34], [45057, 20], [27856297, 17], [\"None\", 8], [21148,...", 1], ["[[9599, 317]]", 1], ["[[9599, 6906], [22429695, 142], [25778, 52], [45057, 39], [536941, 32], [82988, ...", 1]] |
| _analyze_tables_ | num_blank | 341 | 0 | 0 | 10 | [[0, 327], [99, 2], [54, 2], [42, 2], [17, 2], [8, 2], [7918, 1], [774, 1], [157, 1], [94, 1]] | |
| _analyze_tables_ | num_distinct | 341 | 0 | 0 | 110 | [[1, 68], [2, 21], [14, 11], [7918, 9], [15, 9], [3, 9], [439, 8], [28, 8], [95, 7], [0, 6]] | [[1747, 1], [1786, 1], [1831, 1], [1874, 1], [2294, 1], [2394, 1], [3211, 1], [3310, 1], [7319, 1], [8438, 1]] |
| _analyze_tables_ | num_null | 341 | 0 | 0 | 45 | [[0, 282], [615, 4], [8, 4], [742, 2], [439, 2], [240, 2], [25, 2], [14, 2], [6, 2], [1, 2]] | [[557, 1], [558, 1], [640, 1], [724, 1], [739, 1], [763, 1], [939, 1], [1882, 1], [2377, 1], [7983, 1]] |
| _analyze_tables_ | table | 341 | 0 | 0 | 73 | [["repos", 49], ["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 | 341 | 0 | 0 | 34 | [[774, 53], [1, 43], [2396, 27], [439, 27], [28, 19], [317, 18], [7983, 15], [7918, 13], [3312, 12], [95, 11]] | [[17, 2], [85, 2], [104, 2], [329, 2], [531, 2], [2668, 2], [499, 3], [975, 3], [1874, 3], [8441, 3]] |
| 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 | 1 | 0 | 0 | 1 | [["application/zip", 1]] | |
| assets | created_at | 1 | 0 | 0 | 1 | [["2021-01-04T21:26:30Z", 1]] | |
| assets | download_count | 1 | 0 | 0 | 1 | [[39, 1]] | |
| assets | id | 1 | 0 | 0 | 1 | [[30264367, 1]] | |
| assets | label | 1 | 1 | 0 | 0 | [["None", 1]] | |
| assets | name | 1 | 0 | 0 | 1 | [["datasette-0.53-macos-binary.zip", 1]] | |
| assets | node_id | 1 | 0 | 0 | 1 | [["MDEyOlJlbGVhc2VBc3NldDMwMjY0MzY3", 1]] | |
| assets | release | 1 | 0 | 0 | 1 | [[35131848, 1]] | |
| assets | size | 1 | 0 | 0 | 1 | [[8297283, 1]] | |
| assets | state | 1 | 0 | 0 | 1 | [["uploaded", 1]] | |
| assets | updated_at | 1 | 0 | 0 | 1 | [["2021-01-04T21:26:43Z", 1]] | |
| assets | uploader | 1 | 0 | 0 | 1 | [[9599, 1]] | |
| assets | url | 1 | 0 | 0 | 1 | [["https://api.github.com/repos/simonw/datasette/releases/assets/30264367", 1]] | |
| commits | author | 3312 | 8 | 0 | 87 | [[9599, 3109], [49699333, 34], [45057, 20], [27856297, 17], ["None", 8], [21148, 7], [198537, 6], [3243482, 5], [2657547, 5], [25778, 4]] | [[15278512, 1], [16001974, 1], [17075617, 1], [22578954, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [56323389, 1], [72577720, 1]] |
| commits | author_date | 3312 | 0 | 0 | 3310 | [["2022-03-15T15:36:35Z", 2], ["2021-07-30T00:44:16Z", 2], ["2017-10-24T02:48:06Z", 1], ["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]] | [["2022-05-19T00:37:46Z", 1], ["2022-05-20T19:05:33Z", 1], ["2022-05-20T19:11:08Z", 1], ["2022-05-20T20:34:51Z", 1], ["2022-05-20T20:44:23Z", 1], ["2022-05-20T21:51:30Z", 1], ["2022-05-20T21:57:26Z", 1], ["2022-05-20T21:57:49Z", 1], ["2022-05-20T22:23:09Z", 1], ["2022-05-29T01:42:31Z", 1]] |
| commits | committer | 3312 | 8 | 0 | 4 | [[9599, 2590], [19864447, 703], ["None", 8], [21148, 6], [45057, 5]] | |
| commits | committer_date | 3312 | 0 | 0 | 3211 | [["2018-05-16T15:27:24Z", 23], ["2020-10-27T19:39:55Z", 11], ["2018-04-09T05:10:22Z", 9], ["2020-06-01T01:16:42Z", 8], ["2022-01-06T06:24:53Z", 6], ["2020-11-06T18:30:41Z", 6], ["2019-07-03T03:23:05Z", 5], ["2018-05-14T03:04:23Z", 5], ["2018-05-02T00:20:39Z", 4], ["2018-04-18T01:13:02Z", 4]] | [["2022-05-19T00:37:46Z", 1], ["2022-05-20T19:05:33Z", 1], ["2022-05-20T19:11:28Z", 1], ["2022-05-20T20:34:51Z", 1], ["2022-05-20T20:44:23Z", 1], ["2022-05-20T21:52:00Z", 1], ["2022-05-20T21:57:26Z", 1], ["2022-05-20T21:57:49Z", 1], ["2022-05-20T22:23:09Z", 1], ["2022-05-29T01:42:31Z", 1]] |
| commits | message | 3312 | 0 | 0 | 3215 | [["Fixed typo", 11], ["Typo fix", 9], ["Applied Black", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 5], ["Release 0.4", 4], ["Release 0.3", 4], ["Changelog badge", 4], ["First working version", 3]] | [["utils.path_with_added_args() improvements\n\n* Now covered by unit tests\n* Preserv...", 1], ["v0.8 - added PyPI metadata, ready to ship", 1], ["view-database permission\n\nAlso now using π to indicate private resources - resou...", 1], ["view-instance permission for debug URLs, closes #833", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["word-break: break-word;", 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 | 3312 | 0 | 0 | 93 | [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2880], ["2946d096d0cdefdc017559e6b57e87658736e843", 229], ["5df307d91b1167b0aa175853783d760add239497", 34], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 20], ["2edd38cb3801aa07f709f083eba7cbe4f16e0978", 17], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 7], ["b90d9715d7c0881515e9d6aa98923ed89d445945", 5], ["106fe7fbf8b80a01038e265a137b3b703422db48", 5], ["90786fb02407ad60f10210c0592ee711a9a36fae", 4]] | [["d151532d3a398e1acd965596193c7d4c7c0475ff", 1], ["d6a64a7ba2d6c2c36f86efe56eb62e19518bfd72", 1], ["d9a1cca675e8697c10ac5f4cbceac5ea7dc2a906", 1], ["daa0836007170071f748b575d34c4432f4f43926", 1], ["eab1e8f71bd05f2ff2163f024127cc28876dd05d", 1], ["f25304fb12f6d6fab36f551427610ed8e96f0c2f", 1], ["f2f4d10a554519ea00fb44a5f6377123c59e1f22", 1], ["f3dfe1c3cf166dd0b9b8860a25045107a068c5df", 1], ["f85fb7898f36734a83fd9c8a2c2e96c751920c35", 1], ["fcf3b31d4679bb2112170ec4dda53dede33a16b3", 1]] |
| commits | raw_committer | 3312 | 0 | 0 | 6 | [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2343], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 703], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]] | |
| commits | repo | 3312 | 0 | 0 | 15 | [[107914493, 2017], [140912432, 760], [207052882, 167], [206156866, 132], [197431109, 61], [256834907, 41], [205429375, 33], [197882382, 30], [303218369, 19], [248903544, 13]] | [[209590345, 1], [206649770, 6], [206202864, 10], [213286752, 10], [214746582, 12], [248903544, 13], [303218369, 19], [197882382, 30], [205429375, 33], [256834907, 41]] |
| commits | sha | 3312 | 0 | 0 | 3312 | ||
| commits_fts | message | 3312 | 0 | 0 | 3215 | [["Fixed typo", 11], ["Typo fix", 9], ["Applied Black", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 5], ["Release 0.4", 4], ["Release 0.3", 4], ["Changelog badge", 4], ["First working version", 3]] | [["utils.path_with_added_args() improvements\n\n* Now covered by unit tests\n* Preserv...", 1], ["v0.8 - added PyPI metadata, ready to ship", 1], ["view-database permission\n\nAlso now using π to indicate private resources - resou...", 1], ["view-instance permission for debug URLs, closes #833", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["word-break: break-word;", 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 | 1 | 0 | 0 | 1 | [["version", 1]] | |
| commits_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
| commits_fts_data | block | 40 | 0 | 0 | 40 | ||
| commits_fts_data | id | 40 | 0 | 0 | 40 | ||
| commits_fts_docsize | id | 3312 | 0 | 0 | 3312 | ||
| commits_fts_docsize | sz | 3312 | 0 | 0 | 118 | [["b'\\x07'", 425], ["b'\\x08'", 389], ["b'\\x06'", 376], ["b'\\t'", 323], ["b'\\x05'", 279], ["b'\\n'", 200], ["b'\\x04'", 184], ["b'\\x03'", 184], ["b'\\x0b'", 120], ["b'\\x0c'", 100]] | [["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'\\x81\\x1b'", 1], ["b'\\x81h'", 1]] |
| commits_fts_idx | pgno | 38 | 0 | 0 | 38 | ||
| commits_fts_idx | segid | 38 | 0 | 0 | 1 | [[1, 38]] | |
| commits_fts_idx | term | 38 | 0 | 0 | 38 | ||
| contributors | contributions | 108 | 0 | 0 | 19 | [[1, 74], [2, 9], [3, 4], [10, 3], [5, 3], [6, 2], [20, 1], [18, 1], [17, 1], [13, 1]] | [[20, 1], [30, 1], [31, 1], [34, 1], [40, 1], [61, 1], [128, 1], [157, 1], [735, 1], [1859, 1]] |
| contributors | repo_id | 108 | 0 | 0 | 15 | [[107914493, 62], [140912432, 21], [207052882, 4], [206156866, 4], [214746582, 3], [205429375, 3], [303218369, 2], [256834907, 2], [197882382, 1], [197431109, 1]] | [[197431109, 1], [197882382, 1], [206202864, 1], [206649770, 1], [209590345, 1], [213286752, 1], [248903544, 1], [256834907, 2], [303218369, 2], [214746582, 3]] |
| contributors | user_id | 108 | 0 | 0 | 88 | [[9599, 15], [41546558, 2], [78035, 2], [50527, 2], [49260, 2], [25778, 2], [21148, 2], [3637, 1], [3556, 1], [2182, 1]] | [[17075617, 1], [22578954, 1], [27856297, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [49699333, 1], [56323389, 1], [72577720, 1]] |
| dependents | dependent | 975 | 0 | 0 | 773 | [[150847142, 2], [149112525, 2], [138329050, 2], [112050382, 2], [99911706, 2], [79072630, 2], [51720846, 2], [51665750, 2], [24275324, 2], [5832996, 2]] | [[488401655, 1], [489156146, 1], [490558975, 1], [492396183, 1], [494839851, 1], [496273000, 1], [496865479, 1], [496980728, 1], [496981032, 1], [497566500, 1]] |
| dependents | first_seen_utc | 975 | 0 | 0 | 975 | ||
| dependents | repo | 975 | 0 | 0 | 2 | [[107914493, 491], [140912432, 484]] | |
| emojis | image | 1874 | 0 | 0 | 1747 | [["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\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 1], ["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\\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\\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 | 1874 | 0 | 0 | 1874 | ||
| emojis | url | 1874 | 0 | 0 | 1831 | [["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 | 7983 | 0 | 0 | 4 | [["OWNER", 6420], ["NONE", 721], ["MEMBER", 486], ["CONTRIBUTOR", 356]] | |
| issue_comments | body | 7983 | 0 | 0 | 7910 | [["Thanks!", 22], ["Tracking ticket: #1023", 5], ["Thanks for this!", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["Released: https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.15", 3], ["Part of #551 ", 3], ["Part of #1105", 3], ["Just needs documentation now.", 3], ["Blocked on #37", 3]] | [["wow, thanks a lot @simonw , problem is solved. I converted my current json file ...", 1], ["yes, [filter clause on aggregate queries were added to sqlite3 in 3.30](https://...", 1], ["you can hack something like this to achieve this result:\r\n\r\n`sqlite-utils conver...", 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], ["π 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], ["π€·ββοΈ @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 1]] |
| issue_comments | created_at | 7983 | 0 | 0 | 7982 | [["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]] | [["2022-05-20T20:39:17Z", 1], ["2022-05-20T20:40:09Z", 1], ["2022-05-20T21:28:29Z", 1], ["2022-05-20T21:54:43Z", 1], ["2022-05-20T21:56:10Z", 1], ["2022-05-27T08:05:01Z", 1], ["2022-05-27T08:21:53Z", 1], ["2022-05-27T09:04:05Z", 1], ["2022-05-27T10:20:08Z", 1], ["2022-05-28T19:52:17Z", 1]] |
| issue_comments | html_url | 7983 | 0 | 0 | 7983 | ||
| issue_comments | id | 7983 | 0 | 0 | 7983 | ||
| issue_comments | issue | 7983 | 0 | 0 | 1949 | [[849978964, 50], [973139047, 48], [627794879, 48], [712260429, 47], [1058072543, 45], [824064069, 45], [324188953, 42], [582526961, 40], [1058896236, 34], [681375466, 33]] | [[1212838949, 1], [1215216249, 1], [1223263540, 1], [1224112817, 1], [1227571375, 1], [1239034903, 1], [1239080102, 1], [1243512344, 1], [1250495688, 1], [1251710928, 1]] |
| issue_comments | issue_url | 7983 | 0 | 0 | 1949 | [["https://api.github.com/repos/simonw/datasette/issues/1293", 50], ["https://api.github.com/repos/simonw/datasette/issues/782", 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/datasette/issues/1522", 34], ["https://api.github.com/repos/simonw/datasette/issues/943", 33]] | [["https://api.github.com/repos/simonw/sqlite-utils/issues/52", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/55", 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 | 7983 | 0 | 0 | 7983 | ||
| issue_comments | performed_via_github_app | 7983 | 7983 | 0 | 0 | [["None", 7983]] | |
| issue_comments | reactions | 7983 | 0 | 0 | 15 | [["{\"total_count\": 0, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 7727], ["{\"total_count\": 1, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 153], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 1, \"confused\": 0, \"he...", 30], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 27], ["{\"total_count\": 2, \"+1\": 2, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 11], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 9], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 6], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 5], ["{\"total_count\": 3, \"+1\": 3, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 4], ["{\"total_count\": 2, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 3]] | [["{\"total_count\": 10, \"+1\": 6, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"h...", 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\": 2, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 2, \"confused\": 0, \"he...", 2], ["{\"total_count\": 2, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 3], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 1, \"confused\": 0, \"he...", 3], ["{\"total_count\": 3, \"+1\": 3, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 4], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 5], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 6], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 9]] |
| issue_comments | updated_at | 7983 | 0 | 0 | 7982 | [["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]] | [["2022-05-20T20:39:17Z", 1], ["2022-05-20T20:40:09Z", 1], ["2022-05-20T21:28:29Z", 1], ["2022-05-20T21:54:43Z", 1], ["2022-05-20T21:56:10Z", 1], ["2022-05-27T08:05:01Z", 1], ["2022-05-27T08:21:53Z", 1], ["2022-05-27T10:20:08Z", 1], ["2022-05-27T10:44:54Z", 1], ["2022-05-28T19:52:17Z", 1]] |
| issue_comments | user | 7983 | 0 | 0 | 285 | [[9599, 6906], [22429695, 142], [25778, 52], [45057, 39], [536941, 32], [82988, 32], [3243482, 26], [192568, 20], [30607, 19], [7936571, 18]] | [[36834097, 1], [39538958, 1], [43036882, 1], [45919695, 1], [52261150, 1], [63653929, 1], [72577720, 1], [76450761, 1], [95520595, 1], [102771161, 1]] |
| issue_comments_fts | body | 7983 | 0 | 0 | 7910 | [["Thanks!", 22], ["Tracking ticket: #1023", 5], ["Thanks for this!", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["Released: https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.15", 3], ["Part of #551 ", 3], ["Part of #1105", 3], ["Just needs documentation now.", 3], ["Blocked on #37", 3]] | [["wow, thanks a lot @simonw , problem is solved. I converted my current json file ...", 1], ["yes, [filter clause on aggregate queries were added to sqlite3 in 3.30](https://...", 1], ["you can hack something like this to achieve this result:\r\n\r\n`sqlite-utils conver...", 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], ["π 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], ["π€·ββοΈ @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 1]] |
| issue_comments_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
| issue_comments_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
| issue_comments_fts_data | block | 531 | 0 | 0 | 531 | ||
| issue_comments_fts_data | id | 531 | 0 | 0 | 531 | ||
| issue_comments_fts_docsize | id | 7983 | 0 | 0 | 7983 | ||
| issue_comments_fts_docsize | sz | 7983 | 0 | 0 | 442 | [["b'\\x0f'", 185], ["b'\\x12'", 182], ["b'\\x10'", 173], ["b'\\x0c'", 161], ["b'\\x0e'", 157], ["b'\\r'", 146], ["b'\\x13'", 141], ["b'\\x16'", 136], ["b'\\n'", 131], ["b'\\x11'", 129]] | [["b'\\x89g'", 1], ["b'\\x8a\\x0b'", 1], ["b'\\x8b\"'", 1], ["b'\\x8b5'", 1], ["b'\\x8bh'", 1], ["b'\\x8c\\x05'", 1], ["b'\\x8fK'", 1], ["b'\\x927'", 1], ["b'\\x9f\\\\'", 1], ["b'\\xb3.'", 1]] |
| issue_comments_fts_idx | pgno | 499 | 0 | 0 | 289 | [[20, 4], [18, 4], [16, 4], [14, 4], [12, 4], [10, 4], [8, 4], [6, 4], [4, 4], [2, 4]] | [[610, 1], [612, 1], [614, 1], [616, 1], [618, 1], [620, 1], [622, 1], [624, 1], [626, 1], [628, 1]] |
| issue_comments_fts_idx | segid | 499 | 0 | 0 | 4 | [[5, 285], [7, 87], [6, 84], [1, 43]] | |
| issue_comments_fts_idx | term | 499 | 0 | 0 | 453 | [["b''", 4], ["b'0thea'", 3], ["b'0onc'", 3], ["b'0a0'", 3], ["b'0be1'", 2], ["b'0area'", 2], ["b'0andr'", 2], ["b'0age'", 2], ["b'0abov'", 2], ["b'0110'", 2]] | [["b'0\\xce'", 1], ["b'0wishe'", 1], ["b'0worksp'", 1], ["b'0wr'", 1], ["b'0writesc'", 1], ["b'0wro'", 1], ["b'0x0'", 1], ["b'0yi'", 1], ["b'0your'", 1], ["b'0yox'", 1]] |
| issues | active_lock_reason | 2396 | 2396 | 0 | 0 | [["None", 2396]] | |
| issues | assignee | 2396 | 2377 | 0 | 1 | [["None", 2396]] | |
| issues | author_association | 2396 | 0 | 0 | 6 | [["OWNER", 1523], ["NONE", 325], ["CONTRIBUTOR", 311], ["MEMBER", 194], ["FIRST_TIME_CONTRIBUTOR", 40], ["FIRST_TIMER", 3]] | |
| issues | body | 2396 | 8 | 99 | 2287 | [["", 99], ["None", 8], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\r\nThanks for the excellent library, it's very nice to use!\r\n\r\nI've been building...", 1], ["\r\n![image](https://user-images.githubusercontent.com/42315895/106259325-5f75dc80...", 1], ["\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\nCurrently, the datetimes are formatted in a way that is not recognized by da...", 1]] | [["to keep the data write from failing if it came across an error during processing...", 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]] |
| issues | closed_at | 2396 | 558 | 0 | 1786 | [["None", 558], ["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]] | [["2022-05-03T14:59:51Z", 1], ["2022-05-17T19:40:30Z", 1], ["2022-05-17T19:43:45Z", 1], ["2022-05-20T19:05:34Z", 1], ["2022-05-20T19:11:32Z", 1], ["2022-05-20T21:28:29Z", 1], ["2022-05-20T21:54:43Z", 1], ["2022-05-20T21:57:53Z", 1], ["2022-05-27T08:21:53Z", 1], ["2022-05-28T19:52:17Z", 1]] |
| issues | comments | 2396 | 0 | 0 | 39 | [[1, 615], [0, 447], [2, 377], [3, 279], [4, 168], [5, 93], [6, 88], [7, 57], [8, 49], [9, 38]] | [[17, 1], [23, 1], [28, 1], [32, 1], [33, 1], [34, 1], [40, 1], [42, 1], [47, 1], [50, 1]] |
| issues | created_at | 2396 | 0 | 0 | 2396 | ||
| issues | draft | 2396 | 1957 | 0 | 2 | [["None", 1957], [0, 431], [1, 8]] | |
| issues | id | 2396 | 0 | 0 | 2396 | ||
| issues | locked | 2396 | 0 | 0 | 1 | [[0, 2396]] | |
| issues | milestone | 2396 | 1882 | 0 | 27 | [["None", 1882], [3268330, 98], [6026070, 53], [2857392, 49], [5512395, 39], [5533512, 25], [7571612, 24], [4305096, 22], [5971510, 21], [2949431, 21]] | [[5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414, 5], [3439337, 7], [5225818, 7], [6079500, 7], [5234079, 8], [5897911, 8]] |
| issues | node_id | 2396 | 0 | 0 | 2396 | ||
| issues | number | 2396 | 0 | 0 | 1680 | [[2, 14], [1, 14], [4, 13], [3, 13], [8, 12], [7, 12], [6, 12], [5, 12], [10, 11], [9, 11]] | [[1743, 1], [1744, 1], [1745, 1], [1746, 1], [1747, 1], [1748, 1], [1749, 1], [1750, 1], [1751, 1], [1752, 1]] |
| issues | performed_via_github_app | 2396 | 2396 | 0 | 0 | [["None", 2396]] | |
| issues | pull_request | 2396 | 1957 | 0 | 439 | [["None", 1957], ["dogsheep/dogsheep.github.io/pulls/5", 1], ["dogsheep/dogsheep.github.io/pulls/4", 1], ["dogsheep/dogsheep.github.io/pulls/3", 1], ["dogsheep/dogsheep.github.io/pulls/1", 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]] | [["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 | 2396 | 2 | 0 | 2394 | [["None", 2], ["{\"url\": \"https://api.github.com/repos/dogsheep/dogsheep-beta/issues/17/reactions...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/dogsheep-beta/issues/16/reactions...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/dogsheep-beta/issues/15/reactions...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/dogsheep-beta/issues/14/reactions...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/dogsheep-beta/issues/13/reactions...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/dogsheep-beta/issues/12/reactions...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/dogsheep-beta/issues/11/reactions...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/dogsheep-beta/issues/10/reactions...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/dogsheep-beta/issues/1/reactions\"...", 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 | 2396 | 0 | 0 | 14 | [[107914493, 1665], [140912432, 438], [207052882, 72], [206156866, 66], [256834907, 36], [197431109, 35], [197882382, 22], [303218369, 15], [205429375, 12], [206649770, 11]] | [[209590345, 2], [248903544, 4], [214746582, 8], [213286752, 10], [206649770, 11], [205429375, 12], [303218369, 15], [197882382, 22], [197431109, 35], [256834907, 36]] |
| issues | state | 2396 | 0 | 0 | 2 | [["closed", 1838], ["open", 558]] | |
| issues | state_reason | 2396 | 939 | 0 | 1 | [["completed", 2396]] | |
| issues | title | 2396 | 0 | 0 | 2384 | [["`sqlite-utils bulk` command", 2], ["Upgrade to sqlite-utils 2.x", 2], ["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], ["Configure sphinx.ext.extlinks for issues", 2], ["Add SpatiaLite helpers to CLI", 2]] | [["users-lookup command for fetching users", 1], ["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], ["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 | 2396 | 0 | 0 | 2 | [["issue", 1957], ["pull", 439]] | |
| issues | updated_at | 2396 | 0 | 0 | 2294 | [["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]] | [["2022-05-24T16:42:20Z", 1], ["2022-05-25T01:35:12Z", 1], ["2022-05-27T03:13:59Z", 1], ["2022-05-27T08:21:53Z", 1], ["2022-05-27T10:20:08Z", 1], ["2022-05-27T10:44:54Z", 1], ["2022-05-27T10:58:37Z", 1], ["2022-05-28T18:45:48Z", 1], ["2022-05-28T19:52:17Z", 1], ["2022-05-28T22:46:52Z", 1]] |
| issues | user | 2396 | 0 | 0 | 318 | [[9599, 1717], [49699333, 41], [45057, 26], [27856297, 22], [536941, 18], [82988, 18], [192568, 15], [3243482, 14], [25778, 13], [649467, 11]] | [[55480210, 1], [56323389, 1], [57161638, 1], [57859326, 1], [66709385, 1], [69208826, 1], [76450761, 1], [82332573, 1], [87192257, 1], [91880982, 1]] |
| issues_fts | body | 2396 | 8 | 99 | 2287 | [["", 99], ["None", 8], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\r\nThanks for the excellent library, it's very nice to use!\r\n\r\nI've been building...", 1], ["\r\n![image](https://user-images.githubusercontent.com/42315895/106259325-5f75dc80...", 1], ["\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\nCurrently, the datetimes are formatted in a way that is not recognized by da...", 1]] | [["to keep the data write from failing if it came across an error during processing...", 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]] |
| issues_fts | title | 2396 | 0 | 0 | 2384 | [["`sqlite-utils bulk` command", 2], ["Upgrade to sqlite-utils 2.x", 2], ["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], ["Configure sphinx.ext.extlinks for issues", 2], ["Add SpatiaLite helpers to CLI", 2]] | [["users-lookup command for fetching users", 1], ["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], ["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 | 1 | 0 | 0 | 1 | [["version", 1]] | |
| issues_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
| issues_fts_data | block | 329 | 0 | 0 | 329 | ||
| issues_fts_data | id | 329 | 0 | 0 | 329 |