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

15 rows where "date" is on date 2018-02-22 and date_str = "22 February 2018"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name

date_str 1 ✖

  • 22 February 2018 · 15 ✖

date (date) 1 ✖

  • 2018-02-22 · 15 ✖
Link rowid ▼ name date_str date member_id
36 36 Gresham Dinner - guest of the Mercers' Company 22 February 2018 2018-02-22 Edward Lord 292
58 58 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Tom Hoffman 251
82 82 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 John Bennett 139
84 84 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Wendy Mead 375
161 161 Dinner, Worshipful Company of World Traders 22 February 2018 2018-02-22 Sheriff Vincent Thomas Keaveny 1395
217 217 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 John George Stewart Scott 401
232 232 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Sir David Hugh Wootton 397
291 291 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Catherine McGuinness 373
327 327 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Nicholas Michael Bensted-Smith 1472
333 333 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Jamie Ingham Clark 1223
348 348 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Christopher Michael Hayward 1218
419 419 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Simon D'Olier Duckworth 151
434 434 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Jeremy Mayhew 370
485 485 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Sir Mark Boleat 136
564 564 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Dr Giles Robert Evelyn Shilson 383

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