task_readers
4 rows where reader = 105
This data as json, CSV (advanced)
id ▲ | task | reader | team | live |
---|---|---|---|---|
278 | Cross the finish line while connected to your team 769 | Sam Campbell 105 | ✓ | |
287 | Retrieve and sip your drink 793 | Sam Campbell 105 | ✓ | |
289 | Recreate the garage scene in the lab 796 | Sam Campbell 105 | ✓ | |
300 | Throw a ball into the bathtub 819 | Sam Campbell 105 | ✓ |
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 );