_analyze_tables_

Table actions

350 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,id users id 11453 0 0 11453    
users,node_id users node_id 11453 0 0 11453    
users,avatar_url users avatar_url 11453 0 0 11453    
repos,id repos id 1502 0 0 1502    
repos,node_id repos node_id 1502 0 0 1502    
repos,full_name repos full_name 1502 0 0 1502    
repos,html_url repos html_url 1502 0 0 1502    
repos,created_at repos created_at 1502 0 0 1502    
licenses,key licenses key 17 0 0 17    
licenses,name licenses name 17 0 0 17    
licenses,spdx_id licenses spdx_id 17 0 0 17    
licenses,node_id licenses node_id 17 0 0 17    
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 17 0 0 17    
repos_fts_data,id repos_fts_data id 28 0 0 28    
repos_fts_data,block repos_fts_data block 28 0 0 28    
repos_fts_idx,term repos_fts_idx term 26 0 0 26    
repos_fts_idx,pgno repos_fts_idx pgno 26 0 0 26    
repos_fts_docsize,id repos_fts_docsize id 1502 0 0 1502    
users_fts_data,id users_fts_data id 53 0 0 53    
users_fts_data,block users_fts_data block 53 0 0 53    
users_fts_idx,term users_fts_idx term 51 0 0 51    
users_fts_idx,pgno users_fts_idx pgno 51 0 0 51    
users_fts_docsize,id users_fts_docsize id 11453 0 0 11453    
licenses_fts,name licenses_fts name 17 0 0 17    
raw_authors,id raw_authors id 119 0 0 119    
commits,sha commits sha 3922 0 0 3922    
commits_fts_data,id commits_fts_data id 47 0 0 47    
commits_fts_data,block commits_fts_data block 47 0 0 47    
commits_fts_idx,term commits_fts_idx term 45 0 0 45    
commits_fts_idx,pgno commits_fts_idx pgno 45 0 0 45    
commits_fts_docsize,id commits_fts_docsize id 3922 0 0 3922    
milestones,id milestones id 35 0 0 35    
milestones,html_url milestones html_url 35 0 0 35    
milestones,node_id milestones node_id 35 0 0 35    
milestones,created_at milestones created_at 35 0 0 35    
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 35 0 0 35    
issues,id issues id 3044 0 0 3044    
issues,node_id issues node_id 3044 0 0 3044    
issues,created_at issues created_at 3044 0 0 3044    
issues_fts_data,id issues_fts_data id 464 0 0 464    
issues_fts_data,block issues_fts_data block 464 0 0 464    
issues_fts_docsize,id issues_fts_docsize id 3044 0 0 3044    
releases,html_url releases html_url 355 0 0 355    
releases,id releases id 355 0 0 355    
releases,node_id releases node_id 355 0 0 355    
releases,created_at releases created_at 355 0 0 355    
releases,published_at releases published_at 355 0 0 355    
releases_fts_data,id releases_fts_data id 50 0 0 50    
releases_fts_data,block releases_fts_data block 50 0 0 50    
releases_fts_idx,term releases_fts_idx term 48 0 0 48    
releases_fts_idx,pgno releases_fts_idx pgno 48 0 0 48    
releases_fts_docsize,id releases_fts_docsize id 355 0 0 355    
labels,id labels id 106 0 0 106    
labels,node_id labels node_id 106 0 0 106    
labels,url labels url 106 0 0 106    
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 106 0 0 106    
issue_comments,html_url issue_comments html_url 10495 0 0 10495    
issue_comments,id issue_comments id 10495 0 0 10495    
issue_comments,node_id issue_comments node_id 10495 0 0 10495    
issue_comments_fts_data,id issue_comments_fts_data id 725 0 0 725    
issue_comments_fts_data,block issue_comments_fts_data block 725 0 0 725    
issue_comments_fts_docsize,id issue_comments_fts_docsize id 10495 0 0 10495    
dependents,first_seen_utc dependents first_seen_utc 1869 0 0 1869    
tags,sha tags sha 380 0 0 380    
emojis,name emojis name 1877 0 0 1877    
workflows,id workflows id 41 0 0 41    
jobs,id jobs id 54 0 0 54    
steps,id steps id 264 0 0 264    
pull_requests,id pull_requests id 608 0 0 608    
pull_requests,node_id pull_requests node_id 608 0 0 608    
pull_requests,created_at pull_requests created_at 608 0 0 608    
pull_requests,head pull_requests head 608 0 0 608    
pull_requests,url pull_requests url 608 0 0 608    
pull_requests_fts_data,id pull_requests_fts_data id 154 0 0 154    
pull_requests_fts_data,block pull_requests_fts_data block 154 0 0 154    
pull_requests_fts_idx,term pull_requests_fts_idx term 148 0 0 148    
pull_requests_fts_idx,pgno pull_requests_fts_idx pgno 148 0 0 148    
pull_requests_fts_docsize,id pull_requests_fts_docsize id 608 0 0 608    
users,gravatar_id users gravatar_id 11453 0 11453 1 [["", 11453]]  
raw_authors,email raw_authors email 119 0 119 1 [["", 119]]  
repos,temp_clone_token repos temp_clone_token 1502 0 1502 1 [["", 1502]]  
milestones,description milestones description 35 1 21 14 [["", 21], ["None", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["Issues planned for the next 1.0 alpha release.", 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]] [["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], ["Issues planned for the next 1.0 alpha release.", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["The first Datasette 1.0 alpha release.", 1], ["The new Datasette Write API.", 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 35 1 21 14 [["", 21], ["None", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["Issues planned for the next 1.0 alpha release.", 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]] [["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], ["Issues planned for the next 1.0 alpha release.", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["The first Datasette 1.0 alpha release.", 1], ["The new Datasette Write API.", 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 106 14 49 13 [["", 49], ["None", 14], ["New feature or request", 13], ["Something isn't working", 11], ["Improvements or additions to documentation", 8], ["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", 8]]
labels_fts,description labels_fts description 106 14 49 13 [["", 49], ["None", 14], ["New feature or request", 13], ["Something isn't working", 11], ["Improvements or additions to documentation", 8], ["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", 8]]
pull_requests,body pull_requests body 608 10 54 544 [["", 54], ["None", 10], ["Refs #744", 2], ["\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], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] [["sqlite foreign keys can be compound, but that is not as well supported by datase...", 1], ["still testing, hope it works!\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n-...", 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], ["this var `app` isn't actually used? unless init it does some side-effect outside...", 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 608 10 54 544 [["", 54], ["None", 10], ["Refs #744", 2], ["\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], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] [["sqlite foreign keys can be compound, but that is not as well supported by datase...", 1], ["still testing, hope it works!\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n-...", 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], ["this var `app` isn't actually used? unless init it does some side-effect outside...", 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]]
releases,body releases body 355 0 8 347 [["", 8], ["- Fix for a crashing bug caused by viewing the table page for a named in-memory ...", 2], ["* 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]]
releases_fts,body releases_fts body 355 0 8 347 [["", 8], ["- Fix for a crashing bug caused by viewing the table page for a named in-memory ...", 2], ["* 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]]
issues,body issues body 3044 13 99 2928 [["", 99], ["None", 13], ["- #2109 ", 3], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] [["ujson is already a dependency of Sanic, and should be quite a bit faster.", 1], ["uvicorn-0.8 relies on websockets-0.7 which lacks python-3.8 compatiblity", 1], ["v0.54 500 error in sql query template; code worked in v0.53; found a workaround\r...", 1], ["vegaEmbed is a LOT of code (it bundles d3)\r\n\r\nInspired by this tweet: https://tw...", 1], ["view-source:https://calands.datasettes.com/calands/CPAD_2020a_SuperUnits.geojson...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["would it be possible to:\r\n- remove uvicorn mandatory dependancy ?\r\n- eventually ...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1], ["👋 trying to upgrade the formula to use the latest release, but runs into some r...", 1], ["👋 thank you for an incredibly useful project! \r\n\r\nI have noticed that my deploye...", 1]]
issues_fts,body issues_fts body 3044 13 99 2928 [["", 99], ["None", 13], ["- #2109 ", 3], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] [["ujson is already a dependency of Sanic, and should be quite a bit faster.", 1], ["uvicorn-0.8 relies on websockets-0.7 which lacks python-3.8 compatiblity", 1], ["v0.54 500 error in sql query template; code worked in v0.53; found a workaround\r...", 1], ["vegaEmbed is a LOT of code (it bundles d3)\r\n\r\nInspired by this tweet: https://tw...", 1], ["view-source:https://calands.datasettes.com/calands/CPAD_2020a_SuperUnits.geojson...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["would it be possible to:\r\n- remove uvicorn mandatory dependancy ?\r\n- eventually ...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1], ["👋 trying to upgrade the formula to use the latest release, but runs into some r...", 1], ["👋 thank you for an incredibly useful project! \r\n\r\nI have noticed that my deploye...", 1]]
tags,name tags name 380 0 0 286 [["0.2", 10], ["0.1", 10], ["0.3", 8], ["0.4", 7], ["0.7", 5], ["0.5", 5], ["0.3.1", 5], ["0.1a", 5], ["0.6", 4], ["0.10", 4]] [["3.35.2", 1], ["3.36", 1], ["3.4", 1], ["3.4.1", 1], ["3.5", 1], ["3.6", 1], ["3.7", 1], ["3.8", 1], ["3.9", 1], ["3.9.1", 1]]
releases,tag_name releases tag_name 355 0 0 278 [["0.2", 8], ["0.3", 7], ["0.1", 7], ["0.4", 6], ["0.7", 4], ["0.5", 4], ["0.3.1", 4], ["0.1a", 4], ["0.12", 3], ["0.10", 3]] [["3.35.1", 1], ["3.35.2", 1], ["3.4", 1], ["3.4.1", 1], ["3.5", 1], ["3.6", 1], ["3.7", 1], ["3.8", 1], ["3.9", 1], ["3.9.1", 1]]
releases,name releases name 355 0 0 290 [["0.2", 8], ["0.3", 7], ["0.4", 6], ["0.1", 6], ["0.7", 4], ["0.5", 4], ["0.3.1", 4], ["0.3.2", 3], ["0.1a", 3], ["0.10", 3]] [["Datasette 0.29", 1], ["Datasette 0.31", 1], ["Datasette 0.32", 1], ["Datasette 0.33", 1], ["Datasette 0.34", 1], ["Datasette 0.35", 1], ["Datasette 0.36", 1], ["Datasette 0.37", 1], ["Datasette 0.37.1", 1], ["Initial release", 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])
);