sortable
201 rows sorted by pk2
This data as json, CSV (advanced)
Link | pk1 | pk2 ▼ | content | sortable | sortable_with_nulls | sortable_with_nulls_2 | text |
---|---|---|---|---|---|---|---|
f,x | f | x | f-x | 59 | 0.6330767243010155 | 0.3809043988185208 | $blah |
g,x | g | x | g-x | 65 | 0.8552933714560903 | 0.3844824765824649 | $null |
a,y | a | y | a-y | -82 | 0.5141561198085891 | 0.132311848725025 | $blah |
b,y | b | y | b-y | -29 | 0.8643529420302863 | 0.5094056755280374 | $blah |
c,y | c | y | c-y | -39 | 0.6694588446199107 | 0.9477570222166518 | $blah |
d,y | d | y | d-y | 52 | 0.7489577220696233 | 0.4391534486737374 | $blah |
e,y | e | y | e-y | -82 | 0.3455656244430817 | 0.962029072823442 | $blah |
f,y | f | y | f-y | 29 | 0.09917846167904198 | 0.6547129575231422 | $null |
g,y | g | y | g-y | 15 | $null | ||
a,z | a | z | a-z | -38 | 0.09432579649188222 | $blah | |
b,z | b | z | b-z | -93 | $null | ||
c,z | c | z | c-z | -58 | 0.9637347441012087 | 0.11453287137889767 | $null |
d,z | d | z | d-z | -31 | 0.8894228892924536 | $blah | |
e,z | e | z | e-z | 16 | 0.8453039251425987 | 0.8533354586601858 | $blah |
f,z | f | z | f-z | 10 | 0.4515549159652815 | 0.3987301842569533 | $null |
g,z | g | z | g-z | 15 | 0.10350187727039162 | 0.08432913202456382 | $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) );