items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where member_id = "uk.org.publicwhip/member/1057" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: item, date, sort_order, record_id, date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");