gifts
Data source: See col-scraper on GitHub
2 rows where "date" is on date 2015-11-30
This data as json, CSV (advanced)
member_id 2 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
202 | 202 | Royal Shakespeare Company - two tickets to Henry V and a Reception for my wife and myself | 30 November 2015 | 2015-11-30 | John George Stewart Scott 401 |
441 | 441 | Two tickets from the RSC for the performance of Henry V at the Barbican Theatre | 30th November 2015 | 2015-11-30 | Joyce Carruthers Nash 382 |
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");