compound_three_primary_keys

Data source: github.com/simon/datasette-psutil · About: /-/psutil demo

325 rows where pk1 = "b" sorted by pk3 descending

View and edit SQL

Suggested facets: pk2, pk3

pk1

Link pk1 pk2 pk3 ▲ content
b a z b-a-z
b b z b-b-z
b c z b-c-z
b d z b-d-z
b e z b-e-z
b f z b-f-z
b g z b-g-z
b h z b-h-z
b i z b-i-z
b j z b-j-z
b k z b-k-z
b l z b-l-z
b a y b-a-y
b b y b-b-y
b c y b-c-y
b d y b-d-y
b e y b-e-y
b f y b-f-y
b g y b-g-y
b h y b-h-y
b i y b-i-y
b j y b-j-y
b k y b-k-y
b l y b-l-y
b a x b-a-x
b b x b-b-x
b c x b-c-x
b d x b-d-x
b e x b-e-x
b f x b-f-x
b g x b-g-x
b h x b-h-x
b i x b-i-x
b j x b-j-x
b k x b-k-x
b l x b-l-x
b a w b-a-w
b b w b-b-w
b c w b-c-w
b d w b-d-w
b e w b-e-w
b f w b-f-w
b g w b-g-w
b h w b-h-w
b i w b-i-w
b j w b-j-w
b k w b-k-w
b l w b-l-w
b a v b-a-v
b b v b-b-v
b c v b-c-v
b d v b-d-v
b e v b-e-v
b f v b-f-v
b g v b-g-v
b h v b-h-v
b i v b-i-v
b j v b-j-v
b k v b-k-v
b l v b-l-v
b a u b-a-u
b b u b-b-u
b c u b-c-u
b d u b-d-u
b e u b-e-u
b f u b-f-u
b g u b-g-u
b h u b-h-u
b i u b-i-u
b j u b-j-u
b k u b-k-u
b l u b-l-u
b a t b-a-t
b b t b-b-t
b c t b-c-t
b d t b-d-t
b e t b-e-t
b f t b-f-t
b g t b-g-t
b h t b-h-t
b i t b-i-t
b j t b-j-t
b k t b-k-t
b l t b-l-t
b a s b-a-s
b b s b-b-s
b c s b-c-s
b d s b-d-s
b e s b-e-s
b f s b-f-s
b g s b-g-s
b h s b-h-s
b i s b-i-s
b j s b-j-s
b k s b-k-s
b l s b-l-s
b a r b-a-r
b b r b-b-r
b c r b-c-r
b d r b-d-r

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Query took 14.848ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo