sortable

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

26 rows where pk1 = "e"

View and edit SQL

Suggested facets: sortable, text

pk2

pk1

Link pk1 pk2 content sortable sortable_with_nulls sortable_with_nulls_2 text
e a e-a 54 0.0913268866309852   $blah
e b e-b 47 0.040231673144616176 0.518963840987604 $null
e c e-c 49   0.4700103949603517 $null
e d e-d -59 0.3298036635789654 0.4004522548136564 $null
e e e-e 16   0.40417505700074563 $null
e f e-f 68   0.18758254139452712 $blah
e g e-g 94   0.43811609507237825 $blah
e h e-h -69     $blah
e i e-i -77     $blah
e j e-j 83 0.291861560261786   $blah
e k e-k 41 0.19061037094792832   $blah
e l e-l 97 0.41494242355134514 0.00256525935857721 $blah
e m e-m 50   0.44654739304319446 $blah
e n e-n 16 0.8696016832340685 0.23880554416624933 $null
e o e-o -19 0.7447051515651959 0.6636888294845347 $null
e p e-p 26 0.1262462698093887 0.33199470393136377 $null
e q e-q 34     $null
e r e-r 20 0.2650227795434089 0.692704598586882 $blah
e s e-s -19 0.6267991790079878   $null
e t e-t 61     $null
e u e-u 13   0.04599096867721275 $blah
e v e-v -5 0.43068678785540004   $null
e w e-w -80 0.3825442986168739   $null
e x e-x 18 0.459570499176731 0.009397431454871041 $null
e y e-y -82 0.3455656244430817 0.962029072823442 $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 26.742ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette