_analyze_tables_

Table actions

340 rows sorted by total_rows

✎ 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
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_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_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]]  
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_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_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_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]]  
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,label assets label 1 1 0 0 [["None", 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]]  
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_fts_data,id milestones_fts_data id 3 0 0 3    
milestones_fts_data,block milestones_fts_data block 3 0 0 3    
labels_fts_data,id labels_fts_data id 3 0 0 3    
labels_fts_data,block labels_fts_data block 3 0 0 3    
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,url licenses url 14 1 0 13 [["https://api.github.com/licenses/gpl-3.0", 1], ["https://api.github.com/licenses/gpl-2.0", 1], ["https://api.github.com/licenses/eupl-1.2", 1], ["https://api.github.com/licenses/cc0-1.0", 1], ["https://api.github.com/licenses/cc-by-4.0", 1], ["https://api.github.com/licenses/bsd-3-clause", 1], ["https://api.github.com/licenses/bsd-2-clause", 1], ["https://api.github.com/licenses/apache-2.0", 1], ["https://api.github.com/licenses/agpl-3.0", 1], ["None", 1]] [["https://api.github.com/licenses/bsd-3-clause", 1], ["https://api.github.com/licenses/cc-by-4.0", 1], ["https://api.github.com/licenses/cc0-1.0", 1], ["https://api.github.com/licenses/eupl-1.2", 1], ["https://api.github.com/licenses/gpl-2.0", 1], ["https://api.github.com/licenses/gpl-3.0", 1], ["https://api.github.com/licenses/lgpl-2.1", 1], ["https://api.github.com/licenses/mit", 1], ["https://api.github.com/licenses/unlicense", 1], ["https://api.github.com/licenses/wtfpl", 1]]
licenses,node_id licenses node_id 14 0 0 14    
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]]  
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    
licenses_fts,name licenses_fts name 14 0 0 14    
repos_fts_data,id repos_fts_data id 16 0 0 16    
repos_fts_data,block repos_fts_data block 16 0 0 16    
milestones,id milestones id 28 0 0 28    
milestones,title milestones title 28 0 0 27 [["1.0", 2], ["Custom templates edition", 1], ["Apple Photos online and securely browsable", 1], ["3.21", 1], ["3.0", 1], ["2.20", 1], ["2.19", 1], ["0.51", 1], ["0.28", 1], ["0.23.1", 1]] [["Datasette 0.50", 1], ["Datasette 0.52", 1], ["Datasette 0.54", 1], ["Datasette 0.60", 1], ["Datasette 1.0", 1], ["Datasette 1.0a0", 1], ["Datasette Next", 1], ["Foreign key edition", 1], ["Ship first public release", 1], ["v1 stretch goals", 1]]
milestones,description milestones description 28 0 17 12 [["", 17], ["Writeable canned queries, authentication and permissions. [Changelog](https://da...", 1], ["The first Datasette 1.0 alpha release.", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["First version where you can browse via foreign key relationships.", 1], ["Bugfix release for 0.23. Shipped: https://pypi.org/project/datasette/0.23.1/", 1], ["Big new features in this release are ASGI support, new plugin hooks for ASGI and...", 1], ["Ability to fully customize the HTML templates used to display datasette data.", 1], ["A new visual design, plugin hooks for adding navigation options, better handling...", 1], ["0.15 is already pretty stable - a few small fixes and I'm going to ship 1.0.", 1]] [["A new visual design, plugin hooks for adding navigation options, better handling...", 1], ["Ability to fully customize the HTML templates used to display datasette data.", 1], ["Big new features in this release are ASGI support, new plugin hooks for ASGI and...", 1], ["Bugfix release for 0.23. Shipped: https://pypi.org/project/datasette/0.23.1/", 1], ["First version where you can browse via foreign key relationships.", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["The first Datasette 1.0 alpha release.", 1], ["Writeable canned queries, authentication and permissions. [Changelog](https://da...", 1], ["https://github.com/simonw/datasette/issues/519 - stable JSON API, documented tem...", 1], ["https://simonwillison.net/2019/May/19/datasette-0-28/", 1]]
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,number milestones number 28 0 0 23 [[1, 4], [5, 2], [3, 2], [11, 1], [10, 1], [8, 1], [7, 1], [6, 1], [4, 1], [2, 1]] [[15, 1], [16, 1], [17, 1], [18, 1], [19, 1], [20, 1], [21, 1], [22, 1], [23, 1], [24, 1]]
milestones,open_issues milestones open_issues 28 0 0 5 [[0, 24], [41, 1], [9, 1], [6, 1], [2, 1]]  
milestones,closed_issues milestones closed_issues 28 0 0 19 [[11, 3], [7, 3], [3, 3], [21, 2], [8, 2], [4, 2], [15, 1], [13, 1], [5, 1], [2, 1]] [[15, 1], [16, 1], [19, 1], [22, 1], [24, 1], [25, 1], [39, 1], [49, 1], [53, 1], [57, 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,closed_at milestones closed_at 28 4 0 24 [["None", 4], ["2020-03-25T04:07:02Z", 1], ["2019-07-08T03:36:57Z", 1], ["2019-05-25T01:28:06Z", 1], ["2019-05-19T22:24:03Z", 1], ["2018-06-21T15:47:15Z", 1], ["2017-12-10T02:05:05Z", 1], ["2017-11-30T16:49:38Z", 1], ["2017-11-14T08:27:33Z", 1], ["2017-11-14T08:24:21Z", 1]] [["2020-09-14T22:19:57Z", 1], ["2020-09-22T01:35:48Z", 1], ["2020-10-09T17:53:13Z", 1], ["2020-10-31T22:35:05Z", 1], ["2020-11-06T23:52:09Z", 1], ["2020-11-29T02:43:04Z", 1], ["2022-01-10T19:25:44Z", 1], ["2022-01-11T18:41:13Z", 1], ["2022-01-13T22:22:24Z", 1], ["2022-01-14T01:44:41Z", 1]]
milestones_fts,title milestones_fts title 28 0 0 27 [["1.0", 2], ["Custom templates edition", 1], ["Apple Photos online and securely browsable", 1], ["3.21", 1], ["3.0", 1], ["2.20", 1], ["2.19", 1], ["0.51", 1], ["0.28", 1], ["0.23.1", 1]] [["Datasette 0.50", 1], ["Datasette 0.52", 1], ["Datasette 0.54", 1], ["Datasette 0.60", 1], ["Datasette 1.0", 1], ["Datasette 1.0a0", 1], ["Datasette Next", 1], ["Foreign key edition", 1], ["Ship first public release", 1], ["v1 stretch goals", 1]]
milestones_fts,description milestones_fts description 28 0 17 12 [["", 17], ["Writeable canned queries, authentication and permissions. [Changelog](https://da...", 1], ["The first Datasette 1.0 alpha release.", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["First version where you can browse via foreign key relationships.", 1], ["Bugfix release for 0.23. Shipped: https://pypi.org/project/datasette/0.23.1/", 1], ["Big new features in this release are ASGI support, new plugin hooks for ASGI and...", 1], ["Ability to fully customize the HTML templates used to display datasette data.", 1], ["A new visual design, plugin hooks for adding navigation options, better handling...", 1], ["0.15 is already pretty stable - a few small fixes and I'm going to ship 1.0.", 1]] [["A new visual design, plugin hooks for adding navigation options, better handling...", 1], ["Ability to fully customize the HTML templates used to display datasette data.", 1], ["Big new features in this release are ASGI support, new plugin hooks for ASGI and...", 1], ["Bugfix release for 0.23. Shipped: https://pypi.org/project/datasette/0.23.1/", 1], ["First version where you can browse via foreign key relationships.", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["The first Datasette 1.0 alpha release.", 1], ["Writeable canned queries, authentication and permissions. [Changelog](https://da...", 1], ["https://github.com/simonw/datasette/issues/519 - stable JSON API, documented tem...", 1], ["https://simonwillison.net/2019/May/19/datasette-0-28/", 1]]
milestones_fts_docsize,id milestones_fts_docsize id 28 0 0 28    
milestones_fts_docsize,sz milestones_fts_docsize sz 28 0 0 14 [["b'\\x03\\x00'", 10], ["b'\\x02\\x00'", 6], ["b'\\x03\\x11'", 1], ["b'\\x03\\x0e'", 1], ["b'\\x03\\x0c'", 1], ["b'\\x03\\x07'", 1], ["b'\\x03\\n'", 1], ["b'\\x02\\x1c'", 1], ["b'\\x02\\x12'", 1], ["b'\\x02\\t'", 1]] [["b'\\x02\\x1c'", 1], ["b'\\x03$'", 1], ["b'\\x03\\n'", 1], ["b'\\x03\\x07'", 1], ["b'\\x03\\x0c'", 1], ["b'\\x03\\x0e'", 1], ["b'\\x03\\x11'", 1], ["b'\\x03\\x1a'", 1], ["b'\\x04\\x0e'", 1], ["b'\\x06\\x00'", 1]]
workflows,id workflows id 33 0 0 33    
workflows,filename workflows filename 33 0 0 14 [["test.yml", 10], ["publish.yml", 9], ["test-coverage.yml", 2], ["spellcheck.yml", 2], ["push_docker_tag.yml", 1], ["prettier.yml", 1], ["mirror-master-and-main.yml", 1], ["deploy-latest.yml", 1], ["deploy-demo.yml", 1], ["codeql-analysis.yml", 1]] [["codeql-analysis.yml", 1], ["deploy-demo.yml", 1], ["deploy-latest.yml", 1], ["mirror-master-and-main.yml", 1], ["prettier.yml", 1], ["push_docker_tag.yml", 1], ["readme-toc.yaml", 1], ["readme-toc.yml", 1], ["tmate-mac.yml", 1], ["tmate.yml", 1]]
workflows,name workflows name 33 0 0 14 [["Test", 9], ["Publish Python Package", 9], ["Update README table of contents", 2], ["Check spelling in documentation", 2], ["Calculate test coverage", 2], ["Mirror \"master\" and \"main\" branches", 1], ["Deploy latest.datasette.io", 1], ["CodeQL", 1], ["Check JavaScript for conformance with Prettier", 1], ["Build and deploy demo", 1]] [["Build and deploy demo", 1], ["Check JavaScript for conformance with Prettier", 1], ["CodeQL", 1], ["Deploy latest.datasette.io", 1], ["Mirror \"master\" and \"main\" branches", 1], ["Push specific Docker tag", 1], ["Python package", 1], ["tmate session", 1], ["tmate session mac", 1], ["Update README table of contents", 2]]
workflows,on workflows on 33 0 0 13 [["{\"release\": {\"types\": [\"created\"]}}", 9], ["[\"push\"]", 8], ["[\"push\", \"pull_request\"]", 4], ["{\"workflow_dispatch\": null}", 2], ["{\"push\": {\"branches\": [\"main\"]}, \"pull_request\": {\"branches\": [\"main\"]}}", 2], ["{\"push\": {\"branches\": [\"master\"]}, \"pull_request\": {\"branches\": [\"master\"]}}", 1], ["{\"push\": {\"branches\": [\"master\", \"main\"]}}", 1], ["{\"push\": {\"branches\": [\"main\"]}}", 1], ["{\"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\": \"0 4 * * 5\"}]}", 1], ["{\"push\": {\"branches\": [\"main\", \"master\"], \"paths\": [\"README.md\"]}}", 1]] [["{\"push\": {\"branches\": [\"main\", \"master\"], \"paths\": [\"README.md\"]}}", 1], ["{\"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\": \"0 4 * * 5\"}]}", 1], ["{\"push\": {\"branches\": [\"main\"]}}", 1], ["{\"push\": {\"branches\": [\"master\", \"main\"]}}", 1], ["{\"push\": {\"branches\": [\"master\"]}, \"pull_request\": {\"branches\": [\"master\"]}}", 1], ["{\"workflow_dispatch\": null, \"push\": {\"branches\": [\"main\"], \"paths\": [\"README.md\"...", 1], ["{\"workflow_dispatch\": null, \"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\"...", 1], ["{\"workflow_dispatch\": {\"inputs\": {\"version_tag\": {\"description\": \"Tag to build a...", 1], ["{\"push\": {\"branches\": [\"main\"]}, \"pull_request\": {\"branches\": [\"main\"]}}", 2], ["{\"workflow_dispatch\": null}", 2]]
workflows,repo workflows repo 33 0 0 10 [[107914493, 10], [140912432, 5], [207052882, 4], [206156866, 3], [303218369, 2], [248903544, 2], [205429375, 2], [197882382, 2], [197431109, 2], [256834907, 1]]  
workflows,env workflows env 33 32 0 1 [["None", 33]]  
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_data,id users_fts_data id 37 0 0 37    
users_fts_data,block users_fts_data block 37 0 0 37    
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    
releases_fts_idx,segid releases_fts_idx segid 38 0 0 1 [[1, 38]]  
releases_fts_idx,term releases_fts_idx term 38 0 0 38    
releases_fts_idx,pgno releases_fts_idx pgno 38 0 0 38    
commits_fts_data,id commits_fts_data id 39 0 0 39    
commits_fts_data,block commits_fts_data block 39 0 0 39    

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