Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

34 rows where person_id = "uk.org.publicwhip/person/10004" sorted by date descending

View and edit SQL

Suggested facets: item, category_id, date, member_id, sort_order, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
f8170722cd0850e176e40429ca943efe5062ae44 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2010-02-03 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2010-02-03-80ef1083-10004-0
24af039c1ed1fbf221c8abae8d93d46669cf787b 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2010-01-06 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2010-01-06-80ef1083-10004-0
9ccba55fddc6a8a01a86c8c6b3598c60577dceb7 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-12-10 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-12-10-80ef1083-10004-0
b4184d3d9f8948e9ba14359bcf5d874fdb3ee8d8 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-11-25 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-11-25-80ef1083-10004-0
ddf669d134e024d7d4dbb08208a27a61f49f2686 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-11-11 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-11-11-80ef1083-10004-0
bacf34ea5d08892fe2f96fbdd84cda4545f32b81 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-10-28 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-10-28-80ef1083-10004-0
3248a6ad645a2ef809a99f73baf0f6c035ff8640 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-10-14 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-10-14-80ef1083-10004-0
1ad6511a6a66a530e3dad20c51ba57f1084cede1 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-09-02 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-09-02-80ef1083-10004-0
67ee303431ed0604dd1b2fd4dfb40f0bc2d37b38 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-07-21 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-07-21-80ef1083-10004-0
f533eaa72b66053b69aa7b7e25fed1137939979e 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-07-08 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-07-08-80ef1083-10004-0
67750be1a63b29d5560bdf98834023c2ef7b09de 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-06-24 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-06-24-80ef1083-10004-0
24be6fc12788b7a876bb9b6d63a95b047a1a64fa 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-06-10 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-06-10-80ef1083-10004-0
1442073d17532350c36d7b0636c4211eb21d0ccf 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-05-20 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-05-20-80ef1083-10004-0
792f01c0099ce4b7014c7767c05b483058b60bb8 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-05-06 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-05-06-80ef1083-10004-0
2590d1e498567d28a1205bfb658bddfe7340c550 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-04-22 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-04-22-80ef1083-10004-0
c52610aa4ccd5a3863ea340a7f57a81df4dda3fd 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-03-25 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-03-25-80ef1083-10004-0
faca072999ac72a6b5b027fd547e5bb6e1033629 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-03-11 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-03-11-80ef1083-10004-0
23a2c5c91d690fb3e2e07c064c7478b49a326d25 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-02-25 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-02-25-80ef1083-10004-0
0645932c858fe833d044e98f49706ffa99d28381 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-02-11 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-02-11-80ef1083-10004-0
5ddedc0a587c9c9aba95c0f803315caee4abc09a 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-01-28 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-01-28-80ef1083-10004-0
5cf94f84dcd255c23fdf5c6e066877602b72b6c9 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2009-01-14 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2009-01-14-80ef1083-10004-0
f0e1efd06b6ce87dfc841762dac6e7f5938705e1 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2008-12-17 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2008-12-17-80ef1083-10004-0
1933d258c0fad9bfa1782335549424c9aa9b2085 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2008-12-03 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2008-12-03-80ef1083-10004-0
b560c8692d0ff8442de56158a2244d15377d7824 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2008-11-19 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2008-11-19-80ef1083-10004-0
35d22df3142f8c37b836c4863e3c14146c635ac5 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2008-11-05 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2008-11-05-80ef1083-10004-0
8bae974cd5cbacc34609a92a3f2037b14ec8a1a3 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2008-10-22 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2008-10-22-80ef1083-10004-0
76a4f8148153592088b60d58002c9329d9177f70 7-12 September 2008, to Israel and Palestine with Labour Friends of Israel (LFI). Travel and hospitality within Israel and Palestine paid for by LFI. Accommodation paid for by LFI at a rate discounted through the Israeli Ministry of Foreign Affairs. Some hospitality provided by the Palestinian Legislative Council, Palestinian Authority and the Israeli Ministry of Foreign Affairs. (Registered 22 September 2008) Overseas visits 80ef1083 2008-10-08 Nick Ainger uk.org.publicwhip/member/1486 Nick Ainger uk.org.publicwhip/person/10004 0 2008-10-08-80ef1083-10004-0
fe3f32ef9551fd9d88d913295e2303d85054eb7e A contribution of 25% of my election expenses at the 2001 General Election was made by the TGWU. Sponsorship or financial or material support 9e46def6 2002-05-14 Nick Ainger uk.org.publicwhip/member/690 Nick Ainger uk.org.publicwhip/person/10004 0 2002-05-14-9e46def6-10004-0
d94cd9ed98cdee63f21ddec669faa6470cc44963 Occasional broadcasting and written article fees. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Nick Ainger uk.org.publicwhip/member/4 Nick Ainger uk.org.publicwhip/person/10004 0 2001-05-14-1f359ece-10004-0
73072cb70562698e62f75c826ed6585e8f908d4c 16-17 October 2000, to Denmark with the Associate Parliamentary Renewable and Sustainable Energy Group (PRASEG) to witness the Danish Wind Farm Sector and meet with senior members of the Danish Government Energy Agency and the Danish Wind Industry. Flight and accommodation paid for by National Wind Power UK. (Registered 2 November 2000) Overseas visits 80ef1083 2001-05-14 Nick Ainger uk.org.publicwhip/member/4 Nick Ainger uk.org.publicwhip/person/10004 0 2001-05-14-80ef1083-10004-0
e3d3d383ba6dccc4dd4fa617f5e74a6dcd026e36 Occasional broadcasting and written article fees. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Nick Ainger uk.org.publicwhip/member/4 Nick Ainger uk.org.publicwhip/person/10004 0 2000-11-10-1f359ece-10004-0
0f7b4c73cb0b162d9cd64797b4be5b1e4738b0eb 10 October 1999, complimentary ticket, lunch and travel to the Argentina v Western Samoa rugby match in Llanelli, Carmarthenshire provided by the Welsh Development Agency. (Registered 9 November 1999) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Nick Ainger uk.org.publicwhip/member/4 Nick Ainger uk.org.publicwhip/person/10004 0 2000-11-10-84642823-10004-0
b8837f984f1e2952688ef4f242c7f615d5a71081 7-10 February 1999, to the Federal Republic of Germany on a fact finding trip to examine devolution and the federal system in Germany as a guest of the Federal Government. (Registered 25 February 1999) Overseas visits 80ef1083 2000-11-10 Nick Ainger uk.org.publicwhip/member/4 Nick Ainger uk.org.publicwhip/person/10004 0 2000-11-10-80ef1083-10004-0
5c6ef986bb72bfea599dc2dbfc9ab2d22d126644 16-17 October 2000, to Denmark with the Associate Parliamentary Renewable and Sustainable Energy Group (PRASEG) to witness the Danish Wind Farm Sector and meet with senior members of the Danish Government Energy Agency and the Danish Wind Industry. Flight and accommodation paid for by National Wind Power UK. (Registered 2 November 2000) Overseas visits 80ef1083 2000-11-10 Nick Ainger uk.org.publicwhip/member/4 Nick Ainger uk.org.publicwhip/person/10004 1 2000-11-10-80ef1083-10004-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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");