items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where "date" is on date 2012-11-05 and person_id = "uk.org.publicwhip/person/10484" sorted by date descending
This data as json, CSV (advanced)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
81ae941258d25883c5629bc139b0da1340fc170b | Payments from British Sky Broadcasting Ltd, Accounts Payable Department, 1 Macintosh Road, Kirkton Campus, Livingston, West Lothian, EH54 7BW: | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 0 | 2012-11-05-1f359ece-10484-0 |
a687572cebf7877fbdb2b46e707a50bce452ac51 | 26 January 2011, received payment of £100 for paper review on Sky television. Hours: 30 mins. (Registered 20 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 1 | 2012-11-05-1f359ece-10484-0 |
3377107b131703f8867ddf96f8fe2dc02b04db92 | 26 August 2011 received payment of £100 for paper review on Sky television. Hours: 30 mins. (Registered 20 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 2 | 2012-11-05-1f359ece-10484-0 |
b1ff2bfd5b029ba479c13382dafd945ab191ed8b | 14 March 2012, received payment of £100 for appearance on Sky News. Hours: 3 hrs. (Registered 21 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 3 | 2012-11-05-1f359ece-10484-0 |
99b5693c4a58d525f8a3c0f5057da108228e37a9 | 29 March 2012, received payment of £100 from BSkyB Group, Grant Way, Isleworth, Middlesex TW7 5QD, for paper review. Hours: 2 hrs. (Registered 5 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 4 | 2012-11-05-1f359ece-10484-0 |
ab4c01caa6234b3c978fee7cc6d189811b530d30 | Payment of £440 received on 5 November 2011 for lectures for Drew University. Address: 99 Great Russell Street, London WC1B 3LA. Hours: 4 hrs (Registered 20 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 5 | 2012-11-05-1f359ece-10484-0 |
09389c0833616e935598affdfb7035a5c98ac6bd | Payments from Government Knowledge. Address: 1 Northumberland Avenue, London WC2N 5BW: | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 6 | 2012-11-05-1f359ece-10484-0 |
ee3d22d3540da6140ea18186c29ecddca177e01b | Payment of £200 received for presentations on 25 October 2011 and 8 November 2011. Hours: 2 hrs. (Registered 20 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 7 | 2012-11-05-1f359ece-10484-0 |
b1d41185a440ac8ea9b5842955024a67470f762b | Payment of £100 received on 16 March 2012 for training course on 9 February 2012. Hours: 2 hrs. (Registered 21 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 8 | 2012-11-05-1f359ece-10484-0 |
4f614b85a5b6bac4db65555289f8f1964c888f8f | Payment of £100 received on 21 December 2011 for contribution to BBC Book Talk for BBC Parliament. Address: 4 Millbank, London SW1P 3JA. Hours: 2 hrs. (Registered 5 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 9 | 2012-11-05-1f359ece-10484-0 |
b8753d8f9186932063d5329167268e40c128f579 | Payment of £100 received on 19 March 2012 for lecture on 1 March 2012. Address: Understanding ModernGov, 22 Long Acre, London WC2E 9LY. Hours: 2 hrs. (Registered 21 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 10 | 2012-11-05-1f359ece-10484-0 |
681da50d4229b5ddb9af6c2a16c2eef3c8ceaaf7 | Payments from ComRes, Four Millbank, London SW1P 3JA, for completion of surveys: | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 11 | 2012-11-05-1f359ece-10484-0 |
fe07163921511021357fcb64a0a432e04b2659cf | 5 July 2012, received payment of £75, donated to charity. Hours: 1 hr. (Registered 20 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 12 | 2012-11-05-1f359ece-10484-0 |
1422cb30481328a8f6e8d32bf9766e11d2169768 | 23 August 2012, received payment of £75 for participation in July 2012 survey, donated to charity. Hours: 1 hr. (Registered 28 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 13 | 2012-11-05-1f359ece-10484-0 |
d1025e6c0e276074f3242673856c419ba3247824 | Payment from Leftfield, 51 Clink Street Studios, Clink Street, London SE1 5DG, for completion of surveys: | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 14 | 2012-11-05-1f359ece-10484-0 |
0f8e9e8c7c85d56c05598f53de890c6e7f53e532 | 26 July 2012 received payment of £100, donated to charity. Hours: 1 hr. (Registered 1 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 15 | 2012-11-05-1f359ece-10484-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");