items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where record_id = "2015-01-06-8f616a6e-11036-0" sorted by category_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
2e37c88d6d72504b72158085faa43b2bdb239427 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 0 | 2015-01-06-8f616a6e-11036-0 |
45db647bd8d94648a610ca8be17865309f7b8e19 | Name of donor: Yeovil Liberal Democrats | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 1 | 2015-01-06-8f616a6e-11036-0 |
8a53348c26a0d010925655d637d65f72dd49b3f9 | Address of donor: 5 Church Street, Yeovil, Somerset BA20 1HB | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 2 | 2015-01-06-8f616a6e-11036-0 |
0e3cb6aa7ab17930fb5fa906d65f9c6dedaab31c | Amount of donation or nature and value if donation in kind: Money raised at and following a fundraising event on 28 April 2014 in support of campaigns for the 2015 local elections and for my own election fund. The total raised was £49,600, which includes the registrable donations below. | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 3 | 2015-01-06-8f616a6e-11036-0 |
ce3ba02b67fd151e71ab8651fdd57b27fb582e61 | Donor status: unincorporated association | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 4 | 2015-01-06-8f616a6e-11036-0 |
7cdf5b9b47b241ed36fbb221b6d8bd5d8a9348e0 | (Registered 25 July 2014) | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 5 | 2015-01-06-8f616a6e-11036-0 |
9541fee15adc00d03f84c972bc04fda9c0f65a80 | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 6 | 2015-01-06-8f616a6e-11036-0 | |
0169dd3a7f2af9020ad8eb63942fd43f89598887 | Name of donor: Mr and Mrs J Goddard Watts | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 7 | 2015-01-06-8f616a6e-11036-0 |
395919d175ae200c16b553276342708fbb94a2f2 | Amount of donation or nature and value if donation in kind: £7,500 | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 9 | 2015-01-06-8f616a6e-11036-0 |
356a3d0954e6261c049a065378f2a713754649fd | Name of donor: Nina Campbell | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 12 | 2015-01-06-8f616a6e-11036-0 |
b98f17ff77218e144ac068d66a9feee6dbb3c833 | Name of donor: Toolstream Ltd | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 17 | 2015-01-06-8f616a6e-11036-0 |
0cb932eb819fb3334a99ac5e8c600491b27e49d5 | Address of donor: Boundary Way, Lufton Trading Estate, Yeovil, BA22 8HZ | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 18 | 2015-01-06-8f616a6e-11036-0 |
cbb4fdc7b20e778714a8a24e6bf369f73b6c7079 | Donor status: company, registration no 04281144 | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 20 | 2015-01-06-8f616a6e-11036-0 |
b1ac56c75010c14e3d2f7dce1aa68a9957ea8f6a | Name of donor: Michelle Quest | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 22 | 2015-01-06-8f616a6e-11036-0 |
489e74b14340f933e739bd3651882cce7cf2ea5c | Name of donor: Neil Sherlock | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 27 | 2015-01-06-8f616a6e-11036-0 |
a07d8fd5930a507a7637247f0e4c4d7e2bb0a4b9 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 29 | 2015-01-06-8f616a6e-11036-0 |
9fd33acdc1a4f2865720d7e3aa960f0bc4afeaa4 | Name of donor: Mr and Mrs R Rooke | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 32 | 2015-01-06-8f616a6e-11036-0 |
3c2efea843ef2155757e4251397e3f123f1f20ab | Name of donor: Deborah Berger | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 37 | 2015-01-06-8f616a6e-11036-0 |
971c72a2906b5c529508ac32090e27c559f000b2 | Amount of donation or nature and value if donation in kind: £15,000 | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 39 | 2015-01-06-8f616a6e-11036-0 |
52ef596c8fa0fcc6f5d298a5fcd53fe39bff88af | Name of donor: Brompton Capital Ltd | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 42 | 2015-01-06-8f616a6e-11036-0 |
ffcc6c4d1c936848e999f65867169c319e79dda6 | Address of donor: 35 South St, London W1K 2XE | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 43 | 2015-01-06-8f616a6e-11036-0 |
dc9a6a6437ecfd62c33600057f8ca16c9ab269a2 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 44 | 2015-01-06-8f616a6e-11036-0 |
9ffb87cc218a0e4bcc2c667847e3b5e272fa501f | Donor status: company, registration no 03275808 | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 45 | 2015-01-06-8f616a6e-11036-0 |
021fe60f2b65325d919081fa5f0bdb14222362eb | (Registered 25 July 2014) | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 46 | 2015-01-06-8f616a6e-11036-0 |
834b46e3b8c6c641aee2c7951621b3a70428d563 | Name of donor: Paul Marshall | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 47 | 2015-01-06-8f616a6e-11036-0 |
a564f2de96c63fb6820269b6c3ba815865f71b69 | Address of donor: private | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 48 | 2015-01-06-8f616a6e-11036-0 |
453aa10ecd11c7a2c5ec34d0b6fd2d8a3451a3e9 | Amount of donation or nature and value if donation in kind: £8,286 in hosting the fundraising dinner | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 49 | 2015-01-06-8f616a6e-11036-0 |
5ee437ad403129f9e91b8225d003c0548313d600 | Donor status: individual | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 50 | 2015-01-06-8f616a6e-11036-0 |
a0ff7b5387fa1707ff4ade2fccbfa22d81a02310 | (Registered 6 August 2014) | Sponsorships 8f616a6e | 2015-01-06 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 51 | 2015-01-06-8f616a6e-11036-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");