items

Table actions

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

3 rows where record_id = "2023-08-07-891eb863-24740-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
a8909db2aa0b9f8f0aeca24bea37130f1c43a2b6 Name of donor: Conservative Friends of Israel (CFI Ltd) Address of donor: PO Box 72288, London SW1P 9LB Estimate of the probable value (or amount of any donation): Flights, transport and accommodation, value £3,850 Destination of visit: Israel and the West Bank Dates of visit: 12-17 February 2023 Purpose of visit: Fact finding political delegation. (Registered 03 March 2023) Visits outside the UK 891eb863 2023-08-07   Alun Cairns uk.org.publicwhip/person/24740 0 2023-08-07-891eb863-24740-0
545eb2c110ec0fb8c77c9756feb4d53233ce29f8 Name of donor: Institute of Legislation and Legal Policy Address of donor: The Embassy of the Republic of Uzbekistan in London, 41 Holland Park, London W11 3RP Estimate of the probable value (or amount of any donation): Flights, accommodation, internal travel and meals, value £3,000 Destination of visit: Tashkent, Uzbekistan Dates of visit: 16-18 April 2023 Purpose of visit: Taking part in an international conference on the constitutional changes in Uzbekistan and their significance for both citizens and the international community, and meeting various key political stakeholders. (Registered 10 May 2023) Visits outside the UK 891eb863 2023-08-07   Alun Cairns uk.org.publicwhip/person/24740 1 2023-08-07-891eb863-24740-0
2ec63d3909c5107e2e1e18bd388907f177f4eaa9 Name of donor: Media City Qatar Address of donor: Floor 17 & 18, Tornado Tower, Bldg. 17, Zone 60, Street 810, Corner Majlis Al Taawoon And, Al Funduq Street, Doha, Qatar Estimate of the probable value (or amount of any donation): Flights, accommodation, internal travel and meals, total value £6,900 Destination of visit: Doha Dates of visit: 20-24 May 2023 Purpose of visit: To participate at the Bloomberg Qatar Economic Forum 2023 and meet Qatari and international officials to discuss current affairs including regional conflict resolution, labour rights, and Qatar-UK bilateral relations. (Registered 06 June 2023) Visits outside the UK 891eb863 2023-08-07   Alun Cairns uk.org.publicwhip/person/24740 2 2023-08-07-891eb863-24740-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");