home / regmem

items

Data source: mySociety Data

10 rows where member_id = "uk.org.publicwhip/member/1044"

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
25b16effe846f7f9bd4e3a0c4d70e88f7a482732 Penmarric plc. (October 2004) Sponsorship or financial or material support 9e46def6 2005-04-11 uk.org.publicwhip/member/1044 Ivan Lewis uk.org.publicwhip/person/10357 2 2005-04-11-9e46def6-10357-0
2afbf5668428feac8ffd357233f0a24d8dea3036 My constituency party organisation has received registrable donations from: Sponsorship or financial or material support 9e46def6 2005-01-28 uk.org.publicwhip/member/1044 Ivan Lewis uk.org.publicwhip/person/10357 0 2005-01-28-9e46def6-10357-0
68102c645d0fc9b9a88212bd8ab586aa078ba2b6 (Registered 10 January 2005) Sponsorship or financial or material support 9e46def6 2005-04-11 uk.org.publicwhip/member/1044 Ivan Lewis uk.org.publicwhip/person/10357 3 2005-04-11-9e46def6-10357-0
6ebe1714c6c41c9c8e2657f84efd9b3e33f40c82 16-19 January 2005, to Israel and the Palestinian Territories with Labour Friends of Israel, to meet members of the Israeli Government and Parliament; Israel Labour Party activists, representatives of the military, HM Government representatives, the Palestinian Authority and Legislative Council and grassroots organisations. Travel and hospitality paid for by Labour Friends of Israel. Accommodation paid for by Labour Friends of Israel at a rate discounted through the Israeli Ministry of Foreign Affairs, who provided some hospitality (meals). Travel within Israel provided by the Israeli Ministry of Foreign Affairs and Labour Friends of Israel. (Registered 18 January 2005) Overseas visits 80ef1083 2005-01-28 uk.org.publicwhip/member/1044 Ivan Lewis uk.org.publicwhip/person/10357 0 2005-01-28-80ef1083-10357-0
70d41505bc1b098b8aa7cf849ee1ea9f88b12d8f Broome & Wellington (July 2004) Sponsorship or financial or material support 9e46def6 2005-01-28 uk.org.publicwhip/member/1044 Ivan Lewis uk.org.publicwhip/person/10357 1 2005-01-28-9e46def6-10357-0
8f5568be599239c648404bae33805ffc8982aa59 16-19 January 2005, to Israel and the Palestinian Territories with Labour Friends of Israel, to meet members of the Israeli Government and Parliament; Israel Labour Party activists, representatives of the military, HM Government representatives, the Palestinian Authority and Legislative Council and grassroots organisations. Travel and hospitality paid for by Labour Friends of Israel. Accommodation paid for by Labour Friends of Israel at a rate discounted through the Israeli Ministry of Foreign Affairs, who provided some hospitality (meals). Travel within Israel provided by the Israeli Ministry of Foreign Affairs and Labour Friends of Israel. (Registered 18 January 2005) Overseas visits 80ef1083 2005-04-11 uk.org.publicwhip/member/1044 Ivan Lewis uk.org.publicwhip/person/10357 0 2005-04-11-80ef1083-10357-0
b7ca67ab4611953cafe578779679f4146ed5e45a My constituency party organisation has received registrable donations from: Sponsorship or financial or material support 9e46def6 2005-04-11 uk.org.publicwhip/member/1044 Ivan Lewis uk.org.publicwhip/person/10357 0 2005-04-11-9e46def6-10357-0
dd8e39eccaf0f517c9c66b91c09f184c21caf3a2 (Registered 10 January 2005) Sponsorship or financial or material support 9e46def6 2005-01-28 uk.org.publicwhip/member/1044 Ivan Lewis uk.org.publicwhip/person/10357 3 2005-01-28-9e46def6-10357-0
df2c27d970724cf4c4402fe3e170920b203293d7 Broome & Wellington (July 2004) Sponsorship or financial or material support 9e46def6 2005-04-11 uk.org.publicwhip/member/1044 Ivan Lewis uk.org.publicwhip/person/10357 1 2005-04-11-9e46def6-10357-0
fd9132e490d412a3c310fb36e9d59425523ab087 Penmarric plc. (October 2004) Sponsorship or financial or material support 9e46def6 2005-01-28 uk.org.publicwhip/member/1044 Ivan Lewis uk.org.publicwhip/person/10357 2 2005-01-28-9e46def6-10357-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 6.195ms · Data source: mySociety Data