items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2020-05-26-891eb863-10009-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 |
---|---|---|---|---|---|---|---|
59c7c0a03ea024df3981132b71149edbfc868184 | Name of donor: Hadi Saidi Address of donor: private Estimate of the probable value (or amount of any donation): Travel and accommodation with a value of £340 Destination of visit: Albania Dates of visit: 13-14 July 2019 Purpose of visit: To speak at NCRI International Conference. (Registered 30 July 2019) | Visits outside the UK 891eb863 | 2020-05-26 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2020-05-26-891eb863-10009-0 | |
550b6d3eb872a6c004fd9c06738fa4c98625a7cf | Name of donor: Yunus Emre Enstitüsü (Yunus Emre Institute) & ITSEB Turkish Speaking Health Professionals in the UK Address of donor: 10 Maple Street, London W1T 5HA Estimate of the probable value (or amount of any donation): Travel and accommodation with a value of £2,553 Destination of visit: Turkey Dates of visit: 4-11 August 2019 Purpose of visit: Delegation of Conservative MPs to see the conditions of Syrian refugee camps and meet key officials, ministers, governors and mayors, also to visit the Turkish Grand National Assembly and trade and industry chambers. (Registered 23 August 2019) | Visits outside the UK 891eb863 | 2020-05-26 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2020-05-26-891eb863-10009-0 | |
f39a2fcdb8a3653384ff12ef1ad117e7fb09fc05 | Name of donor: Ministry of Foreign Affairs, Qatar Address of donor: Qatar Embassy, 1 South Audley St, London W1K 1NB Estimate of the probable value (or amount of any donation): Flights and accommodation for six nights, total value £4,100 Destination of visit: Qatar Dates of visit: 15-20 February 2020 Purpose of visit: British-Qatar APPG visit to meet Ministers and officials, discuss the Gulf Cooperation Council crisis, Workers’ rights, bilateral relations and regional issues. (Registered 27 March 2020) | Visits outside the UK 891eb863 | 2020-05-26 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2020-05-26-891eb863-10009-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");