items

Table actions

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

7 rows where record_id = "2015-03-30-80ef1083-24950-1" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
37ab60f3fcd46925cbc5d5104df49ae9d3b6ff03 Name of donor: (1) Chinese for Labour and (2) Labour Finance and Industry Group Overseas visits 80ef1083 2015-03-30 Chuka Umunna uk.org.publicwhip/member/40588 Chuka Umunna uk.org.publicwhip/person/24950 0 2015-03-30-80ef1083-24950-1
8f996fd8c2cad8078e511b9374a440081c71c671 Address of donor: (1) PO Box 277, Didcot OX11 1DR; (2) One Brewers Green, London SW1H 0RH Overseas visits 80ef1083 2015-03-30 Chuka Umunna uk.org.publicwhip/member/40588 Chuka Umunna uk.org.publicwhip/person/24950 1 2015-03-30-80ef1083-24950-1
5b4071673607f5cd81674deeea3d720d88072713 Amount of donation (or estimate of the probable value): for myself and my Chief Political Adviser: £3,980 for flights, accommodation, and other disbursements; (2) £1,101.16 towards for flights, accommodation, and other disbursements; total £5,081.16 Overseas visits 80ef1083 2015-03-30 Chuka Umunna uk.org.publicwhip/member/40588 Chuka Umunna uk.org.publicwhip/person/24950 2 2015-03-30-80ef1083-24950-1
05762b55052d76807a5fef9a38cf140042351b7a Destination of visit: China Overseas visits 80ef1083 2015-03-30 Chuka Umunna uk.org.publicwhip/member/40588 Chuka Umunna uk.org.publicwhip/person/24950 3 2015-03-30-80ef1083-24950-1
bf9a4b0a55d309dec5b18fadf03d36b408af59ec Date of visit: 23-26 July 2013 Overseas visits 80ef1083 2015-03-30 Chuka Umunna uk.org.publicwhip/member/40588 Chuka Umunna uk.org.publicwhip/person/24950 4 2015-03-30-80ef1083-24950-1
8073ffbc3f5ccda2e935ee04dfd241c65c031f16 Purpose of visit: Business delegation to China to involve strengthening and developing links, meeting senior officials and business leaders, and attend the '2013 Cooperation and Understanding Dialogue' conference Overseas visits 80ef1083 2015-03-30 Chuka Umunna uk.org.publicwhip/member/40588 Chuka Umunna uk.org.publicwhip/person/24950 5 2015-03-30-80ef1083-24950-1
a360aa12f18c290a1500df5f4575d5701cb34048 (Registered 31 July 2013; updated 20 May 2014) Overseas visits 80ef1083 2015-03-30 Chuka Umunna uk.org.publicwhip/member/40588 Chuka Umunna uk.org.publicwhip/person/24950 6 2015-03-30-80ef1083-24950-1

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");