items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
24 rows where record_id = "2010-12-06-8f616a6e-11696-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 |
---|---|---|---|---|---|---|---|
9d213085f291f970199a3862dd48f044963ecfaa | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 0 | 2010-12-06-8f616a6e-11696-0 |
e8230b974cc7e0ef54fd7da9507e1dc1d029fdd7 | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 1 | 2010-12-06-8f616a6e-11696-0 | |
28a5ccf067963c5c21f29861b708df9f9ab1924c | Amount of donation or nature and value if donation in kind: £5850 (donated to constituency association) | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 4 | 2010-12-06-8f616a6e-11696-0 |
671b42671843f68621bab4d7f9ca4eb68e49b697 | Name of donor: Hew Kennedy | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 7 | 2010-12-06-8f616a6e-11696-0 |
ee9610a3b41ca829b2ada37b66f27700e85c4dd1 | Amount of donation or nature and value if donation in kind: £1350 (donated to constituency association) | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 9 | 2010-12-06-8f616a6e-11696-0 |
45b5a28177f2f14fe4e672ef867efce3ef035295 | Name of donor: Rhoderick Swire | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 12 | 2010-12-06-8f616a6e-11696-0 |
bcd11bb6584dfc9605e5cde7ec6a0487de14bf47 | Amount of donation or nature and value if donation in kind: £1250 (donated to constituency association) | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 14 | 2010-12-06-8f616a6e-11696-0 |
b8848077188455499df48927834fc9783501451b | Name of donor: Jeff Whalley | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 17 | 2010-12-06-8f616a6e-11696-0 |
c17cbc022066728f896a73ec8e4c17333c8f351e | (Registered 22 January 2010) | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 21 | 2010-12-06-8f616a6e-11696-0 |
2fafeae8c25f7e9f1db0725fe7c38771398e6438 | Name of donor: Rupert Lywood | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 22 | 2010-12-06-8f616a6e-11696-0 |
fd938db528609bd7632e42078948d64756e4c479 | Amount of donation or nature and value if donation in kind: £5000 (donated to constituency association) | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 24 | 2010-12-06-8f616a6e-11696-0 |
06d5744caf99bc3879bf782a6c162e32761e6602 | (Registered 5 February 2010) | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 26 | 2010-12-06-8f616a6e-11696-0 |
e2c2d648959136154e7fab85be64740eba08c28e | Name of donor: Mr Roger Gabb | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 27 | 2010-12-06-8f616a6e-11696-0 |
dfe5c4a79e357a22c3d3b2aa3e6ba1623b6cdf6c | Address of donor: private | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 28 | 2010-12-06-8f616a6e-11696-0 |
d35fb55658c150f04497e6c91f3e93b8e1f0dc1f | Amount of donation or nature and value if donation in kind: value of one week in house in Cape Town for Gala Auction dinner; value £4,000. | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 29 | 2010-12-06-8f616a6e-11696-0 |
56715e3c1bf7baccceaa905ab753150dd12c882e | Donor status: individual | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 30 | 2010-12-06-8f616a6e-11696-0 |
35ace8baca46940894d4e102c0f20169c5087d02 | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 31 | 2010-12-06-8f616a6e-11696-0 |
0ee0843a85f2dc8d9c8cb7d2245a590d01d74780 | Name of donor: Mrs Mary Carpenter | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 32 | 2010-12-06-8f616a6e-11696-0 |
5e067a840bba4732b9a7d47c53fd2591df63d03b | Amount of donation or nature and value if donation in kind: £1,600 bid for auction item at fundraising event | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 34 | 2010-12-06-8f616a6e-11696-0 |
4d5c6413ee5256a070fca9834aafb818c6225f0c | Name of donor: Mr Robin Parish | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 37 | 2010-12-06-8f616a6e-11696-0 |
d5f8abf27cff658ff4d628fb3db7b835e20a004d | Address of donor: private | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 38 | 2010-12-06-8f616a6e-11696-0 |
b96e7bdf1684fda160bf1d5b31d345fce3c150a0 | Amount of donation or nature and value if donation in kind: £5,000 bid for auction item at fundraising event | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 39 | 2010-12-06-8f616a6e-11696-0 |
2a5b42f650a979cfe4e6706f4f91eeaa0e0333ac | Donor status: individual | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 40 | 2010-12-06-8f616a6e-11696-0 |
f82b715f3b70945ed5acc005a62f384f3c8f557e | (Registered 3 September 2010) | Sponsorships 8f616a6e | 2010-12-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 41 | 2010-12-06-8f616a6e-11696-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");