interests
Data source: See col-scraper on GitHub
1 row where category_id = "32767bc8" and name = "CMS Cameron McKenna Nabarro Olowang has provided legal advice to the City of London Corporation and may do so again in the future." sorted by name
This data as json, CSV (advanced)
Link | rowid | kind | name ▼ | category_id | member_id |
---|---|---|---|---|---|
8 | 8 | member | CMS Cameron McKenna Nabarro Olowang has provided legal advice to the City of London Corporation and may do so again in the future. | Contracts 32767bc8 | Dame Fiona Woolf 396 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE interests ( kind VARCHAR(10), name TEXT, category_id VARCHAR(8) REFERENCES interest_categories(id), member_id INTEGER REFERENCES members(id) ); CREATE INDEX interests_category_id ON interests("category_id"); CREATE INDEX interests_member_id ON interests("member_id");