sortable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
26 rows where pk1 = "d" sorted by sortable_with_nulls descending
This data as json, testall, testnone, testresponse, CSV (advanced)
Link | pk1 | pk2 | content | sortable | sortable_with_nulls ▲ | sortable_with_nulls_2 | text |
---|---|---|---|---|---|---|---|
d,w | d | w | d-w | 75 | 0.26455462565889964 | $blah | |
d,k | d | k | d-k | 77 | 0.24330516387675716 | 0.47326048875952476 | $blah |
d,o | d | o | d-o | -30 | 0.04551570098321833 | 0.6974173929101944 | $null |
d,b | d | b | d-b | -81 | 0.772480884951224 | $null | |
d,d | d | d | d-d | -97 | 0.43352340132584843 | $null | |
d,i | d | i | d-i | 42 | 0.40642812467051925 | $null | |
d,m | d | m | d-m | 90 | 0.19154097301054474 | $blah | |
d,q | d | q | d-q | -71 | $null | ||
d,r | d | r | d-r | 44 | 0.7644434453261942 | $null | |
d,u | d | u | d-u | -33 | 0.551992245577759 | $blah | |
d,v | d | v | d-v | 76 | 0.2881048895936893 | $null | |
d,z | d | z | d-z | -31 | 0.8894228892924536 | $blah |
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) );