items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2011-10-17-1f359ece-11032-0" sorted by member_id
This data as json, CSV (advanced)
date (date) 1 ✖
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
8167038911a08d50f009e1c11fcb0e2a92210d10 | Populus, Northburgh House, 10 Northburgh Street , London , EC1V 0AT . | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 0 | 2011-10-17-1f359ece-11032-0 |
03ac63ff760b60a8117887484ef5e2e6a0682294 | Received £50 for November 2010 Parliamentary Panel Survey, paid directly to North Norfolk and Great Yarmouth Liberal Democrats on 16 December 2010. (Registered 6 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 1 | 2011-10-17-1f359ece-11032-0 |
b9a3a66cd12ff39f8928edbc8ebe7df222c7e723 | Ipsos MORI, 79-81 Borough Road, London SE1 1FY. | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 2 | 2011-10-17-1f359ece-11032-0 |
9eb2b342aed4592c987b266897f784ed266d6e72 | Received payment of £150 for completed survey on 22 November 2010, paid directly to charity on 13 December 2010. (Registered 6 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 3 | 2011-10-17-1f359ece-11032-0 |
5111fa58a56287ad8caf839e34ecb0ea24ae5f1e | Received 2 bottles of wine, estimated value £20, from LCS International Consulting Ltd, 1 Harley Street, London W1G 9QD, for speaking at LCS 20/20 Health Report Dinner. Hours: 4 hrs. (Registered 7 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 4 | 2011-10-17-1f359ece-11032-0 |
c06e0c01387687fc263db911ae3548d012f601a4 | Received two engraved glasses, value £13.50, from North Walsham High School, Spenser Avenue, North Walsham NR28 9HZ, after attending the prize giving ceremony. Hours: 2 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 5 | 2011-10-17-1f359ece-11032-0 |
a99e72b31f48d615cbbdac6c9b1a41c29bb3120e | Payment of £150 from the Saffron Housing Trust Ltd, Saffron Barn, Swan Lane, Long Stratton, Norfolk NR15 2XP, for a speaking engagement on 28 January 2011. Hours: 3 hrs. The payment was donated to charity. (Registered 10 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 6 | 2011-10-17-1f359ece-11032-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");