_analyze_tables_
336 rows where num_blank = 0 sorted by column
This data as json, CSV (advanced)
Link | table | column ▼ | total_rows | num_null | num_blank | num_distinct | most_common | least_common |
---|---|---|---|---|---|---|---|---|
issues,active_lock_reason | issues | active_lock_reason | 2892 | 2892 | 0 | 0 | [[null, 2892]] | |
repos,allow_auto_merge | repos | allow_auto_merge | 1329 | 1229 | 0 | 1 | [["None", 1329]] | |
repos,allow_forking | repos | allow_forking | 1329 | 526 | 0 | 1 | [["None", 1329]] | |
repos,allow_merge_commit | repos | allow_merge_commit | 1329 | 1120 | 0 | 1 | [["None", 1329]] | |
repos,allow_rebase_merge | repos | allow_rebase_merge | 1329 | 1120 | 0 | 1 | [["None", 1329]] | |
repos,allow_squash_merge | repos | allow_squash_merge | 1329 | 1120 | 0 | 1 | [["None", 1329]] | |
repos,allow_update_branch | repos | allow_update_branch | 1329 | 1244 | 0 | 1 | [["None", 1329]] | |
repos,archived | repos | archived | 1329 | 0 | 0 | 2 | [[0, 1324], [1, 5]] | |
issues,assignee | issues | assignee | 2892 | 2872 | 0 | 2 | [["None", 2872], [9599, 19], [15178711, 1]] | |
pull_requests,assignee | pull_requests | assignee | 560 | 557 | 0 | 2 | [["None", 557], [9599, 2], [15178711, 1]] | |
commits,author | commits | author | 3784 | 8 | 0 | 107 | [[9599, 3540], [49699333, 48], [45057, 20], [27856297, 17], ["None", 8], [21148, 7], [198537, 6], [25778, 6], [3243482, 5], [2657547, 5]] | [[16001974, 1], [17075617, 1], [22578954, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [56323389, 1], [72577720, 1], [99098079, 1]] |
releases,author | releases | author | 344 | 0 | 0 | 1 | [[9599, 344]] | |
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]] | |
issue_comments,author_association | issue_comments | author_association | 9947 | 0 | 0 | 4 | [["OWNER", 7931], ["NONE", 928], ["CONTRIBUTOR", 563], ["MEMBER", 525]] | |
pull_requests,author_association | pull_requests | author_association | 560 | 0 | 0 | 5 | [["CONTRIBUTOR", 277], ["OWNER", 190], ["FIRST_TIME_CONTRIBUTOR", 63], ["NONE", 25], ["MEMBER", 5]] | |
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]] |
pull_requests,auto_merge | pull_requests | auto_merge | 560 | 560 | 0 | 0 | [[null, 560]] | |
users,avatar_url | users | avatar_url | 10621 | 0 | 0 | 10621 | ||
pull_requests,base | pull_requests | base | 560 | 0 | 0 | 422 | [["f09d611782a8372cfb002792dfa727325afb4db6", 7], ["1b697539f5b53cec3fe13c0f4ada13ba655c88c7", 6], ["0b4a28691468b5c758df74fa1d72a823813c96bf", 5], ["b7257a21bf3dfa7353980f343c83a616da44daa7", 4], ["a4bb2abce0764d49d255e5379f9e9c70981834ca", 4], ["8c401ee0f054de2f568c3a8302c9223555146407", 4], ["71e36e1cf034b96de2a8e6652265d782d3fdf63b", 4], ["5890a20c374fb0812d88c9b0ef26a838bfa06c76", 4], ["11b352b4d52fd02a422776edebb14f12e4994d3b", 4], ["0f7192b6154edb576c41b55bd3f2a3f53e5f436a", 4]] | [["f7289174e66ae4d91d57de94bbd9d09fabf7aff4", 1], ["f825e2012109247fa246e2b938f8174069e574f1", 1], ["f8277d0fb9c05a88a9ff01d996e31d55f0f0a645", 1], ["fa8eb0bf1b113ab17ede9cd107b7c3bd5cde39c3", 1], ["faea5093b865031f650da7da6539430f732f511a", 1], ["fb988ace7c7e2bee5ac142a0eab22431d0675a77", 1], ["fcf43589eb6a1f1d0432772a639fd35711c48e0c", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fe5b6ea95a973534fe8a44907c0ea2449aae7602", 1], ["fff89772b4404995400e33fe1d269050717ff4cf", 1]] |
licenses_fts_data,block | licenses_fts_data | block | 3 | 0 | 0 | 3 | ||
repos_fts_data,block | repos_fts_data | block | 25 | 0 | 0 | 25 | ||
users_fts_data,block | users_fts_data | block | 50 | 0 | 0 | 50 | ||
commits_fts_data,block | commits_fts_data | block | 45 | 0 | 0 | 45 | ||
milestones_fts_data,block | milestones_fts_data | block | 3 | 0 | 0 | 3 | ||
issues_fts_data,block | issues_fts_data | block | 420 | 0 | 0 | 420 | ||
releases_fts_data,block | releases_fts_data | block | 47 | 0 | 0 | 47 | ||
labels_fts_data,block | labels_fts_data | block | 3 | 0 | 0 | 3 | ||
issue_comments_fts_data,block | issue_comments_fts_data | block | 688 | 0 | 0 | 688 | ||
pull_requests_fts_data,block | pull_requests_fts_data | block | 126 | 0 | 0 | 126 | ||
issue_comments,body | issue_comments | body | 9947 | 0 | 0 | 9853 | [["Thanks!", 30], ["That fixed it.", 6], ["Tracking ticket: #1023", 5], ["Thanks for this!", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["@dependabot recreate", 4], ["Just needs documentation now.", 3], ["Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-al...", 3], ["Blocked on #37", 3]] | [["you should have a look at Roda written in ruby . ", 1], ["| addr | opcode | p1 | p2 | p3 | p4 | p5 | c...", 1], ["❤️ thanks!", 1], ["🎉 Thanks so much @simonw ! 🎉 ", 1], ["👋 could I help somehow for this to be merged? As Big Sur is going to be more us...", 1], ["👋 Any update on getting this merged?\r\n\r\nAlternatively, is there a work around fo...", 1], ["👋 I'd be interested in building this out in Q1 or Q2 of 2020 if nobody has tackl...", 1], ["👍 I'd like this too! ", 1], ["🤯 this is beautiful. Thanks @simonw !", 1], ["🤷♂️ @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 1]] |
issue_comments_fts,body | issue_comments_fts | body | 9947 | 0 | 0 | 9853 | [["Thanks!", 30], ["That fixed it.", 6], ["Tracking ticket: #1023", 5], ["Thanks for this!", 5], ["Needs documentation.", 5], ["Thanks for spotting this!", 4], ["@dependabot recreate", 4], ["Just needs documentation now.", 3], ["Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-al...", 3], ["Blocked on #37", 3]] | [["you should have a look at Roda written in ruby . ", 1], ["| addr | opcode | p1 | p2 | p3 | p4 | p5 | c...", 1], ["❤️ thanks!", 1], ["🎉 Thanks so much @simonw ! 🎉 ", 1], ["👋 could I help somehow for this to be merged? As Big Sur is going to be more us...", 1], ["👋 Any update on getting this merged?\r\n\r\nAlternatively, is there a work around fo...", 1], ["👋 I'd be interested in building this out in Q1 or Q2 of 2020 if nobody has tackl...", 1], ["👍 I'd like this too! ", 1], ["🤯 this is beautiful. Thanks @simonw !", 1], ["🤷♂️ @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 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]] | |
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]] |
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,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]] |
milestones,closed_issues | milestones | closed_issues | 34 | 0 | 0 | 24 | [[11, 3], [8, 3], [7, 3], [21, 2], [15, 2], [4, 2], [3, 2], [2, 1], [1, 1], [0, 1]] | [[16, 1], [19, 1], [22, 1], [23, 1], [24, 1], [25, 1], [39, 1], [49, 1], [53, 1], [58, 1]] |
labels,color | labels | color | 103 | 0 | 0 | 71 | [["a2eeef", 13], ["d73a4a", 11], ["0075ca", 8], ["ffffff", 2], ["e4e669", 2], ["008672", 2], ["0EE038", 1], ["083993", 1], ["0366d6", 1], ["006b75", 1]] | [["e6e6e6", 1], ["e8be84", 1], ["ecc7fc", 1], ["ee0701", 1], ["f759cf", 1], ["fc79af", 1], ["fc8b0a", 1], ["fcbabb", 1], ["fcd0c4", 1], ["fcecc4", 1]] |
_analyze_tables_,column | _analyze_tables_ | column | 350 | 0 | 0 | 153 | [["id", 33], ["name", 17], ["repo", 11], ["term", 10], ["sz", 10], ["segid", 10], ["pgno", 10], ["node_id", 10], ["k", 10], ["block", 10]] | [["uploader", 1], ["use_squash_pr_title_as_default", 1], ["user_id", 1], ["uses", 1], ["visibility", 1], ["watchers", 1], ["watchers_count", 1], ["web_commit_signoff_required", 1], ["with", 1], ["workflow", 1]] |
issues,comments | issues | comments | 2892 | 0 | 0 | 44 | [[1, 721], [0, 546], [2, 456], [3, 328], [4, 205], [5, 122], [6, 99], [7, 74], [8, 53], [9, 51]] | [[31, 1], [33, 1], [34, 1], [36, 1], [40, 1], [42, 1], [47, 1], [49, 1], [51, 1], [54, 1]] |
commits,committer | commits | committer | 3784 | 8 | 0 | 4 | [[9599, 2926], [19864447, 839], ["None", 8], [21148, 6], [45057, 5]] | |
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]] |
assets,content_type | assets | content_type | 1 | 0 | 0 | 1 | [["application/zip", 1]] | |
contributors,contributions | contributors | contributions | 131 | 0 | 0 | 23 | [[1, 92], [2, 11], [3, 5], [5, 3], [6, 2], [13, 1], [11, 1], [10, 1], [9, 1], [4, 1]] | [[21, 1], [30, 1], [34, 1], [40, 1], [49, 1], [61, 1], [128, 1], [165, 1], [828, 1], [2011, 1]] |
repos,created_at | repos | created_at | 1329 | 0 | 0 | 1329 | ||
milestones,created_at | milestones | created_at | 34 | 0 | 0 | 34 | ||
issues,created_at | issues | created_at | 2892 | 0 | 0 | 2892 | ||
releases,created_at | releases | created_at | 344 | 0 | 0 | 344 | ||
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]] |
pull_requests,created_at | pull_requests | created_at | 560 | 0 | 0 | 560 | ||
assets,created_at | assets | created_at | 1 | 0 | 0 | 1 | [["2021-01-04T21:26:30Z", 1]] | |
milestones,creator | milestones | creator | 34 | 0 | 0 | 1 | [[9599, 34]] | |
labels,default | labels | default | 103 | 0 | 0 | 2 | [[0, 54], [1, 49]] | |
repos,default_branch | repos | default_branch | 1329 | 0 | 0 | 10 | [["main", 811], ["master", 502], ["develop", 8], ["dev", 2], ["trunk", 1], ["test", 1], ["new_sql", 1], ["latest", 1], ["hjmain", 1], ["Main", 1]] | |
repos,delete_branch_on_merge | repos | delete_branch_on_merge | 1329 | 1120 | 0 | 2 | [["None", 1120], [0, 208], [1, 1]] | |
dependents,dependent | dependents | dependent | 1658 | 0 | 0 | 1328 | [[138329050, 2], [112050382, 2], [107914493, 2], [99911706, 2], [79072630, 2], [51720846, 2], [51665750, 2], [24275324, 2], [18156953, 2], [5832996, 2]] | [[663556926, 1], [663586533, 1], [664178911, 1], [664727381, 1], [664733539, 1], [664753575, 1], [664756551, 1], [664757179, 1], [665383572, 1], [665620099, 1]] |
repos,description | repos | description | 1329 | 431 | 0 | 771 | [["None", 431], ["Data Quality Engine for BigQuery", 31], ["A site that displays up to date COVID-19 stats, powered by fastpages.", 18], ["Improved Order Management System for stock trading", 10], ["An open source multi-tool for exploring and publishing data", 9], ["Today I Learned", 8], ["CloudGoat is Rhino Security Labs' \"Vulnerable by Design\" AWS deployment tool", 7], ["Save data from Pinboard to a SQLite database.", 6], ["Tool to index and serve HTML files. Powered by Datasette.", 5], ["A tool for exploring and publishing data", 5]] | [["自托管 Webfont 字体生成接口", 1], ["論文をChatGPTに要約させて毎日Slackに配信させるツール", 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_fts,description | repos_fts | description | 1329 | 431 | 0 | 771 | [["None", 431], ["Data Quality Engine for BigQuery", 31], ["A site that displays up to date COVID-19 stats, powered by fastpages.", 18], ["Improved Order Management System for stock trading", 10], ["An open source multi-tool for exploring and publishing data", 9], ["Today I Learned", 8], ["CloudGoat is Rhino Security Labs' \"Vulnerable by Design\" AWS deployment tool", 7], ["Save data from Pinboard to a SQLite database.", 6], ["Tool to index and serve HTML files. Powered by Datasette.", 5], ["A tool for exploring and publishing data", 5]] | [["自托管 Webfont 字体生成接口", 1], ["論文をChatGPTに要約させて毎日Slackに配信させるツール", 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,disabled | repos | disabled | 1329 | 0 | 0 | 1 | [[0, 1329]] | |
assets,download_count | assets | download_count | 1 | 0 | 0 | 1 | [[49, 1]] | |
issues,draft | issues | draft | 2892 | 2332 | 0 | 2 | [["None", 2332], [0, 550], [1, 10]] | |
releases,draft | releases | draft | 344 | 0 | 0 | 1 | [[0, 344]] | |
pull_requests,draft | pull_requests | draft | 560 | 0 | 0 | 2 | [[0, 550], [1, 10]] | |
milestones,due_on | milestones | due_on | 34 | 31 | 0 | 3 | [["None", 31], ["2019-07-07T07:00:00Z", 1], ["2019-05-19T07:00:00Z", 1], ["2017-11-13T08:00:00Z", 1]] | |
workflows,env | workflows | env | 41 | 40 | 0 | 1 | [["None", 41]] | |
steps,env | steps | env | 262 | 246 | 0 | 6 | [["None", 246], ["{\"TWINE_USERNAME\": \"__token__\", \"TWINE_PASSWORD\": \"${{ secrets.PYPI_TOKEN }}\"}", 11], ["{\"VERCEL_TOKEN\": \"${{ secrets.BRANCH_PREVIEW_VERCEL_TOKEN }}\"}", 1], ["{\"LATEST_DATASETTE_SECRET\": \"${{ secrets.LATEST_DATASETTE_SECRET }}\"}", 1], ["{\"GITHUB_ACCESS_TOKEN\": \"${{ secrets.GH_TOKEN }}\"}", 1], ["{\"DOCKER_USER\": \"${{ secrets.DOCKER_USER }}\", \"DOCKER_PASS\": \"${{ secrets.DOCKER...", 1], ["{\"DOCKER_USER\": \"${{ secrets.DOCKER_USER }}\", \"DOCKER_PASS\": \"${{ secrets.DOCKER...", 1]] | |
workflows,filename | workflows | filename | 41 | 0 | 0 | 17 | [["test.yml", 12], ["publish.yml", 11], ["test-coverage.yml", 2], ["spellcheck.yml", 2], ["documentation-links.yml", 2], ["mirror-master-and-main.yml", 1], ["deploy-latest.yml", 1], ["deploy-demo.yml", 1], ["deploy-branch-preview.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]] |
dependents,first_seen_utc | dependents | first_seen_utc | 1658 | 0 | 0 | 1658 | ||
repos,fork | repos | fork | 1329 | 0 | 0 | 2 | [[0, 1201], [1, 128]] | |
repos,forks | repos | forks | 1329 | 0 | 0 | 29 | [[0, 1136], [1, 99], [2, 29], [3, 14], [6, 8], [7, 6], [4, 6], [5, 5], [11, 2], [9, 2]] | [[23, 1], [30, 1], [38, 1], [42, 1], [55, 1], [87, 1], [199, 1], [309, 1], [331, 1], [555, 1]] |
repos,forks_count | repos | forks_count | 1329 | 0 | 0 | 29 | [[0, 1136], [1, 99], [2, 29], [3, 14], [6, 8], [7, 6], [4, 6], [5, 5], [11, 2], [9, 2]] | [[23, 1], [30, 1], [38, 1], [42, 1], [55, 1], [87, 1], [199, 1], [309, 1], [331, 1], [555, 1]] |
repos,full_name | repos | full_name | 1329 | 0 | 0 | 1329 | ||
repos,has_discussions | repos | has_discussions | 1329 | 884 | 0 | 2 | [["None", 884], [0, 441], [1, 4]] | |
repos,has_downloads | repos | has_downloads | 1329 | 0 | 0 | 2 | [[1, 1328], [0, 1]] | |
repos,has_issues | repos | has_issues | 1329 | 0 | 0 | 2 | [[1, 1185], [0, 144]] | |
repos,has_pages | repos | has_pages | 1329 | 0 | 0 | 2 | [[0, 1277], [1, 52]] | |
repos,has_projects | repos | has_projects | 1329 | 0 | 0 | 2 | [[1, 1281], [0, 48]] | |
repos,has_wiki | repos | has_wiki | 1329 | 0 | 0 | 2 | [[1, 1228], [0, 101]] | |
pull_requests,head | pull_requests | head | 560 | 0 | 0 | 560 | ||
users,html_url | users | html_url | 10621 | 0 | 0 | 10620 | [["https://github.com/fineheard", 2], ["https://github.com/0nyr", 1], ["https://github.com/0nebody", 1], ["https://github.com/0ndrec", 1], ["https://github.com/0ihsan", 1], ["https://github.com/0asa", 1], ["https://github.com/0987031613dow", 1], ["https://github.com/03b8", 1], ["https://github.com/00mjk", 1], ["https://github.com/0-vortex", 1]] | [["https://github.com/zxygithub", 1], ["https://github.com/zy528", 1], ["https://github.com/zyuanlim", 1], ["https://github.com/zz", 1], ["https://github.com/zz0x", 1], ["https://github.com/zz2115", 1], ["https://github.com/zzeleznick", 1], ["https://github.com/zzkt", 1], ["https://github.com/zzl0", 1], ["https://github.com/zzlgreat", 1]] |
repos,html_url | repos | html_url | 1329 | 0 | 0 | 1329 | ||
milestones,html_url | milestones | html_url | 34 | 0 | 0 | 34 | ||
releases,html_url | releases | html_url | 344 | 0 | 0 | 344 | ||
issue_comments,html_url | issue_comments | html_url | 9947 | 0 | 0 | 9947 | ||
users,id | users | id | 10621 | 0 | 0 | 10621 | ||
repos,id | repos | id | 1329 | 0 | 0 | 1329 | ||
licenses_fts_data,id | licenses_fts_data | id | 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_docsize,id | repos_fts_docsize | id | 1329 | 0 | 0 | 1329 | ||
users_fts_data,id | users_fts_data | id | 50 | 0 | 0 | 50 | ||
users_fts_docsize,id | users_fts_docsize | id | 10621 | 0 | 0 | 10621 | ||
raw_authors,id | raw_authors | id | 114 | 0 | 0 | 114 | ||
commits_fts_data,id | commits_fts_data | id | 45 | 0 | 0 | 45 | ||
commits_fts_docsize,id | commits_fts_docsize | id | 3784 | 0 | 0 | 3784 | ||
milestones,id | milestones | id | 34 | 0 | 0 | 34 | ||
milestones_fts_data,id | milestones_fts_data | id | 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_fts_data,id | issues_fts_data | id | 420 | 0 | 0 | 420 | ||
issues_fts_docsize,id | issues_fts_docsize | id | 2892 | 0 | 0 | 2892 |
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]) );