items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2016-09-05-891eb863-13934-0" sorted by hash
This data as json, CSV (advanced)
Suggested facets: date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
05d456b4a02d14a66c65d70bd12d0183effd221d | Name of donor: Indian National Bar Association (INBA) Address of donor: 8/11, First Floor, Jungpura Extension, New Delhi - 110014 Amount of donation (or estimate of the probable value): air tickets £559.28, accommodation, meal and other local travel expenses, £197.33; total £756.61 Destination of visit: New Delhi Date of visit: 24-30 November 2015 Purpose of visit: to attend INBA international conference as a "Guest of Honour" and to improve the Indo-British bilateral relationship. (Registered 07 January 2016) | Visits outside the UK 891eb863 | 2016-09-05 | Virendra Sharma uk.org.publicwhip/person/13934 | 2 | 2016-09-05-891eb863-13934-0 | |
16647feb865456176c6e3fa9ea96348800e0911f | Name of donor: Results UK Address of donor: 31-33 Bondway, London SW8 1SJ Amount of donation (or estimate of the probable value): flights £800, accommodation £700 and travel £240, total value £1,740 Destination of visit: India; Delhi, Uttar Pradesh, Rajasthan Date of visit: 14-21 February 2016 Purpose of visit: to explore development programmes contributing to improved nutrition and health of women and children, and challenges to be addressed for further progress. (Registered 09 March 2016) | Visits outside the UK 891eb863 | 2016-09-05 | Virendra Sharma uk.org.publicwhip/person/13934 | 3 | 2016-09-05-891eb863-13934-0 | |
21a639e7f4ba5dda0ffda24faf49461e244025d8 | Name of donor: Results UK Address of donor: 31-33 Bondway, London SW8 1SJ Amount of donation (or estimate of the probable value): flights, Delhi to Capetown return £930, hotel, four nights £720, food and extras approx. £100; total £1,750 Destination of visit: Cape Town Date of visit: 30 November - 4 December 2015 Purpose of visit: attending the 46th Union World Conference on Lung Health, with a focus on TB. (Registered 16 December 2015) | Visits outside the UK 891eb863 | 2016-09-05 | Virendra Sharma uk.org.publicwhip/person/13934 | 1 | 2016-09-05-891eb863-13934-0 | |
3487bfe59e4cf3fc2b052d0aec412a0d23ca2782 | Name of donor: European Parliamentary Forum on Population and Development (EPF) Address of donor: 23 Rue Montover, 1000 Brussels, Belgium Amount of donation (or estimate of the probable value): flights £166; accommodation £552; travel £38; per diems £159; total value £915 Destination of visit: Copenhagen Date of visit: 16-20 May 2016 Purpose of visit: to attend the Women Deliver Conference. (Registered 25 May 2016) | Visits outside the UK 891eb863 | 2016-09-05 | Virendra Sharma uk.org.publicwhip/person/13934 | 4 | 2016-09-05-891eb863-13934-0 | |
a67f12007dc9e1421583309776800526801a8a82 | Name of donor: (1) European Parliamentary Forum on Population and Development (EPF) (2) Qatar Airways Address of donor: (1) 23 Rue Montover, 1000 Brussels, Belgium (2) London Heathrow Airport Office, Room 6204, Departures Mezzanine, Terminal 4, Heathrow Airport TW6 3FB Amount of donation (or estimate of the probable value): (1) flights £500, hotels including breakfast £780, airport transfers £30, internal travel, food and incidentals £395; total £1,705 (2) business class upgrades on both international flights; approx. value £2,000 Destination of visit: Sri Lanka: Colombo, Kandy, Nuwera Eliya, Batticaloa, Badulla and Trincomalee. Date of visit: 10–17 November 2015 Purpose of visit: UK All Party Parliamentary Group on Population, Development and Reproductive Health organised the study tour to introduce and strengthen UK MPs understanding of core family planning, sexual and reproductive health and rights and International Development issues. (Registered 16 December 2015) | Visits outside the UK 891eb863 | 2016-09-05 | Virendra Sharma uk.org.publicwhip/person/13934 | 0 | 2016-09-05-891eb863-13934-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");