_analyze_tables_

Table actions

340 rows sorted by most_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,html_url users html_url 7727 0 0 7727    
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,html_url repos html_url 752 0 0 752    
repos,created_at repos created_at 752 0 0 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_docsize,id licenses_fts_docsize id 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    
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    
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,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    
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    
commits,sha commits sha 3284 0 0 3284    
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,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    
milestones,id milestones id 28 0 0 28    
milestones,html_url milestones html_url 28 0 0 28    
milestones,node_id milestones node_id 28 0 0 28    
milestones,created_at milestones created_at 28 0 0 28    
milestones,updated_at milestones updated_at 28 0 0 28    
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_docsize,id milestones_fts_docsize id 28 0 0 28    
issues,id issues id 2361 0 0 2361    
issues,node_id issues node_id 2361 0 0 2361    
issues,created_at issues created_at 2361 0 0 2361    
issues_fts_data,id issues_fts_data id 325 0 0 325    
issues_fts_data,block issues_fts_data block 325 0 0 325    
issues_fts_docsize,id issues_fts_docsize id 2361 0 0 2361    
releases,html_url releases html_url 315 0 0 315    
releases,id releases id 315 0 0 315    
releases,node_id releases node_id 315 0 0 315    
releases,created_at releases created_at 315 0 0 315    
releases,published_at releases published_at 315 0 0 315    
releases_fts_data,id releases_fts_data id 40 0 0 40    
releases_fts_data,block releases_fts_data block 40 0 0 40    
releases_fts_idx,term releases_fts_idx term 38 0 0 38    
releases_fts_idx,pgno releases_fts_idx pgno 38 0 0 38    
releases_fts_docsize,id releases_fts_docsize id 315 0 0 315    
labels,id labels id 94 0 0 94    
labels,node_id labels node_id 94 0 0 94    
labels,url labels url 94 0 0 94    
labels_fts_data,id labels_fts_data id 3 0 0 3    
labels_fts_data,block labels_fts_data block 3 0 0 3    
labels_fts_docsize,id labels_fts_docsize id 94 0 0 94    
issue_comments,html_url issue_comments html_url 7896 0 0 7896    
issue_comments,id issue_comments id 7896 0 0 7896    
issue_comments,node_id issue_comments node_id 7896 0 0 7896    
issue_comments_fts_data,id issue_comments_fts_data id 523 0 0 523    
issue_comments_fts_data,block issue_comments_fts_data block 523 0 0 523    
issue_comments_fts_docsize,id issue_comments_fts_docsize id 7896 0 0 7896    
dependents,first_seen_utc dependents first_seen_utc 950 0 0 950    
tags,sha tags sha 339 0 0 339    
emojis,name emojis name 1874 0 0 1874    
workflows,id workflows id 33 0 0 33    
jobs,id jobs id 44 0 0 44    
steps,id steps id 225 0 0 225    
pull_requests,id pull_requests id 433 0 0 433    
pull_requests,node_id pull_requests node_id 433 0 0 433    
pull_requests,created_at pull_requests created_at 433 0 0 433    
pull_requests,merge_commit_sha pull_requests merge_commit_sha 433 0 0 433    
pull_requests,head pull_requests head 433 0 0 433    
pull_requests,url pull_requests url 433 0 0 433    
pull_requests_fts_data,id pull_requests_fts_data id 85 0 0 85    
pull_requests_fts_data,block pull_requests_fts_data block 85 0 0 85    
pull_requests_fts_idx,term pull_requests_fts_idx term 83 0 0 83    
pull_requests_fts_idx,pgno pull_requests_fts_idx pgno 83 0 0 83    
pull_requests_fts_docsize,id pull_requests_fts_docsize id 433 0 0 433    
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_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]]
labels,description labels description 94 14 41 13 [["", 41], ["None", 14], ["New feature or request", 12], ["Something isn't working", 9], ["Improvements or additions to documentation", 7], ["This doesn't seem right", 2], ["Extra attention is needed", 2], ["Minor bugs (not high priority)", 1], ["Further information is requested", 1], ["Awaiting something else to happen first", 1]] [["Awaiting something else to happen first", 1], ["Further information is requested", 1], ["Minor bugs (not high priority)", 1], ["Pull requests that update a dependency file", 1], ["The official Docker image, plus other things related to running Datasette on Doc...", 1], ["This issue or pull request already exists", 1], ["This will not be worked on", 1], ["Extra attention is needed", 2], ["This doesn't seem right", 2], ["Improvements or additions to documentation", 7]]
labels_fts,description labels_fts description 94 14 41 13 [["", 41], ["None", 14], ["New feature or request", 12], ["Something isn't working", 9], ["Improvements or additions to documentation", 7], ["This doesn't seem right", 2], ["Extra attention is needed", 2], ["Minor bugs (not high priority)", 1], ["Further information is requested", 1], ["Awaiting something else to happen first", 1]] [["Awaiting something else to happen first", 1], ["Further information is requested", 1], ["Minor bugs (not high priority)", 1], ["Pull requests that update a dependency file", 1], ["The official Docker image, plus other things related to running Datasette on Doc...", 1], ["This issue or pull request already exists", 1], ["This will not be worked on", 1], ["Extra attention is needed", 2], ["This doesn't seem right", 2], ["Improvements or additions to documentation", 7]]
pull_requests,body pull_requests body 433 6 54 373 [["", 54], ["None", 6], ["Refs #744", 2], ["**NOTE: I don't think this PR is ready, since the arm/v6 and arm/v7 images are f...", 1], ["* Split out view classes from main `app.py`\r\n* Run [black](https://github.com/am...", 1], ["(I discovered this trawling the issues for how to use --since with favorites)", 1], ["### Description\r\nHi :wave: I work at [DeepSource](https://deepsource.io), I ran ...", 1], ["## Description\r\n\r\nProposing a solution to the API limitation for `merged_by` in ...", 1], ["\r\n\r\nRefs #90 ", 1], ["\r\n\r\nDeletes all rows in the table (if it exists) before inserting new rows.\r\nSQL...", 1]] [["https://travis-ci.org/simonw/datasette/jobs/305929426\r\n\r\n pkg_resources.Versi...", 1], ["ref #46 \r\n\r\nIssues don't have merge information on them, which means that PRs ne...", 1], ["setup-gcloud will be updating the branch name from master to main in\r\na future r...", 1], ["the `--connection` parameter has become positional", 1], ["the library deal with Postgres type jsonb as dictionary, add dict type as a TEXT...", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["tiny tweak to make this easier to visually parse—I think it matches your style i...", 1], ["to keep the data write from failing if it came across an error during processing...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1]]
pull_requests_fts,body pull_requests_fts body 433 6 54 373 [["", 54], ["None", 6], ["Refs #744", 2], ["**NOTE: I don't think this PR is ready, since the arm/v6 and arm/v7 images are f...", 1], ["* Split out view classes from main `app.py`\r\n* Run [black](https://github.com/am...", 1], ["(I discovered this trawling the issues for how to use --since with favorites)", 1], ["### Description\r\nHi :wave: I work at [DeepSource](https://deepsource.io), I ran ...", 1], ["## Description\r\n\r\nProposing a solution to the API limitation for `merged_by` in ...", 1], ["\r\n\r\nRefs #90 ", 1], ["\r\n\r\nDeletes all rows in the table (if it exists) before inserting new rows.\r\nSQL...", 1]] [["https://travis-ci.org/simonw/datasette/jobs/305929426\r\n\r\n pkg_resources.Versi...", 1], ["ref #46 \r\n\r\nIssues don't have merge information on them, which means that PRs ne...", 1], ["setup-gcloud will be updating the branch name from master to main in\r\na future r...", 1], ["the `--connection` parameter has become positional", 1], ["the library deal with Postgres type jsonb as dictionary, add dict type as a TEXT...", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["tiny tweak to make this easier to visually parse—I think it matches your style i...", 1], ["to keep the data write from failing if it came across an error during processing...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1]]
repos,temp_clone_token repos temp_clone_token 752 0 752 1 [["", 752]]  
users,gravatar_id users gravatar_id 7727 0 7727 1 [["", 7727]]  
releases,body releases body 315 0 8 308 [["", 8], ["* Added custom project links to the [PyPI listing](https://pypi.org/project/sqli...", 1], ["* Added `github-to-sqlite repos` command, #3 ", 1], ["* Added `followers-ids` and `friends-ids` subcommands", 1], ["* Added `--since_id` and `--since` to `user-timeline` command, refs #20\r\n* `--si...", 1], ["* Added --since option, closes #3 ", 1], ["* favorites command now populates `favorited_by` table - #14 \r\n* favorites `--...", 1], ["### Plugins and internals\r\n\r\n- New plugin hook: [filters_from_request(request,...", 1], ["# 0.13 (2017-11-24)\r\n\r\n - Search now applies to current filters.\r\n \r\n Com...", 1], [" - Better mechanism for handling errors; 404s for missing table/database\r\n \r...", 1]] [["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-1", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-3", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7-1", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-10", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-11", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-8", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-9", 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])
);