items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2012-02-20-1f359ece-10199-0" sorted by member_id
This data as json, CSV (advanced)
date (date) 1 ✖
- 2012-02-20 12
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
cbe66402903ec92ea6f89a8181566d7b264c8471 | Fees for surveys from Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT: | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 0 | 2012-02-20-1f359ece-10199-0 |
6059e6b891931459a834f78fec21eb247805536d | February 2011, £75 for survey. Hours: 30 mins. Payment made to charity. (Registered 30 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 1 | 2012-02-20-1f359ece-10199-0 |
5ef34756e40a4db044443e051deb9314a41f17f3 | Fee for survey from ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 2 | 2012-02-20-1f359ece-10199-0 |
ab0d5a29326334ccb2dcf344794b8c662b553d4f | 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-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 3 | 2012-02-20-1f359ece-10199-0 |
464d37865c6d17a05b76827f25fb1ef39b3eded0 | 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-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 4 | 2012-02-20-1f359ece-10199-0 |
5a59985be3ff34df24facd662e1dba9b70517fc3 | 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-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 5 | 2012-02-20-1f359ece-10199-0 |
d5065a65aac9b34bddbce8e1923948c5f1b31a46 | 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-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 6 | 2012-02-20-1f359ece-10199-0 |
4170531daa6a2173890a93ad78793722bad628dd | 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-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 7 | 2012-02-20-1f359ece-10199-0 |
e1205c5c10713e8e9273ed2b3a2818f4a5e83847 | 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-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 8 | 2012-02-20-1f359ece-10199-0 |
0888431ecff84858dd348f614311418fe3c85bc9 | 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-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 9 | 2012-02-20-1f359ece-10199-0 |
ce9555ab16f535dae4edb90f45a331d210e1ab42 | November-December 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 18 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 10 | 2012-02-20-1f359ece-10199-0 |
dfd713fdea7ff1b747d886da827f3a7295a8e527 | January 2012, fee of £150 for face-to-face survey from Ipsos Mori, 79-81 Borough Road, London SE1 1FY. Hours: 75 mins. Payment donated to charity. (Registered 1 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 11 | 2012-02-20-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");