items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2016-10-17-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 |
---|---|---|---|---|---|---|---|
1ce56a1334da6864fb54facae332baf082f72498 | Name of donor: (1) Stop Aids (2) Aids Alliance Address of donor: (1) Grayston Centre, 28 Charles St, London N1 6HT (2) Preece House, 91-101 Davigdor Rd, Hove BN3 1RE Amount of donation (or estimate of the probable value): for myself and a member of staff, flights £2,784, accommodation £380.52, other travel costs £172, per diems £183; total £3,519.52. These costs were divided equally between both donors. Destination of visit: Uganda Date of visit: 11-14 November 2015 Purpose of visit: to visit the different organisations and charities (development) in regards to AIDS and HIV. (Registered 09 December 2015) | Visits outside the UK 891eb863 | 2016-10-17 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2016-10-17-891eb863-10001-0 | |
45c4374bd5292e6ba5f7db46a746b451532fcd56 | 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 | 2016-10-17 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2016-10-17-891eb863-10001-0 | |
00d0669d310b224b245f3e1fa9718be5641afdc6 | 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 | 2016-10-17 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2016-10-17-891eb863-10001-0 | |
3062d3ca836ad820f6a6dff16c9120f9be52a4a1 | 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 | 2016-10-17 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2016-10-17-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");