items

Table actions

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

8 rows where record_id = "2010-03-24-80ef1083-10071-0" 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
dbc558feb5bc9ffe3f1ba2316f17129f1f43a8fc 15-18 April 2009, to Rome, to attend and speak at a conference on nuclear non-proliferation and disarmament, at the invitation of the Italian Ministry of Foreign Affairs, the Nuclear Security Project and the World Political Forum, who jointly ran the conference. My return flights and accommodation in Rome were paid for by the Nuclear Threat Initiative. (Registered 7 May 2009) Overseas visits 80ef1083 2010-03-24 Des Browne uk.org.publicwhip/member/1996 Des Browne uk.org.publicwhip/person/10071 0 2010-03-24-80ef1083-10071-0
3ed7aa81c5f72021234a64bddddea13777ee97a4 Name of donor: British American Security Council Overseas visits 80ef1083 2010-03-24 Des Browne uk.org.publicwhip/member/1996 Des Browne uk.org.publicwhip/person/10071 1 2010-03-24-80ef1083-10071-0
a92d9a88a24a20b779b422f43a1bfd1ccd78e50e Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT Overseas visits 80ef1083 2010-03-24 Des Browne uk.org.publicwhip/member/1996 Des Browne uk.org.publicwhip/person/10071 2 2010-03-24-80ef1083-10071-0
0f221d02e20cc7bb05da2b5aa95d56b6cb05a07c Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) Overseas visits 80ef1083 2010-03-24 Des Browne uk.org.publicwhip/member/1996 Des Browne uk.org.publicwhip/person/10071 3 2010-03-24-80ef1083-10071-0
e93dd0f976a4ca08771105fc933a7b667b1b8948 Destination of visit: Washington DC, US Overseas visits 80ef1083 2010-03-24 Des Browne uk.org.publicwhip/member/1996 Des Browne uk.org.publicwhip/person/10071 4 2010-03-24-80ef1083-10071-0
523ea74718e08af72cd569ce9ee5f4dab41312a0 Date of visit: 8-13 September 2009 Overseas visits 80ef1083 2010-03-24 Des Browne uk.org.publicwhip/member/1996 Des Browne uk.org.publicwhip/person/10071 5 2010-03-24-80ef1083-10071-0
f045a732ef0b83c8e718e085b384a0a5e4b62493 Purpose of visit: As part of a British Parliamentary delegation to meet with the US Administration and Senators and their staff to discuss nuclear proliferation and multi-lateral disarmament. Overseas visits 80ef1083 2010-03-24 Des Browne uk.org.publicwhip/member/1996 Des Browne uk.org.publicwhip/person/10071 6 2010-03-24-80ef1083-10071-0
cec72f46b5bdf624f0f94361a5cd0bf051d5f9b0 (Registered 30 September 2009) Overseas visits 80ef1083 2010-03-24 Des Browne uk.org.publicwhip/member/1996 Des Browne uk.org.publicwhip/person/10071 7 2010-03-24-80ef1083-10071-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");