_analyze_tables_
350 rows sorted by least_common descending
This data as json, CSV (advanced)
Link | table | column | total_rows | num_null | num_blank | num_distinct | most_common | least_common ▲ |
---|---|---|---|---|---|---|---|---|
commits_fts_docsize,sz | commits_fts_docsize | sz | 3784 | 0 | 0 | 123 | [["b'\\x07'", 478], ["b'\\x08'", 454], ["b'\\x06'", 417], ["b'\\t'", 375], ["b'\\x05'", 307], ["b'\\n'", 236], ["b'\\x04'", 219], ["b'\\x03'", 195], ["b'\\x0b'", 151], ["b'\\x0c'", 107]] | [["b'\\x81&'", 1], ["b'\\x81,'", 1], ["b'\\x812'", 1], ["b'\\x819'", 1], ["b'\\x81>'", 1], ["b'\\x81?'", 1], ["b'\\x81['", 1], ["b'\\x81\\\\'", 1], ["b'\\x81h'", 1], ["b'\\x82\\x14'", 1]] |
issues_fts_docsize,sz | issues_fts_docsize | sz | 2892 | 0 | 0 | 1520 | [["b'\\x07\\x00'", 19], ["b'\\x06\\x00'", 16], ["b'\\x05\\x00'", 15], ["b'\\x04\\x00'", 14], ["b'\\x08\\x02'", 13], ["b'\\x07\\x02'", 13], ["b'\\t\\x00'", 13], ["b'\\x05\\x02'", 11], ["b'\\x04\\x02'", 10], ["b'\\x03\\x00'", 9]] | [["b'\\x14\\x81M'", 1], ["b'\\x14\\x81e'", 1], ["b'\\x14\\x82\\x11'", 1], ["b'\\x14o'", 1], ["b'\\x14z'", 1], ["b'\\x15\\x84='", 1], ["b'\\x15g'", 1], ["b'\\x15h'", 1], ["b'\\x16\\x06'", 1], ["b'\\x196'", 1]] |
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]] |
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]] |
milestones_fts_docsize,sz | milestones_fts_docsize | sz | 34 | 0 | 0 | 16 | [["b'\\x03\\x00'", 13], ["b'\\x02\\x00'", 7], ["b'\\x03\\x0e'", 1], ["b'\\x03\\x0c'", 1], ["b'\\x03\\x07'", 1], ["b'\\x03\\x05'", 1], ["b'\\x03\\n'", 1], ["b'\\x02\\x1c'", 1], ["b'\\x02\\x12'", 1], ["b'\\x02\\t'", 1]] | [["b'\\x03$'", 1], ["b'\\x03\\n'", 1], ["b'\\x03\\x07'", 1], ["b'\\x03\\x0c'", 1], ["b'\\x03\\x0e'", 1], ["b'\\x03\\x11'", 1], ["b'\\x03\\x1a'", 1], ["b'\\x04\\x0e'", 1], ["b'\\x05\\x00'", 1], ["b'\\x06\\x00'", 1]] |
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]] |
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]] |
issue_comments_fts_idx,term | issue_comments_fts_idx | term | 943 | 0 | 0 | 785 | [["b'0a0'", 6], ["b''", 6], ["b'0tho'", 5], ["b'0thea'", 5], ["b'0httpt'", 5], ["b'0worka'", 4], ["b'0uu'", 4], ["b'0off'", 4], ["b'0ite'", 4], ["b'030'", 3]] | [["b'0\\xe1'", 1], ["b'0widths'", 1], ["b'0withoutr'", 1], ["b'0wouldn'", 1], ["b'0writem'", 1], ["b'0writer'", 1], ["b'0wrot'", 1], ["b'0yc'", 1], ["b'0youg'", 1], ["b'0yours'", 1]] |
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]] |
repos,topics | repos | topics | 1329 | 0 | 0 | 238 | [["[]", 1024], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\"]", 29], ["[\"datasette\"]", 10], ["[\"sqlite\", \"sqlite-extension\"]", 9], ["[\"datasette\", \"datasette-plugin\"]", 8], ["[\"git-scraping\"]", 5], ["[\"lexibank1\"]", 3], ["[\"datasette-io\", \"datasette-plugin\"]", 3], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\", \"plugin\"]", 3], ["[\"api\", \"legal\", \"pydantic\", \"sqlite\"]", 2]] | [["[\"resident-advisor\", \"club-nights\"]", 1], ["[\"sandbox\"]", 1], ["[\"scotrail\"]", 1], ["[\"sqlite\", \"datasette-io\", \"datasette-tool\"]", 1], ["[\"sqlite\", \"myfitnesspal\", \"datasette\", \"dogsheep\", \"datasette-io\", \"datasette-t...", 1], ["[\"things-i-learned\", \"til\"]", 1], ["[\"til\", \"today-i-learned\", \"todayilearned\"]", 1], ["[\"wip-do-not-use\"]", 1], ["[\"wookieepedia\"]", 1], ["[\"xtce\", \"yaml-configuration\"]", 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_,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]] |
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]] |
milestones,title | milestones | title | 34 | 0 | 0 | 33 | [["1.0", 2], ["3.29", 1], ["3.21", 1], ["3.0", 1], ["2.20", 1], ["2.19", 1], ["0.51", 1], ["0.28", 1], ["0.23.1", 1], [" Datasette 1.0a2", 1]] | [["Datasette 0.60", 1], ["Datasette 0.62", 1], ["Datasette 1.0", 1], ["Datasette 1.0a0", 1], ["Datasette 1.0a1", 1], ["Datasette 1.0a3", 1], ["Datasette Next", 1], ["Foreign key edition", 1], ["Ship first public release", 1], ["v1 stretch goals", 1]] |
milestones_fts,title | milestones_fts | title | 34 | 0 | 0 | 33 | [["1.0", 2], ["3.29", 1], ["3.21", 1], ["3.0", 1], ["2.20", 1], ["2.19", 1], ["0.51", 1], ["0.28", 1], ["0.23.1", 1], [" Datasette 1.0a2", 1]] | [["Datasette 0.60", 1], ["Datasette 0.62", 1], ["Datasette 1.0", 1], ["Datasette 1.0a0", 1], ["Datasette 1.0a1", 1], ["Datasette 1.0a3", 1], ["Datasette Next", 1], ["Foreign key edition", 1], ["Ship first public release", 1], ["v1 stretch goals", 1]] |
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_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]] |
repos,language | repos | language | 1329 | 167 | 0 | 26 | [["Python", 762], ["None", 167], ["Jupyter Notebook", 103], ["HTML", 83], ["Shell", 58], ["JavaScript", 45], ["Makefile", 35], ["CSS", 12], ["Dockerfile", 11], ["TeX", 9]] | [["Clojure", 1], ["Elixir", 1], ["Hy", 1], ["Java", 1], ["PLpgSQL", 1], ["PureBasic", 1], ["Vim script", 1], ["WebAssembly", 1], ["Julia", 2], ["PHP", 2]] |
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]] |
labels,description | 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 | 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]] |
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]] |
milestones,description | 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 | 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]] |
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]] |
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]] |
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]] |
issue_comments,updated_at | issue_comments | updated_at | 9947 | 0 | 0 | 9946 | [["2021-01-04T19:52:40Z", 2], ["2017-10-23T19:23:29Z", 1], ["2017-10-23T15:28:11Z", 1], ["2017-10-23T02:29:05Z", 1], ["2017-10-23T02:18:36Z", 1], ["2017-10-23T02:16:33Z", 1], ["2017-10-23T02:15:41Z", 1], ["2017-10-23T01:35:17Z", 1], ["2017-10-23T01:20:30Z", 1], ["2017-10-23T01:15:24Z", 1]] | [["2023-07-14T16:32:49Z", 1], ["2023-07-14T17:02:03Z", 1], ["2023-07-17T02:23:32Z", 1], ["2023-07-17T17:14:20Z", 1], ["2023-07-17T17:25:12Z", 1], ["2023-07-17T21:27:41Z", 1], ["2023-07-17T21:42:37Z", 1], ["2023-07-18T11:47:21Z", 1], ["2023-07-18T19:08:50Z", 1], ["2023-07-18T22:41:37Z", 1]] |
issue_comments,created_at | issue_comments | created_at | 9947 | 0 | 0 | 9946 | [["2021-01-04T19:52:40Z", 2], ["2017-10-23T15:28:11Z", 1], ["2017-10-23T02:28:31Z", 1], ["2017-10-23T02:18:36Z", 1], ["2017-10-23T02:16:33Z", 1], ["2017-10-23T02:15:41Z", 1], ["2017-10-23T01:35:17Z", 1], ["2017-10-23T01:20:30Z", 1], ["2017-10-23T01:15:24Z", 1], ["2017-10-23T01:09:05Z", 1]] | [["2023-07-14T16:26:27Z", 1], ["2023-07-14T17:02:03Z", 1], ["2023-07-17T02:23:32Z", 1], ["2023-07-17T17:14:20Z", 1], ["2023-07-17T17:24:19Z", 1], ["2023-07-17T21:27:41Z", 1], ["2023-07-17T21:42:37Z", 1], ["2023-07-18T11:47:21Z", 1], ["2023-07-18T19:08:50Z", 1], ["2023-07-18T22:41:37Z", 1]] |
repos,updated_at | repos | updated_at | 1329 | 0 | 0 | 1317 | [["2021-11-24T19:31:59Z", 3], ["2022-12-10T00:06:05Z", 2], ["2022-11-21T08:21:35Z", 2], ["2022-10-31T13:47:34Z", 2], ["2022-09-01T10:42:32Z", 2], ["2022-07-18T23:51:45Z", 2], ["2022-07-06T18:40:32Z", 2], ["2022-02-28T23:42:41Z", 2], ["2021-09-11T10:57:40Z", 2], ["2020-10-31T14:01:13Z", 2]] | [["2023-07-13T21:14:27Z", 1], ["2023-07-14T19:45:37Z", 1], ["2023-07-14T19:47:49Z", 1], ["2023-07-15T07:05:31Z", 1], ["2023-07-15T19:41:49Z", 1], ["2023-07-17T00:58:30Z", 1], ["2023-07-17T09:23:52Z", 1], ["2023-07-18T08:42:15Z", 1], ["2023-07-18T15:50:48Z", 1], ["2023-07-19T01:56:05Z", 1]] |
repos,pushed_at | repos | pushed_at | 1329 | 0 | 0 | 1312 | [["2019-11-08T13:36:41Z", 6], ["2022-08-18T07:41:34Z", 2], ["2022-04-23T21:22:30Z", 2], ["2022-03-02T00:48:14Z", 2], ["2022-02-28T23:42:38Z", 2], ["2021-11-10T08:58:09Z", 2], ["2021-09-26T22:32:21Z", 2], ["2021-09-11T10:57:37Z", 2], ["2020-10-31T13:33:52Z", 2], ["2019-11-09T20:10:09Z", 2]] | [["2023-07-13T19:29:56Z", 1], ["2023-07-13T21:59:01Z", 1], ["2023-07-14T00:47:11Z", 1], ["2023-07-14T01:36:21Z", 1], ["2023-07-14T17:33:52Z", 1], ["2023-07-14T18:01:50Z", 1], ["2023-07-14T21:25:15Z", 1], ["2023-07-14T23:22:55Z", 1], ["2023-07-17T01:20:34Z", 1], ["2023-07-18T10:32:23Z", 1]] |
issues,updated_at | issues | updated_at | 2892 | 0 | 0 | 2782 | [["2019-05-29T21:39:12Z", 7], ["2022-03-19T04:04:49Z", 5], ["2022-02-05T00:04:26Z", 5], ["2021-06-17T18:12:32Z", 5], ["2018-07-24T04:53:20Z", 5], ["2022-01-13T22:21:29Z", 4], ["2021-06-17T18:14:24Z", 4], ["2021-06-17T18:12:31Z", 4], ["2020-10-23T19:44:06Z", 4], ["2020-09-30T20:36:12Z", 4]] | [["2023-07-12T16:38:28Z", 1], ["2023-07-13T09:30:50Z", 1], ["2023-07-13T15:24:18Z", 1], ["2023-07-14T17:02:03Z", 1], ["2023-07-17T02:23:32Z", 1], ["2023-07-17T16:18:25Z", 1], ["2023-07-17T21:42:37Z", 1], ["2023-07-18T11:47:21Z", 1], ["2023-07-18T19:08:50Z", 1], ["2023-07-18T22:41:37Z", 1]] |
commits,author_date | commits | author_date | 3784 | 0 | 0 | 3781 | [["2022-12-15T17:34:07Z", 2], ["2022-03-15T15:36:35Z", 2], ["2021-07-30T00:44:16Z", 2], ["2017-10-24T02:36:44Z", 1], ["2017-10-24T02:25:48Z", 1], ["2017-10-24T02:00:37Z", 1], ["2017-10-23T16:02:40Z", 1], ["2017-10-23T15:28:00Z", 1], ["2017-10-23T00:41:19Z", 1], ["2017-10-23T00:39:03Z", 1]] | [["2023-07-08T18:40:19Z", 1], ["2023-07-08T19:50:22Z", 1], ["2023-07-08T20:08:09Z", 1], ["2023-07-09T01:03:25Z", 1], ["2023-07-09T01:03:41Z", 1], ["2023-07-09T01:04:14Z", 1], ["2023-07-09T01:05:05Z", 1], ["2023-07-09T01:13:36Z", 1], ["2023-07-09T01:14:06Z", 1], ["2023-07-10T19:24:26Z", 1]] |
commits,committer_date | commits | committer_date | 3784 | 0 | 0 | 3656 | [["2018-05-16T15:27:24Z", 23], ["2022-12-17T21:47:55Z", 18], ["2020-10-27T19:39:55Z", 11], ["2018-04-09T05:10:22Z", 9], ["2020-06-01T01:16:42Z", 8], ["2022-12-31T18:52:37Z", 6], ["2022-01-06T06:24:53Z", 6], ["2020-11-06T18:30:41Z", 6], ["2019-07-03T03:23:05Z", 5], ["2018-05-14T03:04:23Z", 5]] | [["2023-07-08T18:00:08Z", 1], ["2023-07-08T18:22:21Z", 1], ["2023-07-08T18:35:15Z", 1], ["2023-07-08T18:40:19Z", 1], ["2023-07-08T19:50:22Z", 1], ["2023-07-08T20:08:09Z", 1], ["2023-07-09T01:05:05Z", 1], ["2023-07-09T01:13:36Z", 1], ["2023-07-09T01:14:06Z", 1], ["2023-07-10T19:24:26Z", 1]] |
issues,closed_at | issues | closed_at | 2892 | 748 | 0 | 2084 | [["None", 748], ["2020-10-29T22:01:39Z", 3], ["2019-06-30T23:50:55Z", 2], ["2019-05-01T23:01:57Z", 2], ["2019-02-24T04:02:20Z", 2], ["2018-08-05T00:14:57Z", 2], ["2018-07-26T05:16:00Z", 2], ["2018-05-22T19:35:22Z", 2], ["2018-05-04T18:05:04Z", 2], ["2018-04-13T18:18:59Z", 2]] | [["2023-06-14T23:11:47Z", 1], ["2023-06-25T23:25:51Z", 1], ["2023-06-27T18:50:08Z", 1], ["2023-06-29T14:31:54Z", 1], ["2023-06-29T14:48:10Z", 1], ["2023-06-29T15:24:13Z", 1], ["2023-07-03T04:58:21Z", 1], ["2023-07-03T05:42:30Z", 1], ["2023-07-08T20:08:13Z", 1], ["2023-07-09T01:19:42Z", 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,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,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]] |
milestones,closed_at | milestones | closed_at | 34 | 5 | 0 | 29 | [["None", 5], ["2020-03-25T04:07:02Z", 1], ["2019-07-08T03:36:57Z", 1], ["2019-05-25T01:28:06Z", 1], ["2019-05-19T22:24:03Z", 1], ["2018-06-21T15:47:15Z", 1], ["2017-12-10T02:05:05Z", 1], ["2017-11-30T16:49:38Z", 1], ["2017-11-14T08:27:33Z", 1], ["2017-11-14T08:24:21Z", 1]] | [["2020-11-29T02:43:04Z", 1], ["2022-01-10T19:25:44Z", 1], ["2022-01-11T18:41:13Z", 1], ["2022-01-13T22:22:24Z", 1], ["2022-01-14T01:44:41Z", 1], ["2022-08-14T18:03:28Z", 1], ["2022-10-18T18:26:45Z", 1], ["2022-11-29T20:11:39Z", 1], ["2022-12-02T01:24:26Z", 1], ["2022-12-20T20:01:13Z", 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]] | |
assets,browser_download_url | assets | browser_download_url | 1 | 0 | 0 | 1 | [["https://github.com/simonw/datasette/releases/download/0.53/datasette-0.53-macos-...", 1]] | |
assets,content_type | assets | content_type | 1 | 0 | 0 | 1 | [["application/zip", 1]] | |
assets,created_at | assets | created_at | 1 | 0 | 0 | 1 | [["2021-01-04T21:26:30Z", 1]] | |
assets,download_count | assets | download_count | 1 | 0 | 0 | 1 | [[49, 1]] | |
assets,id | assets | id | 1 | 0 | 0 | 1 | [[30264367, 1]] | |
assets,label | assets | label | 1 | 1 | 0 | 0 | [[null, 1]] | |
assets,name | assets | name | 1 | 0 | 0 | 1 | [["datasette-0.53-macos-binary.zip", 1]] | |
assets,node_id | assets | node_id | 1 | 0 | 0 | 1 | [["MDEyOlJlbGVhc2VBc3NldDMwMjY0MzY3", 1]] | |
assets,release | assets | release | 1 | 0 | 0 | 1 | [[35131848, 1]] | |
assets,size | assets | size | 1 | 0 | 0 | 1 | [[8297283, 1]] | |
assets,state | assets | state | 1 | 0 | 0 | 1 | [["uploaded", 1]] | |
assets,updated_at | assets | updated_at | 1 | 0 | 0 | 1 | [["2021-01-04T21:26:43Z", 1]] | |
assets,uploader | assets | uploader | 1 | 0 | 0 | 1 | [[9599, 1]] | |
assets,url | assets | url | 1 | 0 | 0 | 1 | [["https://api.github.com/repos/simonw/datasette/releases/assets/30264367", 1]] | |
commits,committer | commits | committer | 3784 | 8 | 0 | 4 | [[9599, 2926], [19864447, 839], ["None", 8], [21148, 6], [45057, 5]] | |
commits,raw_committer | commits | raw_committer | 3784 | 0 | 0 | 6 | [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2679], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 839], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]] | |
commits,sha | commits | sha | 3784 | 0 | 0 | 3784 | ||
commits_fts_config,k | commits_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
commits_fts_config,v | commits_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
commits_fts_data,block | commits_fts_data | block | 45 | 0 | 0 | 45 | ||
commits_fts_data,id | commits_fts_data | id | 45 | 0 | 0 | 45 | ||
commits_fts_docsize,id | commits_fts_docsize | id | 3784 | 0 | 0 | 3784 | ||
commits_fts_idx,pgno | commits_fts_idx | pgno | 43 | 0 | 0 | 43 | ||
commits_fts_idx,segid | commits_fts_idx | segid | 43 | 0 | 0 | 1 | [[1, 43]] | |
commits_fts_idx,term | commits_fts_idx | term | 43 | 0 | 0 | 43 | ||
dependents,first_seen_utc | dependents | first_seen_utc | 1658 | 0 | 0 | 1658 | ||
dependents,repo | dependents | repo | 1658 | 0 | 0 | 2 | [[140912432, 888], [107914493, 770]] | |
emojis,name | emojis | name | 1877 | 0 | 0 | 1877 | ||
issue_comments,author_association | issue_comments | author_association | 9947 | 0 | 0 | 4 | [["OWNER", 7931], ["NONE", 928], ["CONTRIBUTOR", 563], ["MEMBER", 525]] | |
issue_comments,html_url | issue_comments | html_url | 9947 | 0 | 0 | 9947 | ||
issue_comments,id | issue_comments | id | 9947 | 0 | 0 | 9947 | ||
issue_comments,node_id | issue_comments | node_id | 9947 | 0 | 0 | 9947 | ||
issue_comments,performed_via_github_app | issue_comments | performed_via_github_app | 9947 | 9947 | 0 | 0 | [[null, 9947]] | |
issue_comments_fts_config,k | issue_comments_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
issue_comments_fts_config,v | issue_comments_fts_config | v | 1 | 0 | 0 | 1 | [[4, 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_docsize,id | issue_comments_fts_docsize | id | 9947 | 0 | 0 | 9947 | ||
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]] | |
issues,active_lock_reason | issues | active_lock_reason | 2892 | 2892 | 0 | 0 | [[null, 2892]] | |
issues,assignee | issues | assignee | 2892 | 2872 | 0 | 2 | [["None", 2872], [9599, 19], [15178711, 1]] | |
issues,author_association | issues | author_association | 2892 | 0 | 0 | 6 | [["OWNER", 1783], ["CONTRIBUTOR", 444], ["NONE", 393], ["MEMBER", 208], ["FIRST_TIME_CONTRIBUTOR", 62], ["FIRST_TIMER", 2]] | |
issues,created_at | issues | created_at | 2892 | 0 | 0 | 2892 | ||
issues,draft | issues | draft | 2892 | 2332 | 0 | 2 | [["None", 2332], [0, 550], [1, 10]] | |
issues,id | issues | id | 2892 | 0 | 0 | 2892 | ||
issues,locked | issues | locked | 2892 | 0 | 0 | 1 | [[0, 2892]] | |
issues,node_id | issues | node_id | 2892 | 0 | 0 | 2892 | ||
issues,performed_via_github_app | issues | performed_via_github_app | 2892 | 2892 | 0 | 0 | [[null, 2892]] | |
issues,state | issues | state | 2892 | 0 | 0 | 2 | [["closed", 2144], ["open", 748]] | |
issues,state_reason | issues | state_reason | 2892 | 1214 | 0 | 3 | [["completed", 1673], ["None", 1214], ["reopened", 4], ["not_planned", 1]] | |
issues,type | issues | type | 2892 | 0 | 0 | 2 | [["issue", 2332], ["pull", 560]] | |
issues_fts_config,k | issues_fts_config | k | 1 | 0 | 0 | 1 | [["version", 1]] | |
issues_fts_config,v | issues_fts_config | v | 1 | 0 | 0 | 1 | [[4, 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 | ||
issues_fts_docsize,id | issues_fts_docsize | id | 2892 | 0 | 0 | 2892 | ||
issues_fts_idx,segid | issues_fts_idx | segid | 412 | 0 | 0 | 3 | [[1, 152], [2, 149], [3, 111]] | |
jobs,id | jobs | id | 54 | 0 | 0 | 54 | ||
jobs,if | jobs | if | 54 | 52 | 0 | 1 | [["None", 54]] | |
jobs,needs | jobs | needs | 54 | 41 | 0 | 2 | [["None", 41], ["[\"test\"]", 11], ["[\"deploy\"]", 2]] |
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]) );