_analyze_tables_
350 rows sorted by column 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 |
---|---|---|---|---|---|---|---|---|
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]] |
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]] |
repos,web_commit_signoff_required | repos | web_commit_signoff_required | 1329 | 770 | 0 | 2 | [["None", 770], [0, 552], [1, 7]] | |
repos,watchers_count | repos | watchers_count | 1329 | 0 | 0 | 67 | [[0, 952], [1, 138], [2, 57], [3, 34], [5, 15], [4, 15], [7, 12], [6, 10], [12, 6], [8, 5]] | [[314, 1], [334, 1], [364, 1], [387, 1], [1057, 1], [1062, 1], [1230, 1], [1260, 1], [1445, 1], [7995, 1]] |
repos,watchers | repos | watchers | 1329 | 0 | 0 | 67 | [[0, 952], [1, 138], [2, 57], [3, 34], [5, 15], [4, 15], [7, 12], [6, 10], [12, 6], [8, 5]] | [[314, 1], [334, 1], [364, 1], [387, 1], [1057, 1], [1062, 1], [1230, 1], [1260, 1], [1445, 1], [7995, 1]] |
repos,visibility | repos | visibility | 1329 | 543 | 0 | 1 | [["None", 1329]] | |
licenses_fts_config,v | licenses_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
repos_fts_config,v | repos_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
users_fts_config,v | users_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
commits_fts_config,v | commits_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
milestones_fts_config,v | milestones_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
issues_fts_config,v | issues_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
releases_fts_config,v | releases_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
labels_fts_config,v | labels_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
issue_comments_fts_config,v | issue_comments_fts_config | v | 1 | 0 | 0 | 1 | [[4, 1]] | |
pull_requests_fts_config,v | pull_requests_fts_config | v | 1 | 0 | 0 | 1 | [[4, 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]] |
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]] |
issues,user | issues | user | 2892 | 0 | 0 | 401 | [[9599, 1991], [49699333, 70], [536941, 32], [45057, 26], [27856297, 22], [25778, 22], [82988, 18], [192568, 16], [7908073, 14], [3243482, 14]] | [[57859326, 1], [69208826, 1], [76450761, 1], [80409402, 1], [83080728, 1], [87192257, 1], [91880982, 1], [102635518, 1], [111973926, 1], [130708713, 1]] |
issue_comments,user | issue_comments | user | 9947 | 0 | 0 | 367 | [[9599, 8456], [22429695, 204], [536941, 79], [25778, 70], [45057, 39], [82988, 35], [3243482, 26], [193185, 24], [95570, 24], [192568, 22]] | [[49702524, 1], [52261150, 1], [60892516, 1], [63653929, 1], [76450761, 1], [76528036, 1], [80409402, 1], [89400147, 1], [95520595, 1], [102771161, 1]] |
stars,user | stars | user | 11236 | 0 | 0 | 9675 | [[100658940, 10], [366688, 10], [178424, 10], [41546558, 9], [948118, 9], [7476523, 8], [161718, 8], [128885, 8], [46511, 8], [14772, 8]] | [[132673404, 1], [134146004, 1], [134528840, 1], [134682577, 1], [135533341, 1], [136005892, 1], [137419843, 1], [137427584, 1], [139175847, 1], [139538131, 1]] |
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]] |
repos,use_squash_pr_title_as_default | repos | use_squash_pr_title_as_default | 1329 | 1266 | 0 | 1 | [["None", 1329]] | |
licenses,url | licenses | url | 16 | 1 | 0 | 15 | [["https://api.github.com/licenses/gpl-2.0", 1], ["https://api.github.com/licenses/eupl-1.2", 1], ["https://api.github.com/licenses/cc0-1.0", 1], ["https://api.github.com/licenses/cc-by-4.0", 1], ["https://api.github.com/licenses/bsd-3-clause-clear", 1], ["https://api.github.com/licenses/bsd-3-clause", 1], ["https://api.github.com/licenses/bsd-2-clause", 1], ["https://api.github.com/licenses/apache-2.0", 1], ["https://api.github.com/licenses/agpl-3.0", 1], ["None", 1]] | [["https://api.github.com/licenses/cc-by-4.0", 1], ["https://api.github.com/licenses/cc0-1.0", 1], ["https://api.github.com/licenses/eupl-1.2", 1], ["https://api.github.com/licenses/gpl-2.0", 1], ["https://api.github.com/licenses/gpl-3.0", 1], ["https://api.github.com/licenses/lgpl-2.1", 1], ["https://api.github.com/licenses/mit", 1], ["https://api.github.com/licenses/mpl-2.0", 1], ["https://api.github.com/licenses/unlicense", 1], ["https://api.github.com/licenses/wtfpl", 1]] |
labels,url | labels | url | 103 | 0 | 0 | 103 | ||
emojis,url | emojis | url | 1877 | 0 | 0 | 1834 | [["https://github.githubassets.com/images/icons/emoji/unicode/1f4a9.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f44a.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f34a.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f42c.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f41d.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f3ee.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f3c3.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f314.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f1ec-1f1e7.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f1ea-1f1fa.png?v8", 2]] | [["https://github.githubassets.com/images/icons/emoji/unicode/2b06.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b07.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b1b.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b1c.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b50.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b55.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3030.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/303d.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3297.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3299.png?v8", 1]] |
pull_requests,url | pull_requests | url | 560 | 0 | 0 | 560 | ||
assets,url | assets | url | 1 | 0 | 0 | 1 | [["https://api.github.com/repos/simonw/datasette/releases/assets/30264367", 1]] | |
assets,uploader | assets | uploader | 1 | 0 | 0 | 1 | [[9599, 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]] |
milestones,updated_at | milestones | updated_at | 34 | 0 | 0 | 34 | ||
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]] |
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]] |
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]] |
assets,updated_at | assets | updated_at | 1 | 0 | 0 | 1 | [["2021-01-04T21:26:43Z", 1]] | |
users,type | users | type | 10621 | 0 | 0 | 3 | [["User", 10489], ["Organization", 129], ["Bot", 3]] | |
issues,type | issues | type | 2892 | 0 | 0 | 2 | [["issue", 2332], ["pull", 560]] | |
_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]] |
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]] |
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]] |
issues,title | issues | title | 2892 | 0 | 0 | 2877 | [["Update deploying.rst", 2], ["Update README.md", 2], ["Test against Python 3.11-dev", 2], ["TemplateAssertionError: no filter named 'tojson'", 2], ["Support for generated columns", 2], ["Magic parameters for canned queries", 2], ["Drop support for Python 3.6", 2], ["Configure sphinx.ext.extlinks for issues", 2], ["Add paths for homebrew on Apple silicon", 2], ["Add SpatiaLite helpers to CLI", 2]] | [["utils.parse_metadata() should be a documented internal function", 1], ["v0.54 500 error from sql query in custom template; code worked in v0.53; found a...", 1], ["validating the sql", 1], ["view_name = \"query\" for the query page", 1], ["when hashed urls are turned on, the _memory db has improperly long-lived cache e...", 1], ["word-wrap: anywhere resulting in weird display", 1], ["xml.etree.ElementTree.Parse Error - mismatched tag", 1], ["xml.etree.ElementTree.ParseError: not well-formed (invalid token)", 1], ["{\"$file\": ...} mechanism is broken", 1], ["{{ csrftoken() }} doesn't work with datasette.render_template()", 1]] |
issues_fts,title | issues_fts | title | 2892 | 0 | 0 | 2877 | [["Update deploying.rst", 2], ["Update README.md", 2], ["Test against Python 3.11-dev", 2], ["TemplateAssertionError: no filter named 'tojson'", 2], ["Support for generated columns", 2], ["Magic parameters for canned queries", 2], ["Drop support for Python 3.6", 2], ["Configure sphinx.ext.extlinks for issues", 2], ["Add paths for homebrew on Apple silicon", 2], ["Add SpatiaLite helpers to CLI", 2]] | [["utils.parse_metadata() should be a documented internal function", 1], ["v0.54 500 error from sql query in custom template; code worked in v0.53; found a...", 1], ["validating the sql", 1], ["view_name = \"query\" for the query page", 1], ["when hashed urls are turned on, the _memory db has improperly long-lived cache e...", 1], ["word-wrap: anywhere resulting in weird display", 1], ["xml.etree.ElementTree.Parse Error - mismatched tag", 1], ["xml.etree.ElementTree.ParseError: not well-formed (invalid token)", 1], ["{\"$file\": ...} mechanism is broken", 1], ["{{ csrftoken() }} doesn't work with datasette.render_template()", 1]] |
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_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]] |
licenses_fts_idx,term | licenses_fts_idx | term | 1 | 0 | 0 | 1 | [["b''", 1]] | |
repos_fts_idx,term | repos_fts_idx | term | 23 | 0 | 0 | 23 | ||
users_fts_idx,term | users_fts_idx | term | 48 | 0 | 0 | 48 | ||
commits_fts_idx,term | commits_fts_idx | term | 43 | 0 | 0 | 43 | ||
milestones_fts_idx,term | milestones_fts_idx | term | 1 | 0 | 0 | 1 | [["b''", 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]] |
releases_fts_idx,term | releases_fts_idx | term | 45 | 0 | 0 | 45 | ||
labels_fts_idx,term | labels_fts_idx | term | 1 | 0 | 0 | 1 | [["b''", 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]] |
pull_requests_fts_idx,term | pull_requests_fts_idx | term | 122 | 0 | 0 | 122 | ||
repos,template_repository | repos | template_repository | 1329 | 1278 | 0 | 34 | [["None", 1278], ["{\"id\": 566008212, \"node_id\": \"R_kgDOIbyZlA\", \"name\": \"warehouse-etl\", \"full_name...", 4], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 4], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 3], ["{\"id\": 383002759, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzODMwMDI3NTk=\", \"name\": \"templa...", 3], ["{\"id\": 424823623, \"node_id\": \"R_kgDOGVJLRw\", \"name\": \"glam-workbench-template\", ...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2]] | [["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 1], ["{\"id\": 401177473, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDExNzc0NzM=\", \"name\": \"click-...", 1], ["{\"id\": 404397410, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDQzOTc0MTA=\", \"name\": \"python...", 1], ["{\"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\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 515375569, \"node_id\": \"R_kgDOHrgB0Q\", \"name\": \"cloud-data-quality\", \"full...", 1], ["{\"id\": 521799111, \"node_id\": \"R_kgDOHxoFxw\", \"name\": \"redbean-template\", \"full_n...", 1], ["{\"id\": 614348767, \"node_id\": \"R_kgDOJJ433w\", \"name\": \"ci-full-template\", \"full_n...", 1]] |
repos,temp_clone_token | repos | temp_clone_token | 1329 | 0 | 1329 | 1 | [["", 1329]] | |
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,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]] |
_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]] |
licenses_fts_docsize,sz | licenses_fts_docsize | sz | 16 | 0 | 0 | 7 | [["b'\\x06'", 5], ["b'\\x07'", 3], ["b'\\x05'", 3], ["b'\\x02'", 2], ["b'\\x04'", 1], ["b'\\x01'", 1], ["b'\\n'", 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]] |
users_fts_docsize,sz | users_fts_docsize | sz | 10621 | 0 | 0 | 6 | [["b'\\x01\\x01'", 9901], ["b'\\x02\\x02'", 650], ["b'\\x03\\x03'", 60], ["b'\\x04\\x04'", 6], ["b'\\x05\\x05'", 3], ["b'\\x06\\x06'", 1]] | |
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]] |
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]] |
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]] |
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]] |
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]] | |
issue_comments_fts_docsize,sz | issue_comments_fts_docsize | sz | 9947 | 0 | 0 | 508 | [["b'\\x0f'", 216], ["b'\\x12'", 209], ["b'\\x10'", 203], ["b'\\x0e'", 199], ["b'\\x0c'", 188], ["b'\\r'", 184], ["b'\\x16'", 180], ["b'\\x13'", 176], ["b'\\x15'", 163], ["b'\\x0b'", 162]] | [["b'\\x8a\\x0b'", 1], ["b'\\x8b\"'", 1], ["b'\\x8b5'", 1], ["b'\\x8bh'", 1], ["b'\\x8c\\x05'", 1], ["b'\\x8fK'", 1], ["b'\\x927'", 1], ["b'\\x92}'", 1], ["b'\\x9f\\\\'", 1], ["b'\\xb3.'", 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,subscribers_count | repos | subscribers_count | 1329 | 0 | 0 | 20 | [[1, 897], [0, 178], [2, 122], [3, 51], [4, 24], [6, 13], [5, 13], [7, 8], [8, 4], [9, 3]] | [[14, 1], [20, 1], [23, 1], [56, 1], [94, 1], [102, 1], [154, 1], [10, 3], [11, 3], [12, 3]] |
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]] | |
issues,state_reason | issues | state_reason | 2892 | 1214 | 0 | 3 | [["completed", 1673], ["None", 1214], ["reopened", 4], ["not_planned", 1]] | |
milestones,state | milestones | state | 34 | 0 | 0 | 2 | [["closed", 29], ["open", 5]] | |
issues,state | issues | state | 2892 | 0 | 0 | 2 | [["closed", 2144], ["open", 748]] | |
pull_requests,state | pull_requests | state | 560 | 0 | 0 | 2 | [["closed", 470], ["open", 90]] | |
assets,state | assets | state | 1 | 0 | 0 | 1 | [["uploaded", 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]] |
repos,stargazers_count | repos | stargazers_count | 1329 | 0 | 0 | 67 | [[0, 952], [1, 138], [2, 57], [3, 34], [5, 15], [4, 15], [7, 12], [6, 10], [12, 6], [8, 5]] | [[314, 1], [334, 1], [364, 1], [387, 1], [1057, 1], [1062, 1], [1230, 1], [1260, 1], [1445, 1], [7995, 1]] |
repos,squash_merge_commit_title | repos | squash_merge_commit_title | 1329 | 1275 | 0 | 1 | [["None", 1329]] | |
repos,squash_merge_commit_message | repos | squash_merge_commit_message | 1329 | 1275 | 0 | 1 | [["None", 1329]] | |
licenses,spdx_id | licenses | spdx_id | 16 | 0 | 0 | 16 | ||
repos,source | repos | source | 1329 | 1201 | 0 | 74 | [["None", 1201], ["{\"id\": 349504954, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzNDk1MDQ5NTQ=\", \"name\": \"cloud-...", 31], ["{\"id\": 415345233, \"node_id\": \"R_kgDOGMGqUQ\", \"name\": \"omspy\", \"full_name\": \"uber...", 8], ["{\"id\": 280696796, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyODA2OTY3OTY=\", \"name\": \"calish...", 5], ["{\"id\": 220291151, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjAyOTExNTE=\", \"name\": \"pinboa...", 5], ["{\"id\": 408509890, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDg1MDk4OTA=\", \"name\": \"htmls-...", 4], ["{\"id\": 194628275, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxOTQ2MjgyNzU=\", \"name\": \"junior...", 3], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 2], ["{\"id\": 220697897, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjA2OTc4OTc=\", \"name\": \"lastfm...", 2], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 2]] | [["{\"id\": 399308604, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzOTkzMDg2MDQ=\", \"name\": \"datase...", 1], ["{\"id\": 403239260, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDMyMzkyNjA=\", \"name\": \"pulse-...", 1], ["{\"id\": 409650041, \"node_id\": \"R_kgDOGGrDeQ\", \"name\": \"LOSH-krawler\", \"full_name\"...", 1], ["{\"id\": 415345233, \"node_id\": \"R_kgDOGMGqUQ\", \"name\": \"omspy\", \"full_name\": \"uber...", 1], ["{\"id\": 445218858, \"node_id\": \"R_kgDOGomAKg\", \"name\": \"starred-repos\", \"full_name...", 1], ["{\"id\": 456560389, \"node_id\": \"R_kgDOGzaPBQ\", \"name\": \"coros-to-sqlite\", \"full_na...", 1], ["{\"id\": 459821110, \"node_id\": \"R_kgDOG2hQNg\", \"name\": \"google-drive-to-sqlite\", \"...", 1], ["{\"id\": 464677284, \"node_id\": \"R_kgDOG7JppA\", \"name\": \"calishot\", \"full_name\": \"K...", 1], ["{\"id\": 579841533, \"node_id\": \"R_kgDOIo-t_Q\", \"name\": \"slothful-myles\", \"full_nam...", 1], ["{\"id\": 581302435, \"node_id\": \"R_kgDOIqX4ow\", \"name\": \"mastodon-to-sqlite\", \"full...", 1]] |
repos,size | repos | size | 1329 | 0 | 0 | 700 | [[8, 36], [0, 36], [3, 33], [9, 28], [11, 27], [4, 25], [7, 23], [5, 23], [10, 22], [17, 17]] | [[791181, 1], [1124434, 1], [1205836, 1], [1215453, 1], [1216794, 1], [1289400, 1], [3264862, 1], [3875967, 1], [5200284, 1], [5204108, 1]] |
assets,size | assets | size | 1 | 0 | 0 | 1 | [[8297283, 1]] | |
users,site_admin | users | site_admin | 10621 | 0 | 0 | 2 | [[0, 10597], [1, 24]] | |
commits,sha | commits | sha | 3784 | 0 | 0 | 3784 | ||
tags,sha | tags | sha | 368 | 0 | 0 | 368 | ||
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]] |
licenses_fts_idx,segid | licenses_fts_idx | segid | 1 | 0 | 0 | 1 | [[1, 1]] | |
repos_fts_idx,segid | repos_fts_idx | segid | 23 | 0 | 0 | 1 | [[1, 23]] | |
users_fts_idx,segid | users_fts_idx | segid | 48 | 0 | 0 | 1 | [[1, 48]] | |
commits_fts_idx,segid | commits_fts_idx | segid | 43 | 0 | 0 | 1 | [[1, 43]] | |
milestones_fts_idx,segid | milestones_fts_idx | segid | 1 | 0 | 0 | 1 | [[1, 1]] | |
issues_fts_idx,segid | issues_fts_idx | segid | 412 | 0 | 0 | 3 | [[1, 152], [2, 149], [3, 111]] | |
releases_fts_idx,segid | releases_fts_idx | segid | 45 | 0 | 0 | 1 | [[1, 45]] | |
labels_fts_idx,segid | labels_fts_idx | segid | 1 | 0 | 0 | 1 | [[1, 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]] | |
pull_requests_fts_idx,segid | pull_requests_fts_idx | segid | 122 | 0 | 0 | 1 | [[1, 122]] | |
repos,security_and_analysis | repos | security_and_analysis | 1329 | 1290 | 0 | 3 | [["None", 1290], ["{\"secret_scanning\": {\"status\": \"disabled\"}, \"secret_scanning_push_protection\": {...", 17], ["{\"secret_scanning\": {\"status\": \"disabled\"}, \"secret_scanning_push_protection\": {...", 14], ["{\"secret_scanning\": {\"status\": \"disabled\"}, \"secret_scanning_push_protection\": {...", 8]] |
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]) );