gifts

Gifts of Hospitality in the Register of Interests.

date_str is the date as supplied in the Register, and date is an attempt to create a year-month-day date from that string.

Data source: See col-scraper on GitHub

29 rows where member_id = 511

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date

member_id 1 ✖

  • Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA · 29 ✖
Link rowid ▼ name date_str date member_id
494 494 Buffet Dinner, Hungarian Ambassador     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
495 495 Lunch in Guildhall, Luxembourg Ambassador     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
496 496 Lunch, Professor Trond Beravale     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
497 497 Overnight stay at residence for The Ambassador of Denmark and his wife 4-5 February 2017 2017-02-05 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
498 498 Overnight stay at residence for The Ambassador of Uruguay and his wife 6-7 August 2016 2016-08-07 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
499 499 Overnight stay at residence for The Ambassador of Luxembourg and his wife 6-7 February 2016 2016-02-07 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
500 500 Reception, German Embassy     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
501 501 Dinner with Lord Green at German Embassy     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
502 502 Dinner at the Lancasters, German Embassy     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
503 503 Dinner at Residence, Korean Embassy     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
504 504 Lunch in Guildhall, Italian Ambassador     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
505 505 Lunch in Guildhall, Austrian Ambassador & Wife     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
506 506 Lunch in Guildhall, Hungarian Ambassador & Wife     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
507 507 Lunch in Guildhall, German Ambassador & Wife     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
508 508 International Bankers Annual Banquet, Luxembourg Ambassador     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
509 509 Dinner at Residence, Luxembourg Ambassador     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
510 510 Lunch in Guildhall, Uraguayan Ambassador & Advisor     Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
511 511 Reception at Highclere Castle hosted by the Embassy of Egypt 22/11/17   Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
512 512 Embassy of Ireland - frequent dinners and receptions 2015 - current   Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
513 513 Embassy of Belgium - frequent dinners and receptions 2015 - current   Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
514 514 Embassy of Germany - frequent dinners and receptions 2015 - current   Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
515 515 Embassy of Austria - frequent dinners and receptions 2015 - current   Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
516 516 Embassy of Argentina - frequent dinners and receptions 2015 - current   Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
517 517 Embassy of Uruguay - frequent dinners and receptions 2015 - current   Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
518 518 Embassy of Slovakia - frequent dinners and receptions 2015 - current   Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
519 519 Embassy of Slovenia - frequent dinners and receptions 2016 - current   Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
520 520 Embassy of Peru - frequent dinners and receptions 2016 - current   Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
521 521 Embassy of Luxembourg - frequent dinners and receptions 2015-17 2015-06-17 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
522 522 Apostolic Nunciature - Receptions and lunches 2015-17 2015-06-17 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");