interests
Data source: See col-scraper on GitHub
100 rows where category_id = "4bd97394" sorted by name
This data as json, CSV (advanced)
Link | rowid | kind | name ▼ | category_id | member_id |
---|---|---|---|---|---|
68 | 68 | member | Member - Future Fuels No 1 LLP | Securities 4bd97394 | Nicholas Stephen Leland Lyons 2034 |
67 | 67 | member | Member - Samarkand Film Partnership 1 | Securities 4bd97394 | Nicholas Stephen Leland Lyons 2034 |
66 | 66 | member | Member - The Krypton LP | Securities 4bd97394 | Nicholas Stephen Leland Lyons 2034 |
908 | 908 | partner | Morgan Sindall | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
1450 | 1450 | member | NAISBITT KING ASSET MANAGEMENT LIMITED - CHAIRMAN | Securities 4bd97394 | Alastair John Naisbitt King 269 |
1451 | 1451 | member | NAISBITT KING LIMITED - CHAIRMAN | Securities 4bd97394 | Alastair John Naisbitt King 269 |
1591 | 1591 | member | National Grid PLC | Securities 4bd97394 | Robert Allan Merrett 377 |
1345 | 1345 | member | None other than via investment portfolios managed on a discretionary basis. | Securities 4bd97394 | Thomas Cowley Clementi 1955 |
1085 | 1085 | member | One share of Pemberton Row Limited, EC4 | Securities 4bd97394 | Jeremy Lewis Simons 384 |
467 | 467 | member | Owner of an LLP at Lloyd's of London | Securities 4bd97394 | Brian Desmond Francis Mooney 378 |
63 | 63 | partner | Owns shares in Clipstone Reit PLC (which owns various distribution warehouses outside London but which could be land owned by the City of London Corporation) | Securities 4bd97394 | Nicholas Stephen Leland Lyons 2034 |
981 | 981 | member | P. J MARTINELLI LTD | Securities 4bd97394 | Paul Nicholas Martinelli 1217 |
679 | 679 | member | Payden Global Inflation Linked Bond Fund | Securities 4bd97394 | Robert Charles Hughes-Penney 257 |
64 | 64 | member | Pension insurance corporation shares | Securities 4bd97394 | Nicholas Stephen Leland Lyons 2034 |
289 | 289 | partner | Pension with Aviva. | Securities 4bd97394 | Caroline Kordai Addy 1947 |
288 | 288 | member | Pension with Standard Life. | Securities 4bd97394 | Caroline Kordai Addy 1947 |
865 | 865 | member | Personal Pension Arrangement: Balance and Lifetime Investment Programme | Securities 4bd97394 | Anne Helen Fairweather 1756 |
904 | 904 | partner | Phoenix Group | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
912 | 912 | partner | Prudential | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
65 | 65 | member | Quayle Munro Holdings LTD shares | Securities 4bd97394 | Nicholas Stephen Leland Lyons 2034 |
677 | 677 | member | Rathbone Bros Plc | Securities 4bd97394 | Robert Charles Hughes-Penney 257 |
678 | 678 | partner | Rathbone Bros Plc | Securities 4bd97394 | Robert Charles Hughes-Penney 257 |
903 | 903 | member | Red Savannah | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
899 | 899 | member | Revolut - shareholder | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
909 | 909 | member | Royal Bank of Scotland | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
906 | 906 | partner | Royal Dutch Shell | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
913 | 913 | member | Royal Dutch Shell | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
647 | 647 | member | Sarasin & Partners LLP | Securities 4bd97394 | Nicholas Michael Bensted-Smith 1472 |
648 | 648 | member | Sarasin Investment Management LTD | Securities 4bd97394 | Nicholas Michael Bensted-Smith 1472 |
1623 | 1623 | member | Shareholder in Punter Southall Group, Leadenhall Street, EC3 | Securities 4bd97394 | Clare James 264 |
380 | 380 | member | Shareholder in various other listed securities but none which exceeds value of £25,000 or constitutes more than 1% of the total issued share capital of the issuing company | Securities 4bd97394 | Dhruv Patel 1224 |
918 | 918 | member | Shareholdings in a number of private equity companies | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
1273 | 1273 | member | Shares in BP, Barclays, BT and Lloyds | Securities 4bd97394 | Gregory Jones QC 1220 |
448 | 448 | member | Shares, Hiscox Ltd. | Securities 4bd97394 | Bronek Masojada 2259 |
13 | 13 | member | St Modwen Properties | Securities 4bd97394 | Dame Fiona Woolf 396 |
298 | 298 | member | Standard Life Aberdeen PLC | Securities 4bd97394 | Alexander Robertson Martin Barr 1951 |
866 | 866 | member | Stocks and shares ISA (Fidelity Multi Asset Allocator Strategic Fund N-Accumulation) | Securities 4bd97394 | Anne Helen Fairweather 1756 |
536 | 536 | member | TR European Growth Trust plc, 201 Bishopsgate, London EC2M 3AE | Securities 4bd97394 | James de Sausmarez 1658 |
917 | 917 | member | Tesco | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
11 | 11 | member | Tesco (through Tesco Personal Finance Investments) | Securities 4bd97394 | Dame Fiona Woolf 396 |
527 | 527 | member | The Bankers Investment Trust plc, 201 Bishopsgate, London EC2M 3AE | Securities 4bd97394 | James de Sausmarez 1658 |
528 | 528 | member | The City of London Investment Trust plc, 201 Bishopsgate, London EC2M 3AE | Securities 4bd97394 | James de Sausmarez 1658 |
533 | 533 | member | The Henderson Smaller Companies Investment Trust plc, 201 Bishopsgate, London EC2M 3AE | Securities 4bd97394 | James de Sausmarez 1658 |
535 | 535 | member | The Law Debenture Corporation plc, 5th Floor, 100 Wood Street, London EC2V 7EX | Securities 4bd97394 | James de Sausmarez 1658 |
685 | 685 | member | Triplepoint VCT | Securities 4bd97394 | Robert Charles Hughes-Penney 257 |
1124 | 1124 | member | Upton Underwriting | Securities 4bd97394 | William Upton QC 1935 |
680 | 680 | partner | Vanguard FTSE All World High Dividend Yield Fund | Securities 4bd97394 | Robert Charles Hughes-Penney 257 |
681 | 681 | member | Vanguard Lifestrategy Fund | Securities 4bd97394 | Robert Charles Hughes-Penney 257 |
684 | 684 | partner | Vanguard Lifestrategy Fund | Securities 4bd97394 | Robert Charles Hughes-Penney 257 |
841 | 841 | member | Various investments, unit trust holdings and ETFs in my ISAs and general investment account which may exceed £25,000 each and may invest in institutions based in the City. These investments are professionally managed on my behalf. | Securities 4bd97394 | Mary Durcan 1957 |
842 | 842 | partner | Various investments, unit trust holdings and ETFs in my ISAs and general investment account which may exceed £25,000 each and may invest in institutions based in the City. These investments are professionally managed on my behalf. Also has a SIPP. | Securities 4bd97394 | Mary Durcan 1957 |
910 | 910 | partner | Vodafone | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
911 | 911 | member | Vodafone | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
919 | 919 | member | Zen Educate - shareholder | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
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");