items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2010-02-03-1f359ece-10082-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 |
---|---|---|---|---|---|---|---|
e6ff97e208770c4ff73c8012b73f8edb43cb9091 | Partner, Butterfill Associates (financial, corporate and real estate consultants). Address: private. | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2010-02-03-1f359ece-10082-0 |
9248fc4932fe595fdaf8e03722a96a94d5cab412 | Payments for completing ComRes Parliamentary Panel Surveys. ComRes address: 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2010-02-03-1f359ece-10082-0 |
20e51c55838143396d298adc60fc14adfe41bd42 | Payment of £50 made to Butterfill Associates. Hours: 15mins. (Registered 21 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 2 | 2010-02-03-1f359ece-10082-0 |
b2598640976c774a03f98a2148f12c0be0dfcc9c | Payment of £75 made to Butterfill Associates. Hours: 20 mins. (Registered 24 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 3 | 2010-02-03-1f359ece-10082-0 |
332ffe4dea7ae5a14fd47cfcc72d0dee4c667fd2 | Payment of £75 made to Butterfill Associates. Hours: 15 mins. (Registered 1 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 4 | 2010-02-03-1f359ece-10082-0 |
7c04ae587914331f216ff0e7bdf69ea83ed6066a | Payment of £75 made to Butterfill Associates. Hours: 15 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 5 | 2010-02-03-1f359ece-10082-0 |
55450d86f273eca47a660434062a12a6e61ace87 | 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-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 6 | 2010-02-03-1f359ece-10082-0 |
ba4d3e0eb8f3249f08d6f4600f6dc577ff38dd66 | Payments for research interviews and surveys for Populus Ltd, Northburgh House, 10 Northburgh Street, London EC1V OAT: | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 7 | 2010-02-03-1f359ece-10082-0 |
3dfaaa1b93c587f15eac07cb85c42aa8dd63133b | Donation of £50 given to charity relating to research interview. Hours: 15 mins. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 8 | 2010-02-03-1f359ece-10082-0 |
af9b59439aad63c3c1feeaa6c3c8c440d65425e2 | Donation of £50 to charity relating to Parliament Panel Survey. Hours: 15 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 9 | 2010-02-03-1f359ece-10082-0 |
3976a6d5dfba8c8feded8eba74e8ebbae4c47a20 | 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-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 10 | 2010-02-03-1f359ece-10082-0 |
b67a442ebde59b09cca1478effdf6a1900afdb51 | 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-02-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 11 | 2010-02-03-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");