items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2012-03-19-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 |
---|---|---|---|---|---|---|---|
6af9f699fb367e345ecb75fe920017ec7fb02a66 | Fees for surveys from Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT: | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 0 | 2012-03-19-1f359ece-10199-0 |
9ef0764d6aab1c6839118ed2eae5faa1380643fc | February 2011, £75 for survey. Hours: 30 mins. Payment made to charity. (Registered 30 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 1 | 2012-03-19-1f359ece-10199-0 |
174c47f2ae221027173a08a7ca5b1a1e9931a039 | Fee for survey from ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 2 | 2012-03-19-1f359ece-10199-0 |
8f3c081fdb58024d523a3fffd64ea23420152846 | 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-03-19 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 3 | 2012-03-19-1f359ece-10199-0 |
a811ff58889ce2695a96e9e8cc33a8e2250216ea | 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-03-19 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 4 | 2012-03-19-1f359ece-10199-0 |
38b9164b2fb0950fb93be687270f45f9cdba2d45 | 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-03-19 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 5 | 2012-03-19-1f359ece-10199-0 |
78e2cb7bdfe8edd2753fe0a6bfbb7d5495eb36cc | 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-03-19 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 6 | 2012-03-19-1f359ece-10199-0 |
cfae7bd9cb5d5353c5c297b9a60152e52b029124 | 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-03-19 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 7 | 2012-03-19-1f359ece-10199-0 |
2669dd86486b55690d522d8292096cc05561288d | 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-03-19 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 8 | 2012-03-19-1f359ece-10199-0 |
017e0ae51865a97fac4980824a8a296bd5581c49 | 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-03-19 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 9 | 2012-03-19-1f359ece-10199-0 |
0235a71af2e52bc2d1aa073392b9881cd9f73825 | 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-03-19 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 10 | 2012-03-19-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");