_analyze_tables_
350 rows 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 ▼ |
---|---|---|---|---|---|---|---|---|
milestones_fts_data,block | milestones_fts_data | block | 3 | 0 | 0 | 3 | ||
milestones_fts_data,id | milestones_fts_data | id | 3 | 0 | 0 | 3 | ||
milestones_fts_docsize,id | milestones_fts_docsize | id | 34 | 0 | 0 | 34 | ||
milestones_fts_idx,pgno | milestones_fts_idx | pgno | 1 | 0 | 0 | 1 | [[2, 1]] | |
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]] | |
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,created_at | pull_requests | created_at | 560 | 0 | 0 | 560 | ||
pull_requests,draft | pull_requests | draft | 560 | 0 | 0 | 2 | [[0, 550], [1, 10]] | |
pull_requests,head | pull_requests | head | 560 | 0 | 0 | 560 | ||
pull_requests,id | pull_requests | id | 560 | 0 | 0 | 560 | ||
pull_requests,locked | pull_requests | locked | 560 | 0 | 0 | 1 | [[0, 560]] | |
pull_requests,merged_by | pull_requests | merged_by | 560 | 560 | 0 | 0 | [[null, 560]] | |
pull_requests,node_id | pull_requests | node_id | 560 | 0 | 0 | 560 | ||
pull_requests,state | pull_requests | state | 560 | 0 | 0 | 2 | [["closed", 470], ["open", 90]] | |
pull_requests,url | pull_requests | url | 560 | 0 | 0 | 560 | ||
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_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_docsize,id | pull_requests_fts_docsize | id | 560 | 0 | 0 | 560 | ||
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 | ||
raw_authors,email | raw_authors | 114 | 0 | 114 | 1 | [["", 114]] | ||
raw_authors,id | raw_authors | id | 114 | 0 | 0 | 114 | ||
releases,author | releases | author | 344 | 0 | 0 | 1 | [[9599, 344]] | |
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,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,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]] | |
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_data,block | releases_fts_data | block | 47 | 0 | 0 | 47 | ||
releases_fts_data,id | releases_fts_data | id | 47 | 0 | 0 | 47 | ||
releases_fts_docsize,id | releases_fts_docsize | id | 344 | 0 | 0 | 344 | ||
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 | ||
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,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_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,disabled | repos | disabled | 1329 | 0 | 0 | 1 | [[0, 1329]] | |
repos,fork | repos | fork | 1329 | 0 | 0 | 2 | [[0, 1201], [1, 128]] | |
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,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,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,node_id | repos | node_id | 1329 | 0 | 0 | 1329 | ||
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,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,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,temp_clone_token | repos | temp_clone_token | 1329 | 0 | 1329 | 1 | [["", 1329]] | |
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,web_commit_signoff_required | repos | web_commit_signoff_required | 1329 | 770 | 0 | 2 | [["None", 770], [0, 552], [1, 7]] | |
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]] | |
repos_fts_data,block | repos_fts_data | block | 25 | 0 | 0 | 25 | ||
repos_fts_data,id | repos_fts_data | id | 25 | 0 | 0 | 25 | ||
repos_fts_docsize,id | repos_fts_docsize | id | 1329 | 0 | 0 | 1329 | ||
repos_fts_idx,pgno | repos_fts_idx | pgno | 23 | 0 | 0 | 23 | ||
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 | ||
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]] | |
steps,id | steps | id | 262 | 0 | 0 | 262 | ||
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]] | |
tags,sha | tags | sha | 368 | 0 | 0 | 368 | ||
users,avatar_url | users | avatar_url | 10621 | 0 | 0 | 10621 | ||
users,gravatar_id | users | gravatar_id | 10621 | 0 | 10621 | 1 | [["", 10621]] | |
users,id | users | id | 10621 | 0 | 0 | 10621 | ||
users,node_id | users | node_id | 10621 | 0 | 0 | 10621 | ||
users,site_admin | users | site_admin | 10621 | 0 | 0 | 2 | [[0, 10597], [1, 24]] | |
users,type | users | type | 10621 | 0 | 0 | 3 | [["User", 10489], ["Organization", 129], ["Bot", 3]] | |
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]] | |
users_fts_data,block | users_fts_data | block | 50 | 0 | 0 | 50 |
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]) );