gifts
Data source: See col-scraper on GitHub
3 rows where "date" is on date 2017-05-25
This data as json, CSV (advanced)
date_str 2 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
363 | 363 | Associated Companies Dinner (Worshipful Company of Mercers) | 25 May 2017 | 2017-05-25 | Tijs Broeke 1954 |
437 | 437 | Concert and charity dinner at the Four Seasons Hotel London, 10 Trinity Square, London (Reignwood and Four Seasons) | 25th May 2017 | 2017-05-25 | Marianne Bernadette Fredericks 223 |
482 | 482 | Concert and Dinner with Reignwood | 25 May 2017 | 2017-05-25 | Sir Mark Boleat 136 |
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");