items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2023-05-15-891eb863-10678-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| 5412fdbe6c3e0a535e44647513b71e27228cd10f | Name of donor: Tufts University Address of donor: 419 Boston Avenue, Medford, MA 02155, United States Estimate of the probable value (or amount of any donation): Flights £2,828.12; hotel £332.93; transfers/car/driver £427.44; meals £138.39, total value £3,726.88 Destination of visit: United States Dates of visit: 29 March - 3 April 2022 Purpose of visit: Present speech on Ukraine situation as part of my Shadow Foreign Secretary role. (Registered 13 June 2022) This is a late entry to which the rectification procedure was applied on 11 August 2022. Paragraph 15 of chapter 4 of the Guide to the Rules refers. | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2023-05-15-891eb863-10678-0 | |
| 52c70498c5d5a40be58dafbf261e1bfc27e4218f | Name of donor: European Councils on Foreign Relations Address of donor: Unter den Linden 17, 10117 Berlin, Germany Estimate of the probable value (or amount of any donation): For me, flights £146.82; hotel £117.54; and for me and a member of staff, buffet dinner £164.58; total value £428.94 Destination of visit: Berlin Dates of visit: 19-20 June 2022 Purpose of visit: To take part in the European Councils on Foreign Relations conference. (Registered 13 July 2022) | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2023-05-15-891eb863-10678-0 | |
| ce3c9ac0c1be3dfaaec0df1be2d3562c47d9bfff | Name of donor: (1) Newbridge Advisory; (2) Bilderberg Association Address of donor: (1) Mermaid House, 2 Puddle Dock, London EC4V 3DS (2) 2 St. Jamesâ Place, London SW1A 1NP Estimate of the probable value (or amount of any donation): (1) Reimbursed £5,669.57 for flights and accommodation on 8 June 2022; (2) Airport transfers at £160 and meals approximately £376.58; total value £536.58 Destination of visit: Washington DC, United States Dates of visit: 2-5 June 2022 Purpose of visit: To partake in the Bilderberg Meeting 2022. (Registered 19 July 2022; updated 22 July 2022) This is a late entry to which the rectification procedure was applied on 11 August 2022. Paragraph 15 of chapter 4 of the Guide to the Rules refers. | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2023-05-15-891eb863-10678-0 | |
| 2795ba9c0f940890e2e2239fb81ba9db6119b75f | Name of donor: Franco-British Colloque Ltd Address of donor: Station House, Station Approach, East Horsley KT24 6QX Estimate of the probable value (or amount of any donation): Travel, including transfers, £430.47; one nightâs hotel accommodation, including meals, £527; total value £957.47 Destination of visit: Versailles, France Dates of visit: 1-2 July 2022 Purpose of visit: To attend and speak, including a Q&A session, at the annual Franco-British Colloque Forum. (Registered 21 July 2022) | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2023-05-15-891eb863-10678-0 | |
| 290a24d70f8441b2c810d1d967c9117cca60eb1c | Name of donor: Canada 20/20 Corporation Address of donor: 35 O'Connor Street, Suite 302, Ottawa, ON Canada, K1P 5M4 Estimate of the probable value (or amount of any donation): £527.01 received on 11 October 2022 as reimbursement for non-refundable flights Destination of visit: Toronto, Canada Dates of visit: visit did not take place Purpose of visit: To attend the Global Progress Conference, but I was unable to attend due to the death of her Majesty the Queen. (Registered 01 November 2022) | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2023-05-15-891eb863-10678-0 | |
| 51a9dc8d0f021c99c33a84c4ddcd19430083574f | Name of donor: Friedrich-Ebert-Stiftung Address of donor: Rue du Taciturne 38, 1000 Brussels, Belgium Estimate of the probable value (or amount of any donation): Train tickets, local transport and hotel accommodation for myself and a member of my staff, value £768 Destination of visit: Brussels, Belgium Dates of visit: 9-10 November 2022 Purpose of visit: Visit to NATO, European Parliament and European Commission for meetings in my capacity as Shadow Foreign Secretary. (Registered 29 November 2022) | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2023-05-15-891eb863-10678-0 | |
| 999541ebcec6add6bfc6d3a37600b49b4bab52c3 | Name of donor: Bloomberg Philanthropies Address of donor: 25 East 78th Street, New York, NY 10075, USA Estimate of the probable value (or amount of any donation): Hotel accommodation for myself and a member of my staff, value £2,672.60 Destination of visit: Sharm El-Sheikh, Egypt Dates of visit: 14-15 November 2022 Purpose of visit: Attending COP 27 for meetings in my capacity as Shadow Foreign Secretary. (Registered 29 November 2022) | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2023-05-15-891eb863-10678-0 | |
| 0a0900c97e19050405acaf3970b9a2f5c249377f | Name of donor: Halifax International Security Forum Address of donor: 1740 N St. NW Washington, DC Estimate of the probable value (or amount of any donation): Hotel and ground transportation, value £405.68 Destination of visit: Halifax, Canada Dates of visit: 18-20 November 2022 Purpose of visit: To speak at a conference. (Registered 15 December 2022) | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 7 | 2023-05-15-891eb863-10678-0 | |
| 4df7693728fba7511ecf9c9085315fdb2627b878 | Name of donor: Emirates Literature Foundation Address of donor: Dar Al Adaab, Al Shindagha Historical Neighbourhood, P.O.Box: 24506, Dubai, U.A.E Estimate of the probable value (or amount of any donation): Travel, accommodation and food for me and a member of staff, value £8,911.51 Destination of visit: Dubai, UAE Dates of visit: 31 January - 4 February 2023 Purpose of visit: To speak at a literature festival and conduct meetings in my capacity as Shadow Foreign Secretary. (Registered 08 February 2023) | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 8 | 2023-05-15-891eb863-10678-0 | |
| c6cb43d1b11b9865add24806e33b7389c81d8f24 | Name of donor: Emirates Literature Foundation Address of donor: Dar Al Adaab, Al Shindagha Historical Neighbourhood, P.O.Box: 24506, Dubai, UAE Estimate of the probable value (or amount of any donation): Travel, accommodation and food for me and a member of staff, total value £5,690.24 Destination of visit: Dubai, UAE Dates of visit: 31 January - 4 February 2023 Purpose of visit: To speak at the Literature Festival and conduct meetings in my capacity as Shadow Foreign Secretary. (Registered 27 February 2023) | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 9 | 2023-05-15-891eb863-10678-0 | |
| ed80a8ac2ba20dda9dafdc2b22cabc95ac8d8379 | Name of donor: Halifax International Security Forum Address of donor: 1740 N St. NW Washington DC, USA Estimate of the probable value (or amount of any donation): Flights, value £1,165.06. I paid for the flights and was reimbursed on 28 February 2023. Destination of visit: Halifax, Canada Dates of visit: 18-20 November 2023 Purpose of visit: To speak at a conference. (Registered 28 February 2023) | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 10 | 2023-05-15-891eb863-10678-0 | |
| d08bc64a6846015be3795c00f7f42c8e9618438f | Name of donor: National Security Action Address of donor: 1090 Vernon Avenue NW, Suite 750, Washington, DC 20005, USA Estimate of the probable value (or amount of any donation): Flights, accommodation, meals and transportation for me and a member of staff, value £8,666.67 Destination of visit: Washington, USA Dates of visit: 14-17 March 2023 Purpose of visit: Speaking at an event for the Center for American Progress, conducting bilateral meetings in my capacity as Shadow Foreign Secretary. (Registered 29 March 2023) | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 11 | 2023-05-15-891eb863-10678-0 | |
| f6d2c56aafd5f2b398feda8744827dba7ec8300b | Name of donor: Commonwealth War Graves Commission Address of donor: 2 Marlow Road, Maidenhead SL6 7DX Estimate of the probable value (or amount of any donation): Flights, food, accommodation and visas for me and a member of staff, value £4,563.30 Destination of visit: Nairobi and Mombasa, Kenya Dates of visit: 19-26 April 2023 Purpose of visit: Update from Commonwealth War Graves Commission and meeting stakeholders. (Registered 15 May 2023) | Visits outside the UK 891eb863 | 2023-05-15 | David Lammy uk.org.publicwhip/person/10678 | 12 | 2023-05-15-891eb863-10678-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE items (
hash VARCHAR(40) NOT NULL,
item TEXT,
category_id TEXT,
date TEXT,
member_id TEXT,
person_id TEXT,
sort_order INTEGER,
record_id TEXT,
PRIMARY KEY (hash),
FOREIGN KEY ("category_id") REFERENCES [categories](id),
FOREIGN KEY ("member_id") REFERENCES [members](id),
FOREIGN KEY ("person_id") REFERENCES [people](id)
);
CREATE INDEX items_date ON items("date");
CREATE INDEX items_category_id ON items("category_id");
CREATE INDEX items_member_id ON items("member_id");
CREATE INDEX items_person_id ON items("person_id");
CREATE INDEX items_record_id ON items("record_id");