items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2010-03-10-1f359ece-10373-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 |
|---|---|---|---|---|---|---|---|
| 34ee53841a442c50ff60fe0f6402df7ade43d2a1 | Member of Centre for Parliamentary Studies Advisory Board. Centre address: 14 Great College Street, London, SW1P 3RX. Actual payment approx. £900 per annum. (Up to £5000). | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 0 | 2010-03-10-1f359ece-10373-0 |
| d3e63718016f70ef2fa9257570e8be08ed784057 | 21 July 2009, received payment of £300 for board meeting. Hours: 3hrs. (Registered28 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 1 | 2010-03-10-1f359ece-10373-0 |
| 775b8315fbea63af3efcc0a43e60519231d49c53 | 18 November 2009, received payment of £300 for attending board meeting. Hours: 3 hrs. (Registered 29 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 2 | 2010-03-10-1f359ece-10373-0 |
| 2e90e454888ed38768041f93b7a4e421a53eb016 | 10 February 2010, received payment of £300 for attending board meeting Hours: 2.5 hours. (Registered 9 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 3 | 2010-03-10-1f359ece-10373-0 |
| 91240f0c505c92b7e5a26543e1ace5b2fcd4cc1f | 9 July 2009, speech at Speech Day, Dodderhill School, Droitwich Spa; total preparation, travel and attendance - 5 hours; I was given a bottle of champagne (estimated value £20) by the governors. (Registered 12 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 4 | 2010-03-10-1f359ece-10373-0 |
| 41027052457dfa18bbb19893549d8253e1f2b10a | Opinion surveys for BPRI. Address: 14 Great College Street, London, SW1P 3RX. | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 5 | 2010-03-10-1f359ece-10373-0 |
| 90aca3f58844796d159ed33b3ff63d4542b0185e | 10 July 2009, completion time - 30 minutes; £75 to charity, sent direct by BPRI. (Registered 12 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 6 | 2010-03-10-1f359ece-10373-0 |
| 33cfbe77cd65473464f6d4fdb442eeb930319c6a | 7 November 2009, £75 to charity, sent direct by BPRI. Hours: 30 mins. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 7 | 2010-03-10-1f359ece-10373-0 |
| 7f28b06e3b85fa68a759c3246deafbf383c44af0 | 21 February 2010, £75 sent direct to charity by BPRI. Hours: 30 mins. (Registered 9 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 8 | 2010-03-10-1f359ece-10373-0 |
| 84fb196d7ff11f3210e7792944fa398e7a3ea334 | Lectures to Centre for Parliamentary Studies conference. Centre address: 14 Great College Street, London, SW1P 3RX. | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 9 | 2010-03-10-1f359ece-10373-0 |
| fbccbc8810760bf5e17fe37f061f4a94e6af4763 | 7 July 2009, fee of £150 received. Hours: 2 hrs. (Registered 14 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 10 | 2010-03-10-1f359ece-10373-0 |
| b85edd6275edf99d247e380258f76f98252b5988 | 22 October 2009, fee of £150 received. Hours: 1.5 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 11 | 2010-03-10-1f359ece-10373-0 |
| 98cb49dc0db9fb9f09a7433d6de921685a5ba5b5 | Parliament Panel surveys completed for Populus. Address: Northburgh House, 10 Northburgh Street, London, EC1V 0AT. | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 12 | 2010-03-10-1f359ece-10373-0 |
| 95d5a0811d5ab5a4a65148bcc8a8fd961ad67b6a | 14 July 2009, completion time - 20 minutes. £50 to charity, sent direct by Populus. (Registered 14 July 2009). | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 13 | 2010-03-10-1f359ece-10373-0 |
| 05c8f86580d7b07a5d03406bd031c50620c6b95d | 10 December 2009, survey completed. Hours: 15 mins. £50 to charity, sent direct by Populus. (Registered 10 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 14 | 2010-03-10-1f359ece-10373-0 |
| c022b06f662549daa9178be813959d20557ab958 | 8 March 2010, survey completed. Hours: 15 mins. £50 to charity, sent direct by | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 15 | 2010-03-10-1f359ece-10373-0 |
| b24a89763a45fbe25800c2fa1157f9662738ecae | Populus. (Registered 9 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 16 | 2010-03-10-1f359ece-10373-0 |
| 481a7a8d7f14db2eddf819aabf4af6933f7ba7dc | 28 September 2009, Ipsos MORI survey completed. Completion time 20 minutes. Ipsos MORI address: 79-81 Borough Road, London SE1 1FY. Fee of £60 donated to charity. (Registered 28 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 17 | 2010-03-10-1f359ece-10373-0 |
| c70e3950e134ee7677a2876ddf4d63dd5b5674de | Opinion surveys for ComRes. Address: 4 Millbank, London SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 18 | 2010-03-10-1f359ece-10373-0 |
| 63a06dd6431736baf2e369beb209ea4fd60d1691 | 7 November 2009, fee of £75 received. Hours: 30 mins. . (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 19 | 2010-03-10-1f359ece-10373-0 |
| 27d1094a3b126281047947219ed123089e34a8c5 | 19 February 2010, fee of £75 sent direct to charity by ComRes. Hours: 30 mins. (Registered 9 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Peter Luff uk.org.publicwhip/member/1940 | Peter Luff uk.org.publicwhip/person/10373 | 20 | 2010-03-10-1f359ece-10373-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");