compound_three_primary_keys
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
1,001 rows sorted by pk3
This data as json, testall, testnone, testresponse, CSV (advanced)
Link | pk1 | pk2 | pk3 ▼ | content |
---|---|---|---|---|
a,f,f | a | f | f | a-f-f |
a,g,f | a | g | f | a-g-f |
a,h,f | a | h | f | a-h-f |
a,i,f | a | i | f | a-i-f |
a,j,f | a | j | f | a-j-f |
a,k,f | a | k | f | a-k-f |
a,l,f | a | l | f | a-l-f |
a,m,f | a | m | f | a-m-f |
a,n,f | a | n | f | a-n-f |
a,o,f | a | o | f | a-o-f |
a,p,f | a | p | f | a-p-f |
a,q,f | a | q | f | a-q-f |
a,r,f | a | r | f | a-r-f |
a,s,f | a | s | f | a-s-f |
a,t,f | a | t | f | a-t-f |
a,u,f | a | u | f | a-u-f |
a,v,f | a | v | f | a-v-f |
a,w,f | a | w | f | a-w-f |
a,x,f | a | x | f | a-x-f |
a,y,f | a | y | f | a-y-f |
a,z,f | a | z | f | a-z-f |
b,a,f | b | a | f | b-a-f |
b,b,f | b | b | f | b-b-f |
b,c,f | b | c | f | b-c-f |
b,d,f | b | d | f | b-d-f |
b,e,f | b | e | f | b-e-f |
b,f,f | b | f | f | b-f-f |
b,g,f | b | g | f | b-g-f |
b,h,f | b | h | f | b-h-f |
b,i,f | b | i | f | b-i-f |
b,j,f | b | j | f | b-j-f |
b,k,f | b | k | f | b-k-f |
b,l,f | b | l | f | b-l-f |
b,m,f | b | m | f | b-m-f |
a,a,g | a | a | g | a-a-g |
a,b,g | a | b | g | a-b-g |
a,c,g | a | c | g | a-c-g |
a,d,g | a | d | g | a-d-g |
a,e,g | a | e | g | a-e-g |
a,f,g | a | f | g | a-f-g |
a,g,g | a | g | g | a-g-g |
a,h,g | a | h | g | a-h-g |
a,i,g | a | i | g | a-i-g |
a,j,g | a | j | g | a-j-g |
a,k,g | a | k | g | a-k-g |
a,l,g | a | l | g | a-l-g |
a,m,g | a | m | g | a-m-g |
a,n,g | a | n | g | a-n-g |
a,o,g | a | o | g | a-o-g |
a,p,g | a | p | g | a-p-g |
a,q,g | a | q | g | a-q-g |
a,r,g | a | r | g | a-r-g |
a,s,g | a | s | g | a-s-g |
a,t,g | a | t | g | a-t-g |
a,u,g | a | u | g | a-u-g |
a,v,g | a | v | g | a-v-g |
a,w,g | a | w | g | a-w-g |
a,x,g | a | x | g | a-x-g |
a,y,g | a | y | g | a-y-g |
a,z,g | a | z | g | a-z-g |
b,a,g | b | a | g | b-a-g |
b,b,g | b | b | g | b-b-g |
b,c,g | b | c | g | b-c-g |
b,d,g | b | d | g | b-d-g |
b,e,g | b | e | g | b-e-g |
b,f,g | b | f | g | b-f-g |
b,g,g | b | g | g | b-g-g |
b,h,g | b | h | g | b-h-g |
b,i,g | b | i | g | b-i-g |
b,j,g | b | j | g | b-j-g |
b,k,g | b | k | g | b-k-g |
b,l,g | b | l | g | b-l-g |
b,m,g | b | m | g | b-m-g |
a,a,h | a | a | h | a-a-h |
a,b,h | a | b | h | a-b-h |
a,c,h | a | c | h | a-c-h |
a,d,h | a | d | h | a-d-h |
a,e,h | a | e | h | a-e-h |
a,f,h | a | f | h | a-f-h |
a,g,h | a | g | h | a-g-h |
a,h,h | a | h | h | a-h-h |
a,i,h | a | i | h | a-i-h |
a,j,h | a | j | h | a-j-h |
a,k,h | a | k | h | a-k-h |
a,l,h | a | l | h | a-l-h |
a,m,h | a | m | h | a-m-h |
a,n,h | a | n | h | a-n-h |
a,o,h | a | o | h | a-o-h |
a,p,h | a | p | h | a-p-h |
a,q,h | a | q | h | a-q-h |
a,r,h | a | r | h | a-r-h |
a,s,h | a | s | h | a-s-h |
a,t,h | a | t | h | a-t-h |
a,u,h | a | u | h | a-u-h |
a,v,h | a | v | h | a-v-h |
a,w,h | a | w | h | a-w-h |
a,x,h | a | x | h | a-x-h |
a,y,h | a | y | h | a-y-h |
a,z,h | a | z | h | a-z-h |
b,a,h | b | a | h | b-a-h |
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);