gifts
Data source: See col-scraper on GitHub
3 rows where "date" is on date 2015-10-15
This data as json, CSV (advanced)
member_id 3 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
125 | 125 | Dinner, Worshipful Company of Marketors | 15 October 2015 | 2015-10-15 | Sheriff Vincent Thomas Keaveny 1395 |
221 | 221 | Dinner, Association of Financial Markets in Europe | 15 October 2015 | 2015-10-15 | Sir David Hugh Wootton 397 |
453 | 453 | Dinner, Association of Financial Markets in Europe. | 15 October 2015 | 2015-10-15 | 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");