items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2022-11-14-891eb863-10001-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 |
|---|---|---|---|---|---|---|---|
| 9ebe61af9c5a51fa58097d5faa174dbba8b921a6 | Name of donor: GUBA Foundation Address of donor: 459 Prince Regent Lane, London E16 3HX Estimate of the probable value (or amount of any donation): International flights £805.07; accommodation £1,461.05; GUBA Awards event ticket £365.39; total value £2,631.51 Destination of visit: Accra, Ghana Dates of visit: 5-12 November 2021 Purpose of visit: To participate in the GUBA Foundation Yaa Asantewaa Womens Empowerment Awards ceremony and meet other relevant civil society organisations. (Registered 16 November 2021) | Visits outside the UK 891eb863 | 2022-11-14 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2022-11-14-891eb863-10001-0 | |
| 4c5b32bf79b893eb7f3411f7a8f1cfd94f29358e | Name of donor: PNP Women’s Movement Address of donor: 89 Old Hope Road, St. Andrew, Jamaica Estimate of the probable value (or amount of any donation): Flights £1,737.81, accommodation £802.01 and use of the airport Lounge £34.75, total value £2,574.57 Destination of visit: Kingston, Jamaica Dates of visit: 7-12 July 2022 Purpose of visit: Guest speaker at the PNP Women’s Movement’s 48th Annual Conference. (Registered 05 September 2022) | Visits outside the UK 891eb863 | 2022-11-14 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2022-11-14-891eb863-10001-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");