items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where "date" is on date 2013-03-11 and person_id = "uk.org.publicwhip/person/10065" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
e9a3f659e18f4d0b3696e763b776eb200d02ea8a | October 2012, received £250 for lecture and Q & A for visiting students from European Studies. Address: c/o Rhodes College, 2000 N Parkway, Memphis, TN 38112-1690 . H ours: 90 mins. (Registered 13 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 0 | 2013-03-11-1f359ece-10065-0 |
61a975b44637457618a13d0f8c4c14c62514c5e7 | ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 1 | 2013-03-11-1f359ece-10065-0 |
85ab2985bd512e7b5a54dcae0f4afe711715ec3e | 15 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 2 | 2013-03-11-1f359ece-10065-0 |
1292820b03bc2f1777e28caaea38d538b0741169 | 28 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 3 | 2013-03-11-1f359ece-10065-0 |
6cb64d31053bce588bcfeba7313f3c74667b76f5 | 13 July 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 4 | 2013-03-11-1f359ece-10065-0 |
2d6e6aec743bb77768bd75f21adbe0beb19ad748 | 27 November 2012, received £75 for completing a survey. Hours: 1 hr (Registered 4 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 5 | 2013-03-11-1f359ece-10065-0 |
a53bedf5fefb33d881ecc12894c768e5465da01c | October 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 6 | 2013-03-11-1f359ece-10065-0 |
86a0f99ab6c28d1f8a10743361862e43bce58361 | December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 7 | 2013-03-11-1f359ece-10065-0 |
a506ebaf033f448b9c6efa69fe494b3dc5cd07cc | 20 December 2012, received £75 for completing a survey. Hours: 1 hr (Registered 21 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 8 | 2013-03-11-1f359ece-10065-0 |
fc0324554a39135357880047f11ff270f69b29d4 | Ipsos MORI, 79-81 Borough Road, London SE1 1FY. | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 9 | 2013-03-11-1f359ece-10065-0 |
e928e57ce6cbf7b400c20adf9154141b9a7427b9 | 16 January 2012, received £150 for completing survey. Hours: 1.5 hours (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 10 | 2013-03-11-1f359ece-10065-0 |
6d66c0bc9e4b38d0fbe5875aaeebf47fc2469dcd | October 2012, received £150 for survey. Hours: 90 mins. (Registered 14 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 11 | 2013-03-11-1f359ece-10065-0 |
62fcdf8b888dd41aa6a32b0b55b7653860cfa40f | 8 January 2013, received £150 for survey. Hours: 1.5 hrs. (Registered 21 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 12 | 2013-03-11-1f359ece-10065-0 |
e826fc574e83001b15bf6e0685e2cdd9251ce9f2 | 25 January 2012, received £500 from Waterfront Conference Company, 130 - 132 Tooley Street , London SE1 2TU for chairing conference. Hours: 5 hrs. (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 13 | 2013-03-11-1f359ece-10065-0 |
58bd20892d15d5914ffbbc02079bfdce78dc3129 | Consultant on energy saving products for Conditionaire International Ltd, Wellington House, 7-9 Church Road, Tunbridge Wells, Kent TN1 1HT. Conditionaire also heads a consortium of small companies selling energy and water saving products, including Fridgesaver, Liet Corp, Smartcool and WEMS. Paid by commission only. (£0-£5,000, estimated). (Registered 15 June 2012; updated 17 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 14 | 2013-03-11-1f359ece-10065-0 |
9e321827215f6da5fe3d57b949fcb27846a4d846 | 28 June 2012, received £250 for article for Military History magazine from Current Publishing, Lamb House, Chiswick, London W4 2PD. Hours: 8 hrs. (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 15 | 2013-03-11-1f359ece-10065-0 |
701623573a905359c2213b9368d2fa5e421e1346 | Received £100 for evening lecture to Edinburgh University Club of London, 146 Elizabeth Ave, Amersham, Bucks HP6 6RG. Hours: 3 hrs. (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 16 | 2013-03-11-1f359ece-10065-0 |
5698dfb44d5fa8cb987d71ac1f344b32229ce0cb | December 2012, payment of £75 from Populus for participation in opinion survey. Address: 10 Northburgh Street , London , EC1V 0AT . Hours: 1 hr. Payment donated to local organisation. our (Registered 13 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 17 | 2013-03-11-1f359ece-10065-0 |
1fab0d0990294b204619ebd5541f73413672cb58 | Name of donor: Inmarsat plc | Overseas visits 80ef1083 | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 0 | 2013-03-11-80ef1083-10065-0 |
ef7bf2a9de4503499dcd93f1e737118d05efe677 | Address of donor: 99 City Road, London EC1Y 1AX | Overseas visits 80ef1083 | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 1 | 2013-03-11-80ef1083-10065-0 |
8f8d7d81685eeb977a73793ea33b5012b59f6b21 | Amount of donation (or estimate of the probable value): airfares and three nights’ accommodation for two people, with an estimated value of £680, plus meals | Overseas visits 80ef1083 | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 2 | 2013-03-11-80ef1083-10065-0 |
0a93106392a57696c1d2bad6a8550e9546e6ec25 | Destination of visit: Lisbon | Overseas visits 80ef1083 | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 3 | 2013-03-11-80ef1083-10065-0 |
b4cc62e8cb97597ba38b7727250adbaa47d9e383 | Date of visit: 7-10 June 2012 | Overseas visits 80ef1083 | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 4 | 2013-03-11-80ef1083-10065-0 |
b4117bb738183fced6a9a93b0174593bbcf06b3f | Purpose of visit: Visit to Volvo round the world race and discussions on maritime and other technologies | Overseas visits 80ef1083 | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 5 | 2013-03-11-80ef1083-10065-0 |
b6c34f4b6594a2131a4d0d61e27c8b9d6d6d3eb2 | (Registered 20 June 2012; updated 13 December 2012 ) | Overseas visits 80ef1083 | 2013-03-11 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 6 | 2013-03-11-80ef1083-10065-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");