sortable

26 rows where pk1 = "c"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: text

Link pk1 pk2 content sortable sortable_with_nulls sortable_with_nulls_2 text
c,a c a c-a 52 0.43456375856464435   $blah
c,b c b c-b 47 0.19007877450229604 0.9255751654990827 $null
c,c c c c-c -7 0.4312973996249869   $blah
c,d c d c-d 29 0.30928466220865325   $blah
c,e c e c-e 70   0.3009498745655653 $null
c,f c f c-f -23 0.4298881499898346 0.6066615704797627 $blah
c,g c g c-g 72 0.47318618590932626 0.08479553672512175 $blah
c,h c h c-h -77 0.7511381375407322   $null
c,i c i c-i -89   0.8861369090509815 $null
c,j c j c-j 83     $blah
c,k c k c-k -44 0.9579660422795397   $blah
c,l c l c-l -66 0.6675777325863531 0.5954523184694197 $blah
c,m c m c-m 40 0.44591361207670044 0.7517767865005115 $blah
c,n c n c-n 96   0.2745974469175383 $null
c,o c o c-o -31   0.23126147972818678 $null
c,p c p c-p 80 0.21395287710598743   $blah
c,q c q c-q -1 0.5840794142042252 0.8806566727578236 $blah
c,r c r c-r 22 0.0058960835839930725 0.8534479505691046 $null
c,s c s c-s 24   0.38885720324612805 $null
c,t c t c-t 19 0.9807219775189232 0.3940202563397047 $null
c,u c u c-u -79 0.6427496480093358 0.18172902651343215 $null
c,v c v c-v 16 0.32684580488130854 0.278256615638806 $blah
c,w c w c-w -80   0.3499603437201839 $null
c,x c x c-x 99     $null
c,y c y c-y -39 0.6694588446199107 0.9477570222166518 $blah
c,z c z c-z -58 0.9637347441012087 0.11453287137889767 $null

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);