sortable

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

26 rows where pk1 = "c"

View and edit SQL

Suggested facets: text

pk2

pk1

Link pk1 pk2 content sortable sortable_with_nulls sortable_with_nulls_2 text
c a c-a 52 0.43456375856464435   $blah
c b c-b 47 0.19007877450229604 0.9255751654990827 $null
c c c-c -7 0.4312973996249869   $blah
c d c-d 29 0.30928466220865325   $blah
c e c-e 70   0.3009498745655653 $null
c f c-f -23 0.4298881499898346 0.6066615704797627 $blah
c g c-g 72 0.47318618590932626 0.08479553672512175 $blah
c h c-h -77 0.7511381375407322   $null
c i c-i -89   0.8861369090509815 $null
c j c-j 83     $blah
c k c-k -44 0.9579660422795397   $blah
c l c-l -66 0.6675777325863531 0.5954523184694197 $blah
c m c-m 40 0.44591361207670044 0.7517767865005115 $blah
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 85.869ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette