gifts
Data source: See col-scraper on GitHub
2 rows where "date" is on date 2017-12-19 sorted by member_id
This data as json, CSV (advanced)
Link | rowid | name | date_str | date | member_id ▼ |
---|---|---|---|---|---|
283 | 283 | Guest of Kings College (Tony Halmos) for lunch | 19 December 2017 | 2017-12-19 | Catherine McGuinness 373 |
180 | 180 | Christmas a 75cl bottle of Canti Prosecco from Spice Innovations Limited | 19th December 2017 | 2017-12-19 | Dhruv Patel 1224 |
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");