items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2010-04-12-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 |
|---|---|---|---|---|---|---|---|
| ee005b0158b473a81c403288d534f6d5526f6a17 | 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-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 0 | 2010-04-12-1f359ece-10498-0 |
| d731802406f0f98a1218c7318bc941a1f4b59d2a | Received £400 for writing an article. Hours: 2hrs. (Registered 3 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 1 | 2010-04-12-1f359ece-10498-0 |
| ed24fcc2372a8a390dea3df7c4d36500d4ad368b | Received £400 for writing an article. Hours: 2 hrs. (Registered 10 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 2 | 2010-04-12-1f359ece-10498-0 |
| 51557e912412d1638ccdb7e10a26a5de34a291f1 | Received £400 (excluding VAT) for writing an article. Hours: 2 hrs (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 3 | 2010-04-12-1f359ece-10498-0 |
| 04de700061b04c2294425617ee51b721643851d3 | Received £400 for writing an article. Hours: 2 hrs. (Registered 8 April 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 4 | 2010-04-12-1f359ece-10498-0 |
| 2d6bb13f416d7d9bddb99b756349894e4ad479db | 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-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 5 | 2010-04-12-1f359ece-10498-0 |
| 5009ab53c68c92185a3e1707ac98313dfd7d2460 | Received payment of £260 for article. Hours: 2 hrs. (Registered 30 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 6 | 2010-04-12-1f359ece-10498-0 |
| 73899789de818b9d18489b6a8a5c0a1e71beda56 | Received payment of £260 for article. Hours: 2hrs. (Registered 3 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 7 | 2010-04-12-1f359ece-10498-0 |
| 6dae27a7dd2a9a59d7cac0c9644adabbf13421c8 | Received payment of £260 for article. Hours: 2 hrs. (Registered 10 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 8 | 2010-04-12-1f359ece-10498-0 |
| 66b89efb3e0062d244a421dbb4529f7cd679f65f | Received payment of £260 (excluding VAT) for article. Hours: 2 hrs. (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 9 | 2010-04-12-1f359ece-10498-0 |
| 7d7bfe1e2af5183376a3fa758518a6bd7baf8543 | Received payment of £520 (excluding VAT) for two articles. Hours: 4 hrs. (Registered 4 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 10 | 2010-04-12-1f359ece-10498-0 |
| 1adc76d77d03a88a485fc655addf19dde7574c79 | Received payment of £260 (excluding VAT) for one article. Hours: 2 hrs. (Registered 4 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 11 | 2010-04-12-1f359ece-10498-0 |
| 00dd92fa717541ca25a8cfd8238484c709fa859b | Received £520 for writing two articles. Hours: 4 hrs. (Registered 8 April 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 12 | 2010-04-12-1f359ece-10498-0 |
| 5bd430afd8515bbd7b9c394e787a8568b2cd0395 | 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-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 13 | 2010-04-12-1f359ece-10498-0 |
| 7402aaba8b43f6d79319c911aa26e9ea5629a244 | Received £3500 (excluding VAT) covering May to October 2009. Estimated hours: 18 hrs. (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 14 | 2010-04-12-1f359ece-10498-0 |
| 2df5be61834e7939646a13d501ff8eda7ed316f8 | Lectures for National School of Government, Sunningdale Park, Larch Avenue, Ascot SL5 0QE. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 15 | 2010-04-12-1f359ece-10498-0 |
| bd9c7c13e7127d2be34b697e216cae97d01c793c | Received payment of £150 for lecture. Hours: 2hrs. (Registered 30 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 16 | 2010-04-12-1f359ece-10498-0 |
| e18d7153f3a8c1cded48fb4b1f400a2a03648d8c | Received payment of £175 for lecture. Hours: 2hrs. (Registered 3 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 17 | 2010-04-12-1f359ece-10498-0 |
| b5b9d318d8e0d093d686db51bb9d040ed0fa9f12 | Received payment of £175 for one lecture. Hours: 2 hrs. (Registered 8 April 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 18 | 2010-04-12-1f359ece-10498-0 |
| 58dbd6e92f28039b58d5d7198c7d492d872d3ce1 | Occasional lecturer for Westminster Explained. Address: 4 Grosvenor Place, London SW1X 7DL. | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 19 | 2010-04-12-1f359ece-10498-0 |
| d69d2c2b3fdd01cab6c59951c67663f9075783d8 | Received £150 (excluding VAT) for work done in September 2009. Hours: 2 hrs. (Registered 3 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Nick Raynsford uk.org.publicwhip/member/1602 | Nick Raynsford uk.org.publicwhip/person/10498 | 20 | 2010-04-12-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");