items

Table actions

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

5 rows where record_id = "2016-11-21-891eb863-11858-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
612d69b0552ad59901ed65a1faad096835a4d9fa The four entries below relate to a single visit to New York undertaken between 26 March and 2 April 2016. Visits outside the UK 891eb863 2016-11-21   Michael Gove uk.org.publicwhip/person/11858 0 2016-11-21-891eb863-11858-0
feff507c12ccadd171ac735a96f79c2e677889fa Name of donor: The Algemeiner Journal Address of donor: P.O. Box 250746 Brooklyn, NY 11225 Amount of donation (or estimate of the probable value): for my family, a member of staff and myself, taxis £124; flights £2,525; on 28 March 2016, a dinner £856; plus accommodation for a member of staff £412; total value £3,917 Destination of visit: New York Date of visit: 26 March – 2 April 2016 Purpose of visit: To receive an award at The Algemeiner Journal Anniversary event. (Registered 29 April 2016) Visits outside the UK 891eb863 2016-11-21   Michael Gove uk.org.publicwhip/person/11858 1 2016-11-21-891eb863-11858-0
ba2a8a4ccd6497f3f3b47daf11a281b86be16bee Name of donor: The Henry Jackson Society Address of donor: 21-24 Millbank Tower, Millbank, London SW1P 4QP Amount of donation (or estimate of the probable value): accommodation for my family and myself with a value of £2,764 Date of visit: 26th March – 2nd April, 2016 Purpose of visit: To receive an award at The Algemeiner Journal Anniversary event and attend events organised by the Henry Jackson Society. (Registered 29 April 2016) Visits outside the UK 891eb863 2016-11-21   Michael Gove uk.org.publicwhip/person/11858 2 2016-11-21-891eb863-11858-0
f9cbe7d9138783eb7eb6653464ec2050698334f9 Name of donor: The Lisa and Michael Leffell Foundation Address of donor: 600 Madison Avenue, 20th Floor, New York, NY 10022 Amount of donation (or estimate of the probable value): on 30 March 2016, lunch for a member of staff and myself with a value of £185 Destination of visit: New York Date of visit: 26 March – 2 April 2016 Purpose of visit: Hospitality received during the course of a visit to receive an award at The Algemeiner Journal Anniversary event and attend events organised by the Henry Jackson Society. (Registered 29 April 2016) Visits outside the UK 891eb863 2016-11-21   Michael Gove uk.org.publicwhip/person/11858 3 2016-11-21-891eb863-11858-0
10d8b6c073387ece6e2948bca5b4804328f84ff8 Name of donor: Alisa Swidler Address of donor: private Amount of donation (or estimate of the probable value): on 30 March 2016, dinner for a member of staff and myself with a value of £205 Destination of visit: New York Date of visit: 26 March – 2 April 2016 Purpose of visit: Hospitality received during the course of a visit to receive an award at The Algemeiner Journal Anniversary event and attend events organised by the Henry Jackson Society. (Registered 29 April 2016) Visits outside the UK 891eb863 2016-11-21   Michael Gove uk.org.publicwhip/person/11858 4 2016-11-21-891eb863-11858-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");