home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

5 rows where record_id = "2023-10-16-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
f87336b82714a5a9ce9a7f9fb229f96b77b7351b 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-10-16   Liam Byrne uk.org.publicwhip/person/11360 0 2023-10-16-891eb863-11360-0
263c3bf026b485d92f2e964fffc7e4093b19cd4a 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-10-16   Liam Byrne uk.org.publicwhip/person/11360 1 2023-10-16-891eb863-11360-0
785178c5fdbdd2ab3de0adb8fdbef8e55332e093 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-10-16   Liam Byrne uk.org.publicwhip/person/11360 2 2023-10-16-891eb863-11360-0
f5d37e9ded02f7a896b4ea1be4ca0b86a908da4d 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-10-16   Liam Byrne uk.org.publicwhip/person/11360 3 2023-10-16-891eb863-11360-0
b387f08ce424aa30fa5dc70afdfc6323814e8b47 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 £732; accommodation £557; estimate of sundries £100, total value £1,389 Destination of visit: Rabat and Marrakech, Morocco Dates of visit: 4-8 June 2023 Purpose of visit: In my capacity as Chair of the Parliamentary Network on the World Bank and international Monetary Fund, to attend a field trip in advance of annual meetings to be held in Morocco in October 2023. (Registered 03 July 2023) Visits outside the UK 891eb863 2023-10-16   Liam Byrne uk.org.publicwhip/person/11360 4 2023-10-16-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");
Powered by Datasette · Queries took 27.174ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette