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

55 rows where person_id = "uk.org.publicwhip/person/10341" 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
7603a46455b836dececd9ba5260337d2b340a006 Administrative support and outreach community expertise provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2005-04-11 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2005-04-11-9e46def6-10341-0
cb5981ad56543cac06cd598b2ef4bafc505fa65f 17-24 September 2004, to Bangladesh, flight sponsored by British Airways. (Accommodation and hospitality provided by British High Commission.) (10 November 2004) Overseas visits 80ef1083 2005-04-11 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2005-04-11-80ef1083-10341-0
02eac070a897814fc21627caab78b7193a0cd2ca 3-9 October 2004, to the Democratic Republic of Congo with the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention, paid for by the Rainforest Foundation, Greenpeace and the All-Party Group's registered funds. (Registered 10 November 2004) Overseas visits 80ef1083 2005-04-11 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 1 2005-04-11-80ef1083-10341-0
ef01b822b30cc35216b6cb64964da6bacb083a45 Two-bedroom flat in London E3, from which rental income is received. Land and Property 4f1e6359 2005-04-11 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2005-04-11-4f1e6359-10341-0
ff83edb1d28ffe6a89d793dd6002fec54a52eb90 Administrative support and outreach community expertise provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2005-01-28 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2005-01-28-9e46def6-10341-0
1c4724eb51025370e2decd7d5c2ae2827bc158af 17-24 September 2004, to Bangladesh, flight sponsored by British Airways. (Accommodation and hospitality provided by British High Commission.) (10 November 2004) Overseas visits 80ef1083 2005-01-28 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2005-01-28-80ef1083-10341-0
787223d5f272de3f2df47cf024ba63699a0e8621 3-9 October 2004, to the Democratic Republic of Congo with the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention, paid for by the Rainforest Foundation, Greenpeace and the All-Party Group's registered funds. (Registered 10 November 2004) Overseas visits 80ef1083 2005-01-28 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 1 2005-01-28-80ef1083-10341-0
fd8fcd1eb8e4b9474c4a2f0889df5dac9548fc68 Two-bedroom flat in London E3, from which rental income is received. Land and Property 4f1e6359 2005-01-28 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2005-01-28-4f1e6359-10341-0
4f5a776857fa4ff5aa3c0534e8cc9a8c5f57dd03 Administrative support and outreach community expertise provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2004-12-03 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-12-03-9e46def6-10341-0
5f45140d52e03c8ec93d8bbc37e6c3fff8434eae 9-15 June 2003, to Israel and Gaza Strip, paid for by Christian Aid. (Registered 9 December 2003) Overseas visits 80ef1083 2004-12-03 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-12-03-80ef1083-10341-0
aca9adc7e8ca99d91cf98b190bd70611b4e10604 5-10 October 2003, to the Democratic Republic of Congo, paid for by the Government of the Democratic Republic of Congo. (Registered 9 December 2003) Overseas visits 80ef1083 2004-12-03 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 1 2004-12-03-80ef1083-10341-0
a79358ce5408550984a91981da245ce6ddf42a9c 17-24 September 2004, to Bangladesh, flight sponsored by British Airways. (Accommodation and hospitality provided by British High Commission.) (10 November 2004) Overseas visits 80ef1083 2004-12-03 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 2 2004-12-03-80ef1083-10341-0
ee134a8310a5a848776dc90b0c0a0f636e444a9f 3-9 October 2004, to the Democratic Republic of Congo with the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention, paid for by the Rainforest Foundation, Greenpeace and the All-Party Group's registered funds. (Registered 10 November 2004) Overseas visits 80ef1083 2004-12-03 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 3 2004-12-03-80ef1083-10341-0
105e488f91b8450a7a8c1b1346bf027c75dccc77 Two-bedroom flat in London E3, from which rental income is received. Land and Property 4f1e6359 2004-12-03 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-12-03-4f1e6359-10341-0
611e3fc904b68c1f474898f30078bb8aeb911b46 Administrative support and outreach community expertise provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2004-10-22 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-10-22-9e46def6-10341-0
99a505eef80640f17fdf9182e3bace3d897ebd6b 9-15 June 2003, to Israel and Gaza Strip, paid for by Christian Aid. (Registered 9 December 2003) Overseas visits 80ef1083 2004-10-22 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-10-22-80ef1083-10341-0
bee6497baaa6a984ea5b9a4e5efed42562b73852 5-10 October 2003, to the Democratic Republic of Congo, paid for by the Government of the Democratic Republic of Congo. (Registered 9 December 2003) Overseas visits 80ef1083 2004-10-22 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 1 2004-10-22-80ef1083-10341-0
6dc7a6d773afdda03af75bd9e4b4b5244b51426d Two-bedroom flat in London E3, from which rental income is received. Land and Property 4f1e6359 2004-10-22 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-10-22-4f1e6359-10341-0
a49f3aeca2a686f70314fa16d3f2373757d992e5 Administrative support and outreach community expertise provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2004-09-08 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-09-08-9e46def6-10341-0
bc720bb8a4e80e0af76a837d6514b811073c8093 9-15 June 2003, to Israel and Gaza Strip, paid for by Christian Aid. (Registered 9 December 2003) Overseas visits 80ef1083 2004-09-08 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-09-08-80ef1083-10341-0
60a4f044189ab20e144a50efc0a420f47260061b 5-10 October 2003, to the Democratic Republic of Congo, paid for by the Government of the Democratic Republic of Congo. (Registered 9 December 2003) Overseas visits 80ef1083 2004-09-08 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 1 2004-09-08-80ef1083-10341-0
0dee2d06842ad6a1a6828bee374dce56cb7a6956 Two-bedroom flat in London E3, from which rental income is received. Land and Property 4f1e6359 2004-09-08 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-09-08-4f1e6359-10341-0
6c0be8fc140e7ba3a019bd0a5e46013c15947c94 Administrative support and outreach community expertise provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2004-07-16 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-07-16-9e46def6-10341-0
5fc6ff7cde9c09d3916f65966f477b51bfb748e0 9-15 June 2003, to Israel and Gaza Strip, paid for by Christian Aid. (Registered 9 December 2003) Overseas visits 80ef1083 2004-07-16 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-07-16-80ef1083-10341-0
22f12900e1eed6f83f08bf27834f11cd7d7111a8 5-10 October 2003, to the Democratic Republic of Congo, paid for by the Government of the Democratic Republic of Congo. (Registered 9 December 2003) Overseas visits 80ef1083 2004-07-16 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 1 2004-07-16-80ef1083-10341-0
9908a2f096fae0b12c8e750a09840665b145c030 Two-bedroom flat in London E3, from which rental income is received. Land and Property 4f1e6359 2004-07-16 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-07-16-4f1e6359-10341-0
40ac69724f9b7a912d1d3ad01a3cc9139b5a82b3 Administrative support and outreach community expertise provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2004-05-21 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-05-21-9e46def6-10341-0
8062449ec5ad5be50b4644995c89ef94771214dd 9-15 June 2003, to Israel and Gaza Strip, paid for by Christian Aid. (Registered 9 December 2003) Overseas visits 80ef1083 2004-05-21 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-05-21-80ef1083-10341-0
20e250fc314dca338674d36b32ac2d4a9a6af468 5-10 October 2003, to the Democratic Republic of Congo, paid for by the Government of the Democratic Republic of Congo. (Registered 9 December 2003) Overseas visits 80ef1083 2004-05-21 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 1 2004-05-21-80ef1083-10341-0
ec5f693027cbf4845a6fb7f1fee783670d9e36bb Two-bedroom flat in London E3, from which rental income is received. Land and Property 4f1e6359 2004-05-21 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-05-21-4f1e6359-10341-0
cf5f187fc3d8939edaf54974aeaf262b9f0144a6 Administrative support and outreach community expertise provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2004-01-31 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-01-31-9e46def6-10341-0
ec18237fe5778d7e9f10d5db4a7cc5bb80eaea9f 9-15 June 2003, to Israel and Gaza Strip, paid for by Christian Aid. (Registered 9 December 2003) Overseas visits 80ef1083 2004-01-31 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-01-31-80ef1083-10341-0
b888795880aea1b3cf1d147951efc0f59d630631 5-10 October 2003, to the Democratic Republic of Congo, paid for by the Government of the Democratic Republic of Congo. (Registered 9 December 2003) Overseas visits 80ef1083 2004-01-31 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 1 2004-01-31-80ef1083-10341-0
064d482743bf59a7601d2abbb69bd24428713d26 Two-bedroom flat in London E3, from which rental income is received. Land and Property 4f1e6359 2004-01-31 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2004-01-31-4f1e6359-10341-0
f92f0df142416101200d511311fcdae5be91b060 Public affairs consultant to Strategy International UK, 'The D Group'. Funds are solely directed to fund the salary of health policy adviser. (Up to £5,000) Remunerated employment, office, profession etc 1f359ece 2003-12-04 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2003-12-04-1f359ece-10341-0
d0087e7032cd46c389da953c341497371b64ff4c Administrative support and outreach community expertise provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2003-12-04 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2003-12-04-9e46def6-10341-0
834660bcec1314c79dda167ef43b455548553321 Two-bedroom flat in London E3, from which rental income is received. Land and Property 4f1e6359 2003-12-04 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2003-12-04-4f1e6359-10341-0
e0fccd5c09ab2e87d288a34cd725e4ca9877c459 Public affairs consultant to Strategy International UK, `The D Group'. Funds are solely directed to fund the salary of health policy adviser. (£5,001-£10,000) Remunerated employment, office, profession etc 1f359ece 2002-11-26 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2002-11-26-1f359ece-10341-0
e385bc124a27b7b588f91e8e201f0a5857b7f5d2 Administrative support and outreach community expertise provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2002-11-26 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2002-11-26-9e46def6-10341-0
f6bc4dc169513805cd9d5b0c3720393b507fbbdd October 2000, to Bermuda, accompanied by my husband, to attend conference, paid for by the Premier of Bermuda. (Registered 20 August 2002) Overseas visits 80ef1083 2002-11-26 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2002-11-26-80ef1083-10341-0
e5ad808b8f6b2b8e019639b831c049d98cd68184 21-17 January 2002, to the Democratic Republic of Congo and Rwanda, paid for by All-Party Group on Great Lakes Region and Genocide Prevention. (Registered 9 July 2002) Overseas visits 80ef1083 2002-11-26 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 1 2002-11-26-80ef1083-10341-0
2919d020c800186022e8d6ac87b8848973f1f194 22-26 February 2002, to Prague to present BBC documentary, paid for by BBC. (Registered 9 July 2002) Overseas visits 80ef1083 2002-11-26 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 2 2002-11-26-80ef1083-10341-0
ed495718fdd7451550cd387f4568849698e2203b Two-bedroom flat in London E3, from which rental income is received. Land and Property 4f1e6359 2002-11-26 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2002-11-26-4f1e6359-10341-0
e821aac5265e81427eba10a816b0902e5321a49f Occasional journalism. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2002-05-14-1f359ece-10341-0
eef342e4949722f9897abef1e4a1576a336542bf One full-time caseworker and one part-time (16 hours) provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2002-05-14 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2002-05-14-9e46def6-10341-0
695b11dc08497980b838598e31c6ea4abefe840f 1-7 August 2001, to the Democratic Republic of Congo with the All-Party Parliamentary Group for the Great Lakes Region and Genocide Prevention, to examine the political and humanitarian situation in the country. The visit was jointly funded by the UK charities Tearfund, International Alert, Christian Aid, Oxfam and Save the Children. (Registered 20 September 2001) Overseas visits 80ef1083 2002-05-14 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2002-05-14-80ef1083-10341-0
ca810f1f0fa0e0dc37fa36478b73907585727926 3-7 November 2001, to Washington DC, USA, for a leadership conference, funded by Duke University and the New Policy Network. (Registered 21 November 2001) Overseas visits 80ef1083 2002-05-14 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 1 2002-05-14-80ef1083-10341-0
27d148e9d8b64b85ce7fb9077e87feacbcd7cd11 Two-bedroom flat in London E3, from which rental income is received. Land and Property 4f1e6359 2002-05-14 Oona King uk.org.publicwhip/member/1023 Oona King uk.org.publicwhip/person/10341 0 2002-05-14-4f1e6359-10341-0
cac2e600f1535c120d634d4ffee7af66644c7b87 Occasional lecturing, broadcasting and journalism. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Oona King uk.org.publicwhip/member/341 Oona King uk.org.publicwhip/person/10341 0 2001-05-14-1f359ece-10341-0
5aa554694f9aeb6478ad8d0caf142c31fabd1b3f Administrative assistance for three days a week provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2001-05-14 Oona King uk.org.publicwhip/member/341 Oona King uk.org.publicwhip/person/10341 0 2001-05-14-9e46def6-10341-0
7a8a696fe53c50cb537b1d02c96f29c275f87750 Occasional lecturing, broadcasting and journalism. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Oona King uk.org.publicwhip/member/341 Oona King uk.org.publicwhip/person/10341 0 2000-11-10-1f359ece-10341-0
92898cfe113d6d6e8aa1866ee4a03565b7949637 Administrative assistance for three days a week provided by Community Links, a charitable organisation. Sponsorship or financial or material support 9e46def6 2000-11-10 Oona King uk.org.publicwhip/member/341 Oona King uk.org.publicwhip/person/10341 0 2000-11-10-9e46def6-10341-0
4dbcd6d1f5034cbb033a550649573549cd4a5dce 16 February 1999, I was given two tickets to the Brit Awards by the British Phonographic Industry. (Registered 11 June 1999) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Oona King uk.org.publicwhip/member/341 Oona King uk.org.publicwhip/person/10341 0 2000-11-10-84642823-10341-0
6c498c3130b65e66f189fd1c8a45b8140a87b4ab Honorary membership of the Congress Dining Club in Westminster, London. (Registered 20 December 1999) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Oona King uk.org.publicwhip/member/341 Oona King uk.org.publicwhip/person/10341 1 2000-11-10-84642823-10341-0
963ba4793e2f0286221a568d43c94ba149aa8b88 3-8 October 1999, to Israel to meet senior Israeli and Palestinian leaders in the Middle East Peace Process. My flight and accommodation were paid for by the Labour Friends of Israel. (Registered 10 November 1999) Overseas visits 80ef1083 2000-11-10 Oona King uk.org.publicwhip/member/341 Oona King uk.org.publicwhip/person/10341 0 2000-11-10-80ef1083-10341-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");