interests
Data source: See col-scraper on GitHub
10 rows where category_id = "e9002d25" and member_id = 1756
This data as json, CSV (advanced)
Link | rowid ▼ | kind | name | category_id | member_id |
---|---|---|---|---|---|
867 | 867 | member | Member, The Labour Party | Non-pecuniary interests e9002d25 | Anne Helen Fairweather 1756 |
868 | 868 | member | Member, The Co-operative Party | Non-pecuniary interests e9002d25 | Anne Helen Fairweather 1756 |
869 | 869 | member | Member, London Cycling Campaign | Non-pecuniary interests e9002d25 | Anne Helen Fairweather 1756 |
870 | 870 | member | Member - Labour Movement for Europe | Non-pecuniary interests e9002d25 | Anne Helen Fairweather 1756 |
871 | 871 | member | Member, Chartered Institute of Public Relations (CIPR) | Non-pecuniary interests e9002d25 | Anne Helen Fairweather 1756 |
872 | 872 | member | Community, Nationwide Group Staff Union | Non-pecuniary interests e9002d25 | Anne Helen Fairweather 1756 |
873 | 873 | member | Member, Tower Ward Club | Non-pecuniary interests e9002d25 | Anne Helen Fairweather 1756 |
874 | 874 | member | Member, Progress | Non-pecuniary interests e9002d25 | Anne Helen Fairweather 1756 |
875 | 875 | member | Trustee, The City Academy Hackney | Non-pecuniary interests e9002d25 | Anne Helen Fairweather 1756 |
876 | 876 | member | Micham Common Conservators (non-remunerated) | Non-pecuniary interests e9002d25 | Anne Helen Fairweather 1756 |
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");