_analyze_tables_

Table actions

350 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 3044 0 0 3044    
issues_fts_docsize,sz issues_fts_docsize sz 3044 0 0 1585 [["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]]
issues_fts_idx,pgno issues_fts_idx pgno 452 0 0 155 [[4, 4], [2, 4], [20, 3], [18, 3], [16, 3], [14, 3], [12, 3], [10, 3], [8, 3], [6, 3]] [[278, 1], [308, 1], [310, 1], [40, 2], [152, 2], [154, 2], [268, 2], [270, 2], [274, 2], [306, 2]]
issues_fts_idx,segid issues_fts_idx segid 452 0 0 4 [[1, 152], [3, 149], [2, 149], [4, 2]]  
issues_fts_idx,term issues_fts_idx term 452 0 0 406 [["b''", 4], ["b'0tho'", 3], ["b'0ready'", 3], ["b'0nota'", 3], ["b'0inserte'", 3], ["b'0forb'", 3], ["b'0databased'", 3], ["b'0comb'", 3], ["b'0a0'", 3], ["b'010'", 3]] [["b'0whol'", 1], ["b'0withe'", 1], ["b'0worka'", 1], ["b'0worko'", 1], ["b'0worl'", 1], ["b'0www2'", 1], ["b'0wy'", 1], ["b'0yas'", 1], ["b'0your'", 1], ["b'0yours'", 1]]
issues_labels,issues_id issues_labels issues_id 3359 0 0 2137 [[775666296, 7], [647103735, 6], [323658641, 6], [1122557010, 5], [726094754, 5], [725184645, 5], [652961907, 5], [582526961, 5], [573755726, 5], [317714268, 4]] [[1903932086, 1], [1926729132, 1], [1940346034, 1], [1949756141, 1], [1959278971, 1], [1976986318, 1], [1978022687, 1], [1978023780, 1], [1983600865, 1], [1988525411, 1]]
issues_labels,labels_id issues_labels labels_id 3359 0 0 106 [[727708732, 274], [729585263, 233], [993377884, 224], [750789605, 202], [727708734, 195], [754269786, 191], [947261894, 138], [1970143153, 113], [1379448359, 101], [2374328705, 95]] [[2418058309, 1], [2459412274, 1], [3609901844, 1], [3750508178, 1], [3867322234, 1], [4795091971, 1], [5243620954, 1], [5243620957, 1], [5857663447, 1], [5974977752, 1]]
jobs,id jobs id 54 0 0 54    
jobs,if jobs if 54 52 0 1 [["None", 54]]  
jobs,name jobs name 54 0 0 12 [["test", 25], ["deploy", 12], ["build", 5], ["spellcheck", 2], ["documentation-links", 2], ["deploy_docker", 2], ["mirror", 1], ["deploy_static_docs", 1], ["deploy-branch-preview", 1], ["Analyze", 1]] [["Analyze", 1], ["deploy-branch-preview", 1], ["deploy_static_docs", 1], ["mirror", 1], ["prettier", 1], ["scheduled", 1], ["deploy_docker", 2], ["documentation-links", 2], ["spellcheck", 2], ["build", 5]]
jobs,needs jobs needs 54 41 0 2 [["None", 41], ["[\"test\"]", 11], ["[\"deploy\"]", 2]]  
jobs,repo jobs repo 54 0 0 12 [[107914493, 16], [140912432, 7], [207052882, 5], [206156866, 4], [303218369, 3], [248903544, 3], [213286752, 3], [205429375, 3], [197882382, 3], [197431109, 3]] [[256834907, 1], [197431109, 3], [197882382, 3], [205429375, 3], [213286752, 3], [248903544, 3], [303218369, 3], [611552758, 3], [206156866, 4], [207052882, 5]]
jobs,runs-on jobs runs-on 54 0 0 3 [["ubuntu-latest", 50], ["macos-latest", 2], ["${{ matrix.os }}", 2]]  
jobs,strategy jobs strategy 54 30 0 8 [["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\"]}}", 3], ["{\"matrix\": {\"python-version\": [3.7, 3.8]}}", 1], ["{\"matrix\": {\"python-version\": [\"3.8\", \"3.9\", \"3.10\", \"3.11\", \"3.12\"]}}", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\", \"3.12\"], \"os...", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\", \"3.12\"], \"nu...", 1], ["{\"fail-fast\": false, \"matrix\": {\"language\": [\"python\"]}}", 1]]  
jobs,workflow jobs workflow 54 0 0 41 [[20982, 4], [20975, 2], [20973, 2], [20971, 2], [20969, 2], [20967, 2], [20964, 2], [20961, 2], [20958, 2], [20956, 2]] [[20985, 1], [20986, 1], [20987, 1], [20988, 1], [20989, 1], [20990, 1], [20991, 1], [20993, 1], [20994, 1], [20995, 1]]
labels,color labels color 106 0 0 74 [["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]]
labels,default labels default 106 0 0 2 [[0, 57], [1, 49]]  
labels,description labels description 106 14 49 13 [["", 49], ["None", 14], ["New feature or request", 13], ["Something isn't working", 11], ["Improvements or additions to documentation", 8], ["This doesn't seem right", 2], ["Extra attention is needed", 2], ["Minor bugs (not high priority)", 1], ["Further information is requested", 1], ["Awaiting something else to happen first", 1]] [["Awaiting something else to happen first", 1], ["Further information is requested", 1], ["Minor bugs (not high priority)", 1], ["Pull requests that update a dependency file", 1], ["The official Docker image, plus other things related to running Datasette on Doc...", 1], ["This issue or pull request already exists", 1], ["This will not be worked on", 1], ["Extra attention is needed", 2], ["This doesn't seem right", 2], ["Improvements or additions to documentation", 8]]
labels,id labels id 106 0 0 106    
labels,name labels name 106 0 0 57 [["enhancement", 14], ["bug", 12], ["documentation", 10], ["research", 4], ["invalid", 3], ["help wanted", 3], ["ci", 3], ["plugins", 2], ["duplicate", 2], ["design", 2]] [["release", 1], ["search", 1], ["security", 1], ["small", 1], ["support", 1], ["templates", 1], ["tests", 1], ["tracking-issue", 1], ["usability", 1], ["windows", 1]]
labels,node_id labels node_id 106 0 0 106    
labels,url labels url 106 0 0 106    
labels_fts,description labels_fts description 106 14 49 13 [["", 49], ["None", 14], ["New feature or request", 13], ["Something isn't working", 11], ["Improvements or additions to documentation", 8], ["This doesn't seem right", 2], ["Extra attention is needed", 2], ["Minor bugs (not high priority)", 1], ["Further information is requested", 1], ["Awaiting something else to happen first", 1]] [["Awaiting something else to happen first", 1], ["Further information is requested", 1], ["Minor bugs (not high priority)", 1], ["Pull requests that update a dependency file", 1], ["The official Docker image, plus other things related to running Datasette on Doc...", 1], ["This issue or pull request already exists", 1], ["This will not be worked on", 1], ["Extra attention is needed", 2], ["This doesn't seem right", 2], ["Improvements or additions to documentation", 8]]
labels_fts,name labels_fts name 106 0 0 57 [["enhancement", 14], ["bug", 12], ["documentation", 10], ["research", 4], ["invalid", 3], ["help wanted", 3], ["ci", 3], ["plugins", 2], ["duplicate", 2], ["design", 2]] [["release", 1], ["search", 1], ["security", 1], ["small", 1], ["support", 1], ["templates", 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 106 0 0 106    
labels_fts_docsize,sz labels_fts_docsize sz 106 0 0 10 [["b'\\x01\\x00'", 49], ["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'\\x04\\x00'", 1], ["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 190 0 0 28 [[1970143153, 109], [993377884, 11], [754269786, 7], [1379448359, 6], [993222446, 6], [727708734, 6], [2374328705, 5], [1405404904, 5], [750789605, 4], [754730474, 3]] [[947465681, 1], [1382668283, 1], [1918831023, 1], [2157112227, 1], [2175284252, 1], [2459412274, 1], [3645705798, 1], [3799780031, 1], [4251477726, 1], [4860121561, 1]]
labels_pull_requests,pull_requests_id labels_pull_requests pull_requests_id 190 0 0 171 [[971057476, 3], [853484980, 2], [817257851, 2], [804924636, 2], [700944644, 2], [513106026, 2], [511005542, 2], [481616704, 2], [431478724, 2], [296735320, 2]] [[1492599485, 1], [1497165426, 1], [1507097949, 1], [1510415840, 1], [1515716751, 1], [1522166951, 1], [1542299634, 1], [1562664755, 1], [1571053445, 1], [1592615419, 1]]
licenses,key licenses key 17 0 0 17    
licenses,name licenses name 17 0 0 17    
licenses,node_id licenses node_id 17 0 0 17    
licenses,spdx_id licenses spdx_id 17 0 0 17    
licenses,url licenses url 17 1 0 16 [["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/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/isc", 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]]
licenses_fts,name licenses_fts name 17 0 0 17    
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 17 0 0 17    
licenses_fts_docsize,sz licenses_fts_docsize sz 17 0 0 7 [["b'\\x06'", 5], ["b'\\x07'", 3], ["b'\\x05'", 3], ["b'\\x02'", 3], ["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 35 5 0 30 [["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]] [["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], ["2023-08-09T20:06:09Z", 1]]
milestones,closed_issues milestones closed_issues 35 0 0 23 [[11, 3], [8, 3], [7, 3], [4, 3], [21, 2], [15, 2], [13, 2], [3, 2], [2, 1], [0, 1]] [[16, 1], [19, 1], [22, 1], [23, 1], [24, 1], [25, 1], [39, 1], [49, 1], [53, 1], [60, 1]]
milestones,created_at milestones created_at 35 0 0 35    
milestones,creator milestones creator 35 0 0 1 [[9599, 35]]  
milestones,description milestones description 35 1 21 14 [["", 21], ["None", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["Issues planned for the next 1.0 alpha release.", 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]] [["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], ["Issues planned for the next 1.0 alpha release.", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["The first Datasette 1.0 alpha release.", 1], ["The new Datasette Write API.", 1], ["Writeable canned queries, authentication and permissions. [Changelog](https://da...", 1], ["https://github.com/simonw/datasette/issues/519 - stable JSON API, documented tem...", 1], ["https://simonwillison.net/2019/May/19/datasette-0-28/", 1]]
milestones,due_on milestones due_on 35 32 0 3 [["None", 32], ["2019-07-07T07:00:00Z", 1], ["2019-05-19T07:00:00Z", 1], ["2017-11-13T08:00:00Z", 1]]  
milestones,html_url milestones html_url 35 0 0 35    
milestones,id milestones id 35 0 0 35    
milestones,node_id milestones node_id 35 0 0 35    
milestones,number milestones number 35 0 0 28 [[1, 4], [7, 2], [6, 2], [5, 2], [3, 2], [11, 1], [10, 1], [8, 1], [4, 1], [2, 1]] [[20, 1], [21, 1], [22, 1], [23, 1], [24, 1], [25, 1], [26, 1], [27, 1], [28, 1], [29, 1]]
milestones,open_issues milestones open_issues 35 0 0 6 [[0, 30], [57, 1], [20, 1], [9, 1], [2, 1], [1, 1]]  
milestones,repo milestones repo 35 0 0 4 [[107914493, 26], [140912432, 7], [256834907, 1], [207052882, 1]]  
milestones,state milestones state 35 0 0 2 [["closed", 30], ["open", 5]]  
milestones,title milestones title 35 0 0 34 [["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.62", 1], ["Datasette 1.0", 1], ["Datasette 1.0a-next", 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,updated_at milestones updated_at 35 0 0 34 [["2023-11-06T04:06:12Z", 2], ["2020-03-25T04:19:33Z", 1], ["2019-07-08T03:36:57Z", 1], ["2019-07-07T20:31:25Z", 1], ["2019-05-25T01:28:06Z", 1], ["2019-05-19T22:24:03Z", 1], ["2018-06-21T15:47:49Z", 1], ["2017-12-10T03:12:22Z", 1], ["2017-12-10T02:05:05Z", 1], ["2017-11-30T16:49:38Z", 1]] [["2022-01-11T18:41:13Z", 1], ["2022-01-13T22:22:24Z", 1], ["2022-01-14T01:59:55Z", 1], ["2022-10-18T18:26:45Z", 1], ["2022-11-14T06:01:19Z", 1], ["2022-11-29T20:11:39Z", 1], ["2022-12-02T01:24:26Z", 1], ["2022-12-20T20:01:13Z", 1], ["2023-05-08T21:04:38Z", 1], ["2023-08-09T20:06:09Z", 1]]
milestones_fts,description milestones_fts description 35 1 21 14 [["", 21], ["None", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["Issues planned for the next 1.0 alpha release.", 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]] [["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], ["Issues planned for the next 1.0 alpha release.", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["The first Datasette 1.0 alpha release.", 1], ["The new Datasette Write API.", 1], ["Writeable canned queries, authentication and permissions. [Changelog](https://da...", 1], ["https://github.com/simonw/datasette/issues/519 - stable JSON API, documented tem...", 1], ["https://simonwillison.net/2019/May/19/datasette-0-28/", 1]]
milestones_fts,title milestones_fts title 35 0 0 34 [["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.62", 1], ["Datasette 1.0", 1], ["Datasette 1.0a-next", 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_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 35 0 0 35    
milestones_fts_docsize,sz milestones_fts_docsize sz 35 0 0 17 [["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\\x0c'", 1], ["b'\\x03\\x0e'", 1], ["b'\\x03\\x11'", 1], ["b'\\x03\\x1a'", 1], ["b'\\x04\\t'", 1], ["b'\\x04\\x0e'", 1], ["b'\\x05\\x00'", 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 608 605 0 1 [["None", 608]]  
pull_requests,author_association pull_requests author_association 608 0 0 5 [["CONTRIBUTOR", 308], ["OWNER", 201], ["FIRST_TIME_CONTRIBUTOR", 69], ["NONE", 25], ["MEMBER", 5]]  
pull_requests,auto_merge pull_requests auto_merge 608 608 0 0 [[null, 608]]  
pull_requests,base pull_requests base 608 0 0 445 [["f09d611782a8372cfb002792dfa727325afb4db6", 7], ["1b697539f5b53cec3fe13c0f4ada13ba655c88c7", 6], ["e54e544427f1cc3ea8189f0e95f54046301a8645", 5], ["0b4a28691468b5c758df74fa1d72a823813c96bf", 5], ["6ed7908580fa2ba9297c3225d85c56f8b08b9937", 4], ["5890a20c374fb0812d88c9b0ef26a838bfa06c76", 4], ["527cec66b0403e689c8fb71fc8b381a1d7a46516", 4], ["452a587e236ef642cbc6ae345b58767ea8420cb5", 4], ["11b352b4d52fd02a422776edebb14f12e4994d3b", 4], ["08181823990a71ffa5a1b57b37259198eaa43e06", 4]] [["f825e2012109247fa246e2b938f8174069e574f1", 1], ["f8277d0fb9c05a88a9ff01d996e31d55f0f0a645", 1], ["fa8eb0bf1b113ab17ede9cd107b7c3bd5cde39c3", 1], ["faea5093b865031f650da7da6539430f732f511a", 1], ["fb988ace7c7e2bee5ac142a0eab22431d0675a77", 1], ["fcf43589eb6a1f1d0432772a639fd35711c48e0c", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fd083e37ec53e7e625111168d324a572344a3b19", 1], ["fe5b6ea95a973534fe8a44907c0ea2449aae7602", 1], ["fff89772b4404995400e33fe1d269050717ff4cf", 1]]
pull_requests,body pull_requests body 608 10 54 544 [["", 54], ["None", 10], ["Refs #744", 2], ["\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], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] [["sqlite foreign keys can be compound, but that is not as well supported by datase...", 1], ["still testing, hope it works!\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n-...", 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], ["this var `app` isn't actually used? unless init it does some side-effect outside...", 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 608 93 0 514 [["None", 93], ["2023-08-07T16:20:20Z", 2], ["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-10-12T16:16:38Z", 1], ["2023-10-12T16:20:51Z", 1], ["2023-10-13T00:00:27Z", 1], ["2023-10-24T13:40:26Z", 1], ["2023-11-04T00:31:49Z", 1], ["2023-11-04T00:40:30Z", 1], ["2023-11-04T00:49:50Z", 1], ["2023-11-04T00:58:02Z", 1], ["2023-11-08T13:19:01Z", 1], ["2023-12-08T05:05:27Z", 1]]
pull_requests,created_at pull_requests created_at 608 0 0 608    
pull_requests,draft pull_requests draft 608 0 0 2 [[0, 596], [1, 12]]  
pull_requests,head pull_requests head 608 0 0 608    
pull_requests,id pull_requests id 608 0 0 608    
pull_requests,locked pull_requests locked 608 0 0 1 [[0, 608]]  
pull_requests,merge_commit_sha pull_requests merge_commit_sha 608 1 0 607 [["None", 1], ["03cc697b6b3d0983618c29ee75b45b5e0ac91139", 1], ["03b35d70e281ea48bd9b8058738ed87b13cea2de", 1], ["02f5c4d69d7b4baebde015c56e5bc62923f33314", 1], ["0276c5609da34bfb660f65212e1a367e637979d7", 1], ["025b4024b1b43ea034b7fd331c30740165ff75f2", 1], ["022cdd97a9ddab1a152e23e1e1c42e78c1ed0fa9", 1], ["01369176b0a8943ab45292ffc6f9c929b80a00e8", 1], ["013496862f4d4b441ab61255242b838b24287607", 1], ["00e59ec461dc0150772b999c7cc15fcb9b507d58", 1]] [["f92d823766872a6fd7e76c5249a6b2de1ab0f447", 1], ["f96e55bce55d26c4d5b198edc536e1b8e9bbea43", 1], ["f99a23652910b03ac4669bbbb35a9b484451aabb", 1], ["fb3abeceb2785a582d2c120c7c1bf7dc3cd1de05", 1], ["fb57d4474cb1fdaef260e244b1b6f470f1992e40", 1], ["fc2d316f9e22593d48036e9d81fe972bb5973016", 1], ["fc3660cfad7668dbce6ead12766e048fc1f78b11", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fda4dad23a0494890267fbe8baf179e2b56ee914", 1], ["ffff3a4c5398a9f40b61d59736f386444da19289", 1]]
pull_requests,merged_at pull_requests merged_at 608 200 0 408 [["None", 200], ["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-09-13T21:06:25Z", 1], ["2023-09-20T22:10:55Z", 1], ["2023-09-20T22:11:24Z", 1], ["2023-10-12T16:16:38Z", 1], ["2023-10-12T16:20:51Z", 1], ["2023-10-13T00:00:27Z", 1], ["2023-11-04T00:31:49Z", 1], ["2023-11-04T00:40:30Z", 1], ["2023-11-04T00:49:50Z", 1], ["2023-12-08T05:05:27Z", 1]]
pull_requests,merged_by pull_requests merged_by 608 608 0 0 [[null, 608]]  
pull_requests,milestone pull_requests milestone 608 573 0 15 [["None", 573], [6026070, 6], [3268330, 4], [8711695, 3], [6346396, 3], [5512395, 3], [5471110, 3], [7558727, 2], [5971510, 2], [4471010, 2]] [[5234079, 1], [5533512, 1], [5897911, 1], [6055094, 1], [9700784, 1], [4471010, 2], [5971510, 2], [7558727, 2], [8355157, 2], [8711695, 3]]
pull_requests,node_id pull_requests node_id 608 0 0 608    
pull_requests,number pull_requests number 608 0 0 561 [[8, 4], [5, 4], [67, 3], [65, 3], [15, 3], [13, 3], [6, 3], [7, 2], [4, 2], [1, 2]] [[2182, 1], [2183, 1], [2185, 1], [2190, 1], [2191, 1], [2192, 1], [2200, 1], [2202, 1], [2206, 1], [2209, 1]]
pull_requests,repo pull_requests repo 608 0 0 14 [[107914493, 436], [140912432, 110], [206156866, 13], [207052882, 11], [256834907, 7], [197882382, 7], [214746582, 6], [206649770, 5], [303218369, 4], [205429375, 3]] [[197431109, 1], [213286752, 1], [248903544, 2], [611552758, 2], [205429375, 3], [303218369, 4], [206649770, 5], [214746582, 6], [197882382, 7], [256834907, 7]]
pull_requests,state pull_requests state 608 0 0 2 [["closed", 515], ["open", 93]]  
pull_requests,title pull_requests title 608 0 0 595 [["Bump the python-packages group with 1 update", 5], ["Bump the python-packages group with 3 updates", 3], ["Use Read the Docs action v1", 2], ["Update deploying.rst", 2], ["Update README.md", 2], ["Test against Python 3.12 preview", 2], ["Bump the python-packages group with 2 updates", 2], ["Bump sphinx, furo, blacken-docs dependencies", 2], ["Add paths for homebrew on Apple silicon", 2], [" Don't duplicate simple primary keys in the link column", 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 poetry for packages, asdf for versioning, and gh actions for ci", 1], ["use single quotes for string literals, fixes #2001", 1], ["use universal command", 1]]
pull_requests,updated_at pull_requests updated_at 608 0 0 606 [["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-10-14T17:49:03Z", 1], ["2023-10-24T13:40:29Z", 1], ["2023-11-04T00:34:33Z", 1], ["2023-11-04T00:46:55Z", 1], ["2023-11-04T00:49:50Z", 1], ["2023-11-04T00:58:03Z", 1], ["2023-11-08T13:19:03Z", 1], ["2023-11-15T15:31:12Z", 1], ["2023-12-08T05:17:20Z", 1], ["2023-12-08T13:46:24Z", 1]]
pull_requests,url pull_requests url 608 0 0 608    
pull_requests,user pull_requests user 608 0 0 189 [[9599, 206], [49699333, 87], [27856297, 21], [45057, 19], [15178711, 9], [536941, 8], [25778, 8], [3243482, 7], [2657547, 6], [198537, 5]] [[39452697, 1], [52261150, 1], [56323389, 1], [72577720, 1], [87192257, 1], [91880982, 1], [99098079, 1], [102635518, 1], [111973926, 1], [130708713, 1]]
pull_requests_fts,body pull_requests_fts body 608 10 54 544 [["", 54], ["None", 10], ["Refs #744", 2], ["\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], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]] [["sqlite foreign keys can be compound, but that is not as well supported by datase...", 1], ["still testing, hope it works!\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n-...", 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], ["this var `app` isn't actually used? unless init it does some side-effect outside...", 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])
);