items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
1 row where record_id = "2005-04-11-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 |
---|---|---|---|---|---|---|---|
5e2cc3fe21c1f6ed9c3650939e7f940cb29125f1 | 2-11 December 2004, to Wellington, New Zealand, to participate in a "Consultative Assembly of Parliamentarians for the International Criminal Court and the Rule of Law", hosted by the Parliament of New Zealand and also to attend an international parliamentary forum on "Parliamentarians, the Nuclear Non-Proliferation Treaty and Nuclear Weapon Free Zones." Travel and accommodation paid for by the Parliamentary Network for Nuclear Disarmament. (Registered 22 December 2004) | Overseas visits 80ef1083 | 2005-04-11 | Malcolm Savidge uk.org.publicwhip/member/1212 | Malcolm Savidge uk.org.publicwhip/person/10529 | 0 | 2005-04-11-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");