items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where "date" is on date 2013-02-25 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 |
---|---|---|---|---|---|---|---|
94795bff958c61edb730d6ce574c19fa83b16a03 | 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-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 0 | 2013-02-25-1f359ece-10065-0 |
37989bf66a46bb2bc853d7ea80cd1fd186861754 | ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 1 | 2013-02-25-1f359ece-10065-0 |
77fe4634b9b3882fcc939bbcebe431e59a527dc7 | 15 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 2 | 2013-02-25-1f359ece-10065-0 |
a4d38179dafe9481f662c9279badf1d324a8ecae | 28 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 3 | 2013-02-25-1f359ece-10065-0 |
dcf7b015e2bd6d7434a2314678259817d8f0b59b | 13 July 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 4 | 2013-02-25-1f359ece-10065-0 |
d6a5fad92003322882abaace5f5834b8ca44587e | 27 November 2012, received £75 for completing a survey. Hours: 1 hr (Registered 4 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 5 | 2013-02-25-1f359ece-10065-0 |
161de0bc130776bdd8c587b8e490e63f2ce38833 | October 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 6 | 2013-02-25-1f359ece-10065-0 |
d71e4f7b9ea3bbe3a8138d77f400801e115bb3d5 | December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 7 | 2013-02-25-1f359ece-10065-0 |
3e42b092c4248d450eb3e287f51f42a3b8651c72 | 20 December 2012, received £75 for completing a survey. Hours: 1 hr (Registered 21 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 8 | 2013-02-25-1f359ece-10065-0 |
7f2711a653d16bb796f7b506198b6eb67821a964 | Ipsos MORI, 79-81 Borough Road, London SE1 1FY. | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 9 | 2013-02-25-1f359ece-10065-0 |
603ead1c20df4de90c2f9383edaa27fbfb910cc1 | 16 January 2012, received £150 for completing survey. Hours: 1.5 hours (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 10 | 2013-02-25-1f359ece-10065-0 |
5e5315c0c085ad08f623a3c93e6de8d2059c69a3 | October 2012, received £150 for survey. Hours: 90 mins. (Registered 14 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 11 | 2013-02-25-1f359ece-10065-0 |
203bd00ed95eb33388ce4f36c60c10dcb81a3863 | 8 January 2013, received £150 for survey. Hours: 1.5 hrs. (Registered 21 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 12 | 2013-02-25-1f359ece-10065-0 |
9bcc4a78e9c3607434de6fae38e59e3efb15cfec | 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-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 13 | 2013-02-25-1f359ece-10065-0 |
176f32d58415395ec6665622858bffc055d6abdb | 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-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 14 | 2013-02-25-1f359ece-10065-0 |
e8a2356ca694cf7a1af8c98c5d4240c01dace4b3 | 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-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 15 | 2013-02-25-1f359ece-10065-0 |
e4076aba6a3bd1706b86eb86468217c577f5da8b | 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-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 16 | 2013-02-25-1f359ece-10065-0 |
2879b0f02d2b7c737db56303f6e70359fe790e69 | 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-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 17 | 2013-02-25-1f359ece-10065-0 |
b90c1bbf8441bf5d45a1080310e1887c8c8bbc31 | Name of donor: Inmarsat plc | Overseas visits 80ef1083 | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 0 | 2013-02-25-80ef1083-10065-0 |
437164a67871b6ee77ec661e0480e4c90073cbca | Address of donor: 99 City Road, London EC1Y 1AX | Overseas visits 80ef1083 | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 1 | 2013-02-25-80ef1083-10065-0 |
6010882a7c38fddbf167db48e45a6b8f297dabb9 | 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-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 2 | 2013-02-25-80ef1083-10065-0 |
53019561e33df413183de8f27bf6dda205ba2673 | Destination of visit: Lisbon | Overseas visits 80ef1083 | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 3 | 2013-02-25-80ef1083-10065-0 |
45b225a9eecc5b48b6fef7cadfb677a48c026bf1 | Date of visit: 7-10 June 2012 | Overseas visits 80ef1083 | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 4 | 2013-02-25-80ef1083-10065-0 |
400afc7fe3192acb28a9ddb3ccd185f60c79479f | Purpose of visit: Visit to Volvo round the world race and discussions on maritime and other technologies | Overseas visits 80ef1083 | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 5 | 2013-02-25-80ef1083-10065-0 |
097c6d9b3e9a74b477b22b321205c47abab3fc3c | (Registered 20 June 2012; updated 13 December 2012 ) | Overseas visits 80ef1083 | 2013-02-25 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 6 | 2013-02-25-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");