gifts
Data source: See col-scraper on GitHub
3 rows where "date" is on date 2018-02-28
This data as json, CSV (advanced)
Suggested facets: date_str, member_id, date (date)
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
37 | 37 | Royal Box football ticket and hospitality - guest of Tottenham Hotspurs | 28 February 2018 | 2018-02-28 | Edward Lord 292 |
76 | 76 | Bottle of alcohol and two small guide books to Belarus, received from the Ambassador of Belarus | February 2018 | 2018-02-28 | The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419 |
77 | 77 | Hanging mobile, received from the Chief Scientist of Israel | February 2018 | 2018-02-28 | The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419 |
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");