_analyze_tables_
350 rows sorted by num_null
This data as json, CSV (advanced)
Link | table | column | total_rows | num_null ▼ | num_blank | num_distinct | most_common | least_common |
---|---|---|---|---|---|---|---|---|
users,login | users | login | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
users,id | users | id | 10621 | 0 | 0 | 10621 | ||
users,node_id | users | node_id | 10621 | 0 | 0 | 10621 | ||
users,avatar_url | users | avatar_url | 10621 | 0 | 0 | 10621 | ||
users,gravatar_id | users | gravatar_id | 10621 | 0 | 10621 | 1 | [["", 10621]] | |
users,html_url | users | html_url | 10621 | 0 | 0 | 10620 | [["https://github.com/fineheard", 2], ["https://github.com/0nyr", 1], ["https://github.com/0nebody", 1], ["https://github.com/0ndrec", 1], ["https://github.com/0ihsan", 1], ["https://github.com/0asa", 1], ["https://github.com/0987031613dow", 1], ["https://github.com/03b8", 1], ["https://github.com/00mjk", 1], ["https://github.com/0-vortex", 1]] | [["https://github.com/zxygithub", 1], ["https://github.com/zy528", 1], ["https://github.com/zyuanlim", 1], ["https://github.com/zz", 1], ["https://github.com/zz0x", 1], ["https://github.com/zz2115", 1], ["https://github.com/zzeleznick", 1], ["https://github.com/zzkt", 1], ["https://github.com/zzl0", 1], ["https://github.com/zzlgreat", 1]] |
users,type | users | type | 10621 | 0 | 0 | 3 | [["User", 10489], ["Organization", 129], ["Bot", 3]] | |
users,site_admin | users | site_admin | 10621 | 0 | 0 | 2 | [[0, 10597], [1, 24]] | |
users,name | users | name | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
repos,id | repos | id | 1329 | 0 | 0 | 1329 | ||
repos,node_id | repos | node_id | 1329 | 0 | 0 | 1329 | ||
repos,name | repos | name | 1329 | 0 | 0 | 1113 | [["til", 31], ["cloud-data-quality", 31], ["datasette", 20], ["covid19-dashboard", 17], ["omspy", 10], ["devops_aula07", 9], ["cloudgoat", 9], ["calishot", 8], ["devops-aula07", 7], ["TIL", 7]] | [["yeet", 1], ["yt-fts", 1], ["yumyum", 1], ["z1007816", 1], ["zctaimpacts", 1], ["zero-server", 1], ["zeusops-attendance-analysis", 1], ["zeusops-attendance-bot", 1], ["zhaobai", 1], ["zoned-receiving", 1]] |
repos,full_name | repos | full_name | 1329 | 0 | 0 | 1329 | ||
repos,private | repos | private | 1329 | 0 | 0 | 1 | [[0, 1329]] | |
repos,owner | repos | owner | 1329 | 0 | 0 | 805 | [[9599, 193], [25778, 17], [53015001, 14], [44060760, 13], [15178711, 13], [28694175, 12], [1223, 12], [39538958, 9], [5802411, 9], [193185, 7]] | [[127496762, 1], [127565535, 1], [128680267, 1], [128963156, 1], [129124879, 1], [131779294, 1], [131845973, 1], [132527556, 1], [133026375, 1], [139249755, 1]] |
repos,html_url | repos | html_url | 1329 | 0 | 0 | 1329 | ||
repos,fork | repos | fork | 1329 | 0 | 0 | 2 | [[0, 1201], [1, 128]] | |
repos,created_at | repos | created_at | 1329 | 0 | 0 | 1329 | ||
repos,updated_at | repos | updated_at | 1329 | 0 | 0 | 1317 | [["2021-11-24T19:31:59Z", 3], ["2022-12-10T00:06:05Z", 2], ["2022-11-21T08:21:35Z", 2], ["2022-10-31T13:47:34Z", 2], ["2022-09-01T10:42:32Z", 2], ["2022-07-18T23:51:45Z", 2], ["2022-07-06T18:40:32Z", 2], ["2022-02-28T23:42:41Z", 2], ["2021-09-11T10:57:40Z", 2], ["2020-10-31T14:01:13Z", 2]] | [["2023-07-13T21:14:27Z", 1], ["2023-07-14T19:45:37Z", 1], ["2023-07-14T19:47:49Z", 1], ["2023-07-15T07:05:31Z", 1], ["2023-07-15T19:41:49Z", 1], ["2023-07-17T00:58:30Z", 1], ["2023-07-17T09:23:52Z", 1], ["2023-07-18T08:42:15Z", 1], ["2023-07-18T15:50:48Z", 1], ["2023-07-19T01:56:05Z", 1]] |
repos,pushed_at | repos | pushed_at | 1329 | 0 | 0 | 1312 | [["2019-11-08T13:36:41Z", 6], ["2022-08-18T07:41:34Z", 2], ["2022-04-23T21:22:30Z", 2], ["2022-03-02T00:48:14Z", 2], ["2022-02-28T23:42:38Z", 2], ["2021-11-10T08:58:09Z", 2], ["2021-09-26T22:32:21Z", 2], ["2021-09-11T10:57:37Z", 2], ["2020-10-31T13:33:52Z", 2], ["2019-11-09T20:10:09Z", 2]] | [["2023-07-13T19:29:56Z", 1], ["2023-07-13T21:59:01Z", 1], ["2023-07-14T00:47:11Z", 1], ["2023-07-14T01:36:21Z", 1], ["2023-07-14T17:33:52Z", 1], ["2023-07-14T18:01:50Z", 1], ["2023-07-14T21:25:15Z", 1], ["2023-07-14T23:22:55Z", 1], ["2023-07-17T01:20:34Z", 1], ["2023-07-18T10:32:23Z", 1]] |
repos,size | repos | size | 1329 | 0 | 0 | 700 | [[8, 36], [0, 36], [3, 33], [9, 28], [11, 27], [4, 25], [7, 23], [5, 23], [10, 22], [17, 17]] | [[791181, 1], [1124434, 1], [1205836, 1], [1215453, 1], [1216794, 1], [1289400, 1], [3264862, 1], [3875967, 1], [5200284, 1], [5204108, 1]] |
repos,stargazers_count | repos | stargazers_count | 1329 | 0 | 0 | 67 | [[0, 952], [1, 138], [2, 57], [3, 34], [5, 15], [4, 15], [7, 12], [6, 10], [12, 6], [8, 5]] | [[314, 1], [334, 1], [364, 1], [387, 1], [1057, 1], [1062, 1], [1230, 1], [1260, 1], [1445, 1], [7995, 1]] |
repos,watchers_count | repos | watchers_count | 1329 | 0 | 0 | 67 | [[0, 952], [1, 138], [2, 57], [3, 34], [5, 15], [4, 15], [7, 12], [6, 10], [12, 6], [8, 5]] | [[314, 1], [334, 1], [364, 1], [387, 1], [1057, 1], [1062, 1], [1230, 1], [1260, 1], [1445, 1], [7995, 1]] |
repos,has_issues | repos | has_issues | 1329 | 0 | 0 | 2 | [[1, 1185], [0, 144]] | |
repos,has_projects | repos | has_projects | 1329 | 0 | 0 | 2 | [[1, 1281], [0, 48]] | |
repos,has_downloads | repos | has_downloads | 1329 | 0 | 0 | 2 | [[1, 1328], [0, 1]] | |
repos,has_wiki | repos | has_wiki | 1329 | 0 | 0 | 2 | [[1, 1228], [0, 101]] | |
repos,has_pages | repos | has_pages | 1329 | 0 | 0 | 2 | [[0, 1277], [1, 52]] | |
repos,forks_count | repos | forks_count | 1329 | 0 | 0 | 29 | [[0, 1136], [1, 99], [2, 29], [3, 14], [6, 8], [7, 6], [4, 6], [5, 5], [11, 2], [9, 2]] | [[23, 1], [30, 1], [38, 1], [42, 1], [55, 1], [87, 1], [199, 1], [309, 1], [331, 1], [555, 1]] |
repos,archived | repos | archived | 1329 | 0 | 0 | 2 | [[0, 1324], [1, 5]] | |
repos,disabled | repos | disabled | 1329 | 0 | 0 | 1 | [[0, 1329]] | |
repos,open_issues_count | repos | open_issues_count | 1329 | 0 | 0 | 34 | [[0, 983], [1, 122], [2, 48], [3, 39], [4, 38], [5, 19], [7, 11], [6, 11], [8, 7], [11, 6]] | [[30, 1], [34, 1], [36, 1], [38, 1], [43, 1], [46, 1], [77, 1], [83, 1], [138, 1], [528, 1]] |
repos,topics | repos | topics | 1329 | 0 | 0 | 238 | [["[]", 1024], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\"]", 29], ["[\"datasette\"]", 10], ["[\"sqlite\", \"sqlite-extension\"]", 9], ["[\"datasette\", \"datasette-plugin\"]", 8], ["[\"git-scraping\"]", 5], ["[\"lexibank1\"]", 3], ["[\"datasette-io\", \"datasette-plugin\"]", 3], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\", \"plugin\"]", 3], ["[\"api\", \"legal\", \"pydantic\", \"sqlite\"]", 2]] | [["[\"resident-advisor\", \"club-nights\"]", 1], ["[\"sandbox\"]", 1], ["[\"scotrail\"]", 1], ["[\"sqlite\", \"datasette-io\", \"datasette-tool\"]", 1], ["[\"sqlite\", \"myfitnesspal\", \"datasette\", \"dogsheep\", \"datasette-io\", \"datasette-t...", 1], ["[\"things-i-learned\", \"til\"]", 1], ["[\"til\", \"today-i-learned\", \"todayilearned\"]", 1], ["[\"wip-do-not-use\"]", 1], ["[\"wookieepedia\"]", 1], ["[\"xtce\", \"yaml-configuration\"]", 1]] |
repos,forks | repos | forks | 1329 | 0 | 0 | 29 | [[0, 1136], [1, 99], [2, 29], [3, 14], [6, 8], [7, 6], [4, 6], [5, 5], [11, 2], [9, 2]] | [[23, 1], [30, 1], [38, 1], [42, 1], [55, 1], [87, 1], [199, 1], [309, 1], [331, 1], [555, 1]] |
repos,open_issues | repos | open_issues | 1329 | 0 | 0 | 34 | [[0, 983], [1, 122], [2, 48], [3, 39], [4, 38], [5, 19], [7, 11], [6, 11], [8, 7], [11, 6]] | [[30, 1], [34, 1], [36, 1], [38, 1], [43, 1], [46, 1], [77, 1], [83, 1], [138, 1], [528, 1]] |
repos,watchers | repos | watchers | 1329 | 0 | 0 | 67 | [[0, 952], [1, 138], [2, 57], [3, 34], [5, 15], [4, 15], [7, 12], [6, 10], [12, 6], [8, 5]] | [[314, 1], [334, 1], [364, 1], [387, 1], [1057, 1], [1062, 1], [1230, 1], [1260, 1], [1445, 1], [7995, 1]] |
repos,default_branch | repos | default_branch | 1329 | 0 | 0 | 10 | [["main", 811], ["master", 502], ["develop", 8], ["dev", 2], ["trunk", 1], ["test", 1], ["new_sql", 1], ["latest", 1], ["hjmain", 1], ["Main", 1]] | |
repos,permissions | repos | permissions | 1329 | 0 | 0 | 6 | [["{\"admin\": false, \"maintain\": false, \"push\": false, \"triage\": false, \"pull\": true...", 753], ["{\"admin\": false, \"push\": false, \"pull\": true}", 365], ["{\"admin\": true, \"push\": true, \"pull\": true}", 108], ["{\"admin\": true, \"maintain\": true, \"push\": true, \"triage\": true, \"pull\": true}", 100], ["{\"admin\": false, \"maintain\": false, \"push\": false, \"triage\": true, \"pull\": true}", 2], ["{\"admin\": false, \"push\": true, \"pull\": true}", 1]] | |
repos,temp_clone_token | repos | temp_clone_token | 1329 | 0 | 1329 | 1 | [["", 1329]] | |
repos,network_count | repos | network_count | 1329 | 0 | 0 | 69 | [[0, 1017], [1, 108], [2, 33], [48, 31], [3, 17], [5, 12], [4, 12], [11, 11], [6, 10], [7, 6]] | [[439, 1], [443, 1], [446, 1], [449, 1], [452, 1], [460, 1], [461, 1], [487, 1], [511, 1], [518, 1]] |
repos,subscribers_count | repos | subscribers_count | 1329 | 0 | 0 | 20 | [[1, 897], [0, 178], [2, 122], [3, 51], [4, 24], [6, 13], [5, 13], [7, 8], [8, 4], [9, 3]] | [[14, 1], [20, 1], [23, 1], [56, 1], [94, 1], [102, 1], [154, 1], [10, 3], [11, 3], [12, 3]] |
licenses,key | licenses | key | 16 | 0 | 0 | 16 | ||
licenses,name | licenses | name | 16 | 0 | 0 | 16 | ||
licenses,spdx_id | licenses | spdx_id | 16 | 0 | 0 | 16 | ||
licenses,node_id | licenses | node_id | 16 | 0 | 0 | 16 | ||
licenses_fts_data,id | licenses_fts_data | id | 3 | 0 | 0 | 3 | ||
licenses_fts_data,block | licenses_fts_data | block | 3 | 0 | 0 | 3 | ||
licenses_fts_idx,segid | licenses_fts_idx | segid | 1 | 0 | 0 | 1 | [[1, 1]] | |
licenses_fts_idx,term | licenses_fts_idx | term | 1 | 0 | 0 | 1 | [["b''", 1]] | |
licenses_fts_idx,pgno | licenses_fts_idx | pgno | 1 | 0 | 0 | 1 | [[2, 1]] | |
licenses_fts_docsize,id | licenses_fts_docsize | id | 16 | 0 | 0 | 16 | ||
licenses_fts_docsize,sz | licenses_fts_docsize | sz | 16 | 0 | 0 | 7 | [["b'\\x06'", 5], ["b'\\x07'", 3], ["b'\\x05'", 3], ["b'\\x02'", 2], ["b'\\x04'", 1], ["b'\\x01'", 1], ["b'\\n'", 1]] | |
licenses_fts_config,k | licenses_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
licenses_fts_config,v | licenses_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
repos_fts_data,id | repos_fts_data | id | 25 | 0 | 0 | 25 | ||
repos_fts_data,block | repos_fts_data | block | 25 | 0 | 0 | 25 | ||
repos_fts_idx,segid | repos_fts_idx | segid | 23 | 0 | 0 | 1 | [[1, 23]] | |
repos_fts_idx,term | repos_fts_idx | term | 23 | 0 | 0 | 23 | ||
repos_fts_idx,pgno | repos_fts_idx | pgno | 23 | 0 | 0 | 23 | ||
repos_fts_docsize,id | repos_fts_docsize | id | 1329 | 0 | 0 | 1329 | ||
repos_fts_docsize,sz | repos_fts_docsize | sz | 1329 | 0 | 0 | 112 | [["b'\\x02\\x00'", 168], ["b'\\x01\\x00'", 143], ["b'\\x03\\x00'", 92], ["b'\\x03\\x08'", 52], ["b'\\x03\\x05'", 45], ["b'\\x02\\x06'", 39], ["b'\\x03\\x07'", 37], ["b'\\x02\\x07'", 34], ["b'\\x03\\t'", 31], ["b'\\x01\\x07'", 30]] | [["b'\\x05 '", 1], ["b'\\x05\\x11'", 1], ["b'\\x05\\x13'", 1], ["b'\\x05\\x17'", 1], ["b'\\x06!'", 1], ["b'\\x06\\x00'", 1], ["b'\\x06\\x07'", 1], ["b'\\x06\\x11'", 1], ["b'\\x07\\x00'", 1], ["b'\\x07\\x0f'", 1]] |
repos_fts_config,k | repos_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
repos_fts_config,v | repos_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
users_fts_data,id | users_fts_data | id | 50 | 0 | 0 | 50 | ||
users_fts_data,block | users_fts_data | block | 50 | 0 | 0 | 50 | ||
users_fts_idx,segid | users_fts_idx | segid | 48 | 0 | 0 | 1 | [[1, 48]] | |
users_fts_idx,term | users_fts_idx | term | 48 | 0 | 0 | 48 | ||
users_fts_idx,pgno | users_fts_idx | pgno | 48 | 0 | 0 | 48 | ||
users_fts_docsize,id | users_fts_docsize | id | 10621 | 0 | 0 | 10621 | ||
users_fts_docsize,sz | users_fts_docsize | sz | 10621 | 0 | 0 | 6 | [["b'\\x01\\x01'", 9901], ["b'\\x02\\x02'", 650], ["b'\\x03\\x03'", 60], ["b'\\x04\\x04'", 6], ["b'\\x05\\x05'", 3], ["b'\\x06\\x06'", 1]] | |
users_fts_config,k | users_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
users_fts_config,v | users_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
licenses_fts,name | licenses_fts | name | 16 | 0 | 0 | 16 | ||
repos_fts,name | repos_fts | name | 1329 | 0 | 0 | 1113 | [["til", 31], ["cloud-data-quality", 31], ["datasette", 20], ["covid19-dashboard", 17], ["omspy", 10], ["devops_aula07", 9], ["cloudgoat", 9], ["calishot", 8], ["devops-aula07", 7], ["TIL", 7]] | [["yeet", 1], ["yt-fts", 1], ["yumyum", 1], ["z1007816", 1], ["zctaimpacts", 1], ["zero-server", 1], ["zeusops-attendance-analysis", 1], ["zeusops-attendance-bot", 1], ["zhaobai", 1], ["zoned-receiving", 1]] |
users_fts,login | users_fts | login | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
users_fts,name | users_fts | name | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
raw_authors,id | raw_authors | id | 114 | 0 | 0 | 114 | ||
raw_authors,name | raw_authors | name | 114 | 0 | 0 | 110 | [["Thomas Sibley", 2], ["Simon Willison", 2], ["Robert Gieseke", 2], ["Abdussamet Koçak", 2], ["Alex Garcia", 1], ["Adrien Di Pasquale", 1], ["Adam Wolf", 1], ["Adam Simpson", 1], ["Adam Jonas", 1], ["Abdus", 1]] | [["dependabot[bot]", 1], ["fcatus", 1], ["gerrymanoim", 1], ["joelondon", 1], ["louispotok", 1], ["lsb", 1], ["mkorosec", 1], ["rhoboro", 1], ["vincent d warmerdam", 1], ["カシオ 金城 大関", 1]] |
raw_authors,email | raw_authors | 114 | 0 | 114 | 1 | [["", 114]] | ||
commits,sha | commits | sha | 3784 | 0 | 0 | 3784 | ||
commits,message | commits | message | 3784 | 0 | 0 | 3679 | [["Fixed typo", 12], ["Applied Black", 11], ["Typo fix", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 6], ["Release 0.4", 4], ["Release 0.3", 4], ["Fixed typo in release notes", 4], ["Changelog badge", 4]] | [["view-instance permission for debug URLs, closes #833", 1], ["where= and where_args= parameters to search() and search_sql()\n\nCloses #441", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["will, not may - refs #468", 1], ["word-break: break-word;", 1], ["word-wrap: anywhere on links in cells, refs #1805", 1], ["workflow_dispatch", 1], ["x button for clearing filters, refs #1016", 1], ["xfail documentation unit tests for view classes, refs #299\n\nMore documentation u...", 1], ["© 2017-2021", 1]] |
commits,author_date | commits | author_date | 3784 | 0 | 0 | 3781 | [["2022-12-15T17:34:07Z", 2], ["2022-03-15T15:36:35Z", 2], ["2021-07-30T00:44:16Z", 2], ["2017-10-24T02:36:44Z", 1], ["2017-10-24T02:25:48Z", 1], ["2017-10-24T02:00:37Z", 1], ["2017-10-23T16:02:40Z", 1], ["2017-10-23T15:28:00Z", 1], ["2017-10-23T00:41:19Z", 1], ["2017-10-23T00:39:03Z", 1]] | [["2023-07-08T18:40:19Z", 1], ["2023-07-08T19:50:22Z", 1], ["2023-07-08T20:08:09Z", 1], ["2023-07-09T01:03:25Z", 1], ["2023-07-09T01:03:41Z", 1], ["2023-07-09T01:04:14Z", 1], ["2023-07-09T01:05:05Z", 1], ["2023-07-09T01:13:36Z", 1], ["2023-07-09T01:14:06Z", 1], ["2023-07-10T19:24:26Z", 1]] |
commits,committer_date | commits | committer_date | 3784 | 0 | 0 | 3656 | [["2018-05-16T15:27:24Z", 23], ["2022-12-17T21:47:55Z", 18], ["2020-10-27T19:39:55Z", 11], ["2018-04-09T05:10:22Z", 9], ["2020-06-01T01:16:42Z", 8], ["2022-12-31T18:52:37Z", 6], ["2022-01-06T06:24:53Z", 6], ["2020-11-06T18:30:41Z", 6], ["2019-07-03T03:23:05Z", 5], ["2018-05-14T03:04:23Z", 5]] | [["2023-07-08T18:00:08Z", 1], ["2023-07-08T18:22:21Z", 1], ["2023-07-08T18:35:15Z", 1], ["2023-07-08T18:40:19Z", 1], ["2023-07-08T19:50:22Z", 1], ["2023-07-08T20:08:09Z", 1], ["2023-07-09T01:05:05Z", 1], ["2023-07-09T01:13:36Z", 1], ["2023-07-09T01:14:06Z", 1], ["2023-07-10T19:24:26Z", 1]] |
commits,raw_author | commits | raw_author | 3784 | 0 | 0 | 113 | [["13ae486343ea6454a93114c6f558ffea2f2c6874", 3311], ["2946d096d0cdefdc017559e6b57e87658736e843", 229], ["5df307d91b1167b0aa175853783d760add239497", 48], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 20], ["2edd38cb3801aa07f709f083eba7cbe4f16e0978", 17], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 7], ["90786fb02407ad60f10210c0592ee711a9a36fae", 6], ["b90d9715d7c0881515e9d6aa98923ed89d445945", 5], ["106fe7fbf8b80a01038e265a137b3b703422db48", 5]] | [["ddda3e8cc5167e6bdbab6819a1f4e8e2621f4e89", 1], ["e7784035c9ce3ef64d906c543907d5025673d054", 1], ["eab1e8f71bd05f2ff2163f024127cc28876dd05d", 1], ["f25304fb12f6d6fab36f551427610ed8e96f0c2f", 1], ["f2f4d10a554519ea00fb44a5f6377123c59e1f22", 1], ["f333c00958a658720cd93e305aac71711b88e52b", 1], ["f3dfe1c3cf166dd0b9b8860a25045107a068c5df", 1], ["f85fb7898f36734a83fd9c8a2c2e96c751920c35", 1], ["f98e0e8fe6ee48ca1f752bb408eecbbd294f9ceb", 1], ["fcf3b31d4679bb2112170ec4dda53dede33a16b3", 1]] |
commits,raw_committer | commits | raw_committer | 3784 | 0 | 0 | 6 | [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2679], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 839], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]] | |
commits,repo | commits | repo | 3784 | 0 | 0 | 16 | [[107914493, 2314], [140912432, 901], [207052882, 176], [206156866, 132], [197431109, 61], [256834907, 41], [205429375, 36], [197882382, 30], [213286752, 22], [303218369, 19]] | [[209590345, 1], [206649770, 6], [611552758, 9], [206202864, 10], [214746582, 13], [248903544, 13], [303218369, 19], [213286752, 22], [197882382, 30], [205429375, 36]] |
commits_fts,message | commits_fts | message | 3784 | 0 | 0 | 3679 | [["Fixed typo", 12], ["Applied Black", 11], ["Typo fix", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 6], ["Release 0.4", 4], ["Release 0.3", 4], ["Fixed typo in release notes", 4], ["Changelog badge", 4]] | [["view-instance permission for debug URLs, closes #833", 1], ["where= and where_args= parameters to search() and search_sql()\n\nCloses #441", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["will, not may - refs #468", 1], ["word-break: break-word;", 1], ["word-wrap: anywhere on links in cells, refs #1805", 1], ["workflow_dispatch", 1], ["x button for clearing filters, refs #1016", 1], ["xfail documentation unit tests for view classes, refs #299\n\nMore documentation u...", 1], ["© 2017-2021", 1]] |
commits_fts_data,id | commits_fts_data | id | 45 | 0 | 0 | 45 | ||
commits_fts_data,block | commits_fts_data | block | 45 | 0 | 0 | 45 | ||
commits_fts_idx,segid | commits_fts_idx | segid | 43 | 0 | 0 | 1 | [[1, 43]] | |
commits_fts_idx,term | commits_fts_idx | term | 43 | 0 | 0 | 43 | ||
commits_fts_idx,pgno | commits_fts_idx | pgno | 43 | 0 | 0 | 43 | ||
commits_fts_docsize,id | commits_fts_docsize | id | 3784 | 0 | 0 | 3784 | ||
commits_fts_docsize,sz | commits_fts_docsize | sz | 3784 | 0 | 0 | 123 | [["b'\\x07'", 478], ["b'\\x08'", 454], ["b'\\x06'", 417], ["b'\\t'", 375], ["b'\\x05'", 307], ["b'\\n'", 236], ["b'\\x04'", 219], ["b'\\x03'", 195], ["b'\\x0b'", 151], ["b'\\x0c'", 107]] | [["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_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]] | |
milestones,id | milestones | id | 34 | 0 | 0 | 34 | ||
milestones,title | milestones | title | 34 | 0 | 0 | 33 | [["1.0", 2], ["3.29", 1], ["3.21", 1], ["3.0", 1], ["2.20", 1], ["2.19", 1], ["0.51", 1], ["0.28", 1], ["0.23.1", 1], [" Datasette 1.0a2", 1]] | [["Datasette 0.60", 1], ["Datasette 0.62", 1], ["Datasette 1.0", 1], ["Datasette 1.0a0", 1], ["Datasette 1.0a1", 1], ["Datasette 1.0a3", 1], ["Datasette Next", 1], ["Foreign key edition", 1], ["Ship first public release", 1], ["v1 stretch goals", 1]] |
milestones,creator | milestones | creator | 34 | 0 | 0 | 1 | [[9599, 34]] | |
milestones,repo | milestones | repo | 34 | 0 | 0 | 4 | [[107914493, 25], [140912432, 7], [256834907, 1], [207052882, 1]] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [_analyze_tables_] ( [table] TEXT, [column] TEXT, [total_rows] INTEGER, [num_null] INTEGER, [num_blank] INTEGER, [num_distinct] INTEGER, [most_common] TEXT, [least_common] TEXT, PRIMARY KEY ([table], [column]) );