items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where "date" is on date 2010-11-22 and record_id = "2010-11-22-1f359ece-10027-0" sorted by sort_order
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
384684be813c682df9269ad533ff81490e32ac01 | Member of Advisory Board and speaking engagements for Centre for Parliamentary Studies (until October 2010), 14 Great College Street, London SW1P 3RX. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 0 | 2010-11-22-1f359ece-10027-0 |
621df46640cb925e3fdd942261cca350aee6ad47 | Payment of £300 for Advisory Board meeting on 9 June 2010. Hours: 3 hrs. (Registered 28 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 1 | 2010-11-22-1f359ece-10027-0 |
0d86aeea0b9bb63e07a432efacd853e8f687cf44 | Payment of £150 for speech on 4 January 2010. Hours: 1 hr. (Registered 29 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 2 | 2010-11-22-1f359ece-10027-0 |
9eeff447c4754c18e88c2c5fdab8fd209eb53f1c | Payment of £150 for speech on 4 June 2010. Hours: 1 hr. (Registered 29 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 3 | 2010-11-22-1f359ece-10027-0 |
a338d2f016b4fd5b7115c53053c138e00c78a77d | Payment of £150 for speech on 10 June 2010. Hours: 45 min. (Registered 19 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 4 | 2010-11-22-1f359ece-10027-0 |
9ff352474abdc12a0128f82245466f75a7092291 | Fees for completing opinion surveys for ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 5 | 2010-11-22-1f359ece-10027-0 |
f6a79d59c64d78bdfc3027242d26bde3481fe71b | £75 for survey, October 2009. Hours: 25 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 6 | 2010-11-22-1f359ece-10027-0 |
050c59291c65edc6834bef8308cf41eccf030b58 | £75 for survey, November 2009. Hours: 25 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 7 | 2010-11-22-1f359ece-10027-0 |
4a59b84072e9b13e2e90fbfb27436df40cbf3966 | £75 for survey, May 2010. Hours: 30 mins. (Fee paid to charity.) (Registered 20 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 8 | 2010-11-22-1f359ece-10027-0 |
fd3939dcb6d8d4d03a73d1978bc2ea802c8efac2 | £75 for survey, June 2010. Hours: 25 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 9 | 2010-11-22-1f359ece-10027-0 |
7eb997bb825ba5eeda667db6d51fe6b8438852df | £75 for survey, September 2010. Hours: 25 mins. (Fee paid to charity.) (Registered 21 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 10 | 2010-11-22-1f359ece-10027-0 |
e0bf77bb4fdf22a4ca2a85e463d1ec871d050986 | Fees paid to charity for completing opinion surveys for Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT: | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 11 | 2010-11-22-1f359ece-10027-0 |
0b6fb3277068e33d3ff4d0e93251849746ec2a9f | £75 for survey, July 2009. Hours: 14 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 12 | 2010-11-22-1f359ece-10027-0 |
3b1937b42c137bb05fffd51f9d8594ba2baa4c16 | £50 for survey, November 2009. Hours: 20 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 13 | 2010-11-22-1f359ece-10027-0 |
235988f260e986725091843bd9b6f53960c113d5 | Fees for completing opinion surveys for Ipsos Mori, 79-81 Borough Road, London SE1 1FY: | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 14 | 2010-11-22-1f359ece-10027-0 |
b6e68ea7b1b024337fc7f0b7c54c03e421d662ef | £150 for survey, July 2010. Hours: 1 hr. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 15 | 2010-11-22-1f359ece-10027-0 |
651b5e4b6ec3bea26d63c0b574a5a5a66ec16586 | Fees for completing opinion surveys for BPRI, 24-28 Bloomsbury Way, London, WC1A 2PX: | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 16 | 2010-11-22-1f359ece-10027-0 |
be6b58b8de464895cf4378d54283820a8f4fbeb8 | £75 for survey, November 2009. Hours: 40 mins. (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 17 | 2010-11-22-1f359ece-10027-0 |
5aa88dc8ab1b82588a176994324d41578fffe919 | Fee of £300 for speaking engagement for Westminster Experience, Cumberlege Connections, Snells Cottage, Newick, Lewes BN8 4LA, on 15 July 2010. Hours: 1 hr. (Registered 11 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 18 | 2010-11-22-1f359ece-10027-0 |
1f08d21638e69e66b0dacc708d5d565272cf487a | Fee of £500 received 29 October 2010, from Westminster Explained, 21 Dartmouth St | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 19 | 2010-11-22-1f359ece-10027-0 |
19eaf864844c040d68f93c2b4a8ef8f3d17852b5 | London SW1H 9BP, for all day seminar. Fee donated to local charity. (Registered 1 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 20 | 2010-11-22-1f359ece-10027-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");