home / regmem

items

Data source: mySociety Data

7 rows where record_id = "2011-01-24-80ef1083-10076-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
d338d2f45879a7225f0256a24b965960280c59ed Name of donor: Sir Joseph Hotung Programme Overseas visits 80ef1083 2011-01-24 uk.org.publicwhip/member/40085 Richard Burden uk.org.publicwhip/person/10076 0 2011-01-24-80ef1083-10076-0
63ef2c57f8889d593dc25917a5cbd72bf49df8d9 Address of donor: School of Oriental and African Studies, Thornhaugh Street, Russell Square, London WC1H 0XG Overseas visits 80ef1083 2011-01-24 uk.org.publicwhip/member/40085 Richard Burden uk.org.publicwhip/person/10076 1 2011-01-24-80ef1083-10076-0
c0d2a277a213624b77c583255c2259aad0be2992 Amount of donation (or estimate of the probable value): £1,000 Overseas visits 80ef1083 2011-01-24 uk.org.publicwhip/member/40085 Richard Burden uk.org.publicwhip/person/10076 2 2011-01-24-80ef1083-10076-0
0003046457e7d5d048ffb04f347f20e786d36984 Destination of visit: West Bank, Palestine Overseas visits 80ef1083 2011-01-24 uk.org.publicwhip/member/40085 Richard Burden uk.org.publicwhip/person/10076 3 2011-01-24-80ef1083-10076-0
fbd8fae90a5a90c75b71a9cb21b5e0b55d51e845 Date of visit: 25-29 November 2010 Overseas visits 80ef1083 2011-01-24 uk.org.publicwhip/member/40085 Richard Burden uk.org.publicwhip/person/10076 4 2011-01-24-80ef1083-10076-0
fcdef02b54f62dff8096040eaba817782407ef2b Purpose of visit: Britain-Palestine APPG delegation Overseas visits 80ef1083 2011-01-24 uk.org.publicwhip/member/40085 Richard Burden uk.org.publicwhip/person/10076 5 2011-01-24-80ef1083-10076-0
8ef89d8fe3f3de10065f44ed099b48f706993bb4 (Registered 20 December 2010) Overseas visits 80ef1083 2011-01-24 uk.org.publicwhip/member/40085 Richard Burden uk.org.publicwhip/person/10076 6 2011-01-24-80ef1083-10076-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 41.573ms · Data source: mySociety Data