items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2012-06-11-1f359ece-11036-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 |
---|---|---|---|---|---|---|---|
431a7e1371d666507658a76234c4dd7a915a5b6a | Payments in respect of published book. (£15,001–£20,000) : | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 0 | 2012-06-11-1f359ece-11036-0 |
b3beb9423293b009cbf060cf66135fa8bea13ec7 | Received from Biteback Publishing, 3 Albert Embankment, London: | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 1 | 2012-06-11-1f359ece-11036-0 |
5c930417ff061ae4ef9c261bff2a3b982e47347f | £1,280.31 for royalties on sales of book. No additional hours worked. (Registered 1 August 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 2 | 2012-06-11-1f359ece-11036-0 |
a8204a711131a2f602412447453aa4da6b2f1b4c | £928.14 for royalties on sales of book. No additional hours worked. (Registered 8 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 3 | 2012-06-11-1f359ece-11036-0 |
2370274a7cb10fb646c730ada4b1c1776f56c125 | Payments for articles from News International, PO Box 64617, London SW8 9BG: | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 4 | 2012-06-11-1f359ece-11036-0 |
806a193d9054f5cb0b87207738114691eff9b1f7 | Payment of £400 for article in The Times. Hours: 1 hr. (Registered 21 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 5 | 2012-06-11-1f359ece-11036-0 |
086fd5d308e4e20630fc5694013b245bb7eb4700 | Payment of £800 for article in The Sun. Hours: 1 hr. (Registered 27 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 6 | 2012-06-11-1f359ece-11036-0 |
405d6df7c00e991ae63f7e349ecc00862add3ad9 | Payment of £500 for article in The Times. Hours: 1 hr. (Registered 8 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 7 | 2012-06-11-1f359ece-11036-0 |
fbd3352aae27ae867b2569ecab212dddbe39a046 | Payments for articles in the Mail on Sunday , Northcliffe House, 2 Derry Street, London W8 5TT: | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 8 | 2012-06-11-1f359ece-11036-0 |
adea3ec8f6c0678df0073464a38f12cd21fcc455 | Payment of £1,000 Hours: 1 hr. (Registered 8 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 9 | 2012-06-11-1f359ece-11036-0 |
938e6d9457853e2d6a7e46a03002db3f2c5f078d | Payment of £500. Hours: 1.5 hrs. (Registered 27 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 10 | 2012-06-11-1f359ece-11036-0 |
caf9c84a3852967f9ff494d1de51af8d816fc4f0 | Payment of £285 for article in the Guardian, 90 York Way, London N1 9GU. Hours: 1 hr. (Registered 27 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 11 | 2012-06-11-1f359ece-11036-0 |
07a959af3a163d2954663605f486050e894051a6 | Payments from Parliament Communications Limited, Verry House, Chine Crescent Road, Bournemouth, Dorset BH2 5LQ: | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 12 | 2012-06-11-1f359ece-11036-0 |
77928deff8570db7f9135ae60c71601e75039fe9 | Payment of £4,000 for a speech, Hours: 1.5 hrs. (Registered 1 August 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 13 | 2012-06-11-1f359ece-11036-0 |
bb7c524e8d91f27208c9d87cef1fb7d823b90105 | Payment of £4,000 for a speech. Hours: 4 hrs. (Registered 27 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 14 | 2012-06-11-1f359ece-11036-0 |
27cffc2dd3af221a3ad6f56e66540648eabb7010 | From September 2011: Member of the Investment Committee of Stanhope Capital, 35 Portman Square, London W1H 6LR. The work involves one meeting of two hours duration, every two months. The remuneration is £20,000 per annum. | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 15 | 2012-06-11-1f359ece-11036-0 |
9d0d9ddedb1c90666eb3bebc7429a37c6efa2591 | First payment of £6,666.67 for September-December 2011. Hours: 4 hrs. (Registered 8 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 16 | 2012-06-11-1f359ece-11036-0 |
11d90db75fb7a9b6b7cfa81cef7a15da30d726ca | Payment of £5,000 for January-March 2012. Hours: 4 hrs. (Registered 16 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 17 | 2012-06-11-1f359ece-11036-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");