compound_three_primary_keys
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
676 rows where pk1 = "a" sorted by pk2 descending
This data as json, testall, testnone, testresponse, CSV (advanced)
Link | pk1 | pk2 ▲ | pk3 | content |
---|---|---|---|---|
a,z,z | a | z | z | a-z-z |
a,z,y | a | z | y | a-z-y |
a,z,x | a | z | x | a-z-x |
a,z,w | a | z | w | a-z-w |
a,z,v | a | z | v | a-z-v |
a,z,u | a | z | u | a-z-u |
a,z,t | a | z | t | a-z-t |
a,z,s | a | z | s | a-z-s |
a,z,r | a | z | r | a-z-r |
a,z,q | a | z | q | a-z-q |
a,z,p | a | z | p | a-z-p |
a,z,o | a | z | o | a-z-o |
a,z,n | a | z | n | a-z-n |
a,z,m | a | z | m | a-z-m |
a,z,l | a | z | l | a-z-l |
a,z,k | a | z | k | a-z-k |
a,z,j | a | z | j | a-z-j |
a,z,i | a | z | i | a-z-i |
a,z,h | a | z | h | a-z-h |
a,z,g | a | z | g | a-z-g |
a,z,f | a | z | f | a-z-f |
a,z,e | a | z | e | a-z-e |
a,z,d | a | z | d | a-z-d |
a,z,c | a | z | c | a-z-c |
a,z,b | a | z | b | a-z-b |
a,z,a | a | z | a | a-z-a |
a,y,z | a | y | z | a-y-z |
a,y,y | a | y | y | a-y-y |
a,y,x | a | y | x | a-y-x |
a,y,w | a | y | w | a-y-w |
a,y,v | a | y | v | a-y-v |
a,y,u | a | y | u | a-y-u |
a,y,t | a | y | t | a-y-t |
a,y,s | a | y | s | a-y-s |
a,y,r | a | y | r | a-y-r |
a,y,q | a | y | q | a-y-q |
a,y,p | a | y | p | a-y-p |
a,y,o | a | y | o | a-y-o |
a,y,n | a | y | n | a-y-n |
a,y,m | a | y | m | a-y-m |
a,y,l | a | y | l | a-y-l |
a,y,k | a | y | k | a-y-k |
a,y,j | a | y | j | a-y-j |
a,y,i | a | y | i | a-y-i |
a,y,h | a | y | h | a-y-h |
a,y,g | a | y | g | a-y-g |
a,y,f | a | y | f | a-y-f |
a,y,e | a | y | e | a-y-e |
a,y,d | a | y | d | a-y-d |
a,y,c | a | y | c | a-y-c |
a,y,b | a | y | b | a-y-b |
a,y,a | a | y | a | a-y-a |
a,x,z | a | x | z | a-x-z |
a,x,y | a | x | y | a-x-y |
a,x,x | a | x | x | a-x-x |
a,x,w | a | x | w | a-x-w |
a,x,v | a | x | v | a-x-v |
a,x,u | a | x | u | a-x-u |
a,x,t | a | x | t | a-x-t |
a,x,s | a | x | s | a-x-s |
a,x,r | a | x | r | a-x-r |
a,x,q | a | x | q | a-x-q |
a,x,p | a | x | p | a-x-p |
a,x,o | a | x | o | a-x-o |
a,x,n | a | x | n | a-x-n |
a,x,m | a | x | m | a-x-m |
a,x,l | a | x | l | a-x-l |
a,x,k | a | x | k | a-x-k |
a,x,j | a | x | j | a-x-j |
a,x,i | a | x | i | a-x-i |
a,x,h | a | x | h | a-x-h |
a,x,g | a | x | g | a-x-g |
a,x,f | a | x | f | a-x-f |
a,x,e | a | x | e | a-x-e |
a,x,d | a | x | d | a-x-d |
a,x,c | a | x | c | a-x-c |
a,x,b | a | x | b | a-x-b |
a,x,a | a | x | a | a-x-a |
a,w,z | a | w | z | a-w-z |
a,w,y | a | w | y | a-w-y |
a,w,x | a | w | x | a-w-x |
a,w,w | a | w | w | a-w-w |
a,w,v | a | w | v | a-w-v |
a,w,u | a | w | u | a-w-u |
a,w,t | a | w | t | a-w-t |
a,w,s | a | w | s | a-w-s |
a,w,r | a | w | r | a-w-r |
a,w,q | a | w | q | a-w-q |
a,w,p | a | w | p | a-w-p |
a,w,o | a | w | o | a-w-o |
a,w,n | a | w | n | a-w-n |
a,w,m | a | w | m | a-w-m |
a,w,l | a | w | l | a-w-l |
a,w,k | a | w | k | a-w-k |
a,w,j | a | w | j | a-w-j |
a,w,i | a | w | i | a-w-i |
a,w,h | a | w | h | a-w-h |
a,w,g | a | w | g | a-w-g |
a,w,f | a | w | f | a-w-f |
a,w,e | a | w | e | a-w-e |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE compound_three_primary_keys ( pk1 varchar(30), pk2 varchar(30), pk3 varchar(30), content text, PRIMARY KEY (pk1, pk2, pk3) ); CREATE INDEX idx_compound_three_primary_keys_content ON compound_three_primary_keys(content);