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

12 rows where member_id = "uk.org.publicwhip/member/1088" 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
bb2f623f2bc646dfb682c2cbb3fb8db37096dfd4 House in Halifax. Land and Property 4f1e6359 2005-04-11 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 0 2005-04-11-4f1e6359-10407-0
f00f9cb4007a8e1f1a832501cc58192dac503ccc House in Halifax. Land and Property 4f1e6359 2005-01-28 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 0 2005-01-28-4f1e6359-10407-0
35b7397a462e9822ca6ae08aef240da13a41cf42 House in Halifax. Land and Property 4f1e6359 2004-12-03 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 0 2004-12-03-4f1e6359-10407-0
6826053e4a61d274759e3a26b94d1b42c0ec4fa5 House in Halifax. Land and Property 4f1e6359 2004-10-22 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 0 2004-10-22-4f1e6359-10407-0
802a59f2f1fe32d9e15976c6612cb120d26ee932 House in Halifax. Land and Property 4f1e6359 2004-09-08 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 0 2004-09-08-4f1e6359-10407-0
f338ec653ea3c5285cda4f1ae686b711dd4e4f41 House in Halifax. Land and Property 4f1e6359 2004-07-16 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 0 2004-07-16-4f1e6359-10407-0
17db26aae74f1cffa48bed1ddb06e326e8f4a1a0 House in Halifax. Land and Property 4f1e6359 2004-05-21 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 0 2004-05-21-4f1e6359-10407-0
e08f110a7b30eb57c474618e656f23c278c7f03a House in Halifax. Land and Property 4f1e6359 2004-01-31 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 0 2004-01-31-4f1e6359-10407-0
95c8fdea27c04356ba39d0f3e2b39510607108cf House in Halifax. Land and Property 4f1e6359 2003-12-04 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 0 2003-12-04-4f1e6359-10407-0
af3dd0bdba2fe201a12a75c746d51cf548aff390 House in Halifax. Land and Property 4f1e6359 2002-11-26 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 0 2002-11-26-4f1e6359-10407-0
12b3a9944fdc226a6b8a3b44707d292aa5531b83 Member of Harris Parliamentary Panel. (£1-£1,000) . Fees are paid to organisations nominated by me. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 0 2002-05-14-1f359ece-10407-0
9cceff7a8017dac2ce709447026353a7017e6641 Some fees from media work. The fees are paid to organisations nominated by me. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Alice Mahon uk.org.publicwhip/member/1088 Alice Mahon uk.org.publicwhip/person/10407 1 2002-05-14-1f359ece-10407-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");