items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2019-08-12-891eb863-11093-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 |
|---|---|---|---|---|---|---|---|
| 2a8b5755b9815d7ae1d0a493e4ba20aa95f5413f | Name of donor: (1) Prince Albert II of Monaco Foundation (2) Mamont Foundation (3) WWF UK (4) British Group Inter-Parliamentary Union, all via the APPG for the Polar Regions. Address of donor: (1) Villa Girasole, 16 Boulevard de Suisse, 98000, Monaco (2) PO Box 472, St Julian’s Court, St Julian’s Avenue, St Peter Port, GY1 6AX, Guernsey, Channel Islands (3) The Living Planet Centre, Rufford House, Brewery Rd, Woking GU21 4LL (4) 6th Floor, Millbank House, 1 Millbank, Westminster, London SW1P 4RP Estimate of the probable value (or amount of any donation): (1) £1,021.59 (2) £970.30 (3) £204.32 (4) £510.79 The APPG for the Polar Regions used these sums to meet the costs of flights, local travel, food, accommodation and tour fees, which together had a total value of approximately £2,707, after a personal contribution of £200. Destination of visit: Greenland Dates of visit: 24 – 30 August 2018 Purpose of visit: To establish and develop dialogue with the Parliament and Government of Greenland; promote awareness and understanding among UK Parliamentarians of challenges and opportunities facing Greenland as a consequence of environmental, geopolitical and economic change; to visit British scientists and learn more about Britain’s contribution to Arctic science. (Registered 11 September 2018) | Visits outside the UK 891eb863 | 2019-08-12 | John Mann uk.org.publicwhip/person/11093 | 0 | 2019-08-12-891eb863-11093-0 | |
| ab8b852bf180f831baea67d844804eae76adf54e | Name of donor: The Antisemitism Policy Trust Address of donor: BM 5369, London WC1N 3XX Estimate of the probable value (or amount of any donation): Flight and travels costs £1,083; accommodation and food £835; total £1,918 Destination of visit: Washington and New York Dates of visit: 12-14 September 2018 Purpose of visit: Delegation of MPs with the APPG Against Antisemitism to visit Washington and New York for meetings with social media companies and officials about antisemitism. (Registered 18 September 2018) | Visits outside the UK 891eb863 | 2019-08-12 | John Mann uk.org.publicwhip/person/11093 | 1 | 2019-08-12-891eb863-11093-0 | |
| 6c9cce16d7f98fff4e4a43b96855da06c1ab0210 | Name of donor: The Antisemitism Policy Trust Address of donor: Antisemitism Policy Trust, BM 5369, London WC1N 3XX Estimate of the probable value (or amount of any donation): flight and accommodation costing £955 Destination of visit: Germany Dates of visit: 24-27 September 2018 Purpose of visit: To meet with football clubs to discuss antisemitism and racism in football. (Registered 18 October 2018) | Visits outside the UK 891eb863 | 2019-08-12 | John Mann uk.org.publicwhip/person/11093 | 2 | 2019-08-12-891eb863-11093-0 | |
| 4ee7615c55b44a4b9babcec46dbb2b306b694993 | Name of donor: The American Jewish Congress Address of donor: 165 East 56th Street, New York, New York 10022, United States of America Estimate of the probable value (or amount of any donation): flights, hotel and other travel with a value of £3,528 Destination of visit: Washington DC, USA Dates of visit: 2 to 4 June 2019 Purpose of visit: speaker on a panel at the international AJC conference on anti-semitism. (Registered 14 June 2019) | Visits outside the UK 891eb863 | 2019-08-12 | John Mann uk.org.publicwhip/person/11093 | 3 | 2019-08-12-891eb863-11093-0 | |
| f00d73259ea5cf8a4a5f8bee4151b278e95f74fb | Name of donor: European Population Forum Address of donor: Rue Montoyer 23, Brussels, Belgium Estimate of the probable value (or amount of any donation): Flights, food, accommodation and local transport, total value £2,058 Destination of visit: Zambia Dates of visit: 23-26 June 2019 Purpose of visit: Parliamentary delegation to Zambian Parliamentary Assembly. (Registered 09 August 2019) | Visits outside the UK 891eb863 | 2019-08-12 | John Mann uk.org.publicwhip/person/11093 | 4 | 2019-08-12-891eb863-11093-0 | |
| 85da22e4ba735a24deb09e433e15863879825497 | Name of donor: European Population Forum Address of donor: Rue Montoyer 23, Brussels, Belgium Estimate of the probable value (or amount of any donation): Rail fare, value £157 Destination of visit: Brussels Date of visit: 8 July 2019 Purpose of visit: Executive meeting. (Registered 09 August 2019) | Visits outside the UK 891eb863 | 2019-08-12 | John Mann uk.org.publicwhip/person/11093 | 5 | 2019-08-12-891eb863-11093-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");