items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where record_id = "2014-12-08-8f616a6e-11036-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 |
---|---|---|---|---|---|---|---|
4346193bf25facc27c6652675db8974c2e63cca0 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 0 | 2014-12-08-8f616a6e-11036-0 |
22b2b7a93b3bc32f129e8bd7a2f01a5315a9e348 | Name of donor: Yeovil Liberal Democrats | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 1 | 2014-12-08-8f616a6e-11036-0 |
f1bc84aadf1372c54d1fa76134eca6d92047d0ed | Address of donor: 5 Church Street, Yeovil, Somerset BA20 1HB | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 2 | 2014-12-08-8f616a6e-11036-0 |
a5c51b9be7d6343ffaf473b8e95f3b5321409549 | 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-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 3 | 2014-12-08-8f616a6e-11036-0 |
6ad30af659de453d48350a92ce5727cf9b30b15f | Donor status: unincorporated association | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 4 | 2014-12-08-8f616a6e-11036-0 |
f0cc66b68c428afe368f17bf55295857ea485c2e | (Registered 25 July 2014) | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 5 | 2014-12-08-8f616a6e-11036-0 |
9b33dac135f5a7df2ca3c094662a4b347bab1f93 | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 6 | 2014-12-08-8f616a6e-11036-0 | |
57e9c2bb2ab67dbbfb76a38ab13772c547e814d6 | Name of donor: Mr and Mrs J Goddard Watts | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 7 | 2014-12-08-8f616a6e-11036-0 |
17b88aa9c5bb7ffc045ea53e2af47fbf0c208e9b | Amount of donation or nature and value if donation in kind: £7,500 | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 9 | 2014-12-08-8f616a6e-11036-0 |
1e50e6c07abae7eafae9aa579a526b10d61fb5de | Name of donor: Nina Campbell | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 12 | 2014-12-08-8f616a6e-11036-0 |
14b45f4c1da7bc8014b334ecb0193f512b323024 | Name of donor: Toolstream Ltd | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 17 | 2014-12-08-8f616a6e-11036-0 |
5c229a5d7d42adb446b245444078a28086dd3b0c | Address of donor: Boundary Way, Lufton Trading Estate, Yeovil, BA22 8HZ | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 18 | 2014-12-08-8f616a6e-11036-0 |
2aff2791c5b4869d429d6450a7bde89f09eba861 | Donor status: company, registration no 04281144 | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 20 | 2014-12-08-8f616a6e-11036-0 |
31b22e1bf9714795416f46b6213fb8af6e071785 | Name of donor: Michelle Quest | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 22 | 2014-12-08-8f616a6e-11036-0 |
50e7b7ebb59e2140f9f9a41b9edac03603d83d3d | Name of donor: Neil Sherlock | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 27 | 2014-12-08-8f616a6e-11036-0 |
01a0eecaf541e7b0bc1eca92eb0ee0beeb25e778 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 29 | 2014-12-08-8f616a6e-11036-0 |
fe8af587444eba9293726146f2ff917dac8a487b | Name of donor: Mr and Mrs R Rooke | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 32 | 2014-12-08-8f616a6e-11036-0 |
d58460132abd6b0996f0a2579eeffa729117f0fc | Name of donor: Deborah Berger | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 37 | 2014-12-08-8f616a6e-11036-0 |
e62bdd8b57748006bdcea87480f2eca146e666e8 | Amount of donation or nature and value if donation in kind: £15,000 | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 39 | 2014-12-08-8f616a6e-11036-0 |
ac9da013085701573e62308ca5f09bead6bd0910 | Name of donor: Brompton Capital Ltd | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 42 | 2014-12-08-8f616a6e-11036-0 |
052d7324d9a77c81ab5f9020e11cc067cb40d219 | Address of donor: 35 South St, London W1K 2XE | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 43 | 2014-12-08-8f616a6e-11036-0 |
ab621f83e4600f186d318e5eb3a564e2c40f4ebb | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 44 | 2014-12-08-8f616a6e-11036-0 |
4687a8e84fadf564d94373d11a2b67433e469d5e | Donor status: company, registration no 03275808 | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 45 | 2014-12-08-8f616a6e-11036-0 |
7fe9205fa12ef2cdd46706c6fb43cc28ce180afe | (Registered 25 July 2014) | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 46 | 2014-12-08-8f616a6e-11036-0 |
42e9586c2e874cdc175331a4a3160633e5ae8320 | Name of donor: Paul Marshall | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 47 | 2014-12-08-8f616a6e-11036-0 |
17459c6f6a7d019386c4e234615aeca8d71ba485 | Address of donor: private | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 48 | 2014-12-08-8f616a6e-11036-0 |
1b6527b0bc1d9d0e78155323d0fb22a576d66b61 | Amount of donation or nature and value if donation in kind: £8,286 in hosting the fundraising dinner | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 49 | 2014-12-08-8f616a6e-11036-0 |
25e996b090e36d73602bf5f17f72875ee620277d | Donor status: individual | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 50 | 2014-12-08-8f616a6e-11036-0 |
a90b5995a777ebf81cd970d745f8fa5319968493 | (Registered 6 August 2014) | Sponsorships 8f616a6e | 2014-12-08 | David Laws uk.org.publicwhip/member/40680 | David Laws uk.org.publicwhip/person/11036 | 51 | 2014-12-08-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");