resource_roles
3 rows where resource_id = "iiw-30"
This data as json, CSV (advanced)
role 3
how 1
- derived 3
| Link | rowid ▼ | resource_id | role | how |
|---|---|---|---|---|
| 1325 | 1325 | IIW 30 (Spring 2020, 28 to 30 April 2020, Mountain View) iiw-30 | Marketing and communications communications | derived |
| 1326 | 1326 | IIW 30 (Spring 2020, 28 to 30 April 2020, Mountain View) iiw-30 | Business development business-development | derived |
| 1327 | 1327 | IIW 30 (Spring 2020, 28 to 30 April 2020, Mountain View) iiw-30 | Researcher researcher | derived |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE resource_roles (resource_id TEXT REFERENCES resources(id), role TEXT REFERENCES roles(id), how TEXT);