items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2023-09-18-891eb863-25860-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| 313e14a986cd21a68543d5845c0eaeb9bfd013c1 | Name of donor: Falkland Islands Legislative Assembly Address of donor: Gilbert House, Ross Road, Stanley, Falkland Islands FIQQ 1ZZ Estimate of the probable value (or amount of any donation): Flights, accommodation and subsistence, value £3,945.43 Destination of visit: Falkland Islands Dates of visit: 17-25 November 2022 Purpose of visit: Falklands Islands APPG visit as guests of the Falkland Islands Government, to mark the 40th anniversary of the liberation of the Falkland Islands. (Registered 13 December 2022) | Visits outside the UK 891eb863 | 2023-09-18 | James Sunderland uk.org.publicwhip/person/25860 | 0 | 2023-09-18-891eb863-25860-0 | |
| dfde930bf2a182996c5a34e3a9cbcf1768144e1f | Name of donor: HRH Prince Salman bin Hamad Al Khalifa - Crown Prince and Prime Minister of the Kingdom of Bahrain Address of donor: c/o Embassy of Bahrain, 30 Belgrave Square, London SW1X 8QB Estimate of the probable value (or amount of any donation): Return flights, three nightsâ hotel accommodation and entry to the Formula 1 Bahrain Grand Prix 2023, estimated value £9,500 Destination of visit: Bahrain Dates of visit: 3-6 March 2023 Purpose of visit: Invited as Co-Chairman of APPG on Motorsport - visit included multiple meetings with senior Ministers from Bahrain Government, Formula 1 and individual race teams to discuss pressing international and domestic issues in motorsport. (Registered 05 April 2023) | Visits outside the UK 891eb863 | 2023-09-18 | James Sunderland uk.org.publicwhip/person/25860 | 1 | 2023-09-18-891eb863-25860-0 | |
| ad1e499713ea65caa7755078f0a406f0ea772a11 | Name of donor: All-Party Parliamentary Group on Malaria and Neglected Tropical Diseases Address of donor: c/o Malaria No More UK, Room 202, 2nd Floor, 30 Millbank, London SW1P 4QP Estimate of the probable value (or amount of any donation): Flights (£1,600); accommodation (£620); malaria tablets (£30); food, in-country transport and other expenses (£180); total value £2,430 Destination of visit: Malawi Dates of visit: 23-29 July 2023 Purpose of visit: As Vice-Chair of the All-Party Parliamentary Group on Malaria and Neglected Tropical Diseases, to see the impact of malaria and neglected tropical diseases, and the challenges faced by government, NGOs, academic and research institutions, and local communities in tackling these diseases. (Registered 01 August 2023) | Visits outside the UK 891eb863 | 2023-09-18 | James Sunderland uk.org.publicwhip/person/25860 | 2 | 2023-09-18-891eb863-25860-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");