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 |
---|---|---|---|
f,a | f | a | 47 |
f,b | f | b | 44 |
f,c | f | c | 55 |
f,d | f | d | 60 |
f,e | f | e | 87 |
f,f | f | f | 35 |
f,g | f | g | 91 |
f,h | f | h | 42 |
f,i | f | i | 49 |
f,j | f | j | 56 |
f,k | f | k | -65 |
f,l | f | l | -1 |
f,m | f | m | 6 |
f,n | f | n | -45 |
f,o | f | o | -85 |
f,p | f | p | 64 |
f,q | f | q | -83 |
f,r | f | r | 52 |
f,s | f | s | 69 |
f,t | f | t | -56 |
f,u | f | u | 99 |
f,v | f | v | 17 |
f,w | f | w | 82 |
f,x | f | x | 59 |
f,y | f | y | 29 |
f,z | f | z | 10 |
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) );