home / regmem

items

Data source: mySociety Data

6 rows where person_id = "uk.org.publicwhip/person/10024"

View and edit SQL

Suggested facets: item, category_id, date, sort_order, record_id

hash item category_id date member_id person_id sort_order record_id
3563afaa9ca6211ae80ddd6d45d4b22316830353 Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000). The fees are paid direct to the Harry Burden Trust Fund, a charity. Remunerated employment, office, profession etc 1f359ece 2000-11-10 uk.org.publicwhip/member/24 Jackie Ballard uk.org.publicwhip/person/10024 1 2000-11-10-1f359ece-10024-0
5703a79500715c97e0f5582c3cd4c887692b47e4 I received a donation of £4000 from Jane McTaggart towards my campaign for leader of the Liberal Democrats in 1999. Sponsorship or financial or material support 9e46def6 2001-05-14 uk.org.publicwhip/member/24 Jackie Ballard uk.org.publicwhip/person/10024 0 2001-05-14-9e46def6-10024-0
6e4c01cf60f53fc91b3410ed4bc54b2271b80fc3 Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000). The fees are paid direct to the Harry Burden Trust Fund, a charity. Remunerated employment, office, profession etc 1f359ece 2001-05-14 uk.org.publicwhip/member/24 Jackie Ballard uk.org.publicwhip/person/10024 1 2001-05-14-1f359ece-10024-0
76c79431e50d4f84fe2465d456dd99decd817f56 I received a donation of £4000 from Jane McTaggart towards my campaign for leader of the Liberal Democrats in 1999. Sponsorship or financial or material support 9e46def6 2000-11-10 uk.org.publicwhip/member/24 Jackie Ballard uk.org.publicwhip/person/10024 0 2000-11-10-9e46def6-10024-0
b64a52e5c2fa26dd09d7acf5381da81428767fbd Remuneration for journalism and media appearances. Remunerated employment, office, profession etc 1f359ece 2001-05-14 uk.org.publicwhip/member/24 Jackie Ballard uk.org.publicwhip/person/10024 0 2001-05-14-1f359ece-10024-0
c4ab7619d9cba969c419d00d4b49170a589ee8c2 Remuneration for journalism and media appearances. Remunerated employment, office, profession etc 1f359ece 2000-11-10 uk.org.publicwhip/member/24 Jackie Ballard uk.org.publicwhip/person/10024 0 2000-11-10-1f359ece-10024-0

Advanced export

JSON shape: default, array, 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)
    )
Powered by Datasette · Query took 5.599ms · Data source: mySociety Data