podcast

3 rows where guest = 25

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: rating

id ▲ episode guest topic rating
40 39 Mark Watson 25 A fat bald white man. 17 5
63 62 Mark Watson 25 A wind-dried puffin. 29 2
147 146 Mark Watson 25 I'm off to find a robin. 145 5

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
);