items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
123 rows where person_id = "uk.org.publicwhip/person/10289" sorted by date descending
This data as json, CSV (advanced)
date (date) 7 ✖
- 2000-11-10 4
- 2001-05-14 3
- 2002-05-14 3
- 2002-11-26 3
- 2003-12-04 3
- 2004-01-31 3
- 2004-05-21 3
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
15658a82420427c288e1e2a038bda859ec712c02 | CRU Publishing Ltd. | Remunerated directorships ead1ca87 | 2004-05-21 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 1 | 2004-05-21-ead1ca87-10289-0 |
53445642b371458bf97094a1af4b83c20c85ee60 | CRU International Ltd. | Remunerated directorships ead1ca87 | 2004-05-21 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 0 | 2004-05-21-ead1ca87-10289-0 |
8e8f33097caef76d5dd63cdce3a42c0e96bb9205 | These are non-executive directorships in business consultancy and publishing companies which I helped to found in 1969. | Remunerated directorships ead1ca87 | 2004-05-21 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 2 | 2004-05-21-ead1ca87-10289-0 |
3efda2db77e958af01411a15234c5b2a6e71a049 | CRU International Ltd. | Remunerated directorships ead1ca87 | 2004-01-31 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 0 | 2004-01-31-ead1ca87-10289-0 |
9c08125ca63df5c915f183c9f1c8fd235190538e | CRU Publishing Ltd. | Remunerated directorships ead1ca87 | 2004-01-31 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 1 | 2004-01-31-ead1ca87-10289-0 |
b434ba17e929f253346016150fb92d99cdd88350 | These are non-executive directorships in business consultancy and publishing companies which I helped to found in 1969. | Remunerated directorships ead1ca87 | 2004-01-31 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 2 | 2004-01-31-ead1ca87-10289-0 |
3a42824734262b0e1d130d27bf3606d985cf5d5e | These are non-executive directorships in business consultancy and publishing companies which I helped to found in 1969. | Remunerated directorships ead1ca87 | 2003-12-04 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 2 | 2003-12-04-ead1ca87-10289-0 |
8dffc6a3f472d2131d5a800ddf7cefcf2985516c | CRU Publishing Ltd. | Remunerated directorships ead1ca87 | 2003-12-04 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 1 | 2003-12-04-ead1ca87-10289-0 |
dfb760fc5cdc40dbd07d4e91a33ebd5bf2bb6f63 | CRU International Ltd. | Remunerated directorships ead1ca87 | 2003-12-04 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 0 | 2003-12-04-ead1ca87-10289-0 |
1f15c028be2d7fb4595c6d83103a1ac6f183fdd7 | These are non-executive directorships in business consultancy and publishing companies which I helped to found in 1969. | Remunerated directorships ead1ca87 | 2002-11-26 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 2 | 2002-11-26-ead1ca87-10289-0 |
6eaef7ab8eed54f77ec96cb48b7438d3c80e8d66 | CRU Publishing Ltd. | Remunerated directorships ead1ca87 | 2002-11-26 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 1 | 2002-11-26-ead1ca87-10289-0 |
879b7700acddd41dd1cc3b38a8fb074cd75afc24 | CRU International Ltd. | Remunerated directorships ead1ca87 | 2002-11-26 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 0 | 2002-11-26-ead1ca87-10289-0 |
958ead53874adac0b09861fef6984f2aeaed6d75 | CRU International Ltd. | Remunerated directorships ead1ca87 | 2002-05-14 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 0 | 2002-05-14-ead1ca87-10289-0 |
bcda39ed3d9f2a2ef2a78a051b8f9dfff4237ebf | These are non-executive directorships in business consultancy and publishing companies which I helped to found 28 years ago. | Remunerated directorships ead1ca87 | 2002-05-14 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 2 | 2002-05-14-ead1ca87-10289-0 |
c2f9c06a7f651229a5e107f5ea292d99a193553e | CRU Publishing Ltd. | Remunerated directorships ead1ca87 | 2002-05-14 | John Horam uk.org.publicwhip/member/973 | John Horam uk.org.publicwhip/person/10289 | 1 | 2002-05-14-ead1ca87-10289-0 |
3eed85a443a705f380c9bce9686f747b55a8d533 | These are information and publishing companies which I helped to found 28 years ago. | Remunerated directorships ead1ca87 | 2001-05-14 | John Horam uk.org.publicwhip/member/289 | John Horam uk.org.publicwhip/person/10289 | 2 | 2001-05-14-ead1ca87-10289-0 |
6e1790ea5a0a1b4c45581af990cb90c09df2d87d | CRU Publishing Ltd. | Remunerated directorships ead1ca87 | 2001-05-14 | John Horam uk.org.publicwhip/member/289 | John Horam uk.org.publicwhip/person/10289 | 1 | 2001-05-14-ead1ca87-10289-0 |
ac96bee53d19707e5f0189bdb793e48dbe69aac0 | CRU International Ltd. | Remunerated directorships ead1ca87 | 2001-05-14 | John Horam uk.org.publicwhip/member/289 | John Horam uk.org.publicwhip/person/10289 | 0 | 2001-05-14-ead1ca87-10289-0 |
70586cbaea90c8c01f74923912d3a1cb28a40292 | These are information and publishing companies which I helped to found 28 years ago. | Remunerated directorships ead1ca87 | 2000-11-10 | John Horam uk.org.publicwhip/member/289 | John Horam uk.org.publicwhip/person/10289 | 2 | 2000-11-10-ead1ca87-10289-0 |
b64448417b9740ff4652af8e0007d28365a67b43 | CRU Publishing Ltd. | Remunerated directorships ead1ca87 | 2000-11-10 | John Horam uk.org.publicwhip/member/289 | John Horam uk.org.publicwhip/person/10289 | 1 | 2000-11-10-ead1ca87-10289-0 |
d552ba548b8c708abcebcabdf9dd257e24224020 | 21-22 June 1999, to Bonn, Germany, to meet senior CDU politicians, paid for by the Konrad Adenauer Institute. (Registered 21 July 1999) | Overseas visits 80ef1083 | 2000-11-10 | John Horam uk.org.publicwhip/member/289 | John Horam uk.org.publicwhip/person/10289 | 0 | 2000-11-10-80ef1083-10289-0 |
d825cba9262f1b7f8aa84090ff8fa267239e90cb | CRU International Ltd. | Remunerated directorships ead1ca87 | 2000-11-10 | John Horam uk.org.publicwhip/member/289 | John Horam uk.org.publicwhip/person/10289 | 0 | 2000-11-10-ead1ca87-10289-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");