items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where record_id = "2012-09-03-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 |
---|---|---|---|---|---|---|---|
f296c2479580ea7147e237dc5e04bbd1e1ff8bab | 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-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 0 | 2012-09-03-1f359ece-10498-0 |
d78c473e53c0b345c9812afee871ba99a9a6cb28 | Received £400 for writing one article. Hours: 2 hrs. (Registered 16 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 1 | 2012-09-03-1f359ece-10498-0 |
bda63aabe8aa705bf197b3d21682cdedecc64aea | 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-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 2 | 2012-09-03-1f359ece-10498-0 |
6cd6bfcfdf9bbc86277a296bc63eb5e14ca56ea3 | Received £780 (excluding VAT) for writing 3 articles. Hours: 6 hrs. (Registered 15 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 3 | 2012-09-03-1f359ece-10498-0 |
f652a0f6cede9722505194c947d2dcf42415f369 | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 8 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 4 | 2012-09-03-1f359ece-10498-0 |
aecc0969eb8278aa3019b51c845c90c84e1417eb | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 16 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 5 | 2012-09-03-1f359ece-10498-0 |
ac13ed48770bd7d688bbb3125e8f6e35c1cdc64f | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 22 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 6 | 2012-09-03-1f359ece-10498-0 |
22e1ade1b46e25136bbd1a4220d410bb5cea3a16 | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 20 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 7 | 2012-09-03-1f359ece-10498-0 |
86e11281dc448fccce74d6ecf7f006752be0b410 | Received £520 (excluding VAT) for writing two articles. Hours: 4 hrs. (Registered 6 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 8 | 2012-09-03-1f359ece-10498-0 |
00f9839d587ab67dfcecf3ad7012c275dfc08f3f | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 9 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 9 | 2012-09-03-1f359ece-10498-0 |
7a1347283ba4efbd4db6f82394a05b5d73688d21 | 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-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 10 | 2012-09-03-1f359ece-10498-0 |
dc3d60910880c0fcee0081a704c22102f636b0eb | Received £3,500 (excluding VAT) covering May-October 2011. Hours: 14 hrs. (Registered 16 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 11 | 2012-09-03-1f359ece-10498-0 |
ea9f590748c6d17924d5fd4815dd67c066cd52e7 | Received £3,500 (excluding VAT) covering November 2011- pril 2012. Hours: 13 hrs. (Registered 6 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 12 | 2012-09-03-1f359ece-10498-0 |
3e5ad3682fff7968aceef0b87337b1af36aab2fa | Occasional lecturer for Westminster Explained. Address: 4 Grosvenor Place, London SW1X 7DL. | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 13 | 2012-09-03-1f359ece-10498-0 |
f8c56e692a69c888607205e1f0db42711a5a2ba2 | Fees for speaking engagements: | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 14 | 2012-09-03-1f359ece-10498-0 |
ca0c10155218c2760b01c9326b859d1c03a2890a | 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-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 15 | 2012-09-03-1f359ece-10498-0 |
67212b1b0ae1fb1a4639b47fa59454d7d38c9dfe | 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-09-03 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 16 | 2012-09-03-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");