items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2012-12-03-1f359ece-10065-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
6bf3df8af71e70a98dba9be6de3e4058c75bc63b | 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-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 0 | 2012-12-03-1f359ece-10065-0 |
8e1defd6674ca0e17b37bc2c36a856b60f9ed75b | ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 1 | 2012-12-03-1f359ece-10065-0 |
142648ef02fef3bbdd152f46246d070c6a05bdef | June 2011, received £75 for completing a survey. Hours: 1 hr (Registered 8 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 2 | 2012-12-03-1f359ece-10065-0 |
a6eb4f5bc46b0df2812318139f9a6429cbdc7acf | October 2011, received £75 for completing a survey. Hours: 1 hr (Registered 8 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 3 | 2012-12-03-1f359ece-10065-0 |
fd1688aeda3f5483cafb3299685d6f98f4ea9050 | 9 December 2011, received £75 for completing a survey. Hours: 1 hr (Registered 9 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 4 | 2012-12-03-1f359ece-10065-0 |
04365b65a9e665fecd52afef337458cef75ca4c2 | 15 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 5 | 2012-12-03-1f359ece-10065-0 |
c566c964f2bc984066361d3ca5dffc3471c15436 | 28 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 6 | 2012-12-03-1f359ece-10065-0 |
2c13f3f30b4fed15c66801f8debaf23e0bf2475c | 13 July 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 7 | 2012-12-03-1f359ece-10065-0 |
8f38dd0efa4b065dda54a46dfb0351ad700cd0fa | Ipsos MORI, 79-81 Borough Road, London SE1 1FY. | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 8 | 2012-12-03-1f359ece-10065-0 |
9514f4e735d07a1632827ca2bf6fbeaa0373ae99 | 16 January 2012, received £150 for completing survey. Hours: 1.5 hours (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 9 | 2012-12-03-1f359ece-10065-0 |
fd634312a04c7245bfe1000aae29c78ed84830bb | October 2012, received £150 for survey. Hours: 90 mins. (Registered 14 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 10 | 2012-12-03-1f359ece-10065-0 |
0fb747cedf12e3f0e1ca7a874b52f092e786c1f6 | 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-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 11 | 2012-12-03-1f359ece-10065-0 |
1a589ff484f43cb8fc3c24830206f51c62e514b9 | Consultant on energy saving products for Conditionaire International Ltd, Wellington House, 7-9 Church Road, Tunbridge Wells, Kent TN1 1HT. Paid by commission only. (£0-£5,000, estimated) (Registered 15 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 12 | 2012-12-03-1f359ece-10065-0 |
8b9d61f77184c63a3c67c0e4fdd5a151a3444aa3 | 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-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 13 | 2012-12-03-1f359ece-10065-0 |
2cc9416c182025cd6ba00a2b896b6eb8537430f7 | 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-03 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 14 | 2012-12-03-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");