items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2022-08-08-891eb863-24945-0" sorted by sort_order
This data as json, CSV (advanced)
date (date) 1 ✖
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
3499c8950c430cf86a89977654bd5a45e6b598e1 | Name of donor: (1) Lockheed Martin UK Ltd (2) CAE U.K. Plc Address of donor: (1) Cunard House, 15 Lower Regent Street, London SW1Y 4LR (2) Innovation Drive, Burgess Hill RH15 9TW Estimate of the probable value (or amount of any donation): (1) domestic transport and meals for me and a member of staff to the value of £264 (2) domestic transport and meals for me and a member of staff to the value of £264 Destination of visit: Bosnia and Herzegovina Dates of visit: 28 September - 1 October 2021 Purpose of visit: Parliamentary delegation with the All Party Parliamentary Group for the Armed Forces to meet current politicians from Bosnia and Herzegovina and to learn about the Bosnian War. (Registered 02 November 2021) | Visits outside the UK 891eb863 | 2022-08-08 | Bob Blackman uk.org.publicwhip/person/24945 | 0 | 2022-08-08-891eb863-24945-0 | |
aefdf3f5d71f09032c3f8c2700328b019dece385 | Name of donor: Milli Majlis (National Assembly) Address of donor: Parliament Avenue, 1, Republic of Azerbaijan, Baku City, AZ1152 Estimate of the probable value (or amount of any donation): For me and a member of staff, flights, accommodation, meals and transport, total value £2,006 Destination of visit: Baku, Azerbaijan Dates of visit: 9-13 November 2021 Purpose of visit: As Chairman of the APPG for Azerbaijan, I took a delegation to meet political and parliamentary figures, President Ilham Aliyev, HM Ambassador and business representatives, and visit lands affected by the conflict in Nagorno-Karabakh. (Registered 24 November 2021) | Visits outside the UK 891eb863 | 2022-08-08 | Bob Blackman uk.org.publicwhip/person/24945 | 1 | 2022-08-08-891eb863-24945-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");