items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2019-02-04-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 |
---|---|---|---|---|---|---|---|
76cfe57774a6f0955583a8ec961c353f97c3be50 | 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 | 2019-02-04 | Khalid Mahmood uk.org.publicwhip/person/11087 | 0 | 2019-02-04-891eb863-11087-0 | |
041914927d99a96d16fce6e1d08537ed9374fd49 | 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 | 2019-02-04 | Khalid Mahmood uk.org.publicwhip/person/11087 | 1 | 2019-02-04-891eb863-11087-0 | |
94f429c50eb3ba778f037170f90293cb4ad9acd5 | 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 | 2019-02-04 | Khalid Mahmood uk.org.publicwhip/person/11087 | 2 | 2019-02-04-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");