items

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

25 rows where member_id = "uk.org.publicwhip/member/1034" 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
f69a721e19a2a3060a67d76b04e623d5e7cc82e4 House in Cambridge, from which rental income is received. Land and Property 4f1e6359 2005-04-11 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2005-04-11-4f1e6359-10349-0
a54eb69d68f1706b587ec7fabcc9ab18923ddc26 House in Cambridge, from which rental income is received. Land and Property 4f1e6359 2005-01-28 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2005-01-28-4f1e6359-10349-0
90a187a98e4557d51afcbff769be357629f5bf1f House in Cambridge, from which rental income is received. Land and Property 4f1e6359 2004-12-03 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2004-12-03-4f1e6359-10349-0
abecd5c437d46e59aa1906eaa34956828483b059 House in Cambridge, from which rental income is received. Land and Property 4f1e6359 2004-10-22 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2004-10-22-4f1e6359-10349-0
89f343ef4f785ac9c95f2c236d226844699242a7 House in Cambridge, from which rental income is received. Land and Property 4f1e6359 2004-09-08 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2004-09-08-4f1e6359-10349-0
5079f4aa50d918158af81a5f09605f166d4c85c5 House in Cambridge, from which rental income is received. Land and Property 4f1e6359 2004-07-16 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2004-07-16-4f1e6359-10349-0
9b7ab1dd79df98f57354945e19621a4512c32889 House in Cambridge, from which rental income is received. Land and Property 4f1e6359 2004-05-21 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2004-05-21-4f1e6359-10349-0
f88ddb318a32cd041ddcf9fddb93e9408ac59d30 House in Cambridge, from which rental income is received. Land and Property 4f1e6359 2004-01-31 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2004-01-31-4f1e6359-10349-0
ac4184671d457450f5e7a1fcffe2afe479251e85 House in Cambridge, from which rental income is received. Land and Property 4f1e6359 2003-12-04 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2003-12-04-4f1e6359-10349-0
3bb5db801135920ec50c4bdf8b776b75637dd679 17 October 2002, to Poland to visit Auschwitz-Birkenau as the guest of the Holocaust Educational Trust. The costs of my airfare and travel insurance were covered by the Holocaust Educational Trust. (Registered 24 October 2002) Overseas visits 80ef1083 2002-11-26 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2002-11-26-80ef1083-10349-0
711f17a3a4f39f46225adcffff6c0cbcb0bbf0ed House in Cambridge, from which rental income is received. Land and Property 4f1e6359 2002-11-26 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2002-11-26-4f1e6359-10349-0
b7d3dc5440ef296fadec9f34875afcad6a47106b Occasional fees from journalism, television and other media. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2002-05-14-1f359ece-10349-0
76ed416bcb874cea2d912a728092ad5b79bf48ed Member of Harris Parliamentary Panel. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 1 2002-05-14-1f359ece-10349-0
5a1791fc0a489d3102c0c021b8f62d8ded75fce3 Member of Opinion Leader Research Parliamentary Panel. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 2 2002-05-14-1f359ece-10349-0
88621bf17859cfb2c85e452607940cc102f5d814 Proceeds from both opinion polls are donated directly to charity. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 3 2002-05-14-1f359ece-10349-0
2334851f33c941ab4b4271f9965e18e2263ef6f4 Patron of STRADA, Cambridge; day centre for sufferers from stroke and dysphasia (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 0 2002-05-14-265f2269-10349-0
f063886119ce3252adba8ebaacab7c46a7c16ea8 Patron of the Cambridgeshire Small Business Group (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 1 2002-05-14-265f2269-10349-0
dbf82764b705520325ed3d5939d060dcbcae31ad Vice-President of the Cambridgeshire Beekeepers' Association (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 2 2002-05-14-265f2269-10349-0
8c8bdc76d5fdfbdf3effd57a5a40b193ab96a236 Vice-President of the Local Government Association (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 3 2002-05-14-265f2269-10349-0
2fe039a12b38ed6d9b7abfdd1a23180f4624b368 Patron of ASPIRE (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 4 2002-05-14-265f2269-10349-0
1862ad11941e357bdb6b46f2fe0d91056ea005cc Patron of the International Centre for Child Studies (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 5 2002-05-14-265f2269-10349-0
b92dad78f96e3c181e871259574fae5710dbf2f9 Patron of Headway Cambridge (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 6 2002-05-14-265f2269-10349-0
d56114495586fa1c1b21c2b22f3272f48bed1e89 Member of the Council of The Association of Conservative Clubs Ltd. (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 7 2002-05-14-265f2269-10349-0
1661c9b15e1211df8e7b6474f03e98c6605fd001 Vice-Patron of the MRI Scanner Appeal at Hinchingbrooke Hospital, Cambridge (Unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 8 2002-05-14-265f2269-10349-0
1f3177b6d26dda7973c83a9c4e6271cc51444334 Vice-President of the Cambridge and Peterborough Federation of Young Farmers Clubs (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Andrew Lansley uk.org.publicwhip/member/1034 Andrew Lansley uk.org.publicwhip/person/10349 9 2002-05-14-265f2269-10349-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 22.79ms · Data source: mySociety Data · About: simonw/register-of-members-interests