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

26 rows where member_id = 401

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date_str, date (date)

Link rowid ▼ name date_str date member_id
192 192 Invitation to the Chopin Society Gala Dinner at Guildhall     John George Stewart Scott 401
193 193 Double invitation to the Savoy for the Fresh Produce Consortium Dinner from Spitalfields Market Tenants' Association. £200.     John George Stewart Scott 401
194 194 Two tickets to LSO Concert with Reception from LSO. £60.     John George Stewart Scott 401
195 195 Reception and concert from Spitalfields Festival 10 June 2015 2015-06-10 John George Stewart Scott 401
196 196 Reception at the Italian Embassy 2 June 2015 2015-06-02 John George Stewart Scott 401
197 197 Reception at the Russian Embassy 12 June 2015 2015-06-12 John George Stewart Scott 401
198 198 Guests of the Latvian Ambassador at a reception and concert. 18 June 2015 2015-06-18 John George Stewart Scott 401
199 199 Court Dinner, Carpenters’ Company 21 July 2015 2015-07-21 John George Stewart Scott 401
200 200 Gresham Dinner 10 November 2015 2015-11-10 John George Stewart Scott 401
201 201 Poulters Company Dinner 4 November 2015 2015-11-04 John George Stewart Scott 401
202 202 Royal Shakespeare Company - two tickets to Henry V and a Reception for my wife and myself 30 November 2015 2015-11-30 John George Stewart Scott 401
203 203 Reception, Dinner and accommodation at Leeds Castle from The Royal Navy & Royal Marines Children's Fund 20th - 21st May 2016 2016-05-20 John George Stewart Scott 401
204 204 The Patron’s Lunch, The Mall from The Royal Navy & Royal Marines Children's Fund 12th June 2016 2016-06-12 John George Stewart Scott 401
205 205 Reception - Royal Mail Group 6th September 2016 2016-09-06 John George Stewart Scott 401
206 206 Reception and Concert - LSO 20th September 2016 2016-09-20 John George Stewart Scott 401
207 207 Invitation to attend a Reception at the residence of His Excellency the Ambassador of the Russian Federation, for my wife and myself. 8th November 2016 2016-11-08 John George Stewart Scott 401
208 208 The Worshipful Company of Poulters Court Dinner at the House of Lords 25th November 2016 2016-11-25 John George Stewart Scott 401
209 209 Dinner at the Caledonian Club given by Scotscare 30th November 2016 2016-11-30 John George Stewart Scott 401
210 210 London Schools Symphony Orchestra concert at the Barbican 5 January 2017 2017-01-05 John George Stewart Scott 401
211 211 Dinner at the Worshipful Company of Fishmongers 1 March 2017 2017-03-01 John George Stewart Scott 401
212 212 Dinner at The Worshipful Company of Cooks, Wednesday 10th May 2017. 10 May 2017 2017-05-10 John George Stewart Scott 401
213 213 Reception at the House of Lords, University of Stirling, 11 May 2017 2017-05-11 John George Stewart Scott 401
214 214 Reception at the residence of the Ambassador of the Russian Federation for my wife and myself. 13 June 2017 2017-06-13 John George Stewart Scott 401
215 215 Reception at The Postal Museum for my wife and myself 28 June 2017 2017-06-28 John George Stewart Scott 401
216 216 The Worshipful Company of Mercers - Gresham Dinner 14 November 2017 2017-11-14 John George Stewart Scott 401
217 217 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 John George Stewart Scott 401

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