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

10 rows where member_id = 1954

✎ View and edit SQL

This data as json, CSV (advanced)

member_id 1 ✖

  • Tijs Broeke · 10 ✖
Link rowid ▼ name date_str date member_id
362 362 Luncheon at the conclusion of the Trial of the Pyx (Worshipful Company of Goldsmiths) 28 April 2017 2017-04-28 Tijs Broeke 1954
363 363 Associated Companies Dinner (Worshipful Company of Mercers) 25 May 2017 2017-05-25 Tijs Broeke 1954
364 364 Dinner at Worshipful Company of Haberdashers 8 March 2018 2018-03-08 Tijs Broeke 1954
365 365 Saddlers’ Company lunch (with husband) 24 April 2018 2018-04-24 Tijs Broeke 1954
366 366 Goldsmiths’ Company lunch 27 April 2018 2018-04-27 Tijs Broeke 1954
367 367 Mercers’ Company dinner 24 May 2018 2018-05-24 Tijs Broeke 1954
368 368 Ticket plus guest ticket for morning session of Hockey World Cup (City of London Corporation) 22 July 2018 2018-07-22 Tijs Broeke 1954
369 369 London Planning Awards (guest of The Tenacity Group) 31 January 2019 2019-01-31 Tijs Broeke 1954
370 370 Dinner at Chartered Secretaries and Administrators’ Company 25 March 2019 2019-03-25 Tijs Broeke 1954
371 371 Lunch at Goldsmiths’ Company (Trial of the Pyx) 3 May 2019 2019-05-03 Tijs Broeke 1954

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