interests

Interests for members and their partners ('Spouse/Civil Partner/Living as such') from the Register of Interests.

Data source: See col-scraper on GitHub

31 rows where member_id = 1220

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
1268 1268 member Barrister, in independent practice at the bar within the Chambers of Andrew Tait QC, FTB, Francis Taylor Building, Temple. Employment, office, trade, profession or vocation e938d3aa Gregory Jones QC 1220
1269 1269 partner Rosali Pretorius – Equity Partner (from February 2017) in Simmons & Simmons, City Point One, Ropemaker Street London EC2Y 9SS Employment, office, trade, profession or vocation e938d3aa Gregory Jones QC 1220
1270 1270 member Tenant barrister in Francis Taylor Building, Temple. EC4Y 7BY Land d9df90d8 Gregory Jones QC 1220
1271 1271 member A Liveryman of the Worshipful Company of Leathersellers' - owner of land in and around St Helen's Bishopsgate. Land d9df90d8 Gregory Jones QC 1220
1272 1272 member A Liveryman of the Worshipful Company of Butchers - owner of Hall at 87 Bartholomew Close, London. EC1A 7EB Land d9df90d8 Gregory Jones QC 1220
1273 1273 member Shares in BP, Barclays, BT and Lloyds Securities 4bd97394 Gregory Jones QC 1220
1274 1274 member Ecclesiastical Law Society Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1275 1275 member Ecclesiastical Law Judge's Association Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1276 1276 member Non-Executive Director, GAIA RE DEVELOPERS LIMITED (Company number 10938345) Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1277 1277 member Guild Church Council of St Lawrence Jewry Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1278 1278 member Bexleyheath & Crayford Conservative Association Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1279 1279 member UK Environmental Law Association Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1280 1280 member Planning & Environment Bar Association Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1281 1281 member Constiutional & Administrative Law Bar Association Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1282 1282 member The European Circuit Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1283 1283 member House Council of St Stephen’s House, Oxford University and Trustee of the Society of St Stephen’s House Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1284 1284 member Hon Soc.s of Lincoln's Inn and Inner Temple Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1285 1285 member King's Inns, Dublin Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1286 1286 member The Inn of Court of Northern Ireland Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1287 1287 member Fellow of the Royal Geographical Society Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1288 1288 member Fellow of the Royal Society of Arts Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1289 1289 member Fellow of the Institute of Quarrying Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1290 1290 member Legal Associate of the RTPI Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1291 1291 member Associate of the RIBA Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1292 1292 member Hon. President Old Colfeian Association Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1293 1293 member Associate School Governor, Leathersellers' Federation of Schools, Lewisham (Registered charity) Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1294 1294 member Life Member and Joint Patron Farringdon Ward Club Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1295 1295 member The European Bar Association Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1296 1296 member Fellow of the Linnean Society of London Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1297 1297 member Freemason Grand Charity (Registered charity) Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1298 1298 member Temple & Farringdon Together - Member Non-pecuniary interests e9002d25 Gregory Jones QC 1220

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");