items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where record_id = "2010-09-06-8f616a6e-10555-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 |
---|---|---|---|---|---|---|---|
7c4ef8613559f315d60638edaf22642ccf16a89d | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 0 | 2010-09-06-8f616a6e-10555-0 |
d966a6ffe6829d1482d9374f2acd99c631cf6b97 | Name of donor: David Rowland | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 1 | 2010-09-06-8f616a6e-10555-0 |
ab825573ca7a5c887fd072632f16482e53a14a8a | Amount of donation or nature and value if donation in kind: personal donation of £7,200 as part payment for an auction item at a fundraising dinner. | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 3 | 2010-09-06-8f616a6e-10555-0 |
e2077be76cc2eb510a8042857710c157d4f580e8 | (Registered 1March 2010) | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 5 | 2010-09-06-8f616a6e-10555-0 |
00de15f7133b7578497f738adba345e0038f5989 | Name of donor: Andrew C Green | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 6 | 2010-09-06-8f616a6e-10555-0 |
6ac3dd2ed892b196ab8b8f3411c332862371c851 | Address of donor : private | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 7 | 2010-09-06-8f616a6e-10555-0 |
98a8ed5fbae108be2d66d91fe6050028b58f061b | Amount of donation or nature and value if donation in kind: personal donation of £4,000 as part payment for an auction item at a fundraising dinner. | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 8 | 2010-09-06-8f616a6e-10555-0 |
2a6082a7b12363708efe296769189dddf7213bd8 | Donor status: individual | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 9 | 2010-09-06-8f616a6e-10555-0 |
75eb83273184b0437ec0fed22d1d2cf67ff8c610 | (Registered 1 March 2010) | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 10 | 2010-09-06-8f616a6e-10555-0 |
853f060acdac6dc23345ce64eb96495ff5e8befe | Name of donor: Giles W. Pritchard-Gordon and Co. Ltd., shipowners and charterers | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 11 | 2010-09-06-8f616a6e-10555-0 |
f2f7b5db3ec593f480f57e9aafbe40592d599b31 | Address of donor: Slaugham park, Slaugham, West Sussex RH17 6AH | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 12 | 2010-09-06-8f616a6e-10555-0 |
28390e39b1ed3f81f582a982d883846e1b3ebe95 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 13 | 2010-09-06-8f616a6e-10555-0 |
79d3376de3a074a5c4d88910df500b0877688a4b | Donor status: company | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 14 | 2010-09-06-8f616a6e-10555-0 |
da01b3f1efd56ccb52c9ad4202489c0b2c183b03 | (Registered 31March 2010) | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 15 | 2010-09-06-8f616a6e-10555-0 |
3b748dde36d22fb3a7e9c105b906f87e60a3fdc4 | Name of donor: Mr Ian Curtis | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 16 | 2010-09-06-8f616a6e-10555-0 |
2385aaf8499183ea69acace3df334e49cbad9936 | Name of donor: Mr I Ross | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 21 | 2010-09-06-8f616a6e-10555-0 |
05fdf5a2e400002e9d836668d79e4a878317322e | Address of donor: I Ross Investments Ltd, Construction Services, Ridge Ho, Copyhold La Cuckfield, Haywards Heath, West Sussex | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 22 | 2010-09-06-8f616a6e-10555-0 |
58ac5754c2710947c994d58021838868fa2ee9ea | Donor status: Company | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 24 | 2010-09-06-8f616a6e-10555-0 |
e5c02a30d7a7b4b74a512dd2bbd47758149144c1 | Name of donor: Mr RC Odey | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 26 | 2010-09-06-8f616a6e-10555-0 |
0001500acc0bc002929baa29b3b5a45d6acbdb46 | Amount of donation or nature and value if donation in kind: 2,000 | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 28 | 2010-09-06-8f616a6e-10555-0 |
983e1d52336a6cc5cc3675944dcfc4466aaa702d | Name of donor: Mr DJ Rowland | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 31 | 2010-09-06-8f616a6e-10555-0 |
c5e43c99ac826aeab7784d3b32f43b24cc34c7a0 | Name of donor: Lucy Cady-Ross | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 36 | 2010-09-06-8f616a6e-10555-0 |
5b8ae00706e2525d87e4f689a8cd8af57fdab6db | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 38 | 2010-09-06-8f616a6e-10555-0 |
ba13e98d31b58703274a999c2ac1987e3afde307 | Name of donor: Mrs A R Said | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 41 | 2010-09-06-8f616a6e-10555-0 |
8533e998bdca75477e50c4bdc136b5f713a5aa52 | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 43 | 2010-09-06-8f616a6e-10555-0 |
5d37df5964c4e395b6b11be172654ca7385c767b | (Registered4 June 2010) | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 45 | 2010-09-06-8f616a6e-10555-0 |
0e5405cd10e264238bf17e307549432544a68795 | Name of donor: Mr I C Carter | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 46 | 2010-09-06-8f616a6e-10555-0 |
670101af3a6548fa1544b9c13073851299d278aa | Address of donor: Private | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 47 | 2010-09-06-8f616a6e-10555-0 |
41bb072d87df8adcca1de2834b862d7d2b441a8e | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 48 | 2010-09-06-8f616a6e-10555-0 |
869c9e6fc90dde25fbdc38ca86a36a602d182b9f | Donor status: Individual | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 49 | 2010-09-06-8f616a6e-10555-0 |
631dd52c5f987e0e89422f18daf1072f167b4173 | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2010-09-06 | Nicholas Soames uk.org.publicwhip/member/40397 | Nicholas Soames uk.org.publicwhip/person/10555 | 50 | 2010-09-06-8f616a6e-10555-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");