items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where "date" is on date 2011-01-10 and record_id = "2011-01-10-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 |
---|---|---|---|---|---|---|---|
880b0cc240a9e13c765486d0073b93e98ae2ec96 | 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-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 0 | 2011-01-10-1f359ece-10498-0 |
c52d1d349f7b0288648f3e3c5d23d84cbd1801a4 | Received £400 (excluding VAT) for writing an article. Hours: 2 hrs (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 1 | 2011-01-10-1f359ece-10498-0 |
b3f6fada416604e87700884c8f5640ee09c0e34e | Received £400 for writing an article. Hours: 2 hrs. (Registered 8 April 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 2 | 2011-01-10-1f359ece-10498-0 |
05a3e9425ca3aaf3b0ad8bacb319195e7d28bac0 | Received £400 for writing an article. Hours: 2 hrs. (Registered 16 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 3 | 2011-01-10-1f359ece-10498-0 |
df1cc01e133138e63c653fab76bd38d9c6b2175b | Received £800 for writing two articles. Hours: 4 hrs. (Registered 4 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 4 | 2011-01-10-1f359ece-10498-0 |
47fbc5ba460470a8cb2ccfa66d3c375d07716c38 | Received £800 for writing two articles. Hours: 4 hrs. (Registered 18 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 5 | 2011-01-10-1f359ece-10498-0 |
16292e763549a996dc5bf0f8f0b6d23201ef62e6 | 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-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 6 | 2011-01-10-1f359ece-10498-0 |
f9982393350a141161d9c8922c8f4ea308d6e488 | Received payment of £260 (excluding VAT) for article. Hours: 2 hrs. (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 7 | 2011-01-10-1f359ece-10498-0 |
3e89a4116162607543f38fa937251d99a7d2bf9b | Received payment of £520 (excluding VAT) for two articles. Hours: 4 hrs. (Registered 4 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 8 | 2011-01-10-1f359ece-10498-0 |
9745a1f908fa0ba94b14457608b697cbcf9bd307 | Received payment of £260 (excluding VAT) for one article. Hours: 2 hrs. (Registered 4 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 9 | 2011-01-10-1f359ece-10498-0 |
d8a75f09b0e1ee543c918e1598ed6bff824f8d96 | Received £520 (excluding VAT) for writing two articles. Hours: 4 hrs. (Registered 8 April 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 10 | 2011-01-10-1f359ece-10498-0 |
8874135c97c5876ee58c342952c66738c2e50bce | Received £260 (excluding VAT) for writing articles Hours: 2 hrs. (Registered 4 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 11 | 2011-01-10-1f359ece-10498-0 |
16f0ee9eca4f7baef480f71504f3f92961e16579 | Received £780 (excluding VAT) for writing three articles. Hours: 6 hrs. (Registeed 18 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 12 | 2011-01-10-1f359ece-10498-0 |
2e62ae9d2f4167150e66f54516aa0b4e9985f757 | 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-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 13 | 2011-01-10-1f359ece-10498-0 |
72733f55d7c3ed577c12feb61d51cb37df799421 | Received £3500 (excluding VAT) covering May to October 2009. Estimated hours: 18 hrs. (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 14 | 2011-01-10-1f359ece-10498-0 |
9e181383cd1c835240d33056dc76e0635ed0ab92 | Received £3500 (excluding VAT) covering November 2009 to April 2010. Estimated hours: 13 hours. (Registered 4 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 15 | 2011-01-10-1f359ece-10498-0 |
7fcd3d0557bffedf7c6a28ac76066108947efbc3 | Lectures for National School of Government, Sunningdale Park, Larch Avenue, Ascot SL5 0QE. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 16 | 2011-01-10-1f359ece-10498-0 |
28ce8694c40feb4b3128cceb88ff8c4d2e1d01c3 | Received payment of £175 for one lecture. Hours: 2 hrs. (Registered 8 April 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 17 | 2011-01-10-1f359ece-10498-0 |
896b0f1ae64f13f6cdc2c3d262be55dc0696a519 | Occasional lecturer for Westminster Explained. Address: 4 Grosvenor Place, London SW1X 7DL. | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 18 | 2011-01-10-1f359ece-10498-0 |
2a96dcc1231eef631f083d64c550b2f370e60266 | Received £150 (excluding VAT) for work done in September 2009. Hours: 2 hrs. (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Nick Raynsford uk.org.publicwhip/member/40287 | Nick Raynsford uk.org.publicwhip/person/10498 | 19 | 2011-01-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");