sortable

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

94 rows where text = "$blah" sorted by pk2

View and edit SQL

pk1

text

  • $blah · 40
Link pk1 pk2 ▼ content sortable sortable_with_nulls sortable_with_nulls_2 text
e m e-m 50   0.44654739304319446 $blah
f m f-m 6 0.8336930832963215   $blah
h m h-m -59   0.8730019200593472 $blah
f n f-n -45 0.44338308606070165 0.6856802654812854 $blah
g n g-n 27 0.7470141234297678 0.23011071607665967 $blah
h n h-n 41 0.7114009771190007   $blah
g o g-o -82 0.3970711742472973 0.0187415365856457 $blah
h o h-o 15 0.9053062089782412 0.09171356965909339 $blah
a p a-p 74 0.7508777995916097   $blah
b p b-p -73 0.7424166839809987   $blah
c p c-p 80 0.21395287710598743   $blah
d p d-p -97 0.5740642196263323 0.34070593256029236 $blah
c q c-q -1 0.5840794142042252 0.8806566727578236 $blah
g q g-q 58 0.4600969018938087   $blah
b r b-r -100 0.33355653860508816 0.44183551186085057 $blah
e r e-r 20 0.2650227795434089 0.692704598586882 $blah
d s d-s 98 0.5225725351302178 0.2973531325173874 $blah
h s h-s -80   0.7272347853249318 $blah
f t f-t -56 0.26536750832497336 0.5260855265978671 $blah
d u d-u -33   0.551992245577759 $blah
e u e-u 13   0.04599096867721275 $blah
f u f-u 99 0.36203897381751204   $blah
g u g-u -55 0.9512921405795819 0.7544458252469858 $blah
a v a-v 38 0.6898676320996214 0.9951493566608947 $blah
c v c-v 16 0.32684580488130854 0.278256615638806 $blah
f v f-v 17 0.6433406842054887   $blah
d w d-w 75 0.26455462565889964   $blah
f w f-w 82     $blah
a x a-x 50 0.07099308600903254   $blah
b x b-x 17   0.22292354720580898 $blah
d x d-x -71 0.5445623787105787   $blah
f x f-x 59 0.6330767243010155 0.3809043988185208 $blah
a y a-y -82 0.5141561198085891 0.132311848725025 $blah
b y b-y -29 0.8643529420302863 0.5094056755280374 $blah
c y c-y -39 0.6694588446199107 0.9477570222166518 $blah
d y d-y 52 0.7489577220696233 0.4391534486737374 $blah
e y e-y -82 0.3455656244430817 0.962029072823442 $blah
a z a-z -38   0.09432579649188222 $blah
d z d-z -31   0.8894228892924536 $blah
e z e-z 16 0.8453039251425987 0.8533354586601858 $blah

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 11.371ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo