items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where member_id = "uk.org.publicwhip/member/786" sorted by date descending
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
91d94aaf2689bf5ecc9db10a2e5d9c596f444f31 | The Programme Director of the British-Italian Parliamentary Group, whose services are paid for by the British-Italian Parliamentary Group out of funds provided by its sponsors, is based in my office. | Sponsorship or financial or material support 9e46def6 | 2005-04-11 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2005-04-11-9e46def6-10094-0 |
d1ff456e10338cbdc0a96a0dbadbc44e61ad4844 | The Arthur Palmer Trust (set up in memory of the first Labour MP for Wimbledon) provides financial assistance in respect of my constituency database, newsletter and other administrative support. | Sponsorship or financial or material support 9e46def6 | 2005-04-11 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 1 | 2005-04-11-9e46def6-10094-0 |
015d31558c5ff12c5ea1b3bbc76a3be6a50b54fe | 6-8 November 2004, to Genoa for the Portfino Conference, a tri-lateral UK/US/Italian conference on the future of the transatlantic relationship. Fares paid by GKN and accommodation provided by Orient Express Hotels. (Registered 24 January 2005) | Overseas visits 80ef1083 | 2005-04-11 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2005-04-11-80ef1083-10094-0 |
81ee28d6a2f76a8de2ddb2b218a0fd774dc3705a | The Programme Director of the British-Italian Parliamentary Group, whose services are paid for by the British-Italian Parliamentary Group out of funds provided by its sponsors, is based in my office. | Sponsorship or financial or material support 9e46def6 | 2005-01-28 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2005-01-28-9e46def6-10094-0 |
085a1740ff0ce57327d126b138549d5a06365063 | The Arthur Palmer Trust (set up in memory of the first Labour MP for Wimbledon) provides financial assistance in respect of my constituency database, newsletter and other administrative support. | Sponsorship or financial or material support 9e46def6 | 2005-01-28 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 1 | 2005-01-28-9e46def6-10094-0 |
2a2fbc442c147e51c35a2a40ec321f4d42673677 | 6-8 November 2004, to Genoa for the Portfino Conference, a tri-lateral UK/US/Italian conference on the future of the transatlantic relationship. Fares paid by GKN and accommodation provided by Orient Express Hotels. (Registered 24 January 2005) | Overseas visits 80ef1083 | 2005-01-28 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2005-01-28-80ef1083-10094-0 |
3e4a8e13c91a3c02d7d40446cf5a303ca7c06a73 | The Programme Director of the British-Italian Parliamentary Group, whose services are paid for by the British-Italian Parliamentary Group out of funds provided by its sponsors, is based in my office. | Sponsorship or financial or material support 9e46def6 | 2004-12-03 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2004-12-03-9e46def6-10094-0 |
f9dc11aa9dedb2f87d5d2b815b5f9d99a5c6bfdc | The Programme Director of the British-Italian Parliamentary Group, whose services are paid for by the British-Italian Parliamentary Group out of funds provided by its sponsors, is based in my office. | Sponsorship or financial or material support 9e46def6 | 2004-10-22 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2004-10-22-9e46def6-10094-0 |
c9650356e48e983104b097c93e5be998dcb639a9 | The Programme Director of the British-Italian Parliamentary Group, whose services are paid for by the British-Italian Parliamentary Group out of funds provided by its sponsors, is based in my office. | Sponsorship or financial or material support 9e46def6 | 2004-09-08 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2004-09-08-9e46def6-10094-0 |
705b3d55a2f1adc0f7576cf44687a193093f3f7d | The Programme Director of the British-Italian Parliamentary Group, whose services are paid for by the British-Italian Parliamentary Group out of funds provided by its sponsors, is based in my office. | Sponsorship or financial or material support 9e46def6 | 2004-07-16 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2004-07-16-9e46def6-10094-0 |
5d401e2dae58e8f6be906cdebbe011a389143e48 | The Programme Director of the British-Italian Parliamentary Group, whose services are paid for by the British-Italian Parliamentary Group out of funds provided by its sponsors, is based in my office. | Sponsorship or financial or material support 9e46def6 | 2004-05-21 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2004-05-21-9e46def6-10094-0 |
fc8216efe696373ceaea20349d0a6c120af92850 | The Programme Director of the British-Italian Parliamentary Group, whose services are paid for by the British-Italian Parliamentary Group out of funds provided by its sponsors, is based in my office. | Sponsorship or financial or material support 9e46def6 | 2004-01-31 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2004-01-31-9e46def6-10094-0 |
767bb187a0363656b849d6d361daaae56d997b24 | Reimbursement by the All-Party British Italian Parliamentary Group, out of funds provided by its sponsors, GKN, of expenses incurred by me, including travel expenses to Italy, in the provision of office facilities (including staff) for servicing the All-Party Group. | Sponsorship or financial or material support 9e46def6 | 2003-12-04 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2003-12-04-9e46def6-10094-0 |
611d2745cdc29d9b3248ef56559b4c21969e8d22 | 12 April 2002, fee for seminar for representatives of the Small Business Federation of Reggio Emilia, Italy. (Registered 22 May 2002) | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2002-11-26-1f359ece-10094-0 |
b3c8f48979cfd0d73ec4cdba223d61e28ebc3397 | Reimbursement by the All-Party British Italian Parliamentary Group, out of funds provided by its sponsors, GKN, of expenses incurred by me, including travel expenses to Italy, in the provision of office facilities (including staff) for servicing the All-Party Group. | Sponsorship or financial or material support 9e46def6 | 2002-11-26 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2002-11-26-9e46def6-10094-0 |
9f214105c13b8bdd0a60a1a105b16bede10fb76e | Member of Harris Parliamentary Panel. (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2002-05-14-1f359ece-10094-0 |
ef3e17c6a1755cf451a0fefdba9a224f538ed535 | Occasional lectures and articles on British and European politics. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 1 | 2002-05-14-1f359ece-10094-0 |
0de70d1a6583a9081b893c849b9c722e9ce4d40a | A contribution of more than 25% of my election expenses at the 2001 General Election was provided by GMB. (Registered 12 October 2001) | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2002-05-14-9e46def6-10094-0 |
5201a4348bab86b7e77b2224496eeae94835e033 | Some financial support for my work as a constituency Member provided by the Arthur Palmer Memorial Trust, created in memory of the first Labour Member to represent Wimbledon. | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 1 | 2002-05-14-9e46def6-10094-0 |
6261035ab0acb4bdb5f8c7569983bd7f5d405612 | Some material benefit (excluding monetary payments), e.g. office and storage space and use of facilities, including the use of a free postage facility, from the trade union UNIFY). | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 2 | 2002-05-14-9e46def6-10094-0 |
c5ef05b2893db7b3f28b2d434baa442db76d3ab9 | Reimbursement by the All-Party British Italian Parliamentary Group, out of funds provided by its sponsors, of expenses incurred by me in the provision of office facilities (including staff) for servicing the All-Party Group. | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 3 | 2002-05-14-9e46def6-10094-0 |
4ffa8411b61b3c9c7ff3e2e1bfe5fdfec64ffc73 | Director (non-remunerated) of Wimbledon Civic Forum Trust Ltd. | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Roger Casale uk.org.publicwhip/member/786 | Roger Casale uk.org.publicwhip/person/10094 | 0 | 2002-05-14-265f2269-10094-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");