items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
47 rows where person_id = "uk.org.publicwhip/person/10394" sorted by hash
This data as json, CSV (advanced)
Suggested facets: item, category_id, member_id
date (date) >30 ✖
- 2000-11-10 2
- 2001-05-14 2
- 2002-05-14 2
- 2008-01-22 1
- 2008-02-05 1
- 2008-02-26 1
- 2008-03-11 1
- 2008-03-25 1
- 2008-04-23 1
- 2008-06-16 1
- 2008-07-08 1
- 2008-07-22 1
- 2008-09-03 1
- 2008-10-08 1
- 2008-10-22 1
- 2008-11-05 1
- 2008-11-19 1
- 2008-12-03 1
- 2008-12-17 1
- 2009-01-14 1
- 2009-01-28 1
- 2009-02-11 1
- 2009-02-25 1
- 2009-03-11 1
- 2009-03-25 1
- 2009-04-22 1
- 2009-05-06 1
- 2009-05-20 1
- 2009-06-10 1
- 2009-06-24 1
- …
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
1be93b5632ca6aed299ba7bda754a7ca2e7bd7a1 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2010-04-12-1f359ece-10394-0 |
27aa70ce7f0e9ee978426102fe35aa815f828bf2 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-12-17 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-12-17-1f359ece-10394-0 |
2d17e603c26c57224930ddd7fe09d01d326dd2fc | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2010-03-10-1f359ece-10394-0 |
2eaae474a0fcfc3b39773f9f468477993ac62e65 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-07-21 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-07-21-1f359ece-10394-0 |
3033de3002a0fe8b1ad0da1d1ab16813ccfb409c | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-05-06 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-05-06-1f359ece-10394-0 |
305c129228b705bd3a441138dd8e6057f37ff86d | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-10-22 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-10-22-1f359ece-10394-0 |
31ee0cbbadf72e44a186f5b946e5e783ab6bce62 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-02-25 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-02-25-1f359ece-10394-0 |
3b6d59d3867ab623ceb7ca05a5b8b4d8485fd4dc | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-07-08 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-07-08-1f359ece-10394-0 |
4a6207532c94783b1d1f95091ded842e89597585 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-10-14-1f359ece-10394-0 |
4cef465fc3aac946c14902e524e5e926ef586116 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-09-02-1f359ece-10394-0 |
4dce310b61f0836ca0d835908ea0d9a6d5a539f4 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-07-22 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-07-22-1f359ece-10394-0 |
4dfcb5bcf86ca22dd5bba9b609c07861de73e1fa | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-12-03 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-12-03-1f359ece-10394-0 |
4f70b5f3b7c335d7ee55533666cf80100e0c8b64 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-04-22 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-04-22-1f359ece-10394-0 |
4fde47144a5f8415776cc9620b4e72c282754ad2 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-06-10 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-06-10-1f359ece-10394-0 |
5086445e6c223aa45cb8d1bb674bd8de17009cc3 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-02-11 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-02-11-1f359ece-10394-0 |
5dc88c0bb46c0dac580fce97127ca9be9b51945c | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-03-11 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-03-11-1f359ece-10394-0 |
6a2c4a3219f8b4ceb4ab69a10a514dffe3c7ddef | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-06-16 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-06-16-1f359ece-10394-0 |
6aa7432575f8afb0a25c95df7cbed1808b49b12d | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-03-25 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-03-25-1f359ece-10394-0 |
755db0e96a3b886a47afa3238581d97d7f156d79 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-06-24 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-06-24-1f359ece-10394-0 |
771d997da603ac529fa74118b969e064ff48fb77 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2010-03-24-1f359ece-10394-0 |
7c83e5dc5432ce09d7f29d95943087939a5fd3b2 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2010-02-24-1f359ece-10394-0 |
826d49f45f90366ad9aa6bf62cfd287aefff23b2 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-02-26 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-02-26-1f359ece-10394-0 |
82d3ed7413d47ca807f22c7635c76aa1871f06fe | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-12-10-1f359ece-10394-0 |
84a46707bf86b69bce2a82247f5b7143112756ba | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-11-19 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-11-19-1f359ece-10394-0 |
861d25a25d9f20420a95cda540883dbdbd5ec79d | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-01-22 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-01-22-1f359ece-10394-0 |
8733081ab77f56f1863df750777e89845a47501f | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-10-08 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-10-08-1f359ece-10394-0 |
97183726eeefe2f733587a26ab584cd9ea8d30a3 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-10-28-1f359ece-10394-0 |
998314a8ecbb9c0b67c8a53bc374929cf131aa2c | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-11-25-1f359ece-10394-0 |
9a190b5a6dfdfe7dc409a4d86032fe264506c78e | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-03-11 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-03-11-1f359ece-10394-0 |
9a1a5bccb7d84691383ded3de51b5cae7df6fa3c | Crime Reduction International; a consultancy. | Remunerated directorships ead1ca87 | 2001-05-14 | David Maclean uk.org.publicwhip/member/394 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2001-05-14-ead1ca87-10394-0 |
9c7b2debaef831e7633ec59eae593a7a2e29b362 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-11-11-1f359ece-10394-0 |
a2a5c5139824d9d62c2cc722984ffc8c52bdb65e | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-04-23 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-04-23-1f359ece-10394-0 |
a5bb5e3a107e1efb42941fc6af7d9ff730056582 | Crime Reduction International; a consultancy. | Remunerated directorships ead1ca87 | 2000-11-10 | David Maclean uk.org.publicwhip/member/394 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2000-11-10-ead1ca87-10394-0 |
ac99fa0b4299f53d308839b69764523d0c5104e6 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-03-25 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-03-25-1f359ece-10394-0 |
b140b07c0a74da3cc8408ebeaa2d0420ee064cb4 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-11-05 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-11-05-1f359ece-10394-0 |
b4860e7d0b371b11f71f31ad80218565a9fef131 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-09-03 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-09-03-1f359ece-10394-0 |
b4bd5daed8a9aa9d4f1835411cebea73d989eee5 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-07-08-1f359ece-10394-0 |
b71e837215d8666402b7977235b7ce6b13a0e053 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2010-01-06-1f359ece-10394-0 |
bd6f36c5e25fbf84d62fa507972edb210f697a47 | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2010-02-03-1f359ece-10394-0 |
c727683cb0b5a7a22c05d8dda60bab6fd1fb72e9 | Crime Reduction International; a consultancy. | Remunerated directorships ead1ca87 | 2002-05-14 | David Maclean uk.org.publicwhip/member/1079 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2002-05-14-ead1ca87-10394-0 |
d48a900131111072e5af2d66430e4ed499465768 | Parliamentary Adviser to the Police Superintendents' Association of England and Wales. (£10,001-£15,000) (Resigned September 2001). | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | David Maclean uk.org.publicwhip/member/1079 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2002-05-14-1f359ece-10394-0 |
d733cf91fe32933bc5bdf68012a30ac1de678dae | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-01-14 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-01-14-1f359ece-10394-0 |
dab2b67894866b049a8203befbd69e5ded956b2e | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-05-20 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-05-20-1f359ece-10394-0 |
e5c76ace85a0de08662c5d31a53938fdf429561e | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2009-01-28 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2009-01-28-1f359ece-10394-0 |
e6e94cff2a59c9b764eacc4f7deebde5cf04ad4c | Parliamentary Adviser to the Police Superintendents' Association of England and Wales. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | David Maclean uk.org.publicwhip/member/394 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2001-05-14-1f359ece-10394-0 |
ed507407976497adf8e333e84dcd8cab4f55efd5 | Parliamentary Adviser to the Police Superintendents' Association of England and Wales. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | David Maclean uk.org.publicwhip/member/394 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2000-11-10-1f359ece-10394-0 |
f0b046e924dbae102adb90d097b15d5dc4cdae8b | Consultant to Media House, a public relations company. | Remunerated employment, office, profession etc 1f359ece | 2008-02-05 | David Maclean uk.org.publicwhip/member/1758 | David Maclean uk.org.publicwhip/person/10394 | 0 | 2008-02-05-1f359ece-10394-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");