items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2002-11-26-80ef1083-10529-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 |
---|---|---|---|---|---|---|---|
1e9b864b5e4573d336d010ba6ae7f42ce928515f | 28 February-6 March 2002, to India, to speak at Conference on UN Peacekeeping (Brahimi Report) and have discussions with parliamentarians on the international criminal court. Travel and accommodation paid for by Parliamentarians for Global Action. (Registered 18 July 2002) | Overseas visits 80ef1083 | 2002-11-26 | Malcolm Savidge uk.org.publicwhip/member/1212 | Malcolm Savidge uk.org.publicwhip/person/10529 | 0 | 2002-11-26-80ef1083-10529-0 |
286f7f9682b071d702b3f0507b02751905e894ba | 31 March-11 April 2002, to USA, to attend and speak at Conference on Global Security and Arms Control and to attend Preparatory Committee for the Nuclear Non-Proliferation Treaty and related meetings at the UN. Travel and accommodation paid for by University of Illinois. (Registered 18 July 2002) | Overseas visits 80ef1083 | 2002-11-26 | Malcolm Savidge uk.org.publicwhip/member/1212 | Malcolm Savidge uk.org.publicwhip/person/10529 | 1 | 2002-11-26-80ef1083-10529-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");