gifts
Data source: See col-scraper on GitHub
1 row where member_id = 1949 sorted by date_str
This data as json, CSV (advanced)
date (date) 1 ✖
Link | rowid | name | date_str ▼ | date | member_id |
---|---|---|---|---|---|
575 | 575 | Dinner at Mansion House (Canary Wharf Group) | 6th September 2018 | 2018-09-06 | Munsur Ali 1949 |
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");