sortable

Data source: github.com/simon/datasette-psutil · About: /-/psutil demo

26 rows where pk1 = "g" sorted by sortable descending

View and edit SQL

pk1

Link pk1 pk2 content sortable ▲ sortable_with_nulls sortable_with_nulls_2 text
g y g-y 15     $null
g z g-z 15 0.10350187727039162 0.08432913202456382 $null
g f g-f 9 0.9745466021257082   $blah
g i g-i -4 0.41983249376450316 0.3243828920784265 $null
g w g-w -10 0.5073368852897782 0.037607245571092074 $null
g a g-a -20 0.426764006260958 0.9535925176191249 $null
g l g-l -28 0.5931342503922638 0.6671325587363496 $null
g t g-t -40   0.760215295546892 $null
g u g-u -55 0.9512921405795819 0.7544458252469858 $blah
g b g-b -77     $null
g o g-o -82 0.3970711742472973 0.0187415365856457 $blah
g j g-j -87   0.27210284354621894 $blah
g g g-g -93 0.1804160719608544   $null
g m g-m -99     $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 · Query took 5.054ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo