interests
Data source: See col-scraper on GitHub
100 rows where category_id = "4bd97394" sorted by category_id
This data as json, CSV (advanced)
Link | rowid | kind | name | category_id ▼ | member_id |
---|---|---|---|---|---|
916 | 916 | member | Alliance Trust | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
917 | 917 | member | Tesco | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
918 | 918 | member | Shareholdings in a number of private equity companies | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
919 | 919 | member | Zen Educate - shareholder | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
920 | 920 | member | Augmentum FinTech - shareholder | Securities 4bd97394 | William Anthony Bowater Russell 1202 |
940 | 940 | member | Corporation Tenant - 20, 22, 217-218 Central Markets, Smithfield, London EC1 | Securities 4bd97394 | George Christopher Abrahams 131 |
981 | 981 | member | P. J MARTINELLI LTD | Securities 4bd97394 | Paul Nicholas Martinelli 1217 |
1045 | 1045 | member | Charles Stanley Group PLC | Securities 4bd97394 | Robert Picton Seymour Howard 255 |
1046 | 1046 | partner | Charles Stanley Group PLC | Securities 4bd97394 | Robert Picton Seymour Howard 255 |
1056 | 1056 | member | JP Morgan Chase & Co. | Securities 4bd97394 | Timothy Russell Hailes 1260 |
1085 | 1085 | member | One share of Pemberton Row Limited, EC4 | Securities 4bd97394 | Jeremy Lewis Simons 384 |
1124 | 1124 | member | Upton Underwriting | Securities 4bd97394 | William Upton QC 1935 |
1273 | 1273 | member | Shares in BP, Barclays, BT and Lloyds | Securities 4bd97394 | Gregory Jones QC 1220 |
1345 | 1345 | member | None other than via investment portfolios managed on a discretionary basis. | Securities 4bd97394 | Thomas Cowley Clementi 1955 |
1357 | 1357 | member | As above if this includes interests under a Limited Liability Partnership | Securities 4bd97394 | Angus Knowles-Cutler 1943 |
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 |
1542 | 1542 | member | I HAVE VARIOUS INVESTMENTS AND UNIT TRUSTS HOLDINGS IN MY PENSION AND ISA'S WHICH MAY EXCEED £25,000 EACH AND MAY INVEST IN INSTITUTIONS BASED IN THE CITY. THESE INVESTMENTS ARE PROFESSIONALLY MANAGED SO I HAVE LIMITED KNOWLEDGE OF WHAT IS HELD. | Securities 4bd97394 | Philip Woodhouse 1211 |
1590 | 1590 | member | J P Morgan Chase & Co | Securities 4bd97394 | Robert Allan Merrett 377 |
1591 | 1591 | member | National Grid PLC | Securities 4bd97394 | Robert Allan Merrett 377 |
1615 | 1615 | member | Amlin PLC | Securities 4bd97394 | Elizabeth Rogula 376 |
1623 | 1623 | member | Shareholder in Punter Southall Group, Leadenhall Street, EC3 | Securities 4bd97394 | Clare James 264 |
1655 | 1655 | member | I have various pensionand ISA investments which have holdings that may exceed £2,500 in various unit and investment trusts, or similar type funds which may have a place of business or land ownership within the City. All our investments are managed by professional third party managers and I have limited ability to know or find out exactly what is held at any one time. 5% R&Q Capital No1Ltd (corporate name at Lloyd's). | Securities 4bd97394 | Henry Nicholas Almroth Colthurst 1210 |
1656 | 1656 | partner | I have various pensionand ISA investments which have holdings that may exceed £2,500 in various unit and investment trusts, or similar type funds which may have a place of business or land ownership within the City. All our investments are managed by professional third party managers and I have limited ability to know or find out exactly what is held at any one time. | Securities 4bd97394 | Henry Nicholas Almroth Colthurst 1210 |
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");