items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where record_id = "2011-12-13-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 |
---|---|---|---|---|---|---|---|
7d6f79ab4ff64a461fd1567659cd0e335ef201a0 | Articles for Building Magazine, CMP Information Ltd, PO Box 313, Tonbridge, Kent, TN9 1YB. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 0 | 2011-12-13-1f359ece-10498-0 |
c8b382b721f05b811649d31576668d530c0ad925 | Received £800 for writing two articles. Hours: 4 hrs. (Registered 18 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 1 | 2011-12-13-1f359ece-10498-0 |
04f699e6d21f3cb3bf6c9db1fb54661b1ef96113 | Received £400 for writing one article. Hours: 2 hrs. (Registered 20 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 2 | 2011-12-13-1f359ece-10498-0 |
6db5b3130e8a2f4387ed45cc7976ae68474b337e | Received £400 for writing one article. Hours: 2 hrs. (Registered 11 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 3 | 2011-12-13-1f359ece-10498-0 |
3dffe7ebeaeb8d9aad816e051f3d5d898b4e6048 | 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 | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 4 | 2011-12-13-1f359ece-10498-0 |
92f3e92a86755cb3a901c7c4e267da290a324367 | Received £260 (excluding VAT) for writing articles Hours: 2 hrs. (Registered 4 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 5 | 2011-12-13-1f359ece-10498-0 |
ce13a869c5fda5df42805017959a049359f8c91e | Received £780 (excluding VAT) for writing three articles. Hours: 6 hrs. (Registered 18 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 6 | 2011-12-13-1f359ece-10498-0 |
dafcfbfd5b7de894e7c9f13f13da62874badae64 | Received £880 (excluding VAT) for writing 3 articles. Hours: 6 hrs. (Registered 20 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 7 | 2011-12-13-1f359ece-10498-0 |
df3b2a2ec00e61519a8dd0418e603cc75f5198a8 | Received £520 (excluding VAT) for writing 2 articles. Hours: 4 hrs. (Registered 11 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 8 | 2011-12-13-1f359ece-10498-0 |
0b4b6626f73eef3c85fa07ff11033461cd641ba3 | Received £520 (excluding VAT) for writing 2 articles. Hours: 4 hrs. (Registered 25 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 9 | 2011-12-13-1f359ece-10498-0 |
3eb5d157fe9232b8412839ee3d96cb03c3c9f7b8 | Received £520 (excluding VAT) for writing 2 articles. Hours: 4 hrs. (Registered 29 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 10 | 2011-12-13-1f359ece-10498-0 |
d7faa92f2df48d44786cc0bade3b8996d0735d62 | Received £780 (excluding VAT) for writing 3 articles. Hours: 6 hrs. (Registered 15 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 11 | 2011-12-13-1f359ece-10498-0 |
1912de8c3eacadfaceb686e9c2a6603dfb53d72c | Received £260 (excluding VAT) for writing 1 article. Hours: 2 hrs. (Registered 8 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 12 | 2011-12-13-1f359ece-10498-0 |
c2283cfc7e0d691673af79a5cff5e070d21d8d44 | 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 | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 13 | 2011-12-13-1f359ece-10498-0 |
c5de1a98ad93a09334b21bd419f45a45f50cb921 | Received £3,500 (excluding VAT) covering May-October 2010. Hours: 11 hrs. (Registered 20 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 14 | 2011-12-13-1f359ece-10498-0 |
19135acd7701d8a6ed4b8357f0e6866b56a3ab18 | Received £3,500 (excluding VAT) covering November 2010-April 2011. Hours: 11 hrs. (Registered 29 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 15 | 2011-12-13-1f359ece-10498-0 |
ffee361f20d7c197abd5b21249a8b51731214afe | Occasional lecturer for Westminster Explained. Address: 4 Grosvenor Place, London SW1X 7DL. | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 16 | 2011-12-13-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");