sortable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
19 rows where pk1 = "h" sorted by sortable descending
This data as json, testall, testnone, testresponse, CSV (advanced)
Link | pk1 | pk2 | sortable_with_nulls |
---|---|---|---|
h,k | h | k | 0.44892796303334037 |
h,j | h | j | 0.41085861149653347 |
h,f | h | f | 0.9471086244193812 |
h,i | h | i | |
h,n | h | n | 0.7114009771190007 |
h,g | h | g | |
h,o | h | o | 0.9053062089782412 |
h,l | h | l | 0.6783068250650924 |
h,d | h | d | 0.08150198744788395 |
h,r | h | r | |
h,b | h | b | 0.7744647885737355 |
h,h | h | h | 0.9999766211030285 |
h,m | h | m | |
h,e | h | e | 0.5950412281515748 |
h,s | h | s | |
h,c | h | c | 0.32969075511772883 |
h,a | h | a | 0.24774372359828423 |
h,q | h | q | 0.099083124393048 |
h,p | h | p | 0.4148969058190054 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE sortable ( pk1 varchar(30), pk2 varchar(30), content text, sortable integer, sortable_with_nulls real, sortable_with_nulls_2 real, text text, PRIMARY KEY (pk1, pk2) );