items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where record_id = "2012-12-19-1f359ece-10065-0" sorted by person_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id ▼ | sort_order | record_id |
---|---|---|---|---|---|---|---|
c8ee3c57e31556e94a28fd9a54f6226db8bd6180 | November 2011, received £250 for lecture to visiting students from European Studies Address: c/o Rhodes College, 2000 N Parkway, Memphis, TN 38112-1690 . H ours: 1 hr. (Registered 8 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 0 | 2012-12-19-1f359ece-10065-0 |
585a4e961db4550bc040a0a0818348ec2f2e340e | 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 | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 1 | 2012-12-19-1f359ece-10065-0 |
de3591d89ed4c031479e7066b27f5b0acea6b812 | ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 2 | 2012-12-19-1f359ece-10065-0 |
4797120dac130773d110fd5385a4383c423b55f6 | June 2011, received £75 for completing a survey. Hours: 1 hr (Registered 8 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 3 | 2012-12-19-1f359ece-10065-0 |
326cd71a40dbdb60882d3f42d7d1db8045f94975 | October 2011, received £75 for completing a survey. Hours: 1 hr (Registered 8 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 4 | 2012-12-19-1f359ece-10065-0 |
1eadb88d16c36f0987b7e71807872db244a1b45e | 9 December 2011, received £75 for completing a survey. Hours: 1 hr (Registered 9 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 5 | 2012-12-19-1f359ece-10065-0 |
38b812212680601f2085089069bf349b60ef9e67 | 15 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 6 | 2012-12-19-1f359ece-10065-0 |
8a7b70b3871a4484813b40688e19e81b5347e5c0 | 28 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 7 | 2012-12-19-1f359ece-10065-0 |
0773a2f6bcf9b1309deab6a86d32b1c21a463bc5 | 13 July 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 8 | 2012-12-19-1f359ece-10065-0 |
a833aa244e6616ed7433f295e444c938a16cdc2d | 27 November 2012, received £75 for completing a survey. Hours: 1 hr (Registered 4 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 9 | 2012-12-19-1f359ece-10065-0 |
febeda67fe42079a524b733b8fd64c81a92393d0 | October 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 10 | 2012-12-19-1f359ece-10065-0 |
3a3d9d9e3953a2aa71a65a53f10c3d9e2d17d31a | December 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 11 | 2012-12-19-1f359ece-10065-0 |
c89026276e24cbb8cb5323b40d9d9eb7d777247c | Ipsos MORI, 79-81 Borough Road, London SE1 1FY. | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 12 | 2012-12-19-1f359ece-10065-0 |
c26809cf3023846eeda8d60c5fbee6eaabed787b | 16 January 2012, received £150 for completing survey. Hours: 1.5 hours (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 13 | 2012-12-19-1f359ece-10065-0 |
96f035da376800a3901fe92093b184620e652791 | October 2012, received £150 for survey. Hours: 90 mins. (Registered 14 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 14 | 2012-12-19-1f359ece-10065-0 |
418a3a1dd6d27b3b0e4f10d7576359d3271f95ab | 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 | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 15 | 2012-12-19-1f359ece-10065-0 |
5d2adfa1a21bfa20bd03f674c1d3c0d70335e039 | 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 | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 16 | 2012-12-19-1f359ece-10065-0 |
c1e7e4d2f9fc85b4bc15625876aad05c5a7d2195 | 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 | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 17 | 2012-12-19-1f359ece-10065-0 |
65f0a120540503411cd83647fc354fc045b23c76 | 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 | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 18 | 2012-12-19-1f359ece-10065-0 |
28ce8e42e66328fd1f6c0aab93cf6a38bf6d4d62 | 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 | 2012-12-19 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 19 | 2012-12-19-1f359ece-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");