items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where "date" is on date 2012-12-03 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 |
---|---|---|---|---|---|---|---|
7ceadff5ffd9b5358d815e414e060afc2b0d92bd | 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-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 0 | 2012-12-03-1f359ece-10484-0 |
6818a1f4d2cce41aec69e69a53ab06035d47a2c6 | 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-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 1 | 2012-12-03-1f359ece-10484-0 |
77c1f489759ecfb2a158f714ed83f80670ad8ee3 | 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-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 2 | 2012-12-03-1f359ece-10484-0 |
5566a4ca0e4a9af9a9fe71247cb9748e2c8cd4f4 | 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-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 3 | 2012-12-03-1f359ece-10484-0 |
689af4dba668d273070cbf9d0d18d28d05513347 | 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-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 4 | 2012-12-03-1f359ece-10484-0 |
e76a0dc5be8e71e52eee5d3cf54ac81c46abd36b | 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-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 5 | 2012-12-03-1f359ece-10484-0 |
7b841c6d4df5820c79d633ef51f0a0e8dd52f942 | Payments from Government Knowledge. Address: 1 Northumberland Avenue, London WC2N 5BW: | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 6 | 2012-12-03-1f359ece-10484-0 |
8d809fa14c8aec61a7ce57419916ddf65aebfd97 | 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-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 7 | 2012-12-03-1f359ece-10484-0 |
c04aba36e4f2769fc7d094139d1f0c2c2074f5e6 | 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-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 8 | 2012-12-03-1f359ece-10484-0 |
fc547a9825b1e8888b838a7eee7b3d7bda5bdef7 | 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-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 9 | 2012-12-03-1f359ece-10484-0 |
7193a22e65569f4d95ad91a6b6720cb7110a2302 | 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-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 10 | 2012-12-03-1f359ece-10484-0 |
1beaed922dad8b959deb0e02226d887552dfcb79 | Payments from ComRes, Four Millbank, London SW1P 3JA, for completion of surveys: | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 11 | 2012-12-03-1f359ece-10484-0 |
ff74bcc5e3fdd59f8f5c86cb3ec95b8879ecc041 | 5 July 2012, received payment of £75, donated to charity. Hours: 1 hr. (Registered 20 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 12 | 2012-12-03-1f359ece-10484-0 |
b5e799f403b43f0ef3c0f48b171815cc64e644fa | 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-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 13 | 2012-12-03-1f359ece-10484-0 |
abc41ed6a2719e3238dd6c57f48fd6c0f45771ba | Payment from Leftfield, 51 Clink Street Studios, Clink Street, London SE1 5DG, for completion of surveys: | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 14 | 2012-12-03-1f359ece-10484-0 |
1d36ee385a09d29ab2d53529eefdd615b3301eb0 | 26 July 2012 received payment of £100, donated to charity. Hours: 1 hr. (Registered 1 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 15 | 2012-12-03-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");