315 rows

View and edit SQL

Suggested facets: num_blank

Link table column total_rows num_null num_blank num_distinct most_common least_common
_analyze_tables_ column 315 0 0 131 [["id", 32], ["name", 16], ["repo", 11], ["v", 10], ["term", 10], ["sz", 10], ["segid", 10], ["pgno", 10], ["k", 10], ["block", 10]] [["target_commitish", 1], ["temp_clone_token", 1], ["topics", 1], ["total_rows", 1], ["user_id", 1], ["uses", 1], ["watchers", 1], ["watchers_count", 1], ["with", 1], ["workflow", 1]]
_analyze_tables_ least_common 315 204 0 93 [["None", 204], ["[[91, 1], [92, 1], [101, 1], [103, 1], [174, 1], [183, 1], [297, 1], [1057, 1], ...", 3], ["[[\"plugins\", 1], [\"python-library\", 1], [\"refactor\", 1], [\"search\", 1], [\"securi...", 2], ["[[\"https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2\", 1], [\"htt...", 2], ["[[\"closes #563\", 1], [\"closes bugfix issue #572 \", 1], [\"https://github.com/enco...", 2], ["[[\"Datasette 0.45\", 1], [\"Datasette 0.46\", 1], [\"Datasette 0.49\", 1], [\"Datasett...", 2], ["[[\"Datasette 0.29\", 1], [\"Datasette 0.31\", 1], [\"Datasette 0.32\", 1], [\"Datasett...", 2], ["[[\"Awaiting something else to happen first\", 1], [\"Extra attention is needed\", 1...", 2], ["[[\"2.4.4\", 1], [\"2.7.1\", 1], [\"2.7.2\", 1], [\"2.8.1\", 1], [\"2.8.2\", 1], [\"2.9\", 1...", 2], ["[[\"0.15 is already pretty stable - a few small fixes and I'm going to ship 1.0.\"...", 2]] [["[[507903392, 1], [510235909, 1], [510956134, 1], [511549374, 1], [511868153, 1],...", 1], ["[[5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414, 5], [3439337,...", 1], ["[[68551873, 1], [68790102, 1], [70820453, 1], [71583176, 1], [71698300, 1], [736...", 1], ["[[69994933, 1], [69995013, 1], [69995240, 1], [70040661, 1], [70041098, 1], [700...", 1], ["[[7, 1], [9, 1], [10, 1], [11, 1], [23, 1], [92, 1], [94, 1], [154, 1], [8, 2], ...", 1], ["[[756761963, 1], [758899581, 1], [765637324, 1], [766494367, 1], [771324837, 1],...", 1], ["[[766494367, 1], [769150394, 1], [769282206, 1], [769376447, 1], [769520939, 1],...", 1], ["[[862, 1], [864, 1], [865, 1], [866, 1], [867, 1], [869, 1], [870, 1], [871, 1],...", 1], ["[[9, 2], [26, 2], [27, 2], [30, 2], [34, 2], [39, 2], [177, 2], [297, 2], [1652,...", 1], ["[[993222446, 1], [1405404904, 1], [1918831023, 1], [2175284252, 1], [2459412274,...", 1]]
_analyze_tables_ most_common 315 98 0 167 [["None", 98], ["[[4, 1]]", 10], ["[[\"version\", 1]]", 10], ["[[2, 1]]", 3], ["[[1, 1]]", 3], ["[[0, 366]]", 3], ["[[0, 230], [1, 41], [2, 23], [3, 14], [7, 6], [12, 5], [4, 4], [19, 3], [6, 3], ...", 3], ["[[\"b''\", 1]]", 3], ["[[\"None\", 366]]", 3], ["[[\"None\", 1558]]", 3]] [["[[868, 3], [873, 2], [863, 2], [861, 2], [858, 2], [855, 2], [852, 2], [856, 1],...", 1], ["[[9599, 1220], [45057, 26], [27856297, 17], [82988, 16], [3243482, 12], [2181410...", 1], ["[[9599, 128], [45057, 19], [27856297, 16], [3243482, 6], [2657547, 5], [49260, 4...", 1], ["[[9599, 15], [78035, 2], [50527, 2], [49260, 2], [35681, 1], [32314, 1], [21148,...", 1], ["[[9599, 1987], [19864447, 453], [\"None\", 8], [21148, 6], [45057, 5]]", 1], ["[[9599, 2337], [45057, 20], [27856297, 14], [\"None\", 8], [21148, 6], [2657547, 5...", 1], ["[[9599, 241]]", 1], ["[[9599, 24]]", 1], ["[[9599, 4239], [22429695, 45], [45057, 39], [82988, 26], [3243482, 21], [7936571...", 1], ["[[9599, 92], [53015001, 13], [38107867, 7], [5802411, 6], [55949623, 5], [390144...", 1]]
_analyze_tables_ num_blank 315 0 0 10 [[0, 301], [83, 2], [45, 2], [30, 2], [14, 2], [8, 2], [5235, 1], [366, 1], [65, 1], [59, 1]]  
_analyze_tables_ num_distinct 315 0 0 101 [[1, 51], [2, 19], [3, 12], [268, 10], [5235, 9], [24, 9], [366, 8], [8, 8], [241, 7], [23, 7]] [[1058, 1], [1122, 1], [1218, 1], [1490, 1], [1747, 1], [1757, 1], [1799, 1], [2371, 1], [4935, 1], [5448, 1]]
_analyze_tables_ num_null 315 0 0 35 [[0, 273], [260, 4], [1558, 2], [360, 2], [101, 2], [14, 2], [8, 2], [15, 1], [4, 1], [1, 1]] [[238, 1], [245, 1], [266, 1], [268, 1], [298, 1], [302, 1], [1151, 1], [1290, 1], [1541, 1], [4754, 1]]
_analyze_tables_ table 315 0 0 72 [["repos", 43], ["pull_requests", 22], ["issues", 20], ["milestones", 15], ["releases", 13], ["issue_comments", 12], ["steps", 10], ["users", 9], ["commits", 9], ["_analyze_tables_", 8]] [["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 315 0 0 37 [[366, 47], [1, 29], [268, 26], [1558, 24], [24, 22], [241, 17], [4754, 15], [5235, 13], [2459, 12], [79, 11]] [[9, 2], [26, 2], [27, 2], [30, 2], [34, 2], [39, 2], [177, 2], [297, 2], [1652, 2], [5451, 3]]
commits author 2459 8 0 52 [[9599, 2337], [45057, 20], [27856297, 14], ["None", 8], [21148, 6], [2657547, 5], [198537, 5], [3243482, 4], [72973, 3], [50527, 3]] [[10352819, 1], [13896256, 1], [15278512, 1], [17075617, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [41546558, 1], [56323389, 1]]
commits author_date 2459 0 0 2459    
commits committer 2459 8 0 4 [[9599, 1987], [19864447, 453], ["None", 8], [21148, 6], [45057, 5]]  
commits committer_date 2459 0 0 2371 [["2018-05-16T15:27:24Z", 23], ["2020-10-27T19:39:55Z", 11], ["2018-04-09T05:10:22Z", 9], ["2020-06-01T01:16:42Z", 8], ["2020-11-06T18:30:41Z", 6], ["2019-07-03T03:23:05Z", 5], ["2018-05-14T03:04:23Z", 5], ["2019-12-30T05:29:23Z", 4], ["2018-05-02T00:20:39Z", 4], ["2018-04-18T01:13:02Z", 4]] [["2020-12-19T06:17:27Z", 1], ["2020-12-19T06:18:01Z", 1], ["2020-12-19T20:30:04Z", 1], ["2020-12-21T19:48:06Z", 1], ["2020-12-21T21:49:14Z", 1], ["2020-12-22T19:04:29Z", 1], ["2020-12-22T19:48:54Z", 1], ["2020-12-22T20:04:18Z", 1], ["2020-12-22T23:55:43Z", 1], ["2020-12-23T17:04:32Z", 1]]
commits message 2459 0 0 2381 [["Updated README", 8], ["Typo fix", 8], ["Release 0.2", 8], ["Applied Black", 8], ["Typo", 5], ["Fixed typo", 5], ["Release 0.3", 4], ["Changelog badge", 4], ["Release 0.4", 3], ["First working version", 3]] [["users-lookup command, closes #7", 1], ["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 \ud83d\udd12 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]]
commits raw_author 2459 0 0 58 [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2108], ["2946d096d0cdefdc017559e6b57e87658736e843", 229], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 20], ["2edd38cb3801aa07f709f083eba7cbe4f16e0978", 14], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["b90d9715d7c0881515e9d6aa98923ed89d445945", 5], ["106fe7fbf8b80a01038e265a137b3b703422db48", 4], ["6410ac01839c113476668eeff88d60a0a2c6eb7a", 3], ["207bb2132044fa5a4fe28a579f7588c2eee6e391", 3]] [["bd53542d6923dd8fcfd93cd43a925e6e8acd6e80", 1], ["c49d52addfdcb2a0682b83ad3b98e88426921728", 1], ["caa5b5002180b0bc856f66473e9ba8058a4c820e", 1], ["d151532d3a398e1acd965596193c7d4c7c0475ff", 1], ["d9a1cca675e8697c10ac5f4cbceac5ea7dc2a906", 1], ["daa0836007170071f748b575d34c4432f4f43926", 1], ["eab1e8f71bd05f2ff2163f024127cc28876dd05d", 1], ["f25304fb12f6d6fab36f551427610ed8e96f0c2f", 1], ["f2f4d10a554519ea00fb44a5f6377123c59e1f22", 1], ["f3dfe1c3cf166dd0b9b8860a25045107a068c5df", 1]]
commits raw_committer 2459 0 0 6 [["13ae486343ea6454a93114c6f558ffea2f2c6874", 1740], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 453], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]]  
commits repo 2459 0 0 15 [[107914493, 1531], [140912432, 439], [207052882, 157], [206156866, 119], [197431109, 58], [256834907, 40], [205429375, 29], [197882382, 28], [214746582, 12], [206202864, 10]] [[209590345, 1], [206649770, 6], [303218369, 9], [206202864, 10], [213286752, 10], [248903544, 10], [214746582, 12], [197882382, 28], [205429375, 29], [256834907, 40]]
commits sha 2459 0 0 2459    
commits_fts message 2459 0 0 2381 [["Updated README", 8], ["Typo fix", 8], ["Release 0.2", 8], ["Applied Black", 8], ["Typo", 5], ["Fixed typo", 5], ["Release 0.3", 4], ["Changelog badge", 4], ["Release 0.4", 3], ["First working version", 3]] [["users-lookup command, closes #7", 1], ["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 \ud83d\udd12 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]]
commits_fts_config k 1 0 0 1 [["version", 1]]  
commits_fts_config v 1 0 0 1 [[4, 1]]  
commits_fts_data block 30 0 0 30    
commits_fts_data id 30 0 0 30    
commits_fts_docsize id 2459 0 0 2459    
commits_fts_docsize sz 2459 0 0 107 [["b'\\x07'", 311], ["b'\\x08'", 298], ["b'\\x06'", 260], ["b'\\t'", 221], ["b'\\x05'", 211], ["b'\\x03'", 164], ["b'\\x04'", 150], ["b'\\n'", 145], ["b'\\x0b'", 80], ["b'\\x02'", 68]] [["b'\\x81&'", 1], ["b'\\x81,'", 1], ["b'\\x819'", 1], ["b'\\x81?'", 1], ["b'\\x81['", 1], ["b'\\x81\\\\'", 1], ["b'\\x81\\x03'", 1], ["b'\\x81\\x14'", 1], ["b'\\x81\\x1b'", 1], ["b'\\x81h'", 1]]
commits_fts_idx pgno 28 0 0 28    
commits_fts_idx segid 28 0 0 1 [[1, 28]]  
commits_fts_idx term 28 0 0 28    
contributors contributions 70 0 0 18 [[1, 41], [2, 6], [10, 4], [3, 3], [6, 2], [4, 2], [20, 1], [14, 1], [9, 1], [5, 1]] [[14, 1], [20, 1], [27, 1], [28, 1], [39, 1], [58, 1], [118, 1], [149, 1], [426, 1], [1436, 1]]
contributors repo_id 70 0 0 15 [[107914493, 40], [140912432, 11], [214746582, 3], [205429375, 3], [256834907, 2], [207052882, 2], [206202864, 1], [206156866, 1], [197882382, 1], [197431109, 1]] [[197431109, 1], [197882382, 1], [206156866, 1], [206202864, 1], [206649770, 1], [209590345, 1], [213286752, 1], [248903544, 1], [303218369, 1], [256834907, 2]]
contributors user_id 70 0 0 53 [[9599, 15], [78035, 2], [50527, 2], [49260, 2], [35681, 1], [32314, 1], [21148, 1], [19921, 1], [15543, 1], [15092, 1]] [[13896256, 1], [15278512, 1], [17075617, 1], [27856297, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [41546558, 1], [56323389, 1]]
dependents dependent 452 0 0 365 [[197431109, 2], [193715692, 2], [193603180, 2], [164026920, 2], [149112525, 2], [112050382, 2], [99911706, 2], [51720846, 2], [51665750, 2], [5832996, 2]] [[314804454, 1], [314897522, 1], [315739001, 1], [315796015, 1], [317939993, 1], [319199238, 1], [319369502, 1], [320914777, 1], [320937483, 1], [324110967, 1]]
dependents first_seen_utc 452 0 0 452    
dependents repo 452 0 0 2 [[107914493, 231], [140912432, 221]]  
emojis image 1799 0 0 1747 [["b'Not Found\\n'", 11], ["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 1799 0 0 1799    
emojis url 1799 0 0 1757 [["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 4754 0 0 4 [["OWNER", 3801], ["MEMBER", 438], ["NONE", 339], ["CONTRIBUTOR", 176]]  
issue_comments body 4754 0 0 4706 [["Thanks!", 12], ["Tracking ticket: #1023", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["Shipped in [Datasette 0.38](https://datasette.readthedocs.io/en/latest/changelog...", 3], ["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]] [["reading through the code for `github-to-sqlite repos` - one of the things it doe...", 1], ["ref #46 ", 1], ["thanks a lot, Simon ", 1], ["tried quickly, this seems working:\r\n\r\n```\r\n~ pip3 install pyinstaller\r\n~ pyinsta...", 1], ["well, I succeeded to make uvicorn work.", 1], ["\u2764\ufe0f thanks!", 1], ["\ud83c\udf89 Thanks so much @simonw ! \ud83c\udf89 ", 1], ["\ud83d\udc4b I'd be interested in building this out in Q1 or Q2 of 2020 if nobody has tackl...", 1], ["\ud83d\udc4d I'd like this too! ", 1], ["\ud83e\udd37\u200d\u2642\ufe0f @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 1]]
issue_comments created_at 4754 0 0 4754    
issue_comments html_url 4754 0 0 4754    
issue_comments id 4754 0 0 4754    
issue_comments issue 4754 0 0 1248 [[324188953, 42], [582526961, 40], [681375466, 33], [770436876, 32], [309471814, 31], [608058890, 28], [459397625, 27], [396212021, 27], [323681589, 27], [582517965, 26]] [[756761963, 1], [758899581, 1], [765637324, 1], [766494367, 1], [771324837, 1], [771511344, 1], [771872303, 1], [772408750, 1], [772438273, 1], [774332247, 1]]
issue_comments issue_url 4754 0 0 1248 [["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/943", 33], ["https://api.github.com/repos/simonw/datasette/issues/1150", 32], ["https://api.github.com/repos/simonw/datasette/issues/189", 31], ["https://api.github.com/repos/simonw/datasette/issues/744", 28], ["https://api.github.com/repos/simonw/datasette/issues/514", 27], ["https://api.github.com/repos/simonw/datasette/issues/394", 27], ["https://api.github.com/repos/simonw/datasette/issues/266", 27], ["https://api.github.com/repos/simonw/datasette/issues/698", 26]] [["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 4754 0 0 4754    
issue_comments performed_via_github_app 4754 4754 0 0 [["None", 4754]]  
issue_comments reactions 4754 0 0 12 [["{\"total_count\": 0, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 4643], ["{\"total_count\": 1, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 71], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 1, \"confused\": 0, \"he...", 12], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 12], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 4], ["{\"total_count\": 2, \"+1\": 2, \"-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\": 2, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 2, \"confused\": 0, \"he...", 2], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1]] [["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 2, \"+1\": 0, \"-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\": 2, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 2, \"confused\": 0, \"he...", 2], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 1, \"confused\": 0, \"he...", 3], ["{\"total_count\": 2, \"+1\": 2, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 3], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 4], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 12], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 1, \"confused\": 0, \"he...", 12]]
issue_comments updated_at 4754 0 0 4754    
issue_comments user 4754 0 0 153 [[9599, 4239], [22429695, 45], [45057, 39], [82988, 26], [3243482, 21], [7936571, 18], [30607, 17], [222245, 13], [41546558, 12], [2657547, 11]] [[18221871, 1], [26292069, 1], [26342344, 1], [29426418, 1], [32467826, 1], [32605365, 1], [39445562, 1], [39538958, 1], [45919695, 1], [63653929, 1]]
issue_comments_fts body 4754 0 0 4706 [["Thanks!", 12], ["Tracking ticket: #1023", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["Shipped in [Datasette 0.38](https://datasette.readthedocs.io/en/latest/changelog...", 3], ["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]] [["reading through the code for `github-to-sqlite repos` - one of the things it doe...", 1], ["ref #46 ", 1], ["thanks a lot, Simon ", 1], ["tried quickly, this seems working:\r\n\r\n```\r\n~ pip3 install pyinstaller\r\n~ pyinsta...", 1], ["well, I succeeded to make uvicorn work.", 1], ["\u2764\ufe0f thanks!", 1], ["\ud83c\udf89 Thanks so much @simonw ! \ud83c\udf89 ", 1], ["\ud83d\udc4b I'd be interested in building this out in Q1 or Q2 of 2020 if nobody has tackl...", 1], ["\ud83d\udc4d I'd like this too! ", 1], ["\ud83e\udd37\u200d\u2642\ufe0f @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 297 0 0 297    
issue_comments_fts_data id 297 0 0 297    
issue_comments_fts_docsize id 4754 0 0 4754    
issue_comments_fts_docsize sz 4754 0 0 320 [["b'\\x10'", 115], ["b'\\x0f'", 114], ["b'\\x0c'", 109], ["b'\\x12'", 108], ["b'\\x0e'", 100], ["b'\\x11'", 93], ["b'\\x13'", 91], ["b'\\x0b'", 89], ["b'\\x16'", 87], ["b'\\n'", 87]] [["b'\\x85\\x1c'", 1], ["b'\\x85_'", 1], ["b'\\x85q'", 1], ["b'\\x87a'", 1], ["b'\\x89g'", 1], ["b'\\x8a\\x0b'", 1], ["b'\\x8fK'", 1], ["b'\\x927'", 1], ["b'\\x9f\\\\'", 1], ["b'\\xb3.'", 1]]
issue_comments_fts_idx pgno 357 0 0 86 [[20, 5], [18, 5], [16, 5], [14, 5], [12, 5], [10, 5], [8, 5], [6, 5], [4, 5], [2, 5]] [[172, 1], [146, 2], [160, 2], [162, 2], [164, 2], [166, 2], [168, 2], [170, 2], [156, 3], [158, 3]]
issue_comments_fts_idx segid 357 0 0 5 [[1, 86], [3, 84], [2, 79], [5, 62], [4, 46]]  
issue_comments_fts_idx term 357 0 0 323 [["b'0a0'", 5], ["b''", 5], ["b'0thea'", 3], ["b'0off'", 3], ["b'010'", 3], ["b'0asa'", 2], ["b'0andr'", 2], ["b'0allo'", 2], ["b'0admini'", 2], ["b'020'", 2]] [["b'0\\xf0'", 1], ["b'0wante'", 1], ["b'0weirdl'", 1], ["b'0whene'", 1], ["b'0wherea'", 1], ["b'0whil'", 1], ["b'0wishe'", 1], ["b'0wra'", 1], ["b'0xl'", 1], ["b'0zwellf'", 1]]
issues active_lock_reason 1558 1558 0 0 [["None", 1558]]  
issues assignee 1558 1541 0 1 [["None", 1558]]  
issues author_association 1558 0 0 6 [["OWNER", 1036], ["MEMBER", 184], ["NONE", 167], ["CONTRIBUTOR", 154], ["FIRST_TIME_CONTRIBUTOR", 15], ["FIRST_TIMER", 2]]  
issues body 1558 0 83 1473 [["", 83], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], [" Development Status :: 5 - Production/Stable", 1], [" /database-name-7sha256/table-name/compound-pk\r\n /database-name-7sha256/ta...", 1], [" $ twitter-to-sqlite search dogsheep", 1], [" $ datasette package ~/parlgov-db/parlgov.db --metadata=~/parlgov-db/parlgov....", 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]] [["sqlite-utils now uses a better way of escaping table names, which has highlighte...", 1], ["testing some data from european power information (entsoe.eu), the title of the ...", 1], ["the `--connection` parameter has become positional", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["tiny tweak to make this easier to visually parse\u2014I think it matches your style i...", 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], ["vegaEmbed is a LOT of code (it bundles d3)\r\n\r\nInspired by this tweet: https://tw...", 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]]
issues closed_at 1558 302 0 1218 [["None", 302], ["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]] [["2020-12-16T21:27:10Z", 1], ["2020-12-16T21:44:39Z", 1], ["2020-12-16T21:51:54Z", 1], ["2020-12-18T01:01:26Z", 1], ["2020-12-18T22:34:12Z", 1], ["2020-12-19T06:18:07Z", 1], ["2020-12-19T07:47:11Z", 1], ["2020-12-21T19:51:18Z", 1], ["2020-12-21T21:49:20Z", 1], ["2020-12-23T17:04:32Z", 1]]
issues comments 1558 0 0 33 [[1, 399], [0, 310], [2, 247], [3, 190], [4, 101], [5, 66], [6, 60], [8, 35], [7, 30], [10, 24]] [[17, 1], [22, 1], [24, 1], [25, 1], [28, 1], [31, 1], [32, 1], [33, 1], [40, 1], [42, 1]]
issues created_at 1558 0 0 1558    
issues id 1558 0 0 1558    
issues locked 1558 0 0 1 [[0, 1558]]  
issues milestone 1558 1151 0 24 [["None", 1151], [6026070, 53], [2857392, 49], [3268330, 47], [5512395, 39], [5533512, 25], [4305096, 22], [5971510, 21], [2949431, 21], [6055094, 15]] [[5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414, 5], [3439337, 7], [5225818, 7], [6079500, 7], [5234079, 8], [5897911, 8]]
issues node_id 1558 0 0 1558    
issues number 1558 0 0 1122 [[1, 14], [2, 13], [3, 12], [5, 11], [4, 11], [7, 10], [6, 10], [10, 9], [9, 9], [8, 9]] [[1150, 1], [1151, 1], [1152, 1], [1153, 1], [1154, 1], [1155, 1], [1156, 1], [1157, 1], [1158, 1], [1159, 1]]
issues performed_via_github_app 1558 1558 0 0 [["None", 1558]]  
issues pull_request 1558 1290 0 268 [["None", 1290], ["dogsheep/evernote-to-sqlite/pulls/8", 1], ["dogsheep/evernote-to-sqlite/pulls/10", 1], ["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/31", 1], ["dogsheep/dogsheep-photos/pulls/30", 1], ["dogsheep/dogsheep-photos/pulls/29", 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 repo 1558 0 0 14 [[107914493, 1121], [140912432, 210], [207052882, 59], [206156866, 53], [256834907, 31], [197431109, 31], [197882382, 14], [205429375, 11], [303218369, 10], [213286752, 7]] [[248903544, 1], [209590345, 2], [206649770, 3], [214746582, 5], [213286752, 7], [303218369, 10], [205429375, 11], [197882382, 14], [197431109, 31], [256834907, 31]]
issues state 1558 0 0 2 [["closed", 1256], ["open", 302]]  
issues title 1558 0 0 1553 [["render_cell(value) plugin hook", 2], ["insert_all(..., alter=True) should work for new columns introduced after the fir...", 2], ["Upgrade to sqlite-utils 2.x", 2], ["TemplateAssertionError: no filter named 'tojson'", 2], ["Magic parameters for canned queries", 2], ["\"Invalid SQL\" page should let you edit the SQL", 1], ["\"Edit SQL\" button on canned queries", 1], [" Import pysqlite3 if available, closes #360 ", 1], [" Don't duplicate simple primary keys in the link column", 1], [" /-/permissions debugging tool", 1]] [["twitter-to-sqlite import command, refs #4", 1], ["twitter-to-sqlite user-timeline [screen_names] --sql / --attach", 1], ["updating metadata.json without recreating the app", 1], ["upgrade to uvicorn-0.9 to be Python-3.8 friendly", 1], ["upload command should be resumable, should only upload photos not already upload...", 1], ["upsert_all() throws issue when upserting to empty table", 1], ["use jsonify_if_need for sql updates", 1], ["users-lookup command for fetching users", 1], ["{\"$file\": ...} mechanism is broken", 1], ["{{ csrftoken() }} doesn't work with datasette.render_template()", 1]]
issues type 1558 0 0 2 [["issue", 1290], ["pull", 268]]  
issues updated_at 1558 0 0 1490 [["2019-05-29T21:39:12Z", 7], ["2018-07-24T04:53:20Z", 6], ["2020-11-28T23:26:33Z", 4], ["2020-10-23T19:44:06Z", 4], ["2020-09-30T20:36:12Z", 4], ["2020-09-24T20:35:47Z", 3], ["2020-09-24T20:34:50Z", 3], ["2020-05-27T20:21:56Z", 3], ["2019-05-27T20:05:34Z", 3], ["2019-05-13T18:33:51Z", 3]] [["2020-12-21T21:49:20Z", 1], ["2020-12-22T23:58:04Z", 1], ["2020-12-23T00:14:25Z", 1], ["2020-12-23T17:05:32Z", 1], ["2020-12-24T11:29:21Z", 1], ["2020-12-24T22:26:22Z", 1], ["2020-12-26T17:08:44Z", 1], ["2020-12-27T14:51:39Z", 1], ["2020-12-27T19:02:06Z", 1], ["2020-12-28T18:49:21Z", 1]]
issues user 1558 0 0 167 [[9599, 1220], [45057, 26], [27856297, 17], [82988, 16], [3243482, 12], [2181410, 10], [7936571, 7], [2657547, 7], [649467, 7], [30607, 6]] [[35750428, 1], [36796532, 1], [39452697, 1], [39538958, 1], [42387931, 1], [50578294, 1], [50906992, 1], [55480210, 1], [56323389, 1], [58088336, 1]]
issues_fts body 1558 0 83 1473 [["", 83], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], [" Development Status :: 5 - Production/Stable", 1], [" /database-name-7sha256/table-name/compound-pk\r\n /database-name-7sha256/ta...", 1], [" $ twitter-to-sqlite search dogsheep", 1], [" $ datasette package ~/parlgov-db/parlgov.db --metadata=~/parlgov-db/parlgov....", 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]] [["sqlite-utils now uses a better way of escaping table names, which has highlighte...", 1], ["testing some data from european power information (entsoe.eu), the title of the ...", 1], ["the `--connection` parameter has become positional", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["tiny tweak to make this easier to visually parse\u2014I think it matches your style i...", 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], ["vegaEmbed is a LOT of code (it bundles d3)\r\n\r\nInspired by this tweet: https://tw...", 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]]
issues_fts title 1558 0 0 1553 [["render_cell(value) plugin hook", 2], ["insert_all(..., alter=True) should work for new columns introduced after the fir...", 2], ["Upgrade to sqlite-utils 2.x", 2], ["TemplateAssertionError: no filter named 'tojson'", 2], ["Magic parameters for canned queries", 2], ["\"Invalid SQL\" page should let you edit the SQL", 1], ["\"Edit SQL\" button on canned queries", 1], [" Import pysqlite3 if available, closes #360 ", 1], [" Don't duplicate simple primary keys in the link column", 1], [" /-/permissions debugging tool", 1]] [["twitter-to-sqlite import command, refs #4", 1], ["twitter-to-sqlite user-timeline [screen_names] --sql / --attach", 1], ["updating metadata.json without recreating the app", 1], ["upgrade to uvicorn-0.9 to be Python-3.8 friendly", 1], ["upload command should be resumable, should only upload photos not already upload...", 1], ["upsert_all() throws issue when upserting to empty table", 1], ["use jsonify_if_need for sql updates", 1], ["users-lookup command for fetching users", 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 177 0 0 177    
issues_fts_data id 177 0 0 177    
issues_fts_docsize id 1558 0 0 1558    
issues_fts_docsize sz 1558 0 0 937 [["b'\\x07\\x00'", 15], ["b'\\x06\\x00'", 12], ["b'\\x04\\x00'", 12], ["b'\\x08\\x02'", 10], ["b'\\x07\\x02'", 10], ["b'\\x05\\x00'", 10], ["b'\\t\\x00'", 9], ["b'\\x05\\x02'", 8], ["b'\\x07\\n'", 7], ["b'\\x04\\x02'", 7]] [["b'\\x11\\x81\\r'", 1], ["b'\\x11\\x81\\x15'", 1], ["b'\\x11\\x89`'", 1], ["b'\\x11\\x8a\\r'", 1], ["b'\\x11\\x8ax'", 1], ["b'\\x14\\x00'", 1], ["b'\\x14o'", 1], ["b'\\x14z'", 1], ["b'\\x15g'", 1], ["b'\\x16\\x06'", 1]]
issues_fts_idx pgno 175 0 0 93 [[20, 2], [18, 2], [16, 2], [14, 2], [12, 2], [10, 2], [8, 2], [6, 2], [4, 2], [2, 2]] [[168, 1], [170, 1], [172, 1], [174, 1], [176, 1], [178, 1], [180, 1], [182, 1], [184, 1], [186, 1]]
issues_fts_idx segid 175 0 0 2 [[1, 93], [2, 82]]  
issues_fts_idx term 175 0 0 171 [["b'0tryi'", 2], ["b'0a0'", 2], ["b'020'", 2], ["b''", 2], ["b'030'", 1], ["b'0270'", 1], ["b'013'", 1], ["b'01256'", 1], ["b'00xa'", 1], ["b'00x7f65'", 1]] [["b'0v2'", 1], ["b'0versione'", 1], ["b'0virtualf'", 1], ["b'0whate'", 1], ["b'0whe'", 1], ["b'0willi'", 1], ["b'0withi'", 1], ["b'0worko'", 1], ["b'0xfe'", 1], ["b'0yh'", 1]]
issues_labels issues_id 1652 0 0 1058 [[647103735, 6], [726094754, 5], [652961907, 5], [582526961, 5], [573755726, 5], [526913133, 4], [455965174, 4], [323718842, 4], [323658641, 4], [317714268, 4]] [[766494367, 1], [769150394, 1], [769282206, 1], [769376447, 1], [769520939, 1], [770448622, 1], [771208009, 1], [771216293, 1], [771316301, 1], [772408750, 1]]
issues_labels labels_id 1652 0 0 79 [[729585263, 211], [727708732, 134], [947261894, 124], [754269786, 119], [750789605, 99], [993377884, 93], [727708734, 80], [729586521, 62], [1913901969, 37], [1379448359, 37]] [[1599584307, 1], [1924025922, 1], [1996280384, 1], [2051881526, 1], [2245226086, 1], [2389600683, 1], [2389750367, 1], [2418058309, 1], [2459412274, 1], [2483142469, 1]]
jobs id 31 0 0 31    
jobs if 31 30 0 1 [["None", 31]]  
jobs name 31 0 0 7 [["test", 15], ["deploy", 8], ["build", 4], ["scheduled", 1], ["mirror", 1], ["deploy_docker", 1], ["Analyze", 1]]  
jobs needs 31 23 0 2 [["None", 23], ["[\"test\"]", 7], ["[\"deploy\"]", 1]]  
jobs repo 31 0 0 9 [[107914493, 8], [207052882, 5], [140912432, 4], [303218369, 3], [205429375, 3], [197882382, 3], [197431109, 3], [256834907, 1], [206156866, 1]]  
jobs runs-on 31 0 0 2 [["ubuntu-latest", 30], ["macos-latest", 1]]  
jobs strategy 31 15 0 5 [["None", 15], ["{\"matrix\": {\"python-version\": [3.6, 3.7, 3.8, 3.9]}}", 11], ["{\"matrix\": {\"python-version\": [3.6, 3.7, 3.8]}}", 2], ["{\"matrix\": {\"python-version\": [3.7, 3.8]}}", 1], ["{\"matrix\": {\"python-version\": [3.6, 3.7, 3.8, 3.9], \"numpy\": [0, 1]}}", 1], ["{\"fail-fast\": false, \"matrix\": {\"language\": [\"python\"]}}", 1]]  
jobs workflow 31 0 0 23 [[868, 3], [873, 2], [863, 2], [861, 2], [858, 2], [855, 2], [852, 2], [856, 1], [854, 1], [853, 1]] [[862, 1], [864, 1], [865, 1], [866, 1], [867, 1], [869, 1], [870, 1], [871, 1], [872, 1], [874, 1]]
labels color 79 0 0 54 [["a2eeef", 11], ["d73a4a", 8], ["0075ca", 7], ["ffffff", 2], ["e4e669", 2], ["26bf03", 1], ["083993", 1], ["0366d6", 1], ["008672", 1], ["006b75", 1]] [["e6e6e6", 1], ["e8be84", 1], ["ecc7fc", 1], ["ee0701", 1], ["f759cf", 1], ["fc79af", 1], ["fc8b0a", 1], ["fcbabb", 1], ["fcd0c4", 1], ["fcecc4", 1]]

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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])
);