items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where "date" is on date 2002-05-14 and member_id = "uk.org.publicwhip/member/1172" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
9a22d5fe44b6b42cb6a2e0ce25cded4edf00b70e | Non-practising chartered surveyor. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Mark Prisk uk.org.publicwhip/member/1172 | Mark Prisk uk.org.publicwhip/person/11172 | 0 | 2002-05-14-1f359ece-11172-0 |
f7e62ae4b7e13eb75bc4a475ed1c08214a98cda9 | Contributions of more than 25% of my election expenses at the 2001 General Election were made by: | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Mark Prisk uk.org.publicwhip/member/1172 | Mark Prisk uk.org.publicwhip/person/11172 | 0 | 2002-05-14-9e46def6-11172-0 |
eeca64e46998a4d9abd42abf3998af663181f927 | Mr. H. Tee | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Mark Prisk uk.org.publicwhip/member/1172 | Mark Prisk uk.org.publicwhip/person/11172 | 1 | 2002-05-14-9e46def6-11172-0 |
334fc5f0c98e5a7f595e436217545c6962c74a2d | Mr. G. Morrison | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Mark Prisk uk.org.publicwhip/member/1172 | Mark Prisk uk.org.publicwhip/person/11172 | 2 | 2002-05-14-9e46def6-11172-0 |
a8a449fc6b5d897c665a766abe687fb9181a725b | Mr. K. Twort | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Mark Prisk uk.org.publicwhip/member/1172 | Mark Prisk uk.org.publicwhip/person/11172 | 3 | 2002-05-14-9e46def6-11172-0 |
bc9bf7aa10e5c932b00ea8c94202072941387b40 | 21 January 2002, I received the hospitality of Mr David Pritchard, Director of Lloyds TSB Group PLC, for dinner and tickets for the Royal Opera House, Covent Garden. (Registered 20 March 2002) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Mark Prisk uk.org.publicwhip/member/1172 | Mark Prisk uk.org.publicwhip/person/11172 | 0 | 2002-05-14-84642823-11172-0 |
38bac521f624817e94af4c0e89cd717c2b6c3075 | My wife is a senior executive with the Financial Services Authority. | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Mark Prisk uk.org.publicwhip/member/1172 | Mark Prisk uk.org.publicwhip/person/11172 | 0 | 2002-05-14-265f2269-11172-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");