items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
24 rows where "date" is on date 2011-02-28 and record_id = "2011-02-28-8f616a6e-11696-0" sorted by sort_order
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
4bcb2af6731c157a2518651d1e598aa1ddbdf35d | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 0 | 2011-02-28-8f616a6e-11696-0 |
d9ff99aa255de06b2e5b982057711c889f656a64 | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 1 | 2011-02-28-8f616a6e-11696-0 | |
a37028d3078dd630b63fe6202c0680ebc1426a27 | Amount of donation or nature and value if donation in kind: £5850 (donated to constituency association) | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 4 | 2011-02-28-8f616a6e-11696-0 |
2cbee074c1691318bdf4232b367a61d12cbf7629 | Name of donor: Hew Kennedy | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 7 | 2011-02-28-8f616a6e-11696-0 |
9228bec04f213b3bdabe31326f8a6daf98c6d70f | Amount of donation or nature and value if donation in kind: £1350 (donated to constituency association) | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 9 | 2011-02-28-8f616a6e-11696-0 |
ab6f2b7787dea5ed21f6675690a1b1f2b2f10f30 | Name of donor: Rhoderick Swire | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 12 | 2011-02-28-8f616a6e-11696-0 |
0292b628aa4d3920e60a57b0a4b422ed587b5df6 | Amount of donation or nature and value if donation in kind: £1250 (donated to constituency association) | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 14 | 2011-02-28-8f616a6e-11696-0 |
bdd0149e368895153750290b2b4bc7aa569f5c62 | Name of donor: Jeff Whalley | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 17 | 2011-02-28-8f616a6e-11696-0 |
512e6a1e6c9d409ef93603e2dfe2a2f9e5b1df0c | (Registered 22 January 2010) | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 21 | 2011-02-28-8f616a6e-11696-0 |
2eed494da9ec8719147723c6420a96e1c225282f | Name of donor: Rupert Lywood | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 22 | 2011-02-28-8f616a6e-11696-0 |
80d24290abc09584b1baef3b5e9e00b4fa4c57a2 | Amount of donation or nature and value if donation in kind: £5000 (donated to constituency association) | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 24 | 2011-02-28-8f616a6e-11696-0 |
cf3ddabac820c4fbb045d98c442de13f4422e913 | (Registered 5 February 2010) | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 26 | 2011-02-28-8f616a6e-11696-0 |
b09b11bab2d6f5bf9124f395a99f5927db17ac3b | Name of donor: Mr Roger Gabb | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 27 | 2011-02-28-8f616a6e-11696-0 |
95a9110d1efb51697f5543ed5915aff76679d719 | Address of donor: private | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 28 | 2011-02-28-8f616a6e-11696-0 |
78ba99b5e98c2a9bc2b4132e3e21849dcde44220 | 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-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 29 | 2011-02-28-8f616a6e-11696-0 |
81ec6fd9c86f6893188cac62b77c7e80074def23 | Donor status: individual | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 30 | 2011-02-28-8f616a6e-11696-0 |
50d0e13db48d963e5201141dfb8825890dffe7ed | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 31 | 2011-02-28-8f616a6e-11696-0 |
8812a25366fab5b4fa4625be3827d510fe21a942 | Name of donor: Mrs Mary Carpenter | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 32 | 2011-02-28-8f616a6e-11696-0 |
576fad108d2b9ef867563ecf8430af0cecbc0d1f | Amount of donation or nature and value if donation in kind: £1,600 bid for auction item at fundraising event | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 34 | 2011-02-28-8f616a6e-11696-0 |
bcedb12df41b41529874a52be1142dee603b05c5 | Name of donor: Mr Robin Parish | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 37 | 2011-02-28-8f616a6e-11696-0 |
0777f27c30cdd0eae7af0c0cd78f271d168fbdba | Address of donor: private | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 38 | 2011-02-28-8f616a6e-11696-0 |
6697f5d7ad55dfaf75f75fe1543a20342509d3d4 | Amount of donation or nature and value if donation in kind: £5,000 bid for auction item at fundraising event | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 39 | 2011-02-28-8f616a6e-11696-0 |
9427970e889dedf3e793b6e446547eb99c17a452 | Donor status: individual | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 40 | 2011-02-28-8f616a6e-11696-0 |
4f7a814ef1e56927166bb4c37005a8235fcfc060 | (Registered 3 September 2010) | Sponsorships 8f616a6e | 2011-02-28 | Philip Dunne uk.org.publicwhip/member/40378 | Philip Dunne uk.org.publicwhip/person/11696 | 41 | 2011-02-28-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");