items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where record_id = "2013-04-22-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 |
---|---|---|---|---|---|---|---|
65aa8091abd9ad774049ced0a695a212c63d026a | 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-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 0 | 2013-04-22-1f359ece-10065-0 |
cbf1ec6093a4dcefacffe69d237e3314c7354de1 | ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 1 | 2013-04-22-1f359ece-10065-0 |
6b7fde77307ccbb6381cda77c601ae26035e940d | 15 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 2 | 2013-04-22-1f359ece-10065-0 |
3762a859096dd05099d5873a076b1b2f4c857258 | 28 June 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 3 | 2013-04-22-1f359ece-10065-0 |
985f386d977baacc4a3c76af387243d5bd6930af | 13 July 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 4 | 2013-04-22-1f359ece-10065-0 |
040fddd1e216edf111927a95abd0b25537b4f62f | 27 November 2012, received £75 for completing a survey. Hours: 1 hr (Registered 4 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 5 | 2013-04-22-1f359ece-10065-0 |
0481659a1ee67a429b04049e15ad024d24c075bc | October 2012, received £75 for completing a survey. Hours: 1 hr (Registered 13 | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 6 | 2013-04-22-1f359ece-10065-0 |
47a08d1d5f84570c0baa6c11111ee6f4397be11b | December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 7 | 2013-04-22-1f359ece-10065-0 |
337115099b77232d101ba67d48f287bc1d26cc29 | 20 December 2012, received £75 for completing a survey. Hours: 1 hr (Registered 21 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 8 | 2013-04-22-1f359ece-10065-0 |
2ea60651c9954cc05842ef857907d339cb81c008 | 26 February 2013, received £75 for completing a survey. Hours: 1 hr (Registered 14 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 9 | 2013-04-22-1f359ece-10065-0 |
c4e6a97846c8a0ba036ea9259c11444783a97212 | 22 March 2013, received £75 for completing a survey. Hours: 1 hr (Registered 18 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 10 | 2013-04-22-1f359ece-10065-0 |
3b94c1ff9b78733ef66eb3e7e284dd4833676f39 | Ipsos MORI, 79-81 Borough Road, London SE1 1FY. | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 11 | 2013-04-22-1f359ece-10065-0 |
ef6f9343dcbd2c08ad42db5cec92d68c0cedd72e | 16 January 2012, received £150 for completing survey. Hours: 1.5 hours (Registered 26 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 12 | 2013-04-22-1f359ece-10065-0 |
0946b4f69e47b73fbcd0af2fc0983a6a27681b8b | October 2012, received £150 for survey. Hours: 90 mins. (Registered 14 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 13 | 2013-04-22-1f359ece-10065-0 |
c66fe8e88ca66192661e2100864d665e0f55d3c4 | 8 January 2013, received £150 for survey. Hours: 1.5 hrs. (Registered 21 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-04-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 14 | 2013-04-22-1f359ece-10065-0 |
1798a33a63c4dd7e0b783e4eeea4a9f82abdb29b | 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-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 15 | 2013-04-22-1f359ece-10065-0 |
887bec615ea2048876566d6c214c2180f476a8e1 | 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-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 16 | 2013-04-22-1f359ece-10065-0 |
6f7b0a8a9dfa2d9b6e1083251acfd6d65c0c6b88 | 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-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 17 | 2013-04-22-1f359ece-10065-0 |
38802d17f4215b15ea36d38a8d0a00ad11b54845 | 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-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 18 | 2013-04-22-1f359ece-10065-0 |
f732486abff7543ed8b7f6037adacac705410dcb | 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-22 | Julian Brazier uk.org.publicwhip/member/40144 | Julian Brazier uk.org.publicwhip/person/10065 | 19 | 2013-04-22-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");