gifts
Data source: See col-scraper on GitHub
3 rows where "date" is on date 2017-05-10
This data as json, CSV (advanced)
member_id 3 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
140 | 140 | Dinner, Worshipful Company of Cooks (guest of Mark Grove), | 10 May 2017 | 2017-05-10 | Sheriff Vincent Thomas Keaveny 1395 |
212 | 212 | Dinner at The Worshipful Company of Cooks, Wednesday 10th May 2017. | 10 May 2017 | 2017-05-10 | John George Stewart Scott 401 |
481 | 481 | Dinner: Reignwood | 10 May 2017 | 2017-05-10 | 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");