items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
34 rows where "date" is on date 2014-11-10 and person_id = "uk.org.publicwhip/person/10084" sorted by record_id
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
075cf50eb14b8144bba74feec403623412e71dbb | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2014-11-10-8f616a6e-10084-0 |
75d5dd16ceac20072a7638881cfffb8ccbc136f8 | Name of donor: Lord Oakeshott | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2014-11-10-8f616a6e-10084-0 |
009136e38b1e1b681bc665b7d3b3337550f78949 | Amount of donation or nature and value if donation in kind: conducting a local opinion poll, value £6,000 | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2014-11-10-8f616a6e-10084-0 |
b00fe4c4912cc9d81edde29786a3e6a4f0623673 | (Registered 5 June 2014) | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2014-11-10-8f616a6e-10084-0 |
02aedce9f5248007db1654bcdf4d5afd13dd9f8f | Amount of donation or nature and value if donation in kind: Cost of holding a dinner; £3,738.06 | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2014-11-10-8f616a6e-10084-0 |
5024c1deef0d3b70469a3926ad02482a3826bc49 | Name of donor: Lord Loomba | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2014-11-10-8f616a6e-10084-0 |
a081d3370d0b9098d57094f94831e6e8acdcb518 | Amount of donation or nature and value if donation in kind: £2,450 | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2014-11-10-8f616a6e-10084-0 |
571c1a02207105ab81cf74117d58fa004bd88ec7 | Name of donor: Shiraz Lalji | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 16 | 2014-11-10-8f616a6e-10084-0 |
7f63ff4555fa76f57d647a810f6381eb7691ae38 | Name of donor: Mrs J Mattu | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 21 | 2014-11-10-8f616a6e-10084-0 |
79e60376419b9401c9e23c83dcec90f4ef175ee0 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 23 | 2014-11-10-8f616a6e-10084-0 |
094e23d3ef051083d6c57cf73e4321772506e8b5 | (Registered 13 June 2014) | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 25 | 2014-11-10-8f616a6e-10084-0 |
92b2ce3d42c975b8d026506a6fbc2547772840d7 | Name of donor: Vitabotics Ltd | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 26 | 2014-11-10-8f616a6e-10084-0 |
71659ccd399f9a5dd325ec22af2e57fa13791155 | Address of donor: 1 Apsley Way, London NW2 7HF | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 27 | 2014-11-10-8f616a6e-10084-0 |
1a000f26e89d19ad5e139aeca4df7a644cb3d013 | Donor status: company, registration 01012146 | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 29 | 2014-11-10-8f616a6e-10084-0 |
7513cb7d96a8ed6fee4780188e1f6cc89544e450 | Name of donor: GSM Minerals Engineering Consultants Ltd | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 31 | 2014-11-10-8f616a6e-10084-0 |
a394702158d82dd77b98526b4cd4e9cb0933dff3 | Address of donor: 70 London Road, Twickenham TW1 3QS | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 32 | 2014-11-10-8f616a6e-10084-0 |
ef32911116a95d68b06d32dd8d5cc4d534db9810 | Amount of donation or nature and value if donation in kind: £4,000 | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 33 | 2014-11-10-8f616a6e-10084-0 |
5ee3e46f78103f3939f8340982051a6270734a02 | Donor status: company, registration 02903467 | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 34 | 2014-11-10-8f616a6e-10084-0 |
c7a9c0ddd28ee3f24fe17e81ba59a5bf0970c7a0 | Name of donor: Dr S. P. Sharma | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 36 | 2014-11-10-8f616a6e-10084-0 |
b5d300134ef5206b4202d06254981d10d81ce584 | Donor status: individual | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 39 | 2014-11-10-8f616a6e-10084-0 |
dd7801d40ac5e9e39384bcaa57fadaca23652f38 | Name of donor: Precis Management Services Ltd | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 41 | 2014-11-10-8f616a6e-10084-0 |
cfcd2d5e922662c37ca5588c38b9c046031e90c4 | Address of donor: 98 Park Land, London W1K 7TB | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 42 | 2014-11-10-8f616a6e-10084-0 |
4a9cf758e00d6c27941297d3b24a2357e6de60c8 | Donor status: company, registration 07545915 | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 44 | 2014-11-10-8f616a6e-10084-0 |
456a4e65b56b6997b096c12dfa00680e917b39ca | (Registered 21 July 2014) | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 45 | 2014-11-10-8f616a6e-10084-0 |
fe83dab09ff7f1560716c5a68ca4e78e54343538 | Name of donor: Chartwell Care Services Ltd | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 46 | 2014-11-10-8f616a6e-10084-0 |
4ad8746e12b21d4001c196c16a35f7a829a98506 | Address of donor: 12 Helmet Row, London EC1V 3QJ | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 47 | 2014-11-10-8f616a6e-10084-0 |
5712c33d892fcdee3cd77502a85bd4cc32059f22 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 48 | 2014-11-10-8f616a6e-10084-0 |
7c7f0d9ae23287a39764c8ac1481aeaa565aa478 | Donor status: company, registration no 08554461 | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 49 | 2014-11-10-8f616a6e-10084-0 |
6127916e68bfb7e1a1e486ddb476a511b0bbe77d | (Registered 21 August 2014) | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 50 | 2014-11-10-8f616a6e-10084-0 |
d0f14ef8bb7f0fe3c7b211ad8bdee643b9391597 | Name of donor: Joginder Sangar | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 51 | 2014-11-10-8f616a6e-10084-0 |
2192d6f8ec40f384aed09344e591fac13755ca1d | Address of donor: private | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 52 | 2014-11-10-8f616a6e-10084-0 |
2906c1b1b2b47b8df1c037bfb050a00b2ad43f59 | Amount of donation or nature and value if donation in kind: £1,950 in covering the cost of a dinner | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 53 | 2014-11-10-8f616a6e-10084-0 |
33c40dc3352fef849c9ccd709bf89e9f42fdc746 | Donor status: inidvidual | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 54 | 2014-11-10-8f616a6e-10084-0 |
67b94c5fba37b0e91c5f80d756e281e4d33b4117 | (Registered 9 September 2014) | Sponsorships 8f616a6e | 2014-11-10 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 55 | 2014-11-10-8f616a6e-10084-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");