items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2019-01-07-891eb863-13934-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 |
---|---|---|---|---|---|---|---|
053798ee548bae4164b3d3d59502b4781cfa3d7a | Name of donor: (1) Results UK (2) Indian Government Address of donor: (1) 31-33 Bondway, London SW8 1SJ (2) India House, Aldwych, London WC2B 4NA Estimate of the probable value (or amount of any donation): (1) Per diems of £1,397.28 in total, paid for 3-8 January 2018 at UK Government daily subsistence rates. (2) Flights with a value of £5,990.51, plus hospitality, transport and accommodation worth £1,000, £6,990.51 in total. Destination of visit: New Delhi, India Dates of visit: 2-13 January 2018 Purpose of visit: (1) 3-8 January 2018, meeting with Indian Politicians and NGOs regarding TB and the India TB Caucus Co-chairs on behalf of and with Results UK. (2) 8-10 January 2018, attending the PIO Parliamentarians Conference, which brings together Parliamentarians of Indian origin from across the world to network and discuss global and parliamentary issues. (Registered 05 February 2018; updated 13 February 2018) | Visits outside the UK 891eb863 | 2019-01-07 | Virendra Sharma uk.org.publicwhip/person/13934 | 0 | 2019-01-07-891eb863-13934-0 | |
d1bef20a55b919e9a494d3804971dcf17ac4f6cd | Name of donor: Global TB Caucus Address of donor: 31-33 Bondway, London SW8 1SJ Estimate of the probable value (or amount of any donation): Flights £437.65; hotel: £775.66; per diem £154.30; total £1,367.61 Destination of visit: New York, USA Dates of visit: 24-28 April 2018 Purpose of visit: Attendance at Parliamentary Consultation on the UN High Level Meeting on TB. (Registered 03 October 2018) | Visits outside the UK 891eb863 | 2019-01-07 | Virendra Sharma uk.org.publicwhip/person/13934 | 1 | 2019-01-07-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");