items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where record_id = "2014-04-28-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 |
---|---|---|---|---|---|---|---|
e3392a3810289c09d45298ca825f46e4c259e267 | (b) Support in the capacity as an MP: | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 0 | 2014-04-28-8f616a6e-11032-0 |
daafb7af3d00a11132e413c23c264de68b4f8652 | Name of donor: RBR Crops Ltd | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 1 | 2014-04-28-8f616a6e-11032-0 |
999b704e5f35db656218a1d14e823d23aea875a2 | Address of donor: Carlton Farm, Yarmouth Road, North Walsham NR28 9NA | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 2 | 2014-04-28-8f616a6e-11032-0 |
e5135737b34ea88791e24834264dfd9a45cdb147 | Amount of donation or nature and value if donation in kind: donation of £5,000 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 3 | 2014-04-28-8f616a6e-11032-0 |
f1dc8db80124f58632ee8fe11627d12e6c130648 | Date of receipt: 18 February 2013 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 4 | 2014-04-28-8f616a6e-11032-0 |
39fda12a4341d46b050fbdb1b1b0696cdeffe638 | Date of acceptance: 18 February 2013 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 5 | 2014-04-28-8f616a6e-11032-0 |
621ce64f5b8a7314e18afac4f4e18971b0c0e4e5 | Donor status: company | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 6 | 2014-04-28-8f616a6e-11032-0 |
127193e3888ae92ea99b385800e3d2e3f4d647f3 | (Registered 11 April 2013) | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 7 | 2014-04-28-8f616a6e-11032-0 |
c4dfc690a32c716c78a8d371ec9017490424e662 | Name of donor: Neil Sherlock | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 8 | 2014-04-28-8f616a6e-11032-0 |
c07404c452e2ad29635c7727b45b8426aa8e3733 | Amount of donation or nature and value if donation in kind: £1,750 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 10 | 2014-04-28-8f616a6e-11032-0 |
c5b016b6186e986448737138663e91c128c1d3e9 | Date of receipt: 7 August 2013 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 11 | 2014-04-28-8f616a6e-11032-0 |
641ebb32406d42cab168cc2937187b2f26416a14 | Name of donor: Larry Coltman | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 15 | 2014-04-28-8f616a6e-11032-0 |
27351c5aae9d74557d36676df03e1dbd9bfa76fc | Amount of donation or nature and value if donation in kind: £1,500.50 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 17 | 2014-04-28-8f616a6e-11032-0 |
36cd3042260b27365512679c275b5e2acc0c59fa | Name of donor: Brompton Capital Ltd | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 22 | 2014-04-28-8f616a6e-11032-0 |
6c92d85546100325b508fc027553c440e07e3e2f | Address of donor: 35 South St, London W1K 2XE | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 23 | 2014-04-28-8f616a6e-11032-0 |
ad37c91c39c6813cce223a81c471938b5cf9f0bf | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 24 | 2014-04-28-8f616a6e-11032-0 |
923ccaa81060822a07e7355961fa65e11ad5589e | Date of receipt: 8 August 2013 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 25 | 2014-04-28-8f616a6e-11032-0 |
74bcfbf0e61bd5d06773bc3e733998feb2ecdc58 | Date of acceptance: 8 August 2013 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 26 | 2014-04-28-8f616a6e-11032-0 |
121a5347a4b493dc82418b57d7a7c9bb89f2d7f5 | Donor status: company, registration no 03275808 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 27 | 2014-04-28-8f616a6e-11032-0 |
f1825b5d057bc18311a2361aa76097613d7c6c61 | (Registered 5 September 2013) | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 28 | 2014-04-28-8f616a6e-11032-0 |
6d18a53db100870da8244f0a6857674059a15c33 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 29 | 2014-04-28-8f616a6e-11032-0 |
2b43f156631bfafd010e8dc072bf7304fd03baed | Name of donor: Targetfollow Estates Ltd. | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 30 | 2014-04-28-8f616a6e-11032-0 |
ff0fd1d3d33062008c6fe80606bf7cc865ba56d1 | Address of donor: Riverside House, 11-12 Riverside Road, Norwich NR 1 1SQ | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 31 | 2014-04-28-8f616a6e-11032-0 |
b5aa48089707f63ea1984b458226884c65444a12 | Donor status: company, registration 04697861 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 33 | 2014-04-28-8f616a6e-11032-0 |
a5efa24ae5559ef0f96a75ff01fc1ce28a47dd74 | Name of donor: Ardeshir Nagshineh | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 35 | 2014-04-28-8f616a6e-11032-0 |
4186441380485978c5b7f1935a32ca07a155d5e1 | Address of donor: private | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 36 | 2014-04-28-8f616a6e-11032-0 |
e98439c9d1c52b617c1cab556815b7f58a712819 | Amount of donation or nature and value if donation in kind: £4,950 | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 37 | 2014-04-28-8f616a6e-11032-0 |
02863e60cb78444cb3ae2abb16cf8937a8bee5ed | Donor status: individual | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 38 | 2014-04-28-8f616a6e-11032-0 |
2c61279ee01f3a06c44bb2cb96eb7113339b150b | (Registered 25 February 2014) | Sponsorships 8f616a6e | 2014-04-28 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 39 | 2014-04-28-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");