items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2023-10-30-891eb863-11817-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 |
|---|---|---|---|---|---|---|---|
| d9bda6b29db1449a350073107ec6d3cc90b0891d | Name of donor: Falkland Islands Government Address of donor: The Secretariat, Thatcher Drive, Stanley, Falkland Islands FIQQ 1ZZ Estimate of the probable value (or amount of any donation): Flights and travel (£1,985.72), accommodation (£1,482.47), dinners/hospitality/gifts (£474.51), total value £3,942.70 Destination of visit: Falkland Islands Dates of visit: 17-25 November 2022 Purpose of visit: Falkland Islands All-Party Parliamentary Group visit as guests of the Falkland Islands Government to mark the 40th anniversary of the liberation of the Falkland Islands. (Registered 14 December 2022) | Visits outside the UK 891eb863 | 2023-10-30 | Daniel Kawczynski uk.org.publicwhip/person/11817 | 0 | 2023-10-30-891eb863-11817-0 | |
| 3d1771ac0c1cfb1e873687e593666c0cf6ca75c0 | Name of donor: Wightman International Limited Address of donor: 8th Floor, Reading Bridge House, George Street, Reading RG1 8LS Estimate of the probable value (or amount of any donation): Flights, accommodation meals and transport for myself and a member of staff, total value £4,375.72 Destination of visit: Washington DC and Danville, Virginia, USA Dates of visit: 19-22 February 2023 Purpose of visit: To learn about why the city of Danville in Virginia has been revitalised from foreign direct investment, and how it is addressing the shortage in manufacturing skills needed for the defence industry. My member of staff accompanied me to coordinate logistics and to take notes to produce a report about our visit. (Registered 16 March 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Daniel Kawczynski uk.org.publicwhip/person/11817 | 1 | 2023-10-30-891eb863-11817-0 | |
| c49703dba86168299e72b63d9301834608082aba | Name of donor: Government of the Republic of Kazakhstan via the Embassy of the Republic of Kazakhstan to the Court of St James's Address of donor: Embassy of Kazakhstan, 125 Pall Mall Street, London SW1Y 5EA Estimate of the probable value (or amount of any donation): Flights (£4,500), accommodation (£400) and food (£200), total value £5,100 Destination of visit: Astana, Kazakhstan Dates of visit: 17-20 March 2023 Purpose of visit: Invited by the Government of Kazakhstan to observe the country's legislative election which took place on Sunday 19 March 2023. (Registered 05 April 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Daniel Kawczynski uk.org.publicwhip/person/11817 | 2 | 2023-10-30-891eb863-11817-0 | |
| 562b2df6cb8a661144546777d44a75ae2ef72d67 | Name of donor: Embassy of the Republic of Poland, Greece Address of donor: 22, Chryssanthemon Str., 154 52 Paleo Psychiko, Athens Estimate of the probable value (or amount of any donation): Hotel (£400) and flight (£305), total value £705 Destination of visit: Athens, Greece Dates of visit: 12-14 June 2023 Purpose of visit: Participation in a conference, Post-conflict justice: opening legal paths. (Registered 04 July 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Daniel Kawczynski uk.org.publicwhip/person/11817 | 3 | 2023-10-30-891eb863-11817-0 | |
| 4801ece7eea9a74b338a57e1cadb146d008ecb22 | Name of donor: The Government of St Kitts and Nevis Address of donor: Government Headquarters, Church Street, Basseterre, St Kitts and Nevis Estimate of the probable value (or amount of any donation): Flights (£3,100), accommodation (£3,719.27), meals (£1,456.76) for me and a member of staff, total value £8,276.03 Destination of visit: St Kitts and Nevis Dates of visit: 26 August - 2 September 2023 Purpose of visit: Invited in my capacity as Chair of the APPG on St Kitts and Nevis by the Government of St Kitts and Nevis to visit the country to strengthen bilateral relations and to explore trade and investment opportunities. (Registered 13 September 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Daniel Kawczynski uk.org.publicwhip/person/11817 | 4 | 2023-10-30-891eb863-11817-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");