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

40 rows where member_id = 229

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ name date_str date member_id
523 523 Upholders' Banquet at Carpenters' Hall. 9 April 2015 2015-04-09 Alison Gowman 229
524 524 Six tickets for Guildhall School of Music and Drama Gold medal concert at Barbican with drinks at interval and end. 13 May 2015 2015-05-13 Alison Gowman 229
525 525 Single invitation to evensong at Temple Church; reception at Middle Temple Hall and dinner at Inner Temple Hall as a combined invitation from the Treasurers of Inner and Middle Temple. 14 May 2015 2015-05-14 Alison Gowman 229
526 526 Seminar about Charitable Trustees' responsibilities at Cazenove - morning seminar with coffee and buffet lunch. 21 May 2015 2015-05-21 Alison Gowman 229
527 527 Magna Carta celebrations - morning of entertainment, picnic lunch at Runnymede Surrey County Council. 15 June 2015 2015-06-15 Alison Gowman 229
528 528 Innholders' Livery 500th anniversary banquet in Guildhall for 2 people 16 June 2015 2015-06-16 Alison Gowman 229
529 529 City of London Police Gala Awards dinner at Grange Hotel 19 June 2015 2015-06-19 Alison Gowman 229
530 530 Dinner in celebration of Eid. Invited by the Association of Muslim Police and the City of London Corporation. 31 July 2015 2015-07-31 Alison Gowman 229
531 531 Attended a Medieval Mumming followed by drinks reception - Skinners' Livery Company 14 September 2015 2015-09-14 Alison Gowman 229
532 532 Attended Prince's Trust afternoon tea at the Ritz (as Deputy Chairman of City Bridge Trust) 17 September 2015 2015-09-17 Alison Gowman 229
533 533 Invited by and attended London Symphony Orchestra concert at the Barbican with interval reception for 2 people 21 September 2015 2015-09-21 Alison Gowman 229
534 534 Invited by Sheriffs Alderman Charles Bowman and Christine Rigden to Sheriffs' breakfast at Drapers' Hall 28 September 2015 2015-09-28 Alison Gowman 229
535 535 Guest of the Hamburg Chamber of Commerce at dinner, lunch and dinner to celebrate historic links between City and Hamburg. This includes two nights' accommodation at Atlantic Kempinski Hotel. 14/15 October 2015 2015-10-14 Alison Gowman 229
536 536 Invited by and attended lunch with London Youth at Buckingham Palace (as Deputy Chairman of City Bridge Trust). 22 October 2015 2015-10-22 Alison Gowman 229
537 537 Dinner at Wax Chandlers' Hall hosted by Worshipful Company of Wheelwrights (speaking engagement) 13 November 2015 2015-11-13 Alison Gowman 229
538 538 Lunch at Two Temple Place hosted by Morgan Stanley 16 November 2015 2015-11-16 Alison Gowman 229
539 539 Prince's Trust Celebrate Success celebration at Milton Court 2 December 2015 2015-12-02 Alison Gowman 229
540 540 Barbican Centre two tickets to see Henry V at Barbican Theatre 4 December 2015 2015-12-04 Alison Gowman 229
541 541 Dinner with Turners' Livery Company 16 December 2015 2015-12-16 Alison Gowman 229
542 542 Dinner with the Management Consultants' Livery Company 20 January 2016 2016-01-20 Alison Gowman 229
543 543 Tacitus Lecture and reception as guest of the World Traders' Livery company 25 February 2016 2016-02-25 Alison Gowman 229
544 544 Dinner with Haberdashers at invite of Past Master Haberdasher 3 March 2016 2016-03-03 Alison Gowman 229
545 545 Presentation ceremony at London Palladium at invite of Prince's Trust 7 March 2016 2016-03-07 Alison Gowman 229
546 546 Dinner with Apothecaries at invite of Past Master Apothecary 17 March 2016 2016-03-17 Alison Gowman 229
547 547 Single invite to Woolmen's Livery Banquet at Ironmongers' Hall 23 May 2016 2016-05-23 Alison Gowman 229
548 548 Dinner to celebrate Eid in the City invite by Muslim Police Association 20 July 2016 2016-07-20 Alison Gowman 229
549 549 Dinner with the Hackney Carriage Drivers Livery Company 7 September 2016 2016-09-07 Alison Gowman 229
550 550 River trip with lunch on Lady Daphne in the River Sailing Barges Parade invite by Alderman and Mrs Michael Mainelli and Z/Yen 17 September 2016 2016-09-17 Alison Gowman 229
551 551 Guest of the Hamburg Chamber of Commerce Morgensprache Dinner, lunch and dinner with gifts of book and beer glass 12-14 October 2016 2016-10-12 Alison Gowman 229
552 552 Guest of Arts Scholars Livery Company to company lecture and reception 20 October 2016 2016-10-20 Alison Gowman 229
553 553 Guest of Christopher Moran, Co-operation Ireland to dinner at Crosby Hall 24 October 2016 2016-10-24 Alison Gowman 229
554 554 Reception given by First Aid Nursing Yeomanry at Lincoln's Inn 23 November 2016 2016-11-23 Alison Gowman 229
555 555 2 tickets to King Lear at the Barbican by the Barbican Centre 6 December 2016 2016-12-06 Alison Gowman 229
556 556 Fanmakers Livery Banquet at the Mansion House 8 December 2016 2016-12-08 Alison Gowman 229
557 557 Turners Livery Company dinner at Skinners' Hall 19 December 2016 2016-12-19 Alison Gowman 229
558 558 Dinner with Dyers' Livery Company 5 January 2017 2017-01-05 Alison Gowman 229
559 559 Dinner with the Information Technology Livery Company 18 January 2017 2017-01-18 Alison Gowman 229
560 560 Dinner at Goodenough College 8 March 2017 2017-03-08 Alison Gowman 229
561 561 Dinner with Cordwainers Livery Company at Clothworkers' Hall 10 March 2017 2017-03-10 Alison Gowman 229
562 562 Presentation and lunch with the Plumbers' Livery company 19 April 2017 2017-04-19 Alison Gowman 229

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