items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
32 rows where "date" is on date 2014-11-24 and person_id = "uk.org.publicwhip/person/11036" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
5fbea9e897a8a735f379205ad3859943ef58433f | Received from Biteback Publishing, 3 Albert Embankment, London SE1 7SP: | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 0 | 2014-11-24-1f359ece-11036-0 |
2341d0c705c2c8486fceb4578153748c05bfb001 | £190.28 in royalty payments. No additional hours. (Registered 21 November 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 1 | 2014-11-24-1f359ece-11036-0 |
a39865a81c6c33732377a14c01486f4889eb558c | £118.29 in royalty payments, received in June 2014. No additional hours. (Registered 28 July 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 2 | 2014-11-24-1f359ece-11036-0 |
d8a264b657fc742087975b54104115b17f28decc | 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-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 0 | 2014-11-24-8f616a6e-11036-0 |
20d7765d76f6a1c5dc765deba785f593df2541c0 | Name of donor: Yeovil Liberal Democrats | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 1 | 2014-11-24-8f616a6e-11036-0 |
9a51734ef35eb6df8be9ee07a82f9bfd2a1077bf | Address of donor: 5 Church Street, Yeovil, Somerset BA20 1HB | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 2 | 2014-11-24-8f616a6e-11036-0 |
07b69cce7428eea87488dad535fcba715e69cf00 | 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 | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 3 | 2014-11-24-8f616a6e-11036-0 |
7493e8b66003170c9a8eb08636ae75f1cdc9b6d8 | Donor status: unincorporated association | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 4 | 2014-11-24-8f616a6e-11036-0 |
00653613ab60acf93a1865ff31f3b56d3d2f2463 | (Registered 25 July 2014) | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 5 | 2014-11-24-8f616a6e-11036-0 |
1241bd05b2aa63ebfd87338bc5b1c42bed8ecd4e | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 6 | 2014-11-24-8f616a6e-11036-0 | |
24355f1f9e42ed2165f84af5eb722f94b45be140 | Name of donor: Mr and Mrs J Goddard Watts | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 7 | 2014-11-24-8f616a6e-11036-0 |
03c23b25c1bc17fa83c8b0dc32e17320d53d2346 | Amount of donation or nature and value if donation in kind: £7,500 | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 9 | 2014-11-24-8f616a6e-11036-0 |
4126a076a1a2bcd6d02a1384e562c2bfd0929df3 | Name of donor: Nina Campbell | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 12 | 2014-11-24-8f616a6e-11036-0 |
0ef04b79059d6b38060b528b5cee0fc78d2af301 | Name of donor: Toolstream Ltd | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 17 | 2014-11-24-8f616a6e-11036-0 |
b9eb00397fa477afce40278a539a62a46d233a83 | Address of donor: Boundary Way, Lufton Trading Estate, Yeovil, BA22 8HZ | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 18 | 2014-11-24-8f616a6e-11036-0 |
09f85d9c331895d320f1aa3112fd49aee9794f1d | Donor status: company, registration no 04281144 | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 20 | 2014-11-24-8f616a6e-11036-0 |
e51f7cbdc1eb9fc81437339dff9a117136862401 | Name of donor: Michelle Quest | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 22 | 2014-11-24-8f616a6e-11036-0 |
43be4ee38c9aa275c97c4d8d03c83943624c20e2 | Name of donor: Neil Sherlock | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 27 | 2014-11-24-8f616a6e-11036-0 |
f82ab819c3336c1b8e475e72594fe578fb8013de | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 29 | 2014-11-24-8f616a6e-11036-0 |
da17b0740b1160e79c86a4ccb9b8ba04f12bc948 | Name of donor: Mr and Mrs R Rooke | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 32 | 2014-11-24-8f616a6e-11036-0 |
f83e0146210bc8e6e930fe3da91dbb20d05d3bab | Name of donor: Deborah Berger | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 37 | 2014-11-24-8f616a6e-11036-0 |
d2a3a719499c097920f1b7302718ee7bcee33cf3 | Amount of donation or nature and value if donation in kind: £15,000 | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 39 | 2014-11-24-8f616a6e-11036-0 |
74b10f5988082650bbf64b4c54b2fd93d1f9a972 | Name of donor: Brompton Capital Ltd | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 42 | 2014-11-24-8f616a6e-11036-0 |
43aa2a28a0b5a387068fd54b33bb9ca2f0332c60 | Address of donor: 35 South St, London W1K 2XE | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 43 | 2014-11-24-8f616a6e-11036-0 |
5f2c71ad611c96d1429eacafe8939d1deea5a901 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 44 | 2014-11-24-8f616a6e-11036-0 |
d7bdefd022c091f32ad5dd102313c26874e65451 | Donor status: company, registration no 03275808 | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 45 | 2014-11-24-8f616a6e-11036-0 |
a655b2cbd902416de05e7cea3dab2547f025c50b | (Registered 25 July 2014) | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 46 | 2014-11-24-8f616a6e-11036-0 |
50829fde6d4f6ca34d176f47a1ba2cbb91db9228 | Name of donor: Paul Marshall | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 47 | 2014-11-24-8f616a6e-11036-0 |
ed1d1f91675be4aea385cadede39b06bdef18672 | Address of donor: private | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 48 | 2014-11-24-8f616a6e-11036-0 |
1da172e67801def9e64dee06575bb5bbeee493ea | Amount of donation or nature and value if donation in kind: £8,286 in hosting the fundraising dinner | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 49 | 2014-11-24-8f616a6e-11036-0 |
6ff40a892ea2b6787e6558aee6ac3c46a7a5d9b1 | Donor status: individual | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 50 | 2014-11-24-8f616a6e-11036-0 |
1d46f94680befac7aa4fe2671940b32ec2e45997 | (Registered 6 August 2014) | Sponsorships 8f616a6e | 2014-11-24 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 51 | 2014-11-24-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");