gifts
Data source: See col-scraper on GitHub
3 rows where member_id = 375
This data as json, CSV (advanced)
date (date) 3 ✖
- 2017-05-07 1
- 2018-02-22 1
- 2018-06-20 1
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
83 | 83 | Travel and accommodation costs to attend the Chengdu Innovation and Entrepreneurship Fair - Mayor of Chengdu | 7th - 15th May 2017 | 2017-05-07 | Wendy Mead 375 |
84 | 84 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Wendy Mead 375 |
85 | 85 | Two tickets to Cosi Fan Tuttee - Opera holland Park | 20 June 2018 | 2018-06-20 | Wendy Mead 375 |
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");