items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
34 rows where category_id = "eeb1f309" and person_id = "uk.org.publicwhip/person/24962" sorted by date
This data as json, CSV (advanced)
Suggested facets: item, date (date)
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
b56c5625f9fbcc0d4353c2fdc9398327d1ab0dc7 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2015-08-10 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2015-08-10-eeb1f309-24962-0 | |
8abd482ec48f801cbb3737edeef01476bbc503b2 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2015-09-07 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2015-09-07-eeb1f309-24962-0 | |
9f515f97b509ab65e4b59d57a6b52bf9d90c3dd4 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2015-09-28 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2015-09-28-eeb1f309-24962-0 | |
37f37b56c516ae9169be149a24919a3a97a487e2 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2015-10-12 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2015-10-12-eeb1f309-24962-0 | |
ac984013cf868c90d9fa64e8539b53a70da97d11 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2015-10-26 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2015-10-26-eeb1f309-24962-0 | |
3f5705938030f8772289ca93bc9f5e5d420d17d0 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2015-11-09 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2015-11-09-eeb1f309-24962-0 | |
42f0d67059c7554a50bbd40cd0e334ace3e8ad80 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2015-11-30 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2015-11-30-eeb1f309-24962-0 | |
dc6b60d93a8f732ba09d7a68559dbcd9bb956536 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2015-12-14 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2015-12-14-eeb1f309-24962-0 | |
1945c9831627fe00a495fa145fb597349ee8faef | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-01-11 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-01-11-eeb1f309-24962-0 | |
90083a2d87960c2dd2bcf506848fdaea82ead849 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-01-25 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-01-25-eeb1f309-24962-0 | |
4a6431e551458bc46a6061bb81acb648c7de4ef7 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-02-08 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-02-08-eeb1f309-24962-0 | |
ce4e87709fd68224e8543b14344c646ba3599066 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-02-22 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-02-22-eeb1f309-24962-0 | |
f89d7ae8a0708618df8823df0509e0cbbda031c4 | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-03-07 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-03-07-eeb1f309-24962-0 | |
af5ee6d1c644b9892eadf13a2366aaac195b4a4b | My partner, Flora Coleman, is employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-03-21 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-03-21-eeb1f309-24962-0 | |
d0d8a7a0a7260b4a9d7ab62c72b348b6f34570a3 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-04-18 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-04-18-eeb1f309-24962-0 | |
76726b150776b47086d306c1fb8a76697d997d1f | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-05-03 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-05-03-eeb1f309-24962-0 | |
0f33fb0a93a11f0769d70e6c9f76a7308d5386cc | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-05-16 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-05-16-eeb1f309-24962-0 | |
a885ba31153890a5d23fe7e4a6efa528e7ed007f | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-06-06 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-06-06-eeb1f309-24962-0 | |
436490c7a607089fa92d2550a7f5ff414f93b1f4 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-06-27 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-06-27-eeb1f309-24962-0 | |
573625a08fda17524af96f257efc571428bf858d | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-07-11 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-07-11-eeb1f309-24962-0 | |
485a1f62098c75eae3758fd7dd3df78a43fbfaae | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-08-01 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-08-01-eeb1f309-24962-0 | |
18d88164518affff2befc656310005650f6cdaa8 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-09-05 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-09-05-eeb1f309-24962-0 | |
bbba7a0fedcd7911aeb7f3593c9472172ad618bb | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-10-03 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-10-03-eeb1f309-24962-0 | |
ebd8970da972aa94721102fabf681f1798423324 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-10-17 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-10-17-eeb1f309-24962-0 | |
cb73d4570b2dc57fe13e78ed880fc2b52b707be8 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-10-31 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-10-31-eeb1f309-24962-0 | |
4eec452365fdbd4b0b4ef858e408ba17753f7d37 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-11-21 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-11-21-eeb1f309-24962-0 | |
5f216e32e844c3c79d6d79659562b90162ce7ee0 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-12-05 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-12-05-eeb1f309-24962-0 | |
d3a2b0f5a48f268d08b386d8d88ce790f8fedde0 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2016-12-19 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2016-12-19-eeb1f309-24962-0 | |
9be019baad51aa009304975238384a56e38c0a98 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2017-01-09 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2017-01-09-eeb1f309-24962-0 | |
414d46597ae619df8f587c611ba591a699be6005 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2017-01-23 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2017-01-23-eeb1f309-24962-0 | |
c31c2565005ef72caed683662f0b6ed304061b08 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2017-02-06 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2017-02-06-eeb1f309-24962-0 | |
e93c3a725286f564d8055bcd8a3c157927ecda4f | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2017-02-20 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2017-02-20-eeb1f309-24962-0 | |
e8f0b36fd720857682f0b7e959a1336cb58d5cb2 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2017-03-06 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2017-03-06-eeb1f309-24962-0 | |
19ad842756ea346d347cc35a1f1ea96564e69d46 | Until 24 March 2016, my partner, Flora Coleman, was employed as a corporate affairs consultant by MHP Communications. (Registered 27 July 2015; updated 31 March 2016) | Family members engaged in lobbying the public sector on behalf of a third party or client eeb1f309 | 2017-03-20 | Guy Opperman uk.org.publicwhip/person/24962 | 0 | 2017-03-20-eeb1f309-24962-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");