home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

20 rows where person_id = "uk.org.publicwhip/person/10019" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

hash item category_id date ▲ member_id person_id sort_order record_id
dc6f6f1843595a11c8a3beeadcae22d3d34b7c78 8-10 April 2004, to Turkey, to visit Gallipoli WWI monuments and war graves, and other historic sites in the Cannakale region, Dardanelles, as guest of AK Party, including two nights' accommodation in party's guest house and travel from Istanbul to Cannakale. The visit followed Council of Europe meetings in Istanbul. (Registered 12 May 2004) Overseas visits 80ef1083 2005-04-11 David Atkinson uk.org.publicwhip/member/704 David Atkinson uk.org.publicwhip/person/10019 0 2005-04-11-80ef1083-10019-0
eef15297e56a236f17b47bff21ee1f521c8266ac 15-20 February 2005, to Taiwan, Republic of China, to discuss opportunities of association with the Council of Europe. Travel, accommodation, meals and visit to Peng-Hu Islands provided by Government of Taiwan, Republic of China. (Registered 24 February 2005) Overseas visits 80ef1083 2005-04-11 David Atkinson uk.org.publicwhip/member/704 David Atkinson uk.org.publicwhip/person/10019 1 2005-04-11-80ef1083-10019-0
3a47d47409d71fefd48de20331c5e95d76d51303 8-10 April 2004, to Turkey, to visit Gallipoli WWI monuments and war graves, and other historic sites in the Cannakale region, Dardanelles, as guest of AK Party, including two nights' accommodation in party's guest house and travel from Istanbul to Cannakale. The visit followed Council of Europe meetings in Istanbul. (Registered 12 May 2004) Overseas visits 80ef1083 2005-01-28 David Atkinson uk.org.publicwhip/member/704 David Atkinson uk.org.publicwhip/person/10019 0 2005-01-28-80ef1083-10019-0
53d8aac51a443d3c3474f2a3a85d39c62e861d36 8-10 April 2004, to Turkey, to visit Gallipoli WWI monuments and war graves, and other historic sites in the Cannakale region, Dardanelles, as guest of AK Party, including two nights' accommodation in party's guest house and travel from Istanbul to Cannakale. The visit followed Council of Europe meetings in Istanbul. (Registered 12 May 2004) Overseas visits 80ef1083 2004-12-03 David Atkinson uk.org.publicwhip/member/704 David Atkinson uk.org.publicwhip/person/10019 0 2004-12-03-80ef1083-10019-0
47e36ffc501cba687418b2a1d9853a1feeffd083 8-10 April 2004, to Turkey, to visit Gallipoli WWI monuments and war graves, and other historic sites in the Cannakale region, Dardanelles, as guest of AK Party, including two nights' accommodation in party's guest house and travel from Istanbul to Cannakale. The visit followed Council of Europe meetings in Istanbul. (Registered 12 May 2004) Overseas visits 80ef1083 2004-10-22 David Atkinson uk.org.publicwhip/member/704 David Atkinson uk.org.publicwhip/person/10019 0 2004-10-22-80ef1083-10019-0
71885c5bbf13950fd5fb4db8cdfc4079b2cb89c3 8-10 April 2004, to Turkey, to visit Gallipoli WWI monuments and war graves, and other historic sites in the Cannakale region, Dardanelles, as guest of AK Party, including two nights' accommodation in party's guest house and travel from Istanbul to Cannakale. The visit followed Council of Europe meetings in Istanbul. (Registered 12 May 2004) Overseas visits 80ef1083 2004-09-08 David Atkinson uk.org.publicwhip/member/704 David Atkinson uk.org.publicwhip/person/10019 0 2004-09-08-80ef1083-10019-0
88e0825d31e8665be444050f9aa231c081433415 8-10 April 2004, to Turkey, to visit Gallipoli WWI monuments and war graves, and other historic sites in the Cannakale region, Dardanelles, as guest of AK Party, including two nights' accommodation in party's guest house and travel from Istanbul to Cannakale. The visit followed Council of Europe meetings in Istanbul. (Registered 12 May 2004) Overseas visits 80ef1083 2004-07-16 David Atkinson uk.org.publicwhip/member/704 David Atkinson uk.org.publicwhip/person/10019 0 2004-07-16-80ef1083-10019-0
7804dbf84e409929b2d82ecb4b2cf36e58d60efb 8-10 April 2004, to Turkey, to visit Gallipoli WWI monuments and war graves, and other historic sites in the Cannakale region, Dardanelles, as guest of AK Party, including two nights' accommodation in party's guest house and travel from Istanbul to Cannakale. The visit followed Council of Europe meetings in Istanbul. (Registered 12 May 2004) Overseas visits 80ef1083 2004-05-21 David Atkinson uk.org.publicwhip/member/704 David Atkinson uk.org.publicwhip/person/10019 0 2004-05-21-80ef1083-10019-0
1fa728fcfc54514f381d9a56413b90d0b958404b Occasional fees received for participating in opinion polls. Remunerated employment, office, profession etc 1f359ece 2002-05-14 David Atkinson uk.org.publicwhip/member/704 David Atkinson uk.org.publicwhip/person/10019 0 2002-05-14-1f359ece-10019-0
75bf1e09a6a88ef4c25d3b645efe83540bfffeb8 Occasional payment for addressing seminars, conferences and other speeches. Remunerated employment, office, profession etc 1f359ece 2002-05-14 David Atkinson uk.org.publicwhip/member/704 David Atkinson uk.org.publicwhip/person/10019 1 2002-05-14-1f359ece-10019-0
a65889fdc5ef560eff55f97fe336e89785379079 Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2001-05-14 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 0 2001-05-14-1f359ece-10019-0
5ba6546a88e99ae6594e374487f41913bf2a153f Occasional payment for addressing seminars, conferences and other speeches. Remunerated employment, office, profession etc 1f359ece 2001-05-14 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 1 2001-05-14-1f359ece-10019-0
1ff00a2a0d9cd55c62337482b15f4712c86d3cb6 9-11 September, to Gibraltar, to attend National Day and to have meetings with the Prime Minister and opposition leaders, as guest of the Government of Gibraltar. (Registered 2 November 2000) Overseas visits 80ef1083 2001-05-14 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 0 2001-05-14-80ef1083-10019-0
dd83db5df3d64138c09615b03f9373d26463b1d6 9-13 October, to Russia, as a member of the All-Party British-Russia Group, to visit the Priobskaye Oil Field and to meet leading members of the State Duma in Moscow, sponsored by Yukos Oil. (Registered 2 November 2000) Overseas visits 80ef1083 2001-05-14 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 1 2001-05-14-80ef1083-10019-0
f8f8c6abf1c37088ffa7feff0bfc50e7d549c7a1 Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2000-11-10 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 0 2000-11-10-1f359ece-10019-0
3c71ae8fb06b6acc543843c34496bec73066b932 Occasional payment for addressing seminars, conferences and other speeches. Remunerated employment, office, profession etc 1f359ece 2000-11-10 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 1 2000-11-10-1f359ece-10019-0
92bb899a874c0b5d38c4a0e67fb397793ff49ac8 7-10 January 1999, to the Republic of Cyprus as guest of and sponsored by the Cypriot Parliament. (Registered 12 February 1999) Overseas visits 80ef1083 2000-11-10 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 0 2000-11-10-80ef1083-10019-0
87090a53f0280fb40502ee66ecc722dd8d7a828c 14-19 November 1999, to Iran with the British-Iranian All-Party Parliamentary Group, at the invitation of the Iranian Parliament and Government for the improvement of bilateral parliamentary relations. Travel between London and Tehran sponsored and paid for by British Airways. Accommodation in Tehran provided without charge as guests of the British Ambassador. One day and one night visit to Shiraz made as guests of the Iranian Parliament and the Governorship of Fars Province. (Registered 15 December 1999) Overseas visits 80ef1083 2000-11-10 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 1 2000-11-10-80ef1083-10019-0
b8b0cc7e81905358704a21b16a2e2194509f832d 9-11 September, to Gibraltar, to attend National Day and to have meetings with the Prime Minister and opposition leaders, as guest of the Government of Gibraltar. (Registered 2 November 2000) Overseas visits 80ef1083 2000-11-10 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 2 2000-11-10-80ef1083-10019-0
9388dd59d5c716e06a868cda15182979cb20afec 9-13 October, to Russia, as a member of the All-Party British-Russia Group, to visit the Priobskaye Oil Field and to meet leading members of the State Duma in Moscow, sponsored by Yukos Oil. (Registered 2 November 2000) Overseas visits 80ef1083 2000-11-10 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 3 2000-11-10-80ef1083-10019-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");
Powered by Datasette · Queries took 78.885ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette