330 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 330 0 0 138 [["id", 33], ["name", 17], ["repo", 11], ["term", 10], ["sz", 10], ["segid", 10], ["pgno", 10], ["node_id", 10], ["k", 10], ["block", 10]] [["temp_clone_token", 1], ["topics", 1], ["total_rows", 1], ["uploader", 1], ["user_id", 1], ["uses", 1], ["watchers", 1], ["watchers_count", 1], ["with", 1], ["workflow", 1]]
_analyze_tables_ least_common 330 211 0 101 [["None", 211], ["[[101, 1], [103, 1], [115, 1], [135, 1], [183, 1], [223, 1], [421, 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], ["[[\"https://github.com/encode/uvicorn/commits/0.8.4\\r\\n\\r\\nQuery strings will now...", 2], ["[[\"Datasette 0.46\", 1], [\"Datasette 0.49\", 1], [\"Datasette 0.50\", 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], ["[[\"3.1.1\", 1], [\"3.2\", 1], [\"3.2.1\", 1], [\"3.3\", 1], [\"3.4\", 1], [\"3.4.1\", 1], [...", 2], ["[[\"0.15 is already pretty stable - a few small fixes and I'm going to ship 1.0.\"...", 2]] [["[[5234079, 1], [5533512, 1], [5897911, 1], [6055094, 1], [4471010, 2], [5971510,...", 1], ["[[56083353, 1], [56156524, 1], [56882985, 1], [58014937, 1], [59967720, 1], [621...", 1], ["[[5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414, 5], [3439337,...", 1], ["[[626130135, 1], [626222676, 1], [630578735, 1], [640484966, 1], [643149273, 1],...", 1], ["[[6434, 2], [6438, 2], [6439, 2], [6442, 2], [6443, 2], [6421, 3], [6432, 3], [6...", 1], ["[[70417645, 1], [70722659, 1], [71753362, 1], [71986186, 1], [72322605, 1], [766...", 1], ["[[78364365, 1], [78947611, 1], [79643385, 1], [80643939, 1], [81559221, 1], [817...", 1], ["[[894948100, 1], [895315478, 1], [899851083, 1], [901009787, 1], [903200328, 1],...", 1], ["[[904071938, 1], [906345899, 1], [906977719, 1], [908276134, 1], [908465747, 1],...", 1], ["[[993222446, 1], [1405404904, 1], [1918831023, 1], [2175284252, 1], [2459412274,...", 1]]
_analyze_tables_ most_common 330 95 0 184 [["None", 95], ["[[4, 1]]", 10], ["[[\"version\", 1]]", 10], ["[[1, 1]]", 3], ["[[0, 479]]", 3], ["[[0, 330], [1, 45], [2, 26], [3, 14], [7, 6], [6, 5], [4, 5], [12, 3], [8, 3], [...", 3], ["[[\"b''\", 1]]", 3], ["[[\"None\", 479]]", 3], ["[[\"None\", 326]]", 3], ["[[\"None\", 1827]]", 3]] [["[[9599, 108], [53015001, 13], [38107867, 7], [5802411, 7], [55949623, 5], [44060...", 1], ["[[9599, 1363], [45057, 26], [27856297, 22], [82988, 16], [3243482, 14], [192568,...", 1], ["[[9599, 141], [27856297, 21], [45057, 19], [49699333, 7], [3243482, 7], [2657547...", 1], ["[[9599, 15], [78035, 2], [50527, 2], [49260, 2], [32314, 1], [21148, 1], [19921,...", 1], ["[[9599, 1]]", 1], ["[[9599, 2139], [19864447, 519], [\"None\", 8], [21148, 6], [45057, 5]]", 1], ["[[9599, 2526], [45057, 20], [27856297, 17], [\"None\", 8], [49699333, 6], [21148, ...", 1], ["[[9599, 25]]", 1], ["[[9599, 264]]", 1], ["[[9599, 5063], [22429695, 80], [45057, 39], [82988, 27], [3243482, 24], [30607, ...", 1]]
_analyze_tables_ num_blank 330 0 0 10 [[0, 316], [92, 2], [52, 2], [32, 2], [15, 2], [8, 2], [6221, 1], [479, 1], [86, 1], [78, 1]]  
_analyze_tables_ num_distinct 330 0 0 102 [[1, 64], [2, 17], [11, 14], [3, 12], [326, 10], [6221, 9], [479, 7], [25, 7], [10, 7], [0, 6]] [[1230, 1], [1311, 1], [1404, 1], [1747, 1], [1757, 1], [1766, 1], [1799, 1], [2589, 1], [5830, 1], [6566, 1]]
_analyze_tables_ num_null 330 0 0 34 [[0, 286], [357, 4], [1827, 2], [469, 2], [326, 2], [139, 2], [36, 2], [14, 2], [8, 2], [1, 2]] [[281, 1], [300, 1], [304, 1], [324, 1], [382, 1], [392, 1], [1399, 1], [1501, 1], [1810, 1], [5789, 1]]
_analyze_tables_ table 330 0 0 73 [["repos", 43], ["pull_requests", 23], ["issues", 20], ["milestones", 15], ["assets", 14], ["releases", 13], ["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 330 0 0 35 [[479, 47], [1, 43], [326, 27], [1827, 24], [25, 19], [264, 17], [5789, 15], [6221, 13], [2677, 12], [83, 11]] [[30, 2], [33, 2], [50, 2], [52, 2], [226, 2], [368, 2], [1917, 2], [602, 3], [1799, 3], [6569, 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 [[31, 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 2677 8 0 71 [[9599, 2526], [45057, 20], [27856297, 17], ["None", 8], [49699333, 6], [21148, 6], [3243482, 5], [2657547, 5], [198537, 5], [50527, 3]] [[13896256, 1], [15278512, 1], [17075617, 1], [22578954, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [41546558, 1], [56323389, 1]]
commits author_date 2677 0 0 2677    
commits committer 2677 8 0 4 [[9599, 2139], [19864447, 519], ["None", 8], [21148, 6], [45057, 5]]  
commits committer_date 2677 0 0 2589 [["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]] [["2021-06-03T04:45:03Z", 1], ["2021-06-03T05:16:33Z", 1], ["2021-06-05T18:59:54Z", 1], ["2021-06-05T19:48:51Z", 1], ["2021-06-05T20:18:37Z", 1], ["2021-06-05T22:03:38Z", 1], ["2021-06-05T22:06:55Z", 1], ["2021-06-05T22:55:07Z", 1], ["2021-06-05T23:02:03Z", 1], ["2021-06-06T22:07:45Z", 1]]
commits message 2677 0 0 2593 [["Applied Black", 9], ["Updated README", 8], ["Typo fix", 8], ["Release 0.2", 8], ["Fixed typo", 7], ["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 2677 0 0 77 [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2297], ["2946d096d0cdefdc017559e6b57e87658736e843", 229], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 20], ["2edd38cb3801aa07f709f083eba7cbe4f16e0978", 17], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["5df307d91b1167b0aa175853783d760add239497", 6], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["b90d9715d7c0881515e9d6aa98923ed89d445945", 5], ["106fe7fbf8b80a01038e265a137b3b703422db48", 4], ["207bb2132044fa5a4fe28a579f7588c2eee6e391", 3]] [["d151532d3a398e1acd965596193c7d4c7c0475ff", 1], ["d6a64a7ba2d6c2c36f86efe56eb62e19518bfd72", 1], ["d9a1cca675e8697c10ac5f4cbceac5ea7dc2a906", 1], ["daa0836007170071f748b575d34c4432f4f43926", 1], ["eab1e8f71bd05f2ff2163f024127cc28876dd05d", 1], ["f25304fb12f6d6fab36f551427610ed8e96f0c2f", 1], ["f2f4d10a554519ea00fb44a5f6377123c59e1f22", 1], ["f3dfe1c3cf166dd0b9b8860a25045107a068c5df", 1], ["f85fb7898f36734a83fd9c8a2c2e96c751920c35", 1], ["fcf3b31d4679bb2112170ec4dda53dede33a16b3", 1]]
commits raw_committer 2677 0 0 6 [["13ae486343ea6454a93114c6f558ffea2f2c6874", 1892], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 519], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]]  
commits repo 2677 0 0 15 [[107914493, 1662], [140912432, 507], [207052882, 161], [206156866, 120], [197431109, 58], [256834907, 40], [205429375, 33], [197882382, 28], [303218369, 16], [248903544, 13]] [[209590345, 1], [206649770, 6], [206202864, 10], [213286752, 10], [214746582, 12], [248903544, 13], [303218369, 16], [197882382, 28], [205429375, 33], [256834907, 40]]
commits sha 2677 0 0 2677    
commits_fts message 2677 0 0 2593 [["Applied Black", 9], ["Updated README", 8], ["Typo fix", 8], ["Release 0.2", 8], ["Fixed typo", 7], ["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 33 0 0 33    
commits_fts_data id 33 0 0 33    
commits_fts_docsize id 2677 0 0 2677    
commits_fts_docsize sz 2677 0 0 109 [["b'\\x07'", 334], ["b'\\x08'", 313], ["b'\\x06'", 293], ["b'\\t'", 246], ["b'\\x05'", 225], ["b'\\x03'", 171], ["b'\\n'", 164], ["b'\\x04'", 159], ["b'\\x0b'", 90], ["b'\\x02'", 76]] [["b'\\x81&'", 1], ["b'\\x81,'", 1], ["b'\\x819'", 1], ["b'\\x81>'", 1], ["b'\\x81?'", 1], ["b'\\x81['", 1], ["b'\\x81\\\\'", 1], ["b'\\x81\\x14'", 1], ["b'\\x81\\x1b'", 1], ["b'\\x81h'", 1]]
commits_fts_idx pgno 31 0 0 31    
commits_fts_idx segid 31 0 0 1 [[1, 31]]  
commits_fts_idx term 31 0 0 31    
contributors contributions 89 0 0 19 [[1, 58], [2, 7], [10, 3], [6, 3], [3, 3], [5, 2], [17, 1], [15, 1], [13, 1], [4, 1]] [[17, 1], [20, 1], [28, 1], [31, 1], [39, 1], [58, 1], [119, 1], [151, 1], [490, 1], [1545, 1]]
contributors repo_id 89 0 0 15 [[107914493, 52], [140912432, 15], [207052882, 4], [214746582, 3], [205429375, 3], [303218369, 2], [256834907, 2], [206156866, 1], [197882382, 1], [197431109, 1]] [[197431109, 1], [197882382, 1], [206156866, 1], [206202864, 1], [206649770, 1], [209590345, 1], [213286752, 1], [248903544, 1], [256834907, 2], [303218369, 2]]
contributors user_id 89 0 0 72 [[9599, 15], [78035, 2], [50527, 2], [49260, 2], [32314, 1], [21148, 1], [19921, 1], [15543, 1], [15092, 1], [3637, 1]] [[17075617, 1], [22578954, 1], [27856297, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [41546558, 1], [49699333, 1], [56323389, 1]]
dependents dependent 602 0 0 478 [[193603180, 2], [164026920, 2], [150847142, 2], [149112525, 2], [112050382, 2], [99911706, 2], [79072630, 2], [51720846, 2], [51665750, 2], [5832996, 2]] [[365612162, 1], [367518851, 1], [367750312, 1], [368044233, 1], [368160106, 1], [368375149, 1], [370695978, 1], [372671253, 1], [373233288, 1], [373813826, 1]]
dependents first_seen_utc 602 0 0 602    
dependents repo 602 0 0 2 [[107914493, 307], [140912432, 295]]  
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 5789 0 0 4 [["OWNER", 4602], ["NONE", 493], ["MEMBER", 461], ["CONTRIBUTOR", 233]]  
issue_comments body 5789 0 0 5732 [["Thanks!", 18], ["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]] [["well, I succeeded to make uvicorn work.", 1], ["would be nice to have ", 1], ["wow, thanks a lot @simonw , problem is solved. I converted my current json file ...", 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 5789 0 0 5788 [["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]] [["2021-06-06T15:41:24Z", 1], ["2021-06-06T15:42:55Z", 1], ["2021-06-06T16:38:04Z", 1], ["2021-06-06T16:39:34Z", 1], ["2021-06-06T16:41:30Z", 1], ["2021-06-06T16:46:17Z", 1], ["2021-06-06T16:53:20Z", 1], ["2021-06-06T16:55:33Z", 1], ["2021-06-06T16:59:05Z", 1], ["2021-06-06T17:07:48Z", 1]]
issue_comments html_url 5789 0 0 5789    
issue_comments id 5789 0 0 5789    
issue_comments issue 5789 0 0 1481 [[712260429, 47], [627794879, 46], [824064069, 45], [324188953, 42], [582526961, 40], [681375466, 33], [770436876, 32], [309471814, 31], [608058890, 28], [323681589, 27]] [[894948100, 1], [895315478, 1], [899851083, 1], [901009787, 1], [903200328, 1], [906993731, 1], [908276134, 1], [908465747, 1], [910088936, 1], [912394511, 1]]
issue_comments issue_url 5789 0 0 1481 [["https://api.github.com/repos/simonw/datasette/issues/983", 47], ["https://api.github.com/repos/simonw/datasette/issues/782", 46], ["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/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/266", 27]] [["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 5789 0 0 5789    
issue_comments performed_via_github_app 5789 5789 0 0 [["None", 5789]]  
issue_comments reactions 5789 0 0 14 [["{\"total_count\": 0, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 5608], ["{\"total_count\": 1, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 114], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 1, \"confused\": 0, \"he...", 21], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 17], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 7], ["{\"total_count\": 2, \"+1\": 2, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 5], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 4], ["{\"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\": 0, \"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\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 4, \"+1\": 3, \"-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\": 3, \"+1\": 3, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"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\": 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...", 5], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 7]]
issue_comments updated_at 5789 0 0 5788 [["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]] [["2021-06-06T15:41:24Z", 1], ["2021-06-06T15:42:55Z", 1], ["2021-06-06T16:38:04Z", 1], ["2021-06-06T16:39:34Z", 1], ["2021-06-06T16:44:49Z", 1], ["2021-06-06T16:46:17Z", 1], ["2021-06-06T16:53:20Z", 1], ["2021-06-06T16:55:33Z", 1], ["2021-06-06T17:00:15Z", 1], ["2021-06-06T17:07:48Z", 1]]
issue_comments user 5789 0 0 210 [[9599, 5063], [22429695, 80], [45057, 39], [82988, 27], [3243482, 24], [30607, 19], [7936571, 18], [222245, 14], [192568, 14], [21148, 14]] [[26292069, 1], [26342344, 1], [29426418, 1], [32467826, 1], [32605365, 1], [39538958, 1], [45919695, 1], [49699333, 1], [52261150, 1], [63653929, 1]]
issue_comments_fts body 5789 0 0 5732 [["Thanks!", 18], ["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]] [["well, I succeeded to make uvicorn work.", 1], ["would be nice to have ", 1], ["wow, thanks a lot @simonw , problem is solved. I converted my current json file ...", 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 368 0 0 368    
issue_comments_fts_data id 368 0 0 368    
issue_comments_fts_docsize id 5789 0 0 5789    
issue_comments_fts_docsize sz 5789 0 0 354 [["b'\\x0f'", 142], ["b'\\x12'", 133], ["b'\\x0c'", 125], ["b'\\x10'", 124], ["b'\\x0e'", 122], ["b'\\r'", 105], ["b'\\x16'", 104], ["b'\\x11'", 104], ["b'\\x19'", 103], ["b'\\x13'", 103]] [["b'\\x85q'", 1], ["b'\\x87a'", 1], ["b'\\x87|'", 1], ["b'\\x89?'", 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 490 0 0 125 [[20, 6], [18, 6], [16, 6], [14, 6], [12, 6], [10, 6], [8, 6], [6, 6], [4, 6], [2, 6]] [[236, 1], [238, 1], [240, 1], [244, 1], [246, 1], [248, 1], [250, 1], [252, 1], [254, 1], [256, 1]]
issue_comments_fts_idx segid 490 0 0 6 [[5, 120], [1, 86], [3, 84], [4, 83], [2, 79], [6, 38]]  
issue_comments_fts_idx term 490 0 0 440 [["b''", 6], ["b'0thea'", 4], ["b'0a0'", 4], ["b'010'", 4], ["b'0tod'", 3], ["b'0off'", 3], ["b'0datasettea'", 3], ["b'0admini'", 2], ["b'030'", 2], ["b'020'", 2]] [["b'0\\xf0'", 1], ["b'0whene'", 1], ["b'0wherea'", 1], ["b'0windows'", 1], ["b'0wishe'", 1], ["b'0worka'", 1], ["b'0wouldn'", 1], ["b'0wra'", 1], ["b'0zgf0yxnldhrll3'", 1], ["b'0zwellf'", 1]]
issues active_lock_reason 1827 1827 0 0 [["None", 1827]]  
issues assignee 1827 1810 0 1 [["None", 1827]]  
issues author_association 1827 0 0 6 [["OWNER", 1176], ["NONE", 226], ["CONTRIBUTOR", 214], ["MEMBER", 187], ["FIRST_TIME_CONTRIBUTOR", 21], ["FIRST_TIMER", 3]]  
issues body 1827 0 92 1733 [["", 92], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], [" $ datasette package ~/parlgov-db/parlgov.db --metadata=~/parlgov-db/parlgov....", 1], ["\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]] [["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β€”I think it matches your style i...", 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], ["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]]
issues closed_at 1827 382 0 1404 [["None", 382], ["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]] [["2021-06-03T04:34:38Z", 1], ["2021-06-03T05:12:21Z", 1], ["2021-06-05T18:59:54Z", 1], ["2021-06-05T18:59:55Z", 1], ["2021-06-05T19:48:51Z", 1], ["2021-06-05T20:18:46Z", 1], ["2021-06-05T22:20:07Z", 1], ["2021-06-05T22:22:06Z", 1], ["2021-06-05T23:16:24Z", 1], ["2021-06-06T22:07:50Z", 1]]
issues comments 1827 0 0 37 [[1, 456], [0, 346], [2, 304], [3, 234], [4, 118], [5, 78], [6, 62], [7, 41], [8, 39], [9, 30]] [[25, 1], [28, 1], [31, 1], [32, 1], [33, 1], [40, 1], [42, 1], [45, 1], [46, 1], [47, 1]]
issues created_at 1827 0 0 1827    
issues id 1827 0 0 1827    
issues locked 1827 0 0 1 [[0, 1827]]  
issues milestone 1827 1399 0 25 [["None", 1399], [6026070, 53], [2857392, 49], [3268330, 48], [5512395, 39], [5533512, 25], [4305096, 22], [5971510, 21], [2949431, 21], [6346396, 20]] [[5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414, 5], [3439337, 7], [5225818, 7], [6079500, 7], [5234079, 8], [5897911, 8]]
issues node_id 1827 0 0 1827    
issues number 1827 0 0 1311 [[1, 14], [2, 13], [6, 12], [5, 12], [4, 12], [3, 12], [9, 10], [8, 10], [7, 10], [10, 9]] [[1354, 1], [1355, 1], [1356, 1], [1357, 1], [1358, 1], [1359, 1], [1360, 1], [1361, 1], [1362, 1], [1364, 1]]
issues performed_via_github_app 1827 1827 0 0 [["None", 1827]]  
issues pull_request 1827 1501 0 326 [["None", 1501], ["dogsheep/evernote-to-sqlite/pulls/10", 1], ["dogsheep/dogsheep.github.io/pulls/6", 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 1827 0 0 14 [[107914493, 1310], [140912432, 265], [207052882, 63], [206156866, 57], [256834907, 35], [197431109, 32], [197882382, 18], [303218369, 12], [205429375, 11], [213286752, 9]] [[248903544, 1], [209590345, 2], [206649770, 6], [214746582, 6], [213286752, 9], [205429375, 11], [303218369, 12], [197882382, 18], [197431109, 32], [256834907, 35]]
issues state 1827 0 0 2 [["closed", 1445], ["open", 382]]  
issues title 1827 0 0 1822 [["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], ["\"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], [" /usr/local/opt/python3/bin/python3.6: bad interpreter: No such file or director...", 1], [" /-/permissions debugging tool", 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], ["v0.54 500 error from sql query in custom template; code worked in v0.53; found a...", 1], ["view_name = \"query\" for the query page", 1], ["{\"$file\": ...} mechanism is broken", 1], ["{{ csrftoken() }} doesn't work with datasette.render_template()", 1]]
issues type 1827 0 0 2 [["issue", 1501], ["pull", 326]]  
issues updated_at 1827 0 0 1766 [["2019-05-29T21:39:12Z", 7], ["2018-07-24T04:53:20Z", 6], ["2020-10-23T19:44:06Z", 4], ["2020-09-30T20:36:12Z", 4], ["2020-11-28T23:26:33Z", 3], ["2020-10-23T19:44:05Z", 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]] [["2021-06-05T19:06:06Z", 1], ["2021-06-05T19:48:51Z", 1], ["2021-06-05T20:18:46Z", 1], ["2021-06-05T22:20:07Z", 1], ["2021-06-05T22:23:23Z", 1], ["2021-06-05T23:16:24Z", 1], ["2021-06-06T09:40:18Z", 1], ["2021-06-06T11:25:39Z", 1], ["2021-06-06T17:07:49Z", 1], ["2021-06-06T22:07:50Z", 1]]
issues user 1827 0 0 226 [[9599, 1363], [45057, 26], [27856297, 22], [82988, 16], [3243482, 14], [192568, 12], [649467, 11], [2181410, 10], [2657547, 7], [30607, 7]] [[39452697, 1], [39538958, 1], [42315895, 1], [42387931, 1], [50578294, 1], [50906992, 1], [55480210, 1], [56323389, 1], [58088336, 1], [82332573, 1]]
issues_fts body 1827 0 92 1733 [["", 92], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], [" $ datasette package ~/parlgov-db/parlgov.db --metadata=~/parlgov-db/parlgov....", 1], ["\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]] [["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β€”I think it matches your style i...", 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], ["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]]
issues_fts title 1827 0 0 1822 [["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], ["\"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], [" /usr/local/opt/python3/bin/python3.6: bad interpreter: No such file or director...", 1], [" /-/permissions debugging tool", 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], ["v0.54 500 error from sql query in custom template; code worked in v0.53; found a...", 1], ["view_name = \"query\" for the query page", 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 226 0 0 226    
issues_fts_data id 226 0 0 226    
issues_fts_docsize id 1827 0 0 1827    
issues_fts_docsize sz 1827 0 0 1057 [["b'\\x07\\x00'", 17], ["b'\\x04\\x00'", 13], ["b'\\x06\\x00'", 12], ["b'\\x08\\x02'", 11], ["b'\\x07\\x02'", 11], ["b'\\x05\\x00'", 11], ["b'\\t\\x00'", 10], ["b'\\x05\\x02'", 9], ["b'\\x04\\x02'", 8], ["b'\\x03\\x00'", 8]] [["b'\\x11\\x8a\\r'", 1], ["b'\\x11\\x8ax'", 1], ["b'\\x12\\x825'", 1], ["b'\\x13\\x82\\x01'", 1], ["b'\\x14\\x00'", 1], ["b'\\x14\\x81e'", 1], ["b'\\x14o'", 1], ["b'\\x14z'", 1], ["b'\\x15g'", 1], ["b'\\x16\\x06'", 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])
);