items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2014-02-03-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 |
---|---|---|---|---|---|---|---|
6f98a0b8756e4a977daa65eed89e3b2b6f59d291 | (b) Support in the capacity as an MP: | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 0 | 2014-02-03-8f616a6e-11032-0 |
8452b1d842740c1775f9cfbfc3db8c9c52854ab0 | Name of donor: RBR Crops Ltd | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 1 | 2014-02-03-8f616a6e-11032-0 |
f63452fbafffbdcc75ebeb1999252d120f8b594d | Address of donor: Carlton Farm, Yarmouth Road, North Walsham NR28 9NA | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 2 | 2014-02-03-8f616a6e-11032-0 |
34bd648d9d8687840f3097dd849dbfae67ca85fe | Amount of donation or nature and value if donation in kind: donation of £5,000 | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 3 | 2014-02-03-8f616a6e-11032-0 |
84934f8ae14142b5f80f214df1f48ac5973e4818 | Date of receipt: 18 February 2013 | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 4 | 2014-02-03-8f616a6e-11032-0 |
26a683bddfab0258936f4e953521488da69353a1 | Date of acceptance: 18 February 2013 | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 5 | 2014-02-03-8f616a6e-11032-0 |
fb7873353f6ae74a2ad73200368f88972e5af199 | Donor status: company | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 6 | 2014-02-03-8f616a6e-11032-0 |
ec8c31c7f747fafd1a728d372472237763f71443 | (Registered 11 April 2013) | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 7 | 2014-02-03-8f616a6e-11032-0 |
e841b658e1346ac9f2e143cca88ff37adeff5095 | Name of donor: Neil Sherlock | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 8 | 2014-02-03-8f616a6e-11032-0 |
049010df30818bd1a2a2f3f385f119f87a7fe288 | Amount of donation or nature and value if donation in kind: £1,750 | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 10 | 2014-02-03-8f616a6e-11032-0 |
a4b65d8c33183890eb35eae13e3f78bcc1a04b9c | Date of receipt: 7 August 2013 | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 11 | 2014-02-03-8f616a6e-11032-0 |
4efcd7a1c27838a7bd1cf791af5d397c3ee7c57a | Name of donor: Larry Coltman | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 15 | 2014-02-03-8f616a6e-11032-0 |
471f70a2f61e0d268ace05eaa117be3a9d3f2119 | Address of donor: private | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 16 | 2014-02-03-8f616a6e-11032-0 |
9fdaf25da667adca4af2e96d45deaec515d104af | Amount of donation or nature and value if donation in kind: £1,500.50 | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 17 | 2014-02-03-8f616a6e-11032-0 |
1259634a2387d422d614a97f12b93c53cfcde119 | Donor status: individual | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 20 | 2014-02-03-8f616a6e-11032-0 |
f46d3387349f93943df8ca484cdd233f9a48e82f | Name of donor: Brompton Capital Ltd | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 22 | 2014-02-03-8f616a6e-11032-0 |
4582cf4c73c04aeaeb0c1ac707cc3fc2f38a2183 | Address of donor: 35 South St, London W1K 2XE | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 23 | 2014-02-03-8f616a6e-11032-0 |
ea9b033f62b4c3924d0296c8dbd0f2201f1325bc | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 24 | 2014-02-03-8f616a6e-11032-0 |
3d91f8f7a057d1214b76acdaa689b139cd05dd79 | Date of receipt: 8 August 2013 | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 25 | 2014-02-03-8f616a6e-11032-0 |
2cf39db8f5a37faec6be117af8675623c7d5affe | Date of acceptance: 8 August 2013 | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 26 | 2014-02-03-8f616a6e-11032-0 |
c2fc9e02135c8a9c23924e00a008c6b5fbe52fe2 | Donor status: company, registration no 03275808 | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 27 | 2014-02-03-8f616a6e-11032-0 |
bfe1872a5b25adebf5404c3a433242ea660ef9ac | (Registered 5 September 2013) | Sponsorships 8f616a6e | 2014-02-03 | Norman Lamb uk.org.publicwhip/member/40443 | Norman Lamb uk.org.publicwhip/person/11032 | 28 | 2014-02-03-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");