items

Table actions

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

2 rows where record_id = "2016-02-08-891eb863-24898-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
30393d19f7c4bf499f8798d2710cfa3605b6721a Name of donor: Results UK Address of donor: 31-33 Bondway, London SW8 1SJ Amount of donation (or estimate of the probable value): accommodation, flights, in-country transport and food, valued at £1,700 in total Destination of visit: Zambia Date of visit: 2 to 7 August 2015 Purpose of visit: Parliamentary delegation to gain insight into how Zambia is addressing major health challenges. (Registered 04 September 2015) Visits outside the UK 891eb863 2016-02-08   Oliver Colvile uk.org.publicwhip/person/24898 0 2016-02-08-891eb863-24898-0
4c11b869bb698de366906c0046da1b302297eb40 Name of donor: Jamaica Tourist Board Address of donor: 1-2 Prince Consort Road, London SW7 2BZ Amount of donation (or estimate of the probable value): air travel and accommodation with an approximate value of £1,824 Destination of visit: St Elizabeth Parish, Jamaica Date of visit: 24 September 2015 - 1 October 2015 Purpose of visit: to visit the ‘Breds Foundation’ Community Project, a Lords and Commons All Party Cricket sponsored project, in order to donate sports and grounds equipment. Visit also included talks with ministers, school visits and cricket games. (Registered 30 October 2015) Visits outside the UK 891eb863 2016-02-08   Oliver Colvile uk.org.publicwhip/person/24898 1 2016-02-08-891eb863-24898-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");