items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2019-09-30-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 |
|---|---|---|---|---|---|---|---|
| 12e6e9800663e156f51247e4541e40461517b024 | 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-09-30 | John Bercow uk.org.publicwhip/person/10040 | 0 | 2019-09-30-891eb863-10040-0 | |
| 4269a43bda36e6176042fd7631c3b180577e7b20 | 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-09-30 | John Bercow uk.org.publicwhip/person/10040 | 1 | 2019-09-30-891eb863-10040-0 | |
| cc159c6b11ba6c9a57a2dc8ea6e6acd4d8a74d6e | 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-09-30 | John Bercow uk.org.publicwhip/person/10040 | 2 | 2019-09-30-891eb863-10040-0 | |
| 21ea4065f9ff9c282797a99f5a58c844ec53384f | 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-09-30 | John Bercow uk.org.publicwhip/person/10040 | 3 | 2019-09-30-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");