_analyze_tables_
341 rows sorted by table descending
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 |
|---|---|---|---|---|---|---|---|---|
| workflows,repo | workflows | repo | 34 | 0 | 0 | 10 | [[107914493, 11], [140912432, 5], [207052882, 4], [206156866, 3], [303218369, 2], [248903544, 2], [205429375, 2], [197882382, 2], [197431109, 2], [256834907, 1]] | |
| workflows,on | workflows | on | 34 | 0 | 0 | 14 | [["{\"release\": {\"types\": [\"created\"]}}", 9], ["[\"push\"]", 8], ["[\"push\", \"pull_request\"]", 4], ["{\"workflow_dispatch\": null}", 2], ["{\"push\": {\"branches\": [\"main\"]}, \"pull_request\": {\"branches\": [\"main\"]}}", 2], ["{\"push\": {\"branches\": [\"master\", \"main\"]}}", 1], ["{\"push\": {\"branches\": [\"main\"]}}", 1], ["{\"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\": \"0 4 * * 5\"}]}", 1], ["{\"push\": {\"branches\": [\"main\", \"master\"], \"paths\": [\"README.md\"]}}", 1], ["{\"push\": null, \"pull_request\": null, \"workflow_dispatch\": null}", 1]] | [["{\"push\": null, \"pull_request\": null, \"workflow_dispatch\": null}", 1], ["{\"push\": {\"branches\": [\"main\", \"master\"], \"paths\": [\"README.md\"]}}", 1], ["{\"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\": \"0 4 * * 5\"}]}", 1], ["{\"push\": {\"branches\": [\"main\"]}}", 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\": {\"version_tag\": {\"description\": \"Tag to build a...", 1], ["{\"workflow_dispatch\": null}", 2]] |
| workflows,name | workflows | name | 34 | 0 | 0 | 15 | [["Test", 9], ["Publish Python Package", 9], ["Update README table of contents", 2], ["Check spelling in documentation", 2], ["Calculate test coverage", 2], ["Mirror \"master\" and \"main\" branches", 1], ["Deploy latest.datasette.io", 1], ["CodeQL", 1], ["Check JavaScript for conformance with Prettier", 1], ["Build and deploy demo", 1]] | [["Build and deploy demo", 1], ["Check JavaScript for conformance with Prettier", 1], ["CodeQL", 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,id | workflows | id | 34 | 0 | 0 | 34 | ||
| workflows,filename | workflows | filename | 34 | 0 | 0 | 15 | [["test.yml", 10], ["publish.yml", 9], ["test-coverage.yml", 2], ["spellcheck.yml", 2], ["push_docker_tag.yml", 1], ["prettier.yml", 1], ["mirror-master-and-main.yml", 1], ["deploy-latest.yml", 1], ["deploy-demo.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,env | workflows | env | 34 | 33 | 0 | 1 | [["None", 34]] | |
| users_fts_idx,term | users_fts_idx | term | 36 | 0 | 0 | 35 | [["b''", 2], ["b'0edd'", 1], ["b'0dial'", 1], ["b'0danie'", 1], ["b'0clev'", 1], ["b'0camf'", 1], ["b'0blaked'", 1], ["b'0awa'", 1], ["b'0andref'", 1], ["b'0agup'", 1]] | [["b'0rafg'", 1], ["b'0robb'", 1], ["b'0sarp'", 1], ["b'0sima'", 1], ["b'0stevens'", 1], ["b'0thc'", 1], ["b'0trev'", 1], ["b'0vu'", 1], ["b'0xp'", 1], ["b'0zt'", 1]] |
| users_fts_idx,segid | users_fts_idx | segid | 36 | 0 | 0 | 2 | [[1, 35], [2, 1]] | |
| users_fts_idx,pgno | users_fts_idx | pgno | 36 | 0 | 0 | 35 | [[2, 2], [20, 1], [18, 1], [16, 1], [14, 1], [12, 1], [10, 1], [8, 1], [6, 1], [4, 1]] | [[52, 1], [54, 1], [56, 1], [58, 1], [60, 1], [62, 1], [64, 1], [66, 1], [68, 1], [70, 1]] |
| users_fts_docsize,sz | users_fts_docsize | sz | 7918 | 0 | 0 | 4 | [["b'\\x01\\x01'", 7443], ["b'\\x02\\x02'", 434], ["b'\\x03\\x03'", 37], ["b'\\x04\\x04'", 4]] | |
| users_fts_docsize,id | users_fts_docsize | id | 7918 | 0 | 0 | 7918 | ||
| users_fts_data,id | users_fts_data | id | 38 | 0 | 0 | 38 | ||
| users_fts_data,block | users_fts_data | block | 38 | 0 | 0 | 38 | ||
| users_fts_config,v | users_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
| users_fts_config,k | users_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
| users_fts,name | users_fts | name | 7918 | 0 | 0 | 7918 | ||
| users_fts,login | users_fts | login | 7918 | 0 | 0 | 7918 | ||
| users,type | users | type | 7918 | 0 | 0 | 3 | [["User", 7834], ["Organization", 81], ["Bot", 3]] | |
| users,site_admin | users | site_admin | 7918 | 0 | 0 | 2 | [[0, 7904], [1, 14]] | |
| users,node_id | users | node_id | 7918 | 0 | 0 | 7918 | ||
| users,name | users | name | 7918 | 0 | 0 | 7918 | ||
| users,login | users | login | 7918 | 0 | 0 | 7918 | ||
| users,id | users | id | 7918 | 0 | 0 | 7918 | ||
| users,html_url | users | html_url | 7918 | 0 | 0 | 7918 | ||
| users,gravatar_id | users | gravatar_id | 7918 | 0 | 7918 | 1 | [["", 7918]] | |
| users,avatar_url | users | avatar_url | 7918 | 0 | 0 | 7918 | ||
| tags,sha | tags | sha | 341 | 0 | 0 | 341 | ||
| tags,repo | tags | repo | 341 | 0 | 0 | 14 | [[107914493, 119], [140912432, 111], [206156866, 29], [207052882, 23], [197431109, 20], [197882382, 9], [205429375, 6], [303218369, 5], [256834907, 5], [248903544, 5]] | [[209590345, 1], [206649770, 2], [206202864, 3], [213286752, 3], [248903544, 5], [256834907, 5], [303218369, 5], [205429375, 6], [197882382, 9], [197431109, 20]] |
| tags,name | tags | name | 341 | 0 | 0 | 248 | [["0.2", 10], ["0.1", 9], ["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.26.1", 1], ["3.3", 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]] |
| steps,with | steps | with | 230 | 147 | 0 | 18 | [["None", 147], ["{\"path\": \"~/.cache/pip\", \"key\": \"${{ runner.os }}-pip-${{ hashFiles('**/setup.py...", 25], ["{\"python-version\": \"${{ matrix.python-version }}\"}", 19], ["{\"path\": \"~/.cache/pip\", \"key\": \"${{ runner.os }}-publish-pip-${{ hashFiles('**/...", 10], ["{\"python-version\": \"3.9\"}", 7], ["{\"python-version\": 3.9}", 4], ["{\"version\": \"275.0.0\", \"service_account_email\": \"${{ secrets.GCP_SA_EMAIL }}\", \"...", 3], ["{\"python-version\": \"3.10\"}", 3], ["{\"token\": \"${{ secrets.CODECOV_TOKEN }}\", \"file\": \"coverage.xml\"}", 2], ["{\"fetch-depth\": 2}", 1]] | [["{\"fetch-depth\": 2}", 1], ["{\"languages\": \"${{ matrix.language }}\"}", 1], ["{\"path\": \"github.db\"}", 1], ["{\"path\": \"~/.cache/ms-playwright/\", \"key\": \"${{ runner.os }}-browsers\"}", 1], ["{\"path\": \"~/.npm\", \"key\": \"${{ runner.OS }}-npm-${{ hashFiles('**/package-lock.j...", 1], ["{\"python-version\": \"3.10\", \"cache\": \"pip\", \"cache-dependency-path\": \"**/setup.py...", 1], ["{\"python-version\": \"3.8\"}", 1], ["{\"python-version\": 3.8}", 1], ["{\"target-branch\": \"main\", \"force\": false}", 1], ["{\"target-branch\": \"master\", \"force\": false}", 1]] |
| steps,uses | steps | uses | 230 | 100 | 0 | 15 | [["None", 100], ["actions/checkout@v2", 43], ["actions/cache@v2", 35], ["actions/setup-python@v2", 33], ["google-github-actions/setup-gcloud@v0", 3], ["zofrex/mirror-branch@ea152f124954fa4eb26eea3fe0dbe313a3a08d94", 2], ["mxschmitt/action-tmate@v3", 2], ["codecov/codecov-action@v1", 2], ["actions/setup-python@v1", 2], ["actions/cache@v1", 2]] | [["actions/checkout@v3", 1], ["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], ["zofrex/mirror-branch@ea152f124954fa4eb26eea3fe0dbe313a3a08d94", 2]] |
| steps,seq | steps | seq | 230 | 0 | 0 | 11 | [[2, 45], [1, 45], [3, 40], [4, 38], [5, 37], [6, 7], [7, 6], [10, 3], [9, 3], [8, 3]] | [[8, 3], [9, 3], [10, 3], [11, 3], [7, 6], [6, 7], [5, 37], [4, 38], [3, 40], [2, 45]] |
| steps,run | steps | run | 230 | 130 | 0 | 46 | [["None", 130], ["pip install -e '.[test]'\n", 16], ["pytest\n", 15], ["python setup.py sdist bdist_wheel\ntwine upload dist/*\n", 9], ["pip install setuptools wheel twine\n", 9], ["pytest -v\n", 3], ["pip install -e '.[docs]'\n", 2], ["npx markdown-toc README.md -i", 2], ["git diff\ngit config --global user.email \"readme-bot@example.com\"\ngit config --gl...", 2], ["cd docs\nsphinx-build -b xml . _build\nsphinx-to-sqlite ../docs.db _build\ncd ..", 2]] | [["pip install -e '.[test]'\npip freeze\n", 1], ["pip install numpy", 1], ["pip install shot-scraper build\nshot-scraper install\n", 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,repo | steps | repo | 230 | 0 | 0 | 10 | [[107914493, 65], [140912432, 38], [207052882, 29], [206156866, 18], [303218369, 15], [248903544, 15], [205429375, 15], [197882382, 15], [197431109, 15], [256834907, 5]] | |
| steps,name | steps | name | 230 | 38 | 0 | 46 | [["None", 38], ["Configure pip caching", 35], ["Install dependencies", 32], ["Set up Python ${{ matrix.python-version }}", 21], ["Run tests", 21], ["Set up Python", 14], ["Publish", 9], ["Check out repo", 5], ["Install Python dependencies", 4], ["Set up Cloud Run", 3]] | [["Mirror to \"master\"", 1], ["Optionally install numpy", 1], ["Perform CodeQL Analysis", 1], ["Run prettier", 1], ["Run test", 1], ["Set up Python 3.10", 1], ["Set up the alternate-route demo", 1], ["Test with pytest", 1], ["run flake8", 1], ["run mypy", 1]] |
| steps,job | steps | job | 230 | 0 | 0 | 45 | [[20682, 11], [20663, 11], [20645, 11], [20681, 7], [20674, 7], [20668, 7], [20672, 6], [20640, 5], [20639, 5], [20638, 5]] | [[20664, 2], [20669, 2], [20670, 2], [20675, 2], [20676, 2], [20648, 3], [20661, 3], [20665, 4], [20679, 5], [20680, 5]] |
| steps,if | steps | if | 230 | 223 | 0 | 5 | [["None", 223], ["${{ github.ref == 'refs/heads/main' }}", 3], ["matrix.os == 'ubuntu-latest'", 1], ["matrix.numpy == 1", 1], ["${{ github.event_name == 'pull_request' }}", 1], ["!contains(github.event.head_commit.message, 'REFRESH_DB')", 1]] | |
| steps,id | steps | id | 230 | 0 | 0 | 230 | ||
| steps,env | steps | env | 230 | 218 | 0 | 4 | [["None", 218], ["{\"TWINE_USERNAME\": \"__token__\", \"TWINE_PASSWORD\": \"${{ secrets.PYPI_TOKEN }}\"}", 9], ["{\"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]] | |
| stars,user | stars | user | 8441 | 0 | 0 | 7319 | [[366688, 10], [41546558, 8], [7476523, 8], [46511, 8], [178424, 7], [128885, 7], [62937, 7], [48793, 7], [14772, 7], [8886, 7]] | [[98190180, 1], [98228097, 1], [98233413, 1], [98310755, 1], [98478474, 1], [98595377, 1], [100347187, 1], [102198784, 1], [103208179, 1], [103871546, 1]] |
| stars,starred_at | stars | starred_at | 8441 | 0 | 0 | 8438 | [["2019-07-10T11:27:06Z", 2], ["2017-11-14T13:01:37Z", 2], ["2017-11-14T05:14:41Z", 2], ["2017-11-14T00:25:28Z", 1], ["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]] | [["2022-05-29T13:25:37Z", 1], ["2022-05-29T14:14:28Z", 1], ["2022-05-29T14:55:07Z", 1], ["2022-05-29T15:33:37Z", 1], ["2022-05-29T16:24:53Z", 1], ["2022-05-29T18:17:01Z", 1], ["2022-05-29T18:50:16Z", 1], ["2022-05-29T18:58:14Z", 1], ["2022-05-29T19:59:16Z", 1], ["2022-05-30T00:42:13Z", 1]] |
| stars,repo | stars | repo | 8441 | 0 | 0 | 15 | [[107914493, 6237], [140912432, 888], [206156866, 331], [207052882, 207], [256834907, 143], [197431109, 141], [197882382, 126], [214746582, 109], [206649770, 67], [213286752, 59]] | [[206202864, 4], [209590345, 16], [303218369, 28], [248903544, 38], [205429375, 47], [213286752, 59], [206649770, 67], [214746582, 109], [197882382, 126], [197431109, 141]] |
| repos_fts_idx,term | repos_fts_idx | term | 15 | 0 | 0 | 15 | ||
| repos_fts_idx,segid | repos_fts_idx | segid | 15 | 0 | 0 | 1 | [[1, 15]] | |
| repos_fts_idx,pgno | repos_fts_idx | pgno | 15 | 0 | 0 | 15 | ||
| repos_fts_docsize,sz | repos_fts_docsize | sz | 774 | 0 | 0 | 95 | [["b'\\x02\\x00'", 93], ["b'\\x01\\x00'", 74], ["b'\\x03\\x00'", 54], ["b'\\x03\\x08'", 31], ["b'\\x03\\t'", 25], ["b'\\x02\\x07'", 24], ["b'\\x01\\x03'", 24], ["b'\\x03\\x07'", 23], ["b'\\x03\\x06'", 21], ["b'\\x02\\x05'", 21]] | [["b'\\x04\\x1d'", 1], ["b'\\x04\\x1e'", 1], ["b'\\x05 '", 1], ["b'\\x05\\r'", 1], ["b'\\x05\\x06'", 1], ["b'\\x05\\x07'", 1], ["b'\\x05\\x13'", 1], ["b'\\x05\\x17'", 1], ["b'\\x06!'", 1], ["b'\\x06\\x07'", 1]] |
| repos_fts_docsize,id | repos_fts_docsize | id | 774 | 0 | 0 | 774 | ||
| repos_fts_data,id | repos_fts_data | id | 17 | 0 | 0 | 17 | ||
| repos_fts_data,block | repos_fts_data | block | 17 | 0 | 0 | 17 | ||
| repos_fts_config,v | repos_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
| repos_fts_config,k | repos_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
| repos_fts,name | repos_fts | name | 774 | 0 | 0 | 681 | [["til", 26], ["datasette", 14], ["covid19-dashboard", 13], ["devops_aula07", 9], ["devops-aula07", 7], ["TIL", 5], ["sqlite-for-data-scientists", 3], ["CloudGoat", 2], ["Book-Attic", 2], ["202002_s_devops-aula07", 2]] | [["wrc-timing", 1], ["wsb-collection", 1], ["wumb-to-sqlite", 1], ["xmltotabular", 1], ["yacht-database", 1], ["yaml-to-sqlite", 1], ["z1007816", 1], ["zctaimpacts", 1], ["zero-server", 1], ["zhaobai", 1]] |
| repos_fts,description | repos_fts | description | 774 | 240 | 0 | 497 | [["None", 240], ["A site that displays up to date COVID-19 stats, powered by fastpages.", 13], ["Today I Learned", 8], ["An open source multi-tool for exploring and publishing data", 5], ["A tool for exploring and publishing data", 4], ["Create a SQLite database containing data from your Pocket account", 2], ["Auto-Update of new grades from The Open University of Israel", 2], ["Analysis of bpo", 2], ["A free Python-distribution for Windows platform, including prebuilt packages for...", 2], ["A crawler for open hardware projects", 2]] | [["✉️ Datasette plugin to render email addresses as mailto: links", 1], ["网上课堂管理系统", 1], ["🌍 Import geographic and spatial data from files into a SpatiaLite DB", 1], ["🎓 coding exercises from leetcode, hackerrank, codesignal etc.", 1], ["👨⚕️ health stats from my apple watch", 1], ["📝 Today I Learned", 1], ["📦 course materials, demos, and hands-outs for all the courses I have taken till...", 1], ["📦 data crawler", 1], ["📰 Today I Learned", 1], ["📻 my notes on various topics", 1]] |
| repos,watchers_count | repos | watchers_count | 774 | 0 | 0 | 48 | [[0, 558], [1, 75], [2, 32], [3, 19], [7, 9], [5, 8], [4, 8], [6, 7], [12, 4], [8, 4]] | [[106, 1], [126, 1], [183, 1], [200, 1], [321, 1], [872, 1], [1057, 1], [1062, 1], [1445, 1], [6136, 1]] |
| repos,watchers | repos | watchers | 774 | 0 | 0 | 48 | [[0, 558], [1, 75], [2, 32], [3, 19], [7, 9], [5, 8], [4, 8], [6, 7], [12, 4], [8, 4]] | [[106, 1], [126, 1], [183, 1], [200, 1], [321, 1], [872, 1], [1057, 1], [1062, 1], [1445, 1], [6136, 1]] |
| repos,visibility | repos | visibility | 774 | 552 | 0 | 1 | [["None", 774]] | |
| repos,updated_at | repos | updated_at | 774 | 0 | 0 | 772 | [["2021-11-24T19:31:59Z", 3], ["2018-12-20T22:34:35Z", 1], ["2018-12-08T18:42:15Z", 1], ["2018-11-15T17:58:45Z", 1], ["2018-10-21T10:34:22Z", 1], ["2018-08-19T18:44:00Z", 1], ["2018-05-25T15:38:58Z", 1], ["2018-04-25T08:22:11Z", 1], ["2018-04-19T05:48:18Z", 1], ["2017-12-26T18:54:41Z", 1]] | [["2022-05-27T05:00:45Z", 1], ["2022-05-27T11:50:17Z", 1], ["2022-05-27T12:03:24Z", 1], ["2022-05-27T12:04:31Z", 1], ["2022-05-27T13:24:03Z", 1], ["2022-05-28T16:30:27Z", 1], ["2022-05-28T17:00:31Z", 1], ["2022-05-29T11:09:51Z", 1], ["2022-05-29T18:58:14Z", 1], ["2022-05-30T00:42:13Z", 1]] |
| repos,topics | repos | topics | 774 | 0 | 0 | 156 | [["[]", 570], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\"]", 27], ["[\"datasette\"]", 9], ["[\"git-scraping\"]", 4], ["[\"lexibank1\"]", 3], ["[\"datasette-io\", \"datasette-plugin\"]", 3], ["[\"datasette\", \"datasette-plugin\"]", 3], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\", \"plugin\"]", 3], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\", \"leafletjs\"]", 2], ["[\"coronavirus\", \"database\", \"datasette\", \"sql\"]", 2]] | [["[\"python\", \"sqlite\", \"spatial-data\", \"spatialite\", \"datasette\"]", 1], ["[\"python\", \"template\", \"sqlite\", \"datasette\", \"gitpod\"]", 1], ["[\"python\"]", 1], ["[\"rechte-gewalt\", \"tatortrechts\"]", 1], ["[\"resident-advisor\", \"club-nights\"]", 1], ["[\"sqlite\", \"datasette-io\", \"datasette-tool\"]", 1], ["[\"sqlite\", \"myfitnesspal\", \"datasette\", \"dogsheep\", \"datasette-io\", \"datasette-t...", 1], ["[\"til\", \"today-i-learned\", \"todayilearned\"]", 1], ["[\"wip-do-not-use\"]", 1], ["[\"xtce\", \"yaml-configuration\"]", 1]] |
| repos,template_repository | repos | template_repository | 774 | 763 | 0 | 8 | [["None", 763], ["{\"id\": 383002759, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzODMwMDI3NTk=\", \"name\": \"templa...", 3], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 401177473, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDExNzc0NzM=\", \"name\": \"click-...", 1], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 1], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 1], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 1]] | |
| repos,temp_clone_token | repos | temp_clone_token | 774 | 0 | 774 | 1 | [["", 774]] | |
| repos,subscribers_count | repos | subscribers_count | 774 | 0 | 0 | 20 | [[1, 562], [0, 68], [2, 58], [3, 33], [4, 15], [6, 10], [5, 7], [7, 5], [12, 3], [8, 2]] | [[9, 1], [11, 1], [14, 1], [18, 1], [23, 1], [56, 1], [94, 1], [99, 1], [154, 1], [10, 2]] |
| repos,stargazers_count | repos | stargazers_count | 774 | 0 | 0 | 48 | [[0, 558], [1, 75], [2, 32], [3, 19], [7, 9], [5, 8], [4, 8], [6, 7], [12, 4], [8, 4]] | [[106, 1], [126, 1], [183, 1], [200, 1], [321, 1], [872, 1], [1057, 1], [1062, 1], [1445, 1], [6136, 1]] |
| repos,source | repos | source | 774 | 742 | 0 | 31 | [["None", 742], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 2], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1]] | [["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 1], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 1], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 1], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 1], ["{\"id\": 257022147, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNTcwMjIxNDc=\", \"name\": \"til\", ...", 1], ["{\"id\": 257022147, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNTcwMjIxNDc=\", \"name\": \"til\", ...", 1], ["{\"id\": 257022147, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNTcwMjIxNDc=\", \"name\": \"til\", ...", 1], ["{\"id\": 279645039, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNzk2NDUwMzk=\", \"name\": \"vidyab...", 1], ["{\"id\": 292243861, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyOTIyNDM4NjE=\", \"name\": \"Grades...", 1], ["{\"id\": 382441536, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzODI0NDE1MzY=\", \"name\": \"intro_...", 1]] |
| repos,size | repos | size | 774 | 0 | 0 | 415 | [[0, 36], [3, 26], [7, 21], [8, 20], [5, 20], [4, 18], [10, 16], [9, 16], [11, 14], [6, 13]] | [[765368, 1], [765924, 1], [766394, 1], [767103, 1], [768388, 1], [768427, 1], [768432, 1], [771971, 1], [1289400, 1], [5200284, 1]] |
| repos,pushed_at | repos | pushed_at | 774 | 0 | 0 | 772 | [["2021-11-10T08:58:09Z", 2], ["2020-11-24T23:25:14Z", 2], ["2018-10-10T15:26:09Z", 1], ["2018-09-29T04:50:26Z", 1], ["2018-08-16T00:58:57Z", 1], ["2018-05-25T15:38:56Z", 1], ["2018-04-25T08:22:10Z", 1], ["2018-04-23T19:05:45Z", 1], ["2018-04-19T05:48:18Z", 1], ["2017-12-26T18:54:41Z", 1]] | [["2022-05-22T15:50:34Z", 1], ["2022-05-25T14:47:48Z", 1], ["2022-05-26T01:38:50Z", 1], ["2022-05-27T03:13:59Z", 1], ["2022-05-27T05:00:41Z", 1], ["2022-05-27T12:03:13Z", 1], ["2022-05-27T12:04:20Z", 1], ["2022-05-29T00:17:20Z", 1], ["2022-05-29T01:42:45Z", 1], ["2022-05-29T11:43:24Z", 1]] |
| repos,private | repos | private | 774 | 0 | 0 | 1 | [[0, 774]] | |
| repos,permissions | repos | permissions | 774 | 0 | 0 | 5 | [["{\"admin\": false, \"push\": false, \"pull\": true}", 373], ["{\"admin\": false, \"maintain\": false, \"push\": false, \"triage\": false, \"pull\": true...", 242], ["{\"admin\": true, \"push\": true, \"pull\": true}", 108], ["{\"admin\": true, \"maintain\": true, \"push\": true, \"triage\": true, \"pull\": true}", 50], ["{\"admin\": false, \"push\": true, \"pull\": true}", 1]] | |
| repos,parent | repos | parent | 774 | 742 | 0 | 31 | [["None", 742], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 2], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 1]] | [["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 1], ["{\"id\": 257022147, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNTcwMjIxNDc=\", \"name\": \"til\", ...", 1], ["{\"id\": 257022147, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNTcwMjIxNDc=\", \"name\": \"til\", ...", 1], ["{\"id\": 257022147, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNTcwMjIxNDc=\", \"name\": \"til\", ...", 1], ["{\"id\": 279645039, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNzk2NDUwMzk=\", \"name\": \"vidyab...", 1], ["{\"id\": 292243861, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyOTIyNDM4NjE=\", \"name\": \"Grades...", 1], ["{\"id\": 382441536, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzODI0NDE1MzY=\", \"name\": \"intro_...", 1], ["{\"id\": 423549186, \"node_id\": \"R_kgDOGT7ZAg\", \"name\": \"covid19-dashboard\", \"full_...", 1], ["{\"id\": 426357499, \"node_id\": \"R_kgDOGWmy-w\", \"name\": \"covid19-dashboard\", \"full_...", 1], ["{\"id\": 466635830, \"node_id\": \"R_kgDOG9BMNg\", \"name\": \"covid19-dashboard\", \"full_...", 1]] |
| repos,owner | repos | owner | 774 | 0 | 0 | 464 | [[9599, 145], [53015001, 13], [25778, 10], [44060760, 9], [5802411, 9], [38107867, 7], [59372422, 6], [55949623, 5], [9857779, 5], [78035, 5]] | [[91842948, 1], [91912885, 1], [92047518, 1], [93546675, 1], [93766133, 1], [93947784, 1], [94083909, 1], [94403920, 1], [95031004, 1], [95301613, 1]] |
| repos,organization | repos | organization | 774 | 640 | 0 | 79 | [["None", 640], [53015001, 13], [44060760, 9], [38107867, 7], [89875467, 5], [80003822, 4], [62152414, 3], [48291663, 3], [35539682, 3], [1905990, 3]] | [[77848345, 1], [81873563, 1], [84056280, 1], [85930339, 1], [86156616, 1], [91842948, 1], [92047518, 1], [94083909, 1], [94403920, 1], [95031004, 1]] |
| repos,open_issues_count | repos | open_issues_count | 774 | 0 | 0 | 28 | [[0, 556], [1, 75], [2, 34], [3, 28], [4, 23], [5, 11], [7, 5], [6, 5], [12, 4], [8, 4]] | [[19, 1], [22, 1], [24, 1], [30, 1], [32, 1], [34, 1], [36, 1], [58, 1], [77, 1], [390, 1]] |
| repos,open_issues | repos | open_issues | 774 | 0 | 0 | 28 | [[0, 556], [1, 75], [2, 34], [3, 28], [4, 23], [5, 11], [7, 5], [6, 5], [12, 4], [8, 4]] | [[19, 1], [22, 1], [24, 1], [30, 1], [32, 1], [34, 1], [36, 1], [58, 1], [77, 1], [390, 1]] |
| repos,node_id | repos | node_id | 774 | 0 | 0 | 774 | ||
| repos,network_count | repos | network_count | 774 | 0 | 0 | 47 | [[0, 619], [1, 67], [2, 15], [3, 11], [5, 6], [4, 5], [6, 4], [24, 2], [9, 2], [7, 2]] | [[337, 1], [370, 1], [387, 1], [401, 1], [414, 1], [420, 1], [423, 1], [428, 1], [438, 1], [439, 1]] |
| repos,name | repos | name | 774 | 0 | 0 | 681 | [["til", 26], ["datasette", 14], ["covid19-dashboard", 13], ["devops_aula07", 9], ["devops-aula07", 7], ["TIL", 5], ["sqlite-for-data-scientists", 3], ["CloudGoat", 2], ["Book-Attic", 2], ["202002_s_devops-aula07", 2]] | [["wrc-timing", 1], ["wsb-collection", 1], ["wumb-to-sqlite", 1], ["xmltotabular", 1], ["yacht-database", 1], ["yaml-to-sqlite", 1], ["z1007816", 1], ["zctaimpacts", 1], ["zero-server", 1], ["zhaobai", 1]] |
| repos,license | repos | license | 774 | 430 | 0 | 14 | [["None", 430], ["apache-2.0", 172], ["mit", 109], ["other", 17], ["gpl-3.0", 14], ["bsd-3-clause", 10], ["agpl-3.0", 6], ["unlicense", 4], ["cc-by-4.0", 4], ["bsd-2-clause", 2]] | [["eupl-1.2", 1], ["gpl-2.0", 1], ["lgpl-2.1", 1], ["wtfpl", 1], ["bsd-2-clause", 2], ["cc0-1.0", 2], ["cc-by-4.0", 4], ["unlicense", 4], ["agpl-3.0", 6], ["bsd-3-clause", 10]] |
| repos,language | repos | language | 774 | 69 | 0 | 20 | [["Python", 463], ["None", 69], ["Jupyter Notebook", 65], ["HTML", 54], ["Shell", 34], ["JavaScript", 33], ["Makefile", 17], ["CSS", 8], ["TeX", 7], ["R", 5]] | [["C", 1], ["Hy", 1], ["Java", 1], ["PLpgSQL", 1], ["Procfile", 1], ["Rust", 1], ["Vim script", 1], ["WebAssembly", 1], ["Julia", 2], ["Dockerfile", 4]] |
| repos,is_template | repos | is_template | 774 | 557 | 0 | 2 | [["None", 557], [0, 216], [1, 1]] | |
| repos,id | repos | id | 774 | 0 | 0 | 774 | ||
| repos,html_url | repos | html_url | 774 | 0 | 0 | 774 | ||
| repos,homepage | repos | homepage | 774 | 478 | 157 | 113 | [["None", 478], ["", 157], ["https://covid19dashboards.com", 13], ["https://datasette.io", 5], ["https://til.simonwillison.net/", 4], ["http://datasette.readthedocs.io/", 4], ["https://fara.datasettes.com/", 2], ["https://dogsheep.github.io/", 2], ["https://docs.datasette.io", 2], ["https://covid-19.datasettes.com/", 2]] | [["https://www.jrtorres042@github.enterprise.org/git_covid19-dashboard", 1], ["https://www.niche-museums.com/", 1], ["https://www.opensunshine.herokuapp.com", 1], ["https://www.tacosdedatos.com/", 1], ["https://zctaimpacts.abrie.dev", 1], ["links-mads-hartmann-com.vercel.app", 1], ["my-database-project-git-main.testberg.vercel.app", 1], ["pocket-data-datasette-kasperzutterman.vercel.app", 1], ["unabandaql-ng-git-master.jazzido.vercel.app", 1], ["vumc-resident-map.vercel.app", 1]] |
| repos,has_wiki | repos | has_wiki | 774 | 0 | 0 | 2 | [[1, 748], [0, 26]] | |
| repos,has_projects | repos | has_projects | 774 | 0 | 0 | 2 | [[1, 750], [0, 24]] | |
| repos,has_pages | repos | has_pages | 774 | 0 | 0 | 2 | [[0, 749], [1, 25]] | |
| repos,has_issues | repos | has_issues | 774 | 0 | 0 | 2 | [[1, 736], [0, 38]] | |
| repos,has_downloads | repos | has_downloads | 774 | 0 | 0 | 2 | [[1, 773], [0, 1]] | |
| repos,full_name | repos | full_name | 774 | 0 | 0 | 774 | ||
| repos,forks_count | repos | forks_count | 774 | 0 | 0 | 25 | [[0, 649], [1, 67], [2, 15], [3, 10], [6, 4], [5, 4], [4, 4], [24, 2], [9, 2], [7, 2]] | [[19, 1], [22, 1], [28, 1], [30, 1], [55, 1], [65, 1], [199, 1], [309, 1], [331, 1], [422, 1]] |
| repos,forks | repos | forks | 774 | 0 | 0 | 25 | [[0, 649], [1, 67], [2, 15], [3, 10], [6, 4], [5, 4], [4, 4], [24, 2], [9, 2], [7, 2]] | [[19, 1], [22, 1], [28, 1], [30, 1], [55, 1], [65, 1], [199, 1], [309, 1], [331, 1], [422, 1]] |
| repos,fork | repos | fork | 774 | 0 | 0 | 2 | [[0, 742], [1, 32]] | |
| repos,disabled | repos | disabled | 774 | 0 | 0 | 1 | [[0, 774]] | |
| repos,description | repos | description | 774 | 240 | 0 | 497 | [["None", 240], ["A site that displays up to date COVID-19 stats, powered by fastpages.", 13], ["Today I Learned", 8], ["An open source multi-tool for exploring and publishing data", 5], ["A tool for exploring and publishing data", 4], ["Create a SQLite database containing data from your Pocket account", 2], ["Auto-Update of new grades from The Open University of Israel", 2], ["Analysis of bpo", 2], ["A free Python-distribution for Windows platform, including prebuilt packages for...", 2], ["A crawler for open hardware projects", 2]] | [["✉️ Datasette plugin to render email addresses as mailto: links", 1], ["网上课堂管理系统", 1], ["🌍 Import geographic and spatial data from files into a SpatiaLite DB", 1], ["🎓 coding exercises from leetcode, hackerrank, codesignal etc.", 1], ["👨⚕️ health stats from my apple watch", 1], ["📝 Today I Learned", 1], ["📦 course materials, demos, and hands-outs for all the courses I have taken till...", 1], ["📦 data crawler", 1], ["📰 Today I Learned", 1], ["📻 my notes on various topics", 1]] |
| repos,delete_branch_on_merge | repos | delete_branch_on_merge | 774 | 615 | 0 | 2 | [["None", 615], [0, 158], [1, 1]] | |
| repos,default_branch | repos | default_branch | 774 | 0 | 0 | 9 | [["master", 401], ["main", 364], ["develop", 3], ["trunk", 1], ["test", 1], ["new_sql", 1], ["latest", 1], ["dev", 1], ["Main", 1]] | |
| repos,created_at | repos | created_at | 774 | 0 | 0 | 774 | ||
| repos,archived | repos | archived | 774 | 0 | 0 | 2 | [[0, 773], [1, 1]] | |
| repos,allow_update_branch | repos | allow_update_branch | 774 | 739 | 0 | 1 | [["None", 774]] | |
| repos,allow_squash_merge | repos | allow_squash_merge | 774 | 615 | 0 | 1 | [["None", 774]] | |
| repos,allow_rebase_merge | repos | allow_rebase_merge | 774 | 615 | 0 | 1 | [["None", 774]] | |
| repos,allow_merge_commit | repos | allow_merge_commit | 774 | 615 | 0 | 1 | [["None", 774]] |
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]) );