items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2019-10-21-891eb863-10040-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 |
|---|---|---|---|---|---|---|---|
| d1f25bd3b5ba4595587652643d1a8565639c1a6a | Name of donor: University of Essex Address of donor: Wivenhoe Park, Colchester, CO4 3SQ Estimate of the probable value (or amount of any donation): airfare, accommodation, transport and hospitality, with a total value of approximately £6,100 Destination of visit: Hong Kong Dates of visit: 24-28 September 2018 Purpose of visit: Visit as Chancellor of the University of Essex. (Registered 12 October 2018) | Visits outside the UK 891eb863 | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 0 | 2019-10-21-891eb863-10040-0 | |
| e7c63ef50252af298fd9260b2f390e8751b641ac | Name of donor: Autonomous Province of Trento Address of donor: Piazza Dante 15, 38121 Trento, Italy Estimate of the probable value (or amount of any donation): travel, hotel accommodation and meals to a total value of £1,069 Destination of visit: Trento, Italy Dates of visit: 31 May 2019 to 2 June 2019 Purpose of visit: to attend the Festival of Economics in Trento. (Registered 12 June 2019) | Visits outside the UK 891eb863 | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 1 | 2019-10-21-891eb863-10040-0 | |
| ddf9e62dcf85a7006168266d11dd5ad30f842653 | Name of donor: (1) Dominion Energy Corporate; (2) the American Evolution Address of donor: (1) 120 Tredegar St, Richmond, VA, 23219, USA; (2), 2019 Commemoration, P.O. Box 1607, Williamsburg, VA 23187, USA. Estimate of the probable value (or amount of any donation): (1) transportation by helicopter from Reagan International Airport to Richmond, VA, value £554.26; (2) hotel accommodation and meals, value £287.72 Destination of visit: Richmond, Virginia, USA Dates of visit: 28 -29 May 2019 Purpose of visit: to commemorate the 400th anniversary of the first representative legislature in the New World. (Registered 12 June 2019) | Visits outside the UK 891eb863 | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 2 | 2019-10-21-891eb863-10040-0 | |
| d49c5247748b508a161ba70efa0967cf19e1b1ae | Name of donor: Exane BNP Paribas Address of donor: 1 Hanover St, London W1S 1YZ Estimate of the probable value (or amount of any donation): accommodation, travel and hospitality valued at £1,366.56 Destination of visit: Paris Dates of visit: 13 to 14 June 2019 Purpose of visit: to deliver a talk at the Exane CEO conference and to meet French politicians and the deputy governor of the Bank of France. (Registered 20 June 2019) | Visits outside the UK 891eb863 | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 3 | 2019-10-21-891eb863-10040-0 | |
| 828488c5f11fcbb8f175c7946a6325da5706d2ea | Name of donor: Zurich University Address of donor: Hirschengraben 56, 8001 Switzerland Estimate of the probable value (or amount of any donation): Accommodation, travel and hospitality with a total value of £2,082.51 Destination of visit: Zurich, Switzerland Dates of visit: 19-22 September 2019 Purpose of visit: To deliver a speech on my role as Speaker to the Churchill Europe Symposium, and to meet Swiss politicians. (Registered 01 October 2019) | Visits outside the UK 891eb863 | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 4 | 2019-10-21-891eb863-10040-0 | |
| 3915cc77f1985334e86c31cf3b0c0b6e8ee0b711 | Name of donor: (1) New York University; (2) Harvard Kennedy School, Harvard University; Address of donor: (1) 20 Cooper Square, 7th Floor ,New York; (2) 79 John F. Kennedy Street, Cambridge, Boston, Mass. Estimate of the probable value (or amount of any donation): (1) Hospitality valued at £95; (2) Hospitality valued at £430 Destination of visit: New York and Boston, Massachusetts Dates of visit: (1) 15-16 September 2019; (2) 16-18 September 2019 Purpose of visit: To deliver speeches on my role as Speaker to NYU’s Journalism Institute and to the Harvard Kennedy School. (Registered 01 October 2019) | Visits outside the UK 891eb863 | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 5 | 2019-10-21-891eb863-10040-0 | |
| 1508a51be8adaa0331ddb75128c9fdd98eb2a674 | Name of donor: Pilotstudio Address of donor: Pilotenstraat 21, 1059 Amsterdam Estimate of the probable value (or amount of any donation): Hotel accommodation, travel and other hospitality in Amsterdam for myself and my wife, estimated value £2,516 Destination of visit: Jinek, Amsterdam Dates of visit: 27-29 September 2019 Purpose of visit: To appear on the talk show Jinek to discuss my role as Speaker and the work of Parliament. (Registered 11 October 2019) | Visits outside the UK 891eb863 | 2019-10-21 | John Bercow uk.org.publicwhip/person/10040 | 6 | 2019-10-21-891eb863-10040-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");