items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where "date" is on date 2002-05-14 and person_id = "uk.org.publicwhip/person/10022" 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 |
---|---|---|---|---|---|---|---|
63681a649f9eeb36e89bfaa6245294ea1beb83e7 | Occasional fees for writing and broadcasting. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Norman Baker uk.org.publicwhip/member/710 | Norman Baker uk.org.publicwhip/person/10022 | 0 | 2002-05-14-1f359ece-10022-0 |
47d02c4088719cba897a08f2550500b0822d17a4 | Fee for speech given to civil servants at the initiation of the Cabinet Office on the subject of parliamentary questions. (Registered 31 October 2001) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Norman Baker uk.org.publicwhip/member/710 | Norman Baker uk.org.publicwhip/person/10022 | 1 | 2002-05-14-1f359ece-10022-0 |
fed311878f201567944b7d289061b73eece9a408 | October 2001, fee in respect of commission from Mail on Sunday on the topics of MI5 and Data protection. (Registered 12 November 2001) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Norman Baker uk.org.publicwhip/member/710 | Norman Baker uk.org.publicwhip/person/10022 | 2 | 2002-05-14-1f359ece-10022-0 |
4dce0a6ac717a60dc3e24011d8d2691eea2a428e | Occasional income from contributions to political opinion surveys. All monies received are donated to local voluntary and charitable organisations including, on occasion, my local constituency party. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Norman Baker uk.org.publicwhip/member/710 | Norman Baker uk.org.publicwhip/person/10022 | 3 | 2002-05-14-1f359ece-10022-0 |
acd32fa4c2cfdf8dd9dd688c2f6844f7b89f1b34 | January 2002, fee for speech given to civil servants at the initiation of the Cabinet Office on the subject of parliamentary questions. (Registered 12 February 2002) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Norman Baker uk.org.publicwhip/member/710 | Norman Baker uk.org.publicwhip/person/10022 | 4 | 2002-05-14-1f359ece-10022-0 |
1f6d30e22a9c874bcda8bef5a3de81ec210dc29a | January-February 2002, a research assistant was provided for my House of Commons office by Forum for the Future, an organisation that organises placements for students studying sustainable development. (Registered 4 March 2002) | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Norman Baker uk.org.publicwhip/member/710 | Norman Baker uk.org.publicwhip/person/10022 | 0 | 2002-05-14-9e46def6-10022-0 |
fd549d2c84acfc38dfec7b150187466fd79aff48 | 22 October 2001, gift of a set of matching pens from Parker Pen company, Newhaven. (Registered 31 October 2001) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Norman Baker uk.org.publicwhip/member/710 | Norman Baker uk.org.publicwhip/person/10022 | 0 | 2002-05-14-84642823-10022-0 |
578c4007695edd353498c033c5f9ed811ac93b7b | Part-share in property in Lewes which contains both my constituency office and my main residence since September 2000. | Land and Property 4f1e6359 | 2002-05-14 | Norman Baker uk.org.publicwhip/member/710 | Norman Baker uk.org.publicwhip/person/10022 | 0 | 2002-05-14-4f1e6359-10022-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");