items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2023-10-30-891eb863-25642-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 |
|---|---|---|---|---|---|---|---|
| d5ea36fff464ac821bf903e94049e62128e49113 | Name of donor: FIA Foundation Address of donor: 60 Trafalgar Square, London WC2N 5DS Estimate of the probable value (or amount of any donation): £3,108.31 reimbursement for flights received on 23 June 2023, and £1,138.52 received on 11 August 2023 as reimbursement for five nights' hotel accommodation (13-18 July 2023) in New York, total value £4,246.83 Destination of visit: New York and Washington Dates of visit: 13-20 July 2023 Purpose of visit: As President of the Forum of Young Parliamentarians at the Inter-Parliamentary Union, to attend the United Nations High Level Political Forum and to meet with Members of the United States Senate and Congress. (Registered 17 August 2023; updated 23 August 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Dan Carden uk.org.publicwhip/person/25642 | 0 | 2023-10-30-891eb863-25642-0 | |
| 3d0c2085c959dbd0c1c229b4cdd31b5153617ed5 | Name of donor: Mrs. Pikulkeaw Krairiksh, Member of the Senate of Thailand Address of donor: private Estimate of the probable value (or amount of any donation): Accommodation, food and transport in Bangkok, estimated value £443 Destination of visit: Bangkok, Thailand Dates of visit: 19-24 September 2023 Purpose of visit: As President of the Forum of Young Parliamentarians at the Inter Parliamentary Union, to attend meetings at the House of Representatives of Thailand and other political, cultural and social events. (Registered 20 October 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Dan Carden uk.org.publicwhip/person/25642 | 1 | 2023-10-30-891eb863-25642-0 | |
| ba71ca2360621d9a08e74c69f18c1eb7e71c0a78 | Name of donor: United Arab Emirates, Federal National Council Address of donor: Abu Dhabi, P.O. Box 836, UAE Estimate of the probable value (or amount of any donation): Flights to and from the UAE, hotel accommodation, food and in-country transport, estimated value £6,220 Destination of visit: Abu Dhabi and Dubai, United Arab Emirates Dates of visit: 27 September - 3 October 2023 Purpose of visit: As President of the Forum of Young Parliamentarians at the Inter Parliamentary Union, to attend Climate Future Week events, meet with members of the Federal National Council, and develop plans for the engagement of young parliamentarians at COP28 UAE. (Registered 30 October 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Dan Carden uk.org.publicwhip/person/25642 | 2 | 2023-10-30-891eb863-25642-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");