sortable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
26 rows where pk1 = "d"
This data as json, testall, testnone, testresponse, CSV (advanced)
Suggested facets: sortable, text
Link | pk1 | pk2 | sortable | text |
---|---|---|---|---|
d,a | d | a | 48 | $null |
d,b | d | b | -81 | $null |
d,c | d | c | 44 | $blah |
d,d | d | d | -97 | $null |
d,e | d | e | 11 | $blah |
d,f | d | f | 19 | $blah |
d,g | d | g | 15 | $blah |
d,h | d | h | -54 | $blah |
d,i | d | i | 42 | $null |
d,j | d | j | 76 | $blah |
d,k | d | k | 77 | $blah |
d,l | d | l | -10 | $null |
d,m | d | m | 90 | $blah |
d,n | d | n | -75 | $null |
d,o | d | o | -30 | $null |
d,p | d | p | -97 | $blah |
d,q | d | q | -71 | $null |
d,r | d | r | 44 | $null |
d,s | d | s | 98 | $blah |
d,t | d | t | 45 | $null |
d,u | d | u | -33 | $blah |
d,v | d | v | 76 | $null |
d,w | d | w | 75 | $blah |
d,x | d | x | -71 | $blah |
d,y | d | y | 52 | $blah |
d,z | d | z | -31 | $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) );