gifts
Data source: See col-scraper on GitHub
4 rows where member_id = 158 and name = "Double invitation to LSO concert at the Barbican"
This data as json, CSV (advanced)
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
87 | 87 | Double invitation to LSO concert at the Barbican | 09/01/16 | Roger Arthur Holden Chadwick 158 | |
94 | 94 | Double invitation to LSO concert at the Barbican | 30/06/16 | Roger Arthur Holden Chadwick 158 | |
96 | 96 | Double invitation to LSO concert at the Barbican | 20/09/16 | Roger Arthur Holden Chadwick 158 | |
103 | 103 | Double invitation to LSO concert at the Barbican | 24/09/17 | Roger Arthur Holden Chadwick 158 |
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");