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

11 rows where member_id = "uk.org.publicwhip/member/1146" sorted by date descending

View and edit SQL

Suggested facets: item, category_id, date, sort_order, record_id, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
6af8d8f144f6c308ff3abd9098e90d746272c009 3-12 February 2004, to India as part of a delegation 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 20 February 2004) Overseas visits 80ef1083 2005-01-28 Sandra Osborne uk.org.publicwhip/member/1146 Sandra Osborne uk.org.publicwhip/person/10467 0 2005-01-28-80ef1083-10467-0
ea306a7e32c454723e24cceb4bddab76046a8d21 3-12 February 2004, to India as part of a delegation 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 20 February 2004) Overseas visits 80ef1083 2004-12-03 Sandra Osborne uk.org.publicwhip/member/1146 Sandra Osborne uk.org.publicwhip/person/10467 0 2004-12-03-80ef1083-10467-0
6f0a8a0da53a5f1880737cbc2b2e1046ce6c178d 3-12 February 2004, to India as part of a delegation 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 20 February 2004) Overseas visits 80ef1083 2004-10-22 Sandra Osborne uk.org.publicwhip/member/1146 Sandra Osborne uk.org.publicwhip/person/10467 0 2004-10-22-80ef1083-10467-0
01acc7601fb23cd70e51ef9a6740d87d89e128e0 3-12 February 2004, to India as part of a delegation 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 20 February 2004) Overseas visits 80ef1083 2004-09-08 Sandra Osborne uk.org.publicwhip/member/1146 Sandra Osborne uk.org.publicwhip/person/10467 0 2004-09-08-80ef1083-10467-0
fc5104691e0321a828cb261acac2bdc9eb5227da 3-12 February 2004, to India as part of a delegation 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 20 February 2004) Overseas visits 80ef1083 2004-07-16 Sandra Osborne uk.org.publicwhip/member/1146 Sandra Osborne uk.org.publicwhip/person/10467 0 2004-07-16-80ef1083-10467-0
b84de4abdd766633b2f9e5c154ef0946ecc056e3 10-19 May 2003, to Malawi on reproductive health study tour. Flight, transport, per diem and lodgings paid for by Marie Stopes International. (Registered 4 July2003) Overseas visits 80ef1083 2004-05-21 Sandra Osborne uk.org.publicwhip/member/1146 Sandra Osborne uk.org.publicwhip/person/10467 0 2004-05-21-80ef1083-10467-0
1434d19718d2e3e940b639ebd471ceb4620fbc0f 3-12 February 2004, to India as part of a delegation 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 20 February 2004) Overseas visits 80ef1083 2004-05-21 Sandra Osborne uk.org.publicwhip/member/1146 Sandra Osborne uk.org.publicwhip/person/10467 1 2004-05-21-80ef1083-10467-0
6ca47a3e03888b8174793feb5355ec4bc95f26b8 10-19 May 2003, to Malawi on reproductive health study tour. Flight, transport, per diem and lodgings paid for by Marie Stopes International. (Registered 4 July 2003) Overseas visits 80ef1083 2004-01-31 Sandra Osborne uk.org.publicwhip/member/1146 Sandra Osborne uk.org.publicwhip/person/10467 0 2004-01-31-80ef1083-10467-0
2334742f88f75883abb5b29f3747b246d1f6f49d 10-19 May 2003, to Malawi on reproductive health study tour. Flight, transport, per diem and lodgings paid for by Marie Stopes International. (Registered 4 July2003) Overseas visits 80ef1083 2003-12-04 Sandra Osborne uk.org.publicwhip/member/1146 Sandra Osborne uk.org.publicwhip/person/10467 0 2003-12-04-80ef1083-10467-0
11a2ca7bc5980a3bb542e8839b77699270216784 Occasional fees from broadcasting. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Sandra Osborne uk.org.publicwhip/member/1146 Sandra Osborne uk.org.publicwhip/person/10467 0 2002-05-14-1f359ece-10467-0
4f8ef952b405e9c699ca01f23abc6df3e23b37b0 26-27 June 2001, to Germany, to establish partnership with the Hahn Region and South Ayshire in relation to the introduction of Ryanair flights between Hahn and Prestwick airports. Return flights from Prestwick to Hahn to Stansted provided by Ryanair and hotel accommodation provided by Herr Ganter, Romantik-Hotel Bellevue. (Registered 25 July 2001) Overseas visits 80ef1083 2002-05-14 Sandra Osborne uk.org.publicwhip/member/1146 Sandra Osborne uk.org.publicwhip/person/10467 0 2002-05-14-80ef1083-10467-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");