interests
Data source: See col-scraper on GitHub
2 rows where category_id = "e9002d25" and member_id = 2058
This data as json, CSV (advanced)
Link | rowid ▼ | kind | name | category_id | member_id |
---|---|---|---|---|---|
401 | 401 | member | Chairman of the Board of Governors, Epping St. John's Church of England School, Bury Lane, Epping, Essex, CM16 5JB (a member of the Burnt Mill Multi Academy Trust who operates schools within London) | Non-pecuniary interests e9002d25 | Benjamin Daniel Murphy 2058 |
402 | 402 | member | Member - Bishopsgate Ward Club | Non-pecuniary interests e9002d25 | Benjamin Daniel Murphy 2058 |
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");