items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where record_id = "2012-12-03-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 |
---|---|---|---|---|---|---|---|
ba1d99bd3aad67898498328950b724af0ada9d39 | 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 | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 0 | 2012-12-03-1f359ece-10045-0 |
f80d27a6626de5abb3e74508621e5cde6f6ca40f | 1 March 2011, £75. Hours; 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 1 | 2012-12-03-1f359ece-10045-0 |
de6991f0f68c2165eeaa0bd13464da31c3ebc037 | 14 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 2 | 2012-12-03-1f359ece-10045-0 |
a36d139354a769d73376e9b0943814bac28c1030 | 8 May 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 4 | 2012-12-03-1f359ece-10045-0 |
6afee1e3e47ed10b31f59530722d27061c0c5626 | 19 May 2011, £100. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 5 | 2012-12-03-1f359ece-10045-0 |
3f0f631fd2d16ffcd8497229bfceb9abab8947f8 | 6 June 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 6 | 2012-12-03-1f359ece-10045-0 |
d3ff0710f04dcec3dd192e7538acb4392ba9c104 | 1 July 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 7 | 2012-12-03-1f359ece-10045-0 |
42ec613edd933615309168ef080bbe570c7f3857 | 2 November 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 8 | 2012-12-03-1f359ece-10045-0 |
df5c0c7ee0131f5a69b2d8b0b7cef3b2a7619581 | 2 December 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 9 | 2012-12-03-1f359ece-10045-0 |
e1ae43f1f8926b916c359bdca1508122b18e9d67 | 4 January 2012, £75. Hours: 30 mins. (Registered 2 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 10 | 2012-12-03-1f359ece-10045-0 |
06fd59c49d5165ce76dbb36af6417b7970e4c59b | 13 February 2012, £75. Hours: 30 mins. (Registered 9 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 11 | 2012-12-03-1f359ece-10045-0 |
d58c573b6c86b90b6becb8b95c61997bdf361652 | 11 April 2012, £75. Hours: 30 mins. (Registered 9 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 12 | 2012-12-03-1f359ece-10045-0 |
3ae4866e0fcf2d724d55aafeadd76fb83443b54c | 18 July 2012, £75. Hours: 30 mins. (Registered 9 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 13 | 2012-12-03-1f359ece-10045-0 |
b7db65a893bbffb480e8919a8cd1afc253e78e1b | 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 | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 14 | 2012-12-03-1f359ece-10045-0 |
99cca8b052628070c18941659b646602ba92e0a9 | 18 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 15 | 2012-12-03-1f359ece-10045-0 |
bc0694345113be886dd42ab1408b4380ee318253 | 28 March 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 16 | 2012-12-03-1f359ece-10045-0 |
486df094bd4a7ff6b2b9f5878ba39f01ef9376e0 | 27 September 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 17 | 2012-12-03-1f359ece-10045-0 |
1cc3575bd41aebacb9ac604e34f57458c16b9eb9 | Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing survey: | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 18 | 2012-12-03-1f359ece-10045-0 |
8be2bd0fe3108590c97c414f5858732cc848e926 | 23 July 2012, £70. Hours: 30 mins. (Registered 9 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 19 | 2012-12-03-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");