items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where "date" is on date 2012-03-05 and record_id = "2012-03-05-1f359ece-10498-0" sorted by sort_order
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
7bf9d2f06293db688926eb610deee17da537d9cb | 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-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 0 | 2012-03-05-1f359ece-10498-0 |
87530fe19cda8269fe58aba85f4846571cf48347 | Received £400 for writing one article. Hours: 2 hrs. (Registered 11 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 1 | 2012-03-05-1f359ece-10498-0 |
c23198cf045a1b398a8206e7fd090e280187ad05 | Received £400 for writing one article. Hours: 2 hrs. (Registered 16 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 2 | 2012-03-05-1f359ece-10498-0 |
4b466e1247889248fdad0bc69d93d7ac04b4eb08 | 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-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 3 | 2012-03-05-1f359ece-10498-0 |
989ca31bb9fe4c776385f1761633d6674d6e2f76 | Received £520 (excluding VAT) for writing 2 articles. Hours: 4 hrs. (Registered 11 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 4 | 2012-03-05-1f359ece-10498-0 |
56e2fb28aee7b48e14d92704e2cb0e22e1d77912 | Received £520 (excluding VAT) for writing 2 articles. Hours: 4 hrs. (Registered 25 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 5 | 2012-03-05-1f359ece-10498-0 |
a872325dad736555176bf0bb36768546adff286d | Received £520 (excluding VAT) for writing 2 articles. Hours: 4 hrs. (Registered 29 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 6 | 2012-03-05-1f359ece-10498-0 |
1832d856e9c25eef3eecf3405a017755243aa310 | Received £780 (excluding VAT) for writing 3 articles. Hours: 6 hrs. (Registered 15 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 7 | 2012-03-05-1f359ece-10498-0 |
9908f7a4569fc1a8bc1b40986f1684ef993bc02e | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 8 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 8 | 2012-03-05-1f359ece-10498-0 |
0f518dc28639c276d72bd5b9d1036413df143b2f | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 16 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 9 | 2012-03-05-1f359ece-10498-0 |
58469ca5e31defee46da7339a5d04982d8b423e8 | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 22 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 10 | 2012-03-05-1f359ece-10498-0 |
dbc95fcf1c225ab05ce6eb196edd6cf13cd80497 | 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-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 11 | 2012-03-05-1f359ece-10498-0 |
052088d7c730bb8b71d03cfb3fcd2958b5477447 | Received £3,500 (excluding VAT) covering November 2010-April 2011. Hours: 11 hrs. (Registered 29 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 12 | 2012-03-05-1f359ece-10498-0 |
e4ae456a3b5cf083e778d053090431cd76e25841 | Received £3,500 (excluding VAT) covering May-October 2011. Hours: 14 hrs. (Registered 16 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 13 | 2012-03-05-1f359ece-10498-0 |
f48af826ee2f89fb2b1192d136f60b2967a4cb99 | Occasional lecturer for Westminster Explained. Address: 4 Grosvenor Place, London SW1X 7DL. | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 14 | 2012-03-05-1f359ece-10498-0 |
7f74d2a95308531a04ad3512f09bbd2965b3e3dd | Fees for s peaking engagements: | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 15 | 2012-03-05-1f359ece-10498-0 |
cd982b29064f6491db4ed7f683aa444f1cc8eb22 | 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-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 16 | 2012-03-05-1f359ece-10498-0 |
203230b7df499664c26acd67283e66cee05b345d | 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-03-05 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 17 | 2012-03-05-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");