gifts
Data source: See col-scraper on GitHub
3 rows where member_id = 385
This data as json, CSV (advanced)
date (date) 3 ✖
- 2015-09-14 1
- 2015-10-08 1
- 2016-04-22 1
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
420 | 420 | Lunch with David Landsman | 14th September 2015 | 2015-09-14 | Sir Michael Snyder 385 |
421 | 421 | Lunch with the Indian High Commissioner | 8th October 2015 | 2015-10-08 | Sir Michael Snyder 385 |
422 | 422 | Lunch with Gerald Ronson at his office | 22nd April 2016 | 2016-04-22 | Sir Michael Snyder 385 |
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");