home / kskb

resource_roles

5 rows where resource_id = "rootsid"

✎ View and edit SQL

This data as json, CSV (advanced)

role 5

  • Business development 1
  • Marketing and communications 1
  • Infrastructure operator 1
  • Investor 1
  • Product owner or designer 1

how 1

  • derived 5
Link rowid ▼ resource_id role how
1788 1788 RootsID rootsid Infrastructure operator infrastructure-operator derived
1789 1789 RootsID rootsid Product owner or designer product derived
1790 1790 RootsID rootsid Marketing and communications communications derived
1791 1791 RootsID rootsid Investor investor derived
1792 1792 RootsID rootsid Business development business-development 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 1696.833ms