interests
Data source: See col-scraper on GitHub
1,252 rows where category_id = "e9002d25" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: kind
Link | rowid | kind | name | category_id | member_id ▼ |
---|---|---|---|---|---|
761 | 761 | member | Aldgate Ward Club | Non-pecuniary interests e9002d25 | Douglas Barrow 128 |
762 | 762 | member | Royal National Lifeboat Institution | Non-pecuniary interests e9002d25 | Douglas Barrow 128 |
763 | 763 | member | Freemason | Non-pecuniary interests e9002d25 | Douglas Barrow 128 |
764 | 764 | member | The Worshipful Company of Shipwrights - Past Master | Non-pecuniary interests e9002d25 | Douglas Barrow 128 |
765 | 765 | member | The Worshipful Company of Fuellers - Past Master | Non-pecuniary interests e9002d25 | Douglas Barrow 128 |
766 | 766 | member | International Bunker Industry Association (IBIA) - Honorary Member | Non-pecuniary interests e9002d25 | Douglas Barrow 128 |
767 | 767 | member | Trinity House | Non-pecuniary interests e9002d25 | Douglas Barrow 128 |
768 | 768 | member | Shipwrights Charitable Trust | Non-pecuniary interests e9002d25 | Douglas Barrow 128 |
941 | 941 | member | Society of St George | Non-pecuniary interests e9002d25 | George Christopher Abrahams 131 |
942 | 942 | member | International Meat Traders Association (IMTA) | Non-pecuniary interests e9002d25 | George Christopher Abrahams 131 |
943 | 943 | member | International Meat Trades Association (IMTA) | Non-pecuniary interests e9002d25 | George Christopher Abrahams 131 |
944 | 944 | member | Butchers Company - Liveryman | Non-pecuniary interests e9002d25 | George Christopher Abrahams 131 |
945 | 945 | member | Smithfield Market Tenants Association (SMTA) | Non-pecuniary interests e9002d25 | George Christopher Abrahams 131 |
834 | 834 | member | City Livery Yacht Club | Non-pecuniary interests e9002d25 | John David Absalom 132 |
835 | 835 | member | Worshipful Company of Butchers | Non-pecuniary interests e9002d25 | John David Absalom 132 |
624 | 624 | member | Director of London Marathon Events Ltd. | Non-pecuniary interests e9002d25 | Nicholas Anstee 133 |
625 | 625 | member | London Symphony Orchestra, Advisory Council Member | Non-pecuniary interests e9002d25 | Nicholas Anstee 133 |
626 | 626 | member | Member, Marylebone Cricket Club (MCC) | Non-pecuniary interests e9002d25 | Nicholas Anstee 133 |
627 | 627 | member | The Worshipful Company of Butchers, Member | Non-pecuniary interests e9002d25 | Nicholas Anstee 133 |
628 | 628 | member | The Worshipful Company of Plaisterers, Honorary Member | Non-pecuniary interests e9002d25 | Nicholas Anstee 133 |
629 | 629 | member | Barbican Association, Member | Non-pecuniary interests e9002d25 | Nicholas Anstee 133 |
630 | 630 | member | Aldersgate Ward Club, Member | Non-pecuniary interests e9002d25 | Nicholas Anstee 133 |
631 | 631 | member | ICAEW, Member | Non-pecuniary interests e9002d25 | Nicholas Anstee 133 |
1692 | 1692 | member | Ward of Cordwainer Club | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1693 | 1693 | member | Insurers' Livery Company | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1694 | 1694 | member | International Bankers Livery Company | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1695 | 1695 | member | Chartered Institute of Bankers | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1696 | 1696 | member | London Cycling Campaign | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1697 | 1697 | member | Society of Genealogists | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1698 | 1698 | member | Guildhall Historical Society | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1699 | 1699 | member | European Policy Forum Advisory Council | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1700 | 1700 | member | Centre for London | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1701 | 1701 | member | Crossrail Art Foundation | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1702 | 1702 | member | London Councils Pensions Collective Investment Vehicle Joint Committee | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1703 | 1703 | member | International Business and Development Exchange | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1704 | 1704 | member | Court of the City University | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1705 | 1705 | member | Franco-British Council | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1706 | 1706 | member | Housing & Finance Institute | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1707 | 1707 | member | Homes for Londoners Board | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1708 | 1708 | member | City Music Foundation | Non-pecuniary interests e9002d25 | Sir Mark Boleat 136 |
1505 | 1505 | member | Friend of Guildhall Art Gallery | Non-pecuniary interests e9002d25 | David John Bradshaw 137 |
1506 | 1506 | partner | Friend of Guildhall Art Gallery | Non-pecuniary interests e9002d25 | David John Bradshaw 137 |
1507 | 1507 | member | Member - Cripplegate Ward Club | Non-pecuniary interests e9002d25 | David John Bradshaw 137 |
1508 | 1508 | partner | Member, Cripplegate Ward Club | Non-pecuniary interests e9002d25 | David John Bradshaw 137 |
1509 | 1509 | member | Institute of Marketing and Sales Management | Non-pecuniary interests e9002d25 | David John Bradshaw 137 |
1510 | 1510 | partner | Member, Aldersgate Ward Club | Non-pecuniary interests e9002d25 | David John Bradshaw 137 |
1511 | 1511 | partner | Member, Bishopsgate Ward Club | Non-pecuniary interests e9002d25 | David John Bradshaw 137 |
1512 | 1512 | partner | Member, United Wards Club | Non-pecuniary interests e9002d25 | David John Bradshaw 137 |
1513 | 1513 | partner | Member, Royal Society of St George (City Branch) | Non-pecuniary interests e9002d25 | David John Bradshaw 137 |
1514 | 1514 | partner | Member, City Livery Club | Non-pecuniary interests e9002d25 | David John Bradshaw 137 |
1515 | 1515 | partner | Livery Member, Coopers | Non-pecuniary interests e9002d25 | David John Bradshaw 137 |
144 | 144 | member | Trustee: Lord Mayor's 800th Anniversary Awards Trust | Non-pecuniary interests e9002d25 | John Bennett 139 |
145 | 145 | member | Trustee: Charity of Mary Barnes | Non-pecuniary interests e9002d25 | John Bennett 139 |
146 | 146 | member | Trustee: The F.E. Clearly St Margaret Lothbury Church Trust | Non-pecuniary interests e9002d25 | John Bennett 139 |
147 | 147 | member | Broad Street Ward Club | Non-pecuniary interests e9002d25 | John Bennett 139 |
148 | 148 | member | Worshipful Company of International Bankers Liveryman | Non-pecuniary interests e9002d25 | John Bennett 139 |
149 | 149 | member | Institute of Chartered Accountants in England and Wales | Non-pecuniary interests e9002d25 | John Bennett 139 |
150 | 150 | member | Chartered Institute of Securities and Investments | Non-pecuniary interests e9002d25 | John Bennett 139 |
151 | 151 | member | Chartered Management Institution | Non-pecuniary interests e9002d25 | John Bennett 139 |
152 | 152 | member | Institute of Directors | Non-pecuniary interests e9002d25 | John Bennett 139 |
1778 | 1778 | member | Chairman, Crossrail Arts Foundation | Non-pecuniary interests e9002d25 | Michael John Cassidy 141 |
1779 | 1779 | member | City of London Solicitors Company | Non-pecuniary interests e9002d25 | Michael John Cassidy 141 |
1780 | 1780 | member | Pastmaster Solicitors Livery Company | Non-pecuniary interests e9002d25 | Michael John Cassidy 141 |
1209 | 1209 | member | Lord Mayor's 800th Anniversary Awards Trust | Non-pecuniary interests e9002d25 | Simon D'Olier Duckworth 151 |
1210 | 1210 | member | City Pickwick Club | Non-pecuniary interests e9002d25 | Simon D'Olier Duckworth 151 |
1211 | 1211 | member | The Skinners' Company | Non-pecuniary interests e9002d25 | Simon D'Olier Duckworth 151 |
1212 | 1212 | member | The Worshipful Company of Parish Clerks | Non-pecuniary interests e9002d25 | Simon D'Olier Duckworth 151 |
1213 | 1213 | member | Reserve Forces' and Cadets' Association | Non-pecuniary interests e9002d25 | Simon D'Olier Duckworth 151 |
1214 | 1214 | member | Honorary Colonel - Royal Military Police | Non-pecuniary interests e9002d25 | Simon D'Olier Duckworth 151 |
1215 | 1215 | member | Masonic Charitable Foundation | Non-pecuniary interests e9002d25 | Simon D'Olier Duckworth 151 |
169 | 169 | member | Tower Ward Club | Non-pecuniary interests e9002d25 | Roger Arthur Holden Chadwick 158 |
170 | 170 | partner | Tower Ward Club | Non-pecuniary interests e9002d25 | Roger Arthur Holden Chadwick 158 |
171 | 171 | member | Freemason | Non-pecuniary interests e9002d25 | Roger Arthur Holden Chadwick 158 |
172 | 172 | member | Liveryman Worshipful Company of Bowyers | Non-pecuniary interests e9002d25 | Roger Arthur Holden Chadwick 158 |
173 | 173 | member | Liveryman Worshipful Company of World Traders | Non-pecuniary interests e9002d25 | Roger Arthur Holden Chadwick 158 |
174 | 174 | member | Member of the Guild Church of St Lawrence Jewry | Non-pecuniary interests e9002d25 | Roger Arthur Holden Chadwick 158 |
175 | 175 | member | Trustee of The Honourable The Irish Society | Non-pecuniary interests e9002d25 | Roger Arthur Holden Chadwick 158 |
176 | 176 | member | Honorary Treasurer of the Guild Church of St Lawrence Jewry | Non-pecuniary interests e9002d25 | Roger Arthur Holden Chadwick 158 |
177 | 177 | member | Chairman of Governors - City of London Freemen's School | Non-pecuniary interests e9002d25 | Roger Arthur Holden Chadwick 158 |
1499 | 1499 | member | Guildhall Club | Non-pecuniary interests e9002d25 | John Douglas Chapman 160 |
1500 | 1500 | member | Musicians Livery | Non-pecuniary interests e9002d25 | John Douglas Chapman 160 |
1501 | 1501 | member | Guild of entrepreneurs | Non-pecuniary interests e9002d25 | John Douglas Chapman 160 |
702 | 702 | member | Member, Change UK - The Independent Group | Non-pecuniary interests e9002d25 | Peter Gerard Dunphy 200 |
703 | 703 | member | Member, Lime Street and Cornhill Ward Club | Non-pecuniary interests e9002d25 | Peter Gerard Dunphy 200 |
704 | 704 | member | Member CAMRA | Non-pecuniary interests e9002d25 | Peter Gerard Dunphy 200 |
705 | 705 | member | Liveryman, Drapers’ Company | Non-pecuniary interests e9002d25 | Peter Gerard Dunphy 200 |
706 | 706 | member | Trustee, The Honourable The Irish Society | Non-pecuniary interests e9002d25 | Peter Gerard Dunphy 200 |
406 | 406 | member | Trustee, Seafarers UK (King George’s Fund for Sailors) | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
407 | 407 | member | Director and Trustee of the White Ensign Association | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
408 | 408 | member | Almoner and Director of Christ’s Hospital | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
409 | 409 | member | Trustee, St Paul’s Chorister Trust | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
410 | 410 | member | Trustee, Mansion House Scholarship Scheme | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
411 | 411 | member | President (not a Trustee) of the City of London Sea Cadets | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
412 | 412 | member | Patron, Ward of Cheap Club | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
413 | 413 | member | Liveryman of the Shipwrights, Goldsmiths, World Traders, Wheelwrights and Security Professionals Companies | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
414 | 414 | member | Member, Institute of Chartered Shipbrokers | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
415 | 415 | member | Younger Brother, Trinity House | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
416 | 416 | member | Chairman, Maritime UK | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
417 | 417 | member | Chairman Maritime London | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
418 | 418 | member | Currently chairing the government’s "Maritime Growth Study: keeping the UK competitive" | Non-pecuniary interests e9002d25 | The Lord Mountevans, Jeffrey Evans 207 |
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");