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

16 rows where member_id = 1458

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ name date_str date member_id
59 59 Drinks reception at Is Bank (hosted by CEO of Is Bank) - organsied by TBCCI 5th September 2018 2018-09-05 Emma Edhem 1458
60 60 Drinks reception at the House of lords for JETCO - organised by DIT and DEIK 11th September 2018 2018-09-11 Emma Edhem 1458
61 61 Tea at the House of Lords hosted by Baroness Verma and Baroness Ece 12th September 2018 2018-09-12 Emma Edhem 1458
62 62 No2H8 Crime Awards dinner - organised by Faith Matters/Tell Mama 13th September 2018 2018-09-13 Emma Edhem 1458
63 63 Installation of Master Farrier and dinner at Vintner's Hall (guest of Martin Dudley) 26th September 2018 2018-09-26 Emma Edhem 1458
64 64 Drinks reception and fair at Goldsmith's Hall - organised by the Goldsmiths 27th September 2018 2018-09-27 Emma Edhem 1458
65 65 Tea and Tour of the Chapel at Kensington Palace with Serena Richards 3rd october 2018 2018-10-03 Emma Edhem 1458
66 66 Drinks reception for the departure of inga Beale (CEO of Lloyds) at the Lloyds Building - hosted by Inga Beale and organised by Lloyds Market Place 4th October 2018 2018-10-04 Emma Edhem 1458
67 67 Tea with the Turkish Ambassador at the Turkish Embassy - hosted by the Ambassador 10th October 2018 2018-10-10 Emma Edhem 1458
68 68 Presentation Dinner for the Lord Mayor-Elect at Ironmonger's Hall 22nd October 2018 2018-10-22 Emma Edhem 1458
69 69 Drinks reception at the residence of the Turksih Ambassador - organised by the Turkish Embassy 29th October 2018 2018-10-29 Emma Edhem 1458
70 70 Diwali dinner at Drapers Hall hosted by Baroness Verma - organised by The Hinduja Foundation 30th October 2018 2018-10-30 Emma Edhem 1458
71 71 Drinks reception and debate at the residence of the Dutch Ambassador - organised by IBDE and hosted by the Dutch Ambassador 31st October 2018 2018-10-31 Emma Edhem 1458
72 72 Lunch at the House of Lords hosted by Lord Rana - organised by UK Asian Business Council & Overseas Friends of India 5th November 2018 2018-11-05 Emma Edhem 1458
73 73 Installation of Master City Livery - guest of Trevor Brignall 7th November 2018 2018-11-07 Emma Edhem 1458
74 74 Vin d’honneur at the Residence of the Turkish Ambassador upon presentation of his Credentials to HM the Queen 22nd November 2018 2018-11-22 Emma Edhem 1458

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