items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where member_id = "uk.org.publicwhip/member/948" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
97b0d7434e5b2b3af4ca2ae5b0785443c7c85875 | Barrister (not currently practising). | Remunerated employment, office, profession, etc. f3967f4d | 2005-04-11 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2005-04-11-f3967f4d-10267-0 |
95d0bd64d8d152d4e25189f4f712a925ad07c0eb | I have an intern provided by CARE charity (Christian Action for Research and Education) whose subsistence and travel costs I pay. | Sponsorship or financial or material support 9e46def6 | 2005-04-11 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2005-04-11-9e46def6-10267-0 |
c21251f89842ad7b1f1a68a69be0f1da366714d1 | Donation from Mr Martin Lewis, a businessman in my constituency, in an auction held by the North East Hertfordshire Conservative Association in February 2005. (Registered 7 March 2005) | Sponsorship or financial or material support 9e46def6 | 2005-04-11 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 1 | 2005-04-11-9e46def6-10267-0 |
6aee052bd20259e5f317e60f94fa5e1be0659632 | Barrister (not currently practising). | Remunerated employment, office, profession, etc.. dc69d097 | 2005-01-28 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2005-01-28-dc69d097-10267-0 |
a27ad4d0d3244fdab947da437df2d54ac8b34dcb | I have an intern provided by CARE charity (Christian Action for Research and Education) whose subsistence and travel costs I pay. | Sponsorship or financial or material support 9e46def6 | 2005-01-28 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2005-01-28-9e46def6-10267-0 |
3fbc8ecb0120dd6623d14698dc309898c7da2927 | Barrister (not currently practising). | Remunerated employment, office, profession, etc. f3967f4d | 2004-12-03 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-12-03-f3967f4d-10267-0 |
fc5f1a7350f6328ab71a2d9f8156e35845fc97da | I have an intern provided by CARE charity (Christian Action for Research and Education) whose subsistence and travel costs I pay. | Sponsorship or financial or material support 9e46def6 | 2004-12-03 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-12-03-9e46def6-10267-0 |
a71ba097fd7052abee9b2a9cd07f5d5f3113172f | Barrister (not currently practising). | Remunerated employment, office, profession, etc. f3967f4d | 2004-10-22 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-10-22-f3967f4d-10267-0 |
6b8a97b36ec5d451bdaedfd7f02a3a10ed0fad15 | I have an intern provided by CARE charity (Christian Action for Research and Education) whose subsistence and travel costs I pay. | Sponsorship or financial or material support 9e46def6 | 2004-10-22 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-10-22-9e46def6-10267-0 |
9ac3eff9df6f9788ddcb613e0f23c7da085b187d | Barrister (not currently practising). | Remunerated employment, office, profession, etc. f3967f4d | 2004-09-08 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-09-08-f3967f4d-10267-0 |
172198466a508ab88604bcd716c31e5b36c30c82 | I have an intern provided by CARE charity (Christian Action for Research and Education) whose subsistence and travel costs I pay. | Sponsorship or financial or material support 9e46def6 | 2004-09-08 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-09-08-9e46def6-10267-0 |
b6c379e0f46744c9197958cc4bad79a1977d5d24 | Barrister (not currently practising). | Remunerated employment, office, profession, etc. f3967f4d | 2004-07-16 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-07-16-f3967f4d-10267-0 |
f17014e6bd9135f8f3a7f6024651b81f00b9390c | I have an intern provided by CARE charity (Christian Action for Research and Education) whose subsistence and travel costs I pay. | Sponsorship or financial or material support 9e46def6 | 2004-07-16 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-07-16-9e46def6-10267-0 |
3923ff4ed26f7e4f90cb3d2102c79eceb352ba55 | Barrister (not currently practising). | Remunerated employment, office, profession, etc. f3967f4d | 2004-05-21 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-05-21-f3967f4d-10267-0 |
2f86326cfac546610e33ebfdca16037309c4e905 | I have an intern provided by CARE charity (Christian Action for Research and Education) whose subsistence and travel costs I pay. | Sponsorship or financial or material support 9e46def6 | 2004-05-21 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-05-21-9e46def6-10267-0 |
e92fcf21b2d4a960654fcf0164b82dc28bb5dc85 | Barrister (not currently practising). | Remunerated employment, office, profession, etc. f3967f4d | 2004-01-31 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-01-31-f3967f4d-10267-0 |
079680376067788237d01f5a4e2ad2b2a84a8cb5 | I have an intern provided by CARE charity (Christian Action for Research and Education) whose subsistence and travel costs I pay. | Sponsorship or financial or material support 9e46def6 | 2004-01-31 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2004-01-31-9e46def6-10267-0 |
20fb6d1a855834ace2ec134601fc73ea296a7a42 | Barrister (not currently practising). | Remunerated employment, office, profession, etc. f3967f4d | 2003-12-04 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2003-12-04-f3967f4d-10267-0 |
3e0b13a38ce54794922629992cd5d60862fb97e3 | Barrister (not currently practising). | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2002-11-26-1f359ece-10267-0 |
a38bc681af17de6a6a0b26e79acd03f7bc6ab088 | Barrister (not currently practising). | Remunerated employment, office, profession, etc. f3967f4d | 2002-05-14 | Oliver Heald uk.org.publicwhip/member/948 | Oliver Heald uk.org.publicwhip/person/10267 | 0 | 2002-05-14-f3967f4d-10267-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");