task_readers
6 rows where reader = 102
This data as json, CSV (advanced)
id ▲ | task | reader | team | live |
---|---|---|---|---|
254 | Throw your items into your bucket 720 | Mae Martin 102 | ✓ | |
259 | Perform a slow-motion fight scene 729 | Mae Martin 102 | ✓ | |
264 | Salvage the most spoons 739 | Mae Martin 102 | ✓ | |
268 | Free yourselves and have a team hug 748 | Mae Martin 102 | ✓ | |
269 | Imitate accents/walks 750 | Mae Martin 102 | ✓ | |
272 | Make these things the same colour 757 | Mae Martin 102 | ✓ |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE task_readers ( id INTEGER PRIMARY KEY, task INTEGER REFERENCES tasks(id), reader INTEGER REFERENCES people(id), team INTEGER, live INTEGER );