gifts
Data source: See col-scraper on GitHub
1 row where name = "Ticket and hospitality, Vitality Hockey Women’s World Cup at Lee Valley Hockey and Tennis Centre, Queen Elizabeth Olympic Park, London from the City of London Corporation"
This data as json, CSV (advanced)
name 1 ✖
- Ticket and hospitality, Vitality Hockey Women’s World Cup at Lee Valley Hockey and Tennis Centre, Queen Elizabeth Olympic Park, London from the City of London Corporation · 1 ✖
date (date) 1 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
427 | 427 | Ticket and hospitality, Vitality Hockey Women’s World Cup at Lee Valley Hockey and Tennis Centre, Queen Elizabeth Olympic Park, London from the City of London Corporation | 31 July 2018 | 2018-07-31 | Keith David Forbes Bottomley 1666 |
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");