items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2019-09-16-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 |
---|---|---|---|---|---|---|---|
50e57ce3e1c4eaf5dbe445ceb55d1c6a81862445 | Name of donor: Election Commission of the Maldives Address of donor: 5th Floor, Ports Complex, Hilaalee Magu, Malé, Rep of Maldives Estimate of the probable value (or amount of any donation): Travel and accommodation with a value of £5,275.66 Destination of visit: Maldives Dates of visit: 21-28 August 2018 Purpose of visit: To observe preparations for the Presidential Election due to be held on 23 September 2018. (Registered 12 September 2018) | Visits outside the UK 891eb863 | 2019-09-16 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2019-09-16-891eb863-10009-0 | |
c4250420af3901578e23ed841aaee5042048615f | 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 | 2019-09-16 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2019-09-16-891eb863-10009-0 | |
5db944b30f0aa88c1cd147d85651bd9f12a0cc8a | 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 | 2019-09-16 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2019-09-16-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");