gifts
Data source: See col-scraper on GitHub
3 rows where member_id = 251
This data as json, CSV (advanced)
date (date) 2 ✖
- 2017-11-14 1
- 2018-02-22 1
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
56 | 56 | Date: Thursday 9th July 2015 Nature of Hospitality: Invitation to Garsington Opera and Dinner Received from: Ruffer LLP | Tom Hoffman 251 | ||
57 | 57 | The Worshipful Company of Mercers - Gresham Dinner | 14 November 2017 | 2017-11-14 | Tom Hoffman 251 |
58 | 58 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Tom Hoffman 251 |
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");