items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where record_id = "2012-01-13-1f359ece-10199-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
9bbea69205142f4697b95939e91b0e72bc7cc78e | Fees for surveys from Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT: | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 0 | 2012-01-13-1f359ece-10199-0 |
2c44a52894d9274d1ea5b83be77dc56f4f75c1a9 | March 2010, £50 for telephone interview. Hours: 15 mins. Payment made to charity. | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 1 | 2012-01-13-1f359ece-10199-0 |
9dc62a95b7e58356a2f85f34bc1658e9c1f1cf4c | June 2010, £50 for questionnaire Hours: 20 mins. Payment made to charity. | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 2 | 2012-01-13-1f359ece-10199-0 |
dbd5b29e81ecdbe8eb78a0804b1080c83a8886ff | July 2010, £50 for telephone interview. Hours; 20 mins. Payment made to charity. | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 3 | 2012-01-13-1f359ece-10199-0 |
e224e0061c05e97fc812a0c2f302c12b2ac0e4b5 | July 2010, £75 for telephone interview. Hours: 30 mins. Payment made to charity. | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 4 | 2012-01-13-1f359ece-10199-0 |
c34c507d216507c764931b36b099abd1f47ae4cb | (Registered 24 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 5 | 2012-01-13-1f359ece-10199-0 |
b75411553afdf82bce302de08b940a558c8f67a3 | November 2010, £50 for participation in research project. Hours: 15 mins. Payment made to charity. (Registered 22 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 6 | 2012-01-13-1f359ece-10199-0 |
554efa2330c3c70483d7c6ef5003d5cc1c904e9d | February 2011, £75 for survey. Hours: 30 mins. Payment made to charity. (Registered 30 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 7 | 2012-01-13-1f359ece-10199-0 |
4b9c783ba9b0352122e8523001116887ccc67e59 | Fee for survey from ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 8 | 2012-01-13-1f359ece-10199-0 |
9e1b8ac4a2fc0b022c59720db5ab927057f03932 | October 2010, £75 for parliamentary panel survey. Hours: 30 mins. Payment made to charity. (Registered 24 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 9 | 2012-01-13-1f359ece-10199-0 |
54f3f79d81c04f75daecda8cfa1f4c7c5b1dd81d | November 2010, £75 for parliamentary panel survey. Hours: 30 mins. Payment made to local organisation. (Registered 17 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 10 | 2012-01-13-1f359ece-10199-0 |
1aac363bf50299049778211a5c877f96d19ec1bf | January 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment made to local organisation. (Registered 24 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 11 | 2012-01-13-1f359ece-10199-0 |
c33d3e294004efea665b64546074e293662975c6 | February-March 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment made to local organisation. (Registered 22 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 12 | 2012-01-13-1f359ece-10199-0 |
07c167f2b3fe870569dfe3136563b50f8b6bcacd | March-April 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 9 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 13 | 2012-01-13-1f359ece-10199-0 |
c93e1bfd9be02f4c76431350a27b13748f7a4d4d | May 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 22 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 14 | 2012-01-13-1f359ece-10199-0 |
d5b3dbd62f2e6c4e8340447bc99001de03e89fe5 | June 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 22 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 15 | 2012-01-13-1f359ece-10199-0 |
62ef3efea5d6d7c2401da1b84ba91dd4095112ad | July 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 22 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 16 | 2012-01-13-1f359ece-10199-0 |
de5778410f96dde1fdd5f45d53cdedfc15d3d3f6 | October-November 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 14 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 17 | 2012-01-13-1f359ece-10199-0 |
78320250892686b1b74463ddccc816d6c4f33569 | January 2011, fee of £80 for online survey from YouGov, 50 Featherstone Street, London EC1Y 8RT. Hours: 25 mins. Payment donated to charity. (Registered 9 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 18 | 2012-01-13-1f359ece-10199-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");