items

Table actions

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

2 rows where record_id = "2016-03-21-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
ea488e16c32cdaac84c7b1e182e32f9da4636a5c 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-03-21   Oliver Colvile uk.org.publicwhip/person/24898 0 2016-03-21-891eb863-24898-0
18b2e80e1575b112b089c3454b532cb81d21a122 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-03-21   Oliver Colvile uk.org.publicwhip/person/24898 1 2016-03-21-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");