items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
35 rows where record_id = "2010-11-08-9e46def6-10213-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 |
---|---|---|---|---|---|---|---|
47d7807839f432252874c2762ccce1d88e3f25fd | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 0 | 2010-11-08-9e46def6-10213-0 |
4b81a121d2e7315f351db1ddefdfd68fec6ed8ff | Name of donor: Mr Kenneth Edis | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 1 | 2010-11-08-9e46def6-10213-0 |
29f819fd8e6449e643a9617012431be1ca062a46 | Amount of donation or nature and value if donation in kind: £1,900. (This donation was given to the constituency association, who will report it to the Electoral Commission.) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 3 | 2010-11-08-9e46def6-10213-0 |
613571f875e85f4b13652d7a75dbfa1b28e7cb3c | (Registered 20 May 2010) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 5 | 2010-11-08-9e46def6-10213-0 |
2affc22e029dbfe268d802e0bf5e28685fe76abe | Support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 6 | 2010-11-08-9e46def6-10213-0 |
e53a7a56b3d724b69e216d5f203e42503a926f73 | Contributions to staffing and running of private office from: | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 7 | 2010-11-08-9e46def6-10213-0 |
07f347287c1d2fd4a907f58c6a3e2480518b10aa | Name of donor: Mr Oliver Pawle | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 8 | 2010-11-08-9e46def6-10213-0 |
db256f5c1b85911b7e7ef33f520f7ca3db1775aa | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 9 | 2010-11-08-9e46def6-10213-0 |
f8a440f9b0d51767a025be52bb9f0196d5ffb168 | Amount of donation or nature and value if donation in kind: £5000 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 10 | 2010-11-08-9e46def6-10213-0 |
004d8bbb00db6045e14329167cc51251a24b9f26 | Date of receipt: 2 November 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 11 | 2010-11-08-9e46def6-10213-0 |
4a1fe3b6dc1feecc75c68b220319d176592cb6f1 | Date of acceptance: 2 November 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 12 | 2010-11-08-9e46def6-10213-0 |
ca244733eca31a1f843f08119bff4ba4cee49725 | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 13 | 2010-11-08-9e46def6-10213-0 |
ea5e4795b9102c6c9aad53912f26f7aa2cc2d7e9 | (Registered 3 November 2009) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 14 | 2010-11-08-9e46def6-10213-0 |
bb86c2ef7f21ceda100a8896a94a66a9f4e9610f | Name of donor: Mr Philip Shelley | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 15 | 2010-11-08-9e46def6-10213-0 |
9b2a6c78c279fc2cd6fcbafeeb60e081436791f5 | Date of receipt: 11 November 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 18 | 2010-11-08-9e46def6-10213-0 |
bff290d1bafd321311fc00424fb5416a3ba049fc | Date of acceptance: 11 November 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 19 | 2010-11-08-9e46def6-10213-0 |
06001008a539d58bf21f9d29115f6530d37a0c6b | (Registered 18 November 2009) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 21 | 2010-11-08-9e46def6-10213-0 |
f73ab0af6d679be9746f16aa6e05806b8accedb3 | Name of donor: Mark Bathgate on behalf of Tweeddale Advisors Ltd | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 22 | 2010-11-08-9e46def6-10213-0 |
166c8c7208ae97ed6896038b67d2edc7c776910f | Address of donor: c/o Turcan Connell, Princes Exchange, 1 Earl Grey Street, Edinburgh, EH3 9EE. | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 23 | 2010-11-08-9e46def6-10213-0 |
20c09b03d7a5fd8e8a8706b3b81cca942a61f561 | Amount of donation or nature and value if donation in kind: £5000 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 24 | 2010-11-08-9e46def6-10213-0 |
fea6f94ddce5211ba3c2f38bb8c4fb08a81a7790 | Date of receipt: 7 December 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 25 | 2010-11-08-9e46def6-10213-0 |
d86e0930e015f70df79b51db90c4c982a6790a32 | Date of acceptance: 7 December 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 26 | 2010-11-08-9e46def6-10213-0 |
604c3f46b5bcb3f1ffef07c88b87ec6d45d75c7c | Donor status: company, registration number SC343164 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 27 | 2010-11-08-9e46def6-10213-0 |
ada7878e837e10fdf90dfc46287bfe3afbd9c450 | (Registered 9 December 2009) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 28 | 2010-11-08-9e46def6-10213-0 |
8a2e6e9b0938ad56bed4bc5fae8739ea3ed9fcd9 | Name of donor: Mr Chris Lewis | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 29 | 2010-11-08-9e46def6-10213-0 |
c3115890ac5b31891cb027e512785b71f30d5a67 | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 31 | 2010-11-08-9e46def6-10213-0 |
bb77172b4c60e281aa2524da531a4782145685d8 | Date of receipt: 18 January 2010 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 32 | 2010-11-08-9e46def6-10213-0 |
d25fe6ea76738b3efdca97090c6c21956016c3e9 | Date of acceptance: 18 January 2010 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 33 | 2010-11-08-9e46def6-10213-0 |
d00e07911de48598067c303169b3a90f0bb91854 | Name of donor: Mr Jon Moulton | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 36 | 2010-11-08-9e46def6-10213-0 |
a584e576bf991b8bec36e140507db3daf5a877b0 | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 37 | 2010-11-08-9e46def6-10213-0 |
e45583fe9bf36d85237d1c4e8de0844751b9011e | Amount of donation or nature and value if donation in kind: £50,000 (given to me in my previous capacity as Shadow Secretary of State for Defence) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 38 | 2010-11-08-9e46def6-10213-0 |
92041b59f0f9a93300491c5a787042caff9bc5f9 | Date of receipt: 26 January 2010 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 39 | 2010-11-08-9e46def6-10213-0 |
64a2da6c4d9575a67f23b09250fa65a6a544661f | Date of acceptance: 26 January 2010 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 40 | 2010-11-08-9e46def6-10213-0 |
c8cd96ef046697b847c4e7ca0072db286b961127 | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 41 | 2010-11-08-9e46def6-10213-0 |
997e38368a67cf96bbb9dd60a19cb9b537d0e6e6 | (Registered 29 January 2010) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Liam Fox uk.org.publicwhip/member/40445 | Liam Fox uk.org.publicwhip/person/10213 | 42 | 2010-11-08-9e46def6-10213-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");