This data as json, CSV (advanced)
| Link | pk1 | pk2 | content | sortable | sortable_with_nulls | sortable_with_nulls_2 ▲ | text |
|---|---|---|---|---|---|---|---|
| b,x | b | x | b-x | 17 | 0.22292354720580898 | $blah | |
| b,o | b | o | b-o | 70 | 0.2993787521999779 | 0.1035865019182115 | $null |
| b,q | b | q | b-q | 29 | 0.09229846771273342 | $null | |
| b,a | b | a | b-a | 5 | 0.7290758494598506 | $blah | |
| b,b | b | b | b-b | 86 | $blah | ||
| b,d | b | d | b-d | -88 | $null | ||
| b,e | b | e | b-e | 4 | 0.48564112545071847 | $blah | |
| b,h | b | h | b-h | -86 | 0.4767885171089349 | $null | |
| b,l | b | l | b-l | -20 | $null | ||
| b,p | b | p | b-p | -73 | 0.7424166839809987 | $blah | |
| b,t | b | t | b-t | 10 | $null | ||
| b,u | b | u | b-u | -10 | 0.7801162418714427 | $null | |
| b,w | b | w | b-w | -32 | 0.15919784298073125 | $null | |
| b,z | b | z | b-z | -93 | $null |
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) );