home / fixtures / sortable

sortable

13 rows where pk1 = "e" and text = "$null"

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

Suggested facets: sortable

Link pk1 pk2 content sortable sortable_with_nulls sortable_with_nulls_2 text
e,b e b e-b 47 0.040231673144616176 0.518963840987604 $null
e,c e c e-c 49   0.4700103949603517 $null
e,d e d e-d -59 0.3298036635789654 0.4004522548136564 $null
e,e e e e-e 16   0.40417505700074563 $null
e,n e n e-n 16 0.8696016832340685 0.23880554416624933 $null
e,o e o e-o -19 0.7447051515651959 0.6636888294845347 $null
e,p e p e-p 26 0.1262462698093887 0.33199470393136377 $null
e,q e q e-q 34     $null
e,s e s e-s -19 0.6267991790079878   $null
e,t e t e-t 61     $null
e,v e v e-v -5 0.43068678785540004   $null
e,w e w e-w -80 0.3825442986168739   $null
e,x e x e-x 18 0.459570499176731 0.009397431454871041 $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)
);
Powered by Datasette · Queries took 1.2ms