items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2018-02-05-891eb863-25628-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 |
---|---|---|---|---|---|---|---|
370a0e25350b7270a60ee0f0fb3fa20707a75ecf | Name of donor: Conservative Middle East Council Address of donor: 55 Tufton Street, London SW1P 3QL Estimate of the probable value (or amount of any donation): Accommodation, food and transport with a total value of £1,079 Destination of visit: Sicily Dates of visit: 29 August – 1 September 2017 Purpose of visit: To meet NGOs involved in migrant rescue in the Mediterranean, visit migrant camps and understand the ongoing Mediterranean migrant crisis. (Registered 12 September 2017) | Visits outside the UK 891eb863 | 2018-02-05 | Leo Docherty uk.org.publicwhip/person/25628 | 0 | 2018-02-05-891eb863-25628-0 | |
08b902f769a2b494c121c02999dcd8ec5a96420c | Name of donor: Kingdom of Saudi Arabia Ministry of Foreign Affairs Address of donor: Al Washm Street, Namudhajiyah Riyadh 12735, Saudi Arabia Estimate of the probable value (or amount of any donation): flights, transport, food and accommodation with a value of £7,800 Destination of visit: Riyadh and Jeddah, Saudi Arabia Dates of visit: 24-29 September 2017 Purpose of visit: to meet with HM King Salman Abdulaziz Ibn Saud, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Saudi bilateral relationship. (Registered 12 October 2017) | Visits outside the UK 891eb863 | 2018-02-05 | Leo Docherty uk.org.publicwhip/person/25628 | 1 | 2018-02-05-891eb863-25628-0 | |
5c1f838fe1438704056d187d3857da64c009d15b | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-02-05 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-02-05-891eb863-25628-0 | |
5cde64087844acdfebe9ddd0101d9a14f52a076c | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: P.O. Box 547, Government Road, Manama, Kingdom of Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £3,250 Destination of visit: Bahrain Dates of visit: 7-11 December 2017 Purpose of visit: Parliamentary delegation, with the Conservative Middle East Council, to the IISS Manama Dialogue 2017 in order to gain a deeper understanding of the strategic links between the Kingdom of Bahrain and the wider Gulf States and the UK. (Registered 13 December 2017) | Visits outside the UK 891eb863 | 2018-02-05 | Leo Docherty uk.org.publicwhip/person/25628 | 3 | 2018-02-05-891eb863-25628-0 | |
f524cb20b4d19c51aba5aef2fe32a915643d30f8 | Name of donor: Ministry of Defence, Kingdom of Saudi Arabia Address of donor: Riyadh, Postal Code 111165, Kingdom of Saudi Arabia Estimate of the probable value (or amount of any donation): flights, accommodation, internal transport and food at a total value of £8,257 Destination of visit: Riyadh and Saudi/Yemen border region Dates of visit: 11-15 January 2018 Purpose of visit: Parliamentary delegation to see impact of ballistic missile strikes in the Saudi/Yemen border region and gain a deeper understanding of the strategic importance of the Coalition operations in Yemen. (Registered 24 January 2018) | Visits outside the UK 891eb863 | 2018-02-05 | Leo Docherty uk.org.publicwhip/person/25628 | 4 | 2018-02-05-891eb863-25628-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");