home / regmem

items

Data source: mySociety Data

13 rows where member_id = "uk.org.publicwhip/member/10"

View and edit SQL

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

hash item category_id date member_id person_id sort_order record_id
2948101d85b09bb768999b81b9021392dc15714c Use of car provided by the Rover Group (in my capacity as Chairman of the Conservative Party). Sponsorship or financial or material support 9e46def6 2000-11-10 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 1 2000-11-10-9e46def6-10010-0
3a8a81ae5a9d08bc5e2a0cb7b5d19ab0bd4757d7 3 February 2001, lunch and ticket to the England Wales rugby match in Cardiff as the guest of British Gas. (Registered 21 March 2001) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2001-05-14-84642823-10010-0
465d8cfa31f9a5a8c33764dba70ee384469f7893 Portzim Ltd.; family estate company in Roxburghshire. Remunerated directorships ead1ca87 2000-11-10 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2000-11-10-ead1ca87-10010-0
4efab7d42e6a521eb3101cedccabb4f9362722eb Portzim Ltd. Registrable shareholdings 3aff2389 2001-05-14 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2001-05-14-3aff2389-10010-0
60c93be773bc5d1b5a8d8d5f026423bc6c06ff38 Use of car for four months (from 18 June 1999) provided by Vauxhall Motors Ltd. (in my capacity as Chairman of the Conservative Party). Sponsorship or financial or material support 9e46def6 2000-11-10 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2000-11-10-9e46def6-10010-0
75defd5419c46b4cc861768e779ec6bdc932c102 Minority limited partner in Bonny Extra (Paper) Limited Partnership; provision of consultancy services for the development of waste paper recovery procedures. Remunerated employment, office, profession etc 1f359ece 2001-05-14 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2001-05-14-1f359ece-10010-0
7a0d3267047456c265165ab11305de6b71e48837 A small tenanted estate and a partnership in a tenanted farm in Roxburghshire. Land and Property 4f1e6359 2000-11-10 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2000-11-10-4f1e6359-10010-0
8988162c07c211b2a5fbd09fe437666801839836 A small tenanted estate and a partnership in a tenanted farm in Roxburghshire. Land and Property 4f1e6359 2001-05-14 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2001-05-14-4f1e6359-10010-0
95c0c4d9c5f61026fb0881fae7f20829c92355a2 4 July 1999, tickets for my wife and myself for the Wimbledon finals, from the BBC. (Registered 5 July 1999) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2000-11-10-84642823-10010-0
99dd1737d398e4256fcc8d1ce7de8087acedcbec Minority limited partner in Bonny Extra (Paper) Limited Partnership; provision of consultancy services for the development of waste paper recovery procedures. Remunerated employment, office, profession etc 1f359ece 2000-11-10 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2000-11-10-1f359ece-10010-0
c16f2b0b76cc1d27ddad40b390777f24b224b817 Use of car provided by the Rover Group (in my capacity as Chairman of the Conservative Party). Sponsorship or financial or material support 9e46def6 2001-05-14 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2001-05-14-9e46def6-10010-0
de8b5deee6acbeb127d42273be4081e9aaaa52eb Portzim Ltd. Registrable shareholdings 3aff2389 2000-11-10 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2000-11-10-3aff2389-10010-0
e19509a22e503ed0e285848f8ab809149907e7ab Portzim Ltd.; family estate company in Roxburghshire. Remunerated directorships ead1ca87 2001-05-14 uk.org.publicwhip/member/10 Michael Ancram uk.org.publicwhip/person/10010 0 2001-05-14-ead1ca87-10010-0

Advanced export

JSON shape: default, array, 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)
    )
Powered by Datasette · Query took 5.937ms · Data source: mySociety Data