_analyze_tables_
350 rows sorted by table descending
This data as json, CSV (advanced)
Link | table ▲ | column | total_rows | num_null | num_blank | num_distinct | most_common | least_common |
---|---|---|---|---|---|---|---|---|
repos,allow_rebase_merge | repos | allow_rebase_merge | 1329 | 1120 | 0 | 1 | [["None", 1329]] | |
repos,allow_squash_merge | repos | allow_squash_merge | 1329 | 1120 | 0 | 1 | [["None", 1329]] | |
repos,allow_update_branch | repos | allow_update_branch | 1329 | 1244 | 0 | 1 | [["None", 1329]] | |
repos,archived | repos | archived | 1329 | 0 | 0 | 2 | [[0, 1324], [1, 5]] | |
repos,created_at | repos | created_at | 1329 | 0 | 0 | 1329 | ||
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,delete_branch_on_merge | repos | delete_branch_on_merge | 1329 | 1120 | 0 | 2 | [["None", 1120], [0, 208], [1, 1]] | |
repos,description | repos | description | 1329 | 431 | 0 | 771 | [["None", 431], ["Data Quality Engine for BigQuery", 31], ["A site that displays up to date COVID-19 stats, powered by fastpages.", 18], ["Improved Order Management System for stock trading", 10], ["An open source multi-tool for exploring and publishing data", 9], ["Today I Learned", 8], ["CloudGoat is Rhino Security Labs' \"Vulnerable by Design\" AWS deployment tool", 7], ["Save data from Pinboard to a SQLite database.", 6], ["Tool to index and serve HTML files. Powered by Datasette.", 5], ["A tool for exploring and publishing data", 5]] | [["自托管 Webfont 字体生成接口", 1], ["論文をChatGPTに要約させて毎日Slackに配信させるツール", 1], ["🌍 Import geographic and spatial data from files into a SpatiaLite DB", 1], ["🎓 coding exercises from leetcode, hackerrank, codesignal etc.", 1], ["👨⚕️ health stats from my apple watch", 1], ["📝 Today I Learned", 1], ["📦 course materials, demos, and hands-outs for all the courses I have taken till...", 1], ["📦 data crawler", 1], ["📰 Today I Learned", 1], ["📻 my notes on various topics", 1]] |
repos,disabled | repos | disabled | 1329 | 0 | 0 | 1 | [[0, 1329]] | |
repos,fork | repos | fork | 1329 | 0 | 0 | 2 | [[0, 1201], [1, 128]] | |
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,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,full_name | repos | full_name | 1329 | 0 | 0 | 1329 | ||
repos,has_discussions | repos | has_discussions | 1329 | 884 | 0 | 2 | [["None", 884], [0, 441], [1, 4]] | |
repos,has_downloads | repos | has_downloads | 1329 | 0 | 0 | 2 | [[1, 1328], [0, 1]] | |
repos,has_issues | repos | has_issues | 1329 | 0 | 0 | 2 | [[1, 1185], [0, 144]] | |
repos,has_pages | repos | has_pages | 1329 | 0 | 0 | 2 | [[0, 1277], [1, 52]] | |
repos,has_projects | repos | has_projects | 1329 | 0 | 0 | 2 | [[1, 1281], [0, 48]] | |
repos,has_wiki | repos | has_wiki | 1329 | 0 | 0 | 2 | [[1, 1228], [0, 101]] | |
repos,homepage | repos | homepage | 1329 | 799 | 300 | 177 | [["None", 799], ["", 300], ["https://covid19dashboards.com", 18], ["https://datasette.io", 8], ["https://lawsql.com", 5], ["http://datasette.readthedocs.io/", 5], ["https://til.simonwillison.net/", 4], ["https://junior.guru", 4], ["https://lawdata.xyz", 3], ["https://docs.datasette.io", 3]] | [["https://www.tacosdedatos.com/", 1], ["https://www.youtube.com/watch?v=lhM357qSGXA", 1], ["https://yumyum-tau.vercel.app/", 1], ["https://zctaimpacts.abrie.dev", 1], ["links-mads-hartmann-com.vercel.app", 1], ["my-database-project-git-main.testberg.vercel.app", 1], ["pocket-data-datasette-kasperzutterman.vercel.app", 1], ["scratch-gamma.vercel.app", 1], ["unabandaql-ng-git-master.jazzido.vercel.app", 1], ["vumc-resident-map.vercel.app", 1]] |
repos,html_url | repos | html_url | 1329 | 0 | 0 | 1329 | ||
repos,id | repos | id | 1329 | 0 | 0 | 1329 | ||
repos,is_template | repos | is_template | 1329 | 548 | 0 | 2 | [[0, 773], ["None", 548], [1, 8]] | |
repos,language | repos | language | 1329 | 167 | 0 | 26 | [["Python", 762], ["None", 167], ["Jupyter Notebook", 103], ["HTML", 83], ["Shell", 58], ["JavaScript", 45], ["Makefile", 35], ["CSS", 12], ["Dockerfile", 11], ["TeX", 9]] | [["Clojure", 1], ["Elixir", 1], ["Hy", 1], ["Java", 1], ["PLpgSQL", 1], ["PureBasic", 1], ["Vim script", 1], ["WebAssembly", 1], ["Julia", 2], ["PHP", 2]] |
repos,license | repos | license | 1329 | 666 | 0 | 16 | [["None", 666], ["apache-2.0", 310], ["mit", 224], ["bsd-3-clause", 32], ["gpl-3.0", 29], ["other", 27], ["agpl-3.0", 10], ["unlicense", 7], ["wtfpl", 6], ["cc-by-4.0", 6]] | [["eupl-1.2", 1], ["gpl-2.0", 1], ["lgpl-2.1", 1], ["mpl-2.0", 1], ["bsd-2-clause", 2], ["bsd-3-clause-clear", 2], ["cc0-1.0", 4], ["cc-by-4.0", 6], ["wtfpl", 6], ["unlicense", 7]] |
repos,merge_commit_message | repos | merge_commit_message | 1329 | 1275 | 0 | 1 | [["None", 1329]] | |
repos,merge_commit_title | repos | merge_commit_title | 1329 | 1275 | 0 | 1 | [["None", 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,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,node_id | repos | node_id | 1329 | 0 | 0 | 1329 | ||
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,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,organization | repos | organization | 1329 | 1108 | 0 | 127 | [["None", 1108], [53015001, 14], [44060760, 13], [38107867, 7], [84364688, 6], [42605656, 6], [11290934, 6], [116695412, 5], [89875467, 5], [80003822, 4]] | [[110405140, 1], [114021082, 1], [116570464, 1], [116850614, 1], [117817022, 1], [120766041, 1], [123046521, 1], [128680267, 1], [132527556, 1], [139249755, 1]] |
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,parent | repos | parent | 1329 | 1201 | 0 | 76 | [["None", 1201], ["{\"id\": 349504954, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzNDk1MDQ5NTQ=\", \"name\": \"cloud-...", 29], ["{\"id\": 415345233, \"node_id\": \"R_kgDOGMGqUQ\", \"name\": \"omspy\", \"full_name\": \"uber...", 8], ["{\"id\": 280696796, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyODA2OTY3OTY=\", \"name\": \"calish...", 5], ["{\"id\": 220291151, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjAyOTExNTE=\", \"name\": \"pinboa...", 5], ["{\"id\": 408509890, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDg1MDk4OTA=\", \"name\": \"htmls-...", 4], ["{\"id\": 194628275, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxOTQ2MjgyNzU=\", \"name\": \"junior...", 3], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 2], ["{\"id\": 220697897, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjA2OTc4OTc=\", \"name\": \"lastfm...", 2], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 2]] | [["{\"id\": 426357499, \"node_id\": \"R_kgDOGWmy-w\", \"name\": \"covid19-dashboard\", \"full_...", 1], ["{\"id\": 445218858, \"node_id\": \"R_kgDOGomAKg\", \"name\": \"starred-repos\", \"full_name...", 1], ["{\"id\": 456560389, \"node_id\": \"R_kgDOGzaPBQ\", \"name\": \"coros-to-sqlite\", \"full_na...", 1], ["{\"id\": 459821110, \"node_id\": \"R_kgDOG2hQNg\", \"name\": \"google-drive-to-sqlite\", \"...", 1], ["{\"id\": 464677284, \"node_id\": \"R_kgDOG7JppA\", \"name\": \"calishot\", \"full_name\": \"K...", 1], ["{\"id\": 466635830, \"node_id\": \"R_kgDOG9BMNg\", \"name\": \"covid19-dashboard\", \"full_...", 1], ["{\"id\": 485162981, \"node_id\": \"R_kgDOHOr_5Q\", \"name\": \"cloud-data-quality\", \"full...", 1], ["{\"id\": 579841533, \"node_id\": \"R_kgDOIo-t_Q\", \"name\": \"slothful-myles\", \"full_nam...", 1], ["{\"id\": 581302435, \"node_id\": \"R_kgDOIqX4ow\", \"name\": \"mastodon-to-sqlite\", \"full...", 1], ["{\"id\": 583468610, \"node_id\": \"R_kgDOIscGQg\", \"name\": \"cloud-data-quality\", \"full...", 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,private | repos | private | 1329 | 0 | 0 | 1 | [[0, 1329]] | |
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,security_and_analysis | repos | security_and_analysis | 1329 | 1290 | 0 | 3 | [["None", 1290], ["{\"secret_scanning\": {\"status\": \"disabled\"}, \"secret_scanning_push_protection\": {...", 17], ["{\"secret_scanning\": {\"status\": \"disabled\"}, \"secret_scanning_push_protection\": {...", 14], ["{\"secret_scanning\": {\"status\": \"disabled\"}, \"secret_scanning_push_protection\": {...", 8]] | |
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,source | repos | source | 1329 | 1201 | 0 | 74 | [["None", 1201], ["{\"id\": 349504954, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzNDk1MDQ5NTQ=\", \"name\": \"cloud-...", 31], ["{\"id\": 415345233, \"node_id\": \"R_kgDOGMGqUQ\", \"name\": \"omspy\", \"full_name\": \"uber...", 8], ["{\"id\": 280696796, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyODA2OTY3OTY=\", \"name\": \"calish...", 5], ["{\"id\": 220291151, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjAyOTExNTE=\", \"name\": \"pinboa...", 5], ["{\"id\": 408509890, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDg1MDk4OTA=\", \"name\": \"htmls-...", 4], ["{\"id\": 194628275, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxOTQ2MjgyNzU=\", \"name\": \"junior...", 3], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 2], ["{\"id\": 220697897, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjA2OTc4OTc=\", \"name\": \"lastfm...", 2], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 2]] | [["{\"id\": 399308604, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzOTkzMDg2MDQ=\", \"name\": \"datase...", 1], ["{\"id\": 403239260, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDMyMzkyNjA=\", \"name\": \"pulse-...", 1], ["{\"id\": 409650041, \"node_id\": \"R_kgDOGGrDeQ\", \"name\": \"LOSH-krawler\", \"full_name\"...", 1], ["{\"id\": 415345233, \"node_id\": \"R_kgDOGMGqUQ\", \"name\": \"omspy\", \"full_name\": \"uber...", 1], ["{\"id\": 445218858, \"node_id\": \"R_kgDOGomAKg\", \"name\": \"starred-repos\", \"full_name...", 1], ["{\"id\": 456560389, \"node_id\": \"R_kgDOGzaPBQ\", \"name\": \"coros-to-sqlite\", \"full_na...", 1], ["{\"id\": 459821110, \"node_id\": \"R_kgDOG2hQNg\", \"name\": \"google-drive-to-sqlite\", \"...", 1], ["{\"id\": 464677284, \"node_id\": \"R_kgDOG7JppA\", \"name\": \"calishot\", \"full_name\": \"K...", 1], ["{\"id\": 579841533, \"node_id\": \"R_kgDOIo-t_Q\", \"name\": \"slothful-myles\", \"full_nam...", 1], ["{\"id\": 581302435, \"node_id\": \"R_kgDOIqX4ow\", \"name\": \"mastodon-to-sqlite\", \"full...", 1]] |
repos,squash_merge_commit_message | repos | squash_merge_commit_message | 1329 | 1275 | 0 | 1 | [["None", 1329]] | |
repos,squash_merge_commit_title | repos | squash_merge_commit_title | 1329 | 1275 | 0 | 1 | [["None", 1329]] | |
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,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]] |
repos,temp_clone_token | repos | temp_clone_token | 1329 | 0 | 1329 | 1 | [["", 1329]] | |
repos,template_repository | repos | template_repository | 1329 | 1278 | 0 | 34 | [["None", 1278], ["{\"id\": 566008212, \"node_id\": \"R_kgDOIbyZlA\", \"name\": \"warehouse-etl\", \"full_name...", 4], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 4], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 3], ["{\"id\": 383002759, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzODMwMDI3NTk=\", \"name\": \"templa...", 3], ["{\"id\": 424823623, \"node_id\": \"R_kgDOGVJLRw\", \"name\": \"glam-workbench-template\", ...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2]] | [["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 1], ["{\"id\": 401177473, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDExNzc0NzM=\", \"name\": \"click-...", 1], ["{\"id\": 404397410, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDQzOTc0MTA=\", \"name\": \"python...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 515375569, \"node_id\": \"R_kgDOHrgB0Q\", \"name\": \"cloud-data-quality\", \"full...", 1], ["{\"id\": 521799111, \"node_id\": \"R_kgDOHxoFxw\", \"name\": \"redbean-template\", \"full_n...", 1], ["{\"id\": 614348767, \"node_id\": \"R_kgDOJJ433w\", \"name\": \"ci-full-template\", \"full_n...", 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,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,use_squash_pr_title_as_default | repos | use_squash_pr_title_as_default | 1329 | 1266 | 0 | 1 | [["None", 1329]] | |
repos,visibility | repos | visibility | 1329 | 543 | 0 | 1 | [["None", 1329]] | |
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,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,web_commit_signoff_required | repos | web_commit_signoff_required | 1329 | 770 | 0 | 2 | [["None", 770], [0, 552], [1, 7]] | |
releases_fts_idx,pgno | releases_fts_idx | pgno | 45 | 0 | 0 | 45 | ||
releases_fts_idx,segid | releases_fts_idx | segid | 45 | 0 | 0 | 1 | [[1, 45]] | |
releases_fts_idx,term | releases_fts_idx | term | 45 | 0 | 0 | 45 | ||
releases_fts_docsize,id | releases_fts_docsize | id | 344 | 0 | 0 | 344 | ||
releases_fts_docsize,sz | releases_fts_docsize | sz | 344 | 0 | 0 | 221 | [["b'\\x02\\x0b'", 17], ["b'\\x02\\x00'", 8], ["b'\\x03\\x12'", 7], ["b'\\x03\\x0c'", 7], ["b'\\x03\\x0b'", 6], ["b'\\x02\\x15'", 4], ["b'\\x02\\x11'", 4], ["b'\\x02\\n'", 4], ["b'\\x02('", 4], ["b'\\x02&'", 4]] | [["b'\\n\\x83\\x04'", 1], ["b'\\t\\x81\\x03'", 1], ["b'\\t\\x81{'", 1], ["b'\\x04\\x82\\x16'", 1], ["b'\\x05\\x81\\x7f'", 1], ["b'\\x05\\x82Z'", 1], ["b'\\x05\\x88J'", 1], ["b'\\x06\\x84\\x06'", 1], ["b'\\x07\"'", 1], ["b'\\x08\\x83.'", 1]] |
releases_fts_data,block | releases_fts_data | block | 47 | 0 | 0 | 47 | ||
releases_fts_data,id | releases_fts_data | id | 47 | 0 | 0 | 47 | ||
releases_fts_config,k | releases_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
releases_fts_config,v | releases_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
releases_fts,body | releases_fts | body | 344 | 0 | 8 | 337 | [["", 8], ["* Added custom project links to the [PyPI listing](https://pypi.org/project/sqli...", 1], ["* Added `github-to-sqlite repos` command, #3 ", 1], ["* Added `followers-ids` and `friends-ids` subcommands", 1], ["* Added `--since_id` and `--since` to `user-timeline` command, refs #20\r\n* `--si...", 1], ["* Added --since option, closes #3 ", 1], ["* favorites command now populates `favorited_by` table - #14 \r\n* favorites `--...", 1], ["### Plugins and internals\r\n\r\n- New plugin hook: [filters_from_request(request,...", 1], ["# 0.13 (2017-11-24)\r\n\r\n - Search now applies to current filters.\r\n \r\n Com...", 1], [" - Better mechanism for handling errors; 404s for missing table/database\r\n \r...", 1]] | [["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-1", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-3", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7-1", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-10", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-11", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-8", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-9", 1]] |
releases_fts,name | releases_fts | name | 344 | 0 | 0 | 279 | [["0.2", 8], ["0.3", 7], ["0.4", 6], ["0.1", 6], ["0.7", 4], ["0.5", 4], ["0.3.1", 4], ["0.3.2", 3], ["0.1a", 3], ["0.10", 3]] | [["Datasette 0.29", 1], ["Datasette 0.31", 1], ["Datasette 0.32", 1], ["Datasette 0.33", 1], ["Datasette 0.34", 1], ["Datasette 0.35", 1], ["Datasette 0.36", 1], ["Datasette 0.37", 1], ["Datasette 0.37.1", 1], ["Initial release", 1]] |
releases,author | releases | author | 344 | 0 | 0 | 1 | [[9599, 344]] | |
releases,body | releases | body | 344 | 0 | 8 | 337 | [["", 8], ["* Added custom project links to the [PyPI listing](https://pypi.org/project/sqli...", 1], ["* Added `github-to-sqlite repos` command, #3 ", 1], ["* Added `followers-ids` and `friends-ids` subcommands", 1], ["* Added `--since_id` and `--since` to `user-timeline` command, refs #20\r\n* `--si...", 1], ["* Added --since option, closes #3 ", 1], ["* favorites command now populates `favorited_by` table - #14 \r\n* favorites `--...", 1], ["### Plugins and internals\r\n\r\n- New plugin hook: [filters_from_request(request,...", 1], ["# 0.13 (2017-11-24)\r\n\r\n - Search now applies to current filters.\r\n \r\n Com...", 1], [" - Better mechanism for handling errors; 404s for missing table/database\r\n \r...", 1]] | [["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-1", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-3", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7-1", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-10", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-11", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-8", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-9", 1]] |
releases,created_at | releases | created_at | 344 | 0 | 0 | 344 | ||
releases,draft | releases | draft | 344 | 0 | 0 | 1 | [[0, 344]] | |
releases,html_url | releases | html_url | 344 | 0 | 0 | 344 | ||
releases,id | releases | id | 344 | 0 | 0 | 344 | ||
releases,name | releases | name | 344 | 0 | 0 | 279 | [["0.2", 8], ["0.3", 7], ["0.4", 6], ["0.1", 6], ["0.7", 4], ["0.5", 4], ["0.3.1", 4], ["0.3.2", 3], ["0.1a", 3], ["0.10", 3]] | [["Datasette 0.29", 1], ["Datasette 0.31", 1], ["Datasette 0.32", 1], ["Datasette 0.33", 1], ["Datasette 0.34", 1], ["Datasette 0.35", 1], ["Datasette 0.36", 1], ["Datasette 0.37", 1], ["Datasette 0.37.1", 1], ["Initial release", 1]] |
releases,node_id | releases | node_id | 344 | 0 | 0 | 344 | ||
releases,prerelease | releases | prerelease | 344 | 0 | 0 | 2 | [[0, 305], [1, 39]] | |
releases,published_at | releases | published_at | 344 | 0 | 0 | 344 | ||
releases,reactions | releases | reactions | 344 | 316 | 0 | 28 | [["None", 316], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/57629048/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/51940513/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/51387349/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/47507174/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/45182156/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/44292523/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/44155601/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/101136455/reacti...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/twitter-to-sqlite/releases/500036...", 1]] | [["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/103740013/rea...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/109839649/rea...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/44511190/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/44904928/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/47636109/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/48389722/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/53350811/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/59656694/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/65833874/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/75560168/reac...", 1]] |
releases,repo | releases | repo | 344 | 0 | 0 | 14 | [[107914493, 126], [140912432, 108], [206156866, 28], [207052882, 22], [197431109, 20], [197882382, 9], [205429375, 7], [256834907, 5], [248903544, 5], [213286752, 5]] | [[209590345, 1], [611552758, 1], [206202864, 2], [213286752, 5], [248903544, 5], [256834907, 5], [303218369, 5], [205429375, 7], [197882382, 9], [197431109, 20]] |
releases,tag_name | releases | tag_name | 344 | 0 | 0 | 267 | [["0.2", 8], ["0.3", 7], ["0.1", 7], ["0.4", 6], ["0.7", 4], ["0.5", 4], ["0.3.1", 4], ["0.1a", 4], ["0.12", 3], ["0.10", 3]] | [["3.32.1", 1], ["3.33", 1], ["3.4", 1], ["3.4.1", 1], ["3.5", 1], ["3.6", 1], ["3.7", 1], ["3.8", 1], ["3.9", 1], ["3.9.1", 1]] |
releases,target_commitish | releases | target_commitish | 344 | 0 | 0 | 8 | [["main", 176], ["master", 157], ["0.64.x", 3], ["0.63.x", 3], ["0.60.x", 2], ["0.56.x", 1], ["0.54.x", 1], ["0.52.x", 1]] | |
raw_authors,email | raw_authors | 114 | 0 | 114 | 1 | [["", 114]] | ||
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]] |
pull_requests_fts_idx,pgno | pull_requests_fts_idx | pgno | 122 | 0 | 0 | 122 | ||
pull_requests_fts_idx,segid | pull_requests_fts_idx | segid | 122 | 0 | 0 | 1 | [[1, 122]] | |
pull_requests_fts_idx,term | pull_requests_fts_idx | term | 122 | 0 | 0 | 122 | ||
pull_requests_fts_docsize,id | pull_requests_fts_docsize | id | 560 | 0 | 0 | 560 | ||
pull_requests_fts_docsize,sz | pull_requests_fts_docsize | sz | 560 | 0 | 0 | 396 | [["b'\\x07\\x00'", 13], ["b'\\x08\\x02'", 11], ["b'\\x07\\x02'", 11], ["b'\\x06\\x00'", 11], ["b'\\x04\\x00'", 11], ["b'\\x05\\x02'", 10], ["b'\\x04\\x02'", 10], ["b'\\x06\\x02'", 8], ["b'\\x05\\x00'", 8], ["b'\\x03\\x00'", 6]] | [["b'\\x11\\x89.'", 1], ["b'\\x11\\x896'", 1], ["b'\\x11\\x89<'", 1], ["b'\\x11\\x89`'", 1], ["b'\\x11\\x89s'", 1], ["b'\\x11\\x8a\\r'", 1], ["b'\\x11\\x8a\\x1e'", 1], ["b'\\x11\\x8ax'", 1], ["b'\\x14z'", 1], ["b'\\x15g'", 1]] |
pull_requests_fts_data,block | pull_requests_fts_data | block | 126 | 0 | 0 | 126 | ||
pull_requests_fts_data,id | pull_requests_fts_data | id | 126 | 0 | 0 | 126 | ||
pull_requests_fts_config,k | pull_requests_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
pull_requests_fts_config,v | pull_requests_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
pull_requests_fts,body | pull_requests_fts | body | 560 | 10 | 54 | 496 | [["", 54], ["None", 10], ["Refs #744", 2], ["\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\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] | [["sqlite \"IS\" is equivalent to SQL \"IS NOT DISTINCT FROM\"\r\n\r\ncloses #423", 1], ["sqlite foreign keys can be compound, but that is not as well supported by datase...", 1], ["the `--connection` parameter has become positional", 1], ["the library deal with Postgres type jsonb as dictionary, add dict type as a TEXT...", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["this var `app` isn't actually used? unless init it does some side-effect outside...", 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], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1]] |
pull_requests_fts,title | pull_requests_fts | title | 560 | 0 | 0 | 556 | [["Use Read the Docs action v1", 2], ["Update deploying.rst", 2], ["Update README.md", 2], ["Add paths for homebrew on Apple silicon", 2], ["--crossdb option for joining across databases", 1], ["'datasette --get' option, refs #926", 1], ["\"permissions\" blocks in metadata.json/yaml", 1], ["\"datasette publish cloudrun\" command to publish to Google Cloud Run", 1], [" Import pysqlite3 if available, closes #360 ", 1], [" Don't duplicate simple primary keys in the link column", 1]] | [["table.update() method", 1], ["test commit", 1], ["test_insert_upsert_all_empty_list", 1], ["tiny typo in customization docs", 1], ["twitter-to-sqlite import command, refs #4", 1], ["upsert new rows with constraints, fixes #514", 1], ["use inspect data for hash and file size", 1], ["use jsonify_if_need for sql updates", 1], ["use single quotes for string literals, fixes #2001", 1], ["use universal command", 1]] |
pull_requests,assignee | pull_requests | assignee | 560 | 557 | 0 | 2 | [["None", 557], [9599, 2], [15178711, 1]] | |
pull_requests,author_association | pull_requests | author_association | 560 | 0 | 0 | 5 | [["CONTRIBUTOR", 277], ["OWNER", 190], ["FIRST_TIME_CONTRIBUTOR", 63], ["NONE", 25], ["MEMBER", 5]] | |
pull_requests,auto_merge | pull_requests | auto_merge | 560 | 560 | 0 | 0 | [[null, 560]] | |
pull_requests,base | pull_requests | base | 560 | 0 | 0 | 422 | [["f09d611782a8372cfb002792dfa727325afb4db6", 7], ["1b697539f5b53cec3fe13c0f4ada13ba655c88c7", 6], ["0b4a28691468b5c758df74fa1d72a823813c96bf", 5], ["b7257a21bf3dfa7353980f343c83a616da44daa7", 4], ["a4bb2abce0764d49d255e5379f9e9c70981834ca", 4], ["8c401ee0f054de2f568c3a8302c9223555146407", 4], ["71e36e1cf034b96de2a8e6652265d782d3fdf63b", 4], ["5890a20c374fb0812d88c9b0ef26a838bfa06c76", 4], ["11b352b4d52fd02a422776edebb14f12e4994d3b", 4], ["0f7192b6154edb576c41b55bd3f2a3f53e5f436a", 4]] | [["f7289174e66ae4d91d57de94bbd9d09fabf7aff4", 1], ["f825e2012109247fa246e2b938f8174069e574f1", 1], ["f8277d0fb9c05a88a9ff01d996e31d55f0f0a645", 1], ["fa8eb0bf1b113ab17ede9cd107b7c3bd5cde39c3", 1], ["faea5093b865031f650da7da6539430f732f511a", 1], ["fb988ace7c7e2bee5ac142a0eab22431d0675a77", 1], ["fcf43589eb6a1f1d0432772a639fd35711c48e0c", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fe5b6ea95a973534fe8a44907c0ea2449aae7602", 1], ["fff89772b4404995400e33fe1d269050717ff4cf", 1]] |
pull_requests,body | pull_requests | body | 560 | 10 | 54 | 496 | [["", 54], ["None", 10], ["Refs #744", 2], ["\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\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] | [["sqlite \"IS\" is equivalent to SQL \"IS NOT DISTINCT FROM\"\r\n\r\ncloses #423", 1], ["sqlite foreign keys can be compound, but that is not as well supported by datase...", 1], ["the `--connection` parameter has become positional", 1], ["the library deal with Postgres type jsonb as dictionary, add dict type as a TEXT...", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["this var `app` isn't actually used? unless init it does some side-effect outside...", 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], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1]] |
pull_requests,closed_at | pull_requests | closed_at | 560 | 90 | 0 | 470 | [["None", 90], ["2017-11-21T20:55:05Z", 1], ["2017-11-18T03:15:50Z", 1], ["2017-11-18T00:53:43Z", 1], ["2017-11-17T14:22:56Z", 1], ["2017-11-17T13:29:22Z", 1], ["2017-11-17T03:50:52Z", 1], ["2017-11-15T03:08:04Z", 1], ["2017-11-15T02:03:01Z", 1], ["2017-11-13T22:16:55Z", 1]] | [["2023-05-08T21:13:37Z", 1], ["2023-05-08T21:27:10Z", 1], ["2023-05-08T21:53:58Z", 1], ["2023-05-15T13:59:36Z", 1], ["2023-05-21T16:19:30Z", 1], ["2023-05-21T18:41:56Z", 1], ["2023-05-21T20:57:23Z", 1], ["2023-05-26T00:18:44Z", 1], ["2023-06-25T23:25:51Z", 1], ["2023-06-29T14:31:54Z", 1]] |
pull_requests,created_at | pull_requests | created_at | 560 | 0 | 0 | 560 |
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]) );