items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2000-11-10-80ef1083-10393-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 |
---|---|---|---|---|---|---|---|
8fe5782eb7eeb581cd36db55440a9c51d26fef58 | 12-13 May 2000, to Ypres, Belgium, to speak and participate in a conference on the subject of British soldiers executed in the Great War. The conference was convened by the Flanders Fields Museum of the City of Ypres, who paid for my fare and accommodation. (Registered 26 May 2000) | Overseas visits 80ef1083 | 2000-11-10 | Andrew MacKinlay uk.org.publicwhip/member/393 | Andrew MacKinlay uk.org.publicwhip/person/10393 | 0 | 2000-11-10-80ef1083-10393-0 |
cbbf95ea17bc7a4dcf0bb211d39b1323e87bcaad | 9-12 September 2000, to Gibraltar, as Chairperson of the All-Party Gibraltar Group, for a series of meetings with the Chief Minister, other Ministers and the Leader of the Opposition: coinciding with the National Day celebrations. The purpose of the discussions was to discuss the constitutional future of the Territory and the border situation. I also met with the Commander of the Royal Naval Dockyard in Gibraltar to discuss defence issues. The cost of my travel and accommodation was met by the Territory's Government. (Registered 2 October 2000) | Overseas visits 80ef1083 | 2000-11-10 | Andrew MacKinlay uk.org.publicwhip/member/393 | Andrew MacKinlay uk.org.publicwhip/person/10393 | 1 | 2000-11-10-80ef1083-10393-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");