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 |
---|---|---|---|
a,a | a | a | 63 |
a,b | a | b | 51 |
a,c | a | c | 83 |
a,d | a | d | 78 |
a,e | a | e | -76 |
a,f | a | f | -4 |
a,g | a | g | 80 |
a,h | a | h | -29 |
a,i | a | i | 55 |
a,j | a | j | 75 |
a,k | a | k | -32 |
a,l | a | l | 1 |
a,m | a | m | 91 |
a,n | a | n | -77 |
a,o | a | o | -2 |
a,p | a | p | 74 |
a,q | a | q | -100 |
a,r | a | r | 60 |
a,s | a | s | 53 |
a,t | a | t | -86 |
a,u | a | u | -68 |
a,v | a | v | 38 |
a,w | a | w | 12 |
a,x | a | x | 50 |
a,y | a | y | -82 |
a,z | a | z | -38 |
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) );