items

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

9 rows where person_id = "uk.org.publicwhip/person/10350" sorted by date descending

View and edit SQL

Suggested facets: item, member_id, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
817af106ef40f78edee6036ceb06b065cd0323f2 3-12 February 2004, to India, sponsored by Labour Friends of India. Airline tickets and hospitality in India provided by the Confederation of Indian Industry and the Government of India. (Registered 11 May 2004) Overseas visits 80ef1083 2005-04-11 Jackie Lawrence uk.org.publicwhip/member/1035 Jackie Lawrence uk.org.publicwhip/person/10350 0 2005-04-11-80ef1083-10350-0
c9d2529ef1432f26aca30f769ccb32a1ca97ba82 3-12 February 2004, to India, sponsored by Labour Friends of India. Airline tickets and hospitality in India provided by the Confederation of Indian Industry and the Government of India. (Registered 11 May 2004) Overseas visits 80ef1083 2005-01-28 Jackie Lawrence uk.org.publicwhip/member/1035 Jackie Lawrence uk.org.publicwhip/person/10350 0 2005-01-28-80ef1083-10350-0
b33e03ae8308b9bee9ac1e54cff550a0e5e52f85 3-12 February 2004, to India, sponsored by Labour Friends of India. Airline tickets and hospitality in India provided by the Confederation of Indian Industry and the Government of India. (Registered 11 May 2004) Overseas visits 80ef1083 2004-12-03 Jackie Lawrence uk.org.publicwhip/member/1035 Jackie Lawrence uk.org.publicwhip/person/10350 0 2004-12-03-80ef1083-10350-0
38b214c73244ce987b9e97979f13748744c5d472 3-12 February 2004, to India, sponsored by Labour Friends of India. Airline tickets and hospitality in India provided by the Confederation of Indian Industry and the Government of India. (Registered 11 May 2004) Overseas visits 80ef1083 2004-10-22 Jackie Lawrence uk.org.publicwhip/member/1035 Jackie Lawrence uk.org.publicwhip/person/10350 0 2004-10-22-80ef1083-10350-0
9850f974d800419d9ecbbf5034431827962bc6bb 3-12 February 2004, to India, sponsored by Labour Friends of India. Airline tickets and hospitality in India provided by the Confederation of Indian Industry and the Government of India. (Registered 11 May 2004) Overseas visits 80ef1083 2004-09-08 Jackie Lawrence uk.org.publicwhip/member/1035 Jackie Lawrence uk.org.publicwhip/person/10350 0 2004-09-08-80ef1083-10350-0
a10d5f0fcc108f3a7b4e3f398dafac45c91308bf 3-12 February 2004, to India, sponsored by Labour Friends of India. Airline tickets and hospitality in India provided by the Confederation of Indian Industry and the Government of India. (Registered 11 May 2004) Overseas visits 80ef1083 2004-07-16 Jackie Lawrence uk.org.publicwhip/member/1035 Jackie Lawrence uk.org.publicwhip/person/10350 0 2004-07-16-80ef1083-10350-0
d30bfc720f1a5170e9c6c427ac6e17661dd9c414 3-12 February 2004, to India, sponsored by Labour Friends of India. Airline tickets and hospitality in India provided by the Confederation of Indian Industry and the Government of India. (Registered 11 May 2004) Overseas visits 80ef1083 2004-05-21 Jackie Lawrence uk.org.publicwhip/member/1035 Jackie Lawrence uk.org.publicwhip/person/10350 0 2004-05-21-80ef1083-10350-0
30828af88e2f21b41ca4d9868a4e40709243c57b 16-17 October 2000, to Denmark as part of delegation from Parliamentary Renewable and sustainable Energy Group, funded by National Windpower. (Registered 25 October 2000) Overseas visits 80ef1083 2001-05-14 Jackie Lawrence uk.org.publicwhip/member/350 Jackie Lawrence uk.org.publicwhip/person/10350 0 2001-05-14-80ef1083-10350-0
b22f54f194f4cfe7af5124c42204985b5b556538 16-17 October 2000, to Denmark as part of delegation from Parliamentary Renewable and sustainable Energy Group, funded by National Windpower. (Registered 25 October 2000) Overseas visits 80ef1083 2000-11-10 Jackie Lawrence uk.org.publicwhip/member/350 Jackie Lawrence uk.org.publicwhip/person/10350 0 2000-11-10-80ef1083-10350-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");
Powered by Datasette · Query took 19.166ms · Data source: mySociety Data · About: simonw/register-of-members-interests