sortable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
26 rows where pk1 = "f"
This data as json, testall, testnone, testresponse, CSV (advanced)
Suggested facets: text
Link | pk1 | pk2 | sortable | text |
---|---|---|---|---|
f,a | f | a | 47 | $null |
f,b | f | b | 44 | $null |
f,c | f | c | 55 | $null |
f,d | f | d | 60 | $blah |
f,e | f | e | 87 | $blah |
f,f | f | f | 35 | $blah |
f,g | f | g | 91 | $blah |
f,h | f | h | 42 | $blah |
f,i | f | i | 49 | $blah |
f,j | f | j | 56 | $null |
f,k | f | k | -65 | $null |
f,l | f | l | -1 | $null |
f,m | f | m | 6 | $blah |
f,n | f | n | -45 | $blah |
f,o | f | o | -85 | $null |
f,p | f | p | 64 | $null |
f,q | f | q | -83 | $null |
f,r | f | r | 52 | $null |
f,s | f | s | 69 | $null |
f,t | f | t | -56 | $blah |
f,u | f | u | 99 | $blah |
f,v | f | v | 17 | $blah |
f,w | f | w | 82 | $blah |
f,x | f | x | 59 | $blah |
f,y | f | y | 29 | $null |
f,z | f | z | 10 | $null |
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) );