sortable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
26 rows where pk1 = "c" sorted by sortable_with_nulls_2 descending
This data as json, testall, testnone, testresponse, CSV (advanced)
Link | pk1 | pk2 | content | sortable | sortable_with_nulls | sortable_with_nulls_2 ▲ | text |
---|---|---|---|---|---|---|---|
c,o | c | o | c-o | -31 | 0.23126147972818678 | $null | |
c,u | c | u | c-u | -79 | 0.6427496480093358 | 0.18172902651343215 | $null |
c,z | c | z | c-z | -58 | 0.9637347441012087 | 0.11453287137889767 | $null |
c,g | c | g | c-g | 72 | 0.47318618590932626 | 0.08479553672512175 | $blah |
c,a | c | a | c-a | 52 | 0.43456375856464435 | $blah | |
c,c | c | c | c-c | -7 | 0.4312973996249869 | $blah | |
c,d | c | d | c-d | 29 | 0.30928466220865325 | $blah | |
c,h | c | h | c-h | -77 | 0.7511381375407322 | $null | |
c,j | c | j | c-j | 83 | $blah | ||
c,k | c | k | c-k | -44 | 0.9579660422795397 | $blah | |
c,p | c | p | c-p | 80 | 0.21395287710598743 | $blah | |
c,x | c | x | c-x | 99 | $null |
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) );