items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2011-05-03-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 |
---|---|---|---|---|---|---|---|
dfd459c55f27bedc39ffb87d8ce1a3e98302dd10 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 0 | 2011-05-03-8f616a6e-11696-0 |
c478db919f23b9373ef14e21573086212a5ba893 | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 1 | 2011-05-03-8f616a6e-11696-0 | |
22fa996cbf811e7426fd4b965c01ff2e51e521c2 | Name of donor: Mr Roger Gabb | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 2 | 2011-05-03-8f616a6e-11696-0 |
996c5b287183058bb494d8bfd2a7725adc057002 | Address of donor: private | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 3 | 2011-05-03-8f616a6e-11696-0 |
c3b29c0c519ec03c9703a582a471b6a05be9b8f0 | 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 | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 4 | 2011-05-03-8f616a6e-11696-0 |
363853cfb9edfc4a6183c11d1dd820a4a6666b51 | Donor status: individual | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 5 | 2011-05-03-8f616a6e-11696-0 |
0048c9946be26169ea17d59189af5f6a07e80ce5 | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 6 | 2011-05-03-8f616a6e-11696-0 |
3d0043b0b3d75983822935735d3ed11eda1ef071 | Name of donor: Mrs Mary Carpenter | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 7 | 2011-05-03-8f616a6e-11696-0 |
ba29524f57bc3b358a24df70f1a2aee1af085675 | Amount of donation or nature and value if donation in kind: £1,600 bid for auction item at fundraising event | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 9 | 2011-05-03-8f616a6e-11696-0 |
a4ddf5ddcb215955316e2825415ce9d31e6c2e01 | Name of donor: Mr Robin Parish | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 12 | 2011-05-03-8f616a6e-11696-0 |
18babdea3384a56abe124368ec122cdbc65fed3b | Address of donor: private | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 13 | 2011-05-03-8f616a6e-11696-0 |
61bdd627613062f9686bac84480c64b9e274037e | Amount of donation or nature and value if donation in kind: £5,000 bid for auction item at fundraising event | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 14 | 2011-05-03-8f616a6e-11696-0 |
6007c99f07e608e045273d79daea885444fbf21e | Donor status: individual | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 15 | 2011-05-03-8f616a6e-11696-0 |
d56befc2acabeb2870384426bb32d0370c213148 | (Registered 3 September 2010) | Sponsorships 8f616a6e | 2011-05-03 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 16 | 2011-05-03-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");