colmem

Data source: See col-scraper on GitHub

Custom SQL query returning 101 rows (hide)

This data as json, CSV

rowidkindnamecategory_idmember_id
1874 member Labour Party e9002d25 1949
1873 member Trustee - Positive Action Through Creativity e9002d25 1949
1872 member Director - Epic Media Wedding Productions Ltd. e938d3aa 1949
1871 member Director - Shongram Motion Pictures Ltd. e938d3aa 1949
1870 member Director - Kool Cats Consultancy Ltd. e938d3aa 1949
1869 member New Era Foundation e9002d25 213
1868 member Member, Candlewick Ward Club e9002d25 213
1867 member Freemason e9002d25 213
1866 member Member, Royal Society of St. George, City of London Branch e9002d25 213
1865 member Trustee, Aldgate and Allhallows Foundation e9002d25 213
1864 member Liveryman, Worshipful Company of Fletchers e9002d25 213
1863 member Liverymen, Worshipful Company of Educators e9002d25 213
1862 partner City University e938d3aa 213
1861 member Business/Education Consultant e938d3aa 213
1860 member Liveryman, Worshipful Company of Masons e9002d25 1226
1859 member Member - Financial Advisory Board GLRFCA e9002d25 1226
1858 member Member, The Law Society of Republic of Ireland e9002d25 1226
1857 member Member, The Law Society of Northern Ireland e9002d25 1226
1856 member Member, The Law Society of England and Wales e9002d25 1226
1855 member Member, Conservative Party e9002d25 1226
1854 member Liveryman, Goldsmith's Company e9002d25 1226
1853 member Turstee, John Marshall's Charity e9002d25 1226
1852 member Member, Ward of Cheap Club e9002d25 1226
1851 member Leasehold Interest at 165 Fleet Street as a Member of Memery Crystal LLP. d9df90d8 1226
1850 member Non-Executive Director, Civitas Social Housing Plc e938d3aa 1226
1849 member BOARD AVISOR, TOBIN (UK) LIMITED e938d3aa 1226
1848 member TA OFFICER, MINISTRY OF DEFENCE e938d3aa 1226
1847 partner Programme Director, University of The Arts, 272 High Holborn, London. WC1V 7EY e938d3aa 1226
1846 member Member - MEMERY CRYSTAL LLP, 44 SOUTHAMPTON BUILDINGS, LONDON, WC2A 1AP e938d3aa 1226
1845 member Company Member and Trustee - City of London Academies Trust e9002d25 1230
1844 member Court Assistant - Worshipful Company of Cordwainers e9002d25 1230
1843 member Member, Farringdon Ward Club e9002d25 1230
1842 partner Flat 1, 43 Bartholomew Close, EC1A 7HN d9df90d8 1230
1841 member Flat 1, 43 Bartholomew Close, EC1A 7HN d9df90d8 1230
1840 partner Self employed Partnership Consultant (sole trader) e938d3aa 1230
1839 member Self employed Management Consultant (sole trader) e938d3aa 1230
1838 member Vice Chair, Gresham College Council e9002d25 383
1837 member Past Chairman, Bread Street Ward Club e9002d25 383
1836 member Trustee, Letchworth Memorial Fund e9002d25 383
1835 member Priory Esquire, Most Venerable Order of the Hospital of St John of Jerusalem e9002d25 383
1834 member Member, Royal Institute of International Affairs (Chatham House) e9002d25 383
1833 member Member, Oxford Union Society e9002d25 383
1832 member Member, Order of St John London Priory Group e9002d25 383
1831 member Member, Joint Grand Gresham Committee e9002d25 383
1830 member Member, Honourable Society of the Middle Temple e9002d25 383
1829 member Member, Grand Charity e9002d25 383
1828 member Member, Friends of Blaise e9002d25 383
1827 member Liveryman, Worshipful Company of Ironmongers e9002d25 383
1826 member Direcctor, Gresham College e9002d25 383
1825 member Court Member, City University e9002d25 383
1824 member Past Chairman, City of London School e9002d25 383
1823 member Chairman, Barbican Centre e9002d25 383
1822 member Associate Member, Glyndebourne Festival Society e9002d25 383
1821 member Ironmongers' Hall, Shaftesbury Place, London, EC2 613aec30 383
1820 member Ironmongers' Hall, Shaftesbury Place, London, EC2 d9df90d8 383
1819 member Director, Ten Duke Street Limited e938d3aa 383
1818 member Chief Executive, Ancient & Accepted Rite, Duke Street St James's, London, SW1 e938d3aa 383
1817 member Associate Director, Indie Books, Staple Inn, London WC1 e938d3aa 383
1816 partner Implementation Director, Codwellers.com Limited, London, SW1 e938d3aa 383
1815 member Director of the Museum of London Archaeology Board e9002d25 229
1814 member Governor of the Museum of London e9002d25 229
1813 member Director of Romney Tweed CIC e9002d25 229
1812 member Trustee of the Lord Mayor's 800th Anniversary Awards Trust e9002d25 229
1811 member Patron and member of the Vintry and Dowgate Wards Club e9002d25 229
1810 member Council Member Royal Society of St George e9002d25 229
1809 member Member/ Past President City Livery Club e9002d25 229
1808 member Trustee of Van Mildert College Trust e9002d25 229
1807 member Trustee of the Aldersgate Flame e9002d25 229
1806 member Justice of the Peace, Central London Magistrates Court e9002d25 229
1805 member Member of Methodist Church e9002d25 229
1804 member Liveryman of Solicitors Livery Company e9002d25 229
1803 member Liveryman of the Worshipful Company of Plaisterers e9002d25 229
1802 member Liveryman of Worshipful Company of Glovers of London e9002d25 229
1801 member Member of Law Society of England and Wales e9002d25 229
1800 member London Wall, London EC2 (DLA Piper) 8948e857 229
1799 member Noble Street, London EC2 (DLA Piper) 8948e857 229
1798 member Storage space, Shakespeare Tower, Barbican, London EC2 d9df90d8 229
1797 member Car parking space, Defoe House, Barbican, London EC2 d9df90d8 229
1796 member Property at Shakespeare Tower, Barbican, London EC2 d9df90d8 229
1795 member Consultant (solicitor) in DLA Piper UK LLP, 3 Noble Street, London EC2V 7EE e938d3aa 229
1794 member Member, Old Castlemen's Society e9002d25 291
1793 member Member, the Queen's Royal Hussars Old Comrades' Association e9002d25 291
1792 member Member, Garrick Club e9002d25 291
1791 member Member, Guildhall Lodge e9002d25 291
1790 member Member, Worshipful Company of Pewterers e9002d25 291
1789 member Member, United Grand Lodge of England e9002d25 291
1788 member Member, Bread Street Ward Club e9002d25 291
1787 partner Member, Worshipful Company of Skinners e9002d25 291
1786 member Chairman of Trustee of Seahorse Trust (charitable trust connected to the Worshipful Company of Pewterers) e9002d25 291
1785 partner Member of Skinners' Company which owns Skinners' Hall, Dowgate and other City Properties d9df90d8 291
1784 member Member of Pewterers' Company which owns Pewterers Hall and other City Properties d9df90d8 291
1783 partner Employee, Universal Aunts, Talfourd Road, SE15 e938d3aa 291
1782 partner Secretary, OWL Regulatory Consulting Ltd, Nimrod Road, SW16 e938d3aa 291
1781 member Director, OWL Regulatory Consulting Ltd, Nimrod Road, SW16 e938d3aa 291
1780 member Pastmaster Solicitors Livery Company e9002d25 141
1779 member City of London Solicitors Company e9002d25 141
1778 member Chairman, Crossrail Arts Foundation e9002d25 141
1777 partner 202 Cromwell Tower, Barbican, EC2 d9df90d8 141
1776 member 202 Cromwell Tower, Barbican, EC2 d9df90d8 141
1775 member Chairman, Ebbsfleet UDC e938d3aa 141
1774 member Chairman, Askonas Holt Ltd e938d3aa 141