gifts
Data source: See col-scraper on GitHub
1 row where name = "Received Scotch Whisky from the Briefing Circle as a thank you for being the keynote speaker"
This data as json, CSV (advanced)
name 1 ✖
- Received Scotch Whisky from the Briefing Circle as a thank you for being the keynote speaker · 1 ✖
date (date) 1 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
300 | 300 | Received Scotch Whisky from the Briefing Circle as a thank you for being the keynote speaker | 19 September 2018 | 2018-09-19 | Catherine McGuinness 373 |
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");