items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
113 rows where member_id = "uk.org.publicwhip/member/40619" sorted by date descending
This data as json, CSV (advanced)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
edb1360ca107d51dd364441c509d6b9a96a7931f | 9 January 2012, received payment of £75 from ComRes, Four Millbank, London SW1P, for participation in opinion research, November - December 2011. Hours: 15 mins. (Registered 19 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 2 | 2012-01-30-1f359ece-10086-0 |
adf50a583cd34b83f2dbc0eef3b951a1ac679717 | Payment of £75 from Populus received on 18 March 2011, 10 Northburgh Street, London EC1V 0AT, for participation in opinion research, February 2011. Hours: 15 mins. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2012-01-13-1f359ece-10086-0 |
c466eced3df7a83117566f2a710366a46c659583 | 29 November 2011, received payment of £75 from ComRes, Four Millbank,,London SW1P, for participation in opinion research, October-November 2011. Hours: 15 mins. (Registered 20 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 1 | 2012-01-13-1f359ece-10086-0 |
89bf836ef4c38a321c1d0ad5b632e9f9a84b1eef | Payment of £75 from Populus received on 18 March 2011, 10 Northburgh Street, London EC1V 0AT, for participation in opinion research, February 2011. Hours: 15 mins. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2011-12-13-1f359ece-10086-0 |
dcabd2b09772919ea86cf23b6f1ced598769cfa8 | Payment of £75 from Populus received on 18 March 2011, 10 Northburgh Street, London EC1V 0AT, for participation in opinion research, February 2011. Hours: 15 mins. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-11-29 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2011-11-29-1f359ece-10086-0 |
d19d9c547416f2580092039e5cc2e2820eeab412 | Payment of £75 from Populus received on 18 March 2011, 10 Northburgh Street, London EC1V 0AT, for participation in opinion research, February 2011. Hours: 15 mins. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-11-16 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2011-11-16-1f359ece-10086-0 |
b38b043714c7f08548a3ec73c808c3eb48bdf1be | Payment of £75 from Populus received on 18 March 2011, 10 Northburgh Street, London EC1V 0AT, for participation in opinion research, February 2011. Hours: 15 mins. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2011-10-31-1f359ece-10086-0 |
bc9a1ea2edab51aab3f6de5719a3d9da15c1a021 | Payment of £75 from Populus received on 18 March 2011, 10 Northburgh Street, London EC1V 0AT, for participation in opinion research, February 2011. Hours: 15 mins. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2011-10-17-1f359ece-10086-0 |
8784f5c7be9cf937f402d840e4e0907da11e1df8 | Payment of £75 from Populus received on 18 March 2011, 10 Northburgh Street, London EC1V 0AT, for participation in opinion research, February 2011. Hours: 15 mins. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-09-28 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2011-09-28-1f359ece-10086-0 |
0b735c2ef38f95d6b1922e4ab1a4b0e763d358a7 | Payment of £75 from Populus received on 18 March 2011, 10 Northburgh Street, London EC1V 0AT, for participation in opinion research, February 2011. Hours: 15 mins. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-08-30 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2011-08-30-1f359ece-10086-0 |
bbb31b80aacb696f03931f8788b8204891284706 | Payment of £75 from Populus received on 18 March 2011, 10 Northburgh Street, London EC1V 0AT, for participation in opinion research, February 2011. Hours: 15 mins. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2011-07-19-1f359ece-10086-0 |
777808801c533e39268cabded516ff233d98a51c | Payment of £75 from Populus received on 18 March 2011, 10 Northburgh Street, London EC1V 0AT, for participation in opinion research, February 2011. Hours: 15 mins. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Alan Campbell uk.org.publicwhip/member/40619 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2011-07-06-1f359ece-10086-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");