home / kskb

resource_roles

3 rows where resource_id = "iiw34-1a-vlei-update"

✎ View and edit SQL

This data as json, CSV (advanced)

role 3

  • Business development 1
  • Marketing and communications 1
  • Researcher 1

how 1

  • derived 3
Link rowid ▼ resource_id role how
1465 1465 IIW 34, 1A: vLEI Update iiw34-1a-vlei-update Marketing and communications communications derived
1466 1466 IIW 34, 1A: vLEI Update iiw34-1a-vlei-update Business development business-development derived
1467 1467 IIW 34, 1A: vLEI Update iiw34-1a-vlei-update 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);
Powered by Datasette · Queries took 601.159ms