home / github

Menu
  • GraphQL API

_analyze_tables_

Table actions
  • GraphQL API for _analyze_tables_

348 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: num_blank

Link table column total_rows num_null num_blank num_distinct most_common least_common
_analyze_tables_,column _analyze_tables_ column 348 0 0 151 [["id", 33], ["name", 17], ["repo", 11], ["term", 10], ["sz", 10], ["segid", 10], ["pgno", 10], ["node_id", 10], ["k", 10], ["block", 10]] [["uploader", 1], ["use_squash_pr_title_as_default", 1], ["user_id", 1], ["uses", 1], ["visibility", 1], ["watchers", 1], ["watchers_count", 1], ["web_commit_signoff_required", 1], ["with", 1], ["workflow", 1]]
_analyze_tables_,least_common _analyze_tables_ least_common 348 210 0 119 [["None", 210], ["[[149, 1], [157, 1], [183, 1], [242, 1], [355, 1], [1006, 1], [1057, 1], [1062, ...", 3], ["[[\"release\", 1], [\"search\", 1], [\"security\", 1], [\"small\", 1], [\"support\", 1], [...", 2], ["[[\"ref #46 \\r\\n\\r\\nIssues don't have merge information on them, which means that...", 2], ["[[\"https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2\", 1], [\"htt...", 2], ["[[\"Datasette 0.52\", 1], [\"Datasette 0.54\", 1], [\"Datasette 0.60\", 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.29\", 1], [\"3.3\", 1], [\"3.4\", 1], [\"3.4.1\", 1], [\"3.5\", 1], [\"3.6\", 1], [\"3....", 2]] [["[[550217294, 1], [550276452, 1], [550293655, 1], [550725244, 1], [552033492, 1],...", 1], ["[[56323389, 1], [57161638, 1], [57859326, 1], [69208826, 1], [76450761, 1], [823...", 1], ["[[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], ["[[768429, 1], [768432, 1], [771971, 1], [773714, 1], [774252, 1], [775505, 1], [...", 1], ["[[771, 1], [783, 1], [847, 1], [862, 1], [884, 1], [887, 1], [1030, 1], [2026, 1...", 1], ["[[84056280, 1], [85930339, 1], [86156616, 1], [91842948, 1], [92047518, 1], [940...", 1], ["[[9, 1], [10, 1], [14, 1], [16, 1], [23, 1], [56, 1], [94, 1], [97, 1], [154, 1]...", 1], ["[[947465681, 1], [1382668283, 1], [1918831023, 1], [2092302176, 1], [2157112227,...", 1], ["[[99098079, 1], [103377744, 1], [103442318, 1], [105030229, 1], [105149923, 1], ...", 1]]
_analyze_tables_,most_common _analyze_tables_ most_common 348 86 0 203 [["None", 86], ["[[\"None\", 919]]", 12], ["[[4, 1]]", 10], ["[[\"version\", 1]]", 10], ["[[2, 1]]", 3], ["[[1, 1]]", 3], ["[[0, 678], [1, 85], [2, 35], [3, 22], [7, 9], [5, 9], [4, 9], [6, 8], [12, 5], [...", 3], ["[[\"b''\", 1]]", 3], ["[[\"None\", 486]]", 3], ["[[\"None\", 2562]]", 3]] [["[[9599, 167], [53015001, 13], [25778, 13], [44060760, 11], [5802411, 9], [381078...", 1], ["[[9599, 1805], [49699333, 50], [536941, 26], [45057, 26], [27856297, 22], [82988...", 1], ["[[9599, 181], [49699333, 50], [27856297, 21], [45057, 19], [3243482, 7], [265754...", 1], ["[[9599, 1]]", 1], ["[[9599, 2704], [19864447, 768], [\"None\", 8], [21148, 6], [45057, 5]]", 1], ["[[9599, 30]]", 1], ["[[9599, 325]]", 1], ["[[9599, 3266], [49699333, 40], [45057, 20], [27856297, 17], [\"None\", 8], [21148,...", 1], ["[[9599, 7411], [22429695, 171], [536941, 65], [25778, 55], [45057, 39], [82988, ...", 1], ["[[971057476, 3], [853484980, 2], [817257851, 2], [804924636, 2], [700944644, 2],...", 1]]
_analyze_tables_,num_blank _analyze_tables_ num_blank 348 0 0 10 [[0, 334], [99, 2], [54, 2], [44, 2], [19, 2], [8, 2], [8601, 1], [919, 1], [182, 1], [107, 1]]  
_analyze_tables_,num_distinct _analyze_tables_ num_distinct 348 0 0 115 [[1, 71], [2, 25], [8601, 9], [14, 9], [3, 9], [486, 7], [30, 6], [13, 6], [5, 6], [0, 6]] [[1774, 1], [1801, 1], [1831, 1], [1874, 1], [1898, 1], [2459, 1], [2560, 1], [3489, 1], [7916, 1], [9176, 1]]
_analyze_tables_,num_null _analyze_tables_ num_null 348 0 0 51 [[0, 281], [893, 4], [738, 4], [1, 3], [486, 2], [302, 2], [14, 2], [9, 2], [8, 2], [6, 2]] [[771, 1], [783, 1], [847, 1], [862, 1], [884, 1], [887, 1], [1030, 1], [2026, 1], [2543, 1], [8630, 1]]
_analyze_tables_,table _analyze_tables_ table 348 0 0 73 [["repos", 55], ["pull_requests", 23], ["issues", 23], ["milestones", 15], ["releases", 14], ["assets", 14], ["issue_comments", 12], ["steps", 10], ["users", 9], ["commits", 9]] [["commits_fts", 1], ["issue_comments_fts", 1], ["licenses_fts", 1], ["repos_fts_config", 2], ["repos_fts_data", 2], ["repos_fts_docsize", 2], ["users_fts", 2], ["users_fts_config", 2], ["users_fts_data", 2], ["users_fts_docsize", 2]]
_analyze_tables_,total_rows _analyze_tables_ total_rows 348 0 0 36 [[919, 59], [1, 43], [2562, 27], [486, 27], [30, 19], [325, 18], [8630, 15], [98, 14], [8601, 13], [3491, 12]] [[19, 2], [42, 2], [43, 2], [101, 2], [125, 2], [360, 2], [580, 2], [2857, 2], [1874, 3], [9180, 3]]
assets,browser_download_url assets browser_download_url 1 0 0 1 [["https://github.com/simonw/datasette/releases/download/0.53/datasette-0.53-macos-...", 1]]  
assets,content_type assets content_type 1 0 0 1 [["application/zip", 1]]  
assets,created_at assets created_at 1 0 0 1 [["2021-01-04T21:26:30Z", 1]]  
assets,download_count assets download_count 1 0 0 1 [[39, 1]]  
assets,id assets id 1 0 0 1 [[30264367, 1]]  
assets,label assets label 1 1 0 0 [["None", 1]]  
assets,name assets name 1 0 0 1 [["datasette-0.53-macos-binary.zip", 1]]  
assets,node_id assets node_id 1 0 0 1 [["MDEyOlJlbGVhc2VBc3NldDMwMjY0MzY3", 1]]  
assets,release assets release 1 0 0 1 [[35131848, 1]]  
assets,size assets size 1 0 0 1 [[8297283, 1]]  
assets,state assets state 1 0 0 1 [["uploaded", 1]]  
assets,updated_at assets updated_at 1 0 0 1 [["2021-01-04T21:26:43Z", 1]]  
assets,uploader assets uploader 1 0 0 1 [[9599, 1]]  
assets,url assets url 1 0 0 1 [["https://api.github.com/repos/simonw/datasette/releases/assets/30264367", 1]]  
commits,author commits author 3491 8 0 100 [[9599, 3266], [49699333, 40], [45057, 20], [27856297, 17], ["None", 8], [21148, 7], [198537, 6], [3243482, 5], [2657547, 5], [25778, 5]] [[16001974, 1], [17075617, 1], [22578954, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [56323389, 1], [72577720, 1], [99098079, 1]]
commits,author_date commits author_date 3491 0 0 3489 [["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-10-13T21:51:59Z", 1], ["2022-10-14T19:56:48Z", 1], ["2022-10-18T18:00:25Z", 1], ["2022-10-18T18:08:34Z", 1], ["2022-10-18T18:16:43Z", 1], ["2022-10-23T22:13:02Z", 1], ["2022-10-24T02:11:33Z", 1], ["2022-10-24T02:42:30Z", 1], ["2022-10-24T03:07:09Z", 1], ["2022-10-24T03:14:49Z", 1]]
commits,committer commits committer 3491 8 0 4 [[9599, 2704], [19864447, 768], ["None", 8], [21148, 6], [45057, 5]]  
commits,committer_date commits committer_date 3491 0 0 3389 [["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-10-13T21:51:59Z", 1], ["2022-10-14T19:57:00Z", 1], ["2022-10-18T18:00:35Z", 1], ["2022-10-18T18:08:34Z", 1], ["2022-10-18T18:16:43Z", 1], ["2022-10-23T22:17:33Z", 1], ["2022-10-24T02:11:33Z", 1], ["2022-10-24T02:42:30Z", 1], ["2022-10-24T03:07:09Z", 1], ["2022-10-24T03:14:49Z", 1]]
commits,message commits message 3491 0 0 3389 [["Fixed typo", 11], ["Applied Black", 11], ["Typo fix", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 6], ["Release 0.4", 4], ["Release 0.3", 4], ["Fixed typo in release notes", 4], ["Changelog badge", 4]] [["view-instance permission for debug URLs, closes #833", 1], ["where= and where_args= parameters to search() and search_sql()\n\nCloses #441", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["will, not may - refs #468", 1], ["word-break: break-word;", 1], ["word-wrap: anywhere on links in cells, refs #1805", 1], ["workflow_dispatch", 1], ["x button for clearing filters, refs #1016", 1], ["xfail documentation unit tests for view classes, refs #299\n\nMore documentation u...", 1], ["© 2017-2021", 1]]
commits,raw_author commits raw_author 3491 0 0 106 [["13ae486343ea6454a93114c6f558ffea2f2c6874", 3037], ["2946d096d0cdefdc017559e6b57e87658736e843", 229], ["5df307d91b1167b0aa175853783d760add239497", 40], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 20], ["2edd38cb3801aa07f709f083eba7cbe4f16e0978", 17], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 7], ["b90d9715d7c0881515e9d6aa98923ed89d445945", 5], ["90786fb02407ad60f10210c0592ee711a9a36fae", 5], ["106fe7fbf8b80a01038e265a137b3b703422db48", 5]] [["d9a1cca675e8697c10ac5f4cbceac5ea7dc2a906", 1], ["daa0836007170071f748b575d34c4432f4f43926", 1], ["ddda3e8cc5167e6bdbab6819a1f4e8e2621f4e89", 1], ["e7784035c9ce3ef64d906c543907d5025673d054", 1], ["eab1e8f71bd05f2ff2163f024127cc28876dd05d", 1], ["f25304fb12f6d6fab36f551427610ed8e96f0c2f", 1], ["f2f4d10a554519ea00fb44a5f6377123c59e1f22", 1], ["f3dfe1c3cf166dd0b9b8860a25045107a068c5df", 1], ["f85fb7898f36734a83fd9c8a2c2e96c751920c35", 1], ["fcf3b31d4679bb2112170ec4dda53dede33a16b3", 1]]
commits,raw_committer commits raw_committer 3491 0 0 6 [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2457], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 768], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]]  
commits,repo commits repo 3491 0 0 15 [[107914493, 2105], [140912432, 843], [207052882, 170], [206156866, 132], [197431109, 61], [256834907, 41], [205429375, 33], [197882382, 30], [303218369, 19], [213286752, 15]] [[209590345, 1], [206649770, 6], [206202864, 10], [214746582, 12], [248903544, 13], [213286752, 15], [303218369, 19], [197882382, 30], [205429375, 33], [256834907, 41]]
commits,sha commits sha 3491 0 0 3491    
commits_fts,message commits_fts message 3491 0 0 3389 [["Fixed typo", 11], ["Applied Black", 11], ["Typo fix", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 6], ["Release 0.4", 4], ["Release 0.3", 4], ["Fixed typo in release notes", 4], ["Changelog badge", 4]] [["view-instance permission for debug URLs, closes #833", 1], ["where= and where_args= parameters to search() and search_sql()\n\nCloses #441", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["will, not may - refs #468", 1], ["word-break: break-word;", 1], ["word-wrap: anywhere on links in cells, refs #1805", 1], ["workflow_dispatch", 1], ["x button for clearing filters, refs #1016", 1], ["xfail documentation unit tests for view classes, refs #299\n\nMore documentation u...", 1], ["© 2017-2021", 1]]
commits_fts_config,k commits_fts_config k 1 0 0 1 [["version", 1]]  
commits_fts_config,v commits_fts_config v 1 0 0 1 [[4, 1]]  
commits_fts_data,block commits_fts_data block 42 0 0 42    
commits_fts_data,id commits_fts_data id 42 0 0 42    
commits_fts_docsize,id commits_fts_docsize id 3491 0 0 3491    
commits_fts_docsize,sz commits_fts_docsize sz 3491 0 0 121 [["b'\\x07'", 443], ["b'\\x08'", 403], ["b'\\x06'", 391], ["b'\\t'", 342], ["b'\\x05'", 291], ["b'\\n'", 213], ["b'\\x04'", 198], ["b'\\x03'", 187], ["b'\\x0b'", 141], ["b'\\x0c'", 101]] [["b'\\x81&'", 1], ["b'\\x81,'", 1], ["b'\\x812'", 1], ["b'\\x819'", 1], ["b'\\x81>'", 1], ["b'\\x81?'", 1], ["b'\\x81['", 1], ["b'\\x81\\\\'", 1], ["b'\\x81h'", 1], ["b'\\x82\\x14'", 1]]
commits_fts_idx,pgno commits_fts_idx pgno 40 0 0 40    
commits_fts_idx,segid commits_fts_idx segid 40 0 0 1 [[1, 40]]  
commits_fts_idx,term commits_fts_idx term 40 0 0 40    
contributors,contributions contributors contributions 123 0 0 19 [[1, 88], [2, 10], [3, 4], [5, 3], [40, 2], [10, 2], [6, 2], [17, 1], [14, 1], [13, 1]] [[17, 1], [18, 1], [20, 1], [30, 1], [31, 1], [61, 1], [128, 1], [159, 1], [812, 1], [1933, 1]]
contributors,repo_id contributors repo_id 123 0 0 15 [[107914493, 69], [140912432, 27], [207052882, 5], [206156866, 4], [214746582, 3], [205429375, 3], [303218369, 2], [256834907, 2], [213286752, 2], [197431109, 1]] [[197431109, 1], [197882382, 1], [206202864, 1], [206649770, 1], [209590345, 1], [248903544, 1], [213286752, 2], [256834907, 2], [303218369, 2], [214746582, 3]]
contributors,user_id contributors user_id 123 0 0 101 [[9599, 15], [41546558, 2], [536941, 2], [244656, 2], [78035, 2], [50527, 2], [49260, 2], [25778, 2], [21148, 2], [2182, 1]] [[22578954, 1], [27856297, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [49699333, 1], [56323389, 1], [72577720, 1], [99098079, 1]]
dependents,dependent dependents dependent 1156 0 0 918 [[150847142, 2], [149112525, 2], [138329050, 2], [112050382, 2], [99911706, 2], [79072630, 2], [51720846, 2], [51665750, 2], [24275324, 2], [5832996, 2]] [[550217294, 1], [550276452, 1], [550293655, 1], [550725244, 1], [552033492, 1], [553123856, 1], [553417215, 1], [555079078, 1], [555810576, 1], [555992212, 1]]
dependents,first_seen_utc dependents first_seen_utc 1156 0 0 1156    
dependents,repo dependents repo 1156 0 0 2 [[140912432, 581], [107914493, 575]]  
emojis,image 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 emojis name 1874 0 0 1874    
emojis,url 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 issue_comments author_association 8630 0 0 4 [["OWNER", 6914], ["NONE", 771], ["MEMBER", 497], ["CONTRIBUTOR", 448]]  
issue_comments,body issue_comments body 8630 0 0 8549 [["Thanks!", 26], ["Tracking ticket: #1023", 5], ["Thanks for this!", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["Part of #551 ", 3], ["Part of #1105", 3], ["Just needs documentation now.", 3], ["Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-al...", 3], ["Blocked on #37", 3]] [["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], ["👋 Any update on getting this merged?\r\n\r\nAlternatively, is there a work around fo...", 1], ["👋 I'd be interested in building this out in Q1 or Q2 of 2020 if nobody has tackl...", 1], ["👍 I'd like this too! ", 1], ["🤯 this is beautiful. Thanks @simonw !", 1], ["🤷‍♂️ @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 1]]
issue_comments,created_at issue_comments created_at 8630 0 0 8629 [["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-10-24T22:29:58Z", 1], ["2022-10-24T22:35:01Z", 1], ["2022-10-24T22:54:37Z", 1], ["2022-10-24T23:07:30Z", 1], ["2022-10-24T23:16:00Z", 1], ["2022-10-24T23:25:06Z", 1], ["2022-10-24T23:25:52Z", 1], ["2022-10-24T23:27:00Z", 1], ["2022-10-24T23:29:03Z", 1], ["2022-10-25T01:42:47Z", 1]]
issue_comments,html_url issue_comments html_url 8630 0 0 8630    
issue_comments,id issue_comments id 8630 0 0 8630    
issue_comments,issue issue_comments issue 8630 0 0 2094 [[849978964, 51], [973139047, 48], [627794879, 48], [712260429, 47], [1058072543, 45], [824064069, 45], [324188953, 42], [582526961, 40], [1058896236, 34], [681375466, 33]] [[1363280254, 1], [1366423176, 1], [1366915240, 1], [1377811868, 1], [1386530156, 1], [1386734383, 1], [1387712501, 1], [1392426838, 1], [1400431789, 1], [1405196044, 1]]
issue_comments,issue_url issue_comments issue_url 8630 0 0 2094 [["https://api.github.com/repos/simonw/datasette/issues/1293", 51], ["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 issue_comments node_id 8630 0 0 8630    
issue_comments,performed_via_github_app issue_comments performed_via_github_app 8630 8630 0 0 [["None", 8630]]  
issue_comments,reactions issue_comments reactions 8630 0 0 16 [["{\"total_count\": 0, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 8343], ["{\"total_count\": 1, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 170], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 1, \"confused\": 0, \"he...", 33], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 32], ["{\"total_count\": 2, \"+1\": 2, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 12], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 11], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 7], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 6], ["{\"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\": 15, \"+1\": 7, \"-1\": 0, \"laugh\": 1, \"hooray\": 1, \"confused\": 0, \"h...", 1], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 3, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 3, \"confused\": 0, \"he...", 1], ["{\"total_count\": 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\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 6], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 7]]
issue_comments,updated_at issue_comments updated_at 8630 0 0 8629 [["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-10-24T22:30:15Z", 1], ["2022-10-24T22:35:01Z", 1], ["2022-10-24T23:07:30Z", 1], ["2022-10-24T23:12:10Z", 1], ["2022-10-24T23:16:00Z", 1], ["2022-10-24T23:25:06Z", 1], ["2022-10-24T23:25:52Z", 1], ["2022-10-24T23:27:00Z", 1], ["2022-10-24T23:29:03Z", 1], ["2022-10-25T01:42:47Z", 1]]
issue_comments,user issue_comments user 8630 0 0 315 [[9599, 7411], [22429695, 171], [536941, 65], [25778, 55], [45057, 39], [82988, 34], [3243482, 26], [192568, 20], [30607, 19], [7936571, 18]] [[37748899, 1], [39538958, 1], [43036882, 1], [49702524, 1], [52261150, 1], [60892516, 1], [63653929, 1], [76450761, 1], [95520595, 1], [102771161, 1]]
issue_comments_fts,body issue_comments_fts body 8630 0 0 8549 [["Thanks!", 26], ["Tracking ticket: #1023", 5], ["Thanks for this!", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["Part of #551 ", 3], ["Part of #1105", 3], ["Just needs documentation now.", 3], ["Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-al...", 3], ["Blocked on #37", 3]] [["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], ["👋 Any update on getting this merged?\r\n\r\nAlternatively, is there a work around fo...", 1], ["👋 I'd be interested in building this out in Q1 or Q2 of 2020 if nobody has tackl...", 1], ["👍 I'd like this too! ", 1], ["🤯 this is beautiful. Thanks @simonw !", 1], ["🤷‍♂️ @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 1]]
issue_comments_fts_config,k issue_comments_fts_config k 1 0 0 1 [["version", 1]]  
issue_comments_fts_config,v issue_comments_fts_config v 1 0 0 1 [[4, 1]]  
issue_comments_fts_data,block issue_comments_fts_data block 580 0 0 580    
issue_comments_fts_data,id issue_comments_fts_data id 580 0 0 580    
issue_comments_fts_docsize,id issue_comments_fts_docsize id 8630 0 0 8630    
issue_comments_fts_docsize,sz issue_comments_fts_docsize sz 8630 0 0 456 [["b'\\x0f'", 197], ["b'\\x12'", 191], ["b'\\x10'", 182], ["b'\\x0c'", 174], ["b'\\x0e'", 172], ["b'\\r'", 162], ["b'\\x13'", 153], ["b'\\x16'", 150], ["b'\\x11'", 141], ["b'\\x14'", 139]] [["b'\\x8a\\x0b'", 1], ["b'\\x8b\"'", 1], ["b'\\x8b5'", 1], ["b'\\x8bh'", 1], ["b'\\x8c\\x05'", 1], ["b'\\x8fK'", 1], ["b'\\x927'", 1], ["b'\\x92}'", 1], ["b'\\x9f\\\\'", 1], ["b'\\xb3.'", 1]]
issue_comments_fts_idx,pgno issue_comments_fts_idx pgno 548 0 0 289 [[16, 5], [14, 5], [12, 5], [10, 5], [8, 5], [6, 5], [4, 5], [2, 5], [20, 4], [18, 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 issue_comments_fts_idx segid 548 0 0 5 [[5, 285], [7, 87], [6, 84], [1, 84], [2, 8]]  
issue_comments_fts_idx,term issue_comments_fts_idx term 548 0 0 495 [["b''", 5], ["b'0thea'", 3], ["b'0onc'", 3], ["b'0ite'", 3], ["b'0forb'", 3], ["b'0area'", 3], ["b'0a0'", 3], ["b'0abov'", 2], ["b'0110'", 2], ["b'010'", 2]] [["b'0\\xce'", 1], ["b'0workflows'", 1], ["b'0worksp'", 1], ["b'0wouldn'", 1], ["b'0wpm'", 1], ["b'0x0'", 1], ["b'0xg'", 1], ["b'0youg'", 1], ["b'0your'", 1], ["b'0yox'", 1]]
issues,active_lock_reason issues active_lock_reason 2562 2562 0 0 [["None", 2562]]  
issues,assignee issues assignee 2562 2543 0 1 [["None", 2562]]  
issues,author_association issues author_association 2562 0 0 6 [["OWNER", 1610], ["CONTRIBUTOR", 377], ["NONE", 336], ["MEMBER", 195], ["FIRST_TIME_CONTRIBUTOR", 40], ["FIRST_TIMER", 4]]  
issues,body issues body 2562 9 99 2452 [["", 99], ["None", 9], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\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], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1]] [["ujson is already a dependency of Sanic, and should be quite a bit faster.", 1], ["uvicorn-0.8 relies on websockets-0.7 which lacks python-3.8 compatiblity", 1], ["v0.54 500 error in sql query template; code worked in v0.53; found a workaround\r...", 1], ["vegaEmbed is a LOT of code (it bundles d3)\r\n\r\nInspired by this tweet: https://tw...", 1], ["view-source:https://calands.datasettes.com/calands/CPAD_2020a_SuperUnits.geojson...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["would it be possible to:\r\n- remove uvicorn mandatory dependancy ?\r\n- eventually ...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1], ["👋 trying to upgrade the formula to use the latest release, but runs into some r...", 1], ["👋 thank you for an incredibly useful project! \r\n\r\nI have noticed that my deploye...", 1]]
issues,closed_at issues closed_at 2562 608 0 1898 [["None", 608], ["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-10-11T06:34:31Z", 1], ["2022-10-13T21:52:04Z", 1], ["2022-10-14T19:57:17Z", 1], ["2022-10-18T18:00:40Z", 1], ["2022-10-18T18:23:40Z", 1], ["2022-10-23T22:22:52Z", 1], ["2022-10-24T01:53:13Z", 1], ["2022-10-24T02:11:36Z", 1], ["2022-10-24T02:11:37Z", 1], ["2022-10-24T02:42:34Z", 1]]
issues,comments issues comments 2562 0 0 39 [[1, 647], [0, 468], [2, 404], [3, 305], [4, 184], [5, 106], [6, 91], [7, 64], [8, 49], [9, 44]] [[28, 1], [31, 1], [33, 1], [34, 1], [40, 1], [42, 1], [47, 1], [51, 1], [45, 2], [48, 2]]
issues,created_at issues created_at 2562 0 0 2562    
issues,draft issues draft 2562 2076 0 2 [["None", 2076], [0, 477], [1, 9]]  
issues,id issues id 2562 0 0 2562    
issues,locked issues locked 2562 0 0 1 [[0, 2562]]  
issues,milestone issues milestone 2562 2026 0 29 [["None", 2026], [3268330, 102], [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], [5897911, 8], [8303187, 8]]
issues,node_id issues node_id 2562 0 0 2562    
issues,number issues number 2562 0 0 1774 [[1, 15], [2, 14], [5, 13], [4, 13], [3, 13], [8, 12], [7, 12], [6, 12], [10, 11], [9, 11]] [[1842, 1], [1843, 1], [1844, 1], [1845, 1], [1847, 1], [1848, 1], [1849, 1], [1850, 1], [1851, 1], [1852, 1]]
issues,performed_via_github_app issues performed_via_github_app 2562 2562 0 0 [["None", 2562]]  
issues,pull_request issues pull_request 2562 2076 0 486 [["None", 2076], ["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/37", 1], ["dogsheep/dogsheep-photos/pulls/36", 1], ["dogsheep/dogsheep-photos/pulls/31", 1], ["dogsheep/dogsheep-photos/pulls/30", 1], ["dogsheep/dogsheep-photos/pulls/29", 1], ["dogsheep/dogsheep-beta/pulls/35", 1]] [["simonw/sqlite-utils/pulls/60", 1], ["simonw/sqlite-utils/pulls/64", 1], ["simonw/sqlite-utils/pulls/65", 1], ["simonw/sqlite-utils/pulls/67", 1], ["simonw/sqlite-utils/pulls/72", 1], ["simonw/sqlite-utils/pulls/75", 1], ["simonw/sqlite-utils/pulls/78", 1], ["simonw/sqlite-utils/pulls/80", 1], ["simonw/sqlite-utils/pulls/9", 1], ["simonw/sqlite-utils/pulls/96", 1]]
issues,reactions issues reactions 2562 2 0 2560 [["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 issues repo 2562 0 0 15 [[107914493, 1759], [140912432, 499], [207052882, 77], [206156866, 66], [256834907, 37], [197431109, 35], [197882382, 22], [303218369, 15], [205429375, 14], [206649770, 11]] [[206202864, 1], [209590345, 2], [248903544, 5], [214746582, 8], [206649770, 11], [213286752, 11], [205429375, 14], [303218369, 15], [197882382, 22], [197431109, 35]]
issues,state issues state 2562 0 0 2 [["closed", 1954], ["open", 608]]  
issues,state_reason issues state_reason 2562 1030 0 2 [["completed", 1530], ["None", 1030], ["reopened", 2]]  
issues,title issues title 2562 0 0 2549 [["Use Read the Docs action v1", 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]] [["utils.parse_metadata() should be a documented internal function", 1], ["v0.54 500 error from sql query in custom template; code worked in v0.53; found a...", 1], ["validating the sql", 1], ["view_name = \"query\" for the query page", 1], ["when hashed urls are turned on, the _memory db has improperly long-lived cache e...", 1], ["word-wrap: anywhere resulting in weird display", 1], ["xml.etree.ElementTree.Parse Error - mismatched tag", 1], ["xml.etree.ElementTree.ParseError: not well-formed (invalid token)", 1], ["{\"$file\": ...} mechanism is broken", 1], ["{{ csrftoken() }} doesn't work with datasette.render_template()", 1]]
issues,type issues type 2562 0 0 2 [["issue", 2076], ["pull", 486]]  
issues,updated_at issues updated_at 2562 0 0 2459 [["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-10-18T18:23:40Z", 1], ["2022-10-23T22:22:52Z", 1], ["2022-10-24T01:53:13Z", 1], ["2022-10-24T02:11:36Z", 1], ["2022-10-24T02:23:46Z", 1], ["2022-10-24T02:50:29Z", 1], ["2022-10-24T04:04:02Z", 1], ["2022-10-24T22:31:26Z", 1], ["2022-10-24T23:29:03Z", 1], ["2022-10-25T01:42:47Z", 1]]
issues,user issues user 2562 0 0 348 [[9599, 1805], [49699333, 50], [536941, 26], [45057, 26], [27856297, 22], [82988, 18], [192568, 15], [25778, 15], [3243482, 14], [649467, 12]] [[56323389, 1], [57161638, 1], [57859326, 1], [69208826, 1], [76450761, 1], [82332573, 1], [87192257, 1], [91880982, 1], [102635518, 1], [111973926, 1]]
issues_fts,body issues_fts body 2562 9 99 2452 [["", 99], ["None", 9], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\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], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1]] [["ujson is already a dependency of Sanic, and should be quite a bit faster.", 1], ["uvicorn-0.8 relies on websockets-0.7 which lacks python-3.8 compatiblity", 1], ["v0.54 500 error in sql query template; code worked in v0.53; found a workaround\r...", 1], ["vegaEmbed is a LOT of code (it bundles d3)\r\n\r\nInspired by this tweet: https://tw...", 1], ["view-source:https://calands.datasettes.com/calands/CPAD_2020a_SuperUnits.geojson...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["would it be possible to:\r\n- remove uvicorn mandatory dependancy ?\r\n- eventually ...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1], ["👋 trying to upgrade the formula to use the latest release, but runs into some r...", 1], ["👋 thank you for an incredibly useful project! \r\n\r\nI have noticed that my deploye...", 1]]
issues_fts,title issues_fts title 2562 0 0 2549 [["Use Read the Docs action v1", 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]] [["utils.parse_metadata() should be a documented internal function", 1], ["v0.54 500 error from sql query in custom template; code worked in v0.53; found a...", 1], ["validating the sql", 1], ["view_name = \"query\" for the query page", 1], ["when hashed urls are turned on, the _memory db has improperly long-lived cache e...", 1], ["word-wrap: anywhere resulting in weird display", 1], ["xml.etree.ElementTree.Parse Error - mismatched tag", 1], ["xml.etree.ElementTree.ParseError: not well-formed (invalid token)", 1], ["{\"$file\": ...} mechanism is broken", 1], ["{{ csrftoken() }} doesn't work with datasette.render_template()", 1]]
issues_fts_config,k issues_fts_config k 1 0 0 1 [["version", 1]]  
issues_fts_config,v issues_fts_config v 1 0 0 1 [[4, 1]]  
issues_fts_data,block issues_fts_data block 360 0 0 360    

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])
);
Powered by Datasette · Queries took 15.903ms · About: simonw/datasette-graphql