items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2011-10-31-1f359ece-10045-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
456a302c42fdd77e884164197f1ca81e764bb2a8 | Payments from ComRes, Four Millbank, London SW1P 3JA, for completing surveys. All payments are donated directly to my constituency party: | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 0 | 2011-10-31-1f359ece-10045-0 |
940c49880949f977a5de704a9a92a948f4a7678f | £75 for May 2010 survey. Hours: 30 mins. | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 1 | 2011-10-31-1f359ece-10045-0 |
a1d80a45ef0146fa63f5a3d4f5dac21c9879adc5 | £75 for September 2010 survey. Hours 30 mins. | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 2 | 2011-10-31-1f359ece-10045-0 |
83a93227fa68c360f1308a27d955c3c7c9246900 | £75 for October 2010 survey. Hours: 30 mins. | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 3 | 2011-10-31-1f359ece-10045-0 |
b7ddbae683a99f0a1837ce1bbb7523b2db349350 | £75 for November 2010 survey. Hours: 30 mins. | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 4 | 2011-10-31-1f359ece-10045-0 |
3f9c5968cc2e2120dd9188977ba01737267db713 | £75 for January 2011 survey. Hours: 30 mins. | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 5 | 2011-10-31-1f359ece-10045-0 |
937a398e018b5a544ca9e354d2b6f070517f84c9 | Payments from Populus Ltd, 10 Northburgh Street, London EC1V 0AT, for completing surveys. All payments are donated directly to my constituency party: | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 7 | 2011-10-31-1f359ece-10045-0 |
8792ed29a2904ab9df0e75ba0e83a768b5866468 | £50 for May 2010 survey. Hours: 15 mins. | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 8 | 2011-10-31-1f359ece-10045-0 |
a8f50ee370303d7b6d96c61662f7120f8624efb1 | £50 for September 2010 survey. Hours: 15 mins | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 9 | 2011-10-31-1f359ece-10045-0 |
28f692f1b05645f925acc6e0fc011e3ce0c1713a | £50 for December 2010 survey. Hours: 15 mins. | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 10 | 2011-10-31-1f359ece-10045-0 |
e6bed8b041fadcf5de88ea9a9d60e25e4a358d95 | (Registered 16 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 11 | 2011-10-31-1f359ece-10045-0 |
7cca03333559adfcef615abfc57e74a5770bd43b | Payment of £75 from BPRI, 24-28 Bloomsbury Way, London, WC1A 2PX, for completing a survey in May 2010. Hours: 25 mins. Payment donated directly to my constituency party. (Registered 16 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 12 | 2011-10-31-1f359ece-10045-0 |
45b90b0ad2e39ab40bf8cbd4e8437b015dd1f349 | Payment of £150 from Ipsos MORI, 79-81 Borough Road, London SE1 1FY, for completing a survey in August 2010. Hours: 50 mins. Payment donated directly to my constituency party. (Registered 16 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 13 | 2011-10-31-1f359ece-10045-0 |
a90e9b5a5346201d13885c0f6a2fce382436e0f1 | Paymentof £80 from YouGov, 50 Featherstone St, London EC1Y 8RT, for completing a survey in February 2011. Payment donated to my constituency party. 9registered 16 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 14 | 2011-10-31-1f359ece-10045-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");