items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where member_id = "uk.org.publicwhip/member/1160" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
d4c566dd7f3ef2a7c00b87e1964b5c9508ddce60 | De Brus Marketing Ltd., Leamington Spa (non-executive); education and training support. | Remunerated directorships ead1ca87 | 2005-04-11 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2005-04-11-ead1ca87-10480-0 |
f4352cc931d777216c9f3b4096a666ef8e887302 | Calor Gas funded the production and distribution of my 2004 official Christmas card. (Registered 20 December 2004) | Sponsorship or financial or material support 9e46def6 | 2005-04-11 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2005-04-11-9e46def6-10480-0 |
97fc3a75778721de572d614931b9720b32affcb2 | De Brus Marketing Ltd., Leamington Spa (non-executive); education and training support. | Remunerated directorships ead1ca87 | 2005-01-28 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2005-01-28-ead1ca87-10480-0 |
38126cb581564a7cb6284530d73d06ce56637a6e | Calor Gas funded the production and distribution of my 2004 official Christmas card. (Registered 20 December 2004) | Sponsorship or financial or material support 9e46def6 | 2005-01-28 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2005-01-28-9e46def6-10480-0 |
f8573b2a3873b169cf522d442ecddcd0f24d930a | De Brus Marketing Ltd., Leamington Spa (non-executive); education and training support. | Remunerated directorships ead1ca87 | 2004-12-03 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-12-03-ead1ca87-10480-0 |
aa215ad6f38e3ae8fae7ca84dcdfc20082a7f915 | Calor Gas funded the production and distribution of my 2003 official Christmas card. (Registered 10 December 2003) | Sponsorship or financial or material support 9e46def6 | 2004-12-03 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-12-03-9e46def6-10480-0 |
068e8c9ba791f1341e09e647719a69d94610ec4a | De Brus Marketing Ltd., Leamington Spa (non-executive); education and training support. | Remunerated directorships ead1ca87 | 2004-10-22 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-10-22-ead1ca87-10480-0 |
d50371d7f6f872fad952e1ce6a3dcaf1dc8d18db | Calor Gas funded the production and distribution of my 2003 official Christmas card. (Registered 10 December 2003) | Sponsorship or financial or material support 9e46def6 | 2004-10-22 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-10-22-9e46def6-10480-0 |
88221565bbb7f6018ebc2666fabc911b4d43c211 | De Brus Marketing Ltd., Leamington Spa (non-executive); education and training support. | Remunerated directorships ead1ca87 | 2004-09-08 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-09-08-ead1ca87-10480-0 |
bfbe1015153aa6b192c4174c6a2e496467245d02 | Calor Gas funded the production and distribution of my 2003 official Christmas card. (Registered 10 December 2003) | Sponsorship or financial or material support 9e46def6 | 2004-09-08 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-09-08-9e46def6-10480-0 |
048185ad5b002c22fbce5e8cd586826fc6f578f0 | De Brus Marketing Ltd., Leamington Spa (non-executive); education and training support. | Remunerated directorships ead1ca87 | 2004-07-16 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-07-16-ead1ca87-10480-0 |
6ebd3ea25aa139ce73a297574ca4c63f42458755 | Calor Gas funded the production and distribution of my 2003 official Christmas card. (Registered 10 December 2003) | Sponsorship or financial or material support 9e46def6 | 2004-07-16 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-07-16-9e46def6-10480-0 |
e9a4ef1b00a1978612c1ca215b040dbde78323e2 | De Brus Marketing Ltd., Leamington Spa (non-executive); education and training support. | Remunerated directorships ead1ca87 | 2004-05-21 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-05-21-ead1ca87-10480-0 |
f045a5bfa2a3b530e7e309720a59a459997bff35 | Calor Gas funded the production and distribution of my 2003 official Christmas card. (Registered 10 December 2003) | Sponsorship or financial or material support 9e46def6 | 2004-05-21 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-05-21-9e46def6-10480-0 |
24f2fff238ecf33f37ff73a18c5f68ca1d38c10f | De Brus Marketing Ltd., Leamington Spa (non-executive); education and training support. | Remunerated directorships ead1ca87 | 2004-01-31 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-01-31-ead1ca87-10480-0 |
34c223bb907e198eb12db9cac8cb5397117b7eb8 | Calor Gas funded the production and distribution of my 2003 official Christmas card. (Registered 10 December 2003) | Sponsorship or financial or material support 9e46def6 | 2004-01-31 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2004-01-31-9e46def6-10480-0 |
63ec89dddc8e2321fd17cd26e770624b2c0fe853 | De Brus Marketing Ltd., Leamington Spa (non-executive); education and training support. | Remunerated directorships ead1ca87 | 2003-12-04 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2003-12-04-ead1ca87-10480-0 |
52cadb4b1e5daaba237efe166c3eeff056446205 | De Brus Marketing Ltd., Leamington Spa (non-executive); education and training support. | Remunerated directorships ead1ca87 | 2002-11-26 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2002-11-26-ead1ca87-10480-0 |
ea40bb9d294b51c9fb2a204539acbab65d5c84ac | De Brus Marketing Ltd., Leamington Spa (beginning 1 October 2001) (non-executive). | Remunerated directorships ead1ca87 | 2002-05-14 | James Plaskitt uk.org.publicwhip/member/1160 | James Plaskitt uk.org.publicwhip/person/10480 | 0 | 2002-05-14-ead1ca87-10480-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");