home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

37 rows where person_id = "uk.org.publicwhip/person/10067" sorted by date descending

✎ View and edit SQL

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
919fa26f35edb1b0ced152c06bbdb4cf8aed0247 Occasional journalism and speeches. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 0 2001-05-14-1f359ece-10067-0
e0835ba7d085a88cc166cf5124086165ec690c95 Chairman of the Building Societies Ombudsman Council. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 1 2001-05-14-1f359ece-10067-0
35927ebce9fc9e3155a84152001e237848c10673 Member of Lloyd's (resigned). Remunerated employment, office, profession etc 1f359ece 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 2 2001-05-14-1f359ece-10067-0
8cedf986aaf1fdb9693e06bf57f911fb375a9a8e MAPA: All categories of business underwritten except Life (in run-off). Remunerated employment, office, profession etc 1f359ece 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 3 2001-05-14-1f359ece-10067-0
f911bc0279ed49f44a79f66901360b7988dd9bd7 2 September 2000, guest of PricewaterhouseCooper at the Oval for final test England v West Indies. (Registered 13 December 2000) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 0 2001-05-14-84642823-10067-0
2281dbcd9da52e59f7b453fb139cd78a51e139bf Ecole St. Georges S.A. Registrable shareholdings 3aff2389 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 0 2001-05-14-3aff2389-10067-0
e07a5ba1a923c423774f704136c07a29935f1ff4 Member of Council, University of London. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 0 2001-05-14-265f2269-10067-0
691571c985bc998b00d9fb36f9c6e7f96cebc221 Senior Fellow, Royal College of Art. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 1 2001-05-14-265f2269-10067-0
461f3843a729aa09491acbd77708aee111b04f31 Presentation Fellow, King's College, London. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 2 2001-05-14-265f2269-10067-0
7927244c3262a1e58dfa9cb0438bf6ddc2a53fc4 Honorary Fellow, Queen Mary and Westfield College. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 3 2001-05-14-265f2269-10067-0
ffeed21da80929032238c56be8bc26963dfa830a Hon. D. Litt., University of Westminster. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 4 2001-05-14-265f2269-10067-0
5cae9b99dc926740e73b277a9322a55e3e6f9aa0 President of the British Antique Dealers' Association (honorary, though in receipt of an uncovenanted case of wine at Christmas). Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 5 2001-05-14-265f2269-10067-0
fefb401993722bbdbc55c71e9b0319ab667976c7 President of the British Art Market Federation. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 6 2001-05-14-265f2269-10067-0
78ef2708d488b0914556ed7087aca61639b99ece Trustee, Institute of Contemporary British History. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 7 2001-05-14-265f2269-10067-0
b3d93d3493422bb9f814405bdb624cfe8d321e2e Trustee, Marlburian Club. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 8 2001-05-14-265f2269-10067-0
954299786cd4ca90d9c4c8414308514b308b828a Trustee, Wordsworth Trust. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 9 2001-05-14-265f2269-10067-0
9f97f8431046b9cc6d63e8b4297b9c51bff81648 Patron, The Kennet and Avon Canal Partnership Project. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 10 2001-05-14-265f2269-10067-0
fd9345b247cf364efd8aa37398caf552e5e6e490 Patron, The Stained Glass Museum 25th Anniversary Appeal. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 11 2001-05-14-265f2269-10067-0
67e6d88c0cf0f3976095ff2d38b9437828894452 Liveryman of the Drapers' Company (unremunerated). Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 12 2001-05-14-265f2269-10067-0
5066164ea86efb1ff3636da9cc0dd0e6edeca889 Occasional journalism and speeches. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 0 2000-11-10-1f359ece-10067-0
406042c349f5ac2e84d2b02bfc63866ac7831baa Chairman of the Building Societies Ombudsman Council. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 1 2000-11-10-1f359ece-10067-0
7820f898c750e6ae771c87147885a84ec10d11b4 Member of Lloyd's (resigned). Remunerated employment, office, profession etc 1f359ece 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 2 2000-11-10-1f359ece-10067-0
a2557bdbe54ca483d2abfca53a7d659df8c15fc1 MAPA: All categories of business underwritten except Life (in run-off). Remunerated employment, office, profession etc 1f359ece 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 3 2000-11-10-1f359ece-10067-0
87dd377f8ee4541874d1a063f8ead2892aae7f57 I was a guest of PriceWaterhouseCoopers at the final of the Cricket World Cup at Lords on 20 June 1999 and the Test Match at the Oval on 21 August 1999. (Registered 13 December 1999) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 0 2000-11-10-84642823-10067-0
461333b44c31d23f35e34a6c7016b23f328c1030 Ecole St. Georges S.A. Registrable shareholdings 3aff2389 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 0 2000-11-10-3aff2389-10067-0
2bcc6dce4af49d2bb5ba8c4a046d0a6a2f6f411f Member of Council, University of London. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 0 2000-11-10-265f2269-10067-0
8dbc71adad5ab021bc6530bf17caa7ec7e371821 Senior Fellow, Royal College of Art. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 1 2000-11-10-265f2269-10067-0
005496ea401033eec9aa4fce55cc88d626ad7d19 Presentation Fellow, King's College, London. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 2 2000-11-10-265f2269-10067-0
7252c3e73174c78592817dd5760aeddc937ff1b9 Honorary Fellow, Queen Mary and Westfield College. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 3 2000-11-10-265f2269-10067-0
049213bdb60372c9b3ed263a41a4ebead1d3e854 Hon. D. Litt., University of Westminster. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 4 2000-11-10-265f2269-10067-0
b8b68075592ddb087f8f4e782eabd7397554cf7c President of the British Antique Dealers' Association (honorary, though in receipt of an uncovenanted case of wine at Christmas). Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 5 2000-11-10-265f2269-10067-0
ab549eb44a031cd6f2f5cb50d1b2a7fd4bb2fa65 President of the British Art Market Federation. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 6 2000-11-10-265f2269-10067-0
803cc1c61ccdff073bde81e387e38713fa60fca5 Trustee, Institute of Contemporary British History. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 7 2000-11-10-265f2269-10067-0
40793a3b782818a45360939f50b00fbe64453450 Trustee, Marlburian Club. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 8 2000-11-10-265f2269-10067-0
a95df3178eb368a4302057dbbd408f98ba007c83 Trustee, Wordsworth Trust. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 9 2000-11-10-265f2269-10067-0
20465e7775aa2cd024818c2a46383982f1bb560b Patron, The Kennet and Avon Canal Partnership Project. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 10 2000-11-10-265f2269-10067-0
2edba354a0fdc1ef355615d0d160ce1208786f2c Patron, The Stained Glass Museum 25th Anniversary Appeal. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brooke uk.org.publicwhip/member/67 Peter Brooke uk.org.publicwhip/person/10067 11 2000-11-10-265f2269-10067-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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");
Powered by Datasette · Queries took 124.769ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette