items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2011-03-28-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 |
---|---|---|---|---|---|---|---|
a88daa32e635d49eb4fcc94687b7b83d4922258f | Fees for surveys from Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT: | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 0 | 2011-03-28-1f359ece-10199-0 |
682cb17aefadaf707810fc25ab8bd15e0a6d9975 | March 2010, £50 for telephone interview. Hours: 15 mins. Payment made to charity. | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 1 | 2011-03-28-1f359ece-10199-0 |
4ffddef557e9eb39da91d6a0e53f1b3aae9cfe97 | June 2010, £50 for questionnaire Hours: 20 mins. Payment made to charity. | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 2 | 2011-03-28-1f359ece-10199-0 |
5a8c628ce386fb11ecdba295598b581088e9030a | July 2010, £50 for telephone interview. Hours; 20 mins. Payment made to charity. | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 3 | 2011-03-28-1f359ece-10199-0 |
098e9223924547c54eda5ad149ed0b2ba8cacb5f | July 2010, £75 for telephone interview. Hours: 30 mins. Payment made to charity. | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 4 | 2011-03-28-1f359ece-10199-0 |
0cd9599c3c35029f5e6fc32673b135779b3f7a99 | (Registered 24 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 5 | 2011-03-28-1f359ece-10199-0 |
5ff9eaada6a9faaa60d04fc3ac9a1ae7dd43ccf5 | 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 | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 6 | 2011-03-28-1f359ece-10199-0 |
61d33add77d30051fb4f676f0994f9e34ea955d0 | Fee for survey from ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 7 | 2011-03-28-1f359ece-10199-0 |
5b6489793f442d8c94b4cd50144bd242bce3a65c | October 2010, £75 for parliamentary panel survey. Hours: 30 mins. Payment made to charity. (Registered 24 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 8 | 2011-03-28-1f359ece-10199-0 |
fa421d2cd8fe15461d89461d3ef3c54df34674c3 | 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 | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 9 | 2011-03-28-1f359ece-10199-0 |
38a0a9862f9af133b8b44810e24642235ece624a | 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 | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 10 | 2011-03-28-1f359ece-10199-0 |
9436d2bcd10fe3c6ea4618463ab9eecf268a1bf9 | 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 | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 11 | 2011-03-28-1f359ece-10199-0 |
c207d7102fabfe656e0519566ca712981fb5e736 | 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 | 2011-03-28 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 12 | 2011-03-28-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");