_analyze_tables_
340 rows sorted by most_common
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]] |
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]) );