items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2010-04-12-1f359ece-10082-0" sorted by category_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
9bc7be32e474f1d28f04d514dc4cb295977f19d9 | Partner, Butterfill Associates (financial, corporate and real estate consultants). Address: private. | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2010-04-12-1f359ece-10082-0 |
8a4cc4367bedfde0288fbb1afe00a2c19d8fa2cb | Payments for completing ComRes Parliamentary Panel Surveys. ComRes address: 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2010-04-12-1f359ece-10082-0 |
e604f37ded60f01a104d30786d07fe3e5473e709 | Payment of £50 made to Butterfill Associates. Hours: 15mins. (Registered 21 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 2 | 2010-04-12-1f359ece-10082-0 |
7722b468b5437590fc1bf0d90315c18902ffbe75 | Payment of £75 made to Butterfill Associates. Hours: 20 mins. (Registered 24 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 3 | 2010-04-12-1f359ece-10082-0 |
c1d717546c8ceac33b60639369f7f3ca9c62c7f9 | Payment of £75 made to Butterfill Associates. Hours: 15 mins. (Registered 1 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 4 | 2010-04-12-1f359ece-10082-0 |
9e36d20f6ddb92b8fd69180551f5964bf5cf5bb9 | Payment of £75 made to Butterfill Associates. Hours: 15 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 5 | 2010-04-12-1f359ece-10082-0 |
d2344fbbd016ad56f6aa587e7bb79b5c7e1ae206 | Payment of £75 made to Butterfill Associates. Hours: 20 mins. (Registered 9 April 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 6 | 2010-04-12-1f359ece-10082-0 |
69b27e5093fde30264d37c82e04308197d6d905b | Research interview with Opinion Leader Research. Donation of £30 given to charity. Hours: 10 mins. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 7 | 2010-04-12-1f359ece-10082-0 |
ce566c73d646a0bf897adc807f14d6216c1b0425 | Payments for research interviews and surveys for Populus Ltd, Northburgh House, 10 Northburgh Street, London EC1V OAT: | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 8 | 2010-04-12-1f359ece-10082-0 |
d050f599a9377b43912379b051cfcf8211fe7dbe | Donation of £50 given to charity relating to research interview. Hours: 15 mins. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 9 | 2010-04-12-1f359ece-10082-0 |
1c5853d273e804d88a901a01b92f4d9bac74fbef | Donation of £50 to charity relating to Parliament Panel Survey. Hours: 15 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 10 | 2010-04-12-1f359ece-10082-0 |
7f9d3113836880bddbf764ecbe83542cee6112c7 | Research interview with BPRI Political Opinion Panel. Payment of £75 made to Butterfill Associates. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 11 | 2010-04-12-1f359ece-10082-0 |
3e5184b2f9db1a7dc7f9462693260eac2bd31c20 | Survey completed for Opinion Research International, Angel Corner House, 1 Islington High St., London, N1 9AH. Payment of £150 made to Butterfill Associates. Hours: 1 hr. (Registered 10 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 12 | 2010-04-12-1f359ece-10082-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");