items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2012-03-19-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 |
---|---|---|---|---|---|---|---|
50168116057c2d51675d98d00f96939901843448 | Payments in respect of published book. (£15,001–£20,000) : | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 0 | 2012-03-19-1f359ece-11036-0 |
3f0e03a258fba1521be3a3b68a90f99b89e8e883 | Received from Biteback Publishing, 3 Albert Embankment, London: | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 1 | 2012-03-19-1f359ece-11036-0 |
716203b8fb734b5caabeb99fe066643e4f94022b | £1,280.31 for royalties on sales of book. No additional hours worked. (Registered 1 August 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 2 | 2012-03-19-1f359ece-11036-0 |
a30af5d51a54d0d3fa85676d0568d978072b37e8 | £928.14 for royalties on sales of book. No additional hours worked. (Registered 8 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 3 | 2012-03-19-1f359ece-11036-0 |
d1f40ebdd39a902e35226eaebbd24b0d94652390 | Payments for articles from News International, PO Box 64617, London SW8 9BG: | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 4 | 2012-03-19-1f359ece-11036-0 |
25ee46abd9cda397001b35ea94da04568d00a5f6 | Payment of £400 for article in The Times. Hours: 1 hr. (Registered 21 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 5 | 2012-03-19-1f359ece-11036-0 |
ade7e703b252fb10e9d9fae6f0e613476ccd6aed | Payment of £800 for article in The Sun. Hours: 1 hr. (Registered 27 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 6 | 2012-03-19-1f359ece-11036-0 |
7148f6bfe3c6d26984fde8a4925bae2dbe283ad8 | Payment of £500 for article in The Times. Hours: 1 hr. (Registered 8 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 7 | 2012-03-19-1f359ece-11036-0 |
1c692ca4d837e3ae8ed904aacdac8f55acb8155a | Payment of £1,000 for article in the Mail on Sunday , Northcliffe House, 2 Derry Street, London W8 5TT. Hours: 1 hr. (Registered 8 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 8 | 2012-03-19-1f359ece-11036-0 |
0012552f7690fb391236203dc65afa22b6995b12 | 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-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 9 | 2012-03-19-1f359ece-11036-0 |
e3b1e639d2f6c5b7f0195361599525d245531377 | Payments from Parliament Communications Limited, Verry House, Chine Crescent Road, Bournemouth, Dorset BH2 5LQ: | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 10 | 2012-03-19-1f359ece-11036-0 |
686b2317a19063e04e127f3438e5ff418048222c | Payment of £4,000 for a speech, Hours: 1.5 hrs. (Registered 1 August 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 11 | 2012-03-19-1f359ece-11036-0 |
c13a446a2622eae5507dc210e736de1375e3c26d | Payment of £4,000 for a speech. Hours: 4 hrs. (Registered 27 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 12 | 2012-03-19-1f359ece-11036-0 |
169aca68c34166569d1a330b08d6ed00e1241407 | 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-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 13 | 2012-03-19-1f359ece-11036-0 |
e81a3049d27a2e2b663383c22bfbdae684a2f9ad | First payment of £6,666.67 for September-December 2011. Hours: 4 hrs. (Registered 8 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 14 | 2012-03-19-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");