items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
26 rows where "date" is on date 2014-06-02 and person_id = "uk.org.publicwhip/person/10080" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
3ad9756034b197f4c6b5f9b9ddcb0c15a0d6da92 | Payments for speaking at Westminster Explained events, Dods, 21 Dartmouth Street, Westminster London SW1H 9BP. All fees donated to Sutton Liberal Democrats: | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2014-06-02-1f359ece-10080-0 |
77d2723b845458511c3309c0c105349daf0f7d6e | March 2013, payment of £150. Hours: 45 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 1 | 2014-06-02-1f359ece-10080-0 |
8be5a666ede3458a14833bafdb91e7c484dc4b70 | June 2013, payment of £150. Hours: 45 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 2 | 2014-06-02-1f359ece-10080-0 |
2fdd577f82361b07cbaabcd3fa5f605b67c5087b | March 2014, payment of £150. Hours: 45 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 3 | 2014-06-02-1f359ece-10080-0 |
b44a5aefa6c736af7f0a39eb27a613c1a375f29d | Payments for completing opinion surveys from ComRes, 4 Millbank, London, SW1P 3JA, for opinion surveys. All fees donated to Sutton Liberal Democrats: | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 4 | 2014-06-02-1f359ece-10080-0 |
908caa8507fb7973d7142b65862f85004858e4dd | March 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 5 | 2014-06-02-1f359ece-10080-0 |
d6cf0c8565d1e8531739ed80e0b0168df508965f | May 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 6 | 2014-06-02-1f359ece-10080-0 |
5c54edd3e087d3640e9869a08b70f05b4177a2cf | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-06-02-1f359ece-10080-0 |
7fe92bb1cc5e17ac814575b09c870dcb8edc2a5e | November 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 8 | 2014-06-02-1f359ece-10080-0 |
28201095c6b52637295c1b7e1bbf27c8a6dcae0f | January 2014, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2014-06-02-1f359ece-10080-0 |
e7927ebb90c870b9e4382c127046d0a95a852cad | March 2014, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 10 | 2014-06-02-1f359ece-10080-0 |
d046526eb63a75c07bc7c05a1954bd406da0c388 | May 2014, payment of £75. Hours: 30 mins. (Registered 16 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 11 | 2014-06-02-1f359ece-10080-0 |
d11525f0cd572e8b82c02ea3dbfdf4acdcaa22c7 | Payments from Ipsos MORI, 79-81 Borough Road, London SE1 1FY, for opinion surveys. All fees donated to Sutton Liberal Democrats: | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 12 | 2014-06-02-1f359ece-10080-0 |
9d316e3c41a81c83b08a607be2fe2b663a1cc96e | September 2013, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 13 | 2014-06-02-1f359ece-10080-0 |
e0b88258deff3552222e785e0e1e846fcb88793e | January 2014, payment of £200. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 14 | 2014-06-02-1f359ece-10080-0 |
8325c23da144a1a1470fa7ed0cf4d25b80c35325 | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 15 | 2014-06-02-1f359ece-10080-0 | |
98cf974bd799346e69badac852b5b0717014a51e | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT. All fees donated to Sutton Liberal Democrats: | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 16 | 2014-06-02-1f359ece-10080-0 |
87a179fc982dd0afbc8717aeb04b8e7009fa501f | November 2013, payment of £80. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 17 | 2014-06-02-1f359ece-10080-0 |
5d0d0b9c7b6b7e1b1bb8f8412d31eabfa6422f81 | December 2013, payment of £80. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 18 | 2014-06-02-1f359ece-10080-0 |
bf689496ec6f78e571664917828e49b537f0c88c | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2014-06-02-8f616a6e-10080-0 |
96e092fb551b998164492d9886dfb034277e3483 | Name of donor: Paul Burstow Business Networking Club | Sponsorships 8f616a6e | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 1 | 2014-06-02-8f616a6e-10080-0 |
509ad3103d91f7ca86b8cf15311227a2fdb9b283 | Address of donor: 234 Gander Green Lane, Sutton SM3 9QF | Sponsorships 8f616a6e | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 2 | 2014-06-02-8f616a6e-10080-0 |
b6e20d1f257a5a23f79c46e993485e0e03c730a1 | Amount of donation or nature and value if donation in kind: £1,549.45 | Sponsorships 8f616a6e | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 3 | 2014-06-02-8f616a6e-10080-0 |
a18aa8aa18e96a2b38b12462756788ddc921e670 | Donor status: members’ association | Sponsorships 8f616a6e | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 4 | 2014-06-02-8f616a6e-10080-0 |
894ef1ba32584c8078770c73a650d3a75a9736ac | (Registered 30 January 2014) | Sponsorships 8f616a6e | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 5 | 2014-06-02-8f616a6e-10080-0 |
6541ca05a09af1e88e0f97a99d222f929a2988e6 | I own a 25% share of house in Sutton, lived in by my mother. | Land and Property 4f1e6359 | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2014-06-02-4f1e6359-10080-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");