items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where "date" is on date 2013-07-08 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 |
---|---|---|---|---|---|---|---|
3f6f1925d504a28a04997b1a689516a3a1b98859 | 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-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 0 | 2013-07-08-1f359ece-11087-0 |
349514949b71d104f8147c76968149e898f0a690 | 24 June 1010, payment of £75 for May 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 1 | 2013-07-08-1f359ece-11087-0 |
6191554757ca92820dc2ace20f1f67225b6970f2 | 30 August 2010, payment of £75 for June 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 2 | 2013-07-08-1f359ece-11087-0 |
aff154fd5c137374bb92f71d39c1e56e0eac5cd9 | 13 October 2010, payment of £75 for September 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 3 | 2013-07-08-1f359ece-11087-0 |
3a4ff929543aafee71c0f0e037780c51db51f682 | 7 January 2011, payment of £75 for November 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 4 | 2013-07-08-1f359ece-11087-0 |
14c9498323371848c471ed70af4c9e40df7b02e0 | 14 February 2011, payment of £75 for January 2011. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 5 | 2013-07-08-1f359ece-11087-0 |
75da2028a8981edf17f57e982f00c2e5279ea6ee | 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-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 6 | 2013-07-08-1f359ece-11087-0 |
fd01fa3bfb8bb613bfee88fc184d7ebb05ec5d65 | 2 June 2011, payment of £75 for May 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 7 | 2013-07-08-1f359ece-11087-0 |
bb0a8119f1bae55bf0b7c964b379f6f037366a19 | 1 July 2011, payment of £75 for June 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 8 | 2013-07-08-1f359ece-11087-0 |
adf8fabcec76498dedd21002f48ce6520658736d | 15 December 2011, payment of £75 for October 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 9 | 2013-07-08-1f359ece-11087-0 |
45c40754c3031ec917011104dd3015b2da0bc03f | 6 January 2012, payment of £75 for November 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 10 | 2013-07-08-1f359ece-11087-0 |
6bf4737803bc45a21c5379e910042184468adec2 | 16 February 2012, payment of £75 for January 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 11 | 2013-07-08-1f359ece-11087-0 |
2c2b906b6554d89395c8bc6b2381b4436ed61404 | 23 April 2012, payment of £75 for February 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 12 | 2013-07-08-1f359ece-11087-0 |
f0316f9dcd7fc0a89a9a15ae0f0b2f08df407877 | 19 July 2012, payment of £75 for May 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 13 | 2013-07-08-1f359ece-11087-0 |
a5f9512a3cdd7ea28ff77bf4f665d8565287f628 | 30 August 2012, payment of £75 for July 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 14 | 2013-07-08-1f359ece-11087-0 |
952d034dd4cfe8235281053e4e376768352512f8 | Payment of £75 for October/November 2012 survey. Hours: 30 mins. (Registered 10 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 15 | 2013-07-08-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");