items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2022-11-28-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 |
|---|---|---|---|---|---|---|---|
| f955238f4dbc39d739ede8e6fc62aad3c920f70a | Name of donor: (1) Lockheed Martin UK Ltd (2) CAE U.K. Plc Address of donor: (1) Cunard House, 15 Lower Regent Street, London SW1Y 4LR (2) Innovation Drive, Burgess Hill RH15 9TW Estimate of the probable value (or amount of any donation): (1) domestic transport and meals for two people to the value of £264 (2) domestic transport and meals for two people to the value of £264 Destination of visit: Bosnia and Herzegovina Dates of visit: 28 September - 1 October 2021 Purpose of visit: Parliamentary delegation with the All Party Parliamentary Group for the Armed Forces to meet current politicians from Bosnia and Herzegovina and to learn about the Bosnian War. (Registered 01 November 2021) | Visits outside the UK 891eb863 | 2022-11-28 | James Sunderland uk.org.publicwhip/person/25860 | 0 | 2022-11-28-891eb863-25860-0 | |
| 8039be627e49178a34bb5d2fc0c3f3d385826acf | Name of donor: Conservative Friends of Israel Ltd (CFI Ltd) Address of donor: PO Box 72288, London SW1P 9LB Estimate of the probable value (or amount of any donation): Air travel, accommodation and hospitality with a value of £3,300 Destination of visit: Israel and the West Bank Dates of visit: 3-8 April 2022 Purpose of visit: Fact finding political delegation. (Registered 13 April 2022) | Visits outside the UK 891eb863 | 2022-11-28 | James Sunderland uk.org.publicwhip/person/25860 | 1 | 2022-11-28-891eb863-25860-0 | |
| 817f78fee56b4111357d6e74bb173deb22d52a3f | Name of donor: All-Party Parliamentary Group on Malaria and Neglected Tropical Diseases Address of donor: c/o Malaria No More UK, The Foundry, 17 Oval Way, London SE11 5RR Estimate of the probable value (or amount of any donation): Flights £2,350; accommodation £300; food, in-country transport and other expenses £125; total value £2,775 Destination of visit: Rwanda Dates of visit: 19-24 June 2022 Purpose of visit: To attend the Kigali Summit on Malaria and Neglected Tropical Diseases as Vice-Chair of the APPG for Malaria and NTDs, meet with representatives of those working on malaria and other diseases across Africa, and see the impact of malaria on local communities in Rwanda. (Registered 14 July 2022) | Visits outside the UK 891eb863 | 2022-11-28 | James Sunderland uk.org.publicwhip/person/25860 | 2 | 2022-11-28-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");