items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where member_id = "uk.org.publicwhip/member/324" 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 |
|---|---|---|---|---|---|---|---|
| 402cfaeb189f97d4cffe6c66dc3dc3d141d1c787 | Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Martyn Jones uk.org.publicwhip/member/324 | Martyn Jones uk.org.publicwhip/person/10324 | 0 | 2001-05-14-1f359ece-10324-0 |
| 54683e4f0b6a78f4082f1b2e53cd2213d54a0643 | Member of Harris Parliamentary Panel. (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Martyn Jones uk.org.publicwhip/member/324 | Martyn Jones uk.org.publicwhip/person/10324 | 1 | 2001-05-14-1f359ece-10324-0 |
| f56e18a39b26e3e356df28616a347b3772fb5d29 | Fees from both panels are paid directly to the Labour Party. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Martyn Jones uk.org.publicwhip/member/324 | Martyn Jones uk.org.publicwhip/person/10324 | 2 | 2001-05-14-1f359ece-10324-0 |
| e90a08b9b254cdd1bfee5651ef2b000910da7bc5 | 21-27 January 2001, to Moscow, as Secretary of the All-Party Group on Population, Development and Reproductive Health, to discuss the setting up of a similar Group in the State Duma of the Russian Federation. Flight and accommodation paid for by the International Planned Parenthood Federation. (Registered 14 February 3001) | Overseas visits 80ef1083 | 2001-05-14 | Martyn Jones uk.org.publicwhip/member/324 | Martyn Jones uk.org.publicwhip/person/10324 | 0 | 2001-05-14-80ef1083-10324-0 |
| 9b92791461e7e14cded413ba5e0e35033e0711fe | Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Martyn Jones uk.org.publicwhip/member/324 | Martyn Jones uk.org.publicwhip/person/10324 | 0 | 2000-11-10-1f359ece-10324-0 |
| 7de955428743f77a07fed25a1608bdae7d8b120b | Member of Harris Parliamentary Panel. (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Martyn Jones uk.org.publicwhip/member/324 | Martyn Jones uk.org.publicwhip/person/10324 | 1 | 2000-11-10-1f359ece-10324-0 |
| 514d64a6865c53fac206bb0fd6e22719b81f8ab5 | Fees from both panels are paid directly to the Labour Party. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Martyn Jones uk.org.publicwhip/member/324 | Martyn Jones uk.org.publicwhip/person/10324 | 2 | 2000-11-10-1f359ece-10324-0 |
| b840a9b3aafb651b838a59f84603dbdf66a34db7 | 18-28 February 1999, to Bolivia and Peru, to view reproductive health centres in those two countries in my capacity as Chairman of the All Party Group on Population, Development and Reproductive Health, funded by Marie Stopes International. (Registered 4 March 1999) | Overseas visits 80ef1083 | 2000-11-10 | Martyn Jones uk.org.publicwhip/member/324 | Martyn Jones uk.org.publicwhip/person/10324 | 0 | 2000-11-10-80ef1083-10324-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");