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

14 rows where date_str = "" and member_id = 511

✎ View and edit SQL

This data as json, CSV (advanced)

member_id 1 ✖

  • Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA · 14 ✖

date_str 1 ✖

date (date) 0 ✖

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
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

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