items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where member_id = "uk.org.publicwhip/member/353" 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 | 
|---|---|---|---|---|---|---|---|
| 2a0fa5ba67e085a9eefb11f7409ae7301e477c6d | Occasional fees for journalism. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 0 | 2001-05-14-1f359ece-10353-0 | 
| e801cdd4002c580e4185d1427c1d4efe0020c683 | Trustee (unremunerated) of: | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 0 | 2001-05-14-265f2269-10353-0 | 
| ef3f215de80533da61c0bee46db2ac1ce3f3ec74 | Lighthouse Media Training; multi-media training courses. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 1 | 2001-05-14-265f2269-10353-0 | 
| a766e15fbe6ec0a9e5be8cd22803a99f3f8b6bac | Brighton Youth Orchestra. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 2 | 2001-05-14-265f2269-10353-0 | 
| 8d6a1f3cdc6b81c7cfabede012f0911e10fc7d69 | ARDIS; a Brighton-based charity for those with Alzheimer's Disease. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 3 | 2001-05-14-265f2269-10353-0 | 
| cbf020d0cc3118eb94da455bf9dcd1a26fac2474 | Patron of the Sussex Beacon; a Brighton-based charity providing residential care for those with HIV/AIDS. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 4 | 2001-05-14-265f2269-10353-0 | 
| 63470947710cf9bce8b64e0a4316c315dc720920 | Patron of Brighton Cares; a local charity supporting people with HIV/AIDS. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 5 | 2001-05-14-265f2269-10353-0 | 
| d1269c94f9dcee77fdcdf1062ec507ae3af2a94a | Patron of Age Concern Brighton. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 6 | 2001-05-14-265f2269-10353-0 | 
| dd81af0141878368aea24ce778494c3d7fff3948 | Patron of Brighton Dome Appeal; a fund for the restoration of the Dome Concert Hall, Brighton. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 7 | 2001-05-14-265f2269-10353-0 | 
| 3da99289feaa9bb09b3836fb6e3a9941131ec7bf | Member of National Union of Teachers. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 8 | 2001-05-14-265f2269-10353-0 | 
| 49e6035b252377149214f1688d2ad675b6a47a20 | Member of Brighton and Hove Trades and Labour Clubs. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 9 | 2001-05-14-265f2269-10353-0 | 
| 30b01fe3ad39cd2916e6dba336532dbe6d063f77 | Honorary President of Brighton and Hove Petanque Club. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 10 | 2001-05-14-265f2269-10353-0 | 
| a77f3106e1a605b937daf0883fb647eb7a1cc4a4 | Patron of Cruse, Brighton and Hove. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 11 | 2001-05-14-265f2269-10353-0 | 
| 40b8bcf9d0254e656f639081cdee1d968ac6d4bd | Patron Sussex ME Association. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 12 | 2001-05-14-265f2269-10353-0 | 
| 3a3c03fd88616cfe2551a627700e059b3b334aee | Member of the Council of Brighton Festival. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 13 | 2001-05-14-265f2269-10353-0 | 
| c817ca8ae3760cd36992c89259ba31200182a1ff | Patron of Body Positive, a local AIDS/HIV charity. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 14 | 2001-05-14-265f2269-10353-0 | 
| 192faea094b0241e3cd30d34b40703506815e19a | Chair of Friends of Brighton and Hove Foyer. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 15 | 2001-05-14-265f2269-10353-0 | 
| cf805619841223f6bd5041eb3ee45ab447062d77 | Occasional fees for journalism. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 0 | 2000-11-10-1f359ece-10353-0 | 
| 007cda00a0e80e16ae7f1d368ab90c70864fc017 | 28-29 January 1999, visit by the Parliamentary Beer Club Licensing Law Reform Panel to Edinburgh. All costs of travel, hotel and subsistence borne by the Club. (Registered 15 February 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 0 | 2000-11-10-84642823-10353-0 | 
| 1233ec7885bf20373e5d1a1dd684fdb216177d03 | Trustee (unremunerated) of: | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 0 | 2000-11-10-265f2269-10353-0 | 
| 0eb8d4f7ba7a8d399c687691f6e10360b7207976 | Lighthouse Media Training; multi-media training courses. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 1 | 2000-11-10-265f2269-10353-0 | 
| 9acba46beec40f38a08521e6de6540577dca61d9 | Brighton Youth Orchestra. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 2 | 2000-11-10-265f2269-10353-0 | 
| fa4238504943c8640a26fe582bd3862ba6db6925 | ARDIS; a Brighton-based charity for those with Alzheimer's Disease. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 3 | 2000-11-10-265f2269-10353-0 | 
| 31f23e6a3781e3dd69f8e2468f368156bb9d2033 | Patron of the Sussex Beacon; a Brighton-based charity providing residential care for those with HIV/AIDS. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 4 | 2000-11-10-265f2269-10353-0 | 
| 4ad5b06c5e1f7d2d89cd58280e063331610e1e68 | Patron of Brighton Cares; a local charity supporting people with HIV/AIDS. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 5 | 2000-11-10-265f2269-10353-0 | 
| f6eff76d008775e28a21804645fae66b78cda715 | Patron of Age Concern Brighton. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 6 | 2000-11-10-265f2269-10353-0 | 
| f5107415cd5666e79f151f698cfca1be3a6ff3fb | Patron of Brighton Dome Appeal; a fund for the restoration of the Dome Concert Hall, Brighton. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 7 | 2000-11-10-265f2269-10353-0 | 
| f575a634ca21581bed0a22520a077b2b723c229d | Member of National Union of Teachers. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 8 | 2000-11-10-265f2269-10353-0 | 
| 1a470106138a4148f288dc2479c2824aa5c36163 | Member of Brighton and Hove Trades and Labour Clubs. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 9 | 2000-11-10-265f2269-10353-0 | 
| ddf9e5d1c8d873fc3df0f4d4729ec104b01d0785 | Honorary President of: | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 10 | 2000-11-10-265f2269-10353-0 | 
| 09c7acea07f39430a66f8bab71c82ef4422a7fd3 | Brighton and Hove Petanque Club. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lepper uk.org.publicwhip/member/353 | David Lepper uk.org.publicwhip/person/10353 | 11 | 2000-11-10-265f2269-10353-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");