gifts
Data source: See col-scraper on GitHub
2 rows where member_id = 1658
This data as json, CSV (advanced)
date (date) 2 ✖
- 2017-09-21 1
- 2018-03-07 1
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
233 | 233 | Installation dinner of the Master of the Worshipful Company of Tax Advisers | Thursday 21 September 2017 | 2017-09-21 | James de Sausmarez 1658 |
234 | 234 | Annual Budget Banquet - Worshipful Company of Tax Advisers | 7 March 2018 | 2018-03-07 | James de Sausmarez 1658 |
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");