items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2022-08-08-891eb863-24920-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
ee84da6c5711d610a5f66d827d6217a44cb154e5 | Name of donor: KAICIID Dialogue Centre Address of donor: Schottenring 21, 1010 Vienna, Austria Estimate of the probable value (or amount of any donation): Flights, three night’s accommodation (19-22 October 2021) and meals with a value of £1,095.15 Destination of visit: Lisbon, Portugal Dates of visit: 19-24 October 2021 Purpose of visit: Invited to attend and speak on a panel, titled ‘Promoting civic participation and inclusive decision-making in European cities’ at KAICIID’s ‘3rd European Policy Dialogue Forum’ and ‘High-Level Dialogue on Social Cohesion’ conferences. (Registered 08 November 2021) | Visits outside the UK 891eb863 | 2022-08-08 | Rehman Chishti uk.org.publicwhip/person/24920 | 0 | 2022-08-08-891eb863-24920-0 | |
055f741e9085cf43a9d717e463703f7a69d45986 | Name of donor: Kuwait National Assembly Address of donor: Arabian Gulf St, PO Box, 716 Safat, Kuwait Estimate of the probable value (or amount of any donation): Flights and accommodation, total value: £3,162.50 Destination of visit: Kuwait City, Kuwait Dates of visit: 8-11 November 2021 Purpose of visit: APPG for Kuwait visit to meet the Speaker of the National Assembly, Kuwait Foreign Minister and other stakeholders to discuss foreign policy, security and trade. The delegation also met with the UK Mission in Kuwait. (Registered 25 November 2021) | Visits outside the UK 891eb863 | 2022-08-08 | Rehman Chishti uk.org.publicwhip/person/24920 | 1 | 2022-08-08-891eb863-24920-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");