items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2022-08-08-891eb863-25676-0" sorted by person_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id ▼ | sort_order | record_id |
---|---|---|---|---|---|---|---|
ff52e9871214bcdfeb92eee9da00422fddc9bbdf | Name of donor: House of Representatives of the Republic of Cyprus Address of donor: 1402 Nicosia, Cyprus Estimate of the probable value (or amount of any donation): Accommodation, food and transport with a total value of £750 Destination of visit: Cyprus Dates of visit: 9-12 November 2021 Purpose of visit: To strengthen inter-parliamentary connections between the Republic of Cyprus and the UK and to discuss the latest developments on efforts to restart negotiations to reunite Cyprus. (Registered 29 November 2021) | Visits outside the UK 891eb863 | 2022-08-08 | Bambos Charalambous uk.org.publicwhip/person/25676 | 0 | 2022-08-08-891eb863-25676-0 | |
753b5a72f7ec2efbeca05f1fc250381b5a44f5c8 | Name of donor: (1) Labour Friends of Israel; (2) The Royal Institute of International Affairs, Chatham House Address of donor: (1) BM LFI, London WC1N 3XX; (2) 10 St James's Square, London SW1Y 4LE Estimate of the probable value (or amount of any donation): (1) accommodation and meals with a value of £1,500; (2) flights and accommodation with a value of £3,300 Destination of visit: Israel Dates of visit: 20-25 March 2022 Purpose of visit: Fact-finding visit. Meeting with Israeli co-existence campaigners, politicians, academics and diplomats. Attending the Seventh UK-Israel Strategic Dialogue organised by Chatham House in partnership with ELNET UK. (Registered 08 April 2022) | Visits outside the UK 891eb863 | 2022-08-08 | Bambos Charalambous uk.org.publicwhip/person/25676 | 1 | 2022-08-08-891eb863-25676-0 | |
5a4a3b34be7d9fa858d52bca65a038aa4aeafc0b | Name of donor: Coalition for Global Prosperity Address of donor: 1 Horse Guards Avenue, London SW1A 2HU Estimate of the probable value (or amount of any donation): Accommodation and meals with a value of £501.61; flights with a value of £693.96; total £1,195.57 Destination of visit: Lebanon Dates of visit: 10-14 April 2022 Purpose of visit: To see how UK aid is spent on supporting refugees, removing landmines, cluster munitions and surplus ammunition. Meeting with politicians and beneficiaries of Save the Children and the Mines Advisory Group projects. (Registered 11 May 2022) | Visits outside the UK 891eb863 | 2022-08-08 | Bambos Charalambous uk.org.publicwhip/person/25676 | 2 | 2022-08-08-891eb863-25676-0 | |
c89b51ad61ab960287dd8fcfb151afecc23194f8 | Name of donor: RESULTS UK Address of donor: 31-33 Bondway, London SW8 1SJ Estimate of the probable value (or amount of any donation): Flights £1,412.19; accommodation £777.92; food £235.71; taxis £143.36; misc: (Covid tests, tour of DC, etc) £110; total value £2,679.18 Destination of visit: Washington, D.C. Dates of visit: 19-23 April 2022 Purpose of visit: To attend the replenishment conference of the Global Financing Facility at the Canadian Embassy and a series of meetings with World Bank leadership and CSO groups on the margins of the World Bank Spring Meetings. (Registered 11 May 2022) | Visits outside the UK 891eb863 | 2022-08-08 | Bambos Charalambous uk.org.publicwhip/person/25676 | 3 | 2022-08-08-891eb863-25676-0 | |
4d6929177899bfb746a0cf6ca593d3466aa46b2e | Name of donor: Medical Aid for Palestinians Address of donor: 33a Islington Park Street, London N1 1QB Estimate of the probable value (or amount of any donation): Flights, accommodation, food and transport, total value of £1,451 Destination of visit: Occupied Palestinian Territory and Israel Dates of visit: 22-27 May 2022 Purpose of visit: Fact-finding visit organised by the Council for Arab-British Understanding and Medical Aid for Palestinians. (Registered 20 June 2022) | Visits outside the UK 891eb863 | 2022-08-08 | Bambos Charalambous uk.org.publicwhip/person/25676 | 4 | 2022-08-08-891eb863-25676-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");