sortable

19 rows where pk1 = "g" and text = "$null"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sortable

Link pk1 pk2 content sortable sortable_with_nulls sortable_with_nulls_2 text
g,a g a g-a -20 0.426764006260958 0.9535925176191249 $null
g,b g b g-b -77     $null
g,d g d g-d 84 0.051446079972376046   $null
g,e g e g-e 68 0.4821893962043886 0.8453734186013451 $null
g,g g g g-g -93 0.1804160719608544   $null
g,h g h g-h 44 0.06958542124833644 0.03065709838090591 $null
g,i g i g-i -4 0.41983249376450316 0.3243828920784265 $null
g,k g k g-k 24   0.7549431436683707 $null
g,l g l g-l -28 0.5931342503922638 0.6671325587363496 $null
g,m g m g-m -99     $null
g,p g p g-p 46 0.40442288450523434 0.11517337266379823 $null
g,r g r g-r 50 0.4004498163160871   $null
g,s g s g-s 30   0.3493752654723803 $null
g,t g t g-t -40   0.760215295546892 $null
g,v g v g-v 60 0.3161388944905802 0.44220806383628486 $null
g,w g w g-w -10 0.5073368852897782 0.037607245571092074 $null
g,x g x g-x 65 0.8552933714560903 0.3844824765824649 $null
g,y g y g-y 15     $null
g,z g z g-z 15 0.10350187727039162 0.08432913202456382 $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)
);