_analyze_tables_
2 rows where num_blank = 21
This data as json, CSV (advanced)
Link | table | column | total_rows | num_null | num_blank | num_distinct | most_common | least_common |
---|---|---|---|---|---|---|---|---|
milestones,description | milestones | description | 35 | 1 | 21 | 14 | [ [ "", 21 ], [ "None", 1 ], [ "Just addressable content, a full JSON API and pages that don\u2019t 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\u2019t 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,description | milestones_fts | description | 35 | 1 | 21 | 14 | [ [ "", 21 ], [ "None", 1 ], [ "Just addressable content, a full JSON API and pages that don\u2019t 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\u2019t 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 ] ] |
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]) );