items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
26 rows where "date" is on date 2013-04-08 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 |
---|---|---|---|---|---|---|---|
b7fd9770f3ccf4e4335785a42db03428812fb97d | 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-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 0 | 2013-04-08-1f359ece-10065-0 |
4a1636d3df502610f3927b4e14e42a254d3dae77 | ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 1 | 2013-04-08-1f359ece-10065-0 |
cfa2ee605b04cc4a579e9a986256f87fc1993289 | 15 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 2 | 2013-04-08-1f359ece-10065-0 |
b9ffef8536455f0bafa1799cca240b0299c4d199 | 28 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 3 | 2013-04-08-1f359ece-10065-0 |
e74ac76d757e3e4633545c9354404d83d245ca80 | 13 July 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 4 | 2013-04-08-1f359ece-10065-0 |
e2f00ba64eabfc7e97967ff150ab5e361e8d90e1 | 27 November 2012, received £75 for completing a survey. Hours: 1 hr (Registered 4 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 5 | 2013-04-08-1f359ece-10065-0 |
dfef90ea2c3194d6c93577572f1440b39b62e5c3 | October 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 6 | 2013-04-08-1f359ece-10065-0 |
5a52f9e3d198f11602cc8562f9e82670ada8ba8f | December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 7 | 2013-04-08-1f359ece-10065-0 |
8ac5150ea04d5c9d5238695cf1ed72d77c7a3ac9 | 20 December 2012, received £75 for completing a survey. Hours: 1 hr (Registered 21 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 8 | 2013-04-08-1f359ece-10065-0 |
a516c7b1d81fdd35df8578125387caddae12734b | 26 February 2013, received £75 for completing a survey. Hours: 1 hr (Registered 14 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 9 | 2013-04-08-1f359ece-10065-0 |
901bac801b22879c6a1323016760243d6bb82b86 | Ipsos MORI, 79-81 Borough Road, London SE1 1FY. | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 10 | 2013-04-08-1f359ece-10065-0 |
b17e16a81af913a09762d11cb72f3cc60f6c5511 | 16 January 2012, received £150 for completing survey. Hours: 1.5 hours (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 11 | 2013-04-08-1f359ece-10065-0 |
52f7dc0f9b08552600635e8ab3bf57151ed8fd45 | October 2012, received £150 for survey. Hours: 90 mins. (Registered 14 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 12 | 2013-04-08-1f359ece-10065-0 |
4534dbb587553f7a0d7beec5ce13f1ea1e03f87d | 8 January 2013, received £150 for survey. Hours: 1.5 hrs. (Registered 21 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 13 | 2013-04-08-1f359ece-10065-0 |
4668c9b8daa61835081de1d9393d1161cd27413a | 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-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 14 | 2013-04-08-1f359ece-10065-0 |
da7ae01e163c89bcc486d919f63bc3b555ada769 | 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-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 15 | 2013-04-08-1f359ece-10065-0 |
37f4f71784df0d75afa7688c4c596ab921ee8e1c | 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-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 16 | 2013-04-08-1f359ece-10065-0 |
256ad4abe16ea1e40a7ec64eed20b464a80b762e | 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-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 17 | 2013-04-08-1f359ece-10065-0 |
e505d57fb52fc5e82c23a2499fc84187e8426ed6 | 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-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 18 | 2013-04-08-1f359ece-10065-0 |
9cb05bc3c6a450b1d13a066f589af088a3485702 | Name of donor: Inmarsat plc | Overseas visits 80ef1083 | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 0 | 2013-04-08-80ef1083-10065-0 |
1e29108730c48410be8e5e0c32624397dc0a6022 | Address of donor: 99 City Road, London EC1Y 1AX | Overseas visits 80ef1083 | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 1 | 2013-04-08-80ef1083-10065-0 |
98ed80ab99e8fd397a643a7939170825b72cd7af | 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-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 2 | 2013-04-08-80ef1083-10065-0 |
f3f9ad492441ee824ad152ac7da40d9359bef347 | Destination of visit: Lisbon | Overseas visits 80ef1083 | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 3 | 2013-04-08-80ef1083-10065-0 |
dfd7b157181bb5c11920cb2fecce889331f4efec | Date of visit: 7-10 June 2012 | Overseas visits 80ef1083 | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 4 | 2013-04-08-80ef1083-10065-0 |
864482d9c4805b9120fcdaa1c3671adfc41495e2 | Purpose of visit: Visit to Volvo round the world race and discussions on maritime and other technologies | Overseas visits 80ef1083 | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 5 | 2013-04-08-80ef1083-10065-0 |
6453d3fc6d4c08d9e0c91b7d262e44393288f942 | (Registered 20 June 2012; updated 13 December 2012) | Overseas visits 80ef1083 | 2013-04-08 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 6 | 2013-04-08-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");