items

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

41 rows where member_id = "uk.org.publicwhip/member/1021" sorted by date descending

View and edit SQL

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

hash item category_id date ▲ member_id person_id sort_order record_id
c08d2ea5fc2967645266b7c295d8d5145594ce28 Fee (Up to £5,000) from BBC for television programme, distributed equally between four charities: Remunerated employment, office, profession etc 1f359ece 2004-12-03 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 0 2004-12-03-1f359ece-10339-0
7b35a8061c4cfcb10e57c91675dbb4a22369e0f7 (i) the Fazakerley Family Support Group Remunerated employment, office, profession etc 1f359ece 2004-12-03 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 1 2004-12-03-1f359ece-10339-0
5347c6cc4ec62d7b103ab6644c40fb4d449fbda8 (ii) Anfield Junior League Remunerated employment, office, profession etc 1f359ece 2004-12-03 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 2 2004-12-03-1f359ece-10339-0
7188f6b7bdfd9f87602f3797ae0110873029ff24 (iii) Walton and Kirkdale Junior League Remunerated employment, office, profession etc 1f359ece 2004-12-03 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 3 2004-12-03-1f359ece-10339-0
53310d685dcfc3778eef26f5e2546fcb7cc39f8c (iv) Scotland Road Junior League Remunerated employment, office, profession etc 1f359ece 2004-12-03 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 4 2004-12-03-1f359ece-10339-0
9e0320e907771d7ac55e0f1ea2e081432db0b9d7 (Registered 15 January 2004) Remunerated employment, office, profession etc 1f359ece 2004-12-03 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 5 2004-12-03-1f359ece-10339-0
3f58d91eb9015cb37472409fd7828697a2d7205e Fee (Up to £5,000) from BBC for television programme, distributed equally between four charities: Remunerated employment, office, profession etc 1f359ece 2004-10-22 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 0 2004-10-22-1f359ece-10339-0
93ceba52a7ae6583e0d5bf2f30f7891f5915562b (i) the Fazakerley Family Support Group Remunerated employment, office, profession etc 1f359ece 2004-10-22 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 1 2004-10-22-1f359ece-10339-0
96f5306d8fd6e4fd6cf6317f67034ae87870a25d (ii) Anfield Junior League Remunerated employment, office, profession etc 1f359ece 2004-10-22 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 2 2004-10-22-1f359ece-10339-0
7830ff98465ca6c7f4c1962d98d7c74a5b32d4e0 (iii) Walton and Kirkdale Junior League Remunerated employment, office, profession etc 1f359ece 2004-10-22 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 3 2004-10-22-1f359ece-10339-0
860ae7894b7b9c2e86da13d2c17eac50bcc01ac8 (iv) Scotland Road Junior League Remunerated employment, office, profession etc 1f359ece 2004-10-22 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 4 2004-10-22-1f359ece-10339-0
3531a5ad40db4818320646874cdfabd12e980378 (Registered 15 January 2004) Remunerated employment, office, profession etc 1f359ece 2004-10-22 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 5 2004-10-22-1f359ece-10339-0
7f2553a1021c6ed0ed2fc6d81f525ede25d46ee5 Fee (Up to £5,000) from BBC for television programme, distributed equally between four charities: Remunerated employment, office, profession etc 1f359ece 2004-09-08 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 0 2004-09-08-1f359ece-10339-0
083b1667e90ebf9b2ceddaa95e4a94969b3bfa75 (i) the Fazakerley Family Support Group Remunerated employment, office, profession etc 1f359ece 2004-09-08 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 1 2004-09-08-1f359ece-10339-0
47fe98efe55f4e0f40c21624c439cf34d4984199 (ii) Anfield Junior League Remunerated employment, office, profession etc 1f359ece 2004-09-08 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 2 2004-09-08-1f359ece-10339-0
cf4ee978a6b1608e07a84cbfbf3ba0300e90bc41 (iii) Walton and Kirkdale Junior League Remunerated employment, office, profession etc 1f359ece 2004-09-08 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 3 2004-09-08-1f359ece-10339-0
167593758b90d4e033263a41df1b65a7203b8638 (iv) Scotland Road Junior League Remunerated employment, office, profession etc 1f359ece 2004-09-08 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 4 2004-09-08-1f359ece-10339-0
966e37011f084de1002ea9e6f6e721999363a247 (Registered 15 January 2004) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 5 2004-09-08-1f359ece-10339-0
ce1d880700059f242a5a22f7a000afe3dd872108 Fee (Up to £5,000) from BBC for television programme, distributed equally between four charities: Remunerated employment, office, profession etc 1f359ece 2004-07-16 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 0 2004-07-16-1f359ece-10339-0
b6c4db6398afdb66f850e71c6cca2cffb579b58a (i) the Fazakerley Family Support Group Remunerated employment, office, profession etc 1f359ece 2004-07-16 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 1 2004-07-16-1f359ece-10339-0
44e4cb8b7bb9968d2bde204ba8f52b221e01f44e (ii) Anfield Junior League Remunerated employment, office, profession etc 1f359ece 2004-07-16 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 2 2004-07-16-1f359ece-10339-0
35396317cccc8854689d5ffff563d6e32c931962 (iii) Walton and Kirkdale Junior League Remunerated employment, office, profession etc 1f359ece 2004-07-16 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 3 2004-07-16-1f359ece-10339-0
3dbe0cd6834d42ecd77c15a3f413a7f2d058a758 (iv) Scotland Road Junior League Remunerated employment, office, profession etc 1f359ece 2004-07-16 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 4 2004-07-16-1f359ece-10339-0
100e79238ca8c1104d359b8abcfd5c96f69859aa (Registered 15 January 2004) Remunerated employment, office, profession etc 1f359ece 2004-07-16 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 5 2004-07-16-1f359ece-10339-0
8f9b00391791358fa7c7d67b8891f613bf47eb3b Fee (Up to £5,000) from BBC for television programme, distributed equally between four charities: Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 0 2004-05-21-1f359ece-10339-0
da68e39f5b04840aaf4a155511d7c84181161904 (i) the Fazakerley Family Support Group Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 1 2004-05-21-1f359ece-10339-0
930328d72d81f7c6aa7ecb4bc2e6a9fd9ba72695 (ii) Anfield Junior League Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 2 2004-05-21-1f359ece-10339-0
017ca0c18b3a2866d0e33fe9176ce182bb77957a (iii) Walton and Kirkdale Junior League Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 3 2004-05-21-1f359ece-10339-0
00ccf4277428010b5a690259f42c1dec2dbeb3f2 (iv) Scotland Road Junior League Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 4 2004-05-21-1f359ece-10339-0
85fccddc379fffe2e91c86e89a332f5d18c8f4b6 (Registered 15 January 2004) Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 5 2004-05-21-1f359ece-10339-0
51c2c77f2ab4472893101d4f90ecc811112354b7 Fee (Up to £5,000) from BBC for television programme, distributed equally between four charities: Remunerated employment, office, profession etc 1f359ece 2004-01-31 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 0 2004-01-31-1f359ece-10339-0
a91d669a6326c0bd5f826b0358a93859b2713fc6 (i) the Fazakerley Family Support Group Remunerated employment, office, profession etc 1f359ece 2004-01-31 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 1 2004-01-31-1f359ece-10339-0
7384160b6dfb2fa24e8d6493c9e418d5c3fd3524 (ii) Anfield Junior League Remunerated employment, office, profession etc 1f359ece 2004-01-31 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 2 2004-01-31-1f359ece-10339-0
145f14a062d5db161b04eb46131295e30c774835 (iii) Walton and Kirkdale Junior League Remunerated employment, office, profession etc 1f359ece 2004-01-31 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 3 2004-01-31-1f359ece-10339-0
62552b107654d8183fb5604ddab005152335cf39 (iv) Scotland Road Junior League Remunerated employment, office, profession etc 1f359ece 2004-01-31 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 4 2004-01-31-1f359ece-10339-0
26f80b968245870cc4f741ff043aed93da163c1f (Registered 15 January 2004) Remunerated employment, office, profession etc 1f359ece 2004-01-31 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 5 2004-01-31-1f359ece-10339-0
e4e89ea27ceb9e7a1fd3099ec986ac8a3725d44d 4-13 January 2003, to India with a delegation of MPs, sponsored by the Labour Friends of India. Airline tickets and hospitality in India provided by the Confederation of Indian Industry and the Government of India. (Registered 21 January 2003) Overseas visits 80ef1083 2004-01-31 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 0 2004-01-31-80ef1083-10339-0
1a03b134e6c0834e304f0524097f048096fa213e 4-13 January 2003, to India with a delegation of MPs, sponsored by the Labour Friends of India. Airline tickets and hospitality in India provided by the Confederation of Indian Industry and the Government of India. (Registered 21 January 2003) Overseas visits 80ef1083 2003-12-04 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 0 2003-12-04-80ef1083-10339-0
4d2383dcff43a72f32452ecd09317a5cd5a183aa 9-18 May 2002, to China with delegation from All-Party China Group. Cost of transport, hotels and hospitality in China paid for by the Government of China. (Registered 12 June 2002) Overseas visits 80ef1083 2002-11-26 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 0 2002-11-26-80ef1083-10339-0
fac7e24b9cb042090eb6a2eabed7f8abbfa02778 Occasional payment for articles and media appearances. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 0 2002-05-14-1f359ece-10339-0
ef823a609acc9c643139ee04317f5c2e7a9c0bb5 10 November 2001, one ticket to the England v Australia Rugby Union International at Twickenham, courtesy of News International. (Registered 26 November 2001) Gifts, benefits and hospitality (UK) 84642823 2002-05-14 Peter Kilfoyle uk.org.publicwhip/member/1021 Peter Kilfoyle uk.org.publicwhip/person/10339 0 2002-05-14-84642823-10339-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 · Query took 32.407ms · Data source: mySociety Data · About: simonw/register-of-members-interests