gifts
Data source: See col-scraper on GitHub
575 rows sorted by member_id descending
This data as json, CSV (advanced)
Link | rowid | name | date_str | date | member_id ▲ |
---|---|---|---|---|---|
123 | 123 | Dinner, Worshipful Company of Founders | 27 July 2015 | 2015-07-27 | Sheriff Vincent Thomas Keaveny 1395 |
124 | 124 | Dinner, Society of Young Freemen | 30 July 2015 | 2015-07-30 | Sheriff Vincent Thomas Keaveny 1395 |
125 | 125 | Dinner, Worshipful Company of Marketors | 15 October 2015 | 2015-10-15 | Sheriff Vincent Thomas Keaveny 1395 |
126 | 126 | Dinner (with a guest), Guildable Manor of Southwark | 10 September 2015 | 2015-09-10 | Sheriff Vincent Thomas Keaveny 1395 |
127 | 127 | Dinner (with a guest), Onassis Foundation/Cass Business School | 14 September 2015 | 2015-09-14 | Sheriff Vincent Thomas Keaveny 1395 |
128 | 128 | Lunch, Worshipful Company of Spectacle Makers | 8 December 2015 | 2015-12-08 | Sheriff Vincent Thomas Keaveny 1395 |
129 | 129 | Dinner, Young Presidents' Organisation | 25 September 2015 | 2015-09-25 | Sheriff Vincent Thomas Keaveny 1395 |
130 | 130 | Dinner, Worshipful Company of Distillers | 19 November 2015 | 2015-11-19 | Sheriff Vincent Thomas Keaveny 1395 |
131 | 131 | Dinner, Chairmen's Forum | 11 November 2015 | 2015-11-11 | Sheriff Vincent Thomas Keaveny 1395 |
132 | 132 | Dinner, Worshipful Company of Information Technologists, | 20 January 2016 | 2016-01-20 | Sheriff Vincent Thomas Keaveny 1395 |
133 | 133 | Lunch, Worshipful Company of Distillers | 4 February 2016 | 2016-02-04 | Sheriff Vincent Thomas Keaveny 1395 |
134 | 134 | Lunch (invitation to Mrs Keaveny), Worshipful Company of Founders | 25 April 2016 | 2016-04-25 | Sheriff Vincent Thomas Keaveny 1395 |
135 | 135 | Dinner, Worshipful Society of Apothecaries | 19 May 2016 | 2016-05-19 | Sheriff Vincent Thomas Keaveny 1395 |
136 | 136 | Lunch, Worshipful Company of Farmers | 19 September 2016 | 2016-09-19 | Sheriff Vincent Thomas Keaveny 1395 |
137 | 137 | Lunch, Worshipful Company of Spectacle Makers | 6 December 2016 | 2016-12-06 | Sheriff Vincent Thomas Keaveny 1395 |
138 | 138 | Court Dinner, Worshipful Company of Drapers (guest of Nick Bence-Trower), | 15 February 2017 | 2017-02-15 | Sheriff Vincent Thomas Keaveny 1395 |
139 | 139 | Worshipful Company of Information Technologists' 25th Anniversary Banquet, | 4 May 2017 | 2017-05-04 | Sheriff Vincent Thomas Keaveny 1395 |
140 | 140 | Dinner, Worshipful Company of Cooks (guest of Mark Grove), | 10 May 2017 | 2017-05-10 | Sheriff Vincent Thomas Keaveny 1395 |
141 | 141 | Dinner, Worshipful Society of Apothecaries | 16 May 2017 | 2017-05-16 | Sheriff Vincent Thomas Keaveny 1395 |
142 | 142 | Lime Street & Cornhill Ward Club Civic Luncheon (with a guest) | 12 June 2017 | 2017-06-12 | Sheriff Vincent Thomas Keaveny 1395 |
143 | 143 | Summer Party, Crosby Hall (guest of Dr Christopher Moran) | 6 July 2017 | 2017-07-06 | Sheriff Vincent Thomas Keaveny 1395 |
144 | 144 | Dinner, Worshipful Company of Educators (guest of David O'Reilly) | 22 September 2017 | 2017-09-22 | Sheriff Vincent Thomas Keaveny 1395 |
145 | 145 | Dinner, Worshipful Company of Plaisterers (guest of Bryan Lincoln) | 3 October 2017 | 2017-10-03 | Sheriff Vincent Thomas Keaveny 1395 |
146 | 146 | Dinner, Worshipful Company of Wheelwrights (guest of Alan Culverhouse) | 12 October 2017 | 2017-10-12 | Sheriff Vincent Thomas Keaveny 1395 |
147 | 147 | Dinner (with a guest), Worshipful Company of Upholders (guest of Judy Tayler-Smith) | 26 October 2017 | 2017-10-26 | Sheriff Vincent Thomas Keaveny 1395 |
148 | 148 | British And Irish Trading Alliance lunch | 27 October 2017 | 2017-10-27 | Sheriff Vincent Thomas Keaveny 1395 |
149 | 149 | Dinner, Worshipful Company of Cutlers (guest of Richard Regan CC) 8 November 2017 | 8 November 2017 | 2017-11-08 | Sheriff Vincent Thomas Keaveny 1395 |
150 | 150 | Dinner, Worshipful Company of Stationers (guest of Tom Corrigan) | 22 November 2017 | 2017-11-22 | Sheriff Vincent Thomas Keaveny 1395 |
151 | 151 | Duke of Edinburgh's Award Trustees Dinner (guest of Patricia Teahan) | 28 November 2017 | 2017-11-28 | Sheriff Vincent Thomas Keaveny 1395 |
152 | 152 | Lunch, Worshipful Company of Spectacle Makers | 5 December 2017 | 2017-12-05 | Sheriff Vincent Thomas Keaveny 1395 |
153 | 153 | Dinner, Worshipful Company of Makers of Playing Cards (guest of Tom Corrigan) | 7 December 2017 | 2017-12-07 | Sheriff Vincent Thomas Keaveny 1395 |
154 | 154 | Dinner, Worshipful Company of Plaisterers | 9 January 2018 | 2018-01-09 | Sheriff Vincent Thomas Keaveny 1395 |
155 | 155 | Lunch, Worshipful Company of Plumbers (guest of Christopher Hill CC) | 24 January 2018 | 2018-01-24 | Sheriff Vincent Thomas Keaveny 1395 |
156 | 156 | Dinner, Worshipful Company of Marketors | 25 January 2018 | 2018-01-25 | Sheriff Vincent Thomas Keaveny 1395 |
157 | 157 | Dinner (with a guest), Co-operation Ireland (guest of Dr Christopher Moran) | 1 February 2018 | 2018-02-01 | Sheriff Vincent Thomas Keaveny 1395 |
158 | 158 | Lunch, Worshipful Company of Founders | 7 February 2018 | 2018-02-07 | Sheriff Vincent Thomas Keaveny 1395 |
159 | 159 | Lunch, Worshipful Company of Information Technologists | 21 February 2018 | 2018-02-21 | Sheriff Vincent Thomas Keaveny 1395 |
160 | 160 | Faculty Dinner (with a guest), Goodenough College | 21 February 2018 | 2018-02-21 | Sheriff Vincent Thomas Keaveny 1395 |
161 | 161 | Dinner, Worshipful Company of World Traders | 22 February 2018 | 2018-02-22 | Sheriff Vincent Thomas Keaveny 1395 |
162 | 162 | Dinner, Worshipful Company of Cordwainers (guest of Ann Holmes CC) | 9 March 2018 | 2018-03-09 | Sheriff Vincent Thomas Keaveny 1395 |
163 | 163 | Lunch, Worshipful Company of Masons | 20 March 2018 | 2018-03-20 | Sheriff Vincent Thomas Keaveny 1395 |
164 | 164 | Dinner, Worshipful Company of Drapers | 21 March 2018 | 2018-03-21 | Sheriff Vincent Thomas Keaveny 1395 |
165 | 165 | Dinner, Worshipful Company of Gardeners (guest of William Fraser) | 3 April 2018 | 2018-04-03 | Sheriff Vincent Thomas Keaveny 1395 |
166 | 166 | Lunch, Worshipful Company of Loriners (guest of Nicholas Bensted-Smith CC) | 12 April 2018 | 2018-04-12 | Sheriff Vincent Thomas Keaveny 1395 |
167 | 167 | Dinner, Worshipful Company of Makers of Playing Cards | 12 April 2018 | 2018-04-12 | Sheriff Vincent Thomas Keaveny 1395 |
168 | 168 | Dinner, Worshipful Company of Fletchers (guest of Clare James CC) | 17 April 2018 | 2018-04-17 | Sheriff Vincent Thomas Keaveny 1395 |
169 | 169 | Dinner (with a guest), Worshipful Company of Spectacle Makers (guest of Felicity Harding) | 25 April 2018 | 2018-04-25 | Sheriff Vincent Thomas Keaveny 1395 |
170 | 170 | Dinner, Worshipful Company of Actuaries (guest of Clare James CC) | 2 May 2018 | 2018-05-02 | Sheriff Vincent Thomas Keaveny 1395 |
440 | 440 | The Worshipful Company of Mercers Gresham Dinner | 14 November 2017 | 2017-11-14 | Professor Michael Raymond Mainelli 1323 |
423 | 423 | Wooden bowl - received from the Governor of Western Australia | 6th June 2017 | 2017-06-06 | Charles Edward Beck Bowman 1261 |
424 | 424 | The Worshipful Company of Mercers Gresham Dinner | 14 November 2017 | 2017-11-14 | Charles Edward Beck Bowman 1261 |
377 | 377 | Guest at the Broderers' Company banquet | 7th October 2015 | 2015-10-07 | Timothy Russell Hailes 1260 |
378 | 378 | Guest at Glass Sellers' Company banquet | 12th October 2015 | 2015-10-12 | Timothy Russell Hailes 1260 |
379 | 379 | Guest at Business Faculty Dinner, Goodenough College | 10th February 2016 | 2016-02-10 | Timothy Russell Hailes 1260 |
380 | 380 | Guest at banquet, Loriners Company | 13th May 2016 | 2016-05-13 | Timothy Russell Hailes 1260 |
381 | 381 | Guest at banquet, Guild of Young Freemen | 27th May 2016 | 2016-05-27 | Timothy Russell Hailes 1260 |
382 | 382 | Guest at banquet, Girdlers Company | 9th June 2016 | 2016-06-09 | Timothy Russell Hailes 1260 |
383 | 383 | Guest at banquet, Young Presidents Organisation | 9th September 2016 | 2016-09-09 | Timothy Russell Hailes 1260 |
384 | 384 | Guest at banquet, Guildable Manor of Southwark | 15th September 2016 | 2016-09-15 | Timothy Russell Hailes 1260 |
385 | 385 | Guest at banquet, Plaisterers Company | 4th October 2016 | 2016-10-04 | Timothy Russell Hailes 1260 |
386 | 386 | Guest at banquet, Marketors Company | 22nd October 2016 | 2016-10-22 | Timothy Russell Hailes 1260 |
387 | 387 | Guest at banquet, Tobacco Pipe Makers Company | 24th October 2016 | 2016-10-24 | Timothy Russell Hailes 1260 |
388 | 388 | Guest at banquet, Plaisterers Company | 10th January 2017 | 2017-01-10 | Timothy Russell Hailes 1260 |
389 | 389 | Guest at banquet, Business Faculty Dinner, Goodenough College | 8th February 2017 | 2017-02-08 | Timothy Russell Hailes 1260 |
390 | 390 | Guest at luncheon, Salters Company - | 2nd March 2017 | 2017-03-02 | Timothy Russell Hailes 1260 |
391 | 391 | Dinner guest - C&C Alpha Group | 23rd September 2017 | 2017-09-23 | Timothy Russell Hailes 1260 |
392 | 392 | Dinner guest - Worshipful Company of Security Professionals | 21st September 2017 | 2017-09-21 | Timothy Russell Hailes 1260 |
393 | 393 | Dinner guest -The Honourable Society of the Middle and Inner Temple | 25th September 2017 | 2017-09-25 | Timothy Russell Hailes 1260 |
394 | 394 | Dinner guest- The Worshipful Company of Mercers - Gresham | 14 November 2017 | 2017-11-14 | Timothy Russell Hailes 1260 |
395 | 395 | Membership - Number Twenty client space, Grosvenor Street, London (KPMG) | 28th March 2018 | 2018-03-28 | Timothy Russell Hailes 1260 |
396 | 396 | Dinner guest - Dr Chanchai of Reignwood, Ten Trinity Square. Two bottles of Chateau Siaurac pomerol wine received. | 13th May 2018 | 2018-05-13 | Timothy Russell Hailes 1260 |
397 | 397 | Lunch - Senior Trade and Investment Commissioner, Austrade (Austrade) | 7th August 2018 | 2018-08-07 | Timothy Russell Hailes 1260 |
565 | 565 | Dinner guest - Disappearing Dining Club, 24-26 Newbury Street London EC1A 7HU | 20th July 2017 | 2017-07-20 | Ann Holmes 1230 |
173 | 173 | bottle of fine vintage port (Jim Robinson) | 20th November 2015 | 2015-11-20 | Mark Raymond Peter Henry Delano Wheatley 1229 |
566 | 566 | Invited to the Pensions Age Award as a guest of CBRE | Thursday 23 February 2017 | 2017-02-23 | Alastair Michael Moss 1226 |
567 | 567 | Two tickets to the London Symphony Orchestra and reception | 19 September 2018 | 2018-09-19 | Alastair Michael Moss 1226 |
568 | 568 | Lunch with City Property Association - President and Director, 1 Poultry | 2 November 2018 | 2018-11-02 | Alastair Michael Moss 1226 |
569 | 569 | Lunch with Keltbray at Chez Marlene | 13 March 2019 | 2019-03-13 | Alastair Michael Moss 1226 |
570 | 570 | Guest at London Chamber of Commerce reception at the Five Seasons Hotel, Cannes | 12 March 2019 | 2019-03-12 | Alastair Michael Moss 1226 |
571 | 571 | Westminster Property Association/City Property Association – Stakeholder Lunch – Majestic Hotel, Cannes | 12 March 2019 | 2019-03-12 | Alastair Michael Moss 1226 |
572 | 572 | UK Cities Investor Dinner – Cannes | 12 March 2019 | 2019-03-12 | Alastair Michael Moss 1226 |
573 | 573 | Guest of Lloyd's of London [lunch] | 15 May 2019 | 2019-05-15 | Alastair Michael Moss 1226 |
574 | 574 | Guest of Surveyor's Association - Carlton Club [dinner as guest speaker] | 23 May 2019 | 2019-05-23 | Alastair Michael Moss 1226 |
176 | 176 | Engraved Silver Trowel presented at the Avondale Square Topping Out Ceremony by Geoffrey Osborne Limited. (Donated to Clothworkers’ Company) | 9th December 2015 | 2015-12-09 | Dhruv Patel 1224 |
177 | 177 | Christmas a 75cl bottle of Sainsbury's Blanc De Blancs Brut Champagne from Spice Innovations Limited | 17th December 2015 | 2015-12-17 | Dhruv Patel 1224 |
178 | 178 | Corinthian Roof Terrace ticket to NatWest T20 Blast Surrey v Kent at the Oval from BridgeOne Telecom Ltd | 29th July 2016 | 2016-07-29 | Dhruv Patel 1224 |
179 | 179 | Two tickets to the Asian Voice Charity Awards and Dinner at the London Hilton Park Lane from Pratik Dattani (Charity Clarity). | 19th May 2017 | 2017-05-19 | Dhruv Patel 1224 |
180 | 180 | Christmas a 75cl bottle of Canti Prosecco from Spice Innovations Limited | 19th December 2017 | 2017-12-19 | Dhruv Patel 1224 |
181 | 181 | One ticket to the Asian Voice Charity Awards and Dinner at the London Hilton Park Lane from Pratik Dattani (Charity Clarity) | 17th May 2019 | 2019-05-17 | Dhruv Patel 1224 |
333 | 333 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Jamie Ingham Clark 1223 |
337 | 337 | Invitation (with guest) to Supper at National Gallery marking Sir Stuart Lipton's 50 years' involvement in property. | 13 June 2016 | 2016-06-13 | Christopher Michael Hayward 1218 |
338 | 338 | Invitation to Mischon de Reya Lunch with Sir Stuart Lipton | 7 October 2016 | 2016-10-07 | Christopher Michael Hayward 1218 |
339 | 339 | Lunch at the Goring with Mike Hussey, Almacantar Ltd | 29 November 2016 | 2016-11-29 | Christopher Michael Hayward 1218 |
340 | 340 | Hosted to dinner at 1 Lombard Street by the City Architecture Forum (Guest Speaker) | 23 November 2016 | 2016-11-23 | Christopher Michael Hayward 1218 |
341 | 341 | Hosted breakfast at Guildhall by Gerald Eve Associates (Guest Speaker) | 24th November 2016 | 2016-11-24 | Christopher Michael Hayward 1218 |
342 | 342 | Guest at lunch hosted by Richard Desmond (Northern & Shell plc) | 12th June 2017 | 2017-06-12 | Christopher Michael Hayward 1218 |
343 | 343 | Lunch with the owners of Harry’s Bar and Restaurant, 5 Abchurch Yard, EC4N 7BA | 17 July 2017 | 2017-07-17 | Christopher Michael Hayward 1218 |
344 | 344 | Dinner and gift of a leather travel wallet at the Guildhall for the C & C Alpha Group Limited (Guest Speaker) | 23rd September 2017 | 2017-09-23 | Christopher Michael Hayward 1218 |
345 | 345 | Gresham Dinner, guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | Christopher Michael Hayward 1218 |
346 | 346 | Lunch - Richard Desmond (Northern & Shell PLC) | 2nd February 2018 | 2018-02-02 | Christopher Michael Hayward 1218 |
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");