items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2018-12-17-891eb863-11087-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
79adc739484a0dbabc16880f341a8a405122848c | Name of donor: Council For Moroccans Abroad (CCME) Address of donor: Mahaj. Imm. 10. BP21481, Hay Ryad, Rabat 10 000 Estimate of the probable value (or amount of any donation): Return flights and hotel accommodation with a value of approx £650 Destination of visit: Rabat, Morocco Dates of visit: 14-17 December 2017 Purpose of visit: to build relationships with the Moroccan Parliament and with the Moroccan diaspora in the UK. (Registered 22 January 2018) | Visits outside the UK 891eb863 | 2018-12-17 | Khalid Mahmood uk.org.publicwhip/person/11087 | 0 | 2018-12-17-891eb863-11087-0 | |
523ab8da1d5a15621a0b12e9c83dc1325a85cb77 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Estimate of the probable value (or amount of any donation): Travel and accommodation with a value of £3,800 Destination of visit: United Arab Emirates Dates of visit: 10-16 February 2018 Purpose of visit: United Arab Emirates APPG visit to attend the World Government Summit, meet with Government Ministers, Members of the Federal National Council and senior business figures, in order to build on the bilateral relationship. (Registered 06 March 2018) | Visits outside the UK 891eb863 | 2018-12-17 | Khalid Mahmood uk.org.publicwhip/person/11087 | 1 | 2018-12-17-891eb863-11087-0 | |
b0e9695b32158160e1ba7fc39ddd9e685bd4a7bb | Name of donor: Bahrain Embassy Address of donor: 2 Upper Brook St, London W1K 6PA Estimate of the probable value (or amount of any donation): Travel and accommodation with a value of £2,800 Destination of visit: Kingdom of Bahrain Dates of visit: 5-7 April 2018 Purpose of visit: To attend the opening of the UK/Bahrain Naval base, meet with Government Ministers, Members of the Federal National Council and senior business figures, in order to build on the bilateral relationship. (Registered 08 May 2018) | Visits outside the UK 891eb863 | 2018-12-17 | Khalid Mahmood uk.org.publicwhip/person/11087 | 2 | 2018-12-17-891eb863-11087-0 | |
94f3db573ff156f900fadda74dcb57abd9ee875c | Name of donor: Federation of European Progressive Studies Address of donor: Rue Montoyer, 40 B-1000 Brussels, Belgium Estimate of the probable value (or amount of any donation): Hotel and airport transfer, total value £156.78. Other costs were met by a non-registrable source. Destination of visit: Macedonia Dates of visit: 20-22 September 2018 Purpose of visit: To support democratic institutions. (Registered 14 November 2018) | Visits outside the UK 891eb863 | 2018-12-17 | Khalid Mahmood uk.org.publicwhip/person/11087 | 3 | 2018-12-17-891eb863-11087-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");