gifts
Data source: See col-scraper on GitHub
3 rows where "date" is on date 2018-04-27
This data as json, CSV (advanced)
Suggested facets: name
member_id 3 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
296 | 296 | Guest of London and Partners at Promotion of London Lunch | 27 April 2018 | 2018-04-27 | Catherine McGuinness 373 |
329 | 329 | Goldsmiths’ Company lunch | 27 April 2018 | 2018-04-27 | Nicholas Michael Bensted-Smith 1472 |
366 | 366 | Goldsmiths’ Company lunch | 27 April 2018 | 2018-04-27 | Tijs Broeke 1954 |
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");