_analyze_tables_
336 rows where num_blank = 0 sorted by most_common
This data as json, CSV (advanced)
Link | table | column | total_rows | num_null | num_blank | num_distinct | most_common ▼ | least_common |
---|---|---|---|---|---|---|---|---|
users,id | users | id | 10621 | 0 | 0 | 10621 | ||
users,node_id | users | node_id | 10621 | 0 | 0 | 10621 | ||
users,avatar_url | users | avatar_url | 10621 | 0 | 0 | 10621 | ||
repos,id | repos | id | 1329 | 0 | 0 | 1329 | ||
repos,node_id | repos | node_id | 1329 | 0 | 0 | 1329 | ||
repos,full_name | repos | full_name | 1329 | 0 | 0 | 1329 | ||
repos,html_url | repos | html_url | 1329 | 0 | 0 | 1329 | ||
repos,created_at | repos | created_at | 1329 | 0 | 0 | 1329 | ||
licenses,key | licenses | key | 16 | 0 | 0 | 16 | ||
licenses,name | licenses | name | 16 | 0 | 0 | 16 | ||
licenses,spdx_id | licenses | spdx_id | 16 | 0 | 0 | 16 | ||
licenses,node_id | licenses | node_id | 16 | 0 | 0 | 16 | ||
licenses_fts_data,id | licenses_fts_data | id | 3 | 0 | 0 | 3 | ||
licenses_fts_data,block | licenses_fts_data | block | 3 | 0 | 0 | 3 | ||
licenses_fts_docsize,id | licenses_fts_docsize | id | 16 | 0 | 0 | 16 | ||
repos_fts_data,id | repos_fts_data | id | 25 | 0 | 0 | 25 | ||
repos_fts_data,block | repos_fts_data | block | 25 | 0 | 0 | 25 | ||
repos_fts_idx,term | repos_fts_idx | term | 23 | 0 | 0 | 23 | ||
repos_fts_idx,pgno | repos_fts_idx | pgno | 23 | 0 | 0 | 23 | ||
repos_fts_docsize,id | repos_fts_docsize | id | 1329 | 0 | 0 | 1329 | ||
users_fts_data,id | users_fts_data | id | 50 | 0 | 0 | 50 | ||
users_fts_data,block | users_fts_data | block | 50 | 0 | 0 | 50 | ||
users_fts_idx,term | users_fts_idx | term | 48 | 0 | 0 | 48 | ||
users_fts_idx,pgno | users_fts_idx | pgno | 48 | 0 | 0 | 48 | ||
users_fts_docsize,id | users_fts_docsize | id | 10621 | 0 | 0 | 10621 | ||
licenses_fts,name | licenses_fts | name | 16 | 0 | 0 | 16 | ||
raw_authors,id | raw_authors | id | 114 | 0 | 0 | 114 | ||
commits,sha | commits | sha | 3784 | 0 | 0 | 3784 | ||
commits_fts_data,id | commits_fts_data | id | 45 | 0 | 0 | 45 | ||
commits_fts_data,block | commits_fts_data | block | 45 | 0 | 0 | 45 | ||
commits_fts_idx,term | commits_fts_idx | term | 43 | 0 | 0 | 43 | ||
commits_fts_idx,pgno | commits_fts_idx | pgno | 43 | 0 | 0 | 43 | ||
commits_fts_docsize,id | commits_fts_docsize | id | 3784 | 0 | 0 | 3784 | ||
milestones,id | milestones | id | 34 | 0 | 0 | 34 | ||
milestones,html_url | milestones | html_url | 34 | 0 | 0 | 34 | ||
milestones,node_id | milestones | node_id | 34 | 0 | 0 | 34 | ||
milestones,created_at | milestones | created_at | 34 | 0 | 0 | 34 | ||
milestones,updated_at | milestones | updated_at | 34 | 0 | 0 | 34 | ||
milestones_fts_data,id | milestones_fts_data | id | 3 | 0 | 0 | 3 | ||
milestones_fts_data,block | milestones_fts_data | block | 3 | 0 | 0 | 3 | ||
milestones_fts_docsize,id | milestones_fts_docsize | id | 34 | 0 | 0 | 34 | ||
issues,id | issues | id | 2892 | 0 | 0 | 2892 | ||
issues,node_id | issues | node_id | 2892 | 0 | 0 | 2892 | ||
issues,created_at | issues | created_at | 2892 | 0 | 0 | 2892 | ||
issues_fts_data,id | issues_fts_data | id | 420 | 0 | 0 | 420 | ||
issues_fts_data,block | issues_fts_data | block | 420 | 0 | 0 | 420 | ||
issues_fts_docsize,id | issues_fts_docsize | id | 2892 | 0 | 0 | 2892 | ||
releases,html_url | releases | html_url | 344 | 0 | 0 | 344 | ||
releases,id | releases | id | 344 | 0 | 0 | 344 | ||
releases,node_id | releases | node_id | 344 | 0 | 0 | 344 | ||
releases,created_at | releases | created_at | 344 | 0 | 0 | 344 | ||
releases,published_at | releases | published_at | 344 | 0 | 0 | 344 | ||
releases_fts_data,id | releases_fts_data | id | 47 | 0 | 0 | 47 | ||
releases_fts_data,block | releases_fts_data | block | 47 | 0 | 0 | 47 | ||
releases_fts_idx,term | releases_fts_idx | term | 45 | 0 | 0 | 45 | ||
releases_fts_idx,pgno | releases_fts_idx | pgno | 45 | 0 | 0 | 45 | ||
releases_fts_docsize,id | releases_fts_docsize | id | 344 | 0 | 0 | 344 | ||
labels,id | labels | id | 103 | 0 | 0 | 103 | ||
labels,node_id | labels | node_id | 103 | 0 | 0 | 103 | ||
labels,url | labels | url | 103 | 0 | 0 | 103 | ||
labels_fts_data,id | labels_fts_data | id | 3 | 0 | 0 | 3 | ||
labels_fts_data,block | labels_fts_data | block | 3 | 0 | 0 | 3 | ||
labels_fts_docsize,id | labels_fts_docsize | id | 103 | 0 | 0 | 103 | ||
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_fts_data,id | issue_comments_fts_data | id | 688 | 0 | 0 | 688 | ||
issue_comments_fts_data,block | issue_comments_fts_data | block | 688 | 0 | 0 | 688 | ||
issue_comments_fts_docsize,id | issue_comments_fts_docsize | id | 9947 | 0 | 0 | 9947 | ||
dependents,first_seen_utc | dependents | first_seen_utc | 1658 | 0 | 0 | 1658 | ||
tags,sha | tags | sha | 368 | 0 | 0 | 368 | ||
emojis,name | emojis | name | 1877 | 0 | 0 | 1877 | ||
workflows,id | workflows | id | 41 | 0 | 0 | 41 | ||
jobs,id | jobs | id | 54 | 0 | 0 | 54 | ||
steps,id | steps | id | 262 | 0 | 0 | 262 | ||
pull_requests,id | pull_requests | id | 560 | 0 | 0 | 560 | ||
pull_requests,node_id | pull_requests | node_id | 560 | 0 | 0 | 560 | ||
pull_requests,created_at | pull_requests | created_at | 560 | 0 | 0 | 560 | ||
pull_requests,head | pull_requests | head | 560 | 0 | 0 | 560 | ||
pull_requests,url | pull_requests | url | 560 | 0 | 0 | 560 | ||
pull_requests_fts_data,id | pull_requests_fts_data | id | 126 | 0 | 0 | 126 | ||
pull_requests_fts_data,block | pull_requests_fts_data | block | 126 | 0 | 0 | 126 | ||
pull_requests_fts_idx,term | pull_requests_fts_idx | term | 122 | 0 | 0 | 122 | ||
pull_requests_fts_idx,pgno | pull_requests_fts_idx | pgno | 122 | 0 | 0 | 122 | ||
pull_requests_fts_docsize,id | pull_requests_fts_docsize | id | 560 | 0 | 0 | 560 | ||
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]] |
releases,tag_name | releases | tag_name | 344 | 0 | 0 | 267 | [["0.2", 8], ["0.3", 7], ["0.1", 7], ["0.4", 6], ["0.7", 4], ["0.5", 4], ["0.3.1", 4], ["0.1a", 4], ["0.12", 3], ["0.10", 3]] | [["3.32.1", 1], ["3.33", 1], ["3.4", 1], ["3.4.1", 1], ["3.5", 1], ["3.6", 1], ["3.7", 1], ["3.8", 1], ["3.9", 1], ["3.9.1", 1]] |
releases,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]] |
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]] |
commits,raw_committer | commits | raw_committer | 3784 | 0 | 0 | 6 | [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2679], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 839], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]] | |
commits,raw_author | commits | raw_author | 3784 | 0 | 0 | 113 | [["13ae486343ea6454a93114c6f558ffea2f2c6874", 3311], ["2946d096d0cdefdc017559e6b57e87658736e843", 229], ["5df307d91b1167b0aa175853783d760add239497", 48], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 20], ["2edd38cb3801aa07f709f083eba7cbe4f16e0978", 17], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 7], ["90786fb02407ad60f10210c0592ee711a9a36fae", 6], ["b90d9715d7c0881515e9d6aa98923ed89d445945", 5], ["106fe7fbf8b80a01038e265a137b3b703422db48", 5]] | [["ddda3e8cc5167e6bdbab6819a1f4e8e2621f4e89", 1], ["e7784035c9ce3ef64d906c543907d5025673d054", 1], ["eab1e8f71bd05f2ff2163f024127cc28876dd05d", 1], ["f25304fb12f6d6fab36f551427610ed8e96f0c2f", 1], ["f2f4d10a554519ea00fb44a5f6377123c59e1f22", 1], ["f333c00958a658720cd93e305aac71711b88e52b", 1], ["f3dfe1c3cf166dd0b9b8860a25045107a068c5df", 1], ["f85fb7898f36734a83fd9c8a2c2e96c751920c35", 1], ["f98e0e8fe6ee48ca1f752bb408eecbbd294f9ceb", 1], ["fcf3b31d4679bb2112170ec4dda53dede33a16b3", 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,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]] |
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]] |
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]] |
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]] |
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]] |
assets,created_at | assets | created_at | 1 | 0 | 0 | 1 | [["2021-01-04T21:26:30Z", 1]] |
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]) );