items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where "date" is on date 2011-03-14 and person_id = "uk.org.publicwhip/person/10477" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
eed52bbf37efc6ebeaa1758d1af82d6b84a7cc01 | Printing of calendars and advice centre notices by International Property Magazine, of Chelmsford. | Sponsorship or financial or material support 9e46def6 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 0 | 2011-03-14-9e46def6-10477-0 |
b122de262649e15fffae643f3df7cda7d8ea44c0 | Name of donor: Noble Foods | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 0 | 2011-03-14-84642823-10477-0 |
c84bf60e8700e3a1f9ed6676faa9a337e8ae3b78 | Address of donor : Bridgeway House, Icknield Way, Tring, Herts HP23 4JX. | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 1 | 2011-03-14-84642823-10477-0 |
698a8ed4709a95f8edc7351233e43b6c0ca3d3e8 | Amount of donation or nature and value if donation in kind: helicopter transport for myself and one other passenger travelling from London to Llandudno and back. The total cost of the flight was £4,099.75 (it is this value that will be reported to the Electoral Commission by the Conservative Party). | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 2 | 2011-03-14-84642823-10477-0 |
056e2088d66a9c3fe60df2eeaf077a309d165e61 | Date of receipt of donation: 7 March 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 3 | 2011-03-14-84642823-10477-0 |
be21bae7044bba0d233eab20fa4e13e1c36fc585 | Date of acceptance of donation: 7 March 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 4 | 2011-03-14-84642823-10477-0 |
bdab98b4f252b43f887bb1502e2635d85fe4da45 | Donor status: company, registration number 05826545 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 5 | 2011-03-14-84642823-10477-0 |
4f91f49a88b7efa92a1b0db35a8d16f6a91917f9 | (Registered 29 March 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 6 | 2011-03-14-84642823-10477-0 |
ededf0bd95fc14125c81c18ff5ca31833e16c698 | Name of donor: Provident Financial Bradford | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 7 | 2011-03-14-84642823-10477-0 |
94085d1ddeb98f030eba984275c9a82f298a1e52 | Address of donor : Colonnade Sunbridge Road Bradford BD1 2LQ | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 8 | 2011-03-14-84642823-10477-0 |
4985dd1ffa8c69bfc0b7715f2279acaed5622eeb | Amount of donation or nature and value if donation in kind: two tickets for Wimbledon tennis 3 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 9 | 2011-03-14-84642823-10477-0 |
0730304878459489e6b3eec58ae88b7702b99622 | Date of receipt of donation: 3 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 10 | 2011-03-14-84642823-10477-0 |
0a8c5425d8586fc273cc927fd8cfe39f254b92d4 | Date of acceptance of donation: 3 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 11 | 2011-03-14-84642823-10477-0 |
96db1ddcffb9e14f9f9a18a604aea4f314ee4f74 | Name of donor: Rainham Steel Company Limited | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 14 | 2011-03-14-84642823-10477-0 |
a915828d5800925dc9e331dac6f23e5925f3a396 | Address of donor : Devonshire House, 60 Goswell Road, London EC1M 7AD. | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 15 | 2011-03-14-84642823-10477-0 |
dda95280068a36a42c046dee77391e2701a3b944 | Amount of donation or nature and value if donation in kind: my wife and I received tickets to the Conservative Party’s Summer Party (value: £900). Payment was made directly to the Conservative Party | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 16 | 2011-03-14-84642823-10477-0 |
e4b443a3214569105afd86961b71af7ccc4c575a | Date of receipt of donation: 5 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 17 | 2011-03-14-84642823-10477-0 |
740f7e249d517551019d81cb12808c60da2e4206 | Date of acceptance of donation: 5 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 18 | 2011-03-14-84642823-10477-0 |
8c0de9386c37f081b9317568e709e4b4593dd44a | Donor status: company, registration number 01093531 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 19 | 2011-03-14-84642823-10477-0 |
a23ddbe8fa6e20f06618118304bf42c379752c1d | (Registered 22 July 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 20 | 2011-03-14-84642823-10477-0 |
d3d62929a44faf0331cb41ebbda67a7ad05034a5 | Name of donor: Mr W Ives | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 21 | 2011-03-14-84642823-10477-0 |
574b8dea0fbd616bc1550e5a1af7a264dd11a96f | Address of donor : Rainham Steel, Kathryn House, Manor Way, Rainham RM13 8RE | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 22 | 2011-03-14-84642823-10477-0 |
3588ba9cc1cddaf4694981cd50d08a4ecc2aac93 | Amount of donation or nature and value if donation in kind: 2 tickets to Conservative Party Black and White Party; total value £800 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 23 | 2011-03-14-84642823-10477-0 |
8032a609b8e9a5d2fcc48cd0ab93a6c8bc4102e7 | Date of receipt of donation: 7 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 24 | 2011-03-14-84642823-10477-0 |
2dc5c02beccf4e7895eb899cc46b0c73abd3d792 | Date of acceptance of donation: 7 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 25 | 2011-03-14-84642823-10477-0 |
fbe045a4fa50f58042bb6dbc41e4b6f9caff0fbf | Donor status: company, registration 1093531 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 26 | 2011-03-14-84642823-10477-0 |
9adc099407b96e0bd35277857ec6450298ae4aa1 | (Registered 25 February 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-14 | Eric Pickles uk.org.publicwhip/member/40116 | Eric Pickles uk.org.publicwhip/person/10477 | 27 | 2011-03-14-84642823-10477-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");