items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2012-02-20-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 |
---|---|---|---|---|---|---|---|
e31dc4af51b410389b90e5176e377d159e4d7ac6 | Opinion surveys completed for ComRes, 4 Millbank, London, SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 0 | 2012-02-20-1f359ece-11759-0 |
79bb52383e8f304dcebb37f3053f7ffc73392fc7 | Payment of £75 for February/March 2011. Hours: 50 mins. (Registered 10 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 1 | 2012-02-20-1f359ece-11759-0 |
21780972dd50736f198ba59a022ed08c464a457e | Payment of £75, March 2011. Hours: 45 mins. (Registered 9 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 2 | 2012-02-20-1f359ece-11759-0 |
41c1cbc035ba566a307492434689ae79efb9dff3 | Payment of £75, March 2011. Hours: 45 mins. Fee donated to charity. (Registered 15 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 3 | 2012-02-20-1f359ece-11759-0 |
a2f395946df3f5258bba30038b6630443fbe32f9 | Payment of £75, May 2011. Hours: 45 mins. (Registered 22 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 4 | 2012-02-20-1f359ece-11759-0 |
eb77708c23b56c1a38c94734735af70610682682 | Payment of £75, June 2011. Hours: 45 mins. (Registered 12 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 5 | 2012-02-20-1f359ece-11759-0 |
6fb709719682d4f67bfcfc315c6533409c9349ee | Payment of £75, July 2011. Hours: 45 mins. Fee donated to charity. (Registered 12 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 6 | 2012-02-20-1f359ece-11759-0 |
3b8144ea9cbb53fecdafad753f36b5f63b96c87a | Payment of £75, November 2011. Hours: 45 mins. (Registered 5 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 7 | 2012-02-20-1f359ece-11759-0 |
36657027723601952958882b54f3ee3549cc380e | Payment of £75, December 2011. Hours: 45 mins. (Registered 9 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 8 | 2012-02-20-1f359ece-11759-0 |
1c1b5fccaabe0876f692a066808c0ad7fdd27d78 | 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 | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 9 | 2012-02-20-1f359ece-11759-0 |
df7500917438873fffab5b20e2e9d42ba71c5f3a | 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 | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 10 | 2012-02-20-1f359ece-11759-0 |
675dac5d5ba8bf8a5ccbab5f8e1bf442413b8766 | Received £389 for work done in January 2011. (Registered 1 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 11 | 2012-02-20-1f359ece-11759-0 |
51978efb6d17f8085b34f9b97243a01ce5978971 | Received £314.56 for work done in February 2011. (Registered 1 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 12 | 2012-02-20-1f359ece-11759-0 |
9a3f288e217fa346558b3aef6206ad5dadb1b8b8 | Received £454.90 for work done in March 2011. (Registered 15 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 13 | 2012-02-20-1f359ece-11759-0 |
f0625cbddc0536ace59bd6e8b87e0db6c2e1c426 | 21 April 2011, received fee of £454.90. Hours: 8 hrs. (Registered 13 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 14 | 2012-02-20-1f359ece-11759-0 |
5e2cf963cdf6dbe13848f188a5d754de18da3411 | 25 May 2011, received fee of £454.90. Hours: 8 hrs. (Registered 13 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 15 | 2012-02-20-1f359ece-11759-0 |
fe7504263ce737dcd51d36e8381167adb38713f9 | Received £1,060 for work done in July/August 2011, lecturing at Summer School. Hours: 15 hrs. (Registered 9 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 16 | 2012-02-20-1f359ece-11759-0 |
0002c3005188bb0c16fa570850b63e84fd6e4332 | 25 October 2011, received £410.64 for work done in September/October 2011. Hours: 12 hrs. (Registered 14 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 17 | 2012-02-20-1f359ece-11759-0 |
6e9bdaa6616d9bb5f7fbf53e2ba2424d139c60d2 | 25 November 2011, received £410.64 for work done in September/October 2011. Hours: 12 hrs. (Registered 23 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 18 | 2012-02-20-1f359ece-11759-0 |
2dfa222c49fa72dbb47066ba8f47bb1b95a8d04c | 16 December 2011, received £410.64 for work done in November/December 2011. Hours: 12 hrs. (Registered 23 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 19 | 2012-02-20-1f359ece-11759-0 |
7986c3380fe542b9d356fff9f0022694f3a45adc | Opinion surveys completed for Ipsos MORI, 79-81 Borough Road, London SE1 1FY. | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 20 | 2012-02-20-1f359ece-11759-0 |
c6fa1131b3815a1860781fa2e6bd5757c03dce67 | Fee of £150. Hours: 65 mins. (Registered 20 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 21 | 2012-02-20-1f359ece-11759-0 |
9b59e7a04dbcb84a66574f5ce03b66a316b15fb2 | Fee of £150. Hours: 65 mins. (Registered 31 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 22 | 2012-02-20-1f359ece-11759-0 |
e96823b469c08691316192073fb4f2903d21565a | Payments from Tribune Business Systems Ltd, for general consultancy and human resources advice. Address: 30 City Road, London EC1Y 2AY: | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 23 | 2012-02-20-1f359ece-11759-0 |
82730af36ee3dd83e799ab4c3aaba0d3a5e77ff6 | Payment of £2,000, January-March 2011. Hours: 16 hrs. (Registered 9 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 24 | 2012-02-20-1f359ece-11759-0 |
447346e1313ca28415e149e40ac41c17a0fd1798 | Payment of £3,750, April-June 2011. Hours: 36 hrs. (Registered 1 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 25 | 2012-02-20-1f359ece-11759-0 |
c88a0ed254034297098f59fc863030f8205cc03f | Payment of £3,750, August-October 2011. Hours: 20 hrs. (Registered 14 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 26 | 2012-02-20-1f359ece-11759-0 |
7b7ac6b94466c94b496bd468e437744bd4e95cf6 | Payment of £500 for role as keynote speaker at conference on 29 June 2011. Address of payer: Christian Concern, 70 Wimpole Street, London W1G 8AX. Hours: 1 hr. (Registered 12 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Stewart Jackson uk.org.publicwhip/member/40479 | Stewart Jackson uk.org.publicwhip/person/11759 | 27 | 2012-02-20-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");