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

21 rows where member_id = 1260

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, date (date)

Link rowid ▼ name date_str date member_id
377 377 Guest at the Broderers' Company banquet 7th October 2015 2015-10-07 Timothy Russell Hailes 1260
378 378 Guest at Glass Sellers' Company banquet 12th October 2015 2015-10-12 Timothy Russell Hailes 1260
379 379 Guest at Business Faculty Dinner, Goodenough College 10th February 2016 2016-02-10 Timothy Russell Hailes 1260
380 380 Guest at banquet, Loriners Company 13th May 2016 2016-05-13 Timothy Russell Hailes 1260
381 381 Guest at banquet, Guild of Young Freemen 27th May 2016 2016-05-27 Timothy Russell Hailes 1260
382 382 Guest at banquet, Girdlers Company 9th June 2016 2016-06-09 Timothy Russell Hailes 1260
383 383 Guest at banquet, Young Presidents Organisation 9th September 2016 2016-09-09 Timothy Russell Hailes 1260
384 384 Guest at banquet, Guildable Manor of Southwark 15th September 2016 2016-09-15 Timothy Russell Hailes 1260
385 385 Guest at banquet, Plaisterers Company 4th October 2016 2016-10-04 Timothy Russell Hailes 1260
386 386 Guest at banquet, Marketors Company 22nd October 2016 2016-10-22 Timothy Russell Hailes 1260
387 387 Guest at banquet, Tobacco Pipe Makers Company 24th October 2016 2016-10-24 Timothy Russell Hailes 1260
388 388 Guest at banquet, Plaisterers Company 10th January 2017 2017-01-10 Timothy Russell Hailes 1260
389 389 Guest at banquet, Business Faculty Dinner, Goodenough College 8th February 2017 2017-02-08 Timothy Russell Hailes 1260
390 390 Guest at luncheon, Salters Company - 2nd March 2017 2017-03-02 Timothy Russell Hailes 1260
391 391 Dinner guest - C&C Alpha Group 23rd September 2017 2017-09-23 Timothy Russell Hailes 1260
392 392 Dinner guest - Worshipful Company of Security Professionals 21st September 2017 2017-09-21 Timothy Russell Hailes 1260
393 393 Dinner guest -The Honourable Society of the Middle and Inner Temple 25th September 2017 2017-09-25 Timothy Russell Hailes 1260
394 394 Dinner guest- The Worshipful Company of Mercers - Gresham 14 November 2017 2017-11-14 Timothy Russell Hailes 1260
395 395 Membership - Number Twenty client space, Grosvenor Street, London (KPMG) 28th March 2018 2018-03-28 Timothy Russell Hailes 1260
396 396 Dinner guest - Dr Chanchai of Reignwood, Ten Trinity Square. Two bottles of Chateau Siaurac pomerol wine received. 13th May 2018 2018-05-13 Timothy Russell Hailes 1260
397 397 Lunch - Senior Trade and Investment Commissioner, Austrade (Austrade) 7th August 2018 2018-08-07 Timothy Russell Hailes 1260

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