items

Table actions

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

1 row where record_id = "2007-11-06-80ef1083-10437-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
0396c65a796355c3f0a3188dcc86f98d3cab0e85 7-14 February 2007, to Pakistan on a fact-finding visit to investigate UK-Pakistan relations; women's rights and development, education and the spending of development aid in Pakistan (especially Kashmir). Return flight to Islamabad paid for by Mr Javid Majid (Chair, Tall Trees Hotel, Yarm); Mr Nas Khan (Managing Director, Jennings Ford Middlesbrough) and Mr Nasser Din (Managing Director, Supreme Property Developments, Stockton on Tees). Accommodation, car transportation and expenses in Pakistan paid for by Mr Javid Majid and Mr M Akram Farid (Chief Executive, Hotel Crown Plaza, Islamabad). (Registered 28 February 2007) Overseas visits 80ef1083 2007-11-06 Laura Moffatt uk.org.publicwhip/member/1519 Laura Moffatt uk.org.publicwhip/person/10437 0 2007-11-06-80ef1083-10437-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");