items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where "date" is on date 2013-09-09 and person_id = "uk.org.publicwhip/person/11087" sorted by sort_order
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
e39601fe9a9e6a608d572ffb7699151bb957a917 | Payments from ComRes, Four Millbank, London SW1P 3JA, for taking part in parliamentary panel surveys. Payments donated to charity: | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 0 | 2013-09-09-1f359ece-11087-0 |
f7b1962d8851264efec634217e0fcb96e28e7fdf | 24 June 1010, payment of £75 for May 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 1 | 2013-09-09-1f359ece-11087-0 |
f271979d1cbfdf9cc35994a1fbab2c2b92d08241 | 30 August 2010, payment of £75 for June 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 2 | 2013-09-09-1f359ece-11087-0 |
3e20e1d5aac020035ba1a9c33cc420b75f8b2270 | 13 October 2010, payment of £75 for September 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 3 | 2013-09-09-1f359ece-11087-0 |
4ede311f47c4171b3d786d4323551d5bc9ea9f18 | 7 January 2011, payment of £75 for November 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 4 | 2013-09-09-1f359ece-11087-0 |
14417e6a47dfe583df05ff2d5806c65082c5d81a | 14 February 2011, payment of £75 for January 2011. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 5 | 2013-09-09-1f359ece-11087-0 |
8a1ecc15123d93ab0cdde15a74641221fb47d84d | 28 April 2011, payment of £75 for March-April 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 6 | 2013-09-09-1f359ece-11087-0 |
4a0c54d56f755388a39b58120362a7019f902d50 | 2 June 2011, payment of £75 for May 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 7 | 2013-09-09-1f359ece-11087-0 |
2821e32fbaffc93ea1f5fcc2ea919604ec2830f5 | 1 July 2011, payment of £75 for June 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 8 | 2013-09-09-1f359ece-11087-0 |
e3b974f2d982ee245c5cdfc2edef147308a7c014 | 15 December 2011, payment of £75 for October 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 9 | 2013-09-09-1f359ece-11087-0 |
e0293673becebd731be99d28fc8f14c3325d819d | 6 January 2012, payment of £75 for November 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 10 | 2013-09-09-1f359ece-11087-0 |
0d2ac789b41ca139109fa2cbf72560b5d5c7c512 | 16 February 2012, payment of £75 for January 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 11 | 2013-09-09-1f359ece-11087-0 |
f92793e40bcee8cf2c3941728296567400ab767e | 23 April 2012, payment of £75 for February 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 12 | 2013-09-09-1f359ece-11087-0 |
641153457323f043fcf04663a2f03ab7f1fcaf3c | 19 July 2012, payment of £75 for May 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 13 | 2013-09-09-1f359ece-11087-0 |
96ec2bf03a0f7323cd59a36dfaf375186b8e1e63 | 30 August 2012, payment of £75 for July 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 14 | 2013-09-09-1f359ece-11087-0 |
1930bd66463255f8bb6d40f66c9cdd3b49a70dfe | Payment of £75 for October/November 2012 survey. Hours: 30 mins. (Registered 10 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 15 | 2013-09-09-1f359ece-11087-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");