gifts
Data source: See col-scraper on GitHub
2 rows where "date" is on date 2015-10-12
This data as json, CSV (advanced)
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
378 | 378 | Guest at Glass Sellers' Company banquet | 12th October 2015 | 2015-10-12 | Timothy Russell Hailes 1260 |
400 | 400 | Wife attended Gibraltar Day at Guildhall. Hosted by HM government of Gibraltar. A reception. | 12 October 2015 | 2015-10-12 | Ian David Luder 296 |
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");