home / kskb

resource_roles

5 rows where resource_id = "london-stock-exchange-group"

✎ 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
1948 1948 London Stock Exchange Group london-stock-exchange-group Infrastructure operator infrastructure-operator derived
1949 1949 London Stock Exchange Group london-stock-exchange-group Product owner or designer product derived
1950 1950 London Stock Exchange Group london-stock-exchange-group Marketing and communications communications derived
1951 1951 London Stock Exchange Group london-stock-exchange-group Investor investor derived
1952 1952 London Stock Exchange Group london-stock-exchange-group 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 795.789ms