_analyze_tables_
350 rows sorted by num_null descending
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 |
---|---|---|---|---|---|---|---|---|
issue_comments,performed_via_github_app | issue_comments | performed_via_github_app | 9947 | 9947 | 0 | 0 | [[null, 9947]] | |
issues,active_lock_reason | issues | active_lock_reason | 2892 | 2892 | 0 | 0 | [[null, 2892]] | |
issues,performed_via_github_app | issues | performed_via_github_app | 2892 | 2892 | 0 | 0 | [[null, 2892]] | |
issues,assignee | issues | assignee | 2892 | 2872 | 0 | 2 | [["None", 2872], [9599, 19], [15178711, 1]] | |
issues,pull_request | issues | pull_request | 2892 | 2332 | 0 | 560 | [["None", 2332], ["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], ["dogsheep/apple-notes-to-sqlite/pulls/13", 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,draft | issues | draft | 2892 | 2332 | 0 | 2 | [["None", 2332], [0, 550], [1, 10]] | |
issues,milestone | issues | milestone | 2892 | 2293 | 0 | 33 | [["None", 2293], [3268330, 110], [6026070, 53], [2857392, 49], [5512395, 39], [5533512, 25], [7571612, 24], [8658075, 23], [4305096, 22], [2949431, 21]] | [[9374594, 1], [5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414, 5], [7867486, 6], [3439337, 7], [5225818, 7], [6079500, 7]] |
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,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,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,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,use_squash_pr_title_as_default | repos | use_squash_pr_title_as_default | 1329 | 1266 | 0 | 1 | [["None", 1329]] | |
repos,allow_update_branch | repos | allow_update_branch | 1329 | 1244 | 0 | 1 | [["None", 1329]] | |
repos,allow_auto_merge | repos | allow_auto_merge | 1329 | 1229 | 0 | 1 | [["None", 1329]] | |
issues,state_reason | issues | state_reason | 2892 | 1214 | 0 | 3 | [["completed", 1673], ["None", 1214], ["reopened", 4], ["not_planned", 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,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,allow_squash_merge | repos | allow_squash_merge | 1329 | 1120 | 0 | 1 | [["None", 1329]] | |
repos,allow_merge_commit | repos | allow_merge_commit | 1329 | 1120 | 0 | 1 | [["None", 1329]] | |
repos,allow_rebase_merge | repos | allow_rebase_merge | 1329 | 1120 | 0 | 1 | [["None", 1329]] | |
repos,delete_branch_on_merge | repos | delete_branch_on_merge | 1329 | 1120 | 0 | 2 | [["None", 1120], [0, 208], [1, 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,has_discussions | repos | has_discussions | 1329 | 884 | 0 | 2 | [["None", 884], [0, 441], [1, 4]] | |
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,web_commit_signoff_required | repos | web_commit_signoff_required | 1329 | 770 | 0 | 2 | [["None", 770], [0, 552], [1, 7]] | |
issues,closed_at | issues | closed_at | 2892 | 748 | 0 | 2084 | [["None", 748], ["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]] | [["2023-06-14T23:11:47Z", 1], ["2023-06-25T23:25:51Z", 1], ["2023-06-27T18:50:08Z", 1], ["2023-06-29T14:31:54Z", 1], ["2023-06-29T14:48:10Z", 1], ["2023-06-29T15:24:13Z", 1], ["2023-07-03T04:58:21Z", 1], ["2023-07-03T05:42:30Z", 1], ["2023-07-08T20:08:13Z", 1], ["2023-07-09T01:19:42Z", 1]] |
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]] |
pull_requests,merged_by | pull_requests | merged_by | 560 | 560 | 0 | 0 | [[null, 560]] | |
pull_requests,auto_merge | pull_requests | auto_merge | 560 | 560 | 0 | 0 | [[null, 560]] | |
pull_requests,assignee | pull_requests | assignee | 560 | 557 | 0 | 2 | [["None", 557], [9599, 2], [15178711, 1]] | |
repos,is_template | repos | is_template | 1329 | 548 | 0 | 2 | [[0, 773], ["None", 548], [1, 8]] | |
repos,visibility | repos | visibility | 1329 | 543 | 0 | 1 | [["None", 1329]] | |
pull_requests,milestone | pull_requests | milestone | 560 | 527 | 0 | 14 | [["None", 527], [6026070, 6], [8711695, 3], [6346396, 3], [5512395, 3], [5471110, 3], [3268330, 3], [7558727, 2], [5971510, 2], [4471010, 2]] | [[5234079, 1], [5533512, 1], [5897911, 1], [6055094, 1], [4471010, 2], [5971510, 2], [7558727, 2], [8355157, 2], [6346396, 3], [8711695, 3]] |
repos,allow_forking | repos | allow_forking | 1329 | 526 | 0 | 1 | [["None", 1329]] | |
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_fts,description | repos_fts | 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]] |
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]] |
steps,if | steps | if | 262 | 252 | 0 | 7 | [["None", 252], ["${{ github.ref == 'refs/heads/main' }}", 3], ["matrix.os == 'ubuntu-latest'", 2], ["matrix.python-version >= 3.8", 1], ["matrix.os == 'macos-latest' && matrix.python-version == '3.10'", 1], ["matrix.numpy == 1", 1], ["${{ github.event_name == 'pull_request' }}", 1], ["!contains(github.event.head_commit.message, 'REFRESH_DB')", 1]] | |
steps,env | steps | env | 262 | 246 | 0 | 6 | [["None", 246], ["{\"TWINE_USERNAME\": \"__token__\", \"TWINE_PASSWORD\": \"${{ secrets.PYPI_TOKEN }}\"}", 11], ["{\"VERCEL_TOKEN\": \"${{ secrets.BRANCH_PREVIEW_VERCEL_TOKEN }}\"}", 1], ["{\"LATEST_DATASETTE_SECRET\": \"${{ secrets.LATEST_DATASETTE_SECRET }}\"}", 1], ["{\"GITHUB_ACCESS_TOKEN\": \"${{ secrets.GH_TOKEN }}\"}", 1], ["{\"DOCKER_USER\": \"${{ secrets.DOCKER_USER }}\", \"DOCKER_PASS\": \"${{ secrets.DOCKER...", 1], ["{\"DOCKER_USER\": \"${{ secrets.DOCKER_USER }}\", \"DOCKER_PASS\": \"${{ secrets.DOCKER...", 1]] | |
_analyze_tables_,least_common | _analyze_tables_ | least_common | 350 | 211 | 0 | 117 | [["None", 211], ["[[\"zxygithub\", 1], [\"zy528\", 1], [\"zyuanlim\", 1], [\"zz\", 1], [\"zz0x\", 1], [\"zz21...", 4], ["[[314, 1], [334, 1], [364, 1], [387, 1], [1057, 1], [1062, 1], [1230, 1], [1260,...", 3], ["[[\"release\", 1], [\"search\", 1], [\"security\", 1], [\"small\", 1], [\"support\", 1], [...", 2], ["[[\"https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2\", 1], [\"htt...", 2], ["[[\"Datasette 0.60\", 1], [\"Datasette 0.62\", 1], [\"Datasette 1.0\", 1], [\"Datasette...", 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], ["[[\"Ability to fully customize the HTML templates used to display datasette data....", 2], ["[[\"3.32.1\", 1], [\"3.33\", 1], [\"3.4\", 1], [\"3.4.1\", 1], [\"3.5\", 1], [\"3.6\", 1], [...", 2]] | [["[[37962604, 1], [39452697, 1], [56323389, 1], [72577720, 1], [87192257, 1], [918...", 1], ["[[439, 1], [443, 1], [446, 1], [449, 1], [452, 1], [460, 1], [461, 1], [487, 1],...", 1], ["[[49702524, 1], [52261150, 1], [60892516, 1], [63653929, 1], [76450761, 1], [765...", 1], ["[[5234079, 1], [5533512, 1], [5897911, 1], [6055094, 1], [4471010, 2], [5971510,...", 1], ["[[57859326, 1], [69208826, 1], [76450761, 1], [80409402, 1], [83080728, 1], [871...", 1], ["[[626, 1], [628, 1], [630, 1], [632, 1], [636, 1], [638, 1], [640, 1], [642, 1],...", 1], ["[[663556926, 1], [663586533, 1], [664178911, 1], [664727381, 1], [664733539, 1],...", 1], ["[[791181, 1], [1124434, 1], [1205836, 1], [1215453, 1], [1216794, 1], [1289400, ...", 1], ["[[9374594, 1], [5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414,...", 1], ["[[947465681, 1], [1382668283, 1], [1918831023, 1], [2157112227, 1], [2175284252,...", 1]] |
pull_requests,merged_at | pull_requests | merged_at | 560 | 178 | 0 | 382 | [["None", 178], ["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-04-13T01:44:43Z", 1], ["2023-05-08T21:10:01Z", 1], ["2023-05-08T21:13:37Z", 1], ["2023-05-08T21:53:58Z", 1], ["2023-05-21T16:19:30Z", 1], ["2023-05-21T18:41:56Z", 1], ["2023-05-21T20:57:22Z", 1], ["2023-05-26T00:18:44Z", 1], ["2023-06-25T23:25:51Z", 1], ["2023-06-29T14:31:54Z", 1]] |
steps,with | steps | with | 262 | 173 | 0 | 23 | [["None", 173], ["{\"path\": \"~/.cache/pip\", \"key\": \"${{ runner.os }}-pip-${{ hashFiles('**/setup.py...", 23], ["{\"python-version\": \"${{ matrix.python-version }}\"}", 17], ["{\"path\": \"~/.cache/pip\", \"key\": \"${{ runner.os }}-publish-pip-${{ hashFiles('**/...", 9], ["{\"python-version\": \"3.9\"}", 7], ["{\"python-version\": 3.9}", 4], ["{\"python-version\": \"3.11\"}", 4], ["{\"python-version\": \"${{ matrix.python-version }}\", \"cache\": \"pip\", \"cache-depend...", 4], ["{\"version\": \"318.0.0\", \"service_account_email\": \"${{ secrets.GCP_SA_EMAIL }}\", \"...", 3], ["{\"python-version\": \"${{ matrix.python-version }}\", \"cache\": \"pip\", \"cache-depend...", 2]] | [["{\"path\": \"github.db\"}", 1], ["{\"path\": \"~/.cache/ms-playwright/\", \"key\": \"${{ runner.os }}-browsers\"}", 1], ["{\"path\": \"~/.npm\", \"key\": \"${{ runner.OS }}-npm-${{ hashFiles('**/package-lock.j...", 1], ["{\"project-slug\": \"datasette\"}", 1], ["{\"project-slug\": \"sqlite-utils\"}", 1], ["{\"python-version\": \"3.10\", \"cache\": \"pip\", \"cache-dependency-path\": \"**/setup.py...", 1], ["{\"python-version\": \"3.11\", \"cache\": \"pip\", \"cache-dependency-path\": \"pyproject.t...", 1], ["{\"python-version\": \"3.8\"}", 1], ["{\"target-branch\": \"main\", \"force\": false}", 1], ["{\"target-branch\": \"master\", \"force\": false}", 1]] |
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]] |
steps,run | steps | run | 262 | 143 | 0 | 58 | [["None", 143], ["pytest\n", 19], ["pip install -e '.[test]'\n", 15], ["python setup.py sdist bdist_wheel\ntwine upload dist/*\n", 9], ["pip install setuptools wheel twine\n", 9], ["pip install '.[test]'\n", 4], ["pytest -v\n", 3], ["npx markdown-toc README.md -i", 2], ["git diff\ngit config --global user.email \"readme-bot@example.com\"\ngit config --gl...", 2], ["cd docs\nDISABLE_SPHINX_INLINE_TABS=1 sphinx-build -b xml . _build\nsphinx-to-sqli...", 2]] | [["pip install sqlean.py sqlite-dump", 1], ["pytest -n auto -m \"not serial\"\npytest -m \"serial\"\n", 1], ["pytest -n auto -m \"not serial\"\npytest -m \"serial\"\n# And the test that exceeds a ...", 1], ["python -m pip install --upgrade pip\npip install -e .[test]\n", 1], ["python -m pip install --upgrade pip\npip install sqlite-utils>=3.1\nsqlite-utils -...", 1], ["python -m pip install --upgrade pip\npython -m pip install -e .[test]\npython -m p...", 1], ["python -m pip install -e .[docs]\npython -m pip install sphinx-to-sqlite==0.1a1\n", 1], ["python tests/fixtures.py fixtures.db fixtures.json plugins --extra-db-filename e...", 1], ["sleep 60 # Give PyPI time to make the new release available\ndocker login -u $DOC...", 1], ["sqlite-utils github.db \"select full_name from repos where owner = 53015001 union...", 1]] |
steps,uses | steps | uses | 262 | 119 | 0 | 18 | [["None", 119], ["actions/checkout@v2", 33], ["actions/cache@v2", 25], ["actions/setup-python@v2", 23], ["actions/checkout@v3", 18], ["actions/setup-python@v4", 17], ["actions/cache@v3", 7], ["google-github-actions/setup-gcloud@v0", 3], ["actions/setup-python@v1", 2], ["actions/cache@v1", 2]] | [["actions/setup-python@v3", 1], ["actions/upload-artifact@v2", 1], ["github/codeql-action/analyze@v1", 1], ["github/codeql-action/autobuild@v1", 1], ["github/codeql-action/init@v1", 1], ["actions/setup-python@v1", 2], ["codecov/codecov-action@v1", 2], ["mxschmitt/action-tmate@v3", 2], ["readthedocs/actions/preview@v1", 2], ["zofrex/mirror-branch@ea152f124954fa4eb26eea3fe0dbe313a3a08d94", 2]] |
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]] |
_analyze_tables_,most_common | _analyze_tables_ | most_common | 350 | 85 | 0 | 206 | [["None", 85], ["[[\"None\", 1329]]", 12], ["[[4, 1]]", 10], ["[[\"version\", 1]]", 10], ["[[\"fineheard\", 2], [\"0nyr\", 1], [\"0nebody\", 1], [\"0ndrec\", 1], [\"0ihsan\", 1], [\"...", 4], ["[[2, 1]]", 3], ["[[1, 1]]", 3], ["[[0, 952], [1, 138], [2, 57], [3, 34], [5, 15], [4, 15], [7, 12], [6, 10], [12, ...", 3], ["[[\"b''\", 1]]", 3], ["[[\"\", 21], [\"The first Datasette 1.0 alpha release.\", 1], [\"None\", 1], [\"Just ad...", 2]] | [["[[9599, 1991], [49699333, 70], [536941, 32], [45057, 26], [27856297, 22], [25778...", 1], ["[[9599, 1]]", 1], ["[[9599, 2926], [19864447, 839], [\"None\", 8], [21148, 6], [45057, 5]]", 1], ["[[9599, 344]]", 1], ["[[9599, 34]]", 1], ["[[9599, 3540], [49699333, 48], [45057, 20], [27856297, 17], [\"None\", 8], [21148,...", 1], ["[[9599, 8456], [22429695, 204], [536941, 79], [25778, 70], [45057, 39], [82988, ...", 1], ["[[971057476, 3], [853484980, 2], [817257851, 2], [804924636, 2], [700944644, 2],...", 1], ["[[null, 1]]", 1], ["[[null, 9947]]", 1]] |
jobs,if | jobs | if | 54 | 52 | 0 | 1 | [["None", 54]] | |
steps,name | steps | name | 262 | 47 | 0 | 52 | [["None", 47], ["Install dependencies", 39], ["Configure pip caching", 32], ["Set up Python ${{ matrix.python-version }}", 25], ["Run tests", 25], ["Set up Python", 16], ["Publish", 11], ["Check out repo", 5], ["Install Python dependencies", 4], ["Set up Cloud Run", 3]] | [["Optionally install numpy", 1], ["Perform CodeQL Analysis", 1], ["Run prettier", 1], ["Run test", 1], ["Set up Python 3.10", 1], ["Set up Python 3.11", 1], ["Set up the alternate-route demo", 1], ["Test with pytest", 1], ["run flake8 if Python 3.8 or higher", 1], ["run mypy", 1]] |
jobs,needs | jobs | needs | 54 | 41 | 0 | 2 | [["None", 41], ["[\"test\"]", 11], ["[\"deploy\"]", 2]] | |
workflows,env | workflows | env | 41 | 40 | 0 | 1 | [["None", 41]] | |
milestones,due_on | milestones | due_on | 34 | 31 | 0 | 3 | [["None", 31], ["2019-07-07T07:00:00Z", 1], ["2019-05-19T07:00:00Z", 1], ["2017-11-13T08:00:00Z", 1]] | |
jobs,strategy | jobs | strategy | 54 | 30 | 0 | 7 | [["None", 30], ["{\"matrix\": {\"python-version\": [3.6, 3.7, 3.8, 3.9]}}", 10], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\"]}}", 6], ["{\"matrix\": {\"python-version\": [\"3.8\", \"3.9\", \"3.10\", \"3.11\"]}}", 4], ["{\"matrix\": {\"python-version\": [3.7, 3.8]}}", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\"], \"os\": [\"ubu...", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\"], \"numpy\": [0...", 1], ["{\"fail-fast\": false, \"matrix\": {\"language\": [\"python\"]}}", 1]] | |
workflows,permissions | workflows | permissions | 41 | 25 | 0 | 2 | [["None", 25], ["{\"contents\": \"read\"}", 14], ["{\"pull-requests\": \"write\"}", 2]] | |
labels,description | labels | description | 103 | 14 | 46 | 13 | [["", 46], ["None", 14], ["New feature or request", 13], ["Something isn't working", 11], ["Improvements or additions to documentation", 8], ["This doesn't seem right", 2], ["Extra attention is needed", 2], ["Minor bugs (not high priority)", 1], ["Further information is requested", 1], ["Awaiting something else to happen first", 1]] | [["Awaiting something else to happen first", 1], ["Further information is requested", 1], ["Minor bugs (not high priority)", 1], ["Pull requests that update a dependency file", 1], ["The official Docker image, plus other things related to running Datasette on Doc...", 1], ["This issue or pull request already exists", 1], ["This will not be worked on", 1], ["Extra attention is needed", 2], ["This doesn't seem right", 2], ["Improvements or additions to documentation", 8]] |
labels_fts,description | labels_fts | description | 103 | 14 | 46 | 13 | [["", 46], ["None", 14], ["New feature or request", 13], ["Something isn't working", 11], ["Improvements or additions to documentation", 8], ["This doesn't seem right", 2], ["Extra attention is needed", 2], ["Minor bugs (not high priority)", 1], ["Further information is requested", 1], ["Awaiting something else to happen first", 1]] | [["Awaiting something else to happen first", 1], ["Further information is requested", 1], ["Minor bugs (not high priority)", 1], ["Pull requests that update a dependency file", 1], ["The official Docker image, plus other things related to running Datasette on Doc...", 1], ["This issue or pull request already exists", 1], ["This will not be worked on", 1], ["Extra attention is needed", 2], ["This doesn't seem right", 2], ["Improvements or additions to documentation", 8]] |
issues,body | issues | body | 2892 | 13 | 99 | 2778 | [["", 99], ["None", 13], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\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]] | [["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,body | issues_fts | body | 2892 | 13 | 99 | 2778 | [["", 99], ["None", 13], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\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]] | [["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]] |
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_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]] |
commits,author | commits | author | 3784 | 8 | 0 | 107 | [[9599, 3540], [49699333, 48], [45057, 20], [27856297, 17], ["None", 8], [21148, 7], [198537, 6], [25778, 6], [3243482, 5], [2657547, 5]] | [[16001974, 1], [17075617, 1], [22578954, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [56323389, 1], [72577720, 1], [99098079, 1]] |
commits,committer | commits | committer | 3784 | 8 | 0 | 4 | [[9599, 2926], [19864447, 839], ["None", 8], [21148, 6], [45057, 5]] | |
milestones,closed_at | milestones | closed_at | 34 | 5 | 0 | 29 | [["None", 5], ["2020-03-25T04:07:02Z", 1], ["2019-07-08T03:36:57Z", 1], ["2019-05-25T01:28:06Z", 1], ["2019-05-19T22:24:03Z", 1], ["2018-06-21T15:47:15Z", 1], ["2017-12-10T02:05:05Z", 1], ["2017-11-30T16:49:38Z", 1], ["2017-11-14T08:27:33Z", 1], ["2017-11-14T08:24:21Z", 1]] | [["2020-11-29T02:43:04Z", 1], ["2022-01-10T19:25:44Z", 1], ["2022-01-11T18:41:13Z", 1], ["2022-01-13T22:22:24Z", 1], ["2022-01-14T01:44:41Z", 1], ["2022-08-14T18:03:28Z", 1], ["2022-10-18T18:26:45Z", 1], ["2022-11-29T20:11:39Z", 1], ["2022-12-02T01:24:26Z", 1], ["2022-12-20T20:01:13Z", 1]] |
issues,reactions | issues | reactions | 2892 | 2 | 0 | 2890 | [["None", 2], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/5/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/4/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/3/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/2/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/13/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/12/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/11/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/10/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/1/re...", 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]] |
licenses,url | licenses | url | 16 | 1 | 0 | 15 | [["https://api.github.com/licenses/gpl-2.0", 1], ["https://api.github.com/licenses/eupl-1.2", 1], ["https://api.github.com/licenses/cc0-1.0", 1], ["https://api.github.com/licenses/cc-by-4.0", 1], ["https://api.github.com/licenses/bsd-3-clause-clear", 1], ["https://api.github.com/licenses/bsd-3-clause", 1], ["https://api.github.com/licenses/bsd-2-clause", 1], ["https://api.github.com/licenses/apache-2.0", 1], ["https://api.github.com/licenses/agpl-3.0", 1], ["None", 1]] | [["https://api.github.com/licenses/cc-by-4.0", 1], ["https://api.github.com/licenses/cc0-1.0", 1], ["https://api.github.com/licenses/eupl-1.2", 1], ["https://api.github.com/licenses/gpl-2.0", 1], ["https://api.github.com/licenses/gpl-3.0", 1], ["https://api.github.com/licenses/lgpl-2.1", 1], ["https://api.github.com/licenses/mit", 1], ["https://api.github.com/licenses/mpl-2.0", 1], ["https://api.github.com/licenses/unlicense", 1], ["https://api.github.com/licenses/wtfpl", 1]] |
milestones,description | milestones | description | 34 | 1 | 21 | 13 | [["", 21], ["The first Datasette 1.0 alpha release.", 1], ["None", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["First version where you can browse via foreign key relationships.", 1], ["Bugfix release for 0.23. Shipped: https://pypi.org/project/datasette/0.23.1/", 1], ["Big new features in this release are ASGI support, new plugin hooks for ASGI and...", 1], ["Ability to fully customize the HTML templates used to display datasette data.", 1], ["A new visual design, plugin hooks for adding navigation options, better handling...", 1], ["0.15 is already pretty stable - a few small fixes and I'm going to ship 1.0.", 1]] | [["Ability to fully customize the HTML templates used to display datasette data.", 1], ["Big new features in this release are ASGI support, new plugin hooks for ASGI and...", 1], ["Bugfix release for 0.23. Shipped: https://pypi.org/project/datasette/0.23.1/", 1], ["First version where you can browse via foreign key relationships.", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["The first Datasette 1.0 alpha release.", 1], ["The new Datasette Write API.", 1], ["Writeable canned queries, authentication and permissions. [Changelog](https://da...", 1], ["https://github.com/simonw/datasette/issues/519 - stable JSON API, documented tem...", 1], ["https://simonwillison.net/2019/May/19/datasette-0-28/", 1]] |
milestones_fts,description | milestones_fts | description | 34 | 1 | 21 | 13 | [["", 21], ["The first Datasette 1.0 alpha release.", 1], ["None", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["First version where you can browse via foreign key relationships.", 1], ["Bugfix release for 0.23. Shipped: https://pypi.org/project/datasette/0.23.1/", 1], ["Big new features in this release are ASGI support, new plugin hooks for ASGI and...", 1], ["Ability to fully customize the HTML templates used to display datasette data.", 1], ["A new visual design, plugin hooks for adding navigation options, better handling...", 1], ["0.15 is already pretty stable - a few small fixes and I'm going to ship 1.0.", 1]] | [["Ability to fully customize the HTML templates used to display datasette data.", 1], ["Big new features in this release are ASGI support, new plugin hooks for ASGI and...", 1], ["Bugfix release for 0.23. Shipped: https://pypi.org/project/datasette/0.23.1/", 1], ["First version where you can browse via foreign key relationships.", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["The first Datasette 1.0 alpha release.", 1], ["The new Datasette Write API.", 1], ["Writeable canned queries, authentication and permissions. [Changelog](https://da...", 1], ["https://github.com/simonw/datasette/issues/519 - stable JSON API, documented tem...", 1], ["https://simonwillison.net/2019/May/19/datasette-0-28/", 1]] |
pull_requests,merge_commit_sha | pull_requests | merge_commit_sha | 560 | 1 | 0 | 559 | [["None", 1], ["0499f174c063283aa9b589d475a32077aaf7adc5", 1], ["03cc697b6b3d0983618c29ee75b45b5e0ac91139", 1], ["03b35d70e281ea48bd9b8058738ed87b13cea2de", 1], ["02f5c4d69d7b4baebde015c56e5bc62923f33314", 1], ["025b4024b1b43ea034b7fd331c30740165ff75f2", 1], ["022cdd97a9ddab1a152e23e1e1c42e78c1ed0fa9", 1], ["01369176b0a8943ab45292ffc6f9c929b80a00e8", 1], ["013496862f4d4b441ab61255242b838b24287607", 1], ["00e59ec461dc0150772b999c7cc15fcb9b507d58", 1]] | [["f8ffac8787e299a62c99ed1ce914cd5ace84ad94", 1], ["f92d823766872a6fd7e76c5249a6b2de1ab0f447", 1], ["f96e55bce55d26c4d5b198edc536e1b8e9bbea43", 1], ["f99a23652910b03ac4669bbbb35a9b484451aabb", 1], ["fb3abeceb2785a582d2c120c7c1bf7dc3cd1de05", 1], ["fb57d4474cb1fdaef260e244b1b6f470f1992e40", 1], ["fc3660cfad7668dbce6ead12766e048fc1f78b11", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fda4dad23a0494890267fbe8baf179e2b56ee914", 1], ["ffff3a4c5398a9f40b61d59736f386444da19289", 1]] |
assets,label | assets | label | 1 | 1 | 0 | 0 | [[null, 1]] | |
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]] |
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]) );