interests
Data source: See col-scraper on GitHub
7 rows where category_id = "4bd97394" and member_id = 1756
This data as json, CSV (advanced)
Link | rowid ▼ | kind | name | category_id | member_id |
---|---|---|---|---|---|
860 | 860 | member | Investments through the following pension funds: | Securities 4bd97394 | Anne Helen Fairweather 1756 |
861 | 861 | member | 1) Aviva Series 6 AVAT UK Ethical S6 | Securities 4bd97394 | Anne Helen Fairweather 1756 |
862 | 862 | member | 2) CBI Retirement Benefits Plan | Securities 4bd97394 | Anne Helen Fairweather 1756 |
863 | 863 | member | 3) NEST Pensions, Ethical Fund | Securities 4bd97394 | Anne Helen Fairweather 1756 |
864 | 864 | member | 4) Friends Life Nationwide Group | Securities 4bd97394 | Anne Helen Fairweather 1756 |
865 | 865 | member | Personal Pension Arrangement: Balance and Lifetime Investment Programme | Securities 4bd97394 | Anne Helen Fairweather 1756 |
866 | 866 | member | Stocks and shares ISA (Fidelity Multi Asset Allocator Strategic Fund N-Accumulation) | Securities 4bd97394 | 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");