items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2017-10-09-891eb863-10648-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| abb29d2ddb16ec353b3f8a8c438387251ef8a2b6 | Name of donor: HM Government of Gibraltar Address of donor: Gibraltar House, 150 Strand, London WC2R 1JA Estimate of the probable value (or amount of any donation): Flight, hotel and accommodation with an estimated value of £1,296 Destination of visit: Gibraltar Dates of visit: 8-10 September 2016 Purpose of visit: Invited by HM Government of Gibraltar for National Day celebrations. (Registered 23 November 2016) | Visits outside the UK 891eb863 | 2017-10-09 | Rosie Winterton uk.org.publicwhip/person/10648 | 0 | 2017-10-09-891eb863-10648-0 | |
| ba1517169f0e367a4212d8cee3197cd398184fbd | Name of donor: (1) Kar Group (2) Kurdistan Regional Government Address of donor: (1) Apartment 8, 1st Floor, Building J, Naz City, Erbil, Iraq (2) KRG UK Representation, 23 Buckingham Gate, London SW1E 6LB Estimate of the probable value (or amount of any donation): (1) Flights and hotel with a value of £3,400 (2) Internal security and transport with a value of £516 Destination of visit: Erbil, Slemani and Mosul, Kurdistan Region of Iraq Dates of visit: 3-9 November 2016 Purpose of visit: to meet senior political leaders including the Prime Minister, Ministers, the UK acting Consul-General, also the Iraqi Army and the Peshmerga, and to visit camps for internally displaced people. (Registered 23 November 2016) | Visits outside the UK 891eb863 | 2017-10-09 | Rosie Winterton uk.org.publicwhip/person/10648 | 1 | 2017-10-09-891eb863-10648-0 | |
| 5e8e340fe1c3c234661fc7b445f5027fd90362bc | Name of donor: (1) Labour Friends of Israel (2) Israeli Ministry of Foreign Affairs Address of donor: (1) BM LFI, London WC1N 3XX (2) 9 Yitzhak Rabin Blvd., Kiryat Ben-Gurion, Jerusalem 9103001 Estimate of the probable value (or amount of any donation): (1) Travel and accommodation with a value of £1,500 (2) Hospitality with a value of £125. Destination of visit: Israel and the Palestinian Territories Dates of visit: 14-17 November 2016 Purpose of visit: Fact finding visit. Meeting with Israeli and Palestinian co-existence campaigners, politicians, academics, journalists and diplomats. (Registered 28 November 2016) | Visits outside the UK 891eb863 | 2017-10-09 | Rosie Winterton uk.org.publicwhip/person/10648 | 2 | 2017-10-09-891eb863-10648-0 | |
| 36a690d5be9d3a74e38a542f8a6360752ba57833 | Name of donor: Labour Friends of Bangladesh Address of donor: 349 Cambridge Heath Road, London E2 9RA Estimate of the probable value (or amount of any donation): Flights, hotels and internal transport with an estimated value of £2,500 Destination of visit: Dhaka and Sylhet, Bangladesh Date of visit: 11 to 17 February 2017 Purpose of visit: Meetings with representatives of Bangladesh government and opposition leaders, meetings at Bangladesh Parliament, meetings with charitable organisations and British/Bangladeshi business organisations (Registered 24 February 2017) | Visits outside the UK 891eb863 | 2017-10-09 | Rosie Winterton uk.org.publicwhip/person/10648 | 3 | 2017-10-09-891eb863-10648-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");