items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2017-02-06-891eb863-10001-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 |
---|---|---|---|---|---|---|---|
fdaaafa100dc443ed0dd7194cfc5d5a8a827b694 | Name of donor: Muslim Charities Forum Address of donor: 6 Whitehorse Mews, 37 Westminster Bridge Road, London SE1 7QD Amount of donation (or estimate of the probable value): for a member of staff and myself, return flights to Nairobi £5,170; one night's accommodation in Hargeisa £107.57; one night's accommodation in Borama £36.21; total £5,313.78 Destination of visit: Somaliland Date of visit: 7-10 April 2016 Purpose of visit: to visit the different refugee camps and charities (development) in regards to the severe drought in Somaliland. (Registered 18 May 2016) | Visits outside the UK 891eb863 | 2017-02-06 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2017-02-06-891eb863-10001-0 | |
0270324105ff5821dca857a57615ce2853f047bc | Name of donor: British-Swiss Chamber of Commerce Address of donor: Bleicherweg, 128002, Zurich, Switzerland Amount of donation (or estimate of the probable value): flights £200.14; one night's accommodation £177, train fare Geneva to Zurich £110; total £487.14 Destination of visit: Geneva and Zurich, Switzerland Date of visit: 28-29 April 2016 Purpose of visit: to participate in a public panel discussion in Geneva in front of British-Swiss Chamber of Commerce, its members and guests. (Registered 18 May 2016) | Visits outside the UK 891eb863 | 2017-02-06 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2017-02-06-891eb863-10001-0 | |
872af48971cffd9b6b94506dddf94cd1f3d21ad2 | Name of donor: Oxford and Cambridge Club of Nigeria Address of donor: Secretariat 5th Floor, 72 Broad Street, Lagos, Nigeria Amount of donation (or estimate of the probable value): for myself and a member of staff, accommodation, breakfast and dinner £1,155.88 plus flights at an estimated value of £1,405, total £2,560.88 Destination of visit: Nigeria Date of visit: 29 May - 2 June 2016 Purpose of visit: to deliver speech on education and visit education and maternal health development projects. (Registered 27 June 2016) | Visits outside the UK 891eb863 | 2017-02-06 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2017-02-06-891eb863-10001-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");