items

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

16 rows where member_id = "uk.org.publicwhip/member/1063" 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
df97d8fe64f5ab726d3d3244c3e58779ad16713a Parliamentary Patron, Women in Business (unremunerated). Miscellaneous and unremunerated interests 265f2269 2005-04-11 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2005-04-11-265f2269-10378-0
04f9ea4c61a4a48a674ab49057e0a8a961f76325 Parliamentary Patron, Women in Business (unremunerated). Miscellaneous and unremunerated interests 265f2269 2005-01-28 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2005-01-28-265f2269-10378-0
f89331a4275f2e40c5d6c646c36d21a27a4d0cb4 Parliamentary Patron, Women in Business (unremunerated). Miscellaneous and unremunerated interests 265f2269 2004-12-03 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2004-12-03-265f2269-10378-0
0723b424ba0de0c127beeb351422c2cdef0ee95b Parliamentary Patron, Women in Business (unremunerated). Miscellaneous and unremunerated interests 265f2269 2004-10-22 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2004-10-22-265f2269-10378-0
02c5198041f35759a72b1a3b5df95213316f4eb3 Parliamentary Patron, Women in Business (unremunerated). Miscellaneous and unremunerated interests 265f2269 2004-09-08 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2004-09-08-265f2269-10378-0
5a5c0b651a0ddbc9f8ea67166bb22fef1bea2224 Parliamentary Patron, Women in Business (unremunerated). Miscellaneous and unremunerated interests 265f2269 2004-07-16 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2004-07-16-265f2269-10378-0
7866a6f50306c28cdae5007a9b05af980d4848d4 Parliamentary Patron, Women in Business (unremunerated). Miscellaneous and unremunerated interests 265f2269 2004-05-21 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2004-05-21-265f2269-10378-0
1fe7509d28ce9439c2167f943e659cd602846d1e Parliamentary Patron, Women in Business (unremunerated). Miscellaneous and unremunerated interests 265f2269 2004-01-31 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2004-01-31-265f2269-10378-0
12f6cffc9fcde70aeb486709e2ce189d7add190f Parliamentary Patron, Women in Business (unremunerated). Miscellaneous and unremunerated interests 265f2269 2003-12-04 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2003-12-04-265f2269-10378-0
1f839236f67de3d7bbb435fc6765e10645bd5933 15-20 September 2002, study tour to Bahrain, accompanied by my spouse. Our air travel and hotel accommodation was paid for by the Gulf Centre for Strategic Studies and the Bahrain Government. (Registered 21 October 2002) Overseas visits 80ef1083 2002-11-26 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2002-11-26-80ef1083-10378-0
ad4500fdaa932886b87040beea9b4f3793c435d6 Parliamentary Patron, Women in Business (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-11-26 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2002-11-26-265f2269-10378-0
fefbadde4b31b11efff4a041e5b0fe3958e6bd3f Occasional fees for opinion surveys from Opinion Leader and MORI. All fees donated to Calder Valley Constituency Labour Party. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2002-05-14-1f359ece-10378-0
1fd3caa0db82d957d5cfff08df0d233f273edb2a House and shop in Todmorden from which rental income is received. Land and Property 4f1e6359 2002-05-14 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2002-05-14-4f1e6359-10378-0
06c2f9d4c1bdf751b9fb3015e98b9ca4725c1c46 Maisonette in Hebden Bridge. Land and Property 4f1e6359 2002-05-14 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 1 2002-05-14-4f1e6359-10378-0
9b8b7258a001dd494723a336b1ff21a679f688b7 Constituency office in Hebden Bridge. Land and Property 4f1e6359 2002-05-14 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 2 2002-05-14-4f1e6359-10378-0
c7216c312bd06d161911706a02d9351e7cee878c Parliamentary Patron, Women in Business in the Arab World (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Chris McCafferty uk.org.publicwhip/member/1063 Chris McCafferty uk.org.publicwhip/person/10378 0 2002-05-14-265f2269-10378-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");
Powered by Datasette · Query took 15.916ms · Data source: mySociety Data · About: simonw/register-of-members-interests