_analyze_tables_
350 rows sorted by num_distinct
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 |
---|---|---|---|---|---|---|---|---|
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]] | |
issue_comments,performed_via_github_app | issue_comments | performed_via_github_app | 9947 | 9947 | 0 | 0 | [[null, 9947]] | |
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]] | |
assets,label | assets | label | 1 | 1 | 0 | 0 | [[null, 1]] | |
users,gravatar_id | users | gravatar_id | 10621 | 0 | 10621 | 1 | [["", 10621]] | |
repos,private | repos | private | 1329 | 0 | 0 | 1 | [[0, 1329]] | |
repos,disabled | repos | disabled | 1329 | 0 | 0 | 1 | [[0, 1329]] | |
repos,temp_clone_token | repos | temp_clone_token | 1329 | 0 | 1329 | 1 | [["", 1329]] | |
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,allow_auto_merge | repos | allow_auto_merge | 1329 | 1229 | 0 | 1 | [["None", 1329]] | |
repos,allow_forking | repos | allow_forking | 1329 | 526 | 0 | 1 | [["None", 1329]] | |
repos,visibility | repos | visibility | 1329 | 543 | 0 | 1 | [["None", 1329]] | |
repos,allow_update_branch | repos | allow_update_branch | 1329 | 1244 | 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,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]] | |
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_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_idx,segid | repos_fts_idx | segid | 23 | 0 | 0 | 1 | [[1, 23]] | |
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_idx,segid | users_fts_idx | segid | 48 | 0 | 0 | 1 | [[1, 48]] | |
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]] | |
raw_authors,email | raw_authors | 114 | 0 | 114 | 1 | [["", 114]] | ||
commits_fts_idx,segid | commits_fts_idx | segid | 43 | 0 | 0 | 1 | [[1, 43]] | |
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,creator | milestones | creator | 34 | 0 | 0 | 1 | [[9599, 34]] | |
milestones_fts_idx,segid | milestones_fts_idx | segid | 1 | 0 | 0 | 1 | [[1, 1]] | |
milestones_fts_idx,term | milestones_fts_idx | term | 1 | 0 | 0 | 1 | [["b''", 1]] | |
milestones_fts_idx,pgno | milestones_fts_idx | pgno | 1 | 0 | 0 | 1 | [[2, 1]] | |
milestones_fts_config,k | milestones_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
milestones_fts_config,v | milestones_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
issues,locked | issues | locked | 2892 | 0 | 0 | 1 | [[0, 2892]] | |
issues_fts_config,k | issues_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
issues_fts_config,v | issues_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
releases,draft | releases | draft | 344 | 0 | 0 | 1 | [[0, 344]] | |
releases,author | releases | author | 344 | 0 | 0 | 1 | [[9599, 344]] | |
releases_fts_idx,segid | releases_fts_idx | segid | 45 | 0 | 0 | 1 | [[1, 45]] | |
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]] | |
labels_fts_idx,segid | labels_fts_idx | segid | 1 | 0 | 0 | 1 | [[1, 1]] | |
labels_fts_idx,term | labels_fts_idx | term | 1 | 0 | 0 | 1 | [["b''", 1]] | |
labels_fts_idx,pgno | labels_fts_idx | pgno | 1 | 0 | 0 | 1 | [[2, 1]] | |
labels_fts_config,k | labels_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
labels_fts_config,v | labels_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
issue_comments_fts_config,k | issue_comments_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
issue_comments_fts_config,v | issue_comments_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
workflows,env | workflows | env | 41 | 40 | 0 | 1 | [["None", 41]] | |
jobs,if | jobs | if | 54 | 52 | 0 | 1 | [["None", 54]] | |
pull_requests,locked | pull_requests | locked | 560 | 0 | 0 | 1 | [[0, 560]] | |
pull_requests_fts_idx,segid | pull_requests_fts_idx | segid | 122 | 0 | 0 | 1 | [[1, 122]] | |
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]] | |
assets,url | assets | url | 1 | 0 | 0 | 1 | [["https://api.github.com/repos/simonw/datasette/releases/assets/30264367", 1]] | |
assets,id | assets | id | 1 | 0 | 0 | 1 | [[30264367, 1]] | |
assets,node_id | assets | node_id | 1 | 0 | 0 | 1 | [["MDEyOlJlbGVhc2VBc3NldDMwMjY0MzY3", 1]] | |
assets,name | assets | name | 1 | 0 | 0 | 1 | [["datasette-0.53-macos-binary.zip", 1]] | |
assets,uploader | assets | uploader | 1 | 0 | 0 | 1 | [[9599, 1]] | |
assets,content_type | assets | content_type | 1 | 0 | 0 | 1 | [["application/zip", 1]] | |
assets,state | assets | state | 1 | 0 | 0 | 1 | [["uploaded", 1]] | |
assets,size | assets | size | 1 | 0 | 0 | 1 | [[8297283, 1]] | |
assets,download_count | assets | download_count | 1 | 0 | 0 | 1 | [[49, 1]] | |
assets,created_at | assets | created_at | 1 | 0 | 0 | 1 | [["2021-01-04T21:26:30Z", 1]] | |
assets,updated_at | assets | updated_at | 1 | 0 | 0 | 1 | [["2021-01-04T21:26:43Z", 1]] | |
assets,browser_download_url | assets | browser_download_url | 1 | 0 | 0 | 1 | [["https://github.com/simonw/datasette/releases/download/0.53/datasette-0.53-macos-...", 1]] | |
assets,release | assets | release | 1 | 0 | 0 | 1 | [[35131848, 1]] | |
users,site_admin | users | site_admin | 10621 | 0 | 0 | 2 | [[0, 10597], [1, 24]] | |
repos,fork | repos | fork | 1329 | 0 | 0 | 2 | [[0, 1201], [1, 128]] | |
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,archived | repos | archived | 1329 | 0 | 0 | 2 | [[0, 1324], [1, 5]] | |
repos,delete_branch_on_merge | repos | delete_branch_on_merge | 1329 | 1120 | 0 | 2 | [["None", 1120], [0, 208], [1, 1]] | |
repos,is_template | repos | is_template | 1329 | 548 | 0 | 2 | [[0, 773], ["None", 548], [1, 8]] | |
repos,web_commit_signoff_required | repos | web_commit_signoff_required | 1329 | 770 | 0 | 2 | [["None", 770], [0, 552], [1, 7]] | |
repos,has_discussions | repos | has_discussions | 1329 | 884 | 0 | 2 | [["None", 884], [0, 441], [1, 4]] | |
milestones,state | milestones | state | 34 | 0 | 0 | 2 | [["closed", 29], ["open", 5]] | |
issues,state | issues | state | 2892 | 0 | 0 | 2 | [["closed", 2144], ["open", 748]] | |
issues,assignee | issues | assignee | 2892 | 2872 | 0 | 2 | [["None", 2872], [9599, 19], [15178711, 1]] | |
issues,type | issues | type | 2892 | 0 | 0 | 2 | [["issue", 2332], ["pull", 560]] | |
issues,draft | issues | draft | 2892 | 2332 | 0 | 2 | [["None", 2332], [0, 550], [1, 10]] | |
releases,prerelease | releases | prerelease | 344 | 0 | 0 | 2 | [[0, 305], [1, 39]] | |
labels,default | labels | default | 103 | 0 | 0 | 2 | [[0, 54], [1, 49]] | |
dependents,repo | dependents | repo | 1658 | 0 | 0 | 2 | [[140912432, 888], [107914493, 770]] | |
workflows,permissions | workflows | permissions | 41 | 25 | 0 | 2 | [["None", 25], ["{\"contents\": \"read\"}", 14], ["{\"pull-requests\": \"write\"}", 2]] | |
jobs,needs | jobs | needs | 54 | 41 | 0 | 2 | [["None", 41], ["[\"test\"]", 11], ["[\"deploy\"]", 2]] | |
pull_requests,state | pull_requests | state | 560 | 0 | 0 | 2 | [["closed", 470], ["open", 90]] |
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]) );