_analyze_tables_

Table actions

340 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link table column total_rows num_null num_blank num_distinct most_common least_common
issues_fts_docsize,id issues_fts_docsize id 2361 0 0 2361    
issues_fts_docsize,sz issues_fts_docsize sz 2361 0 0 1292 [["b'\\x07\\x00'", 18], ["b'\\x06\\x00'", 16], ["b'\\x05\\x00'", 14], ["b'\\x08\\x02'", 13], ["b'\\x07\\x02'", 13], ["b'\\x04\\x00'", 13], ["b'\\t\\x00'", 13], ["b'\\x05\\x02'", 11], ["b'\\x04\\x02'", 9], ["b'\\x03\\x00'", 8]] [["b'\\x137'", 1], ["b'\\x13\\x82\\x01'", 1], ["b'\\x14\\x00'", 1], ["b'\\x14\\x81M'", 1], ["b'\\x14\\x81e'", 1], ["b'\\x14\\x82\\x11'", 1], ["b'\\x14o'", 1], ["b'\\x14z'", 1], ["b'\\x15g'", 1], ["b'\\x16\\x06'", 1]]
issues_fts_idx,pgno issues_fts_idx pgno 384 0 0 93 [[20, 5], [18, 5], [16, 5], [14, 5], [12, 5], [10, 5], [8, 5], [6, 5], [4, 5], [2, 5]] [[186, 1], [178, 2], [180, 2], [182, 2], [184, 2], [168, 3], [170, 3], [172, 3], [174, 3], [176, 3]]
issues_fts_idx,segid issues_fts_idx segid 384 0 0 5 [[1, 93], [3, 92], [2, 88], [5, 62], [4, 49]]  
issues_fts_idx,term issues_fts_idx term 384 0 0 343 [["b''", 5], ["b'0a0'", 4], ["b'080'", 4], ["b'0worko'", 3], ["b'0simonwi'", 3], ["b'0andr'", 3], ["b'020'", 3], ["b'0asc'", 2], ["b'0ana'", 2], ["b'010'", 2]] [["b'0valuee'", 1], ["b'0versionc'", 1], ["b'0virtualf'", 1], ["b'0wante'", 1], ["b'0warnings'", 1], ["b'0weirdl'", 1], ["b'0wh'", 1], ["b'0wi'", 1], ["b'0wk'", 1], ["b'0yh'", 1]]
issues_labels,issues_id issues_labels issues_id 2641 0 0 1661 [[775666296, 7], [647103735, 6], [323658641, 6], [1122557010, 5], [726094754, 5], [725184645, 5], [652961907, 5], [582526961, 5], [573755726, 5], [317714268, 4]] [[1211283427, 1], [1212838949, 1], [1213683988, 1], [1214859703, 1], [1215216249, 1], [1216436131, 1], [1216508080, 1], [1216619276, 1], [1218133366, 1], [1219398983, 1]]
issues_labels,labels_id issues_labels labels_id 2641 0 0 94 [[729585263, 230], [727708732, 209], [993377884, 166], [750789605, 162], [754269786, 157], [727708734, 143], [947261894, 134], [1845722916, 79], [2374328705, 73], [1379448359, 68]] [[1996280384, 1], [2051881526, 1], [2245226086, 1], [2389750367, 1], [2418058309, 1], [2459412274, 1], [3609901844, 1], [3668762178, 1], [3750508178, 1], [3867322234, 1]]
jobs,id jobs id 44 0 0 44    
jobs,if jobs if 44 42 0 1 [["None", 44]]  
jobs,name jobs name 44 0 0 10 [["test", 20], ["deploy", 10], ["build", 5], ["spellcheck", 2], ["deploy_docker", 2], ["scheduled", 1], ["prettier", 1], ["mirror", 1], ["deploy_static_docs", 1], ["Analyze", 1]]  
jobs,needs jobs needs 44 33 0 2 [["None", 33], ["[\"test\"]", 9], ["[\"deploy\"]", 2]]  
jobs,repo jobs repo 44 0 0 10 [[107914493, 13], [140912432, 6], [207052882, 5], [206156866, 4], [303218369, 3], [248903544, 3], [205429375, 3], [197882382, 3], [197431109, 3], [256834907, 1]]  
jobs,runs-on jobs runs-on 44 0 0 3 [["ubuntu-latest", 40], ["macos-latest", 2], ["${{ matrix.os }}", 2]]  
jobs,strategy jobs strategy 44 24 0 7 [["None", 24], ["{\"matrix\": {\"python-version\": [3.6, 3.7, 3.8, 3.9]}}", 14], ["{\"matrix\": {\"python-version\": [3.7, 3.8]}}", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\"]}}", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11-dev\"]}}", 1], ["{\"matrix\": {\"python-version\": [\"3.6\", \"3.7\", \"3.8\", \"3.9\", \"3.10\"], \"os\": [\"ubun...", 1], ["{\"matrix\": {\"python-version\": [\"3.6\", \"3.7\", \"3.8\", \"3.9\", \"3.10\"], \"numpy\": [0,...", 1], ["{\"fail-fast\": false, \"matrix\": {\"language\": [\"python\"]}}", 1]]  
jobs,workflow jobs workflow 44 0 0 33 [[14475, 4], [14483, 2], [14469, 2], [14467, 2], [14465, 2], [14463, 2], [14460, 2], [14457, 2], [14454, 2], [14455, 1]] [[14476, 1], [14477, 1], [14478, 1], [14479, 1], [14480, 1], [14481, 1], [14482, 1], [14484, 1], [14485, 1], [14486, 1]]
labels,color labels color 94 0 0 66 [["a2eeef", 12], ["d73a4a", 9], ["0075ca", 7], ["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]]
labels,default labels default 94 0 0 2 [[0, 49], [1, 45]]  
labels,description labels description 94 14 41 13 [["", 41], ["None", 14], ["New feature or request", 12], ["Something isn't working", 9], ["Improvements or additions to documentation", 7], ["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", 7]]
labels,id labels id 94 0 0 94    
labels,name labels name 94 0 0 51 [["enhancement", 13], ["bug", 10], ["documentation", 9], ["research", 4], ["invalid", 3], ["help wanted", 3], ["ci", 3], ["question", 2], ["duplicate", 2], ["design", 2]] [["python-library", 1], ["refactor", 1], ["search", 1], ["security", 1], ["small", 1], ["support", 1], ["tests", 1], ["tracking-issue", 1], ["usability", 1], ["windows", 1]]
labels,node_id labels node_id 94 0 0 94    
labels,url labels url 94 0 0 94    
labels_fts,description labels_fts description 94 14 41 13 [["", 41], ["None", 14], ["New feature or request", 12], ["Something isn't working", 9], ["Improvements or additions to documentation", 7], ["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", 7]]
labels_fts,name labels_fts name 94 0 0 51 [["enhancement", 13], ["bug", 10], ["documentation", 9], ["research", 4], ["invalid", 3], ["help wanted", 3], ["ci", 3], ["question", 2], ["duplicate", 2], ["design", 2]] [["python-library", 1], ["refactor", 1], ["search", 1], ["security", 1], ["small", 1], ["support", 1], ["tests", 1], ["tracking-issue", 1], ["usability", 1], ["windows", 1]]
labels_fts_config,k labels_fts_config k 1 0 0 1 [["version", 1]]  
labels_fts_config,v labels_fts_config v 1 0 0 1 [[4, 1]]  
labels_fts_data,block labels_fts_data block 3 0 0 3    
labels_fts_data,id labels_fts_data id 3 0 0 3    
labels_fts_docsize,id labels_fts_docsize id 94 0 0 94    
labels_fts_docsize,sz labels_fts_docsize sz 94 0 0 9 [["b'\\x01\\x00'", 42], ["b'\\x01\\x04'", 22], ["b'\\x02\\x00'", 11], ["b'\\x01\\x05'", 10], ["b'\\x03\\x00'", 2], ["b'\\x02\\x04'", 2], ["b'\\x01\\x07'", 2], ["b'\\x01\\x06'", 2], ["b'\\x01\\r'", 1]]  
labels_fts_idx,pgno labels_fts_idx pgno 1 0 0 1 [[2, 1]]  
labels_fts_idx,segid labels_fts_idx segid 1 0 0 1 [[1, 1]]  
labels_fts_idx,term labels_fts_idx term 1 0 0 1 [["b''", 1]]  
labels_pull_requests,labels_id labels_pull_requests labels_id 104 0 0 18 [[1970143153, 62], [993377884, 7], [754269786, 5], [727708734, 5], [2374328705, 4], [993222446, 4], [1379448359, 2], [947261894, 2], [750789605, 2], [727708735, 2]] [[947465681, 1], [1918831023, 1], [2157112227, 1], [2175284252, 1], [2374328637, 1], [2459412274, 1], [3799780031, 1], [947261894, 2], [1379448359, 2], [1405404904, 2]]
labels_pull_requests,pull_requests_id labels_pull_requests pull_requests_id 104 0 0 95 [[853484980, 2], [817257851, 2], [804924636, 2], [700944644, 2], [513106026, 2], [511005542, 2], [481616704, 2], [431478724, 2], [296735320, 2], [204851511, 1]] [[836124846, 1], [838724548, 1], [838755826, 1], [840249513, 1], [841715204, 1], [879038656, 1], [889476515, 1], [893039755, 1], [893040042, 1], [903832393, 1]]
licenses,key licenses key 14 0 0 14    
licenses,name licenses name 14 0 0 14    
licenses,node_id licenses node_id 14 0 0 14    
licenses,spdx_id licenses spdx_id 14 0 0 14    
licenses,url licenses url 14 1 0 13 [["https://api.github.com/licenses/gpl-3.0", 1], ["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", 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/bsd-3-clause", 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/unlicense", 1], ["https://api.github.com/licenses/wtfpl", 1]]
licenses_fts,name licenses_fts name 14 0 0 14    
licenses_fts_config,k licenses_fts_config k 1 0 0 1 [["version", 1]]  
licenses_fts_config,v licenses_fts_config v 1 0 0 1 [[4, 1]]  
licenses_fts_data,block licenses_fts_data block 3 0 0 3    
licenses_fts_data,id licenses_fts_data id 3 0 0 3    
licenses_fts_docsize,id licenses_fts_docsize id 14 0 0 14    
licenses_fts_docsize,sz licenses_fts_docsize sz 14 0 0 7 [["b'\\x06'", 5], ["b'\\x07'", 3], ["b'\\x02'", 2], ["b'\\x05'", 1], ["b'\\x04'", 1], ["b'\\x01'", 1], ["b'\\n'", 1]]  
licenses_fts_idx,pgno licenses_fts_idx pgno 1 0 0 1 [[2, 1]]  
licenses_fts_idx,segid licenses_fts_idx segid 1 0 0 1 [[1, 1]]  
licenses_fts_idx,term licenses_fts_idx term 1 0 0 1 [["b''", 1]]  
milestones,closed_at milestones closed_at 28 4 0 24 [["None", 4], ["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-09-14T22:19:57Z", 1], ["2020-09-22T01:35:48Z", 1], ["2020-10-09T17:53:13Z", 1], ["2020-10-31T22:35:05Z", 1], ["2020-11-06T23:52:09Z", 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]]
milestones,closed_issues milestones closed_issues 28 0 0 19 [[11, 3], [7, 3], [3, 3], [21, 2], [8, 2], [4, 2], [15, 1], [13, 1], [5, 1], [2, 1]] [[15, 1], [16, 1], [19, 1], [22, 1], [24, 1], [25, 1], [39, 1], [49, 1], [53, 1], [57, 1]]
milestones,created_at milestones created_at 28 0 0 28    
milestones,creator milestones creator 28 0 0 1 [[9599, 28]]  
milestones,description milestones description 28 0 17 12 [["", 17], ["Writeable canned queries, authentication and permissions. [Changelog](https://da...", 1], ["The first Datasette 1.0 alpha release.", 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]] [["A new visual design, plugin hooks for adding navigation options, better handling...", 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], ["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,due_on milestones due_on 28 25 0 3 [["None", 25], ["2019-07-07T07:00:00Z", 1], ["2019-05-19T07:00:00Z", 1], ["2017-11-13T08:00:00Z", 1]]  
milestones,html_url milestones html_url 28 0 0 28    
milestones,id milestones id 28 0 0 28    
milestones,node_id milestones node_id 28 0 0 28    
milestones,number milestones number 28 0 0 23 [[1, 4], [5, 2], [3, 2], [11, 1], [10, 1], [8, 1], [7, 1], [6, 1], [4, 1], [2, 1]] [[15, 1], [16, 1], [17, 1], [18, 1], [19, 1], [20, 1], [21, 1], [22, 1], [23, 1], [24, 1]]
milestones,open_issues milestones open_issues 28 0 0 5 [[0, 24], [41, 1], [9, 1], [6, 1], [2, 1]]  
milestones,repo milestones repo 28 0 0 4 [[107914493, 21], [140912432, 5], [256834907, 1], [207052882, 1]]  
milestones,state milestones state 28 0 0 2 [["closed", 24], ["open", 4]]  
milestones,title milestones title 28 0 0 27 [["1.0", 2], ["Custom templates edition", 1], ["Apple Photos online and securely browsable", 1], ["3.21", 1], ["3.0", 1], ["2.20", 1], ["2.19", 1], ["0.51", 1], ["0.28", 1], ["0.23.1", 1]] [["Datasette 0.50", 1], ["Datasette 0.52", 1], ["Datasette 0.54", 1], ["Datasette 0.60", 1], ["Datasette 1.0", 1], ["Datasette 1.0a0", 1], ["Datasette Next", 1], ["Foreign key edition", 1], ["Ship first public release", 1], ["v1 stretch goals", 1]]
milestones,updated_at milestones updated_at 28 0 0 28    
milestones_fts,description milestones_fts description 28 0 17 12 [["", 17], ["Writeable canned queries, authentication and permissions. [Changelog](https://da...", 1], ["The first Datasette 1.0 alpha release.", 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]] [["A new visual design, plugin hooks for adding navigation options, better handling...", 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], ["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,title milestones_fts title 28 0 0 27 [["1.0", 2], ["Custom templates edition", 1], ["Apple Photos online and securely browsable", 1], ["3.21", 1], ["3.0", 1], ["2.20", 1], ["2.19", 1], ["0.51", 1], ["0.28", 1], ["0.23.1", 1]] [["Datasette 0.50", 1], ["Datasette 0.52", 1], ["Datasette 0.54", 1], ["Datasette 0.60", 1], ["Datasette 1.0", 1], ["Datasette 1.0a0", 1], ["Datasette Next", 1], ["Foreign key edition", 1], ["Ship first public release", 1], ["v1 stretch goals", 1]]
milestones_fts_config,k milestones_fts_config k 1 0 0 1 [["version", 1]]  
milestones_fts_config,v milestones_fts_config v 1 0 0 1 [[4, 1]]  
milestones_fts_data,block milestones_fts_data block 3 0 0 3    
milestones_fts_data,id milestones_fts_data id 3 0 0 3    
milestones_fts_docsize,id milestones_fts_docsize id 28 0 0 28    
milestones_fts_docsize,sz milestones_fts_docsize sz 28 0 0 14 [["b'\\x03\\x00'", 10], ["b'\\x02\\x00'", 6], ["b'\\x03\\x11'", 1], ["b'\\x03\\x0e'", 1], ["b'\\x03\\x0c'", 1], ["b'\\x03\\x07'", 1], ["b'\\x03\\n'", 1], ["b'\\x02\\x1c'", 1], ["b'\\x02\\x12'", 1], ["b'\\x02\\t'", 1]] [["b'\\x02\\x1c'", 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'\\x06\\x00'", 1]]
milestones_fts_idx,pgno milestones_fts_idx pgno 1 0 0 1 [[2, 1]]  
milestones_fts_idx,segid milestones_fts_idx segid 1 0 0 1 [[1, 1]]  
milestones_fts_idx,term milestones_fts_idx term 1 0 0 1 [["b''", 1]]  
pull_requests,assignee pull_requests assignee 433 431 0 1 [["None", 433]]  
pull_requests,author_association pull_requests author_association 433 0 0 5 [["CONTRIBUTOR", 208], ["OWNER", 162], ["FIRST_TIME_CONTRIBUTOR", 38], ["NONE", 20], ["MEMBER", 5]]  
pull_requests,auto_merge pull_requests auto_merge 433 433 0 0 [["None", 433]]  
pull_requests,base pull_requests base 433 0 0 338 [["1b697539f5b53cec3fe13c0f4ada13ba655c88c7", 6], ["fffd69ec031b83f46680f192ba57a27f0d1f0b8a", 4], ["ed3752022e45b890af63996efec804725e95d0d4", 4], ["b7257a21bf3dfa7353980f343c83a616da44daa7", 4], ["a4bb2abce0764d49d255e5379f9e9c70981834ca", 4], ["8c401ee0f054de2f568c3a8302c9223555146407", 4], ["71e36e1cf034b96de2a8e6652265d782d3fdf63b", 4], ["11b352b4d52fd02a422776edebb14f12e4994d3b", 4], ["0d5cc20aeffa3537cfc9296d01ec24b9c6e23dcf", 3], ["0156c6b5e52d541e93f0d68e9245f20ae83bc933", 3]] [["f7289174e66ae4d91d57de94bbd9d09fabf7aff4", 1], ["f825e2012109247fa246e2b938f8174069e574f1", 1], ["f8277d0fb9c05a88a9ff01d996e31d55f0f0a645", 1], ["fa8eb0bf1b113ab17ede9cd107b7c3bd5cde39c3", 1], ["faea5093b865031f650da7da6539430f732f511a", 1], ["fb988ace7c7e2bee5ac142a0eab22431d0675a77", 1], ["fcf43589eb6a1f1d0432772a639fd35711c48e0c", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fe5b6ea95a973534fe8a44907c0ea2449aae7602", 1], ["fff89772b4404995400e33fe1d269050717ff4cf", 1]]
pull_requests,body pull_requests body 433 6 54 373 [["", 54], ["None", 6], ["Refs #744", 2], ["**NOTE: I don't think this PR is ready, since the arm/v6 and arm/v7 images are f...", 1], ["* Split out view classes from main `app.py`\r\n* Run [black](https://github.com/am...", 1], ["(I discovered this trawling the issues for how to use --since with favorites)", 1], ["### Description\r\nHi :wave: I work at [DeepSource](https://deepsource.io), I ran ...", 1], ["## Description\r\n\r\nProposing a solution to the API limitation for `merged_by` in ...", 1], ["\r\n\r\nRefs #90 ", 1], ["\r\n\r\nDeletes all rows in the table (if it exists) before inserting new rows.\r\nSQL...", 1]] [["https://travis-ci.org/simonw/datasette/jobs/305929426\r\n\r\n pkg_resources.Versi...", 1], ["ref #46 \r\n\r\nIssues don't have merge information on them, which means that PRs ne...", 1], ["setup-gcloud will be updating the branch name from master to main in\r\na future r...", 1], ["the `--connection` parameter has become positional", 1], ["the library deal with Postgres type jsonb as dictionary, add dict type as a TEXT...", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["tiny tweak to make this easier to visually parse—I think it matches your style i...", 1], ["to keep the data write from failing if it came across an error during processing...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1]]
pull_requests,closed_at pull_requests closed_at 433 54 0 379 [["None", 54], ["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]] [["2022-03-07T15:38:30Z", 1], ["2022-03-15T18:01:57Z", 1], ["2022-03-15T18:03:02Z", 1], ["2022-03-19T00:12:04Z", 1], ["2022-03-23T17:55:39Z", 1], ["2022-03-24T04:07:58Z", 1], ["2022-03-24T21:01:44Z", 1], ["2022-04-08T22:51:05Z", 1], ["2022-04-08T23:05:09Z", 1], ["2022-04-24T14:03:08Z", 1]]
pull_requests,created_at pull_requests created_at 433 0 0 433    
pull_requests,draft pull_requests draft 433 0 0 2 [[0, 425], [1, 8]]  
pull_requests,head pull_requests head 433 0 0 433    
pull_requests,id pull_requests id 433 0 0 433    
pull_requests,locked pull_requests locked 433 0 0 1 [[0, 433]]  
pull_requests,merge_commit_sha pull_requests merge_commit_sha 433 0 0 433    
pull_requests,merged_at pull_requests merged_at 433 117 0 316 [["None", 117], ["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]] [["2022-03-06T01:58:32Z", 1], ["2022-03-06T19:39:15Z", 1], ["2022-03-07T15:38:29Z", 1], ["2022-03-15T18:01:57Z", 1], ["2022-03-15T18:03:01Z", 1], ["2022-03-19T00:12:03Z", 1], ["2022-03-24T21:01:44Z", 1], ["2022-04-08T22:51:05Z", 1], ["2022-04-08T23:05:09Z", 1], ["2022-04-24T14:03:08Z", 1]]
pull_requests,merged_by pull_requests merged_by 433 433 0 0 [["None", 433]]  
pull_requests,milestone pull_requests milestone 433 405 0 12 [["None", 405], [6026070, 6], [6346396, 3], [5512395, 3], [5471110, 3], [3268330, 3], [7558727, 2], [5971510, 2], [4471010, 2], [5234079, 1]] [[5234079, 1], [5533512, 1], [5897911, 1], [6055094, 1], [4471010, 2], [5971510, 2], [7558727, 2], [5471110, 3], [5512395, 3], [6346396, 3]]
pull_requests,node_id pull_requests node_id 433 0 0 433    
pull_requests,number pull_requests number 433 0 0 402 [[8, 4], [65, 3], [15, 3], [5, 3], [10, 2], [9, 2], [7, 2], [6, 2], [4, 2], [1, 2]] [[1649, 1], [1656, 1], [1659, 1], [1664, 1], [1665, 1], [1685, 1], [1693, 1], [1694, 1], [1703, 1], [1717, 1]]
pull_requests,repo pull_requests repo 433 0 0 12 [[107914493, 316], [140912432, 74], [207052882, 9], [206156866, 7], [214746582, 6], [197882382, 6], [303218369, 4], [256834907, 4], [206649770, 3], [205429375, 2]] [[197431109, 1], [213286752, 1], [205429375, 2], [206649770, 3], [256834907, 4], [303218369, 4], [197882382, 6], [214746582, 6], [206156866, 7], [207052882, 9]]
pull_requests,state pull_requests state 433 0 0 2 [["closed", 379], ["open", 54]]  
pull_requests,title pull_requests title 433 0 0 432 [["Update deploying.rst", 2], ["--plugin-secret option", 1], ["--metadata accepts YAML as well as JSON", 1], ["--lines and --text and --convert and --import", 1], ["--dirs option for scanning directories for SQLite databases", 1], ["--crossdb option for joining across databases", 1], ["'datasette --get' option, refs #926", 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]] [["sqlite-utils index-foreign-keys / db.index_foreign_keys()", 1], ["sqlite-utils memory command for directly querying CSV/JSON data", 1], ["stargazers command, refs #4", 1], ["table.search() improvements plus sqlite-utils search command", 1], ["table.transform() method", 1], ["table.update() method", 1], ["test_insert_upsert_all_empty_list", 1], ["tiny typo in customization docs", 1], ["twitter-to-sqlite import command, refs #4", 1], ["use jsonify_if_need for sql updates", 1]]
pull_requests,updated_at pull_requests updated_at 433 0 0 431 [["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]] [["2022-03-24T04:07:58Z", 1], ["2022-03-24T21:01:44Z", 1], ["2022-04-08T22:51:05Z", 1], ["2022-04-08T23:05:10Z", 1], ["2022-04-15T17:24:43Z", 1], ["2022-04-21T16:51:24Z", 1], ["2022-04-22T13:16:36Z", 1], ["2022-04-24T14:03:08Z", 1], ["2022-04-24T15:51:44Z", 1], ["2022-04-24T15:58:09Z", 1]]
pull_requests,url pull_requests url 433 0 0 433    
pull_requests,user pull_requests user 433 0 0 138 [[9599, 167], [49699333, 41], [27856297, 21], [45057, 19], [3243482, 7], [2657547, 6], [198537, 4], [49260, 4], [25778, 4], [50527, 3]] [[32605365, 1], [36061055, 1], [36654812, 1], [37962604, 1], [39452697, 1], [56323389, 1], [72577720, 1], [82332573, 1], [87192257, 1], [91880982, 1]]
pull_requests_fts,body pull_requests_fts body 433 6 54 373 [["", 54], ["None", 6], ["Refs #744", 2], ["**NOTE: I don't think this PR is ready, since the arm/v6 and arm/v7 images are f...", 1], ["* Split out view classes from main `app.py`\r\n* Run [black](https://github.com/am...", 1], ["(I discovered this trawling the issues for how to use --since with favorites)", 1], ["### Description\r\nHi :wave: I work at [DeepSource](https://deepsource.io), I ran ...", 1], ["## Description\r\n\r\nProposing a solution to the API limitation for `merged_by` in ...", 1], ["\r\n\r\nRefs #90 ", 1], ["\r\n\r\nDeletes all rows in the table (if it exists) before inserting new rows.\r\nSQL...", 1]] [["https://travis-ci.org/simonw/datasette/jobs/305929426\r\n\r\n pkg_resources.Versi...", 1], ["ref #46 \r\n\r\nIssues don't have merge information on them, which means that PRs ne...", 1], ["setup-gcloud will be updating the branch name from master to main in\r\na future r...", 1], ["the `--connection` parameter has become positional", 1], ["the library deal with Postgres type jsonb as dictionary, add dict type as a TEXT...", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["tiny tweak to make this easier to visually parse—I think it matches your style i...", 1], ["to keep the data write from failing if it came across an error during processing...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1]]

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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])
);