sortable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
26 rows where pk1 = "c" sorted by sortable descending
This data as json, testall, testnone, testresponse, CSV (advanced)
Suggested facets: text
pk2 26 ✖
Link | pk1 | pk2 | sortable_with_nulls |
---|---|---|---|
c,x | c | x | |
c,n | c | n | |
c,j | c | j | |
c,p | c | p | 0.21395287710598743 |
c,g | c | g | 0.47318618590932626 |
c,e | c | e | |
c,a | c | a | 0.43456375856464435 |
c,b | c | b | 0.19007877450229604 |
c,m | c | m | 0.44591361207670044 |
c,d | c | d | 0.30928466220865325 |
c,s | c | s | |
c,r | c | r | 0.0058960835839930725 |
c,t | c | t | 0.9807219775189232 |
c,v | c | v | 0.32684580488130854 |
c,q | c | q | 0.5840794142042252 |
c,c | c | c | 0.4312973996249869 |
c,f | c | f | 0.4298881499898346 |
c,o | c | o | |
c,y | c | y | 0.6694588446199107 |
c,k | c | k | 0.9579660422795397 |
c,z | c | z | 0.9637347441012087 |
c,l | c | l | 0.6675777325863531 |
c,h | c | h | 0.7511381375407322 |
c,u | c | u | 0.6427496480093358 |
c,w | c | w | |
c,i | c | i |
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) );