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

30 rows where member_id = 158

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name

Link rowid ▼ name date_str date member_id
86 86 In my capacity as Past Deputy Governor of the Honourable Irish Society and as the cuurent Chairman of the Co-operation Ireland GB Executive, I have regularly attended events hosted by Dr Christopher Moran both personally and in his role as Chairman of Co-operation Ireland, the cost of which in total, is likely to have exceeded the cumulative registration threshhold. 2016 - ongoing   Roger Arthur Holden Chadwick 158
87 87 Double invitation to LSO concert at the Barbican 09/01/16   Roger Arthur Holden Chadwick 158
88 88 Dinner, Ironmongers Company 02/02/16   Roger Arthur Holden Chadwick 158
89 89 Dinner, Clothworkers Company 08/03/16   Roger Arthur Holden Chadwick 158
90 90 Lunch Royal Sun Alliance 19/04/16   Roger Arthur Holden Chadwick 158
91 91 Dinner, Leathersellers Company 05/05/16   Roger Arthur Holden Chadwick 158
92 92 Address and dinner at Goodenough College 19/05/16   Roger Arthur Holden Chadwick 158
93 93 Dinner, Drapers Company 16/06/16   Roger Arthur Holden Chadwick 158
94 94 Double invitation to LSO concert at the Barbican 30/06/16   Roger Arthur Holden Chadwick 158
95 95 Dinner, Worshipful Company of Chartered Accountants 12/07/16   Roger Arthur Holden Chadwick 158
96 96 Double invitation to LSO concert at the Barbican 20/09/16   Roger Arthur Holden Chadwick 158
97 97 Double invitation to UK/Irish Economic Relations dinner 22/09/16   Roger Arthur Holden Chadwick 158
98 98 Civic Lunch - Corporation of Trinity House 09/11/16   Roger Arthur Holden Chadwick 158
99 99 Double invitation to Royal Shakespeare Company performance of King Lear at the Barbican Centre 16/12/16   Roger Arthur Holden Chadwick 158
100 100 Dinner, Clothworks Company 07/03/17   Roger Arthur Holden Chadwick 158
101 101 Lunch - London Councils 19/07/17   Roger Arthur Holden Chadwick 158
102 102 Sheriffs' Ball - Guildhall 15/09/17   Roger Arthur Holden Chadwick 158
103 103 Double invitation to LSO concert at the Barbican 24/09/17   Roger Arthur Holden Chadwick 158
104 104 Civic Lunch - Corporation of Trinity House 31/10/17   Roger Arthur Holden Chadwick 158
105 105 Faculty Dinner Goodenough College 22/11/17   Roger Arthur Holden Chadwick 158
106 106 Lunch Goodenough College 12/01/18   Roger Arthur Holden Chadwick 158
107 107 Double invitation to Royal Shakespeare Company performance of Julius Caeser at the Barbican Centre 15/01/18   Roger Arthur Holden Chadwick 158
108 108 Lunch Goodenough College 26/01/18   Roger Arthur Holden Chadwick 158
109 109 Lunch Goodenough College 19/03/18   Roger Arthur Holden Chadwick 158
110 110 Court Lunch - Corporation of Trinity House 20/03/18   Roger Arthur Holden Chadwick 158
111 111 Membership of Ten Trinity Square Private Club 21/03/18   Roger Arthur Holden Chadwick 158
112 112 Opera Tickets (2) Goodenough College 24/04/18   Roger Arthur Holden Chadwick 158
113 113 RIBA Awards Ceremony/Dinner - Hawkins Brown 17/05/18   Roger Arthur Holden Chadwick 158
114 114 Lunch Goodenough College 27/06/18   Roger Arthur Holden Chadwick 158
115 115 Construction News Awards Ceremony/Dinner - Gilbert Ash 12/07/18   Roger Arthur Holden Chadwick 158

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