items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2010-03-24-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 |
---|---|---|---|---|---|---|---|
52d47b08e4b69a432310d634c4e7bdefeb4dfc45 | Articles for Building Magazine, CMP Information Ltd, PO Box 313, Tonbridge, Kent, TN9 1YB. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 0 | 2010-03-24-1f359ece-10498-0 |
be14c4df71bdb87f0d6bfb110d63a80c960170be | Received £400 for writing an article. Hours: 2hrs. (Registered 3 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 1 | 2010-03-24-1f359ece-10498-0 |
e8d3687a28497a42d6557c47084de2b292f865fa | Received £400 for writing an article. Hours: 2 hrs. (Registered 10 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 2 | 2010-03-24-1f359ece-10498-0 |
43b837d5bab6923041db3968671816e223774a51 | Received £400 (excluding VAT) for writing an article. Hours: 2 hrs (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 3 | 2010-03-24-1f359ece-10498-0 |
870e07b928e13b0b8cd7d13fd91faeb6d7f5e498 | 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 | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 4 | 2010-03-24-1f359ece-10498-0 |
a2707d620dd091d2c6b32a6baf35bd6abf3f6c1e | Received payment of £260 for article. Hours: 2 hrs. (Registered 30 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 5 | 2010-03-24-1f359ece-10498-0 |
56e51e06cf4a17e45d439e0d341a2906ab32dddf | Received payment of £260 for article. Hours: 2hrs. (Registered 3 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 6 | 2010-03-24-1f359ece-10498-0 |
19e2929cce2126d60288457b03bec1397cdf79fe | Received payment of £260 for article. Hours: 2 hrs. (Registered 10 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 7 | 2010-03-24-1f359ece-10498-0 |
b41a7abcf764d001e87bdca8f0e7b195923e7d3b | Received payment of £260 (excluding VAT) for article. Hours: 2 hrs. (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 8 | 2010-03-24-1f359ece-10498-0 |
bd2dcf83d5b64172b6850f06897bd768ea342a3c | Received payment of £520 (excluding VAT) for two articles. Hours: 4 hrs. (Registered 4 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 9 | 2010-03-24-1f359ece-10498-0 |
1bdf036a5ee073a0a63692cc74f75cf2390dba0a | Received payment of £260 (excluding VAT) for one article. Hours: 2 hrs. (Registered 4 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 10 | 2010-03-24-1f359ece-10498-0 |
98aa2a204abdd1399f8bf5d7b89a1a8c20b3e528 | 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 | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 11 | 2010-03-24-1f359ece-10498-0 |
48c5dc6fd3b6fd05f6f1b9b343c789786665a4e2 | Received £3500 (excluding VAT) covering May to October 2009. Estimated hours: 18 hrs. (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 12 | 2010-03-24-1f359ece-10498-0 |
e3216b0dee83991d17fb848a834c3dd2e3ad0123 | Lectures for National School of Government, Sunningdale Park, Larch Avenue, Ascot SL5 0QE. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 13 | 2010-03-24-1f359ece-10498-0 |
8532ca820f1d854fd6757d2f4e354a0e013178b2 | Received payment of £150 for lecture. Hours: 2hrs. (Registered 30 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 14 | 2010-03-24-1f359ece-10498-0 |
add002f2de77ed7f0264872433c1fb8540e2d07a | Received payment of £175 for lecture. Hours: 2hrs. (Registered 3 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 15 | 2010-03-24-1f359ece-10498-0 |
3c0dfea369a2c8e311cf8047ed5022bbf65b95a3 | Occasional lecturer for Westminster Explained. Address: 4 Grosvenor Place, London SW1X 7DL. | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 16 | 2010-03-24-1f359ece-10498-0 |
fc4994297f18064d3d1eec9b070c2503d41f4e09 | Received £150 (excluding VAT) for work done in September 2009. Hours: 2 hrs. (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 17 | 2010-03-24-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");