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_str = "22nd April"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ name date_str date member_id
185 185 Lunch with the Wardens of the Grocers Company 22nd April   The Lord Mountevans, Jeffrey Evans 207
186 186 Chancellors Dinner of City University at Mansion House 22nd April   The Lord Mountevans, Jeffrey Evans 207

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