items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2002-05-14-1f359ece-10022-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: 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 |
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");