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

8 rows where person_id = "uk.org.publicwhip/person/10090" sorted by date descending

View and edit SQL

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
a59b9376253a8ae417de992d4c9dc2b2c2721172 Occasional payments from public opinion pollsters. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Dale Campbell-Savours uk.org.publicwhip/member/90 Dale Campbell-Savours uk.org.publicwhip/person/10090 0 2001-05-14-1f359ece-10090-0
d323be383272e98fd7cc6e8bc15b839c9f88861e A proportion of the salary of the constituency organiser met by UNISON. Sponsorship or financial or material support 9e46def6 2001-05-14 Dale Campbell-Savours uk.org.publicwhip/member/90 Dale Campbell-Savours uk.org.publicwhip/person/10090 0 2001-05-14-9e46def6-10090-0
b2b6a2e012b896b6a445d51c3e7e4edd213eccef A house in London, and a house in my constituency in the Lake District. Land and Property 4f1e6359 2001-05-14 Dale Campbell-Savours uk.org.publicwhip/member/90 Dale Campbell-Savours uk.org.publicwhip/person/10090 0 2001-05-14-4f1e6359-10090-0
497c21c632132266009cbb2f02b0ea7ef03469bf Occasional payments from public opinion pollsters. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Dale Campbell-Savours uk.org.publicwhip/member/90 Dale Campbell-Savours uk.org.publicwhip/person/10090 0 2000-11-10-1f359ece-10090-0
76cdd52f42963a126db2d742d8f914306ff6fe61 A proportion of the salary of the constituency organiser met by UNISON. Sponsorship or financial or material support 9e46def6 2000-11-10 Dale Campbell-Savours uk.org.publicwhip/member/90 Dale Campbell-Savours uk.org.publicwhip/person/10090 0 2000-11-10-9e46def6-10090-0
ee199cb69cb9f8ffb1bf0d2f32f9579d10cadfb5 17-23 April 1999, to South Korea for the Annual Conference of the Britain-Korea Forum for the Future, paid for by the UK-Korea Forum. (Registered 11 May 1999) Overseas visits 80ef1083 2000-11-10 Dale Campbell-Savours uk.org.publicwhip/member/90 Dale Campbell-Savours uk.org.publicwhip/person/10090 0 2000-11-10-80ef1083-10090-0
1affbc5800ce2f288bf37fdce8311d9cd17d33f4 30 October-6 November 1999, to Turkey, to lecture on constitutional issues, paid for by the National Democratic Institute of Washington. (Registered 30 November 1999) Overseas visits 80ef1083 2000-11-10 Dale Campbell-Savours uk.org.publicwhip/member/90 Dale Campbell-Savours uk.org.publicwhip/person/10090 1 2000-11-10-80ef1083-10090-0
694dbab523f42e130c4dca2db5deb676e596aedc A house in London, and a house in my constituency in the Lake District. Land and Property 4f1e6359 2000-11-10 Dale Campbell-Savours uk.org.publicwhip/member/90 Dale Campbell-Savours uk.org.publicwhip/person/10090 0 2000-11-10-4f1e6359-10090-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");