items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2000-11-10-80ef1083-10327-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 |
---|---|---|---|---|---|---|---|
2a97c9ccc4c766e36f46ebd22e0ed4a06cb26ba1 | 14-15 June 1999, to Germany, to attend Cologne Media Forum Conference to make keynote speech on Made in Britain - The British Television Market as a Model for Europe. Conference organisers paid for flights and hotel accommodation. (Registered 16 June 1999) | Overseas visits 80ef1083 | 2000-11-10 | Gerald Kaufman uk.org.publicwhip/member/327 | Gerald Kaufman uk.org.publicwhip/person/10327 | 0 | 2000-11-10-80ef1083-10327-0 |
7d36f69d9db5f486a83afc46b73694808f533046 | 30 September-2 October 1999, to Ramallah, Palestine, as guest speaker at a conference on Europe's Role in Building the Palestine State. Travel and accommodation provided by the Palestinian Centre for Regional Studies, a non-profit making organisation. (Registered 6 October 1999) | Overseas visits 80ef1083 | 2000-11-10 | Gerald Kaufman uk.org.publicwhip/member/327 | Gerald Kaufman uk.org.publicwhip/person/10327 | 1 | 2000-11-10-80ef1083-10327-0 |
0332cf6a720aac132a2d94358d514cb0eab2229d | 11-13 August 2000, to Geneva to address and chair session of First International Conference on the Right to Self Determination and the United Nations, organised by the International Human Rights Association of American Minorities and the International Council on Human Rights, both international non-governmental organisations. Travel and accommodation provided by conference organisers. (Registered 14 August 2000) | Overseas visits 80ef1083 | 2000-11-10 | Gerald Kaufman uk.org.publicwhip/member/327 | Gerald Kaufman uk.org.publicwhip/person/10327 | 2 | 2000-11-10-80ef1083-10327-0 |
7d44c84ae139a89002004b83dd283a20abe4a2bb | 22-25 September 2000, to Jerusalem to chair working group of Anglo-Israel Colloquium (registered charity). Travel and accommodation provided by organisers. (Registered 2 October 2000) | Overseas visits 80ef1083 | 2000-11-10 | Gerald Kaufman uk.org.publicwhip/member/327 | Gerald Kaufman uk.org.publicwhip/person/10327 | 3 | 2000-11-10-80ef1083-10327-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");