items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where member_id = "uk.org.publicwhip/member/112" 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 |
---|---|---|---|---|---|---|---|
21a5997e39288ca9d801fcd7b5c443cf3330b3e1 | Member of the Political Opinion Panel of BPRI (Business Planning and Research International). Fees donated for the work of my Constituency Labour Party. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Paul Clark uk.org.publicwhip/member/112 | Paul Clark uk.org.publicwhip/person/10112 | 0 | 2001-05-14-1f359ece-10112-0 |
d227407b17554b29545925f417f4ea724c35dbcb | A donation of £1000 per annum is made to my constituency party by the Amalgamated Engineering Union. | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Paul Clark uk.org.publicwhip/member/112 | Paul Clark uk.org.publicwhip/person/10112 | 0 | 2001-05-14-9e46def6-10112-0 |
0c3e9daf465e9e913976aaa69fdb78f20e98b16c | Member of the Political Opinion Panel of BPRI (Business Planning and Research International). Fees donated for the work of my Constituency Labour Party. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Paul Clark uk.org.publicwhip/member/112 | Paul Clark uk.org.publicwhip/person/10112 | 0 | 2000-11-10-1f359ece-10112-0 |
aa7e7ed00c6eb2e13e3997f15c370e78fad7b436 | A donation of £1000 per annum is made to my constituency party by the Amalgamated Engineering Union. | Sponsorship or financial or material support 9e46def6 | 2000-11-10 | Paul Clark uk.org.publicwhip/member/112 | Paul Clark uk.org.publicwhip/person/10112 | 0 | 2000-11-10-9e46def6-10112-0 |
6671460d4cf9601e084bd5acd14564b1acfa9ea4 | 18-20 July 1999, to Gibraltar; air fares and accommodation paid for by the Gibraltar Government. (Registered 7 December 1999) | Overseas visits 80ef1083 | 2000-11-10 | Paul Clark uk.org.publicwhip/member/112 | Paul Clark uk.org.publicwhip/person/10112 | 0 | 2000-11-10-80ef1083-10112-0 |
36aacc471c1a5469fae6079170b4789e2a973970 | 3-8 October 1999, to Israel and the Palestinian Authority with the Labour Friends of Israel to meet senior Israeli and Palestinian leaders in the Middle East Peace process. Flight and accommodation paid for by Labour Friends of Israel. (Registered 7 December 1999) | Overseas visits 80ef1083 | 2000-11-10 | Paul Clark uk.org.publicwhip/member/112 | Paul Clark uk.org.publicwhip/person/10112 | 1 | 2000-11-10-80ef1083-10112-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");