items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where "date" is on date 2012-12-19 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 |
---|---|---|---|---|---|---|---|
b227edd6b8aad90cc223d78ff3a32ef59b9de892 | 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 | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 0 | 2012-12-19-1f359ece-11087-0 |
fbb7d30836d4851508ffbf08f2c825cdc5e029ab | 24 June 1010, payment of £75 for May 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 1 | 2012-12-19-1f359ece-11087-0 |
19dd2adbdc711b5aef1f4ffb01bb4033a81ba0b1 | 30 August 2010, payment of £75 for June 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 2 | 2012-12-19-1f359ece-11087-0 |
5c6cf0737f78975ae935714d11e766f90cc1fcea | 13 October 2010, payment of £75 for September 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 3 | 2012-12-19-1f359ece-11087-0 |
0ccb7b933b7effb668fe682ab455d7537273794b | 7 January 2011, payment of £75 for November 2010 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 4 | 2012-12-19-1f359ece-11087-0 |
19bc711f227cc5daea491ffcbeb774123a0a4e93 | 14 February 2011, payment of £75 for January 2011. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 5 | 2012-12-19-1f359ece-11087-0 |
83b4998368734e05a0da36e0b779a7816aee1120 | 28 April 2011, payment of £75 for March-April 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 6 | 2012-12-19-1f359ece-11087-0 |
26c824087057427c99ddd70557e2e7b27123761b | 2 June 2011, payment of £75 for May 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 7 | 2012-12-19-1f359ece-11087-0 |
3796bae8dfe72e89bd5358534b7b95b86d4812fb | 1 July 2011, payment of £75 for June 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 8 | 2012-12-19-1f359ece-11087-0 |
ec8954cbc8ab7edb5f97a95424104da4e2900e67 | 15 December 2011, payment of £75 for October 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 9 | 2012-12-19-1f359ece-11087-0 |
99aaa3b78fd42224cd31cf290ad39aef1b3c8e08 | 6 January 2012, payment of £75 for November 2011 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 10 | 2012-12-19-1f359ece-11087-0 |
588d15313a06529a68659a1054938a8de7990b8a | 16 February 2012, payment of £75 for January 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 11 | 2012-12-19-1f359ece-11087-0 |
975b0b1bdfdfaa5ca6ba4e7b69cbea3a70a4ed37 | 23 April 2012, payment of £75 for February 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 12 | 2012-12-19-1f359ece-11087-0 |
9b9138721922decfbf3388d9a6b6c80e2ca9b08a | 19 July 2012, payment of £75 for May 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 13 | 2012-12-19-1f359ece-11087-0 |
a948dce38caadf0399cfe62f130b22665ece3598 | 30 August 2012, payment of £75 for July 2012 survey. Hours: 30 mins. (Registered 19 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 14 | 2012-12-19-1f359ece-11087-0 |
dc9a24b6b3471dcc941f4982e04a9b1823cc7686 | Payment of £75 for October/November 2012 survey. Hours: 30 mins. (Registered 10 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Khalid Mahmood uk.org.publicwhip/member/40086 | Khalid Mahmood uk.org.publicwhip/person/11087 | 15 | 2012-12-19-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");