items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where "date" is on date 2012-11-19 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 |
---|---|---|---|---|---|---|---|
418d390ad59087e4035d7c186a0ae32f9c7f3518 | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 0 | 2012-11-19-1f359ece-10484-0 |
ce75dc290dd1a58f5bfcbb47aa437eead858e813 | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 1 | 2012-11-19-1f359ece-10484-0 |
7c202dce38713a8130fee0346752fec03b2d9120 | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 2 | 2012-11-19-1f359ece-10484-0 |
ddb4f0fbd7493572c917659fdd4d840614d5290e | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 3 | 2012-11-19-1f359ece-10484-0 |
d934a9b523743830064ede1aeb14d0cd3aa641af | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 4 | 2012-11-19-1f359ece-10484-0 |
a6fd48ff5c039b3a10a3ceb805e4fdbd4ea38650 | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 5 | 2012-11-19-1f359ece-10484-0 |
0ce158a7887410c3bfcae15f06bb2b17de8a6d58 | Payments from Government Knowledge. Address: 1 Northumberland Avenue, London WC2N 5BW: | Remunerated employment, office, profession etc 1f359ece | 2012-11-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 6 | 2012-11-19-1f359ece-10484-0 |
810e5e6dfbf0d13c2ddc2cbe158a54a213b9d79a | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 7 | 2012-11-19-1f359ece-10484-0 |
d3c9dd47d06cd0c3775f25a1e853f421f070f094 | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 8 | 2012-11-19-1f359ece-10484-0 |
82bd3b7d518c4bcace0d8b7e5d2b3070031277fe | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 9 | 2012-11-19-1f359ece-10484-0 |
523ccb2d76a827f4f897681d554a418c1dc1da05 | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 10 | 2012-11-19-1f359ece-10484-0 |
2ef21a1124b921c2495d051de3f7ff9245d0b368 | Payments from ComRes, Four Millbank, London SW1P 3JA, for completion of surveys: | Remunerated employment, office, profession etc 1f359ece | 2012-11-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 11 | 2012-11-19-1f359ece-10484-0 |
a951ee41aaa77353ea0116d91fd7213b4c98f3e6 | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 12 | 2012-11-19-1f359ece-10484-0 |
4befc44fd2bbe0ed9bdda081335668a657f84753 | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 13 | 2012-11-19-1f359ece-10484-0 |
99cca1117fae420e373bd8749cd183c691e5435f | Payment from Leftfield, 51 Clink Street Studios, Clink Street, London SE1 5DG, for completion of surveys: | Remunerated employment, office, profession etc 1f359ece | 2012-11-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 14 | 2012-11-19-1f359ece-10484-0 |
997f8d425b27e4246b4cb736875e286a7e477950 | 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-19 | Stephen Pound uk.org.publicwhip/member/40220 | Steve Pound uk.org.publicwhip/person/10484 | 15 | 2012-11-19-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");