items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where "date" is on date 2014-07-28 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 |
---|---|---|---|---|---|---|---|
d35220d1cba06d9c49b45641339a8bd843607624 | Received from Biteback Publishing, 3 Albert Embankment, London SE1 7SP: | Remunerated employment, office, profession etc 1f359ece | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 0 | 2014-07-28-1f359ece-11036-0 |
a9fff1592edd8e1641349fed6303037a179f8138 | £190.28 in royalty payments. No additional hours. (Registered 21 November 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 1 | 2014-07-28-1f359ece-11036-0 |
682f3824bf93ff9260670d64f3dd341462970011 | £118.29 in royalty payments, received in June 2014. No additional hours. (Registered 28 July 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 2 | 2014-07-28-1f359ece-11036-0 |
00911d80e827fb57e02c88e0849270c07b29376b | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 0 | 2014-07-28-8f616a6e-11036-0 |
e4ee4a1585c4da4ea2a0dd2dabf98ba169c30a20 | Name of donor: Yeovil Liberal Democrats | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 1 | 2014-07-28-8f616a6e-11036-0 |
7e445ec9bb0ac393f16ba5f378c7441edc21d7b5 | Address of donor: 5 Church Street, Yeovil, Somerset BA20 1HB | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 2 | 2014-07-28-8f616a6e-11036-0 |
cfd892810dc4790ecf5b9bd8e4020f824be520b4 | 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-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 3 | 2014-07-28-8f616a6e-11036-0 |
f3f4cf41ce0b3b2f0ab266704e0ae16adbe4edff | Donor status: unincorporated association | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 4 | 2014-07-28-8f616a6e-11036-0 |
04109fc11ac3bd6a969b0c4717f2de319bea6c2a | (Registered 25 July 2014) | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 5 | 2014-07-28-8f616a6e-11036-0 |
5f7fb52ea10e42e32824cbb7b3b78d26be29aff2 | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 6 | 2014-07-28-8f616a6e-11036-0 | |
5965e46d068793318ef0f5f75685da292c5c8eb7 | Name of donor: Mr and Mrs J Goddard Watts | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 7 | 2014-07-28-8f616a6e-11036-0 |
b73e405fdf3519dfae9fc8f7f23db66aad4ecee9 | Amount of donation or nature and value if donation in kind: £7,500 | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 9 | 2014-07-28-8f616a6e-11036-0 |
39db4b2e2bc8571849cf08b216189bd7a19f1c5a | Name of donor: Nina Campbell | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 12 | 2014-07-28-8f616a6e-11036-0 |
4e87939d317dcc5e62ec9fe5631362420cf28b21 | Name of donor: Toolstream Ltd | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 17 | 2014-07-28-8f616a6e-11036-0 |
73fdddb9f44b643362932dfbf534950aa95d5ef1 | Address of donor: Boundary Way, Lufton Trading Estate, Yeovil, BA22 8HZ | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 18 | 2014-07-28-8f616a6e-11036-0 |
95904ce634b4086662533c6dc200457c17e0974c | Donor status: company, registration no 04281144 | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 20 | 2014-07-28-8f616a6e-11036-0 |
e60afa90d7836be42456c0822f4e335f6803b612 | Name of donor: Michelle Quest | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 22 | 2014-07-28-8f616a6e-11036-0 |
42acb7ea511c5a2ceefb45e6d00a8888bbd9b472 | Name of donor: Neil Sherlock | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 27 | 2014-07-28-8f616a6e-11036-0 |
f03671eb3fc1bac475144d90875a42ab651f6625 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 29 | 2014-07-28-8f616a6e-11036-0 |
28f8142078edf543020dd222379565a4b5b08401 | Name of donor: Mr and Mrs R Rooke | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 32 | 2014-07-28-8f616a6e-11036-0 |
adfe493214b7eec8f7bba7aae407a17958a8ec2c | Name of donor: Deborah Berger | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 37 | 2014-07-28-8f616a6e-11036-0 |
8ac5e9115cd388da6744082fa54f3aac0f099021 | Address of donor: private | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 38 | 2014-07-28-8f616a6e-11036-0 |
e59e27939b919b597a47788590ed37339937ea77 | Amount of donation or nature and value if donation in kind: £15,000 | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 39 | 2014-07-28-8f616a6e-11036-0 |
5db0e3c5ac312f0677d9fa349bcaf25fd18a25ca | Donor status: individual | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 40 | 2014-07-28-8f616a6e-11036-0 |
510fe69304e2df3481637bac2a0c9428407f9007 | Name of donor: Brompton Capital Ltd | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 42 | 2014-07-28-8f616a6e-11036-0 |
0c222f7c4d321614cccbb08f9bca9ceda0f12143 | Address of donor: 35 South St, London W1K 2XE | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 43 | 2014-07-28-8f616a6e-11036-0 |
02cbd7b7a5474bf7f19f8189f7063a3319db59a6 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 44 | 2014-07-28-8f616a6e-11036-0 |
5212f054d05f8843ebb1ea5c788398fb9a91815e | Donor status: company, registration no 03275808 | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 45 | 2014-07-28-8f616a6e-11036-0 |
a72ce3b30d015f51efce1189ac8d8376c4974c42 | (Registered 25 July 2014) | Sponsorships 8f616a6e | 2014-07-28 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 46 | 2014-07-28-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");