sortable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
26 rows where pk1 = "f" sorted by sortable descending
This data as json, testall, testnone, testresponse, CSV (advanced)
Suggested facets: text
Link | pk1 | pk2 | sortable_with_nulls |
---|---|---|---|
f,u | f | u | 0.36203897381751204 |
f,g | f | g | 0.8703969593250397 |
f,e | f | e | 0.13141180642048544 |
f,w | f | w | |
f,s | f | s | 0.866447888506801 |
f,p | f | p | |
f,d | f | d | |
f,x | f | x | 0.6330767243010155 |
f,j | f | j | 0.22136720007399002 |
f,c | f | c | |
f,r | f | r | |
f,i | f | i | 0.3810254992724753 |
f,a | f | a | |
f,b | f | b | |
f,h | f | h | |
f,f | f | f | |
f,y | f | y | 0.09917846167904198 |
f,v | f | v | 0.6433406842054887 |
f,z | f | z | 0.4515549159652815 |
f,m | f | m | 0.8336930832963215 |
f,l | f | l | 0.6704862188501712 |
f,n | f | n | 0.44338308606070165 |
f,t | f | t | 0.26536750832497336 |
f,k | f | k | 0.045346811013382116 |
f,q | f | q | 0.5542077884611291 |
f,o | f | o |
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) );