sortable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
8 rows where pk2 = "o" sorted by sortable descending
This data as json, testall, testnone, testresponse, CSV (advanced)
Suggested facets: text
Link | pk1 | pk2 | sortable_with_nulls |
---|---|---|---|
b,o | b | o | 0.2993787521999779 |
h,o | h | o | 0.9053062089782412 |
a,o | a | o | 0.9961213802400968 |
e,o | e | o | 0.7447051515651959 |
d,o | d | o | 0.04551570098321833 |
c,o | c | o | |
g,o | g | o | 0.3970711742472973 |
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) );