items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
24 rows where record_id = "2010-09-06-8f616a6e-11696-0" sorted by date
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
c55e1ac6b40141a1b5c4d6dbfb8e821324e19978 | 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 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 0 | 2010-09-06-8f616a6e-11696-0 |
e020648e7f6f8352f6ffc4f693ceb0e2792e1920 | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 1 | 2010-09-06-8f616a6e-11696-0 | |
f89289efdb271799b609a1806ad03d951df128e1 | Amount of donation or nature and value if donation in kind: £5850 (donated to constituency association) | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 4 | 2010-09-06-8f616a6e-11696-0 |
d4f22485c5848417069e6a9754b0fb5075fa4102 | Name of donor: Hew Kennedy | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 7 | 2010-09-06-8f616a6e-11696-0 |
555185f9fd6697d0c96f66d3dcbc0800a6115c70 | Amount of donation or nature and value if donation in kind: £1350 (donated to constituency association) | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 9 | 2010-09-06-8f616a6e-11696-0 |
992e9687ef0c4f676d86297dfe8849a9320efb52 | Name of donor: Rhoderick Swire | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 12 | 2010-09-06-8f616a6e-11696-0 |
43ea012edf61390f55ca986711c86e0ad45927a1 | Amount of donation or nature and value if donation in kind: £1250 (donated to constituency association) | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 14 | 2010-09-06-8f616a6e-11696-0 |
8a3729fbacc8c900d76be979e7423b772b9f77fe | Name of donor: Jeff Whalley | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 17 | 2010-09-06-8f616a6e-11696-0 |
bf70cef4a6ace483fe09c336bad0b3019dc5634a | (Registered 22 January 2010) | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 21 | 2010-09-06-8f616a6e-11696-0 |
c1f1906b28f648e1485c01e4d9edbe260f3b6c3c | Name of donor: Rupert Lywood | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 22 | 2010-09-06-8f616a6e-11696-0 |
03e3384d2a7fe463b85397338f7b4384718bcb0f | Amount of donation or nature and value if donation in kind: £5000 (donated to constituency association) | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 24 | 2010-09-06-8f616a6e-11696-0 |
0e3575678a23989746f0e7eefdd3d7b7771e2b5f | (Registered 5 February 2010) | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 26 | 2010-09-06-8f616a6e-11696-0 |
84af4c7175d7755ede0771b498bc1695fd80e202 | Name of donor: Mr Roger Gabb | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 27 | 2010-09-06-8f616a6e-11696-0 |
f32d113546405309f91a8b9664b4b805dcd5f479 | Address of donor: private | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 28 | 2010-09-06-8f616a6e-11696-0 |
dd45e372b482169c7a1aa338ed9dc08626932619 | 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-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 29 | 2010-09-06-8f616a6e-11696-0 |
d0f3c3a82cba7bdcaf0462ae7546343b5d017267 | Donor status: individual | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 30 | 2010-09-06-8f616a6e-11696-0 |
1e47a2c685f00bcece44904534529d375b1b3670 | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 31 | 2010-09-06-8f616a6e-11696-0 |
3c57e1089ac9efd27ff414c54784e9d313edacf0 | Name of donor: Mrs Mary Carpenter | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 32 | 2010-09-06-8f616a6e-11696-0 |
eff615c8502097ef2a3cf4f470c601008da1c9a8 | Amount of donation or nature and value if donation in kind: £1,600 bid for auction item at fundraising event | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 34 | 2010-09-06-8f616a6e-11696-0 |
9bcc4fef187c64d1dbf81772edd135e48a00c0ce | Name of donor: Mr Robin Parish | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 37 | 2010-09-06-8f616a6e-11696-0 |
1c7a9af71d7c9b1d454a4a9b00ad420c1a3f9979 | Address of donor: private | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 38 | 2010-09-06-8f616a6e-11696-0 |
9e7f4d4c85ac637ff661ef64915edd19ecca9bf6 | Amount of donation or nature and value if donation in kind: £5,000 bid for auction item at fundraising event | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 39 | 2010-09-06-8f616a6e-11696-0 |
79f5ef9fafdac959127287c1b155f869cddf6747 | Donor status: individual | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 40 | 2010-09-06-8f616a6e-11696-0 |
e094729f8a0bd5e111a0015872cb349b1e463794 | (Registered 3 September 2010) | Sponsorships 8f616a6e | 2010-09-06 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 41 | 2010-09-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");