items

Table actions

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

2 rows where record_id = "2000-11-10-80ef1083-10541-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
3868963cbc40db1567bd6e7d2d39122b32563cd5 10 September 1999, to Portugal with the Parliamentary Football Team, travel costs met by National Express Ltd., cost of football kit met by Spall Sports. (Registered 19 January 2000) Overseas visits 80ef1083 2000-11-10 Alan Simpson uk.org.publicwhip/member/541 Alan Simpson uk.org.publicwhip/person/10541 0 2000-11-10-80ef1083-10541-0
1b73c98cf82cec6d879729c5e2b27e201ab54b0c 23-27 February 2000, to Washington, USA, to speak at a conference on Damages and Liabilities Related to GMO foods organised by the American Consumer Choice Council who paid all flight and accommodation costs. No fee received. I also had meetings with the American Corn Growers Association and the lawyers involved in the law suit against Monsanto relating to GMO liabilities and breach of anti-trust legislation. (Registered 10 March 2000) Overseas visits 80ef1083 2000-11-10 Alan Simpson uk.org.publicwhip/member/541 Alan Simpson uk.org.publicwhip/person/10541 1 2000-11-10-80ef1083-10541-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");