gifts
Data source: See col-scraper on GitHub
3 rows where member_id = 1666
This data as json, CSV (advanced)
date (date) 3 ✖
- 2017-09-23 1
- 2018-05-12 1
- 2018-07-31 1
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
425 | 425 | Dinner and gift of a leather travel wallet at the Guildhall for the C & C Alpha Group Limited | 23 September 2017 | 2017-09-23 | Keith David Forbes Bottomley 1666 |
426 | 426 | Private dinner given by the Lord Mayor of Westminster at the In & Out Club | 12 May 2018 | 2018-05-12 | Keith David Forbes Bottomley 1666 |
427 | 427 | Ticket and hospitality, Vitality Hockey Women’s World Cup at Lee Valley Hockey and Tennis Centre, Queen Elizabeth Olympic Park, London from the City of London Corporation | 31 July 2018 | 2018-07-31 | Keith David Forbes Bottomley 1666 |
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");