items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2003-12-04-80ef1083-10412-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 |
|---|---|---|---|---|---|---|---|
| 64324fb16ee4e6ec04a4ffc660e577d7ebbff054 | 27 August-10 September, to Indonesia, Malaysia, Thailand and Singapore, for political visit. Travel and accommodation paid for by Asia House, London. (Registered 5 November 2002) | Overseas visits 80ef1083 | 2003-12-04 | Peter Mandelson uk.org.publicwhip/member/1092 | Peter Mandelson uk.org.publicwhip/person/10412 | 0 | 2003-12-04-80ef1083-10412-0 |
| 7db389575a07f4cfd65f137cbfdfbcdfc0c75024 | 12-13 October 2002, to Russia, to speak at Conference on Russia and Europe. Travel and accommodation paid for by the conference organisers. (Registered 5 November 2002) | Overseas visits 80ef1083 | 2003-12-04 | Peter Mandelson uk.org.publicwhip/member/1092 | Peter Mandelson uk.org.publicwhip/person/10412 | 1 | 2003-12-04-80ef1083-10412-0 |
| 73a749820c525be2b14676c5543307e368703d3a | 22-26 December 2002, to New Delhi to address the Confederation of Indian Industry. Travel, accommodation and hospitality paid for by my hosts. (Registered 17 February 2003) | Overseas visits 80ef1083 | 2003-12-04 | Peter Mandelson uk.org.publicwhip/member/1092 | Peter Mandelson uk.org.publicwhip/person/10412 | 2 | 2003-12-04-80ef1083-10412-0 |
| bf226130a6f0866db6e21732a19f12628b8d8753 | 12-13 March 2003, to Madrid, Spain, with the Spanish All-Party Parliamentary Group. Travel expenses to Madrid paid for from Group funds provided by the Group's declared sponsor TUI UK Ltd. (Thomson Holidays). Expenses whilst in Madrid paid for by the Congreso de los Diputados, whose guests we were. (Registered 14 April 2003) | Overseas visits 80ef1083 | 2003-12-04 | Peter Mandelson uk.org.publicwhip/member/1092 | Peter Mandelson uk.org.publicwhip/person/10412 | 3 | 2003-12-04-80ef1083-10412-0 |
| 809994404f4eb9b1f377b64851813310b7256e91 | 18-19 February 2003, to Bahrain, at the invitation of the Government of Bahrain. (Registered 17 April 2003) | Overseas visits 80ef1083 | 2003-12-04 | Peter Mandelson uk.org.publicwhip/member/1092 | Peter Mandelson uk.org.publicwhip/person/10412 | 4 | 2003-12-04-80ef1083-10412-0 |
| c69b4bf95e1235d33e5ecc5a105ce8ec12c46791 | 20-21 February 2003, to Qatar, at the invitation of the Government of Qatar. (Registered 17 April 2003) | Overseas visits 80ef1083 | 2003-12-04 | Peter Mandelson uk.org.publicwhip/member/1092 | Peter Mandelson uk.org.publicwhip/person/10412 | 5 | 2003-12-04-80ef1083-10412-0 |
| e5e1330bb7c140a8ba22b08c4c3708466e1d4cf8 | 5-6 May 2003, to Warsaw to speak at the College for Europe and FES. Travel and accommodation paid for by the College of Europe. (Registered 13 August 2003) | Overseas visits 80ef1083 | 2003-12-04 | Peter Mandelson uk.org.publicwhip/member/1092 | Peter Mandelson uk.org.publicwhip/person/10412 | 6 | 2003-12-04-80ef1083-10412-0 |
| 7b821a0bd93942a906da2007d68b17e1190a408e | 6-8 June 2003, to Moscow to speak at the Moscow School of Political Studies. Travel and accommodation paid for by the School. (Registered 13 August 2003) | Overseas visits 80ef1083 | 2003-12-04 | Peter Mandelson uk.org.publicwhip/member/1092 | Peter Mandelson uk.org.publicwhip/person/10412 | 7 | 2003-12-04-80ef1083-10412-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");