_analyze_tables_
350 rows sorted by least_common descending
This data as json, CSV (advanced)
Link | table | column | total_rows | num_null | num_blank | num_distinct | most_common | least_common ▲ |
---|---|---|---|---|---|---|---|---|
jobs,runs-on | jobs | runs-on | 54 | 0 | 0 | 3 | [["ubuntu-latest", 50], ["macos-latest", 2], ["${{ matrix.os }}", 2]] | |
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]] | |
labels,default | labels | default | 103 | 0 | 0 | 2 | [[0, 54], [1, 49]] | |
labels,id | labels | id | 103 | 0 | 0 | 103 | ||
labels,node_id | labels | node_id | 103 | 0 | 0 | 103 | ||
labels,url | labels | url | 103 | 0 | 0 | 103 | ||
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]] | |
labels_fts_data,block | labels_fts_data | block | 3 | 0 | 0 | 3 | ||
labels_fts_data,id | labels_fts_data | id | 3 | 0 | 0 | 3 | ||
labels_fts_docsize,id | labels_fts_docsize | id | 103 | 0 | 0 | 103 | ||
labels_fts_docsize,sz | labels_fts_docsize | sz | 103 | 0 | 0 | 9 | [["b'\\x01\\x00'", 47], ["b'\\x01\\x04'", 25], ["b'\\x02\\x00'", 11], ["b'\\x01\\x05'", 11], ["b'\\x03\\x00'", 2], ["b'\\x02\\x04'", 2], ["b'\\x01\\x07'", 2], ["b'\\x01\\x06'", 2], ["b'\\x01\\r'", 1]] | |
labels_fts_idx,pgno | labels_fts_idx | pgno | 1 | 0 | 0 | 1 | [[2, 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]] | |
licenses,key | licenses | key | 16 | 0 | 0 | 16 | ||
licenses,name | licenses | name | 16 | 0 | 0 | 16 | ||
licenses,node_id | licenses | node_id | 16 | 0 | 0 | 16 | ||
licenses,spdx_id | licenses | spdx_id | 16 | 0 | 0 | 16 | ||
licenses_fts,name | licenses_fts | name | 16 | 0 | 0 | 16 | ||
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]] | |
licenses_fts_data,block | licenses_fts_data | block | 3 | 0 | 0 | 3 | ||
licenses_fts_data,id | licenses_fts_data | id | 3 | 0 | 0 | 3 | ||
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_idx,pgno | licenses_fts_idx | pgno | 1 | 0 | 0 | 1 | [[2, 1]] | |
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]] | |
milestones,created_at | milestones | created_at | 34 | 0 | 0 | 34 | ||
milestones,creator | milestones | creator | 34 | 0 | 0 | 1 | [[9599, 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,html_url | milestones | html_url | 34 | 0 | 0 | 34 | ||
milestones,id | milestones | id | 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,repo | milestones | repo | 34 | 0 | 0 | 4 | [[107914493, 25], [140912432, 7], [256834907, 1], [207052882, 1]] | |
milestones,state | milestones | state | 34 | 0 | 0 | 2 | [["closed", 29], ["open", 5]] | |
milestones,updated_at | milestones | updated_at | 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]] | |
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]] |
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]) );