_analyze_tables_
350 rows sorted by num_blank descending
This data as json, CSV (advanced)
Link | table | column | total_rows | num_null | num_blank ▲ | num_distinct | most_common | least_common |
---|---|---|---|---|---|---|---|---|
repos_fts_data,block | repos_fts_data | block | 25 | 0 | 0 | 25 | ||
repos_fts_data,id | repos_fts_data | id | 25 | 0 | 0 | 25 | ||
repos_fts_docsize,id | repos_fts_docsize | id | 1329 | 0 | 0 | 1329 | ||
repos_fts_docsize,sz | repos_fts_docsize | sz | 1329 | 0 | 0 | 112 | [["b'\\x02\\x00'", 168], ["b'\\x01\\x00'", 143], ["b'\\x03\\x00'", 92], ["b'\\x03\\x08'", 52], ["b'\\x03\\x05'", 45], ["b'\\x02\\x06'", 39], ["b'\\x03\\x07'", 37], ["b'\\x02\\x07'", 34], ["b'\\x03\\t'", 31], ["b'\\x01\\x07'", 30]] | [["b'\\x05 '", 1], ["b'\\x05\\x11'", 1], ["b'\\x05\\x13'", 1], ["b'\\x05\\x17'", 1], ["b'\\x06!'", 1], ["b'\\x06\\x00'", 1], ["b'\\x06\\x07'", 1], ["b'\\x06\\x11'", 1], ["b'\\x07\\x00'", 1], ["b'\\x07\\x0f'", 1]] |
repos_fts_idx,pgno | repos_fts_idx | pgno | 23 | 0 | 0 | 23 | ||
repos_fts_idx,segid | repos_fts_idx | segid | 23 | 0 | 0 | 1 | [[1, 23]] | |
repos_fts_idx,term | repos_fts_idx | term | 23 | 0 | 0 | 23 | ||
stars,repo | stars | repo | 11236 | 0 | 0 | 16 | [[107914493, 8162], [140912432, 1255], [206156866, 402], [207052882, 324], [197431109, 176], [197882382, 169], [256834907, 163], [611552758, 125], [214746582, 119], [213286752, 94]] | [[206202864, 6], [209590345, 20], [303218369, 35], [248903544, 44], [205429375, 55], [206649770, 87], [213286752, 94], [214746582, 119], [611552758, 125], [256834907, 163]] |
stars,starred_at | stars | starred_at | 11236 | 0 | 0 | 11232 | [["2022-08-01T04:42:31Z", 2], ["2019-07-10T11:27:06Z", 2], ["2017-11-14T13:01:37Z", 2], ["2017-11-14T05:14:41Z", 2], ["2017-11-14T00:23:15Z", 1], ["2017-11-14T00:17:38Z", 1], ["2017-11-14T00:16:53Z", 1], ["2017-11-14T00:10:35Z", 1], ["2017-11-13T22:01:43Z", 1], ["2017-11-13T21:59:52Z", 1]] | [["2023-07-17T12:31:56Z", 1], ["2023-07-18T03:11:42Z", 1], ["2023-07-18T07:03:32Z", 1], ["2023-07-18T11:42:48Z", 1], ["2023-07-18T12:58:25Z", 1], ["2023-07-18T14:08:36Z", 1], ["2023-07-18T14:26:52Z", 1], ["2023-07-18T15:50:47Z", 1], ["2023-07-19T00:32:21Z", 1], ["2023-07-19T01:56:04Z", 1]] |
stars,user | stars | user | 11236 | 0 | 0 | 9675 | [[100658940, 10], [366688, 10], [178424, 10], [41546558, 9], [948118, 9], [7476523, 8], [161718, 8], [128885, 8], [46511, 8], [14772, 8]] | [[132673404, 1], [134146004, 1], [134528840, 1], [134682577, 1], [135533341, 1], [136005892, 1], [137419843, 1], [137427584, 1], [139175847, 1], [139538131, 1]] |
steps,env | steps | env | 262 | 246 | 0 | 6 | [["None", 246], ["{\"TWINE_USERNAME\": \"__token__\", \"TWINE_PASSWORD\": \"${{ secrets.PYPI_TOKEN }}\"}", 11], ["{\"VERCEL_TOKEN\": \"${{ secrets.BRANCH_PREVIEW_VERCEL_TOKEN }}\"}", 1], ["{\"LATEST_DATASETTE_SECRET\": \"${{ secrets.LATEST_DATASETTE_SECRET }}\"}", 1], ["{\"GITHUB_ACCESS_TOKEN\": \"${{ secrets.GH_TOKEN }}\"}", 1], ["{\"DOCKER_USER\": \"${{ secrets.DOCKER_USER }}\", \"DOCKER_PASS\": \"${{ secrets.DOCKER...", 1], ["{\"DOCKER_USER\": \"${{ secrets.DOCKER_USER }}\", \"DOCKER_PASS\": \"${{ secrets.DOCKER...", 1]] | |
steps,id | steps | id | 262 | 0 | 0 | 262 | ||
steps,if | steps | if | 262 | 252 | 0 | 7 | [["None", 252], ["${{ github.ref == 'refs/heads/main' }}", 3], ["matrix.os == 'ubuntu-latest'", 2], ["matrix.python-version >= 3.8", 1], ["matrix.os == 'macos-latest' && matrix.python-version == '3.10'", 1], ["matrix.numpy == 1", 1], ["${{ github.event_name == 'pull_request' }}", 1], ["!contains(github.event.head_commit.message, 'REFRESH_DB')", 1]] | |
steps,job | steps | job | 262 | 0 | 0 | 54 | [[27508, 13], [27488, 12], [27466, 11], [27499, 8], [27507, 7], [27493, 7], [27497, 6], [27460, 5], [27459, 5], [27458, 5]] | [[27489, 1], [27503, 1], [26772, 2], [27494, 2], [27495, 2], [27500, 2], [27501, 2], [27469, 3], [27485, 3], [27490, 4]] |
steps,name | steps | name | 262 | 47 | 0 | 52 | [["None", 47], ["Install dependencies", 39], ["Configure pip caching", 32], ["Set up Python ${{ matrix.python-version }}", 25], ["Run tests", 25], ["Set up Python", 16], ["Publish", 11], ["Check out repo", 5], ["Install Python dependencies", 4], ["Set up Cloud Run", 3]] | [["Optionally install numpy", 1], ["Perform CodeQL Analysis", 1], ["Run prettier", 1], ["Run test", 1], ["Set up Python 3.10", 1], ["Set up Python 3.11", 1], ["Set up the alternate-route demo", 1], ["Test with pytest", 1], ["run flake8 if Python 3.8 or higher", 1], ["run mypy", 1]] |
steps,repo | steps | repo | 262 | 0 | 0 | 12 | [[107914493, 72], [140912432, 41], [207052882, 29], [206156866, 18], [303218369, 15], [248903544, 15], [197882382, 15], [197431109, 15], [611552758, 13], [205429375, 12]] | [[256834907, 5], [205429375, 12], [213286752, 12], [611552758, 13], [197431109, 15], [197882382, 15], [248903544, 15], [303218369, 15], [206156866, 18], [207052882, 29]] |
steps,run | steps | run | 262 | 143 | 0 | 58 | [["None", 143], ["pytest\n", 19], ["pip install -e '.[test]'\n", 15], ["python setup.py sdist bdist_wheel\ntwine upload dist/*\n", 9], ["pip install setuptools wheel twine\n", 9], ["pip install '.[test]'\n", 4], ["pytest -v\n", 3], ["npx markdown-toc README.md -i", 2], ["git diff\ngit config --global user.email \"readme-bot@example.com\"\ngit config --gl...", 2], ["cd docs\nDISABLE_SPHINX_INLINE_TABS=1 sphinx-build -b xml . _build\nsphinx-to-sqli...", 2]] | [["pip install sqlean.py sqlite-dump", 1], ["pytest -n auto -m \"not serial\"\npytest -m \"serial\"\n", 1], ["pytest -n auto -m \"not serial\"\npytest -m \"serial\"\n# And the test that exceeds a ...", 1], ["python -m pip install --upgrade pip\npip install -e .[test]\n", 1], ["python -m pip install --upgrade pip\npip install sqlite-utils>=3.1\nsqlite-utils -...", 1], ["python -m pip install --upgrade pip\npython -m pip install -e .[test]\npython -m p...", 1], ["python -m pip install -e .[docs]\npython -m pip install sphinx-to-sqlite==0.1a1\n", 1], ["python tests/fixtures.py fixtures.db fixtures.json plugins --extra-db-filename e...", 1], ["sleep 60 # Give PyPI time to make the new release available\ndocker login -u $DOC...", 1], ["sqlite-utils github.db \"select full_name from repos where owner = 53015001 union...", 1]] |
steps,seq | steps | seq | 262 | 0 | 0 | 13 | [[1, 54], [2, 52], [3, 47], [4, 45], [5, 35], [6, 7], [7, 6], [8, 4], [10, 3], [9, 3]] | [[13, 1], [12, 2], [9, 3], [10, 3], [11, 3], [8, 4], [7, 6], [6, 7], [5, 35], [4, 45]] |
steps,uses | steps | uses | 262 | 119 | 0 | 18 | [["None", 119], ["actions/checkout@v2", 33], ["actions/cache@v2", 25], ["actions/setup-python@v2", 23], ["actions/checkout@v3", 18], ["actions/setup-python@v4", 17], ["actions/cache@v3", 7], ["google-github-actions/setup-gcloud@v0", 3], ["actions/setup-python@v1", 2], ["actions/cache@v1", 2]] | [["actions/setup-python@v3", 1], ["actions/upload-artifact@v2", 1], ["github/codeql-action/analyze@v1", 1], ["github/codeql-action/autobuild@v1", 1], ["github/codeql-action/init@v1", 1], ["actions/setup-python@v1", 2], ["codecov/codecov-action@v1", 2], ["mxschmitt/action-tmate@v3", 2], ["readthedocs/actions/preview@v1", 2], ["zofrex/mirror-branch@ea152f124954fa4eb26eea3fe0dbe313a3a08d94", 2]] |
steps,with | steps | with | 262 | 173 | 0 | 23 | [["None", 173], ["{\"path\": \"~/.cache/pip\", \"key\": \"${{ runner.os }}-pip-${{ hashFiles('**/setup.py...", 23], ["{\"python-version\": \"${{ matrix.python-version }}\"}", 17], ["{\"path\": \"~/.cache/pip\", \"key\": \"${{ runner.os }}-publish-pip-${{ hashFiles('**/...", 9], ["{\"python-version\": \"3.9\"}", 7], ["{\"python-version\": 3.9}", 4], ["{\"python-version\": \"3.11\"}", 4], ["{\"python-version\": \"${{ matrix.python-version }}\", \"cache\": \"pip\", \"cache-depend...", 4], ["{\"version\": \"318.0.0\", \"service_account_email\": \"${{ secrets.GCP_SA_EMAIL }}\", \"...", 3], ["{\"python-version\": \"${{ matrix.python-version }}\", \"cache\": \"pip\", \"cache-depend...", 2]] | [["{\"path\": \"github.db\"}", 1], ["{\"path\": \"~/.cache/ms-playwright/\", \"key\": \"${{ runner.os }}-browsers\"}", 1], ["{\"path\": \"~/.npm\", \"key\": \"${{ runner.OS }}-npm-${{ hashFiles('**/package-lock.j...", 1], ["{\"project-slug\": \"datasette\"}", 1], ["{\"project-slug\": \"sqlite-utils\"}", 1], ["{\"python-version\": \"3.10\", \"cache\": \"pip\", \"cache-dependency-path\": \"**/setup.py...", 1], ["{\"python-version\": \"3.11\", \"cache\": \"pip\", \"cache-dependency-path\": \"pyproject.t...", 1], ["{\"python-version\": \"3.8\"}", 1], ["{\"target-branch\": \"main\", \"force\": false}", 1], ["{\"target-branch\": \"master\", \"force\": false}", 1]] |
tags,name | 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]] |
tags,repo | tags | repo | 368 | 0 | 0 | 15 | [[107914493, 134], [140912432, 119], [206156866, 29], [207052882, 23], [197431109, 20], [197882382, 9], [205429375, 7], [256834907, 5], [248903544, 5], [213286752, 5]] | [[209590345, 1], [611552758, 1], [206649770, 2], [206202864, 3], [213286752, 5], [248903544, 5], [256834907, 5], [303218369, 5], [205429375, 7], [197882382, 9]] |
tags,sha | tags | sha | 368 | 0 | 0 | 368 | ||
users,avatar_url | users | avatar_url | 10621 | 0 | 0 | 10621 | ||
users,html_url | users | html_url | 10621 | 0 | 0 | 10620 | [["https://github.com/fineheard", 2], ["https://github.com/0nyr", 1], ["https://github.com/0nebody", 1], ["https://github.com/0ndrec", 1], ["https://github.com/0ihsan", 1], ["https://github.com/0asa", 1], ["https://github.com/0987031613dow", 1], ["https://github.com/03b8", 1], ["https://github.com/00mjk", 1], ["https://github.com/0-vortex", 1]] | [["https://github.com/zxygithub", 1], ["https://github.com/zy528", 1], ["https://github.com/zyuanlim", 1], ["https://github.com/zz", 1], ["https://github.com/zz0x", 1], ["https://github.com/zz2115", 1], ["https://github.com/zzeleznick", 1], ["https://github.com/zzkt", 1], ["https://github.com/zzl0", 1], ["https://github.com/zzlgreat", 1]] |
users,id | users | id | 10621 | 0 | 0 | 10621 | ||
users,login | users | login | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
users,name | users | name | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
users,node_id | users | node_id | 10621 | 0 | 0 | 10621 | ||
users,site_admin | users | site_admin | 10621 | 0 | 0 | 2 | [[0, 10597], [1, 24]] | |
users,type | users | type | 10621 | 0 | 0 | 3 | [["User", 10489], ["Organization", 129], ["Bot", 3]] | |
users_fts,login | users_fts | login | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]] |
users_fts,name | users_fts | name | 10621 | 0 | 0 | 10620 | [["fineheard", 2], ["0nyr", 1], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]] | [["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zz2115", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 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]] | |
users_fts_data,block | users_fts_data | block | 50 | 0 | 0 | 50 | ||
users_fts_data,id | users_fts_data | id | 50 | 0 | 0 | 50 | ||
users_fts_docsize,id | users_fts_docsize | id | 10621 | 0 | 0 | 10621 | ||
users_fts_docsize,sz | users_fts_docsize | sz | 10621 | 0 | 0 | 6 | [["b'\\x01\\x01'", 9901], ["b'\\x02\\x02'", 650], ["b'\\x03\\x03'", 60], ["b'\\x04\\x04'", 6], ["b'\\x05\\x05'", 3], ["b'\\x06\\x06'", 1]] | |
users_fts_idx,pgno | users_fts_idx | pgno | 48 | 0 | 0 | 48 | ||
users_fts_idx,segid | users_fts_idx | segid | 48 | 0 | 0 | 1 | [[1, 48]] | |
users_fts_idx,term | users_fts_idx | term | 48 | 0 | 0 | 48 | ||
workflows,env | workflows | env | 41 | 40 | 0 | 1 | [["None", 41]] | |
workflows,filename | workflows | filename | 41 | 0 | 0 | 17 | [["test.yml", 12], ["publish.yml", 11], ["test-coverage.yml", 2], ["spellcheck.yml", 2], ["documentation-links.yml", 2], ["mirror-master-and-main.yml", 1], ["deploy-latest.yml", 1], ["deploy-demo.yml", 1], ["deploy-branch-preview.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], ["test-pyodide.yml", 1], ["tmate-mac.yml", 1], ["tmate.yml", 1]] |
workflows,id | workflows | id | 41 | 0 | 0 | 41 | ||
workflows,name | workflows | name | 41 | 0 | 0 | 17 | [["Test", 11], ["Publish Python Package", 11], ["Update README table of contents", 2], ["Read the Docs Pull Request Preview", 2], ["Check spelling in documentation", 2], ["Calculate test coverage", 2], ["Deploy a Datasette branch preview to Vercel", 1], ["CodeQL", 1], ["Check JavaScript for conformance with Prettier", 1], ["Build and deploy demo", 1]] | [["Check JavaScript for conformance with Prettier", 1], ["CodeQL", 1], ["Deploy a Datasette branch preview to Vercel", 1], ["Deploy latest.datasette.io", 1], ["Mirror \"master\" and \"main\" branches", 1], ["Push specific Docker tag", 1], ["Python package", 1], ["Test in Pyodide with shot-scraper", 1], ["tmate session", 1], ["tmate session mac", 1]] |
workflows,on | workflows | on | 41 | 0 | 0 | 16 | [["{\"release\": {\"types\": [\"created\"]}}", 11], ["[\"push\"]", 8], ["[\"push\", \"pull_request\"]", 6], ["{\"workflow_dispatch\": null}", 2], ["{\"push\": {\"branches\": [\"main\"]}, \"pull_request\": {\"branches\": [\"main\"]}}", 2], ["{\"pull_request_target\": {\"types\": [\"opened\"]}}", 2], ["{\"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\": \"0 4 * * 5\"}]}", 1], ["{\"push\": {\"branches\": [\"main\", \"master\"], \"paths\": [\"README.md\"]}}", 1], ["{\"push\": {\"branches\": [\"main\", \"1.0-dev\"]}}", 1], ["{\"push\": null, \"pull_request\": null, \"workflow_dispatch\": null}", 1]] | [["{\"push\": null, \"pull_request\": null, \"workflow_dispatch\": null}", 1], ["{\"push\": {\"branches\": [\"main\", \"1.0-dev\"]}}", 1], ["{\"push\": {\"branches\": [\"main\", \"master\"], \"paths\": [\"README.md\"]}}", 1], ["{\"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\": \"0 4 * * 5\"}]}", 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\": {\"branch\": {\"description\": \"Branch to deploy\", ...", 1], ["{\"workflow_dispatch\": {\"inputs\": {\"version_tag\": {\"description\": \"Tag to build a...", 1]] |
workflows,permissions | workflows | permissions | 41 | 25 | 0 | 2 | [["None", 25], ["{\"contents\": \"read\"}", 14], ["{\"pull-requests\": \"write\"}", 2]] | |
workflows,repo | workflows | repo | 41 | 0 | 0 | 12 | [[107914493, 13], [140912432, 6], [207052882, 4], [206156866, 3], [303218369, 2], [248903544, 2], [213286752, 2], [205429375, 2], [197882382, 2], [197431109, 2]] | [[256834907, 1], [197431109, 2], [197882382, 2], [205429375, 2], [213286752, 2], [248903544, 2], [303218369, 2], [611552758, 2], [206156866, 3], [207052882, 4]] |
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]) );