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

10 rows where person_id = "uk.org.publicwhip/person/10044" sorted by date descending

View and edit SQL

Suggested facets: item, category_id, member_id, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
e6e9f6f82bb32d7924859574f51bc94946143840 Premises provided by Leeds City Council at a peppercorn rent for use as my constituency office. The Council does not pay running and maintenance costs. Sponsorship or financial or material support 9e46def6 2004-12-03 Harold Best uk.org.publicwhip/member/733 Harold Best uk.org.publicwhip/person/10044 0 2004-12-03-9e46def6-10044-0
84a084979cad7bf9c079d18391fd0e018b821c46 Premises provided by Leeds City Council at a peppercorn rent for use as my constituency office. The Council does not pay running and maintenance costs. Sponsorship or financial or material support 9e46def6 2004-10-22 Harold Best uk.org.publicwhip/member/733 Harold Best uk.org.publicwhip/person/10044 0 2004-10-22-9e46def6-10044-0
b2ec4988b8cc48b70d9403620b59d54f842915ce Premises provided by Leeds City Council at a peppercorn rent for use as my constituency office. The Council does not pay running and maintenance costs. Sponsorship or financial or material support 9e46def6 2004-09-08 Harold Best uk.org.publicwhip/member/733 Harold Best uk.org.publicwhip/person/10044 0 2004-09-08-9e46def6-10044-0
533e32248940468b471a73a7da2b3c946d10c2b0 Premises provided by Leeds City Council at a peppercorn rent for use as my constituency office. The Council does not pay running and maintenance costs. Sponsorship or financial or material support 9e46def6 2004-07-16 Harold Best uk.org.publicwhip/member/733 Harold Best uk.org.publicwhip/person/10044 0 2004-07-16-9e46def6-10044-0
884c51c1534da9b2e653c1989b2f0d7d4507eb5a Premises provided by Leeds City Council at a peppercorn rent for use as my constituency office. The Council does not pay running and maintenance costs. Sponsorship or financial or material support 9e46def6 2004-05-21 Harold Best uk.org.publicwhip/member/733 Harold Best uk.org.publicwhip/person/10044 0 2004-05-21-9e46def6-10044-0
666ff7156cd0a4db9ff1b039000b800f9e1b5c27 Premises provided by Leeds City Council at a peppercorn rent for use as my constituency office. The Council does not pay running and maintenance costs. Sponsorship or financial or material support 9e46def6 2004-01-31 Harold Best uk.org.publicwhip/member/733 Harold Best uk.org.publicwhip/person/10044 0 2004-01-31-9e46def6-10044-0
7841e4d821d4e27a08b64373ab3fabc2e7b16a2a Premises provided by Leeds City Council at a peppercorn rent for use as my constituency office. The Council does not pay running and maintenance costs. Sponsorship or financial or material support 9e46def6 2003-12-04 Harold Best uk.org.publicwhip/member/733 Harold Best uk.org.publicwhip/person/10044 0 2003-12-04-9e46def6-10044-0
a22b948b728aebc3fa39278edd934f9db4f5b74e Premises provided by Leeds City Council at a peppercorn rent for use as my constituency office. The Council does not pay running and maintenance costs. Sponsorship or financial or material support 9e46def6 2002-11-26 Harold Best uk.org.publicwhip/member/733 Harold Best uk.org.publicwhip/person/10044 0 2002-11-26-9e46def6-10044-0
7d0c714c09d4b5cbb51c1e46bdffd56fe9e9fa1a Free loan of computer equipment with associated computer support services and access to the Council's intranet provided by Leeds City Council solely for the benefit of constituents. [Received from 2000] Sponsorship or financial or material support 9e46def6 2002-05-14 Harold Best uk.org.publicwhip/member/733 Harold Best uk.org.publicwhip/person/10044 0 2002-05-14-9e46def6-10044-0
4c31613c12281def751f935ce381222597a8c5ac Between 28 March 1999 and 29 April 2000 I received complimentary tickets from the Rugby Football League for four matches in which Leeds Rugby Club were playing. (Registered 11 January 2001) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Harold Best uk.org.publicwhip/member/44 Harold Best uk.org.publicwhip/person/10044 0 2001-05-14-84642823-10044-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");