_analyze_tables_
340 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 | 2361 | 2361 | 0 | 0 | [["None", 2361]] | |
| issues,performed_via_github_app | issues | performed_via_github_app | 2361 | 2361 | 0 | 0 | [["None", 2361]] | |
| issue_comments,performed_via_github_app | issue_comments | performed_via_github_app | 7896 | 7896 | 0 | 0 | [["None", 7896]] | |
| pull_requests,merged_by | pull_requests | merged_by | 433 | 433 | 0 | 0 | [["None", 433]] | |
| pull_requests,auto_merge | pull_requests | auto_merge | 433 | 433 | 0 | 0 | [["None", 433]] | |
| assets,label | assets | label | 1 | 1 | 0 | 0 | [["None", 1]] | |
| users,gravatar_id | users | gravatar_id | 7727 | 0 | 7727 | 1 | [["", 7727]] | |
| repos,private | repos | private | 752 | 0 | 0 | 1 | [[0, 752]] | |
| repos,disabled | repos | disabled | 752 | 0 | 0 | 1 | [[0, 752]] | |
| repos,temp_clone_token | repos | temp_clone_token | 752 | 0 | 752 | 1 | [["", 752]] | |
| repos,allow_squash_merge | repos | allow_squash_merge | 752 | 596 | 0 | 1 | [["None", 752]] | |
| repos,allow_merge_commit | repos | allow_merge_commit | 752 | 596 | 0 | 1 | [["None", 752]] | |
| repos,allow_rebase_merge | repos | allow_rebase_merge | 752 | 596 | 0 | 1 | [["None", 752]] | |
| repos,allow_auto_merge | repos | allow_auto_merge | 752 | 705 | 0 | 1 | [["None", 752]] | |
| repos,allow_forking | repos | allow_forking | 752 | 536 | 0 | 1 | [["None", 752]] | |
| repos,visibility | repos | visibility | 752 | 553 | 0 | 1 | [["None", 752]] | |
| repos,allow_update_branch | repos | allow_update_branch | 752 | 720 | 0 | 1 | [["None", 752]] | |
| 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 | 14 | 0 | 0 | 1 | [[1, 14]] | |
| 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 | 35 | 0 | 0 | 1 | [[1, 35]] | |
| 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 | 94 | 0 | 94 | 1 | [["", 94]] | ||
| commits_fts_idx,segid | commits_fts_idx | segid | 37 | 0 | 0 | 1 | [[1, 37]] | |
| 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 | 28 | 0 | 0 | 1 | [[9599, 28]] | |
| 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 | 2361 | 0 | 0 | 1 | [[0, 2361]] | |
| issues,assignee | issues | assignee | 2361 | 2342 | 0 | 1 | [["None", 2361]] | |
| 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 | 315 | 0 | 0 | 1 | [[0, 315]] | |
| releases,author | releases | author | 315 | 0 | 0 | 1 | [[9599, 315]] | |
| releases_fts_idx,segid | releases_fts_idx | segid | 38 | 0 | 0 | 1 | [[1, 38]] | |
| 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 | 33 | 32 | 0 | 1 | [["None", 33]] | |
| jobs,if | jobs | if | 44 | 42 | 0 | 1 | [["None", 44]] | |
| pull_requests,locked | pull_requests | locked | 433 | 0 | 0 | 1 | [[0, 433]] | |
| pull_requests,assignee | pull_requests | assignee | 433 | 431 | 0 | 1 | [["None", 433]] | |
| pull_requests_fts_idx,segid | pull_requests_fts_idx | segid | 83 | 0 | 0 | 1 | [[1, 83]] | |
| 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 | [[36, 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 | 7727 | 0 | 0 | 2 | [[0, 7715], [1, 12]] | |
| repos,fork | repos | fork | 752 | 0 | 0 | 2 | [[0, 720], [1, 32]] | |
| repos,has_issues | repos | has_issues | 752 | 0 | 0 | 2 | [[1, 715], [0, 37]] | |
| repos,has_projects | repos | has_projects | 752 | 0 | 0 | 2 | [[1, 728], [0, 24]] | |
| repos,has_downloads | repos | has_downloads | 752 | 0 | 0 | 2 | [[1, 751], [0, 1]] | |
| repos,has_wiki | repos | has_wiki | 752 | 0 | 0 | 2 | [[1, 726], [0, 26]] | |
| repos,has_pages | repos | has_pages | 752 | 0 | 0 | 2 | [[0, 727], [1, 25]] | |
| repos,archived | repos | archived | 752 | 0 | 0 | 2 | [[0, 751], [1, 1]] | |
| repos,delete_branch_on_merge | repos | delete_branch_on_merge | 752 | 596 | 0 | 2 | [["None", 596], [0, 155], [1, 1]] | |
| repos,is_template | repos | is_template | 752 | 558 | 0 | 2 | [["None", 558], [0, 193], [1, 1]] | |
| milestones,state | milestones | state | 28 | 0 | 0 | 2 | [["closed", 24], ["open", 4]] | |
| issues,state | issues | state | 2361 | 0 | 0 | 2 | [["closed", 1822], ["open", 539]] | |
| issues,type | issues | type | 2361 | 0 | 0 | 2 | [["issue", 1928], ["pull", 433]] | |
| issues,draft | issues | draft | 2361 | 1928 | 0 | 2 | [["None", 1928], [0, 425], [1, 8]] | |
| releases,prerelease | releases | prerelease | 315 | 0 | 0 | 2 | [[0, 283], [1, 32]] | |
| labels,default | labels | default | 94 | 0 | 0 | 2 | [[0, 49], [1, 45]] | |
| dependents,repo | dependents | repo | 950 | 0 | 0 | 2 | [[107914493, 482], [140912432, 468]] | |
| jobs,needs | jobs | needs | 44 | 33 | 0 | 2 | [["None", 33], ["[\"test\"]", 9], ["[\"deploy\"]", 2]] | |
| pull_requests,state | pull_requests | state | 433 | 0 | 0 | 2 | [["closed", 379], ["open", 54]] | |
| pull_requests,draft | pull_requests | draft | 433 | 0 | 0 | 2 | [[0, 425], [1, 8]] | |
| users,type | users | type | 7727 | 0 | 0 | 3 | [["User", 7643], ["Organization", 81], ["Bot", 3]] | |
| licenses_fts_data,id | licenses_fts_data | id | 3 | 0 | 0 | 3 | ||
| licenses_fts_data,block | licenses_fts_data | block | 3 | 0 | 0 | 3 | ||
| milestones,due_on | milestones | due_on | 28 | 25 | 0 | 3 | [["None", 25], ["2019-07-07T07:00:00Z", 1], ["2019-05-19T07:00:00Z", 1], ["2017-11-13T08:00:00Z", 1]] | |
| milestones_fts_data,id | milestones_fts_data | id | 3 | 0 | 0 | 3 | ||
| milestones_fts_data,block | milestones_fts_data | block | 3 | 0 | 0 | 3 |
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]) );