home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for 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

✎ View and edit SQL

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

CSV options:

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");
Powered by Datasette · Queries took 73.142ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette