items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2002-11-26-80ef1083-10218-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 |
|---|---|---|---|---|---|---|---|
| 85deec1f617fc8c145c854d484b0c8257183749e | 2-5 December 2001, to Abu Dhabi, paid for by the Government of the United Arab Emirates. (Registered 6 December 2001) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 0 | 2002-11-26-80ef1083-10218-0 |
| 4e842ceb78d3848f9b0c4814ecfd29e66927c23a | 27-31 December 2001, to Libya. Four nights' hotel accommodation paid for by the Academy of Graduates in Tripoli where I gave two speeches. (Registered 7 January 2002) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 1 | 2002-11-26-80ef1083-10218-0 |
| f14dec6c6f46fd9fbe10f23526497fdc56822840 | 6-9 January 2002, to Jordan and Iraq. Three nights' hotel accommodation paid for by the Mariam Appeal. (Registered 16 January 2002) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 2 | 2002-11-26-80ef1083-10218-0 |
| a33053d7c0c69539d1f0373db2938dbb9413d66d | 14-21 January 2002, to Canada and US. Flights and hotel accommodation paid for by the Canadian anti-sanction campaign and the Methodist Church, Seattle, USA. (Registered 25 January 2002) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 3 | 2002-11-26-80ef1083-10218-0 |
| 455bf2e4bf119159821f632fa3edbeacce68186e | April 2002, to Paris, to the French Senate. Flight from Faro to Paris and one night's hotel accommodation paid for by French anti-sanctions campaigners. (Registered 14 May 2002) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 4 | 2002-11-26-80ef1083-10218-0 |
| 19e40312a12f8a238892baa2c9b6811768fe8b06 | April 2002, to Rome to speak at the Italian Parliament. Flight from Paris to Rome and Rome to London and one night's hotel accommodation paid for by an Italian-Palestinian solidarity group. (Registered 14 May 2002) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 5 | 2002-11-26-80ef1083-10218-0 |
| 6b5269c15d6772796bbc0b0c491aa0062f12f3cf | April 2002, to Rabat for a meeting on Iraq. Return flight from London-Rabat and two nights' hotel accommodation paid for by the Great Britain Iraq Society, of which I am Chairman. (Registered 14 May 2002) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 6 | 2002-11-26-80ef1083-10218-0 |
| 1bbd978f7afe27b7f725f1847b5999b78541bc5a | May 2002, to Amman, return flight paid for by the Great Britain Iraq Society, who also paid for a car from Amman to Baghdad and flight from Baghdad-Amman. Three nights in the al Rashid hotel paid for by myself. A car and bus from Amman to the West Bank and from West Bank to Gaza and two nights in a Jerusalem hotel paid for by the Emergency Committee on Iraq and Palestine. One night in a hotel in Gaza paid for by myself. (Registered 14 May 2002) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 7 | 2002-11-26-80ef1083-10218-0 |
| b060bb9ef5e54295cbcaa1004b0fefd0e57b61a6 | 10-18 September 2002, to Jordan and Iraq; flights and hotel accommodation paid for by the Great Britain Iraq Society, of which I am Chairman. (Registered 4 September 2002) (registered 24 September 2002) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 8 | 2002-11-26-80ef1083-10218-0 |
| 77c05fdb35c3e900c0c695c9727d2e0eedda5ffe | 1-15 October 2002, to Jordan, Iraq, Syria and Beirut, to attend conferences. Flights and hotel accommodation paid for by the Great Britain Iraq Society, of which I am Chairman. (Registered 16 October 2002) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 9 | 2002-11-26-80ef1083-10218-0 |
| c40dd6d78e85926314128ffd7ff6ed59ef57ae94 | 7-10 November 2002, to Kiev for a conference on Iraq. Flights paid for by the Great Britain Iraq Society, and the hotel accommodation was provided by the Ukrainian union for friendship with the Iraqi people. (Registered 7 November 2002) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 10 | 2002-11-26-80ef1083-10218-0 |
| 6e5aa1b5e383173281f2e4ca1c4bd6f4cc1fc580 | 15-17 November 2002, to Madrid. Flights and two nights' accommodation paid for by the Spanish Campaign Against Sanctions on Iraq. (Registered 18 November) | Overseas visits 80ef1083 | 2002-11-26 | George Galloway uk.org.publicwhip/member/903 | George Galloway uk.org.publicwhip/person/10218 | 11 | 2002-11-26-80ef1083-10218-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");