items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2023-10-30-891eb863-10678-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
e54cc0c1ddc99e7571bd4b921c6fd18953b78ae1 | 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-10-30 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2023-10-30-891eb863-10678-0 | |
b55450f150cf8fe5588d7cfb0a94c096396ab0f9 | 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-10-30 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2023-10-30-891eb863-10678-0 | |
22d0c5a6efbb675ce7cc2a88aa37e5bfb8f0ec66 | 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-10-30 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2023-10-30-891eb863-10678-0 | |
cd362a70f757d9ecc1dc099713b6e815e285630b | 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-10-30 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2023-10-30-891eb863-10678-0 | |
166416c81ea0e795a401443272fd9cff61512586 | 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-10-30 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2023-10-30-891eb863-10678-0 | |
5f2c6d0715bcaab5d305f1ad535232f177b76748 | 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-10-30 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2023-10-30-891eb863-10678-0 | |
68fa82f9d6ec20a86e75bce5c734b21957a0c82b | 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-10-30 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2023-10-30-891eb863-10678-0 | |
17da9230e92e5c9ff3d323cba9b4b2dd0c4b0020 | 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-10-30 | David Lammy uk.org.publicwhip/person/10678 | 7 | 2023-10-30-891eb863-10678-0 | |
97f5a53bd82e45d8cd139916171d1ff71fc0282c | 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-10-30 | David Lammy uk.org.publicwhip/person/10678 | 8 | 2023-10-30-891eb863-10678-0 | |
7d10d08977feaa59dbff93283a08a0f35b911364 | Name of donor: TED Conferences LLC Address of donor: 330 Hudson St, 12th Floor, New York, NY 10013 Estimate of the probable value (or amount of any donation): Conference passes, accommodation and transport for me and a member of staff, value £8,510.16 Destination of visit: Detroit, USA Dates of visit: 11-14 July 2023 Purpose of visit: To speak at the TED Climate Conference. (Registered 24 July 2023) | Visits outside the UK 891eb863 | 2023-10-30 | David Lammy uk.org.publicwhip/person/10678 | 9 | 2023-10-30-891eb863-10678-0 | |
4627d8e5f1d478807ee9e3e4df4f51f617dab944 | Name of donor: Conservation International do Brasil Address of donor: Avenida Rio Branco n. 131, 8th floor, Rio De Janeiro Estimate of the probable value (or amount of any donation): For me and a member of staff, flights, accommodation, food, transport, translator, life insurance and medical support, value £24,739.36 Destination of visit: Brazil Dates of visit: 14-18 August 2023 Purpose of visit: Bilateral meetings and visit to Amazon region. (Registered 06 September 2023) | Visits outside the UK 891eb863 | 2023-10-30 | David Lammy uk.org.publicwhip/person/10678 | 10 | 2023-10-30-891eb863-10678-0 | |
e4b2f7a933abb5d1030f9cf933bf307083140131 | Name of donor: Canada 20/20 Corporation Address of donor: 35 O'Connor Street, Suite 302, Ottawa, Ontario K1P 4MS Estimate of the probable value (or amount of any donation): Flights, transfers and hotel, total value £965.46 Destination of visit: Montreal Dates of visit: 15-17 September 2023 Purpose of visit: Attend and speak at Global Progress Summit. (Registered 03 October 2023) | Visits outside the UK 891eb863 | 2023-10-30 | David Lammy uk.org.publicwhip/person/10678 | 11 | 2023-10-30-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");