_analyze_tables_

Table actions

340 rows sorted by num_null

✎ View and edit SQL

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
users,login users login 7727 0 0 7727    
users,id users id 7727 0 0 7727    
users,node_id users node_id 7727 0 0 7727    
users,avatar_url users avatar_url 7727 0 0 7727    
users,gravatar_id users gravatar_id 7727 0 7727 1 [["", 7727]]  
users,html_url users html_url 7727 0 0 7727    
users,type users type 7727 0 0 3 [["User", 7643], ["Organization", 81], ["Bot", 3]]  
users,site_admin users site_admin 7727 0 0 2 [[0, 7715], [1, 12]]  
users,name users name 7727 0 0 7727    
repos,id repos id 752 0 0 752    
repos,node_id repos node_id 752 0 0 752    
repos,name repos name 752 0 0 662 [["til", 26], ["datasette", 14], ["covid19-dashboard", 13], ["devops_aula07", 9], ["devops-aula07", 7], ["TIL", 4], ["sqlite-for-data-scientists", 3], ["CloudGoat", 2], ["Book-Attic", 2], ["202002_s_devops-aula07", 2]] [["wrc-timing", 1], ["wsb-collection", 1], ["wumb-to-sqlite", 1], ["xmltotabular", 1], ["yacht-database", 1], ["yaml-to-sqlite", 1], ["z1007816", 1], ["zctaimpacts", 1], ["zero-server", 1], ["zhaobai", 1]]
repos,full_name repos full_name 752 0 0 752    
repos,private repos private 752 0 0 1 [[0, 752]]  
repos,owner repos owner 752 0 0 448 [[9599, 142], [53015001, 13], [25778, 10], [44060760, 9], [5802411, 9], [38107867, 7], [59372422, 6], [55949623, 5], [9857779, 5], [78035, 5]] [[91842948, 1], [91912885, 1], [92047518, 1], [93546675, 1], [93766133, 1], [93947784, 1], [94083909, 1], [94403920, 1], [95031004, 1], [95301613, 1]]
repos,html_url repos html_url 752 0 0 752    
repos,fork repos fork 752 0 0 2 [[0, 720], [1, 32]]  
repos,created_at repos created_at 752 0 0 752    
repos,updated_at repos updated_at 752 0 0 750 [["2021-11-24T19:31:59Z", 3], ["2018-12-20T22:34:35Z", 1], ["2018-12-08T18:42:15Z", 1], ["2018-11-15T17:58:45Z", 1], ["2018-10-21T10:34:22Z", 1], ["2018-08-19T18:44:00Z", 1], ["2018-05-25T15:38:58Z", 1], ["2018-04-25T08:22:11Z", 1], ["2018-04-19T05:48:18Z", 1], ["2017-12-26T18:54:41Z", 1]] [["2022-04-27T15:57:02Z", 1], ["2022-04-27T15:57:33Z", 1], ["2022-04-27T15:58:39Z", 1], ["2022-04-27T17:56:18Z", 1], ["2022-04-28T03:03:45Z", 1], ["2022-04-28T03:03:57Z", 1], ["2022-04-28T03:04:51Z", 1], ["2022-04-28T16:51:16Z", 1], ["2022-04-28T17:20:14Z", 1], ["2022-04-28T20:16:21Z", 1]]
repos,pushed_at repos pushed_at 752 0 0 750 [["2021-11-10T08:58:09Z", 2], ["2020-11-24T23:25:14Z", 2], ["2018-10-10T15:26:09Z", 1], ["2018-09-29T04:50:26Z", 1], ["2018-08-16T00:58:57Z", 1], ["2018-05-25T15:38:56Z", 1], ["2018-04-25T08:22:10Z", 1], ["2018-04-23T19:05:45Z", 1], ["2018-04-19T05:48:18Z", 1], ["2017-12-26T18:54:41Z", 1]] [["2022-04-21T22:54:29Z", 1], ["2022-04-23T22:51:07Z", 1], ["2022-04-25T14:54:09Z", 1], ["2022-04-26T12:41:54Z", 1], ["2022-04-26T18:22:52Z", 1], ["2022-04-26T22:11:48Z", 1], ["2022-04-27T05:30:46Z", 1], ["2022-04-27T17:59:27Z", 1], ["2022-04-28T20:29:27Z", 1], ["2022-04-28T22:08:06Z", 1]]
repos,size repos size 752 0 0 405 [[0, 36], [3, 25], [7, 21], [5, 20], [8, 19], [4, 18], [10, 16], [9, 16], [11, 14], [6, 12]] [[764749, 1], [765368, 1], [765924, 1], [767103, 1], [768388, 1], [768428, 1], [768432, 1], [771971, 1], [1289400, 1], [5200284, 1]]
repos,stargazers_count repos stargazers_count 752 0 0 50 [[0, 541], [1, 72], [2, 32], [3, 19], [7, 9], [4, 8], [6, 7], [5, 7], [12, 4], [8, 4]] [[135, 1], [138, 1], [183, 1], [193, 1], [316, 1], [821, 1], [1057, 1], [1062, 1], [1445, 1], [6011, 1]]
repos,watchers_count repos watchers_count 752 0 0 50 [[0, 541], [1, 72], [2, 32], [3, 19], [7, 9], [4, 8], [6, 7], [5, 7], [12, 4], [8, 4]] [[135, 1], [138, 1], [183, 1], [193, 1], [316, 1], [821, 1], [1057, 1], [1062, 1], [1445, 1], [6011, 1]]
repos,has_issues repos has_issues 752 0 0 2 [[1, 715], [0, 37]]  
repos,has_projects repos has_projects 752 0 0 2 [[1, 728], [0, 24]]  
repos,has_downloads repos has_downloads 752 0 0 2 [[1, 751], [0, 1]]  
repos,has_wiki repos has_wiki 752 0 0 2 [[1, 726], [0, 26]]  
repos,has_pages repos has_pages 752 0 0 2 [[0, 727], [1, 25]]  
repos,forks_count repos forks_count 752 0 0 24 [[0, 632], [1, 64], [2, 13], [3, 10], [5, 5], [4, 4], [6, 3], [16, 2], [9, 2], [7, 2]] [[18, 1], [22, 1], [28, 1], [30, 1], [55, 1], [65, 1], [199, 1], [309, 1], [331, 1], [414, 1]]
repos,archived repos archived 752 0 0 2 [[0, 751], [1, 1]]  
repos,disabled repos disabled 752 0 0 1 [[0, 752]]  
repos,open_issues_count repos open_issues_count 752 0 0 28 [[0, 539], [1, 74], [2, 33], [3, 27], [4, 23], [5, 11], [6, 6], [12, 5], [10, 4], [7, 4]] [[20, 1], [22, 1], [24, 1], [30, 1], [32, 1], [34, 1], [36, 1], [50, 1], [77, 1], [382, 1]]
repos,topics repos topics 752 0 0 155 [["[]", 549], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\"]", 27], ["[\"datasette\"]", 9], ["[\"git-scraping\"]", 4], ["[\"lexibank1\"]", 3], ["[\"datasette-io\", \"datasette-plugin\"]", 3], ["[\"datasette\", \"datasette-plugin\"]", 3], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\", \"plugin\"]", 3], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\", \"leafletjs\"]", 2], ["[\"coronavirus\", \"database\", \"datasette\", \"sql\"]", 2]] [["[\"python\", \"sqlite\", \"spatial-data\", \"spatialite\", \"datasette\"]", 1], ["[\"python\", \"template\", \"sqlite\", \"datasette\", \"gitpod\"]", 1], ["[\"python\"]", 1], ["[\"rechte-gewalt\", \"tatortrechts\"]", 1], ["[\"resident-advisor\", \"club-nights\"]", 1], ["[\"sqlite\", \"datasette-io\", \"datasette-tool\"]", 1], ["[\"sqlite\", \"myfitnesspal\", \"datasette\", \"dogsheep\", \"datasette-io\", \"datasette-t...", 1], ["[\"til\", \"today-i-learned\", \"todayilearned\"]", 1], ["[\"wip-do-not-use\"]", 1], ["[\"xtce\", \"yaml-configuration\"]", 1]]
repos,forks repos forks 752 0 0 24 [[0, 632], [1, 64], [2, 13], [3, 10], [5, 5], [4, 4], [6, 3], [16, 2], [9, 2], [7, 2]] [[18, 1], [22, 1], [28, 1], [30, 1], [55, 1], [65, 1], [199, 1], [309, 1], [331, 1], [414, 1]]
repos,open_issues repos open_issues 752 0 0 28 [[0, 539], [1, 74], [2, 33], [3, 27], [4, 23], [5, 11], [6, 6], [12, 5], [10, 4], [7, 4]] [[20, 1], [22, 1], [24, 1], [30, 1], [32, 1], [34, 1], [36, 1], [50, 1], [77, 1], [382, 1]]
repos,watchers repos watchers 752 0 0 50 [[0, 541], [1, 72], [2, 32], [3, 19], [7, 9], [4, 8], [6, 7], [5, 7], [12, 4], [8, 4]] [[135, 1], [138, 1], [183, 1], [193, 1], [316, 1], [821, 1], [1057, 1], [1062, 1], [1445, 1], [6011, 1]]
repos,default_branch repos default_branch 752 0 0 9 [["master", 395], ["main", 348], ["develop", 3], ["trunk", 1], ["test", 1], ["new_sql", 1], ["latest", 1], ["dev", 1], ["Main", 1]]  
repos,permissions repos permissions 752 0 0 5 [["{\"admin\": false, \"push\": false, \"pull\": true}", 373], ["{\"admin\": false, \"maintain\": false, \"push\": false, \"triage\": false, \"pull\": true...", 223], ["{\"admin\": true, \"push\": true, \"pull\": true}", 108], ["{\"admin\": true, \"maintain\": true, \"push\": true, \"triage\": true, \"pull\": true}", 47], ["{\"admin\": false, \"push\": true, \"pull\": true}", 1]]  
repos,temp_clone_token repos temp_clone_token 752 0 752 1 [["", 752]]  
repos,network_count repos network_count 752 0 0 45 [[0, 601], [1, 65], [2, 13], [3, 11], [5, 7], [4, 5], [6, 3], [16, 2], [9, 2], [7, 2]] [[320, 1], [331, 1], [337, 1], [370, 1], [387, 1], [397, 1], [401, 1], [420, 1], [423, 1], [428, 1]]
repos,subscribers_count repos subscribers_count 752 0 0 20 [[1, 545], [0, 66], [2, 55], [3, 33], [4, 15], [6, 10], [5, 7], [7, 5], [12, 3], [8, 2]] [[9, 1], [11, 1], [14, 1], [17, 1], [23, 1], [56, 1], [94, 1], [97, 1], [154, 1], [10, 2]]
licenses,key licenses key 14 0 0 14    
licenses,name licenses name 14 0 0 14    
licenses,spdx_id licenses spdx_id 14 0 0 14    
licenses,node_id licenses node_id 14 0 0 14    
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_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]]  
licenses_fts_idx,pgno licenses_fts_idx pgno 1 0 0 1 [[2, 1]]  
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_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]]  
repos_fts_data,id repos_fts_data id 16 0 0 16    
repos_fts_data,block repos_fts_data block 16 0 0 16    
repos_fts_idx,segid repos_fts_idx segid 14 0 0 1 [[1, 14]]  
repos_fts_idx,term repos_fts_idx term 14 0 0 14    
repos_fts_idx,pgno repos_fts_idx pgno 14 0 0 14    
repos_fts_docsize,id repos_fts_docsize id 752 0 0 752    
repos_fts_docsize,sz repos_fts_docsize sz 752 0 0 95 [["b'\\x02\\x00'", 86], ["b'\\x01\\x00'", 70], ["b'\\x03\\x00'", 53], ["b'\\x03\\x08'", 31], ["b'\\x03\\t'", 25], ["b'\\x02\\x07'", 24], ["b'\\x01\\x03'", 24], ["b'\\x03\\x07'", 23], ["b'\\x02\\x05'", 21], ["b'\\x03\\x06'", 20]] [["b'\\x04\\x1d'", 1], ["b'\\x04\\x1e'", 1], ["b'\\x05 '", 1], ["b'\\x05\\r'", 1], ["b'\\x05\\x06'", 1], ["b'\\x05\\x07'", 1], ["b'\\x05\\x13'", 1], ["b'\\x05\\x17'", 1], ["b'\\x06!'", 1], ["b'\\x06\\x07'", 1]]
repos_fts_config,k repos_fts_config k 1 0 0 1 [["version", 1]]  
repos_fts_config,v repos_fts_config v 1 0 0 1 [[4, 1]]  
users_fts_data,id users_fts_data id 37 0 0 37    
users_fts_data,block users_fts_data block 37 0 0 37    
users_fts_idx,segid users_fts_idx segid 35 0 0 1 [[1, 35]]  
users_fts_idx,term users_fts_idx term 35 0 0 35    
users_fts_idx,pgno users_fts_idx pgno 35 0 0 35    
users_fts_docsize,id users_fts_docsize id 7727 0 0 7727    
users_fts_docsize,sz users_fts_docsize sz 7727 0 0 4 [["b'\\x01\\x01'", 7266], ["b'\\x02\\x02'", 421], ["b'\\x03\\x03'", 36], ["b'\\x04\\x04'", 4]]  
users_fts_config,k users_fts_config k 1 0 0 1 [["version", 1]]  
users_fts_config,v users_fts_config v 1 0 0 1 [[4, 1]]  
licenses_fts,name licenses_fts name 14 0 0 14    
repos_fts,name repos_fts name 752 0 0 662 [["til", 26], ["datasette", 14], ["covid19-dashboard", 13], ["devops_aula07", 9], ["devops-aula07", 7], ["TIL", 4], ["sqlite-for-data-scientists", 3], ["CloudGoat", 2], ["Book-Attic", 2], ["202002_s_devops-aula07", 2]] [["wrc-timing", 1], ["wsb-collection", 1], ["wumb-to-sqlite", 1], ["xmltotabular", 1], ["yacht-database", 1], ["yaml-to-sqlite", 1], ["z1007816", 1], ["zctaimpacts", 1], ["zero-server", 1], ["zhaobai", 1]]
users_fts,login users_fts login 7727 0 0 7727    
users_fts,name users_fts name 7727 0 0 7727    
raw_authors,id raw_authors id 94 0 0 94    
raw_authors,name raw_authors name 94 0 0 90 [["Thomas Sibley", 2], ["Simon Willison", 2], ["Robert Gieseke", 2], ["Abdussamet Koçak", 2], ["Andreas Madsack", 1], ["Amjith Ramanujam", 1], ["Adrien Di Pasquale", 1], ["Adam Wolf", 1], ["Adam Jonas", 1], ["Abdus", 1]] [["chris48s", 1], ["dependabot-preview[bot]", 1], ["dependabot[bot]", 1], ["fcatus", 1], ["gerrymanoim", 1], ["joelondon", 1], ["louispotok", 1], ["lsb", 1], ["mkorosec", 1], ["vincent d warmerdam", 1]]
raw_authors,email raw_authors email 94 0 94 1 [["", 94]]  
commits,sha commits sha 3284 0 0 3284    
commits,message commits message 3284 0 0 3189 [["Fixed typo", 10], ["Typo fix", 9], ["Applied Black", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 5], ["Release 0.4", 4], ["Release 0.3", 4], ["Changelog badge", 4], ["First working version", 3]] [["utils.path_with_added_args() improvements\n\n* Now covered by unit tests\n* Preserv...", 1], ["v0.8 - added PyPI metadata, ready to ship", 1], ["view-database permission\n\nAlso now using 🔒 to indicate private resources - resou...", 1], ["view-instance permission for debug URLs, closes #833", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["word-break: break-word;", 1], ["workflow_dispatch", 1], ["x button for clearing filters, refs #1016", 1], ["xfail documentation unit tests for view classes, refs #299\n\nMore documentation u...", 1], ["© 2017-2021", 1]]
commits,author_date commits author_date 3284 0 0 3282 [["2022-03-15T15:36:35Z", 2], ["2021-07-30T00:44:16Z", 2], ["2017-10-24T02:48:06Z", 1], ["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]] [["2022-04-24T15:50:43Z", 1], ["2022-04-24T15:51:09Z", 1], ["2022-04-24T16:08:56Z", 1], ["2022-04-24T16:17:59Z", 1], ["2022-04-24T16:59:20Z", 1], ["2022-04-25T18:33:35Z", 1], ["2022-04-26T20:56:27Z", 1], ["2022-04-26T22:34:29Z", 1], ["2022-04-26T22:48:56Z", 1], ["2022-04-28T20:29:11Z", 1]]
commits,committer_date commits committer_date 3284 0 0 3183 [["2018-05-16T15:27:24Z", 23], ["2020-10-27T19:39:55Z", 11], ["2018-04-09T05:10:22Z", 9], ["2020-06-01T01:16:42Z", 8], ["2022-01-06T06:24:53Z", 6], ["2020-11-06T18:30:41Z", 6], ["2019-07-03T03:23:05Z", 5], ["2018-05-14T03:04:23Z", 5], ["2018-05-02T00:20:39Z", 4], ["2018-04-18T01:13:02Z", 4]] [["2022-04-24T14:09:08Z", 1], ["2022-04-24T14:10:13Z", 1], ["2022-04-24T15:50:43Z", 1], ["2022-04-24T16:03:14Z", 1], ["2022-04-24T16:08:56Z", 1], ["2022-04-24T16:17:59Z", 1], ["2022-04-24T16:59:20Z", 1], ["2022-04-25T18:33:35Z", 1], ["2022-04-26T22:34:29Z", 1], ["2022-04-28T20:29:11Z", 1]]
commits,raw_author commits raw_author 3284 0 0 93 [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2852], ["2946d096d0cdefdc017559e6b57e87658736e843", 229], ["5df307d91b1167b0aa175853783d760add239497", 34], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 20], ["2edd38cb3801aa07f709f083eba7cbe4f16e0978", 17], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 7], ["b90d9715d7c0881515e9d6aa98923ed89d445945", 5], ["106fe7fbf8b80a01038e265a137b3b703422db48", 5], ["90786fb02407ad60f10210c0592ee711a9a36fae", 4]] [["d151532d3a398e1acd965596193c7d4c7c0475ff", 1], ["d6a64a7ba2d6c2c36f86efe56eb62e19518bfd72", 1], ["d9a1cca675e8697c10ac5f4cbceac5ea7dc2a906", 1], ["daa0836007170071f748b575d34c4432f4f43926", 1], ["eab1e8f71bd05f2ff2163f024127cc28876dd05d", 1], ["f25304fb12f6d6fab36f551427610ed8e96f0c2f", 1], ["f2f4d10a554519ea00fb44a5f6377123c59e1f22", 1], ["f3dfe1c3cf166dd0b9b8860a25045107a068c5df", 1], ["f85fb7898f36734a83fd9c8a2c2e96c751920c35", 1], ["fcf3b31d4679bb2112170ec4dda53dede33a16b3", 1]]
commits,raw_committer commits raw_committer 3284 0 0 6 [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2327], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 691], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]]  
commits,repo commits repo 3284 0 0 15 [[107914493, 1995], [140912432, 754], [207052882, 167], [206156866, 132], [197431109, 61], [256834907, 41], [205429375, 33], [197882382, 30], [303218369, 19], [248903544, 13]] [[209590345, 1], [206649770, 6], [206202864, 10], [213286752, 10], [214746582, 12], [248903544, 13], [303218369, 19], [197882382, 30], [205429375, 33], [256834907, 41]]
commits_fts,message commits_fts message 3284 0 0 3189 [["Fixed typo", 10], ["Typo fix", 9], ["Applied Black", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 5], ["Release 0.4", 4], ["Release 0.3", 4], ["Changelog badge", 4], ["First working version", 3]] [["utils.path_with_added_args() improvements\n\n* Now covered by unit tests\n* Preserv...", 1], ["v0.8 - added PyPI metadata, ready to ship", 1], ["view-database permission\n\nAlso now using 🔒 to indicate private resources - resou...", 1], ["view-instance permission for debug URLs, closes #833", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["word-break: break-word;", 1], ["workflow_dispatch", 1], ["x button for clearing filters, refs #1016", 1], ["xfail documentation unit tests for view classes, refs #299\n\nMore documentation u...", 1], ["© 2017-2021", 1]]
commits_fts_data,id commits_fts_data id 39 0 0 39    
commits_fts_data,block commits_fts_data block 39 0 0 39    
commits_fts_idx,segid commits_fts_idx segid 37 0 0 1 [[1, 37]]  
commits_fts_idx,term commits_fts_idx term 37 0 0 37    
commits_fts_idx,pgno commits_fts_idx pgno 37 0 0 37    
commits_fts_docsize,id commits_fts_docsize id 3284 0 0 3284    
commits_fts_docsize,sz commits_fts_docsize sz 3284 0 0 118 [["b'\\x07'", 418], ["b'\\x08'", 386], ["b'\\x06'", 370], ["b'\\t'", 321], ["b'\\x05'", 277], ["b'\\n'", 197], ["b'\\x04'", 184], ["b'\\x03'", 184], ["b'\\x0b'", 119], ["b'\\x0c'", 100]] [["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'\\x81\\x1b'", 1], ["b'\\x81h'", 1]]
commits_fts_config,k commits_fts_config k 1 0 0 1 [["version", 1]]  
commits_fts_config,v commits_fts_config v 1 0 0 1 [[4, 1]]  
milestones,id milestones id 28 0 0 28    
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,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,creator milestones creator 28 0 0 1 [[9599, 28]]  

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