items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where "date" is on date 2002-11-26 and person_id = "uk.org.publicwhip/person/10095" 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 |
---|---|---|---|---|---|---|---|
fdb78a594a4fbaa1c4f334afa7bf12bad026aeff | Legal and legislative adviser to Institute of Company Accountants. | Remunerated employment, office, profession etc. 0a4a155f | 2002-11-26 | William Cash uk.org.publicwhip/member/787 | Bill Cash uk.org.publicwhip/person/10095 | 0 | 2002-11-26-0a4a155f-10095-0 |
593ccb0c2b4d9161c7796a0b18ba6b5ff44add64 | Consultant to Radcliffe's, solicitors; providing legal, legislative, parliamentary and public affairs advice. I occasionally sponsor functions for the firm. (£5,001-£10,000) | Remunerated employment, office, profession etc. 0a4a155f | 2002-11-26 | William Cash uk.org.publicwhip/member/787 | Bill Cash uk.org.publicwhip/person/10095 | 1 | 2002-11-26-0a4a155f-10095-0 |
3234b3a8dcbb2bc15dd75a6c367c70c4b1500830 | Solicitor_William Cash & Co. | Remunerated employment, office, profession etc. 0a4a155f | 2002-11-26 | William Cash uk.org.publicwhip/member/787 | Bill Cash uk.org.publicwhip/person/10095 | 2 | 2002-11-26-0a4a155f-10095-0 |
98d0251448b4ed32b9574f4f8fd30389dc595939 | Research and organisational assistance from the European Foundation (nil remuneration). | Sponsorship or financial or material support 9e46def6 | 2002-11-26 | William Cash uk.org.publicwhip/member/787 | Bill Cash uk.org.publicwhip/person/10095 | 0 | 2002-11-26-9e46def6-10095-0 |
9345430602f7f123ce7266b248311498f75a89da | 13-16 April 2002, to USA, to attend conference. Air fare and two nights' hotel accommodation paid for by American Enterprise Institute. (Registered 7 September 2002) | Overseas visits 80ef1083 | 2002-11-26 | William Cash uk.org.publicwhip/member/787 | Bill Cash uk.org.publicwhip/person/10095 | 0 | 2002-11-26-80ef1083-10095-0 |
0ca63cbcdaaa13ecc7ff5f19dc5f52456c69f839 | Three houses at Upton Cressett, Shropshire from which rental income is received. | Land and Property 4f1e6359 | 2002-11-26 | William Cash uk.org.publicwhip/member/787 | Bill Cash uk.org.publicwhip/person/10095 | 0 | 2002-11-26-4f1e6359-10095-0 |
26ac488e871031c7dcdd3dd6b5d34f529ae9b644 | Africa Speaks Holdings (UK) Limited (not trading); African data, information and culture. | Registrable shareholdings 3aff2389 | 2002-11-26 | William Cash uk.org.publicwhip/member/787 | Bill Cash uk.org.publicwhip/person/10095 | 0 | 2002-11-26-3aff2389-10095-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");