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

29 rows where member_id = "uk.org.publicwhip/member/1057" 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
b25c4a2b92caf86db39838f38bf56ddfdb24aed4 Unpaid consultant in Stevens Lucas, Solicitors. Present partners of that firm are purchasing my previous interest in that firm. Remunerated employment, office, profession etc 1f359ece 2005-04-11 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2005-04-11-1f359ece-11057-0
7633f994733c395dd47265a41f71c738c68cb8bc Paid share of royalties from "The Bodyguard's Story" by Trevor Rees-Jones, published by Little Brown and Company. Remunerated employment, office, profession etc 1f359ece 2005-04-11 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 1 2005-04-11-1f359ece-11057-0
814c452df8c0254eae37d440012a7e92ab3a5724 18 January 2005, to Toulouse to attend the Airbus UK celebration of the A380. Return air travel from London to Toulouse and travel from my London home to London City Airport and return to the House of Commons paid for by Airbus UK. (Registered 21 January 2005) Overseas visit f455437c 2005-04-11 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2005-04-11-f455437c-11057-0
5596e71c3d837e10f02c4b4df9fe9aa3ace4a95d Unpaid consultant in Stevens Lucas, Solicitors. Present partners of that firm are purchasing my previous interest in that firm. Remunerated employment, office, profession etc.. 12405e8c 2005-01-28 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2005-01-28-12405e8c-11057-0
001d476f407dc26332f3131f2b6e1618fac64332 Paid share of royalties from "The Bodyguard's Story" by Trevor Rees-Jones, published by Little Brown and Company. Remunerated employment, office, profession etc.. 12405e8c 2005-01-28 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 1 2005-01-28-12405e8c-11057-0
7160490e61cd802d5c0caee239e6de0d984142a4 18 January 2005, to Toulouse to attend the Airbus UK celebration of the A380. Return air travel from London to Toulouse and travel from my London home to London City Airport and return to the House of Commons paid for by Airbus UK. (Registered 21 January 2005) Overseas visit f455437c 2005-01-28 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2005-01-28-f455437c-11057-0
8a317c83bb66905eb1bde95c33b78282354db379 Unpaid consultant in Stevens Lucas, Solicitors. Present partners of that firm are purchasing my previous interest in that firm. Remunerated employment, office, profession etc 1f359ece 2004-12-03 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2004-12-03-1f359ece-11057-0
d60dd4df7908fc402f3cf7b764a50edeed0c8b31 Paid share of royalties from "The Bodyguard's Story" by Trevor Rees-Jones, published by Little Brown and Company. Remunerated employment, office, profession etc 1f359ece 2004-12-03 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 1 2004-12-03-1f359ece-11057-0
b128e2c3b743943d5b18c77e11c26dbb80e9f320 Unpaid consultant in Stevens Lucas, Solicitors. Present partners of that firm are purchasing my previous interest in that firm. Remunerated employment, office, profession etc 1f359ece 2004-10-22 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2004-10-22-1f359ece-11057-0
d496f920478c3255c4277c3986e3fb00f6e15b58 Paid share of royalties from "The Bodyguard's Story" by Trevor Rees-Jones, published by Little Brown and Company. Remunerated employment, office, profession etc 1f359ece 2004-10-22 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 1 2004-10-22-1f359ece-11057-0
b5f5e579ef721dc9f768303e3163d2263f4cfa25 Unpaid consultant in Stevens Lucas, Solicitors. Present partners of that firm are purchasing my previous interest in that firm. Remunerated employment, office, profession etc 1f359ece 2004-09-08 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2004-09-08-1f359ece-11057-0
d06c2f88cdbe397d30811b17fe907a217d39177e Paid share of royalties from "The Bodyguard's Story" by Trevor Rees-Jones, published by Little Brown and Company. Remunerated employment, office, profession etc 1f359ece 2004-09-08 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 1 2004-09-08-1f359ece-11057-0
f127977c35b66d876e84b525009437f5799233b4 Unpaid consultant in Stevens Lucas, Solicitors. Present partners of that firm are purchasing my previous interest in that firm. Remunerated employment, office, profession etc 1f359ece 2004-07-16 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2004-07-16-1f359ece-11057-0
323b713e9e4b4ba1786d37beb50ebd4139553bbd Paid share of royalties from "The Bodyguard's Story" by Trevor Rees-Jones, published by Little Brown and Company. Remunerated employment, office, profession etc 1f359ece 2004-07-16 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 1 2004-07-16-1f359ece-11057-0
a11db6ea411cad53b3ca3bd42054b03d1eb0c60a 21-25 November 2002, to Albania with a group of parliamentarians from different parts of the world, to inspect development projects which have been funded by the World Bank. The visit was funded by the World Bank. (Registered 17 December 2002) Overseas visits 80ef1083 2004-07-16 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2004-07-16-80ef1083-11057-0
21c57e2a7ac9c0027843f76782eb727303e4f9ad Unpaid consultant in Stevens Lucas, Solicitors. Present partners of that firm are purchasing my previous interest in that firm. Remunerated employment, office, profession etc 1f359ece 2004-05-21 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2004-05-21-1f359ece-11057-0
2934a5a6d46aaad0753f7fe0a5827360deeda6a5 Paid share of royalties from "The Bodyguard's Story" by Trevor Rees-Jones, published by Little Brown and Company. Remunerated employment, office, profession etc 1f359ece 2004-05-21 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 1 2004-05-21-1f359ece-11057-0
31ee62466794375ec8c1e8acf36e745d7126ca0e 21-25 November 2002, to Albania with a group of parliamentarians from different parts of the world, to inspect development projects which have been funded by the World Bank. The visit was funded by the World Bank. (Registered 17 December 2002) Overseas visits 80ef1083 2004-05-21 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2004-05-21-80ef1083-11057-0
64aacaf02268c855751214b7b0ef71c1fcd5a712 Unpaid consultant in Stevens Lucas, Solicitors. Present partners of that firm are purchasing my previous interest in that firm. Remunerated employment, office, profession etc 1f359ece 2004-01-31 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2004-01-31-1f359ece-11057-0
8f0e4a485147dd1a5e7150fae3a67688c6fff846 Paid share of royalties from "The Bodyguard's Story" by Trevor Rees-Jones, published by Little Brown and Company. Remunerated employment, office, profession etc 1f359ece 2004-01-31 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 1 2004-01-31-1f359ece-11057-0
c2e213789715147a3912e5ea3238b04215502095 21-25 November 2002, to Albania with a group of parliamentarians from different parts of the world, to inspect development projects which have been funded by the World Bank. The visit was funded by the World Bank. (Registered 17 December 2002) Overseas visits 80ef1083 2004-01-31 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2004-01-31-80ef1083-11057-0
189899732c55fe18bb91452a49248f4ed98ef604 Unpaid consultant in Stevens Lucas, Solicitors. Present partners of that firm are purchasing my previous interest in that firm. Remunerated employment, office, profession etc 1f359ece 2003-12-04 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2003-12-04-1f359ece-11057-0
3e67acb7868129ed2c919a92f54983a5cd498e03 Paid share of royalties from "The Bodyguard's Story" by Trevor Rees-Jones, published by Little Brown and Company. Remunerated employment, office, profession etc 1f359ece 2003-12-04 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 1 2003-12-04-1f359ece-11057-0
10faede3846aa12533dd7101cfe3fddccab40b61 21-25 November 2002, to Albania with a group of parliamentarians from different parts of the world, to inspect development projects which have been funded by the World Bank. The visit was funded by the World Bank. (Registered 17 December 2002) Overseas visits 80ef1083 2003-12-04 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2003-12-04-80ef1083-11057-0
8c38a8ac486f2f367af66c6bb9e9282e1e98af6a Unpaid consultant in Stevens Lucas, Solicitors. Present partners of that firm are purchasing my previous interest in that firm. Remunerated employment, office, profession etc 1f359ece 2002-11-26 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2002-11-26-1f359ece-11057-0
83611689e62e6badaa471f5109e36770c77d88ad Paid share of royalties from The Bodyguard's Story" by Trevor Rees-Jones, published by Little Brown and Company. Remunerated employment, office, profession etc 1f359ece 2002-11-26 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 1 2002-11-26-1f359ece-11057-0
512f9ed6b5b14fd3418649cc2840ad00ef1cf799 Formerly non-executive director of Robert Jones and Agnes Hunt Orthopaedic and District NHS Trust (resigned May 2001). Remunerated directorships ead1ca87 2002-05-14 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2002-05-14-ead1ca87-11057-0
92c9f82bcfcf47afa6afc6a500579e0f19eeec6f Unpaid consultant in Stevens Lucas, Solicitors. Present partners of that firm are purchasing my previous interest in that firm. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 0 2002-05-14-1f359ece-11057-0
32ba0dd692ee2f1591d6489331b76428a69ceb96 Paid share of royalties from "The Bodyguard's Story" by Trevor Rees-Jones, published by Little Brown and Company. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Ian Lucas uk.org.publicwhip/member/1057 Ian Lucas uk.org.publicwhip/person/11057 1 2002-05-14-1f359ece-11057-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");