_analyze_tables_
336 rows where num_blank = 0 sorted by total_rows
This data as json, CSV (advanced)
Link | table | column | total_rows ▼ | num_null | num_blank | num_distinct | most_common | least_common |
---|---|---|---|---|---|---|---|---|
jobs,id | jobs | id | 54 | 0 | 0 | 54 | ||
jobs,if | jobs | if | 54 | 52 | 0 | 1 | [["None", 54]] | |
jobs,name | jobs | name | 54 | 0 | 0 | 12 | [["test", 25], ["deploy", 12], ["build", 5], ["spellcheck", 2], ["documentation-links", 2], ["deploy_docker", 2], ["mirror", 1], ["deploy_static_docs", 1], ["deploy-branch-preview", 1], ["Analyze", 1]] | [["Analyze", 1], ["deploy-branch-preview", 1], ["deploy_static_docs", 1], ["mirror", 1], ["prettier", 1], ["scheduled", 1], ["deploy_docker", 2], ["documentation-links", 2], ["spellcheck", 2], ["build", 5]] |
jobs,needs | jobs | needs | 54 | 41 | 0 | 2 | [["None", 41], ["[\"test\"]", 11], ["[\"deploy\"]", 2]] | |
jobs,repo | jobs | repo | 54 | 0 | 0 | 12 | [[107914493, 16], [140912432, 7], [207052882, 5], [206156866, 4], [303218369, 3], [248903544, 3], [213286752, 3], [205429375, 3], [197882382, 3], [197431109, 3]] | [[256834907, 1], [197431109, 3], [197882382, 3], [205429375, 3], [213286752, 3], [248903544, 3], [303218369, 3], [611552758, 3], [206156866, 4], [207052882, 5]] |
jobs,runs-on | jobs | runs-on | 54 | 0 | 0 | 3 | [["ubuntu-latest", 50], ["macos-latest", 2], ["${{ matrix.os }}", 2]] | |
jobs,strategy | jobs | strategy | 54 | 30 | 0 | 7 | [["None", 30], ["{\"matrix\": {\"python-version\": [3.6, 3.7, 3.8, 3.9]}}", 10], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\"]}}", 6], ["{\"matrix\": {\"python-version\": [\"3.8\", \"3.9\", \"3.10\", \"3.11\"]}}", 4], ["{\"matrix\": {\"python-version\": [3.7, 3.8]}}", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\"], \"os\": [\"ubu...", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\"], \"numpy\": [0...", 1], ["{\"fail-fast\": false, \"matrix\": {\"language\": [\"python\"]}}", 1]] | |
jobs,workflow | jobs | workflow | 54 | 0 | 0 | 41 | [[20702, 4], [20695, 2], [20693, 2], [20691, 2], [20689, 2], [20687, 2], [20684, 2], [20681, 2], [20678, 2], [20676, 2]] | [[20705, 1], [20706, 1], [20707, 1], [20708, 1], [20709, 1], [20710, 1], [20711, 1], [20713, 1], [20714, 1], [20715, 1]] |
labels,color | labels | color | 103 | 0 | 0 | 71 | [["a2eeef", 13], ["d73a4a", 11], ["0075ca", 8], ["ffffff", 2], ["e4e669", 2], ["008672", 2], ["0EE038", 1], ["083993", 1], ["0366d6", 1], ["006b75", 1]] | [["e6e6e6", 1], ["e8be84", 1], ["ecc7fc", 1], ["ee0701", 1], ["f759cf", 1], ["fc79af", 1], ["fc8b0a", 1], ["fcbabb", 1], ["fcd0c4", 1], ["fcecc4", 1]] |
labels,default | labels | default | 103 | 0 | 0 | 2 | [[0, 54], [1, 49]] | |
labels,id | labels | id | 103 | 0 | 0 | 103 | ||
labels,name | labels | name | 103 | 0 | 0 | 56 | [["enhancement", 14], ["bug", 12], ["documentation", 10], ["research", 4], ["invalid", 3], ["help wanted", 3], ["ci", 3], ["question", 2], ["duplicate", 2], ["design", 2]] | [["release", 1], ["search", 1], ["security", 1], ["small", 1], ["support", 1], ["templates", 1], ["tests", 1], ["tracking-issue", 1], ["usability", 1], ["windows", 1]] |
labels,node_id | labels | node_id | 103 | 0 | 0 | 103 | ||
labels,url | labels | url | 103 | 0 | 0 | 103 | ||
labels_fts,name | labels_fts | name | 103 | 0 | 0 | 56 | [["enhancement", 14], ["bug", 12], ["documentation", 10], ["research", 4], ["invalid", 3], ["help wanted", 3], ["ci", 3], ["question", 2], ["duplicate", 2], ["design", 2]] | [["release", 1], ["search", 1], ["security", 1], ["small", 1], ["support", 1], ["templates", 1], ["tests", 1], ["tracking-issue", 1], ["usability", 1], ["windows", 1]] |
labels_fts_docsize,id | labels_fts_docsize | id | 103 | 0 | 0 | 103 | ||
labels_fts_docsize,sz | labels_fts_docsize | sz | 103 | 0 | 0 | 9 | [["b'\\x01\\x00'", 47], ["b'\\x01\\x04'", 25], ["b'\\x02\\x00'", 11], ["b'\\x01\\x05'", 11], ["b'\\x03\\x00'", 2], ["b'\\x02\\x04'", 2], ["b'\\x01\\x07'", 2], ["b'\\x01\\x06'", 2], ["b'\\x01\\r'", 1]] | |
raw_authors,id | raw_authors | id | 114 | 0 | 0 | 114 | ||
raw_authors,name | raw_authors | name | 114 | 0 | 0 | 110 | [["Thomas Sibley", 2], ["Simon Willison", 2], ["Robert Gieseke", 2], ["Abdussamet Koçak", 2], ["Alex Garcia", 1], ["Adrien Di Pasquale", 1], ["Adam Wolf", 1], ["Adam Simpson", 1], ["Adam Jonas", 1], ["Abdus", 1]] | [["dependabot[bot]", 1], ["fcatus", 1], ["gerrymanoim", 1], ["joelondon", 1], ["louispotok", 1], ["lsb", 1], ["mkorosec", 1], ["rhoboro", 1], ["vincent d warmerdam", 1], ["カシオ 金城 大関", 1]] |
pull_requests_fts_idx,pgno | pull_requests_fts_idx | pgno | 122 | 0 | 0 | 122 | ||
pull_requests_fts_idx,segid | pull_requests_fts_idx | segid | 122 | 0 | 0 | 1 | [[1, 122]] | |
pull_requests_fts_idx,term | pull_requests_fts_idx | term | 122 | 0 | 0 | 122 | ||
pull_requests_fts_data,block | pull_requests_fts_data | block | 126 | 0 | 0 | 126 | ||
pull_requests_fts_data,id | pull_requests_fts_data | id | 126 | 0 | 0 | 126 | ||
contributors,contributions | contributors | contributions | 131 | 0 | 0 | 23 | [[1, 92], [2, 11], [3, 5], [5, 3], [6, 2], [13, 1], [11, 1], [10, 1], [9, 1], [4, 1]] | [[21, 1], [30, 1], [34, 1], [40, 1], [49, 1], [61, 1], [128, 1], [165, 1], [828, 1], [2011, 1]] |
contributors,repo_id | contributors | repo_id | 131 | 0 | 0 | 16 | [[107914493, 73], [140912432, 30], [207052882, 5], [206156866, 4], [214746582, 3], [205429375, 3], [303218369, 2], [256834907, 2], [213286752, 2], [197431109, 1]] | [[197431109, 1], [197882382, 1], [206202864, 1], [206649770, 1], [209590345, 1], [248903544, 1], [611552758, 1], [213286752, 2], [256834907, 2], [303218369, 2]] |
contributors,user_id | contributors | user_id | 131 | 0 | 0 | 108 | [[9599, 16], [41546558, 2], [536941, 2], [244656, 2], [78035, 2], [50527, 2], [49260, 2], [25778, 2], [21148, 2], [2182, 1]] | [[22578954, 1], [27856297, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [49699333, 1], [56323389, 1], [72577720, 1], [99098079, 1]] |
labels_pull_requests,labels_id | labels_pull_requests | labels_id | 163 | 0 | 0 | 26 | [[1970143153, 92], [993377884, 11], [993222446, 6], [727708734, 6], [2374328705, 5], [1405404904, 5], [1379448359, 5], [754269786, 5], [750789605, 4], [754730474, 3]] | [[947465681, 1], [1382668283, 1], [1918831023, 1], [2157112227, 1], [2175284252, 1], [2459412274, 1], [3645705798, 1], [3799780031, 1], [4251477726, 1], [4860121561, 1]] |
labels_pull_requests,pull_requests_id | labels_pull_requests | pull_requests_id | 163 | 0 | 0 | 146 | [[971057476, 3], [853484980, 2], [817257851, 2], [804924636, 2], [700944644, 2], [513106026, 2], [511005542, 2], [481616704, 2], [431478724, 2], [296735320, 2]] | [[1327188997, 1], [1333843584, 1], [1350861558, 1], [1358254580, 1], [1358282799, 1], [1358321208, 1], [1359311359, 1], [1392480869, 1], [1427574243, 1], [1429431050, 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]] |
releases,author | releases | author | 344 | 0 | 0 | 1 | [[9599, 344]] | |
releases,created_at | releases | created_at | 344 | 0 | 0 | 344 | ||
releases,draft | releases | draft | 344 | 0 | 0 | 1 | [[0, 344]] | |
releases,html_url | releases | html_url | 344 | 0 | 0 | 344 | ||
releases,id | releases | id | 344 | 0 | 0 | 344 | ||
releases,name | 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]] |
releases,node_id | releases | node_id | 344 | 0 | 0 | 344 | ||
releases,prerelease | releases | prerelease | 344 | 0 | 0 | 2 | [[0, 305], [1, 39]] | |
releases,published_at | releases | published_at | 344 | 0 | 0 | 344 | ||
releases,reactions | releases | reactions | 344 | 316 | 0 | 28 | [["None", 316], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/57629048/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/51940513/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/51387349/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/47507174/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/45182156/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/44292523/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/44155601/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/101136455/reacti...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/twitter-to-sqlite/releases/500036...", 1]] | [["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/103740013/rea...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/109839649/rea...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/44511190/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/44904928/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/47636109/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/48389722/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/53350811/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/59656694/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/65833874/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/75560168/reac...", 1]] |
releases,repo | releases | repo | 344 | 0 | 0 | 14 | [[107914493, 126], [140912432, 108], [206156866, 28], [207052882, 22], [197431109, 20], [197882382, 9], [205429375, 7], [256834907, 5], [248903544, 5], [213286752, 5]] | [[209590345, 1], [611552758, 1], [206202864, 2], [213286752, 5], [248903544, 5], [256834907, 5], [303218369, 5], [205429375, 7], [197882382, 9], [197431109, 20]] |
releases,tag_name | 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,target_commitish | releases | target_commitish | 344 | 0 | 0 | 8 | [["main", 176], ["master", 157], ["0.64.x", 3], ["0.63.x", 3], ["0.60.x", 2], ["0.56.x", 1], ["0.54.x", 1], ["0.52.x", 1]] | |
releases_fts,name | releases_fts | 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]] |
releases_fts_docsize,id | releases_fts_docsize | id | 344 | 0 | 0 | 344 | ||
releases_fts_docsize,sz | releases_fts_docsize | sz | 344 | 0 | 0 | 221 | [["b'\\x02\\x0b'", 17], ["b'\\x02\\x00'", 8], ["b'\\x03\\x12'", 7], ["b'\\x03\\x0c'", 7], ["b'\\x03\\x0b'", 6], ["b'\\x02\\x15'", 4], ["b'\\x02\\x11'", 4], ["b'\\x02\\n'", 4], ["b'\\x02('", 4], ["b'\\x02&'", 4]] | [["b'\\n\\x83\\x04'", 1], ["b'\\t\\x81\\x03'", 1], ["b'\\t\\x81{'", 1], ["b'\\x04\\x82\\x16'", 1], ["b'\\x05\\x81\\x7f'", 1], ["b'\\x05\\x82Z'", 1], ["b'\\x05\\x88J'", 1], ["b'\\x06\\x84\\x06'", 1], ["b'\\x07\"'", 1], ["b'\\x08\\x83.'", 1]] |
_analyze_tables_,column | _analyze_tables_ | column | 350 | 0 | 0 | 153 | [["id", 33], ["name", 17], ["repo", 11], ["term", 10], ["sz", 10], ["segid", 10], ["pgno", 10], ["node_id", 10], ["k", 10], ["block", 10]] | [["uploader", 1], ["use_squash_pr_title_as_default", 1], ["user_id", 1], ["uses", 1], ["visibility", 1], ["watchers", 1], ["watchers_count", 1], ["web_commit_signoff_required", 1], ["with", 1], ["workflow", 1]] |
_analyze_tables_,least_common | _analyze_tables_ | least_common | 350 | 211 | 0 | 117 | [["None", 211], ["[[\"zxygithub\", 1], [\"zy528\", 1], [\"zyuanlim\", 1], [\"zz\", 1], [\"zz0x\", 1], [\"zz21...", 4], ["[[314, 1], [334, 1], [364, 1], [387, 1], [1057, 1], [1062, 1], [1230, 1], [1260,...", 3], ["[[\"release\", 1], [\"search\", 1], [\"security\", 1], [\"small\", 1], [\"support\", 1], [...", 2], ["[[\"https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2\", 1], [\"htt...", 2], ["[[\"Datasette 0.60\", 1], [\"Datasette 0.62\", 1], [\"Datasette 1.0\", 1], [\"Datasette...", 2], ["[[\"Datasette 0.29\", 1], [\"Datasette 0.31\", 1], [\"Datasette 0.32\", 1], [\"Datasett...", 2], ["[[\"Awaiting something else to happen first\", 1], [\"Further information is reques...", 2], ["[[\"Ability to fully customize the HTML templates used to display datasette data....", 2], ["[[\"3.32.1\", 1], [\"3.33\", 1], [\"3.4\", 1], [\"3.4.1\", 1], [\"3.5\", 1], [\"3.6\", 1], [...", 2]] | [["[[37962604, 1], [39452697, 1], [56323389, 1], [72577720, 1], [87192257, 1], [918...", 1], ["[[439, 1], [443, 1], [446, 1], [449, 1], [452, 1], [460, 1], [461, 1], [487, 1],...", 1], ["[[49702524, 1], [52261150, 1], [60892516, 1], [63653929, 1], [76450761, 1], [765...", 1], ["[[5234079, 1], [5533512, 1], [5897911, 1], [6055094, 1], [4471010, 2], [5971510,...", 1], ["[[57859326, 1], [69208826, 1], [76450761, 1], [80409402, 1], [83080728, 1], [871...", 1], ["[[626, 1], [628, 1], [630, 1], [632, 1], [636, 1], [638, 1], [640, 1], [642, 1],...", 1], ["[[663556926, 1], [663586533, 1], [664178911, 1], [664727381, 1], [664733539, 1],...", 1], ["[[791181, 1], [1124434, 1], [1205836, 1], [1215453, 1], [1216794, 1], [1289400, ...", 1], ["[[9374594, 1], [5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414,...", 1], ["[[947465681, 1], [1382668283, 1], [1918831023, 1], [2157112227, 1], [2175284252,...", 1]] |
_analyze_tables_,most_common | _analyze_tables_ | most_common | 350 | 85 | 0 | 206 | [["None", 85], ["[[\"None\", 1329]]", 12], ["[[4, 1]]", 10], ["[[\"version\", 1]]", 10], ["[[\"fineheard\", 2], [\"0nyr\", 1], [\"0nebody\", 1], [\"0ndrec\", 1], [\"0ihsan\", 1], [\"...", 4], ["[[2, 1]]", 3], ["[[1, 1]]", 3], ["[[0, 952], [1, 138], [2, 57], [3, 34], [5, 15], [4, 15], [7, 12], [6, 10], [12, ...", 3], ["[[\"b''\", 1]]", 3], ["[[\"\", 21], [\"The first Datasette 1.0 alpha release.\", 1], [\"None\", 1], [\"Just ad...", 2]] | [["[[9599, 1991], [49699333, 70], [536941, 32], [45057, 26], [27856297, 22], [25778...", 1], ["[[9599, 1]]", 1], ["[[9599, 2926], [19864447, 839], [\"None\", 8], [21148, 6], [45057, 5]]", 1], ["[[9599, 344]]", 1], ["[[9599, 34]]", 1], ["[[9599, 3540], [49699333, 48], [45057, 20], [27856297, 17], [\"None\", 8], [21148,...", 1], ["[[9599, 8456], [22429695, 204], [536941, 79], [25778, 70], [45057, 39], [82988, ...", 1], ["[[971057476, 3], [853484980, 2], [817257851, 2], [804924636, 2], [700944644, 2],...", 1], ["[[null, 1]]", 1], ["[[null, 9947]]", 1]] |
_analyze_tables_,num_blank | _analyze_tables_ | num_blank | 350 | 0 | 0 | 10 | [[0, 336], [99, 2], [54, 2], [46, 2], [21, 2], [8, 2], [10621, 1], [1329, 1], [300, 1], [114, 1]] | |
_analyze_tables_,num_distinct | _analyze_tables_ | num_distinct | 350 | 0 | 0 | 126 | [[1, 71], [2, 25], [16, 13], [3, 12], [34, 9], [560, 7], [6, 7], [1329, 6], [344, 6], [0, 6]] | [[1877, 1], [2009, 1], [2033, 1], [2084, 1], [2782, 1], [2890, 1], [3656, 1], [3781, 1], [9675, 1], [11232, 1]] |
_analyze_tables_,num_null | _analyze_tables_ | num_null | 350 | 0 | 0 | 53 | [[0, 279], [1, 5], [1275, 4], [1120, 4], [560, 2], [431, 2], [14, 2], [13, 2], [10, 2], [8, 2]] | [[1108, 1], [1214, 1], [1229, 1], [1244, 1], [1266, 1], [1278, 1], [1290, 1], [2293, 1], [2872, 1], [9947, 1]] |
_analyze_tables_,table | _analyze_tables_ | table | 350 | 0 | 0 | 73 | [["repos", 57], ["pull_requests", 23], ["issues", 23], ["milestones", 15], ["releases", 14], ["assets", 14], ["issue_comments", 12], ["steps", 10], ["users", 9], ["commits", 9]] | [["commits_fts", 1], ["issue_comments_fts", 1], ["licenses_fts", 1], ["repos_fts_config", 2], ["repos_fts_data", 2], ["repos_fts_docsize", 2], ["users_fts", 2], ["users_fts_config", 2], ["users_fts_data", 2], ["users_fts_docsize", 2]] |
_analyze_tables_,total_rows | _analyze_tables_ | total_rows | 350 | 0 | 0 | 37 | [[1329, 61], [1, 43], [2892, 27], [560, 27], [34, 19], [344, 18], [9947, 15], [10621, 13], [3784, 12], [103, 11]] | [[25, 2], [47, 2], [50, 2], [126, 2], [163, 2], [420, 2], [688, 2], [3206, 2], [1877, 3], [11236, 3]] |
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 | ||
issues_fts_idx,pgno | issues_fts_idx | pgno | 412 | 0 | 0 | 155 | [[20, 3], [18, 3], [16, 3], [14, 3], [12, 3], [10, 3], [8, 3], [6, 3], [4, 3], [2, 3]] | [[268, 1], [274, 1], [278, 1], [306, 1], [308, 1], [310, 1], [298, 2], [300, 2], [302, 2], [304, 2]] |
issues_fts_idx,segid | issues_fts_idx | segid | 412 | 0 | 0 | 3 | [[1, 152], [2, 149], [3, 111]] | |
issues_fts_idx,term | issues_fts_idx | term | 412 | 0 | 0 | 373 | [["b'0tho'", 3], ["b'0nota'", 3], ["b'0forb'", 3], ["b'0a0'", 3], ["b''", 3], ["b'0beg'", 2], ["b'0asc'", 2], ["b'0andr'", 2], ["b'0adde'", 2], ["b'010'", 2]] | [["b'0withe'", 1], ["b'0withi'", 1], ["b'0worka'", 1], ["b'0worker'", 1], ["b'0worko'", 1], ["b'0www2'", 1], ["b'0wy'", 1], ["b'0yer'", 1], ["b'0your'", 1], ["b'0yours'", 1]] |
issues_fts_data,block | issues_fts_data | block | 420 | 0 | 0 | 420 | ||
issues_fts_data,id | issues_fts_data | id | 420 | 0 | 0 | 420 | ||
pull_requests,assignee | pull_requests | assignee | 560 | 557 | 0 | 2 | [["None", 557], [9599, 2], [15178711, 1]] | |
pull_requests,author_association | pull_requests | author_association | 560 | 0 | 0 | 5 | [["CONTRIBUTOR", 277], ["OWNER", 190], ["FIRST_TIME_CONTRIBUTOR", 63], ["NONE", 25], ["MEMBER", 5]] | |
pull_requests,auto_merge | pull_requests | auto_merge | 560 | 560 | 0 | 0 | [[null, 560]] | |
pull_requests,base | pull_requests | base | 560 | 0 | 0 | 422 | [["f09d611782a8372cfb002792dfa727325afb4db6", 7], ["1b697539f5b53cec3fe13c0f4ada13ba655c88c7", 6], ["0b4a28691468b5c758df74fa1d72a823813c96bf", 5], ["b7257a21bf3dfa7353980f343c83a616da44daa7", 4], ["a4bb2abce0764d49d255e5379f9e9c70981834ca", 4], ["8c401ee0f054de2f568c3a8302c9223555146407", 4], ["71e36e1cf034b96de2a8e6652265d782d3fdf63b", 4], ["5890a20c374fb0812d88c9b0ef26a838bfa06c76", 4], ["11b352b4d52fd02a422776edebb14f12e4994d3b", 4], ["0f7192b6154edb576c41b55bd3f2a3f53e5f436a", 4]] | [["f7289174e66ae4d91d57de94bbd9d09fabf7aff4", 1], ["f825e2012109247fa246e2b938f8174069e574f1", 1], ["f8277d0fb9c05a88a9ff01d996e31d55f0f0a645", 1], ["fa8eb0bf1b113ab17ede9cd107b7c3bd5cde39c3", 1], ["faea5093b865031f650da7da6539430f732f511a", 1], ["fb988ace7c7e2bee5ac142a0eab22431d0675a77", 1], ["fcf43589eb6a1f1d0432772a639fd35711c48e0c", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fe5b6ea95a973534fe8a44907c0ea2449aae7602", 1], ["fff89772b4404995400e33fe1d269050717ff4cf", 1]] |
pull_requests,closed_at | pull_requests | closed_at | 560 | 90 | 0 | 470 | [["None", 90], ["2017-11-21T20:55:05Z", 1], ["2017-11-18T03:15:50Z", 1], ["2017-11-18T00:53:43Z", 1], ["2017-11-17T14:22:56Z", 1], ["2017-11-17T13:29:22Z", 1], ["2017-11-17T03:50:52Z", 1], ["2017-11-15T03:08:04Z", 1], ["2017-11-15T02:03:01Z", 1], ["2017-11-13T22:16:55Z", 1]] | [["2023-05-08T21:13:37Z", 1], ["2023-05-08T21:27:10Z", 1], ["2023-05-08T21:53:58Z", 1], ["2023-05-15T13:59:36Z", 1], ["2023-05-21T16:19:30Z", 1], ["2023-05-21T18:41:56Z", 1], ["2023-05-21T20:57:23Z", 1], ["2023-05-26T00:18:44Z", 1], ["2023-06-25T23:25:51Z", 1], ["2023-06-29T14:31:54Z", 1]] |
pull_requests,created_at | pull_requests | created_at | 560 | 0 | 0 | 560 | ||
pull_requests,draft | pull_requests | draft | 560 | 0 | 0 | 2 | [[0, 550], [1, 10]] | |
pull_requests,head | pull_requests | head | 560 | 0 | 0 | 560 | ||
pull_requests,id | pull_requests | id | 560 | 0 | 0 | 560 | ||
pull_requests,locked | pull_requests | locked | 560 | 0 | 0 | 1 | [[0, 560]] | |
pull_requests,merge_commit_sha | pull_requests | merge_commit_sha | 560 | 1 | 0 | 559 | [["None", 1], ["0499f174c063283aa9b589d475a32077aaf7adc5", 1], ["03cc697b6b3d0983618c29ee75b45b5e0ac91139", 1], ["03b35d70e281ea48bd9b8058738ed87b13cea2de", 1], ["02f5c4d69d7b4baebde015c56e5bc62923f33314", 1], ["025b4024b1b43ea034b7fd331c30740165ff75f2", 1], ["022cdd97a9ddab1a152e23e1e1c42e78c1ed0fa9", 1], ["01369176b0a8943ab45292ffc6f9c929b80a00e8", 1], ["013496862f4d4b441ab61255242b838b24287607", 1], ["00e59ec461dc0150772b999c7cc15fcb9b507d58", 1]] | [["f8ffac8787e299a62c99ed1ce914cd5ace84ad94", 1], ["f92d823766872a6fd7e76c5249a6b2de1ab0f447", 1], ["f96e55bce55d26c4d5b198edc536e1b8e9bbea43", 1], ["f99a23652910b03ac4669bbbb35a9b484451aabb", 1], ["fb3abeceb2785a582d2c120c7c1bf7dc3cd1de05", 1], ["fb57d4474cb1fdaef260e244b1b6f470f1992e40", 1], ["fc3660cfad7668dbce6ead12766e048fc1f78b11", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fda4dad23a0494890267fbe8baf179e2b56ee914", 1], ["ffff3a4c5398a9f40b61d59736f386444da19289", 1]] |
pull_requests,merged_at | pull_requests | merged_at | 560 | 178 | 0 | 382 | [["None", 178], ["2017-11-21T20:55:05Z", 1], ["2017-11-18T03:15:50Z", 1], ["2017-11-18T00:53:43Z", 1], ["2017-11-17T14:22:56Z", 1], ["2017-11-17T13:29:22Z", 1], ["2017-11-17T03:50:52Z", 1], ["2017-11-15T03:08:04Z", 1], ["2017-11-15T02:03:01Z", 1], ["2017-11-13T22:16:55Z", 1]] | [["2023-04-13T01:44:43Z", 1], ["2023-05-08T21:10:01Z", 1], ["2023-05-08T21:13:37Z", 1], ["2023-05-08T21:53:58Z", 1], ["2023-05-21T16:19:30Z", 1], ["2023-05-21T18:41:56Z", 1], ["2023-05-21T20:57:22Z", 1], ["2023-05-26T00:18:44Z", 1], ["2023-06-25T23:25:51Z", 1], ["2023-06-29T14:31:54Z", 1]] |
pull_requests,merged_by | pull_requests | merged_by | 560 | 560 | 0 | 0 | [[null, 560]] | |
pull_requests,milestone | pull_requests | milestone | 560 | 527 | 0 | 14 | [["None", 527], [6026070, 6], [8711695, 3], [6346396, 3], [5512395, 3], [5471110, 3], [3268330, 3], [7558727, 2], [5971510, 2], [4471010, 2]] | [[5234079, 1], [5533512, 1], [5897911, 1], [6055094, 1], [4471010, 2], [5971510, 2], [7558727, 2], [8355157, 2], [6346396, 3], [8711695, 3]] |
pull_requests,node_id | pull_requests | node_id | 560 | 0 | 0 | 560 | ||
pull_requests,number | pull_requests | number | 560 | 0 | 0 | 517 | [[8, 4], [5, 4], [67, 3], [65, 3], [15, 3], [6, 3], [9, 2], [7, 2], [4, 2], [1, 2]] | [[2075, 1], [2076, 1], [2077, 1], [2080, 1], [2082, 1], [2083, 1], [2096, 1], [2098, 1], [2099, 1], [2100, 1]] |
pull_requests,repo | pull_requests | repo | 560 | 0 | 0 | 14 | [[107914493, 400], [140912432, 102], [206156866, 13], [207052882, 11], [197882382, 7], [214746582, 6], [256834907, 5], [303218369, 4], [206649770, 4], [205429375, 3]] | [[197431109, 1], [213286752, 1], [611552758, 1], [248903544, 2], [205429375, 3], [206649770, 4], [303218369, 4], [256834907, 5], [214746582, 6], [197882382, 7]] |
pull_requests,state | pull_requests | state | 560 | 0 | 0 | 2 | [["closed", 470], ["open", 90]] | |
pull_requests,title | pull_requests | title | 560 | 0 | 0 | 556 | [["Use Read the Docs action v1", 2], ["Update deploying.rst", 2], ["Update README.md", 2], ["Add paths for homebrew on Apple silicon", 2], ["--crossdb option for joining across databases", 1], ["'datasette --get' option, refs #926", 1], ["\"permissions\" blocks in metadata.json/yaml", 1], ["\"datasette publish cloudrun\" command to publish to Google Cloud Run", 1], [" Import pysqlite3 if available, closes #360 ", 1], [" Don't duplicate simple primary keys in the link column", 1]] | [["table.update() method", 1], ["test commit", 1], ["test_insert_upsert_all_empty_list", 1], ["tiny typo in customization docs", 1], ["twitter-to-sqlite import command, refs #4", 1], ["upsert new rows with constraints, fixes #514", 1], ["use inspect data for hash and file size", 1], ["use jsonify_if_need for sql updates", 1], ["use single quotes for string literals, fixes #2001", 1], ["use universal command", 1]] |
pull_requests,updated_at | pull_requests | updated_at | 560 | 0 | 0 | 558 | [["2020-05-27T20:21:56Z", 3], ["2017-11-21T20:55:05Z", 1], ["2017-11-19T20:30:24Z", 1], ["2017-11-18T03:15:57Z", 1], ["2017-11-17T15:16:34Z", 1], ["2017-11-17T15:12:29Z", 1], ["2017-11-17T03:50:52Z", 1], ["2017-11-15T03:08:04Z", 1], ["2017-11-15T02:03:01Z", 1], ["2017-11-14T02:24:54Z", 1]] | [["2023-05-31T18:45:26Z", 1], ["2023-06-26T08:21:00Z", 1], ["2023-06-29T14:31:55Z", 1], ["2023-06-29T14:31:59Z", 1], ["2023-06-29T14:40:35Z", 1], ["2023-07-08T01:58:13Z", 1], ["2023-07-10T13:49:31Z", 1], ["2023-07-11T13:06:16Z", 1], ["2023-07-12T16:38:28Z", 1], ["2023-07-13T09:30:50Z", 1]] |
pull_requests,url | pull_requests | url | 560 | 0 | 0 | 560 | ||
pull_requests,user | pull_requests | user | 560 | 0 | 0 | 179 | [[9599, 195], [49699333, 70], [27856297, 21], [45057, 19], [536941, 8], [25778, 8], [3243482, 7], [2657547, 6], [26161409, 5], [49260, 4]] | [[37962604, 1], [39452697, 1], [56323389, 1], [72577720, 1], [87192257, 1], [91880982, 1], [99098079, 1], [102635518, 1], [111973926, 1], [130708713, 1]] |
pull_requests_fts,title | pull_requests_fts | title | 560 | 0 | 0 | 556 | [["Use Read the Docs action v1", 2], ["Update deploying.rst", 2], ["Update README.md", 2], ["Add paths for homebrew on Apple silicon", 2], ["--crossdb option for joining across databases", 1], ["'datasette --get' option, refs #926", 1], ["\"permissions\" blocks in metadata.json/yaml", 1], ["\"datasette publish cloudrun\" command to publish to Google Cloud Run", 1], [" Import pysqlite3 if available, closes #360 ", 1], [" Don't duplicate simple primary keys in the link column", 1]] | [["table.update() method", 1], ["test commit", 1], ["test_insert_upsert_all_empty_list", 1], ["tiny typo in customization docs", 1], ["twitter-to-sqlite import command, refs #4", 1], ["upsert new rows with constraints, fixes #514", 1], ["use inspect data for hash and file size", 1], ["use jsonify_if_need for sql updates", 1], ["use single quotes for string literals, fixes #2001", 1], ["use universal command", 1]] |
pull_requests_fts_docsize,id | pull_requests_fts_docsize | id | 560 | 0 | 0 | 560 | ||
pull_requests_fts_docsize,sz | pull_requests_fts_docsize | sz | 560 | 0 | 0 | 396 | [["b'\\x07\\x00'", 13], ["b'\\x08\\x02'", 11], ["b'\\x07\\x02'", 11], ["b'\\x06\\x00'", 11], ["b'\\x04\\x00'", 11], ["b'\\x05\\x02'", 10], ["b'\\x04\\x02'", 10], ["b'\\x06\\x02'", 8], ["b'\\x05\\x00'", 8], ["b'\\x03\\x00'", 6]] | [["b'\\x11\\x89.'", 1], ["b'\\x11\\x896'", 1], ["b'\\x11\\x89<'", 1], ["b'\\x11\\x89`'", 1], ["b'\\x11\\x89s'", 1], ["b'\\x11\\x8a\\r'", 1], ["b'\\x11\\x8a\\x1e'", 1], ["b'\\x11\\x8ax'", 1], ["b'\\x14z'", 1], ["b'\\x15g'", 1]] |
issue_comments_fts_data,block | issue_comments_fts_data | block | 688 | 0 | 0 | 688 | ||
issue_comments_fts_data,id | issue_comments_fts_data | id | 688 | 0 | 0 | 688 | ||
issue_comments_fts_idx,pgno | issue_comments_fts_idx | pgno | 943 | 0 | 0 | 288 | [[24, 6], [22, 6], [20, 6], [16, 6], [14, 6], [12, 6], [10, 6], [8, 6], [6, 6], [2, 6]] | [[626, 1], [628, 1], [630, 1], [632, 1], [636, 1], [638, 1], [640, 1], [642, 1], [644, 1], [646, 1]] |
issue_comments_fts_idx,segid | issue_comments_fts_idx | segid | 943 | 0 | 0 | 6 | [[5, 266], [4, 146], [3, 145], [2, 143], [1, 143], [6, 100]] |
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]) );