home / regmem

items

Data source: mySociety Data

1 row where record_id = "2009-03-11-80ef1083-11759-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
0005750cf3db77a6b0a2dd837a3fa4f4eb90f95d 7-11 July 2008, to Israel, hosted by Conservative Friends of Israel (CFI), to gain an understanding of the current state of affairs in the region including East Jerusalem, Gaza and the Golan Heights. CFI contributed the cost of flights, accommodation and some meals. The Israeli Ministry of Foreign Affairs (Official Guests Department) contributed to the costs of travel inside Israel, some accommodation and meals. (Registered 14 July 2008) Overseas visits 80ef1083 2009-03-11 uk.org.publicwhip/member/1759 Stewart Jackson uk.org.publicwhip/person/11759 0 2009-03-11-80ef1083-11759-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.122ms · Data source: mySociety Data