items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where person_id = "uk.org.publicwhip/person/10137" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, member_id, sort_order, record_id, date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| 3984b52c574ffb4c2d066f94a853b5af7680b7ae | Occasional income from writing and articles. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Jim Cousins uk.org.publicwhip/member/823 | Jim Cousins uk.org.publicwhip/person/10137 | 0 | 2002-05-14-1f359ece-10137-0 |
| bb94770a7a55e1ba9172f55277cfe943a5c82c21 | Member of Harris Parliamentary Panel. (£1-£1,000) . Fees are donated elsewhere. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Jim Cousins uk.org.publicwhip/member/823 | Jim Cousins uk.org.publicwhip/person/10137 | 1 | 2002-05-14-1f359ece-10137-0 |
| 6e871040e7f68943859e10e135c7b8d1dbb5132c | Member of Political Opinion Panel of BPRI (Business Planning and Research International). Fees are donated elsewhere. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Jim Cousins uk.org.publicwhip/member/823 | Jim Cousins uk.org.publicwhip/person/10137 | 2 | 2002-05-14-1f359ece-10137-0 |
| 56e52c97de044a9d4869c0fb8b953247656b6bf9 | Newcastle City Council give me access to the Staff and Council Members' Car Park. I estimate the value of this concession as being below the threshold for registration. | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Jim Cousins uk.org.publicwhip/member/823 | Jim Cousins uk.org.publicwhip/person/10137 | 0 | 2002-05-14-265f2269-10137-0 |
| b23013aa35cb85f9560de526057f8e0847dd18db | Occasional income from writing and articles. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Jim Cousins uk.org.publicwhip/member/137 | Jim Cousins uk.org.publicwhip/person/10137 | 0 | 2001-05-14-1f359ece-10137-0 |
| 026908578f6695eaa6429ee08a513b3e8d59a3a1 | Member of Harris Parliamentary Panel. (£1-£1,000) . Fees are donated elsewhere. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Jim Cousins uk.org.publicwhip/member/137 | Jim Cousins uk.org.publicwhip/person/10137 | 1 | 2001-05-14-1f359ece-10137-0 |
| 81b9f2846c55e972bcc02293765841bab7026afc | Member of Political Opinion Panel of BPRI (Business Planning and Research International). Fees are donated elsewhere. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Jim Cousins uk.org.publicwhip/member/137 | Jim Cousins uk.org.publicwhip/person/10137 | 2 | 2001-05-14-1f359ece-10137-0 |
| 4ba662cd7f6fcab46180ac38467e5a46f283e9d3 | Member of Advisory Group of Shareholder Services; an online financial services news and information service (February-May 2000). The fee was donated elsewhere and no direct financial benefit came to me. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Jim Cousins uk.org.publicwhip/member/137 | Jim Cousins uk.org.publicwhip/person/10137 | 3 | 2001-05-14-1f359ece-10137-0 |
| c305f157fad5ed55fbf81ed812bc28a11b12a0e4 | Occasional income from writing and articles. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Jim Cousins uk.org.publicwhip/member/137 | Jim Cousins uk.org.publicwhip/person/10137 | 0 | 2000-11-10-1f359ece-10137-0 |
| 745770b870664ed5d468ae26836e8ab4867b03f8 | Member of Harris Parliamentary Panel. (£1-£1,000) . Fees are donated elsewhere. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Jim Cousins uk.org.publicwhip/member/137 | Jim Cousins uk.org.publicwhip/person/10137 | 1 | 2000-11-10-1f359ece-10137-0 |
| e7f4ea8f21caab120f17522f19493a8af1128450 | Member of Political Opinion Panel of BPRI (Business Planning and Research International). Fees are donated elsewhere. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Jim Cousins uk.org.publicwhip/member/137 | Jim Cousins uk.org.publicwhip/person/10137 | 2 | 2000-11-10-1f359ece-10137-0 |
| 197d698819653879a4335dbea951efb5c346cf18 | Member of Advisory Group of Shareholder Services; an online financial services news and information service (February-May 2000). The fee is donated elsewhere and no direct financial benefit comes to me. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Jim Cousins uk.org.publicwhip/member/137 | Jim Cousins uk.org.publicwhip/person/10137 | 3 | 2000-11-10-1f359ece-10137-0 |
| 4d4d8f880d057438e4bf5161564cfa0444c24482 | 14-19 November 1999, to Iran with the British-Iranian All-Party Parliamentary Group, at the invitation of the Iranian Parliament and Government for the improvement of bilateral parliamentary relations. Air travel between London and Tehran provided by British Airways. Accommodation in Tehran provided without charge as guests of the British Ambassador. Overnight visit to Shiraz made as guests of the Iranian Parliament and the Governorship of Fars Province. (Registered 13 December 1999) | Overseas visits 80ef1083 | 2000-11-10 | Jim Cousins uk.org.publicwhip/member/137 | Jim Cousins uk.org.publicwhip/person/10137 | 0 | 2000-11-10-80ef1083-10137-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");