_analyze_tables_
336 rows where num_blank = 0 sorted by least_common
This data as json, CSV (advanced)
Link | table | column | total_rows | num_null | num_blank | num_distinct | most_common | least_common ▼ |
---|---|---|---|---|---|---|---|---|
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,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]] | |
repos,id | repos | id | 1329 | 0 | 0 | 1329 | ||
repos,node_id | repos | node_id | 1329 | 0 | 0 | 1329 | ||
repos,full_name | repos | full_name | 1329 | 0 | 0 | 1329 | ||
repos,private | repos | private | 1329 | 0 | 0 | 1 | [[0, 1329]] | |
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,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,disabled | repos | disabled | 1329 | 0 | 0 | 1 | [[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,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,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,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,is_template | repos | is_template | 1329 | 548 | 0 | 2 | [[0, 773], ["None", 548], [1, 8]] | |
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,web_commit_signoff_required | repos | web_commit_signoff_required | 1329 | 770 | 0 | 2 | [["None", 770], [0, 552], [1, 7]] | |
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,has_discussions | repos | has_discussions | 1329 | 884 | 0 | 2 | [["None", 884], [0, 441], [1, 4]] | |
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]] | |
licenses,key | licenses | key | 16 | 0 | 0 | 16 | ||
licenses,name | licenses | name | 16 | 0 | 0 | 16 | ||
licenses,spdx_id | licenses | spdx_id | 16 | 0 | 0 | 16 | ||
licenses,node_id | licenses | node_id | 16 | 0 | 0 | 16 | ||
licenses_fts_data,id | licenses_fts_data | id | 3 | 0 | 0 | 3 | ||
licenses_fts_data,block | licenses_fts_data | block | 3 | 0 | 0 | 3 | ||
licenses_fts_idx,segid | licenses_fts_idx | segid | 1 | 0 | 0 | 1 | [[1, 1]] | |
licenses_fts_idx,term | licenses_fts_idx | term | 1 | 0 | 0 | 1 | [["b''", 1]] | |
licenses_fts_idx,pgno | licenses_fts_idx | pgno | 1 | 0 | 0 | 1 | [[2, 1]] | |
licenses_fts_docsize,id | licenses_fts_docsize | id | 16 | 0 | 0 | 16 | ||
licenses_fts_docsize,sz | licenses_fts_docsize | sz | 16 | 0 | 0 | 7 | [["b'\\x06'", 5], ["b'\\x07'", 3], ["b'\\x05'", 3], ["b'\\x02'", 2], ["b'\\x04'", 1], ["b'\\x01'", 1], ["b'\\n'", 1]] | |
licenses_fts_config,k | licenses_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
licenses_fts_config,v | licenses_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
repos_fts_data,id | repos_fts_data | id | 25 | 0 | 0 | 25 | ||
repos_fts_data,block | repos_fts_data | block | 25 | 0 | 0 | 25 | ||
repos_fts_idx,segid | repos_fts_idx | segid | 23 | 0 | 0 | 1 | [[1, 23]] | |
repos_fts_idx,term | repos_fts_idx | term | 23 | 0 | 0 | 23 | ||
repos_fts_idx,pgno | repos_fts_idx | pgno | 23 | 0 | 0 | 23 | ||
repos_fts_docsize,id | repos_fts_docsize | id | 1329 | 0 | 0 | 1329 | ||
repos_fts_config,k | repos_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
repos_fts_config,v | repos_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
users_fts_data,id | users_fts_data | id | 50 | 0 | 0 | 50 | ||
users_fts_data,block | users_fts_data | block | 50 | 0 | 0 | 50 | ||
users_fts_idx,segid | users_fts_idx | segid | 48 | 0 | 0 | 1 | [[1, 48]] | |
users_fts_idx,term | users_fts_idx | term | 48 | 0 | 0 | 48 | ||
users_fts_idx,pgno | users_fts_idx | pgno | 48 | 0 | 0 | 48 | ||
users_fts_docsize,id | users_fts_docsize | id | 10621 | 0 | 0 | 10621 | ||
users_fts_docsize,sz | users_fts_docsize | sz | 10621 | 0 | 0 | 6 | [["b'\\x01\\x01'", 9901], ["b'\\x02\\x02'", 650], ["b'\\x03\\x03'", 60], ["b'\\x04\\x04'", 6], ["b'\\x05\\x05'", 3], ["b'\\x06\\x06'", 1]] | |
users_fts_config,k | users_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
users_fts_config,v | users_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
licenses_fts,name | licenses_fts | name | 16 | 0 | 0 | 16 | ||
raw_authors,id | raw_authors | id | 114 | 0 | 0 | 114 | ||
commits,sha | commits | sha | 3784 | 0 | 0 | 3784 | ||
commits,raw_committer | commits | raw_committer | 3784 | 0 | 0 | 6 | [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2679], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 839], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]] | |
commits,committer | commits | committer | 3784 | 8 | 0 | 4 | [[9599, 2926], [19864447, 839], ["None", 8], [21148, 6], [45057, 5]] | |
commits_fts_data,id | commits_fts_data | id | 45 | 0 | 0 | 45 | ||
commits_fts_data,block | commits_fts_data | block | 45 | 0 | 0 | 45 | ||
commits_fts_idx,segid | commits_fts_idx | segid | 43 | 0 | 0 | 1 | [[1, 43]] | |
commits_fts_idx,term | commits_fts_idx | term | 43 | 0 | 0 | 43 | ||
commits_fts_idx,pgno | commits_fts_idx | pgno | 43 | 0 | 0 | 43 | ||
commits_fts_docsize,id | commits_fts_docsize | id | 3784 | 0 | 0 | 3784 | ||
commits_fts_config,k | commits_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
commits_fts_config,v | commits_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
milestones,id | milestones | id | 34 | 0 | 0 | 34 | ||
milestones,creator | milestones | creator | 34 | 0 | 0 | 1 | [[9599, 34]] | |
milestones,repo | milestones | repo | 34 | 0 | 0 | 4 | [[107914493, 25], [140912432, 7], [256834907, 1], [207052882, 1]] | |
milestones,html_url | milestones | html_url | 34 | 0 | 0 | 34 | ||
milestones,node_id | milestones | node_id | 34 | 0 | 0 | 34 | ||
milestones,open_issues | milestones | open_issues | 34 | 0 | 0 | 6 | [[0, 29], [52, 1], [18, 1], [9, 1], [2, 1], [1, 1]] | |
milestones,state | milestones | state | 34 | 0 | 0 | 2 | [["closed", 29], ["open", 5]] | |
milestones,created_at | milestones | created_at | 34 | 0 | 0 | 34 | ||
milestones,updated_at | milestones | updated_at | 34 | 0 | 0 | 34 | ||
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]] | |
milestones_fts_data,id | milestones_fts_data | id | 3 | 0 | 0 | 3 | ||
milestones_fts_data,block | milestones_fts_data | block | 3 | 0 | 0 | 3 | ||
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_docsize,id | milestones_fts_docsize | id | 34 | 0 | 0 | 34 | ||
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,id | issues | id | 2892 | 0 | 0 | 2892 |
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]) );