_analyze_tables_

Table actions

340 rows sorted by least_common

✎ View and edit SQL

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 ▼
users,login users login 7727 0 0 7727    
users,id users id 7727 0 0 7727    
users,node_id users node_id 7727 0 0 7727    
users,avatar_url users avatar_url 7727 0 0 7727    
users,gravatar_id users gravatar_id 7727 0 7727 1 [["", 7727]]  
users,html_url users html_url 7727 0 0 7727    
users,type users type 7727 0 0 3 [["User", 7643], ["Organization", 81], ["Bot", 3]]  
users,site_admin users site_admin 7727 0 0 2 [[0, 7715], [1, 12]]  
users,name users name 7727 0 0 7727    
repos,id repos id 752 0 0 752    
repos,node_id repos node_id 752 0 0 752    
repos,full_name repos full_name 752 0 0 752    
repos,private repos private 752 0 0 1 [[0, 752]]  
repos,html_url repos html_url 752 0 0 752    
repos,fork repos fork 752 0 0 2 [[0, 720], [1, 32]]  
repos,created_at repos created_at 752 0 0 752    
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,disabled repos disabled 752 0 0 1 [[0, 752]]  
repos,default_branch repos default_branch 752 0 0 9 [["master", 395], ["main", 348], ["develop", 3], ["trunk", 1], ["test", 1], ["new_sql", 1], ["latest", 1], ["dev", 1], ["Main", 1]]  
repos,permissions repos permissions 752 0 0 5 [["{\"admin\": false, \"push\": false, \"pull\": true}", 373], ["{\"admin\": false, \"maintain\": false, \"push\": false, \"triage\": false, \"pull\": true...", 223], ["{\"admin\": true, \"push\": true, \"pull\": true}", 108], ["{\"admin\": true, \"maintain\": true, \"push\": true, \"triage\": true, \"pull\": true}", 47], ["{\"admin\": false, \"push\": true, \"pull\": true}", 1]]  
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,delete_branch_on_merge repos delete_branch_on_merge 752 596 0 2 [["None", 596], [0, 155], [1, 1]]  
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,is_template repos is_template 752 558 0 2 [["None", 558], [0, 193], [1, 1]]  
repos,template_repository repos template_repository 752 741 0 8 [["None", 741], ["{\"id\": 383002759, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzODMwMDI3NTk=\", \"name\": \"templa...", 3], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 401177473, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDExNzc0NzM=\", \"name\": \"click-...", 1], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 1], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 1], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 1]]  
repos,allow_update_branch repos allow_update_branch 752 720 0 1 [["None", 752]]  
licenses,key licenses key 14 0 0 14    
licenses,name licenses name 14 0 0 14    
licenses,spdx_id licenses spdx_id 14 0 0 14    
licenses,node_id licenses node_id 14 0 0 14    
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 14 0 0 14    
licenses_fts_docsize,sz licenses_fts_docsize sz 14 0 0 7 [["b'\\x06'", 5], ["b'\\x07'", 3], ["b'\\x02'", 2], ["b'\\x05'", 1], ["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 16 0 0 16    
repos_fts_data,block repos_fts_data block 16 0 0 16    
repos_fts_idx,segid repos_fts_idx segid 14 0 0 1 [[1, 14]]  
repos_fts_idx,term repos_fts_idx term 14 0 0 14    
repos_fts_idx,pgno repos_fts_idx pgno 14 0 0 14    
repos_fts_docsize,id repos_fts_docsize id 752 0 0 752    
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 37 0 0 37    
users_fts_data,block users_fts_data block 37 0 0 37    
users_fts_idx,segid users_fts_idx segid 35 0 0 1 [[1, 35]]  
users_fts_idx,term users_fts_idx term 35 0 0 35    
users_fts_idx,pgno users_fts_idx pgno 35 0 0 35    
users_fts_docsize,id users_fts_docsize id 7727 0 0 7727    
users_fts_docsize,sz users_fts_docsize sz 7727 0 0 4 [["b'\\x01\\x01'", 7266], ["b'\\x02\\x02'", 421], ["b'\\x03\\x03'", 36], ["b'\\x04\\x04'", 4]]  
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 14 0 0 14    
users_fts,login users_fts login 7727 0 0 7727    
users_fts,name users_fts name 7727 0 0 7727    
raw_authors,id raw_authors id 94 0 0 94    
raw_authors,email raw_authors email 94 0 94 1 [["", 94]]  
commits,sha commits sha 3284 0 0 3284    
commits,raw_committer commits raw_committer 3284 0 0 6 [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2327], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 691], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]]  
commits,committer commits committer 3284 8 0 4 [[9599, 2574], [19864447, 691], ["None", 8], [21148, 6], [45057, 5]]  
commits_fts_data,id commits_fts_data id 39 0 0 39    
commits_fts_data,block commits_fts_data block 39 0 0 39    
commits_fts_idx,segid commits_fts_idx segid 37 0 0 1 [[1, 37]]  
commits_fts_idx,term commits_fts_idx term 37 0 0 37    
commits_fts_idx,pgno commits_fts_idx pgno 37 0 0 37    
commits_fts_docsize,id commits_fts_docsize id 3284 0 0 3284    
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 28 0 0 28    
milestones,creator milestones creator 28 0 0 1 [[9599, 28]]  
milestones,repo milestones repo 28 0 0 4 [[107914493, 21], [140912432, 5], [256834907, 1], [207052882, 1]]  
milestones,html_url milestones html_url 28 0 0 28    
milestones,node_id milestones node_id 28 0 0 28    
milestones,open_issues milestones open_issues 28 0 0 5 [[0, 24], [41, 1], [9, 1], [6, 1], [2, 1]]  
milestones,state milestones state 28 0 0 2 [["closed", 24], ["open", 4]]  
milestones,created_at milestones created_at 28 0 0 28    
milestones,updated_at milestones updated_at 28 0 0 28    
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    
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 28 0 0 28    
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]]  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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])
);