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

19 rows where member_id = 1218

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ name date_str date member_id
337 337 Invitation (with guest) to Supper at National Gallery marking Sir Stuart Lipton's 50 years' involvement in property. 13 June 2016 2016-06-13 Christopher Michael Hayward 1218
338 338 Invitation to Mischon de Reya Lunch with Sir Stuart Lipton 7 October 2016 2016-10-07 Christopher Michael Hayward 1218
339 339 Lunch at the Goring with Mike Hussey, Almacantar Ltd 29 November 2016 2016-11-29 Christopher Michael Hayward 1218
340 340 Hosted to dinner at 1 Lombard Street by the City Architecture Forum (Guest Speaker) 23 November 2016 2016-11-23 Christopher Michael Hayward 1218
341 341 Hosted breakfast at Guildhall by Gerald Eve Associates (Guest Speaker) 24th November 2016 2016-11-24 Christopher Michael Hayward 1218
342 342 Guest at lunch hosted by Richard Desmond (Northern & Shell plc) 12th June 2017 2017-06-12 Christopher Michael Hayward 1218
343 343 Lunch with the owners of Harry’s Bar and Restaurant, 5 Abchurch Yard, EC4N 7BA 17 July 2017 2017-07-17 Christopher Michael Hayward 1218
344 344 Dinner and gift of a leather travel wallet at the Guildhall for the C & C Alpha Group Limited (Guest Speaker) 23rd September 2017 2017-09-23 Christopher Michael Hayward 1218
345 345 Gresham Dinner, guest of the Mercers' Company 14 November 2017 2017-11-14 Christopher Michael Hayward 1218
346 346 Lunch - Richard Desmond (Northern & Shell PLC) 2nd February 2018 2018-02-02 Christopher Michael Hayward 1218
347 347 Lunch with Harrry Haddad, Harry’s Bar, Ironmonger Lane, EC2V 8EP 13 February 2018 2018-02-13 Christopher Michael Hayward 1218
348 348 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Christopher Michael Hayward 1218
349 349 Guest of KPMG at Dinner at Plage l'Ondine at MIPIM 13 March 2018 2018-03-13 Christopher Michael Hayward 1218
350 350 Guest of London Chamber of Commerce at a Presidents Lunch at MIPIM 14 March 2018 2018-03-14 Christopher Michael Hayward 1218
351 351 Guest of Christopher Moran Dinner at Crosby Hall 16 May 2018 2018-05-16 Christopher Michael Hayward 1218
352 352 Guest of Farebrother Chartered Surveyors, dinner at the RAC Club 3 September 2018 2018-09-03 Christopher Michael Hayward 1218
353 353 Guest of London and Oriental, lunch at The Ned 4 September 2018 2018-09-04 Christopher Michael Hayward 1218
354 354 Guest of City Property Association, lunch at The Coq D'argent 2 November 2018 2018-11-02 Christopher Michael Hayward 1218
355 355 Lunch with Chairman of Northern & Shell Plc 7 January 2019 2019-01-07 Christopher Michael Hayward 1218

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