sortable

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

26 rows where pk1 = "g" sorted by text

View and edit SQL

Suggested facets: sortable, text

pk1

Link pk1 pk2 content sortable sortable_with_nulls sortable_with_nulls_2 text ▼
g c g-c 50 0.5616833815697281 0.35359807963376766 $blah
g f g-f 9 0.9745466021257082   $blah
g j g-j -87   0.27210284354621894 $blah
g n g-n 27 0.7470141234297678 0.23011071607665967 $blah
g o g-o -82 0.3970711742472973 0.0187415365856457 $blah
g q g-q 58 0.4600969018938087   $blah
g u g-u -55 0.9512921405795819 0.7544458252469858 $blah
g a g-a -20 0.426764006260958 0.9535925176191249 $null
g b g-b -77     $null
g d g-d 84 0.051446079972376046   $null
g e g-e 68 0.4821893962043886 0.8453734186013451 $null
g g g-g -93 0.1804160719608544   $null
g h g-h 44 0.06958542124833644 0.03065709838090591 $null
g i g-i -4 0.41983249376450316 0.3243828920784265 $null
g k g-k 24   0.7549431436683707 $null
g l g-l -28 0.5931342503922638 0.6671325587363496 $null
g m g-m -99     $null
g p g-p 46 0.40442288450523434 0.11517337266379823 $null
g r g-r 50 0.4004498163160871   $null
g s g-s 30   0.3493752654723803 $null
g t g-t -40   0.760215295546892 $null
g v g-v 60 0.3161388944905802 0.44220806383628486 $null
g w g-w -10 0.5073368852897782 0.037607245571092074 $null
g x g-x 65 0.8552933714560903 0.3844824765824649 $null
g y g-y 15     $null
g z g-z 15 0.10350187727039162 0.08432913202456382 $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 17.077ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette