items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2019-10-21-891eb863-11093-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 |
|---|---|---|---|---|---|---|---|
| 3f5611e5e6b36e4fd1e2abe8a0ba2fa53b1035d0 | Name of donor: The Antisemitism Policy Trust Address of donor: Antisemitism Policy Trust, BM 5369, London WC1N 3XX Estimate of the probable value (or amount of any donation): flight and accommodation costing £955 Destination of visit: Germany Dates of visit: 24-27 September 2018 Purpose of visit: To meet with football clubs to discuss antisemitism and racism in football. (Registered 18 October 2018) | Visits outside the UK 891eb863 | 2019-10-21 | John Mann uk.org.publicwhip/person/11093 | 0 | 2019-10-21-891eb863-11093-0 | |
| 1fda088a55ac8536cd3151b6d0517d6f790a85d2 | Name of donor: The American Jewish Congress Address of donor: 165 East 56th Street, New York, New York 10022, United States of America Estimate of the probable value (or amount of any donation): flights, hotel and other travel with a value of £3,528 Destination of visit: Washington DC, USA Dates of visit: 2 to 4 June 2019 Purpose of visit: speaker on a panel at the international AJC conference on anti-semitism. (Registered 14 June 2019) | Visits outside the UK 891eb863 | 2019-10-21 | John Mann uk.org.publicwhip/person/11093 | 1 | 2019-10-21-891eb863-11093-0 | |
| c50de11d90887ea63e07a20e868ffd7154917b22 | Name of donor: European Population Forum Address of donor: Rue Montoyer 23, Brussels, Belgium Estimate of the probable value (or amount of any donation): Flights, food, accommodation and local transport, total value £2,058 Destination of visit: Zambia Dates of visit: 23-26 June 2019 Purpose of visit: Parliamentary delegation to Zambian Parliamentary Assembly. (Registered 09 August 2019) | Visits outside the UK 891eb863 | 2019-10-21 | John Mann uk.org.publicwhip/person/11093 | 2 | 2019-10-21-891eb863-11093-0 | |
| 39be944f636bf8c75592298bfa01d772e78a1472 | Name of donor: European Population Forum Address of donor: Rue Montoyer 23, Brussels, Belgium Estimate of the probable value (or amount of any donation): Rail fare, value £157 Destination of visit: Brussels Date of visit: 8 July 2019 Purpose of visit: Executive meeting. (Registered 09 August 2019) | Visits outside the UK 891eb863 | 2019-10-21 | John Mann uk.org.publicwhip/person/11093 | 3 | 2019-10-21-891eb863-11093-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");