items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
32 rows where "date" is on date 2014-09-22 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 |
---|---|---|---|---|---|---|---|
82c7a78eae8874d22aa38c961b315ac616bca57a | Received from Biteback Publishing, 3 Albert Embankment, London SE1 7SP: | Remunerated employment, office, profession etc 1f359ece | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 0 | 2014-09-22-1f359ece-11036-0 |
fc7a107666a611d1216fdc93235d6ebfda580904 | £190.28 in royalty payments. No additional hours. (Registered 21 November 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 1 | 2014-09-22-1f359ece-11036-0 |
40f598f13515e581f052b5fb15d810147fa3172e | £118.29 in royalty payments, received in June 2014. No additional hours. (Registered 28 July 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 2 | 2014-09-22-1f359ece-11036-0 |
531eed6ce1639c9146489c8992312af92236c1ae | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 0 | 2014-09-22-8f616a6e-11036-0 |
0ce742638aac2715621300b5fc8537d136f2ace8 | Name of donor: Yeovil Liberal Democrats | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 1 | 2014-09-22-8f616a6e-11036-0 |
3295d69e9d39ae18ada2cbb55c45fdbcb9a64aad | Address of donor: 5 Church Street, Yeovil, Somerset BA20 1HB | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 2 | 2014-09-22-8f616a6e-11036-0 |
c8b6226b20f5eb36278e0d57d0492d748d8ba8c5 | 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-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 3 | 2014-09-22-8f616a6e-11036-0 |
d15e09a1bda257d97b771d335f8aa6e2eeb2816b | Donor status: unincorporated association | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 4 | 2014-09-22-8f616a6e-11036-0 |
a099652f294f5a356be53e1e3c7a0e2ec33fb696 | (Registered 25 July 2014) | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 5 | 2014-09-22-8f616a6e-11036-0 |
67e7b79e09470db9bdffa0fc22b9c092811fa1fd | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 6 | 2014-09-22-8f616a6e-11036-0 | |
24857daf90387135bef5f06c35eb0c1f96bb9bba | Name of donor: Mr and Mrs J Goddard Watts | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 7 | 2014-09-22-8f616a6e-11036-0 |
a30c0e83109dd10e73159c48da4eb0d1d9ab6305 | Amount of donation or nature and value if donation in kind: £7,500 | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 9 | 2014-09-22-8f616a6e-11036-0 |
22865cab2facf22b1418dd4f7dfded9faafdda3d | Name of donor: Nina Campbell | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 12 | 2014-09-22-8f616a6e-11036-0 |
e937e633805e4ba7284fcb981c344870550b8fb0 | Name of donor: Toolstream Ltd | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 17 | 2014-09-22-8f616a6e-11036-0 |
e025c75dd10177db67d9cf4e62114c541f9841c8 | Address of donor: Boundary Way, Lufton Trading Estate, Yeovil, BA22 8HZ | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 18 | 2014-09-22-8f616a6e-11036-0 |
91439226cdbd46117489b0e2dacc4d00d62f08ed | Donor status: company, registration no 04281144 | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 20 | 2014-09-22-8f616a6e-11036-0 |
9c685ee62d9629f05896b60dbd22a7a3589122b8 | Name of donor: Michelle Quest | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 22 | 2014-09-22-8f616a6e-11036-0 |
577e17bd05441b596d033b2b6ab7cfeb93759a91 | Name of donor: Neil Sherlock | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 27 | 2014-09-22-8f616a6e-11036-0 |
6a4d40d44ce066550ef2d42ffa4ef53973870141 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 29 | 2014-09-22-8f616a6e-11036-0 |
0d8c7e1824ad1bd32d9d47a6f9f4ca5a36f8c715 | Name of donor: Mr and Mrs R Rooke | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 32 | 2014-09-22-8f616a6e-11036-0 |
d8c4876418ee6c757e2013f15571cf7ae0d0a206 | Name of donor: Deborah Berger | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 37 | 2014-09-22-8f616a6e-11036-0 |
96673b20c3fce19342dc13cfaa272970ae321627 | Amount of donation or nature and value if donation in kind: £15,000 | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 39 | 2014-09-22-8f616a6e-11036-0 |
970a6fc9d8da0c6bcf1ba8591b1ea401972deb08 | Name of donor: Brompton Capital Ltd | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 42 | 2014-09-22-8f616a6e-11036-0 |
06ef5984a3c5cf55cd8e3c08783244bd6f7f9ca4 | Address of donor: 35 South St, London W1K 2XE | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 43 | 2014-09-22-8f616a6e-11036-0 |
18c588e653fa9d5aec43b23da3cb2a0f58e4676c | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 44 | 2014-09-22-8f616a6e-11036-0 |
9da72efc467fb24b7f650e33210ab6bbec43fb0c | Donor status: company, registration no 03275808 | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 45 | 2014-09-22-8f616a6e-11036-0 |
7fd3d9c86b5cc2993efc43186967eb0ae566e23b | (Registered 25 July 2014) | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 46 | 2014-09-22-8f616a6e-11036-0 |
c00431ac383a71a67d4c83948fcf15a61c46acc1 | Name of donor: Paul Marshall | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 47 | 2014-09-22-8f616a6e-11036-0 |
5b30a03b6918a4f3d5fc39120586eaeb5081bb31 | Address of donor: private | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 48 | 2014-09-22-8f616a6e-11036-0 |
54ac234480dca2268c7662396e4f6b865f9c3a8d | Amount of donation or nature and value if donation in kind: £8,286 in hosting the fundraising dinner | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 49 | 2014-09-22-8f616a6e-11036-0 |
a893a9477fe1a4776d4eec0adae1201cb979ad15 | Donor status: individual | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 50 | 2014-09-22-8f616a6e-11036-0 |
89efb673a4124111b4df0e3debce66b31348f532 | (Registered 6 August 2014) | Sponsorships 8f616a6e | 2014-09-22 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 51 | 2014-09-22-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");