gifts

Gifts of Hospitality in the Register of Interests.

date_str is the date as supplied in the Register, and date is an attempt to create a year-month-day date from that string.

Data source: See col-scraper on GitHub

55 rows where member_id = 292

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ name date_str date member_id
1 1 Champagne reception and Dinner - Honourable Societies of the Inner Temple and Middle Temple 14 May 2015 2015-05-14 Edward Lord 292
2 2 Dinner - The Mercers Company 28 May 2015 2015-05-28 Edward Lord 292
3 3 Gala Dinner (for self plus partner) London LGBT Pride C.I.C. 24 June 2015 2015-06-24 Edward Lord 292
4 4 Director's Box ticket for West Ham United v Newcastle United - Greg Lawrence CC 14 September 2015 2015-09-14 Edward Lord 292
5 5 Banquet - Young Presidents' Organisation London Mayfair Chapter (Chair: Deputy Alistair King) 25 September 2015 2015-09-25 Edward Lord 292
6 6 Director's Box ticket and hospitality x2 for Manchester City Vs Newcastle United - City Football Group Limited 3 October 2015 2015-10-03 Edward Lord 292
7 7 Dinner - Young Presidents' Organisation London Mayfair Chapter 4 February 2016 2016-02-04 Edward Lord 292
8 8 Court Dinner - Grocers' Company (Guest of Henry Colthurst CC) 10 February 2016 2016-02-10 Edward Lord 292
9 9 Kuwait National Day Reception 25 February 2016 2016-02-25 Edward Lord 292
10 10 Bread Street Ward Club Dinner (Guest of Deputy Giles Shilson) 18 March 2016 2016-03-18 Edward Lord 292
11 11 Club Level Ticket & Hospitality - England Vs Netherlands (Guest of NHBC) 29 March 2016 2016-03-29 Edward Lord 292
12 12 Two Directors' box Tickets & Hospitality Manchester City Vs Arsenal (Guest of City Football Group Plc.) 8 May 2016 2016-05-08 Edward Lord 292
13 13 Associated Companies' Dinner (Guest of The Mercers' Company) 26 May 2016 2016-05-26 Edward Lord 292
14 14 Livery Dinner - The Tallow Chandlers' Company (Guest of Sophie Fernandes CC) 16 June 2016 2016-06-16 Edward Lord 292
15 15 Gala Dinner at Mansion House (Guest of London LGBT Community Pride C.I.C) 22 June 2016 2016-06-22 Edward Lord 292
16 16 Garden Party (with guest) - Middle Temple 5 July 2016 2016-07-05 Edward Lord 292
17 17 Albert Kennedy Trust Gala Dinner - Genesis Housing 13 October 2016 2016-10-13 Edward Lord 292
18 18 Directors' Box Ticket and Hospitality: Huddersfield Town v Birmingham City - Jason McCartney MP (Colne Valley) 5 November 2016 2016-11-05 Edward Lord 292
19 19 National Day Reception - HE The Ambassador of Kuwait 23 February 2017 2017-02-23 Edward Lord 292
20 20 Livery Dinner - The Haberdashers' Company 9 March 2017 2017-03-09 Edward Lord 292
21 21 Stonewall Equity Dinner - Philip Morris Limited 24 March 2017 2017-03-24 Edward Lord 292
22 22 VIP courtside ticket and hospitality - British Basketball League and Women’s British Basketball League Finals, O2 Arena – British Basketball Federation 14 May 2017 2017-05-14 Edward Lord 292
23 23 2 x Box tickets for Take That concert, O2 Arena – Grange Hotels Limited 11 June 2017 2017-06-11 Edward Lord 292
24 24 Garden Party (with guest) – Middle Temple 4 July 2017 2017-07-04 Edward Lord 292
25 25 Gala Dinner, Shakespeare’s Globe – London LGBT+ Community Pride C.I.C. 6 July 2017 2017-07-06 Edward Lord 292
26 26 VIP tickets and hospitality – IPC World Para Athletics World Championships, London Stadium – London 2017 Limited 21 July 2017 2017-07-21 Edward Lord 292
27 27 VIP hospitality – Great City Race – London Marathon Limited 24 July 2017 2017-07-24 Edward Lord 292
28 28 Reception and Tour, Westminster Abbey – London & Partners 28 July 2017 2017-07-28 Edward Lord 292
29 29 VIP hospitality (not taken) – Ride London, Mall – London Marathon Limited 29/30 July 2017 2017-07-29 Edward Lord 292
30 30 VIP ticket and hospitality – IAAF World Athletics Championships, London Stadium – London 2017 Limited 6 August 2017 2017-08-06 Edward Lord 292
31 31 VIP ticket and hospitality – IAAF World Athletics Championships, London Stadium – London 2017 Limited 11 August 2017 2017-08-11 Edward Lord 292
32 32 VIP tickets and hospitality – Great Britain v Greece, Copper Box – British Basketball Federation 19 August 2017 2017-08-19 Edward Lord 292
33 33 Gala Dinner - guest of Albert Kennedy Trust 19 October 2017 2017-10-19 Edward Lord 292
34 34 Walbrook Club Port Dinner - guest of Colin Hart JP 2 November 2017 2017-11-02 Edward Lord 292
35 35 Gresham Dinner - guest of the Mercers' Company 14 November 2017 2017-11-14 Edward Lord 292
36 36 Gresham Dinner - guest of the Mercers' Company 22 February 2018 2018-02-22 Edward Lord 292
37 37 Royal Box football ticket and hospitality - guest of Tottenham Hotspurs 28 February 2018 2018-02-28 Edward Lord 292
38 38 Hard copy book entitled "Legal Architecture" by Linda Mulcahy [value £110] given by the Subtreasurer of Inner Temple to Deputy Lord by virtue of his position as Deputy Chairmen of Capital Buildings Committee 16 March 2018 2018-03-16 Edward Lord 292
39 39 Mounted brass plaque from the Managing Director, The Cook & Butler Event Company Ltd. 26 March 2018 2018-03-26 Edward Lord 292
40 40 Livery Dinner - Haberdasher's Company 08 March 2018 2018-03-08 Edward Lord 292
41 41 Dinner - guest of Inner Temple 22 March 2018 2018-03-22 Edward Lord 292
42 42 Dinner for Christ's Hospital - Mercer's Company 2 May 2018 2018-05-02 Edward Lord 292
43 43 Dinner with Alderman & Sheriff Tim Hailes 10 May 2018 2018-05-10 Edward Lord 292
44 44 Dinner with Lord Mayor of Westminster 12 May 2018 2018-05-12 Edward Lord 292
45 45 Lunch with Reignwood Investments 13 May 2018 2018-05-13 Edward Lord 292
46 46 Dinner with Sir Brian Leveson/Liverpool John Moores University 16 May 2018 2018-05-16 Edward Lord 292
47 47 VIP courtside ticket and hospitality - British Basketball League and Women’s British Basketball League Play-Off Finals, O2 Arena 20 May 2018 2018-05-20 Edward Lord 292
48 48 VIP Wristband and hospitality – Manchester Pride 24-27 August 2018 2018-08-24 Edward Lord 292
49 49 Gresham Dinner - The Mercers' Company 13 November 2018 2018-11-13 Edward Lord 292
50 50 VIP ticket and hospitality – London New Years’ Parade 1 January 2019 2019-01-01 Edward Lord 292
51 51 Courtside seats – NBA London Game: Washington Wizards v New York Knicks 17 January 2019 2019-01-17 Edward Lord 292
52 52 Livery Dinner – Worshipful Company of Framework Knitters 18 January 2019 2019-01-18 Edward Lord 292
53 53 Australia Day Reception – High Commission of Australia 24 January 2019 2019-01-24 Edward Lord 292
54 54 National Day Reception (DECLINED) – Embassy of Kuwait 25 February 2019 2019-02-25 Edward Lord 292
55 55 Directors’ Box Tickets and hospitality: Celtic FC v Aberdeen FC 9 March 2019 2019-03-09 Edward Lord 292

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE gifts (
        name TEXT,
        date_str VARCHAR(50),
        date TEXT,
        member_id INTEGER REFERENCES members(id)
    );
CREATE INDEX gifts_date ON gifts("date");
CREATE INDEX gifts_member_id ON gifts("member_id");