items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2023-10-16-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 |
|---|---|---|---|---|---|---|---|
| de565db79c81017fcd88d41771dbe3d40a5e50b5 | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2023-10-16-891eb863-10678-0 | |
| 0e72cbfe8ee38e7f99b19293f9d78f4a1d86eb2a | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2023-10-16-891eb863-10678-0 | |
| e0484401b2441a19d6d440136aee0154394a35e9 | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2023-10-16-891eb863-10678-0 | |
| 87e365a7db7f33d54c2f2c92398be2b2e78c050b | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2023-10-16-891eb863-10678-0 | |
| 2fddeace6d4e009266b8eb6cedd15dc4066a429a | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2023-10-16-891eb863-10678-0 | |
| a2f2e10d95969c0f54feeb1849291513b9884c03 | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2023-10-16-891eb863-10678-0 | |
| 62b1ab2f24daaa8eeed1763e17e5dd30dd8cddab | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2023-10-16-891eb863-10678-0 | |
| 804b3454c812a9deb3a8163bf5f6b8974b8751a8 | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 7 | 2023-10-16-891eb863-10678-0 | |
| a4863cef6c811d08b1f6f9a393b0bc3e062dab1f | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 8 | 2023-10-16-891eb863-10678-0 | |
| 76322a46107d85e656806c27f228c8f8287ec147 | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 9 | 2023-10-16-891eb863-10678-0 | |
| 8a06b8481b868755d23ffa100daf155dfdb9b8e9 | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 10 | 2023-10-16-891eb863-10678-0 | |
| a67dc6d53528c74262b3e7196ea536deead59bfb | 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-16 | David Lammy uk.org.publicwhip/person/10678 | 11 | 2023-10-16-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");