home / colmem

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

2 rows where "date" is on date 2018-10-22

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ name date_str date member_id
68 68 Presentation Dinner for the Lord Mayor-Elect at Ironmonger's Hall 22nd October 2018 2018-10-22 Emma Edhem 1458
414 414 Presentation Dinner at Ironmongers Hall, together with wife. Hosted by the Worshipful Company of International Bankers and the Worshipful Company of Ironmongers. 22 Oct 2018 2018-10-22 Ian David Luder 296

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");
Powered by Datasette · Queries took 9.645ms · Data source: See col-scraper on GitHub