sortable

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

26 rows where pk1 = "c" sorted by pk2

View and edit SQL

pk1

Link pk1 pk2 ▼ content sortable sortable_with_nulls sortable_with_nulls_2 text
c n c-n 96   0.2745974469175383 $null
c o c-o -31   0.23126147972818678 $null
c p c-p 80 0.21395287710598743   $blah
c q c-q -1 0.5840794142042252 0.8806566727578236 $blah
c r c-r 22 0.0058960835839930725 0.8534479505691046 $null
c s c-s 24   0.38885720324612805 $null
c t c-t 19 0.9807219775189232 0.3940202563397047 $null
c u c-u -79 0.6427496480093358 0.18172902651343215 $null
c v c-v 16 0.32684580488130854 0.278256615638806 $blah
c w c-w -80   0.3499603437201839 $null
c x c-x 99     $null
c y c-y -39 0.6694588446199107 0.9477570222166518 $blah
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)
);
Powered by Datasette · Query took 5.595ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo