items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2012-10-01-1f359ece-10498-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 |
---|---|---|---|---|---|---|---|
c9c3a39e99d98c1191b6179106ef98798dc6a09a | Articles for Building Magazine, CMP Information Ltd, PO Box 313, Tonbridge, Kent, TN9 1YB. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 0 | 2012-10-01-1f359ece-10498-0 |
f7401de43eb112843822709f886fbfea0acd08fd | Received £400 for writing one article. Hours: 2 hrs. (Registered 16 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 1 | 2012-10-01-1f359ece-10498-0 |
0661bc98f0f532de44e0ade76fca23ff511cca74 | Articles for the Municipal Journal, Hemming Group Ltd, 32 Vauxhall Bridge Road, London, SW1V 2SS. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 2 | 2012-10-01-1f359ece-10498-0 |
2d7030cd4b28ab6e9a1c5634049beed410323b9d | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 8 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 3 | 2012-10-01-1f359ece-10498-0 |
73c531c72affa7b2200d18d7e89a80c9c10e62ca | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 16 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 4 | 2012-10-01-1f359ece-10498-0 |
19a9210f0a7e4d6507972a8d9bff182eaa4b10d1 | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 22 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 5 | 2012-10-01-1f359ece-10498-0 |
178ea681c1bae9d0e392a5120b226429a4979ed9 | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 20 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 6 | 2012-10-01-1f359ece-10498-0 |
3ef6768f97d867404a8f1fc7d2d5afcb5dc2af1b | Received £520 (excluding VAT) for writing two articles. Hours: 4 hrs. (Registered 6 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 7 | 2012-10-01-1f359ece-10498-0 |
1ea32e5b19ff687c84fd19c771ed836654077bdc | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 9 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 8 | 2012-10-01-1f359ece-10498-0 |
04bdf0b4ae953b70133c03dd88f001db610daf92 | Fire Protection Association Council (non-executive board member and chair), London Road, Moreton-in-Marsh, Gloucestershire, GL56 0RH. Work involves advising on the development of the FPA’s work and mission to promote fire safety, including attendance at board meetings. (£5,001–£10,000) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 9 | 2012-10-01-1f359ece-10498-0 |
f2cdaa44a0ac73294bf22c37f7796ac2af89af94 | Received £3,500 (excluding VAT) covering May-October 2011. Hours: 14 hrs. (Registered 16 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 10 | 2012-10-01-1f359ece-10498-0 |
298367939843d8a86410e9c3901b7c4faf92f183 | Received £3,500 (excluding VAT) covering November 2011- pril 2012. Hours: 13 hrs. (Registered 6 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 11 | 2012-10-01-1f359ece-10498-0 |
f50759b3aec1d6fcd4bb0c600defdae030ee5573 | Occasional lecturer for Westminster Explained. Address: 4 Grosvenor Place, London SW1X 7DL. | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 12 | 2012-10-01-1f359ece-10498-0 |
776e83c7e02bf81ad77556d26a5c727349f61011 | Fees for speaking engagements: | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 13 | 2012-10-01-1f359ece-10498-0 |
b122d344473b68481871e47a90d34145876f27b9 | Received £1,000 for October 2011 engagement for First Wessex Housing Association, Peninsula House, Wharf Rd, Portsmouth PO2 8HB. Hours: 7 hrs. (Registered 16 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 14 | 2012-10-01-1f359ece-10498-0 |
e33a1a66a2123a414caaa5c8e0d546b4da4d23f0 | Received £200 for September 2011 lecture for Cambridge University Department of Engineering, Trumpington St, Cambridge CB2 1PZ. Hours: 6 hrs. (Registered 16 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 15 | 2012-10-01-1f359ece-10498-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");