_analyze_tables_
1 row where num_blank = 10621 sorted by table
This data as json, CSV (advanced)
Link | table ▼ | column | total_rows | num_null | num_blank | num_distinct | most_common | least_common |
---|---|---|---|---|---|---|---|---|
users,gravatar_id | users | gravatar_id | 10621 | 0 | 10621 | 1 | [["", 10621]] |
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]) );