items

Table actions

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

5 rows where record_id = "2023-06-26-891eb863-11360-0" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
fd042c4b62b22e42c2fa902937b52c100d7f5dc4 Name of donor: Yalta European Strategy Ltd Address of donor: Third Floor, 95 The Promenade, Cheltenham GL50 1HH Estimate of the probable value (or amount of any donation): Flights and travel £1,262.66; accommodation £314.12; dinners/hospitality £450.06; total value £2,026.84 Destination of visit: Kyiv, Ukraine Dates of visit: 8-12 September 2022 Purpose of visit: Attending the Yalta European Strategy Conference, meetings with Ukrainian officials and members of civil society. (Registered 27 September 2022) Visits outside the UK 891eb863 2023-06-26   Liam Byrne uk.org.publicwhip/person/11360 0 2023-06-26-891eb863-11360-0
0cde1a9e9e337b566dc11f2bccf1e894f3595d23 Name of donor: The Parliamentary Network on the World Bank & International Monetary Fund Address of donor: 66 avenue d'Iéna, 75116 Paris, France Estimate of the probable value (or amount of any donation): Flights £ 2,635.00; accommodation £400; total value £3,035 Destination of visit: Tanzania Dates of visit: 19-24 September 2022 Purpose of visit: In my capacity as Chair of the Parliamentary Network on the World Bank and international Monetary Fund, to launch its Tanzanian Chapter. (Registered 10 October 2022) Visits outside the UK 891eb863 2023-06-26   Liam Byrne uk.org.publicwhip/person/11360 1 2023-06-26-891eb863-11360-0
5073c179ecdb0f7b6d77152f8f71141c3d2038e8 Name of donor: The Eleanor Cook Foundation Address of donor: Suite 1110, 150 Fayetteville Street Raleigh, NC 27601 USA Estimate of the probable value (or amount of any donation): Transport (£2,586.91), hotel (£580) and food and subsistence (£400), total value £3,566.91 Destination of visit: Kenya Dates of visit: 13-17 February 2023 Purpose of visit: To demonstrate the impact UK Aid has in communities in Kenya. (Registered 27 February 2023) Visits outside the UK 891eb863 2023-06-26   Liam Byrne uk.org.publicwhip/person/11360 2 2023-06-26-891eb863-11360-0
19f14e35ccb9b0661f91d79b378849de6f5ec746 Name of donor: UK Committee for UNICEF Address of donor: 1 Westfield Avenue, Stratford, London E20 1HZ Estimate of the probable value (or amount of any donation): Flights £1,580.52, accommodation £320, food and other hospitality £300; total value £2,200.52 Destination of visit: Addis Ababa, Arba Mintch, Yabello and Dubluk, Ethiopia Dates of visit: 3-6 April 2023 Purpose of visit: To join a parliamentary delegation observing the malnutrition crisis unfolding in the Horn of Africa and UNICEF’s programmatic work there. (Registered 18 April 2023) Visits outside the UK 891eb863 2023-06-26   Liam Byrne uk.org.publicwhip/person/11360 3 2023-06-26-891eb863-11360-0
9674cf2b4e7f3b4f5b7c7db99411ce826679e0d3 Name of donor: The Parliamentary Network on the World Bank & International Monetary Fund Address of donor: 66 avenue d'Iéna, 75116 Paris, France Amount of donation or nature and value if donation in kind: Flights (£1,599); accommodation (£1,598); estimate of sundries (£127), total value £3,324 Destination of visit: Washington DC, USA Dates of visit: 9-13 April 2023 Purpose of visit: In my capacity as Chair of the Parliamentary Network on the World Bank and international Monetary Fund, to attend the organisations Spring Meetings. (Registered 15 May 2023) Visits outside the UK 891eb863 2023-06-26   Liam Byrne uk.org.publicwhip/person/11360 4 2023-06-26-891eb863-11360-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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