gifts
Data source: See col-scraper on GitHub
3 rows where date_str = "" and member_id = 401
This data as json, CSV (advanced)
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
192 | 192 | Invitation to the Chopin Society Gala Dinner at Guildhall | John George Stewart Scott 401 | ||
193 | 193 | Double invitation to the Savoy for the Fresh Produce Consortium Dinner from Spitalfields Market Tenants' Association. £200. | John George Stewart Scott 401 | ||
194 | 194 | Two tickets to LSO Concert with Reception from LSO. £60. | John George Stewart Scott 401 |
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");