home / fixtures

sortable

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

201 rows sorted by sortable_with_nulls

View and edit SQL

Suggested facets: pk1, pk2, text

Link pk1 pk2 content sortable sortable_with_nulls ▼ sortable_with_nulls_2 text
a a a-a 63   0.7364712141640124 $null
a b a-b 51   0.6020187290499803 $null
a c a-c 83     $null
a d a-d 78     $blah
a h a-h -29   0.37018096711688264 $null
a i a-i 55   0.3794554417576478 $null
a j a-j 75   0.22904807196410437 $blah
a l a-l 1   0.24662750769398345 $blah
a n a-n -77   0.62744604170309 $null
a t a-t -86     $null
a u a-u -68   0.2650566289400591 $null
a w a-w 12   0.33808556214745533 $null
a z a-z -38   0.09432579649188222 $blah
b b b-b 86     $blah
b c b-c -54   0.8613491047618306 $null
b d b-d -88     $null
b g b-g -61   0.5421952013742742 $blah
b i b-i -83   0.9415961272290894 $null
b l b-l -20     $null
b q b-q 29   0.09229846771273342 $null
b t b-t 10     $null
b x b-x 17   0.22292354720580898 $blah
b z b-z -93     $null
c e c-e 70   0.3009498745655653 $null
c i c-i -89   0.8861369090509815 $null
c j c-j 83     $blah
c n c-n 96   0.2745974469175383 $null
c o c-o -31   0.23126147972818678 $null
c s c-s 24   0.38885720324612805 $null
c w c-w -80   0.3499603437201839 $null
c x c-x 99     $null
d b d-b -81   0.772480884951224 $null
d d d-d -97   0.43352340132584843 $null
d i d-i 42   0.40642812467051925 $null
d m d-m 90   0.19154097301054474 $blah
d q d-q -71     $null
d r d-r 44   0.7644434453261942 $null
d u d-u -33   0.551992245577759 $blah
d v d-v 76   0.2881048895936893 $null
d z d-z -31   0.8894228892924536 $blah
e c e-c 49   0.4700103949603517 $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 m e-m 50   0.44654739304319446 $blah
e q e-q 34     $null
e t e-t 61     $null
e u e-u 13   0.04599096867721275 $blah
f a f-a 47   0.9779444845768627 $null
f b f-b 44   0.9106169537187105 $null
f c f-c 55   0.6777644586233594 $null
f d f-d 60   0.4408231901628116 $blah
f f f-f 35   0.2569700845632623 $blah
f h f-h 42   0.2644585783524238 $blah
f o f-o -85     $null
f p f-p 64     $null
f r f-r 52     $null
f w f-w 82     $blah
g b g-b -77     $null
g j g-j -87   0.27210284354621894 $blah
g k g-k 24   0.7549431436683707 $null
g m g-m -99     $null
g s g-s 30   0.3493752654723803 $null
g t g-t -40   0.760215295546892 $null
g y g-y 15     $null
h g h-g 30   0.9511693135961343 $null
h i h-i 69     $null
h m h-m -59   0.8730019200593472 $blah
h r h-r -27   0.4691101271554937 $null
h s h-s -80   0.7272347853249318 $blah
c r c-r 22 0.0058960835839930725 0.8534479505691046 $null
b v b-v -55 0.024786361898188725 0.9244872952415456 $null
e b e-b 47 0.040231673144616176 0.518963840987604 $null
f k f-k -65 0.045346811013382116 0.23480003243132908 $null
d o d-o -30 0.04551570098321833 0.6974173929101944 $null
g d g-d 84 0.051446079972376046   $null
a g a-g 80 0.06955514882374092   $blah
g h g-h 44 0.06958542124833644 0.03065709838090591 $null
a x a-x 50 0.07099308600903254   $blah
b s b-s 43 0.07524386007376704 0.9039285715598931 $null
h d h-d -15 0.08150198744788395 0.6560547180360552 $blah
e a e-a 54 0.0913268866309852   $blah
h q h-q -93 0.099083124393048   $null
f y f-y 29 0.09917846167904198 0.6547129575231422 $null
g z g-z 15 0.10350187727039162 0.08432913202456382 $null
e p e-p 26 0.1262462698093887 0.33199470393136377 $null
f e f-e 87 0.13141180642048544   $blah
b w b-w -32 0.15919784298073125   $null
g g g-g -93 0.1804160719608544   $null
c b c-b 47 0.19007877450229604 0.9255751654990827 $null
e k e-k 41 0.19061037094792832   $blah
b m b-m 37 0.2131543122670404 0.8808641736864395 $blah
c p c-p 80 0.21395287710598743   $blah
f j f-j 56 0.22136720007399002 0.909387638427892 $null
d k d-k 77 0.24330516387675716 0.47326048875952476 $blah
h a h-a -90 0.24774372359828423 0.5240685531701745 $blah
d w d-w 75 0.26455462565889964   $blah
e r e-r 20 0.2650227795434089 0.692704598586882 $blah

Next page

Advanced export

JSON shape: default, array, 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 6.821ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py