gifts
Data source: See col-scraper on GitHub
3 rows where "date" is on date 2019-01-09
This data as json, CSV (advanced)
Suggested facets: date_str
member_id 2 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
317 | 317 | Received two books from High Commissioner of India | 9 January 2019 | 2019-01-09 | Catherine McGuinness 373 |
318 | 318 | Received two tickets for Romeo and Juliet at the Barbican from Royal Shakespeare Company | 9 January 2019 | 2019-01-09 | Catherine McGuinness 373 |
443 | 443 | Guest for lunch of the Worshipful Company of Poulters | 9th January 2019 | 2019-01-09 | James Richard Tumbridge 394 |
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");