sortable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
26 rows where pk1 = "a"
This data as json, testall, testnone, testresponse, CSV (advanced)
Suggested facets: text
Link | pk1 | pk2 | sortable | text |
---|---|---|---|---|
a,a | a | a | 63 | $null |
a,b | a | b | 51 | $null |
a,c | a | c | 83 | $null |
a,d | a | d | 78 | $blah |
a,e | a | e | -76 | $null |
a,f | a | f | -4 | $null |
a,g | a | g | 80 | $blah |
a,h | a | h | -29 | $null |
a,i | a | i | 55 | $null |
a,j | a | j | 75 | $blah |
a,k | a | k | -32 | $blah |
a,l | a | l | 1 | $blah |
a,m | a | m | 91 | $blah |
a,n | a | n | -77 | $null |
a,o | a | o | -2 | $null |
a,p | a | p | 74 | $blah |
a,q | a | q | -100 | $null |
a,r | a | r | 60 | $null |
a,s | a | s | 53 | $null |
a,t | a | t | -86 | $null |
a,u | a | u | -68 | $null |
a,v | a | v | 38 | $blah |
a,w | a | w | 12 | $null |
a,x | a | x | 50 | $blah |
a,y | a | y | -82 | $blah |
a,z | a | z | -38 | $blah |
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) );