gifts
Data source: See col-scraper on GitHub
3 rows where "date" is on date 2018-11-13
This data as json, CSV (advanced)
member_id 3 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
49 | 49 | Gresham Dinner - The Mercers' Company | 13 November 2018 | 2018-11-13 | Edward Lord 292 |
331 | 331 | The Worshipful Company of Mercers Gresham Dinner | 13 November 2018 | 2018-11-13 | Nicholas Michael Bensted-Smith 1472 |
416 | 416 | Mercer’s Company Gresham Dinner at Mercer’s Hall. | 13 November 2018 | 2018-11-13 | Ian David Luder 296 |
Advanced export
JSON shape: default, array, newline-delimited
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");