role_topics
2 rows where topic = "comparisons"
This data as json, CSV (advanced)
| Link | rowid ▼ | role | topic |
|---|---|---|---|
| 24 | 24 | Marketing and communications communications | Comparisons comparisons |
| 35 | 35 | Researcher researcher | Comparisons comparisons |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE role_topics (role TEXT REFERENCES roles(id), topic TEXT REFERENCES topics(id));