gifts
Data source: See col-scraper on GitHub
4 rows where member_id = 158 and name = "Lunch Goodenough College"
This data as json, CSV (advanced)
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
106 | 106 | Lunch Goodenough College | 12/01/18 | Roger Arthur Holden Chadwick 158 | |
108 | 108 | Lunch Goodenough College | 26/01/18 | Roger Arthur Holden Chadwick 158 | |
109 | 109 | Lunch Goodenough College | 19/03/18 | Roger Arthur Holden Chadwick 158 | |
114 | 114 | Lunch Goodenough College | 27/06/18 | 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");