items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2019-11-05-891eb863-10219-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 |
|---|---|---|---|---|---|---|---|
| 11ffe53333a094fb09c0dc84db5e8d81f87f7c08 | Name of donor: Mamont Foundation Address of donor: PO Box 472, St Julian’s Court, St Julian’s Avenue, St Peter Port, GY1 6AX, Guernsey, Channel Islands Estimate of the probable value (or amount of any donation): £137 towards the costs of the costs of local travel, food, accommodation and tour fees. All other costs met by non-registrable sources. Destination of visit: Iceland Dates of visit: 15-22 September 2019 Purpose of visit: To build relationships with the Icelandic government; connect with Arctic Council groups; witness the effects of climate; understand the impact of Iceland’s volcanic activity; learn about Iceland’s renewable energy initiatives. (Registered 08 October 2019) | Visits outside the UK 891eb863 | 2019-11-05 | Mike Gapes uk.org.publicwhip/person/10219 | 0 | 2019-11-05-891eb863-10219-0 | |
| 846eb0035be40a59a8a78b2423dd6eb5e2f3896f | Name of donor: HM Government of Gibraltar Address of donor: Gibraltar House, 150 Strand London WC2R 1JA Estimate of the probable value, or amount of any donation: Flights costing £1,050 return, and two nights' hotel accommodation costing £330; total value £1,380 Destination of visit: Gibraltar Dates of visit: 6-8 September 2019 Purpose of visit: to meet Chief Minister and other Government and opposition political leaders to discuss Brexit and other issues and to join National Day celebrations. (Registered 09 October 2019) | Visits outside the UK 891eb863 | 2019-11-05 | Mike Gapes uk.org.publicwhip/person/10219 | 1 | 2019-11-05-891eb863-10219-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");