gifts
Data source: See col-scraper on GitHub
2 rows where "date" is on date 2016-06-22 sorted by member_id
This data as json, CSV (advanced)
Link | rowid | name | date_str | date | member_id ▼ |
---|---|---|---|---|---|
467 | 467 | Michael Bloomberg - Double Invitation, Reception and Dinner at Tate Modern | 22 June 2016 | 2016-06-22 | Sir Mark Boleat 136 |
15 | 15 | Gala Dinner at Mansion House (Guest of London LGBT Community Pride C.I.C) | 22 June 2016 | 2016-06-22 | Edward Lord 292 |
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");