items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
34 rows where record_id = "2014-10-27-8f616a6e-10084-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
6704334314e0ed6b77828f6f303b5b61e246dbdd | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2014-10-27-8f616a6e-10084-0 |
e930d8d9b72c8a1b5674d5928c77d87909803650 | Name of donor: Lord Oakeshott | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2014-10-27-8f616a6e-10084-0 |
f85530f5b9b5c8db7a42ceea120dd9d03c09778f | Amount of donation or nature and value if donation in kind: conducting a local opinion poll, value £6,000 | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2014-10-27-8f616a6e-10084-0 |
609f4af1bfee0865f03a442b7337670b5ed48668 | (Registered 5 June 2014) | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2014-10-27-8f616a6e-10084-0 |
2729a49b4606a4a8a2682358af8152273bdafc12 | Amount of donation or nature and value if donation in kind: Cost of holding a dinner; £3,738.06 | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2014-10-27-8f616a6e-10084-0 |
3547bb02366f5cece87d9b45bdbb70cd71288ab3 | Name of donor: Lord Loomba | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2014-10-27-8f616a6e-10084-0 |
bd03778247706a5a50a175a962e4890437ad7dfd | Amount of donation or nature and value if donation in kind: £2,450 | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2014-10-27-8f616a6e-10084-0 |
ff94fe927e79e1aab0be0164747c77ae9dbb5f53 | Name of donor: Shiraz Lalji | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 16 | 2014-10-27-8f616a6e-10084-0 |
03a7ddf1bc7142bcc489a0edff9a7b40f48c8960 | Name of donor: Mrs J Mattu | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 21 | 2014-10-27-8f616a6e-10084-0 |
b33c1860d88327c4c92c22cae262748c03a9829e | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 23 | 2014-10-27-8f616a6e-10084-0 |
6166cff83412f7c2ba8cbff7cf5c1d26d8bb7f10 | (Registered 13 June 2014) | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 25 | 2014-10-27-8f616a6e-10084-0 |
83707ac466dc2efc784d32ca8752a637cce82643 | Name of donor: Vitabotics Ltd | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 26 | 2014-10-27-8f616a6e-10084-0 |
10630103d348415b927c960669e445225968989c | Address of donor: 1 Apsley Way, London NW2 7HF | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 27 | 2014-10-27-8f616a6e-10084-0 |
bc89bffd7169a5136ecf50f3430daf8dc6a9d445 | Donor status: company, registration 01012146 | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 29 | 2014-10-27-8f616a6e-10084-0 |
628dd03fe62d2d139a771848d16a9a701f1268d7 | Name of donor: GSM Minerals Engineering Consultants Ltd | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 31 | 2014-10-27-8f616a6e-10084-0 |
21b5e9de7cd7a935fa2eb6a1ec6d5b8cdc2dd700 | Address of donor: 70 London Road, Twickenham TW1 3QS | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 32 | 2014-10-27-8f616a6e-10084-0 |
316f365cd114c5b85190c0da40c6201a84a7b519 | Amount of donation or nature and value if donation in kind: £4,000 | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 33 | 2014-10-27-8f616a6e-10084-0 |
7cad81bdc7c11f5a43038605e5dd66a87b59b719 | Donor status: company, registration 02903467 | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 34 | 2014-10-27-8f616a6e-10084-0 |
9a966a85131f7d9ca1762ecf023e7b4e636ed2a9 | Name of donor: Dr S. P. Sharma | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 36 | 2014-10-27-8f616a6e-10084-0 |
c3a1d47a125d60e240b8e1383b92c734ea502ca6 | Donor status: individual | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 39 | 2014-10-27-8f616a6e-10084-0 |
8ec6aaa9080039bc56b370040c89b7df2683cb2a | Name of donor: Precis Management Services Ltd | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 41 | 2014-10-27-8f616a6e-10084-0 |
8dcd5be6925ac79627d83a15bef73bea3aaed8ab | Address of donor: 98 Park Land, London W1K 7TB | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 42 | 2014-10-27-8f616a6e-10084-0 |
afe712f848b084a14a05994e47215a0aa0c82f70 | Donor status: company, registration 07545915 | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 44 | 2014-10-27-8f616a6e-10084-0 |
654404a92e3da3caf4adc2b056652c73f0b5bb56 | (Registered 21 July 2014) | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 45 | 2014-10-27-8f616a6e-10084-0 |
5e877f556f51e344722ee9264844048e6bf98ae9 | Name of donor: Chartwell Care Services Ltd | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 46 | 2014-10-27-8f616a6e-10084-0 |
cbee9ef094d6a2da59fef452aa3c10538360433c | Address of donor: 12 Helmet Row, London EC1V 3QJ | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 47 | 2014-10-27-8f616a6e-10084-0 |
4b77dab40f0e785dfcf71d14cc91e39e093c3c1b | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 48 | 2014-10-27-8f616a6e-10084-0 |
6975bf3749f43843227cb1131f566d03ec0f9af5 | Donor status: company, registration no 08554461 | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 49 | 2014-10-27-8f616a6e-10084-0 |
573f8230174cd3060e5169ff12f2473776321002 | (Registered 21 August 2014) | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 50 | 2014-10-27-8f616a6e-10084-0 |
5b5fb7c395d991356f2e637ae1fbb6db6bc12898 | Name of donor: Joginder Sangar | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 51 | 2014-10-27-8f616a6e-10084-0 |
c543b3199ef631e9502a3389bf8a84ba8085fa6c | Address of donor: private | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 52 | 2014-10-27-8f616a6e-10084-0 |
453a040e5eb82256caa69dfe26f678b7984244a4 | Amount of donation or nature and value if donation in kind: £1,950 in covering the cost of a dinner | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 53 | 2014-10-27-8f616a6e-10084-0 |
0cce403f32f44dffe80bea9c5b45d92f71e4ac16 | Donor status: inidvidual | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 54 | 2014-10-27-8f616a6e-10084-0 |
abd38f2daf0a7e43a017ec14c5a0d5d45275e02b | (Registered 9 September 2014) | Sponsorships 8f616a6e | 2014-10-27 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 55 | 2014-10-27-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");