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

27 rows where person_id = "uk.org.publicwhip/person/10332" sorted by date descending

View and edit SQL

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
5fef51b7879d92c65fa9e81922b1c810cf789438 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2007-03-26 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2007-03-26-a41b9847-10332-0
8ef08ecb5ad2f00cd3851eb744115a42a6f2deb4 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2007-03-13 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2007-03-13-a41b9847-10332-0
7dffc8b6f8b821ccb0ef2a8e960d967504d4a474 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2007-02-27 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2007-02-27-a41b9847-10332-0
dbd0f87b0c82074b835dca0b092639ca99a919cd 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2007-02-06 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2007-02-06-a41b9847-10332-0
4d771ec6afdcd79a3f6025917e296009cb0789c8 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2007-01-23 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2007-01-23-a41b9847-10332-0
0fa5ca74461f043ea2e46f25a00e92faef6bdedc 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2007-01-09 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2007-01-09-a41b9847-10332-0
530e051eb63fcfe238c92cc8c0d9496222da11f7 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2006-12-11 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2006-12-11-a41b9847-10332-0
3642c7d05fa0430d7131f974a8f108bd560cdbec 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2006-11-27 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2006-11-27-a41b9847-10332-0
1aba2da31e975f08f22408b2dddaac45f2e22cae 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2006-11-06 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2006-11-06-a41b9847-10332-0
511c6a8addc91b0753eecb26bfd855034fae80ad 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2006-09-19 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2006-09-19-a41b9847-10332-0
c3de526a404ce25d42f9be6098b10f9a46ae1b9f 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2006-07-25 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2006-07-25-a41b9847-10332-0
1acdc3a5baaf8d9a8ce1730de5e5086c8527c375 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2006-06-21 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2006-06-21-a41b9847-10332-0
642ea2dcb8b671c8f2b2018cfe9f3272eca6e0eb 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2006-05-12 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2006-05-12-a41b9847-10332-0
3ca017f8ec9477e341c799ae2a48eeee90a4b6db 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2006-03-24 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2006-03-24-a41b9847-10332-0
610ea281669b077a19ef3c5eb72dbf8e9672a451 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2006-02-14 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2006-02-14-a41b9847-10332-0
34f65c2a93461f4a604c99c93ccc416c4e56597a 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2006-02-13 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2006-02-13-a41b9847-10332-0
fb65a7221a957b604409d916eafdbc6771ad979a 6 November 2005, I received complimentary tickets for me and two members of my family to attend the world premiere of the new Harry Potter film, given by Carolyn Dailey, Vice President and Senior Strategic Advisor Public Policy at Time Warner. (Registered 8 December 2005) Overseas benefits and gifts a41b9847 2005-12-14 Ruth Kelly uk.org.publicwhip/member/1433 Ruth Kelly uk.org.publicwhip/person/10332 0 2005-12-14-a41b9847-10332-0
daf9cf40ba2f57084b318fb664598d9f4444bdfb Payment received in April 2002 for previous work as Associate Editor of the House Magazine (Up to £5,000) . Resigned from post in June 2001. (Registered 24 April 2002) Remunerated employment, office, profession etc 1f359ece 2002-11-26 Ruth Kelly uk.org.publicwhip/member/1014 Ruth Kelly uk.org.publicwhip/person/10332 0 2002-11-26-1f359ece-10332-0
aeb97d2fde928652948de1e23bfee6357d30aef6 Payment received in April 2002 for previous work as Associate Editor of the House Magazine. Resigned from post in June 2001. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 Ruth Kelly uk.org.publicwhip/member/1014 Ruth Kelly uk.org.publicwhip/person/10332 0 2002-05-14-1f359ece-10332-0
99715d0b3261d39dadf6d604e5abc93f0189a607 Occasional earnings from journalism. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Ruth Kelly uk.org.publicwhip/member/332 Ruth Kelly uk.org.publicwhip/person/10332 0 2001-05-14-1f359ece-10332-0
5cb69c4ee150324b77557ead772138b31ec7e4cb Member of Political Opinion Panel of BPRI (Business Planning and Research International). Remunerated employment, office, profession etc 1f359ece 2001-05-14 Ruth Kelly uk.org.publicwhip/member/332 Ruth Kelly uk.org.publicwhip/person/10332 1 2001-05-14-1f359ece-10332-0
3a7fc819d55afdd290cdb3c14e8b911cdc7b66c1 Member of Harris Parliamentary Panel. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2001-05-14 Ruth Kelly uk.org.publicwhip/member/332 Ruth Kelly uk.org.publicwhip/person/10332 2 2001-05-14-1f359ece-10332-0
74f4e40261ce2b450912e476d59def163bbcc6c1 3-7 November 2000, to Rome, Italy, for the Jubilee of Government Leaders, Members of Parliament and Politicians. Travel expenses paid for by the All-Party Anglo-Italian Parliamentary Group. Accommodation and hospitality for myself, my husband and baby daughter paid for by the Vatican. (Registered 29 November 2000) Overseas visits 80ef1083 2001-05-14 Ruth Kelly uk.org.publicwhip/member/332 Ruth Kelly uk.org.publicwhip/person/10332 0 2001-05-14-80ef1083-10332-0
7a4fcae1bcbf599b4238abc80e3a59a4a220df60 Occasional earnings from journalism. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Ruth Kelly uk.org.publicwhip/member/332 Ruth Kelly uk.org.publicwhip/person/10332 0 2000-11-10-1f359ece-10332-0
420f473e356403c6cb191b89b2ae0c4a33c6dcb7 Member of Political Opinion Panel of BPRI (Business Planning and Research International). Remunerated employment, office, profession etc 1f359ece 2000-11-10 Ruth Kelly uk.org.publicwhip/member/332 Ruth Kelly uk.org.publicwhip/person/10332 1 2000-11-10-1f359ece-10332-0
a5262b45ed7eac55e068bbc287935e600cf2e36d Member of Harris Parliamentary Panel. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2000-11-10 Ruth Kelly uk.org.publicwhip/member/332 Ruth Kelly uk.org.publicwhip/person/10332 2 2000-11-10-1f359ece-10332-0
a60c3ce6f669b37cf5cbcaeb229b40dbc85ff0c6 14-17 October 1999, to Castel Gandolfo, Italy, to attend a conference organised by the British Council, air fare paid for by Go, one of the conference sponsors. (Registered 19 October 1999) Overseas visits 80ef1083 2000-11-10 Ruth Kelly uk.org.publicwhip/member/332 Ruth Kelly uk.org.publicwhip/person/10332 0 2000-11-10-80ef1083-10332-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");