items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2011-05-16-1f359ece-11759-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 |
---|---|---|---|---|---|---|---|
24f53846a86df29800e36950271ebcb931168fdd | Opinion surveys completed for ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 0 | 2011-05-16-1f359ece-11759-0 |
cdd844203fc64d942f183ae89f98b5268b9ea4af | Payment of £75. Hours: 40 mins. (Registered 12 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 1 | 2011-05-16-1f359ece-11759-0 |
e04fb05f22a719938261bf5109341648cd238cc0 | Payment of £75. Hours: 50 mins. (Registered 28 September 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 2 | 2011-05-16-1f359ece-11759-0 |
94e30ba20e2af525bdbe22d2e9e313dba235eb2a | Payment of £75. Hours: 50 mins. (Registered 28 September 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 3 | 2011-05-16-1f359ece-11759-0 |
41603b80d21be362db8532d99d228443e7d505b2 | Payment of £75. Hours: 45 mins. Fee Donated to charity (Registered 22 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 4 | 2011-05-16-1f359ece-11759-0 |
97682ae44e91199585b0b43fd278c7c01ffac1bc | Payment of £75. Hours: 45 mins. Fee Donated to charity (Registered 22 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 5 | 2011-05-16-1f359ece-11759-0 |
9108ffc8f48ae080279bfaac0f9bb86113d50252 | Payment of £75. Hours: 45 mins. Fee donated to charity. (Registered 28 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 6 | 2011-05-16-1f359ece-11759-0 |
b4aa6c3dd1f537a487e1cd94bddf8b50745b6cd1 | Payment of £75. Hours: 45 mins. Fee donated to charity. (Registered 19 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 7 | 2011-05-16-1f359ece-11759-0 |
ead75a1f46ef172c8d965c026104b1c690961ee6 | Payment of £75 for February/March 2011. Hours: 50 mins. (Registered 10 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 8 | 2011-05-16-1f359ece-11759-0 |
70f6d6c17a4cf6f78b57f99cd0c61f344d22715e | Payment of £75, March 2011. Hours: 45 mins. (Registered 9 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 9 | 2011-05-16-1f359ece-11759-0 |
7b33cfa528219741030a084882c89911bf04d0d0 | Payment of £75, March 2011. Hours: 45 mins. Fee donated to charity. (Registered 15 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 10 | 2011-05-16-1f359ece-11759-0 |
099647f7aa3429b618952e15cd4d47d693081cc5 | Lecturer in British Government and Politics at American International University in London, Queen’s Road Richmond-upon-Thames TW10 6JP. | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 11 | 2011-05-16-1f359ece-11759-0 |
5bf95e5f643b9c9829b060698ff005815ddcbf0b | Received £1050 for work done in June/July 2010. Hours: 14 hours (Registered 12 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 12 | 2011-05-16-1f359ece-11759-0 |
b68ce33f4a4ba971e9163e57d156e4b8a6da4043 | Adjunct Associate Professor in British Government and Politics at the American International University in London, from September 2010 (for two semesters at 90 minutes a week for up to 30 hours per year). Address: Queen’s Road Richmond-upon-Thames TW10 6JP. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 13 | 2011-05-16-1f359ece-11759-0 |
11f58d3b64dbe72b3b5c0e45ccb5d7c62461c430 | Received £1,297.69 for work done in October and November 2010. Hours: 10.5 hrs. (Registered 29 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 14 | 2011-05-16-1f359ece-11759-0 |
d9f3ecef664678e19eafa8ad7eb5f4e47698ceb3 | Received £387.50 for work done in December 2010. Hours: 4.5 hrs. (Registered 15 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 15 | 2011-05-16-1f359ece-11759-0 |
3d13370b375955bfacc99ab62cb037fdcd81e7ae | Received £389 for work done in January 2011. (Registered 1 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 16 | 2011-05-16-1f359ece-11759-0 |
98f49672dca90424ab1174b3ebfae51ecb3d6580 | Received £314.56 for work done in February 2011. (Registered 1 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 17 | 2011-05-16-1f359ece-11759-0 |
7b069e8290289a3fd8df0f7664ad0d9483cc3da7 | Received £454.90 for work done in March 2011. (Registered 15 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 18 | 2011-05-16-1f359ece-11759-0 |
1ca1e12f387ab50b83e1fd104b61d6c30afe5b84 | Ipsos MORI, 79-81 Borough Road, London SE1 1FY. Fee of £150. Hours: 55 mins. (Registered 6 September 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 19 | 2011-05-16-1f359ece-11759-0 |
000c53361639cf7039b3fe409283b920e167796f | Payment of £80 for opinion survey for YouGov, 50 Featherstone Street, London EC1Y 8RT. Hours: 45 mins. (Registered 7 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 20 | 2011-05-16-1f359ece-11759-0 |
79b03f3e9252ebf6f8bb34dfaf0bbfed6a941b40 | Payment of £2,000 from Tribune Business Systems Ltd, for general consultancy and human resources advice, January-March 2011. Address: 30 City Road, London EC1Y 2AY. Hours: 16 hrs. (Registered 9 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 21 | 2011-05-16-1f359ece-11759-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");