home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

27 rows where person_id = "uk.org.publicwhip/person/10064" 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
d42fa75e5e22451c405614c45e7e3bce33054114 Partner in NHS GP practice, Brading, Isle of Wight. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 0 2001-05-14-1f359ece-10064-0
771ced0bac0d9e37de67241e0aada5074d52b395 Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 1 2001-05-14-1f359ece-10064-0
f7fa18bf08d3ab2e2d0cc7ec83e83f8ddd4dd294 Occasional fees for speaking at various medical conferences in the UK. The fees are paid as a donation to my local constituency party. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 2 2001-05-14-1f359ece-10064-0
6ea85f323d2612b4ddbcfe0a4c72199d6bae46ad Honorary membership of Royal Solent Yacht Club. Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 0 2001-05-14-84642823-10064-0
6c5e9d118f251e4c5906652077b827937d679cbc Honorary membership of Seaview Sailing Club. Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 1 2001-05-14-84642823-10064-0
b98ac209e5d61e10a670efc6142489487432d075 Honorary membership of Ryde Rowing Club. Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 2 2001-05-14-84642823-10064-0
0ec4254575f269517d337fca6f290aa494654c7b Honorary membership of Bembridge Sailing Club. Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 3 2001-05-14-84642823-10064-0
cb54a16232ae2cd53b9fe7dea6986cdc24a6fcf0 15-17 March 2000, British-Netherlands All-Party Parliamentary Group visit to the Netherlands Second Chamber at the Hague. Travel paid by Group from funds donated by declared sponsors, namely Royal Dutch Shell, Unilever and Reid Elsevier. All other expenses met by the Second Chamber. (Registered 5 March 2000) Overseas visits 80ef1083 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 0 2001-05-14-80ef1083-10064-0
005be16f0341c7cb3f729c9bb78f3dce2c98e85d 16-17 October 2000, to Denmark with the Associate Parliamentary Renewable and Sustainable Energy Group (PRASEG) to witness the Danish Wind Farm Sector and meet with senior members of the Danish Government Energy Agency and the Danish Wind Industry. Flight and accommodation paid for by National Wind Power UK. (Registered 31 October 2000) Overseas visits 80ef1083 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 1 2001-05-14-80ef1083-10064-0
dae8bea8f7f00c908205c5e362e9fa7dc6f094b0 Beechgrove Surgery, Brading, Isle of Wight. Land and Property 4f1e6359 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 0 2001-05-14-4f1e6359-10064-0
1de51f298c1d867030a4da026f94c63ee7f3cc72 Beechgrove Lake Surgery, Lake, Isle of Wight. Land and Property 4f1e6359 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 1 2001-05-14-4f1e6359-10064-0
c4410370b1d817d60b6df3ef62fabc5e3f221007 Both properties owned jointly with my wife, Dr. Jane Brand, and partner, Dr. Richard Loach. Land and Property 4f1e6359 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 2 2001-05-14-4f1e6359-10064-0
5e1f97ad0ae710ddd4cd8327a0e1ecb2b4eb5b07 Director (unremunerated) of the Isle of Wight Partnership, which is concerned with the economic and social regeneration of the Isle of Wight. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 0 2001-05-14-265f2269-10064-0
93fe42bca760c68722478320196dc9b0de795f11 Partner in NHS GP practice, Brading, Isle of Wight. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 0 2000-11-10-1f359ece-10064-0
a7090a1f1c0ea513bea4d6387b835ae2786062eb Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 1 2000-11-10-1f359ece-10064-0
01e893f24873e3215618b7b4206d1bbda083aece Occasional fees for speaking at various medical conferences in the UK. The fees are paid as a donation to my local constituency party. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 2 2000-11-10-1f359ece-10064-0
dc520018b1b86a7945ede250cf40496d326ccc88 Honorary membership of Royal Solent Yacht Club. Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 0 2000-11-10-84642823-10064-0
0a501aa95a10ea6cbf4555ed2384ed79838e1157 Honorary membership of Seaview Sailing Club. Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 1 2000-11-10-84642823-10064-0
f7e8882548e3ddf0fd3cc451f2531e5259345bb8 Honorary membership of Ryde Rowing Club. Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 2 2000-11-10-84642823-10064-0
1ddcd7dd2dbd3fddb58811503185f7fd57fe770b Honorary membership of Bembridge Sailing Club. Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 3 2000-11-10-84642823-10064-0
9289caafe60f6b3c17273cbd3c6ae8f842057a95 1-2 October 1999, to Helsinki to attend Europe Blanche XXI colloquium entitled 'Cost Containment Strategies in Health Care in Europe'. Travel and accommodation expenses paid by the Institut de la Santé. (Registered 18 October 1999) Overseas visits 80ef1083 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 0 2000-11-10-80ef1083-10064-0
a64256ecccc069ac77257b408b28477a1ee3c82d 15-17 March 2000, British-Netherlands All-Party Parliamentary Group visit to the Netherlands Second Chamber at the Hague. Travel paid by Group from funds donated by declared sponsors, namely Royal Dutch Shell, Unilever and Reid Elsevier. All other expenses met by the Second Chamber. (Registered 5 March 2000) Overseas visits 80ef1083 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 1 2000-11-10-80ef1083-10064-0
3fec77c831d714d5a50fb48a4f1c262c2492424e 16-17 October 2000, to Denmark with the Associate Parliamentary Renewable and Sustainable Energy Group (PRASEG) to witness the Danish Wind Farm Sector and meet with senior members of the Danish Government Energy Agency and the Danish Wind Industry. Flight and accommodation paid for by National Wind Power UK. (Registered 31 October 2000) Overseas visits 80ef1083 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 2 2000-11-10-80ef1083-10064-0
3802f8f0a296e41617986b4f6a0c9c195c6dee79 Beechgrove Surgery, Brading, Isle of Wight. Land and Property 4f1e6359 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 0 2000-11-10-4f1e6359-10064-0
53052b42552a4bc027d76a30c68c3967c1bf750c Beechgrove Lake Surgery, Lake, Isle of Wight. Land and Property 4f1e6359 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 1 2000-11-10-4f1e6359-10064-0
280f254b2daa1ab8a10b0b9406986cec1273aa95 Both properties owned jointly with my wife, Dr. Jane Brand, and partner, Dr. Richard Loach. Land and Property 4f1e6359 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 2 2000-11-10-4f1e6359-10064-0
dcb244ca1c6846fe976d942215609b4c99c2acaa Director (unremunerated) of the Isle of Wight Partnership, which is concerned with the economic and social regeneration of the Isle of Wight. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Peter Brand uk.org.publicwhip/member/64 Peter Brand uk.org.publicwhip/person/10064 0 2000-11-10-265f2269-10064-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 17.067ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette