resource_roles

3 rows where resource_id = "kerione-closing-keynote-2-sam-smith-nonconformist"

✎ View and edit SQL

This data as json, CSV (advanced)

how 1

Link rowid ▼ resource_id role how
560 560 Closing Keynote #2: Sam Smith (Nonconformist Innovation Summit) kerione-closing-keynote-2-sam-smith-nonconformist Marketing and communications communications derived
561 561 Closing Keynote #2: Sam Smith (Nonconformist Innovation Summit) kerione-closing-keynote-2-sam-smith-nonconformist Business development business-development derived
562 562 Closing Keynote #2: Sam Smith (Nonconformist Innovation Summit) kerione-closing-keynote-2-sam-smith-nonconformist Researcher researcher derived

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE resource_roles (resource_id TEXT REFERENCES resources(id), role TEXT REFERENCES roles(id), how TEXT);