podcast

5 rows where guest = 57

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ episode guest topic rating
10 10 Richard Herring 57 Dog meat trifle. 84 5
24 24 Richard Herring 57 It's not your fault. 86 3
56 55 Richard Herring 57 Nothing matters. 104 2
87 86 Richard Herring 57 The Alpine Darling. 117 10
106 105 Richard Herring 57 The one that bats do. 125 4

Advanced export

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

CSV options: 

CREATE TABLE podcast (
   id      INTEGER PRIMARY KEY,
   episode INTEGER,
   guest   INTEGER REFERENCES people(id),
   topic   INTEGER REFERENCES episodes(id),
   rating  REAL
);