items

Table actions

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

1 row where record_id = "2019-10-21-891eb863-24798-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
1b7a25d74d2ca13064a99a7db25896e31a79bd59 Name of donor: European Parliamentary Forum on Sexual and Reproductive Health Address of donor: 23 Rue Montoyer, 1000 Brussels, Belgium Estimate of the probable value (or amount of any donation): Flights costing £915.72; accommodation costing £740; food, travel, subsistence, per diems and incidentals, £1,107.28; total value £2,763 Destination of visit: Dhaka and Cox Bazar, Bangladesh Dates of visit: 12-20 September 2019 Purpose of visit: APPG on Population, Development and Reproductive Health study tour to gain insight into sexual and reproductive health and rights service provisions in Bangladesh. (Registered 14 October 2019) Visits outside the UK 891eb863 2019-10-21   Nicholas Dakin uk.org.publicwhip/person/24798 0 2019-10-21-891eb863-24798-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");