items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2011-05-03-1f359ece-10202-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 |
---|---|---|---|---|---|---|---|
9a1b51a5b9ad31185d525b31aedb0f69c874d298 | Parliamentary Panel survey questionnaires completed for ComRes, 4 Millbank, London SW1P 3JA. | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 0 | 2011-05-03-1f359ece-10202-0 |
99fb96344dbe5d9cfc5dcc5bc5d3343af63f97d7 | Payment of £75 for completing December 2009 survey questionnaire. 1 hour. Payment made directly to Don Valley Labour Party. (Registered 10 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 1 | 2011-05-03-1f359ece-10202-0 |
ac031841e212a60c95961bddc8f9426e3d8bf3c8 | Payment of £75for completing September 2010 survey. 1 hour. Payment made directly to Don Valley Labour Party on 13 October 2010. (Registered 27 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 2 | 2011-05-03-1f359ece-10202-0 |
37f31fa8caa6b2975872ca35aeaae10d396409ca | Payment of £75 for completing November 2010 survey. Hours: 1 hr. Payment made directly to Don Valley Labour Party in December 2010. (Registered 26 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 3 | 2011-05-03-1f359ece-10202-0 |
3df1ab2acc0b80c9cfc4cf2f53a3225d52643390 | Appearances on Sky. Address: BSkyB Broadcasting, Great Way, Isleworth, Middlesex TW7 5QD. | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 4 | 2011-05-03-1f359ece-10202-0 |
3eb8e4ce003b29b06e44b1d10936d22805f442a1 | Payment of £100 for appearance on Sky, Adam Boulton Live (8 August 2010), 3 hours. Payment donated to Don Valley Labour Party in October 2010. (Registered 27 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 5 | 2011-05-03-1f359ece-10202-0 |
c8e48773a452e0829b24cda1f3c6e2daae0b105b | Appearances on BBC. Address: BBC Television Centre, Wood Lane, London W12 7RJ. Payments donated to Don Valley Labour Party. | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 6 | 2011-05-03-1f359ece-10202-0 |
8a313475a6f85890f1f0d5cf1ad95cf23fb3ae5b | Payment of £110 for appearance on BBC Andrew Marr Show (16 August 2009), 3 hours. Payment received November 2009. | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 7 | 2011-05-03-1f359ece-10202-0 |
000935f71ff22c92a31cfd92029231691e59b3a4 | Payment of £500 for appearance as presenter on BBC One’s This Week. 8 hours. (Registered 10 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 9 | 2011-05-03-1f359ece-10202-0 |
95f06a52f8b98148c72d2df50a20ec184cfd7b0c | Payment of £500 for appearance as presenter on BBC One’s This Week. 4 hours. (Registered 21 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 10 | 2011-05-03-1f359ece-10202-0 |
514208f68e829073e28b7c12b340dac026244952 | House Magazine, 3rd Floor Westminster Tower, Albert Embankments, London. 3 hours. Payments made directly to Don Valley Labour Party. | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 11 | 2011-05-03-1f359ece-10202-0 |
7a0b741f247a168a16f0adf2c876646a602c521b | £150 f or speaking engagement on 30 September. 3 Hours. (Registered 13 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 12 | 2011-05-03-1f359ece-10202-0 |
4eda441321c6b04b49194cbfb31ff2a86f264c67 | £150 f or speaking engagement on 3 March. 3 Hours. (Registered 10 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 13 | 2011-05-03-1f359ece-10202-0 |
41b12f93abd73bd3d30707bc643c003af69882ad | Payment of £300 received on 8 September 2010 for article in The Times newspaper published 6 August 2010. Address: 3 Thomas Moore Square, London E98 1TY. Hours: 6 hrs. (Registered 27 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 14 | 2011-05-03-1f359ece-10202-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");