github
table | column | total_rows | num_null | num_blank | num_distinct | most_common | least_common |
---|---|---|---|---|---|---|---|
users | id | 10621 | 0 | 0 | 10621 | ||
users | node_id | 10621 | 0 | 0 | 10621 | ||
users | avatar_url | 10621 | 0 | 0 | 10621 | ||
repos | id | 1329 | 0 | 0 | 1329 | ||
repos | node_id | 1329 | 0 | 0 | 1329 | ||
repos | full_name | 1329 | 0 | 0 | 1329 | ||
repos | html_url | 1329 | 0 | 0 | 1329 | ||
repos | created_at | 1329 | 0 | 0 | 1329 | ||
licenses | key | 16 | 0 | 0 | 16 | ||
licenses | name | 16 | 0 | 0 | 16 | ||
licenses | spdx_id | 16 | 0 | 0 | 16 | ||
licenses | node_id | 16 | 0 | 0 | 16 | ||
licenses_fts_data | id | 3 | 0 | 0 | 3 | ||
licenses_fts_data | block | 3 | 0 | 0 | 3 | ||
licenses_fts_docsize | id | 16 | 0 | 0 | 16 | ||
repos_fts_data | id | 25 | 0 | 0 | 25 | ||
repos_fts_data | block | 25 | 0 | 0 | 25 | ||
repos_fts_idx | term | 23 | 0 | 0 | 23 | ||
repos_fts_idx | pgno | 23 | 0 | 0 | 23 | ||
repos_fts_docsize | id | 1329 | 0 | 0 | 1329 | ||
users_fts_data | id | 50 | 0 | 0 | 50 | ||
users_fts_data | block | 50 | 0 | 0 | 50 | ||
users_fts_idx | term | 48 | 0 | 0 | 48 | ||
users_fts_idx | pgno | 48 | 0 | 0 | 48 | ||
users_fts_docsize | id | 10621 | 0 | 0 | 10621 | ||
licenses_fts | name | 16 | 0 | 0 | 16 | ||
raw_authors | id | 114 | 0 | 0 | 114 | ||
commits | sha | 3784 | 0 | 0 | 3784 | ||
commits_fts_data | id | 45 | 0 | 0 | 45 | ||
commits_fts_data | block | 45 | 0 | 0 | 45 | ||
commits_fts_idx | term | 43 | 0 | 0 | 43 | ||
commits_fts_idx | pgno | 43 | 0 | 0 | 43 | ||
commits_fts_docsize | id | 3784 | 0 | 0 | 3784 | ||
milestones | id | 34 | 0 | 0 | 34 | ||
milestones | html_url | 34 | 0 | 0 | 34 | ||
milestones | node_id | 34 | 0 | 0 | 34 | ||
milestones | created_at | 34 | 0 | 0 | 34 | ||
milestones | updated_at | 34 | 0 | 0 | 34 | ||
milestones_fts_data | id | 3 | 0 | 0 | 3 | ||
milestones_fts_data | block | 3 | 0 | 0 | 3 | ||
milestones_fts_docsize | id | 34 | 0 | 0 | 34 | ||
issues | id | 2892 | 0 | 0 | 2892 | ||
issues | node_id | 2892 | 0 | 0 | 2892 | ||
issues | created_at | 2892 | 0 | 0 | 2892 | ||
issues_fts_data | id | 420 | 0 | 0 | 420 | ||
issues_fts_data | block | 420 | 0 | 0 | 420 | ||
issues_fts_docsize | id | 2892 | 0 | 0 | 2892 | ||
releases | html_url | 344 | 0 | 0 | 344 | ||
releases | id | 344 | 0 | 0 | 344 | ||
releases | node_id | 344 | 0 | 0 | 344 | ||
releases | created_at | 344 | 0 | 0 | 344 | ||
releases | published_at | 344 | 0 | 0 | 344 | ||
releases_fts_data | id | 47 | 0 | 0 | 47 | ||
releases_fts_data | block | 47 | 0 | 0 | 47 | ||
releases_fts_idx | term | 45 | 0 | 0 | 45 | ||
releases_fts_idx | pgno | 45 | 0 | 0 | 45 | ||
releases_fts_docsize | id | 344 | 0 | 0 | 344 | ||
labels | id | 103 | 0 | 0 | 103 | ||
labels | node_id | 103 | 0 | 0 | 103 | ||
labels | url | 103 | 0 | 0 | 103 | ||
labels_fts_data | id | 3 | 0 | 0 | 3 | ||
labels_fts_data | block | 3 | 0 | 0 | 3 | ||
labels_fts_docsize | id | 103 | 0 | 0 | 103 | ||
issue_comments | html_url | 9947 | 0 | 0 | 9947 | ||
issue_comments | id | 9947 | 0 | 0 | 9947 | ||
issue_comments | node_id | 9947 | 0 | 0 | 9947 | ||
issue_comments_fts_data | id | 688 | 0 | 0 | 688 | ||
issue_comments_fts_data | block | 688 | 0 | 0 | 688 | ||
issue_comments_fts_docsize | id | 9947 | 0 | 0 | 9947 | ||
dependents | first_seen_utc | 1658 | 0 | 0 | 1658 | ||
tags | sha | 368 | 0 | 0 | 368 | ||
emojis | name | 1877 | 0 | 0 | 1877 | ||
workflows | id | 41 | 0 | 0 | 41 | ||
jobs | id | 54 | 0 | 0 | 54 | ||
steps | id | 262 | 0 | 0 | 262 | ||
pull_requests | id | 560 | 0 | 0 | 560 | ||
pull_requests | node_id | 560 | 0 | 0 | 560 | ||
pull_requests | created_at | 560 | 0 | 0 | 560 | ||
pull_requests | head | 560 | 0 | 0 | 560 | ||
pull_requests | url | 560 | 0 | 0 | 560 | ||
pull_requests_fts_data | id | 126 | 0 | 0 | 126 | ||
pull_requests_fts_data | block | 126 | 0 | 0 | 126 | ||
pull_requests_fts_idx | term | 122 | 0 | 0 | 122 | ||
pull_requests_fts_idx | pgno | 122 | 0 | 0 | 122 | ||
pull_requests_fts_docsize | id | 560 | 0 | 0 | 560 | ||
users | gravatar_id | 10621 | 0 | 10621 | 1 | [["", 10621]] | |
raw_authors | 114 | 0 | 114 | 1 | [["", 114]] | ||
repos | temp_clone_token | 1329 | 0 | 1329 | 1 | [["", 1329]] | |
milestones | description | 34 | 1 | 21 | 13 | [["", 21], ["The first Datasette 1.0 alpha release.", 1], ["None", 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]] | [["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], ["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 | 34 | 1 | 21 | 13 | [["", 21], ["The first Datasette 1.0 alpha release.", 1], ["None", 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]] | [["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], ["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 | 103 | 14 | 46 | 13 | [["", 46], ["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 | 103 | 14 | 46 | 13 | [["", 46], ["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 | 560 | 10 | 54 | 496 | [["", 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 \"IS\" is equivalent to SQL \"IS NOT DISTINCT FROM\"\r\n\r\ncloses #423", 1], ["sqlite foreign keys can be compound, but that is not as well supported by datase...", 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 | 560 | 10 | 54 | 496 | [["", 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 \"IS\" is equivalent to SQL \"IS NOT DISTINCT FROM\"\r\n\r\ncloses #423", 1], ["sqlite foreign keys can be compound, but that is not as well supported by datase...", 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 | 344 | 0 | 8 | 337 | [["", 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]] |
releases_fts | body | 344 | 0 | 8 | 337 | [["", 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]] |
issues | body | 2892 | 13 | 99 | 2778 | [["", 99], ["None", 13], ["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 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 | 2892 | 13 | 99 | 2778 | [["", 99], ["None", 13], ["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 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 | 368 | 0 | 0 | 274 | [["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.32.1", 1], ["3.33", 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 | 344 | 0 | 0 | 267 | [["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.32.1", 1], ["3.33", 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 | 344 | 0 | 0 | 279 | [["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]] |