home / regmem

Menu
  • GraphQL API

items

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

✎ 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
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

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 22.836ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette