items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2010-11-08-9e46def6-11859-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 |
---|---|---|---|---|---|---|---|
4d8e49278987c3f7a3e4dd45e578a88c132cda15 | 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 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 0 | 2010-11-08-9e46def6-11859-0 |
1339a2b2931747c804fc3752177c8883f9ff51aa | Name of donor: Mr John Littlewood | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 1 | 2010-11-08-9e46def6-11859-0 |
dc731aa8e33ac85499b0ed0fee4b3596ac4555d2 | Amount of donation or nature and value if donation in kind: Donations: £500 received on 18 March 2009 and £1000 received on 10 December 2009. | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 3 | 2010-11-08-9e46def6-11859-0 |
c207a0b40c930d5fdf1df9c93b1672269450159e | (Registered 22 December 2009) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 5 | 2010-11-08-9e46def6-11859-0 |
923b838fd72b984dccb8a9a5f0182c86175e16f9 | Name of donor: Patricia Frost | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 6 | 2010-11-08-9e46def6-11859-0 |
63c4e9cfe9194b761eccbcfc0c6e1f2aa90cc6d1 | Amount of donation or nature and value if donation in kind: £2,850 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 8 | 2010-11-08-9e46def6-11859-0 |
0045549fcb423bc0dd0857297c6f7cd7427fe320 | Name of donor: Andrew Law | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 11 | 2010-11-08-9e46def6-11859-0 |
c857ac0f6cc9ead3da2f3ed1185097d07c989c7f | Amount of donation or nature and value if donation in kind: £3,600 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 13 | 2010-11-08-9e46def6-11859-0 |
82833299983855f301e0d59fc3064aad7f46824c | Donor status: | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 14 | 2010-11-08-9e46def6-11859-0 |
d9ba006e5f4b8e6ca3a83c5e8fbacb604bd99bfd | Name of donor: Nick Roach | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 16 | 2010-11-08-9e46def6-11859-0 |
4b9b2678e11adfc2748812f3bb81dd243da5b0e6 | Amount of donation or nature and value if donation in kind: hire of venue and entertainment valued at £8,000 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 18 | 2010-11-08-9e46def6-11859-0 |
dcdae85eb7b3be402949267cb1bba34ef5cb415e | Name of donor: Charles and Monica Eve | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 21 | 2010-11-08-9e46def6-11859-0 |
a1527cf848e78c2d6e1126a817e1c27c1d5b9a92 | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 22 | 2010-11-08-9e46def6-11859-0 |
65d097c4df6a7baa46efa9e207b00e961d18bc26 | Donor status: individuals | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 24 | 2010-11-08-9e46def6-11859-0 |
e4520899b3af48d07b41da7f9e43c98df79fd8a5 | Name of donor: John Winter | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 26 | 2010-11-08-9e46def6-11859-0 |
b2d3fea6a45c58875569cbf4009ae8dba52892e1 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 28 | 2010-11-08-9e46def6-11859-0 |
8849a38fd9dc1445da1bae012442c697028c0945 | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 29 | 2010-11-08-9e46def6-11859-0 |
e19584d541cd6802a81bcacae33bd9fdfa957294 | (Registered 17 June 2010) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 30 | 2010-11-08-9e46def6-11859-0 |
db239d2d4e72af47c99cf216ad215ed89c18b553 | Name of donor: Peter Hall | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 31 | 2010-11-08-9e46def6-11859-0 |
62cbf04294d584e6cb7555a3b86c3b09128ccf44 | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 32 | 2010-11-08-9e46def6-11859-0 |
8d534467dfbfa579e5cc9452a7cd59569cf61149 | Amount of donation or nature and value if donation in kind: £2000 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 33 | 2010-11-08-9e46def6-11859-0 |
e2d4b986e53ebdff216b3e013ba43f46c3b3f0d6 | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 34 | 2010-11-08-9e46def6-11859-0 |
9edac1726898d39278acb9f12db78ec8a1ee7ad9 | (Registered 3 February 2010) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 35 | 2010-11-08-9e46def6-11859-0 |
a10689ac78995afb0648202e49ba91f63ef5ffcc | (b) Support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 36 | 2010-11-08-9e46def6-11859-0 |
9954998c3d04cf293403aca5167cf49c4d78b7be | Financial support for my office costs from: | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 37 | 2010-11-08-9e46def6-11859-0 |
db6a81b21d9396a3e775a10a9abc94590431d381 | Hotcourses Ltd; an educational publisher. | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 38 | 2010-11-08-9e46def6-11859-0 |
f36f78ed1c8073d4a10302b5d0922e7e99ccb284 | Mr John Lewis, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Jeremy Hunt uk.org.publicwhip/member/40561 | Jeremy Hunt uk.org.publicwhip/person/11859 | 39 | 2010-11-08-9e46def6-11859-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");