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

20 rows where person_id = "uk.org.publicwhip/person/10407" sorted by date descending

View and edit SQL

Suggested facets: item, category_id, date, member_id, 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
84459d0137edca905fe0ac506f77bec6bbe1a973 Member of Harris Parliamentary Panel. (£1-£1,000) . Fees are paid to organisations nominated by me. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Alice Mahon uk.org.publicwhip/member/407 Alice Mahon uk.org.publicwhip/person/10407 0 2001-05-14-1f359ece-10407-0
4de7ee394bf2d415a217ca89fc155b70cfbcc5cc Some fees from media work. The fees are paid to organisations nominated by me. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Alice Mahon uk.org.publicwhip/member/407 Alice Mahon uk.org.publicwhip/person/10407 1 2001-05-14-1f359ece-10407-0
ad76be5b4c66d0e04973290b940c0dca91b2f691 20-27 April 2000, to Egypt, with my husband, at the invitation and expense of the Egyptian Government. (Registered 15 May 2000) Overseas visits 80ef1083 2001-05-14 Alice Mahon uk.org.publicwhip/member/407 Alice Mahon uk.org.publicwhip/person/10407 0 2001-05-14-80ef1083-10407-0
3dc5fae4edc42f2e8c994f15987249e8ef313584 Member of Harris Parliamentary Panel. (£1-£1,000) . Fees are paid to organisations nominated by me. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Alice Mahon uk.org.publicwhip/member/407 Alice Mahon uk.org.publicwhip/person/10407 0 2000-11-10-1f359ece-10407-0
f670600f935afb3275fdbf14b12fd386cdf94d0e Some fees from media work. The fees are paid to organisations nominated by me. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Alice Mahon uk.org.publicwhip/member/407 Alice Mahon uk.org.publicwhip/person/10407 1 2000-11-10-1f359ece-10407-0
5ba34e7a86e4990606679081fe9fc88eae94d584 17-19 April, to Yugoslavia, part of my expenses paid for by the Daily Mirror. I paid the remainder myself. (Registered 21 April 1999) Overseas visits 80ef1083 2000-11-10 Alice Mahon uk.org.publicwhip/member/407 Alice Mahon uk.org.publicwhip/person/10407 0 2000-11-10-80ef1083-10407-0
58fee0d8a3d7b77e032b1c80b477d41522694d5b 10-14 October 1999, to Bahrain, accompanied by my spouse, for study tour at the invitation and expense of the Gulf Centre for Strategic Studies. (Registered 10 November 1999) Overseas visits 80ef1083 2000-11-10 Alice Mahon uk.org.publicwhip/member/407 Alice Mahon uk.org.publicwhip/person/10407 1 2000-11-10-80ef1083-10407-0
be8b3bbdf7781e6ac8cbc047bd3aeb3e99263f85 20-27 April 2000, to Egypt, with my husband, at the invitation and expense of the Egyptian Government. (Registered 15 May 2000) Overseas visits 80ef1083 2000-11-10 Alice Mahon uk.org.publicwhip/member/407 Alice Mahon uk.org.publicwhip/person/10407 2 2000-11-10-80ef1083-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");