items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2010-03-10-1f359ece-10498-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
051240f8881a2be48dad964cf93f798e7ee4e679 | 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-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 0 | 2010-03-10-1f359ece-10498-0 |
9e0de89650c4d0e9355b94c1da20d907267230b1 | Received £400 for writing an article. Hours: 2hrs. (Registered 3 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 1 | 2010-03-10-1f359ece-10498-0 |
9c76249d74a2bd0ba48fe3aeafbbeb4137272d17 | Received £400 for writing an article. Hours: 2 hrs. (Registered 10 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 2 | 2010-03-10-1f359ece-10498-0 |
b3f83d6ccae8f38ff89efc6822b08efa8a4413c7 | Received £400 (excluding VAT) for writing an article. Hours: 2 hrs (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 3 | 2010-03-10-1f359ece-10498-0 |
e5bcb572c4ffa90c23e37420306fb777c5bec4e3 | 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-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 4 | 2010-03-10-1f359ece-10498-0 |
c130e76e71641d5ddaf935c3533dc9021ce3627b | Received payment of £260 for article. Hours: 2 hrs. (Registered 30 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 5 | 2010-03-10-1f359ece-10498-0 |
9ac0012fffd3a1f471ea13e48f98932fd2f07aa3 | Received payment of £260 for article. Hours: 2hrs. (Registered 3 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 6 | 2010-03-10-1f359ece-10498-0 |
dfa7edb2c32bca2eef0201b12e670434bb0f5856 | Received payment of £260 for article. Hours: 2 hrs. (Registered 10 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 7 | 2010-03-10-1f359ece-10498-0 |
78728efbcdd18513e533a50c7b736691f95f63b6 | Received payment of £260 (excluding VAT) for article. Hours: 2 hrs. (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 8 | 2010-03-10-1f359ece-10498-0 |
a5988382decdd02bf3227594ba831fa2508ad5aa | Received payment of £520 (excluding VAT) for two articles. Hours: 4 hrs. (Registered 4 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 9 | 2010-03-10-1f359ece-10498-0 |
af10532224d7eba2b8fd21c28e1d2377ef729b12 | Received payment of £260 (excluding VAT) for one article. Hours: 2 hrs. (Registered 4 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 10 | 2010-03-10-1f359ece-10498-0 |
c3067962b3c6c1e85e51e9689a8b5c78d8f08e54 | 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-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 11 | 2010-03-10-1f359ece-10498-0 |
820d997ff96c9fa9e5e1d75387082c84597375c4 | 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-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 12 | 2010-03-10-1f359ece-10498-0 |
23b678213f353d6f8914e5a3652c50dc2476f626 | 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-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 13 | 2010-03-10-1f359ece-10498-0 |
d6e0bd6299d750043f2f3ae26e9024b06430f132 | Received payment of £150 for lecture. Hours: 2hrs. (Registered 30 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 14 | 2010-03-10-1f359ece-10498-0 |
3b031de570aa877ca9fc0aa8960e5bb0387c3678 | Received payment of £175 for lecture. Hours: 2hrs. (Registered 3 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 15 | 2010-03-10-1f359ece-10498-0 |
dd8a40c1b47b39411c6899ea8591b77cc047e06a | Occasional lecturer for Westminster Explained. Address: 4 Grosvenor Place, London SW1X 7DL. | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 16 | 2010-03-10-1f359ece-10498-0 |
5e251dbf331e1a6c412255fdf1ee6bec5a15a151 | 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-10 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 17 | 2010-03-10-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");