items

Table actions

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

3 rows where record_id = "2023-09-04-891eb863-24769-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
db72d4c4ba09e2cbcf69e419dcdc57563a2f8fb0 Name of donor: Coalition for Global Prosperity Address of donor: Public Hall, 1 Horse Guards Ave, London SW1A 2HU Estimate of the probable value (or amount of any donation): Transport, hotel and subsistence, estimated value £2,203.71 Destination of visit: Jordan Dates of visit: 10-14 October 2022 Purpose of visit: Coalition for Global Prosperity cross party visit to Jordan to see Syrian refugee camps. (Registered 31 October 2022) Visits outside the UK 891eb863 2023-09-04   Heather Wheeler uk.org.publicwhip/person/24769 0 2023-09-04-891eb863-24769-0
1b61885082357ce85e22d2836b62c0514fcc8326 Name of donor: European Parliamentary Forum for Sexual and Reproductive Rights Address of donor: Rue Montoyer, 23 – 1000 Brussels, Belgium Estimate of the probable value (or amount of any donation): Transport, hotel and subsistence, estimated value £3,848 Destination of visit: Tanzania Dates of visit: 7-13 January 2023 Purpose of visit: Study Tour on Reproductive, Maternal, New-Born Child and Adolescent Health. (Registered 06 February 2023) Visits outside the UK 891eb863 2023-09-04   Heather Wheeler uk.org.publicwhip/person/24769 1 2023-09-04-891eb863-24769-0
26095369b845fdbc6442f8d07e54b3722cc84746 Name of donor: General Confederation of Moroccan Enterprises (CGEM) Address of donor: 23, Boulevard Mohamed Abdou, Quartier Palmiers 20340, Casablanca, Morocco Estimate of the probable value (or amount of any donation): Flights, travel and subsistence for myself, value £2,794; flights, travel and subsistence for my staff member who acts as secretariat for the APPG, value £1,892; total value £4,686 Destination of visit: Morocco Dates of visit: 10-14 April 2023 Purpose of visit: As Chair of the APPG on Morocco to promote links and mutual understanding between Britain and Morocco. (Registered 28 April 2023) Visits outside the UK 891eb863 2023-09-04   Heather Wheeler uk.org.publicwhip/person/24769 2 2023-09-04-891eb863-24769-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");