items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2023-10-30-891eb863-25649-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 |
|---|---|---|---|---|---|---|---|
| fa0aa86352aa455d08e4934c3b1ffea185ae28b2 | Name of donor: Speaker's Office, Government of Pakistan Address of donor: Constitution Avenue, G-5/2 Islamabad, Pakistan Estimate of the probable value (or amount of any donation): Return flights to Pakistan (£941.46) and three nights' full board accommodation (£286.53), total value £1,227.99 Destination of visit: Islamabad, Pakistan Dates of visit: 5-13 May 2023 Purpose of visit: Pakistan 1973 Constitution Golden Jubilee Celebration. (Registered 05 June 2023; updated 23 June 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Mohammad Yasin uk.org.publicwhip/person/25649 | 0 | 2023-10-30-891eb863-25649-0 | |
| fd0e2998793aad25917e6cf377217f4a29d6abfb | Name of donor: Ministry of Foreign Affairs of the State of Qatar Address of donor: Ministry of Foreign Affairs, Almirqab Tower, West Bay, Doha, Qatar Estimate of the probable value (or amount of any donation): Return flights, accommodation and food, estimated value £6,872 Destination of visit: Doha, Qatar Dates of visit: 19-23 September 2023 Purpose of visit: Qatar APPG visit to meet with ministers, the Shura Council and senior local and international stakeholders in international development to explore ways of enhancing UK-Qatar cooperation on global development and aid. (Registered 16 October 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Mohammad Yasin uk.org.publicwhip/person/25649 | 1 | 2023-10-30-891eb863-25649-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");