items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2015-01-06-8f616a6e-11032-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 |
---|---|---|---|---|---|---|---|
62b52ad63f7b7b75b4f56aaa519870c1e0102559 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 0 | 2015-01-06-8f616a6e-11032-0 |
66eef59e2875d5033c8871ac2d0030e77fba05ef | Name of donor: Targetfollow Estates Ltd. | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 1 | 2015-01-06-8f616a6e-11032-0 |
685ebc5d2953a4262cbb361fda2a7b6f7639d850 | Address of donor: Riverside House, 11-12 Riverside Road, Norwich NR 1 1SQ | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 2 | 2015-01-06-8f616a6e-11032-0 |
f6af5ec861cab06113fc24f708cdb0817b04ad65 | Donor status: company, registration 04697861 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 4 | 2015-01-06-8f616a6e-11032-0 |
5d89d30259d2403264e62b5d1cd186be5d8ac31e | Name of donor: Ardeshir Nagshineh | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 6 | 2015-01-06-8f616a6e-11032-0 |
045d7e93bd2aab92ec2cc7afff937bee229d1b5b | (Registered 25 February 2014) | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 10 | 2015-01-06-8f616a6e-11032-0 |
b88d2e68acbf545e1714e78b9bf40aac3ecbb436 | Name of donor: Norwich Property Company Ltd | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 11 | 2015-01-06-8f616a6e-11032-0 |
4a11da553c756347dd88e742fbe3bdd574ddbddd | Donor status: company, registration no 06589966 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 14 | 2015-01-06-8f616a6e-11032-0 |
cf80fd415113317a912cfadfb007de0512b64e70 | Name of donor: Malcor Estates Ltd | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 16 | 2015-01-06-8f616a6e-11032-0 |
312c3b4a3c13a87a704086c9522ce4e3591b9e53 | Address of donor: Riverside House, 11/12 Riverside Road, Norwich, NR1 1SQ | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 17 | 2015-01-06-8f616a6e-11032-0 |
0d1d4b3671ad2485623f1f49bf5a041dc7dab302 | Amount of donation or nature and value if donation in kind: £4,950 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 18 | 2015-01-06-8f616a6e-11032-0 |
f4ddfa10cbc432a90c8fe44e1be74d7c4a460e87 | Donor status: company, registration no 04271068 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 19 | 2015-01-06-8f616a6e-11032-0 |
3b41e96755722e7f1edde3525276e97f5702eb47 | (Registered 15 September 2014) | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 20 | 2015-01-06-8f616a6e-11032-0 |
30ce6c6c44ad1bef332355e6cab89ad9f7e84315 | (b) Support in the capacity as an MP: | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 21 | 2015-01-06-8f616a6e-11032-0 |
44d349600e6a4f19cd520d7f2d410ebce24634f2 | Name of donor: Larry Coltman | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 22 | 2015-01-06-8f616a6e-11032-0 |
4ba6f7d12b75bbdee4136e202fd6117b06ace484 | Date of receipt: 30 July 2014 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 25 | 2015-01-06-8f616a6e-11032-0 |
9ebf3349b86f0dd0ce5b4cf93ddc2a183581d5d3 | Date of acceptance: 30 July 2014 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 26 | 2015-01-06-8f616a6e-11032-0 |
8aa1eb9d551b27b516ee27987cd2acc600949387 | (Registered 28 August 2014) | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 28 | 2015-01-06-8f616a6e-11032-0 |
ba2038d0c98fdfd04ed06f429474530e163cf3e0 | Name of donor: Dr Anthony Hare | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 29 | 2015-01-06-8f616a6e-11032-0 |
ecd755cbec31600d0cc8c0ca779bb1640f4e2ebc | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 31 | 2015-01-06-8f616a6e-11032-0 |
41ef20efd956aa51eb9ead9e4e7ff3045cfc4cce | Date of receipt: 29 August 2014 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 32 | 2015-01-06-8f616a6e-11032-0 |
d2725fe5a016d7651cb568ef1a4487e553c03fd8 | Date of acceptance: 29 August 2014 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 33 | 2015-01-06-8f616a6e-11032-0 |
85b083141e4286b86c2f9395c6db299e0290d25f | (Registered 15 September 2014) | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 35 | 2015-01-06-8f616a6e-11032-0 |
00bb40da7440a7d7380fe0e51b0f57881c50b405 | Name of donor: Tim Harris | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 36 | 2015-01-06-8f616a6e-11032-0 |
d95404585775a6cc0fb740353e499d2f17da5aa2 | Address of donor: private | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 37 | 2015-01-06-8f616a6e-11032-0 |
3b229e9fe06f44c04e2c3a96b5f5d2ef2e54dccf | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 38 | 2015-01-06-8f616a6e-11032-0 |
63195493b5fe4c3ccf75bbe1eca2e2a9f3b8b423 | Date of receipt: 27 November 2014 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 39 | 2015-01-06-8f616a6e-11032-0 |
8c1bd5ec7b51f52c3eab9fff23b31982f90b0251 | Date of acceptance: 27 November 2014 | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 40 | 2015-01-06-8f616a6e-11032-0 |
95f74205db067767f74e17dcdaa7358d299b6614 | Donor status: individual | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 41 | 2015-01-06-8f616a6e-11032-0 |
b5c6d82e29c8fca1fac8d2a536de9c55555fc5dc | (Registered 15 December 2014 ) | Sponsorships 8f616a6e | 2015-01-06 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 42 | 2015-01-06-8f616a6e-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");