gifts
Data source: See col-scraper on GitHub
3 rows where member_id = 287
This data as json, CSV (advanced)
date (date) 1 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
491 | 491 | Cart Marking lunch (Worshipful Company of Carmen) | 15 July 2015 | 2015-07-15 | Vivienne Littlechild 287 |
492 | 492 | Private visit to the Tower of London Jewel House followed by dinner at Tower Bridge, accompanied by my husband (TMI conference) | 23rd November | Vivienne Littlechild 287 | |
493 | 493 | Drinks at Claridges (Land Securities) | 9th December | Vivienne Littlechild 287 |
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");