sortable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
26 rows where pk1 = "d" sorted by sortable descending
This data as json, testall, testnone, testresponse, CSV (advanced)
Suggested facets: sortable, text
Link | pk1 | pk2 | sortable_with_nulls |
---|---|---|---|
d,s | d | s | 0.5225725351302178 |
d,m | d | m | |
d,k | d | k | 0.24330516387675716 |
d,j | d | j | 0.4760931107841647 |
d,v | d | v | |
d,w | d | w | 0.26455462565889964 |
d,y | d | y | 0.7489577220696233 |
d,a | d | a | 0.3119572443946952 |
d,t | d | t | 0.6096309122451303 |
d,c | d | c | 0.7826353463610196 |
d,r | d | r | |
d,i | d | i | |
d,f | d | f | 0.4355744930038943 |
d,g | d | g | 0.46470846660323173 |
d,e | d | e | 0.5217467469384799 |
d,l | d | l | 0.7028549421857689 |
d,o | d | o | 0.04551570098321833 |
d,z | d | z | |
d,u | d | u | |
d,h | d | h | 0.48754993239134437 |
d,q | d | q | |
d,x | d | x | 0.5445623787105787 |
d,n | d | n | 0.8326283633270679 |
d,b | d | b | |
d,d | d | d | |
d,p | d | p | 0.5740642196263323 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );