items

Table actions

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

3 rows where record_id = "2023-06-26-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
de096cb89e860d99b1fbb7a29c37dfe71c2d599b 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-06-26   Alun Cairns uk.org.publicwhip/person/24740 0 2023-06-26-891eb863-24740-0
df1b021c23391d3ac170a6ac91dc1ef9ebfbc0a8 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-06-26   Alun Cairns uk.org.publicwhip/person/24740 1 2023-06-26-891eb863-24740-0
6dcc553ba40bcb0179fc7ca17635e565cb32a916 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-06-26   Alun Cairns uk.org.publicwhip/person/24740 2 2023-06-26-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");