items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2023-10-30-891eb863-24741-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 |
|---|---|---|---|---|---|---|---|
| cf40c1004eb36179a048c406c12e1b732b3c9efb | Name of donor: Children's Health Defense Europe and Binders Initiative Address of donor: Postboks 3207 Krossen, 4398 Sandnes, Norway Estimate of the probable value (or amount of any donation): Boat trip (£55) and accommodation (£186), plus reimbursement on 10 May 2023 for flights (£320) and other travel costs (£51), total value £612 Destination of visit: Stavenger, Norway Dates of visit: 14-16 April 2023 Purpose of visit: To speak at the Spotlight Conference. (Registered 11 May 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Andrew Bridgen uk.org.publicwhip/person/24741 | 0 | 2023-10-30-891eb863-24741-0 | |
| f17b12be187036ce4d79ac95dc9d1f4bcd3b8dab | Name of donor: European Parliament Address of donor: Rue Wiertz 60, B-1047 Brussels, Belgium Estimate of the probable value (or amount of any donation): £418.82 received on 12 September as reimbursement for travel costs and accommodation Destination of visit: Brussels Dates of visit: 4-5 July 2023 Purpose of visit: Guest speaker (panellist) at a public debate, entitled 'European Public Health and Cooperation' on the 4 July 2023. (Registered 25 September 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Andrew Bridgen uk.org.publicwhip/person/24741 | 1 | 2023-10-30-891eb863-24741-0 | |
| e7ff6ed3ec39a0edd0237bffa04b96105a21c0cd | Name of donor: The Danish Freedom Movement Address of donor: FBF2020, Hindegade 6, 1303 Copenhagen K, Denmark Estimate of the probable value (or amount of any donation): Flights and accommodation, value £555.07 Destination of visit: Copenhagen, Denmark Dates of visit: 1-3 September 2023 Purpose of visit: To speak at the Facts Matter conference. (Registered 12 October 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Andrew Bridgen uk.org.publicwhip/person/24741 | 2 | 2023-10-30-891eb863-24741-0 | |
| 0f5231155c25ebebe1aae96a83a248217193e6c2 | Name of donor: The Doctorsâ Appeal Address of donor: Läkaruppropet ideal förening, c/o Grycksbovägen 46, Enskede, 12247 Sweden Estimate of the probable value (or amount of any donation): Accommodation for four nights (£384), food (£116), flights (£383) and other travel costs (£68), total approx. value £951 Destination of visit: Sweden Dates of visit: 28 September - 2 October 2023 Purpose of visit: To participate and speak at the On Guard for the Liberty of Mankind conference. (Registered 23 October 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Andrew Bridgen uk.org.publicwhip/person/24741 | 3 | 2023-10-30-891eb863-24741-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");