items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
48 rows where record_id = "2015-01-06-8f616a6e-10040-0" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
b9e02498aeb430f4f12c23924da277181bb0d94f | Donations to my campaign for re-election to the House of Commons were received as follows: | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 0 | 2015-01-06-8f616a6e-10040-0 |
ad64ab44c4cafb05cf372c5ff9f577011523240d | Name of donor: Michael Keegan | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 1 | 2015-01-06-8f616a6e-10040-0 |
984dfe2a48744e583a41c1c3df7cc260f4a86a1d | Date of receipt: 16 March 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 4 | 2015-01-06-8f616a6e-10040-0 |
d2cff604ee627732f48410493f2cea30ece4ba15 | Name of donor: Lord Levy | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 8 | 2015-01-06-8f616a6e-10040-0 |
d3cd244218dc8d09fc022cff06fb98b463b20139 | Date of receipt: 18 March 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 11 | 2015-01-06-8f616a6e-10040-0 |
938a6ef879c25bd0eb21909ff59ef1ac1b6dd56e | Date of acceptance: 24 March 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 12 | 2015-01-06-8f616a6e-10040-0 |
dae0e9aa802a74a9c55f5e69210ce645225cff3f | (Registered 27 March 2014) | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 14 | 2015-01-06-8f616a6e-10040-0 |
678c13e753a8e028db97342b522eb40daac08d62 | Name of donor: Vascroft Contractors Ltd | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 15 | 2015-01-06-8f616a6e-10040-0 |
a10a1a0a7b36ded82e95652f2651695715655572 | Address of donor: Vascroft Estate, 861 Coronation Rd, London NW10 7PT | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 16 | 2015-01-06-8f616a6e-10040-0 |
71c138830f380c524f12a4f7e5c8e1812a412323 | Amount of donation or nature and value if donation in kind: £3,500 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 17 | 2015-01-06-8f616a6e-10040-0 |
1c81bb64af19d7a0828077e4a52c9e4515076497 | Date of acceptance: 18 June 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 19 | 2015-01-06-8f616a6e-10040-0 |
12f6fb06a2759bbb914165850f692b53364aef82 | Donor status: company, registration no 1293674 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 20 | 2015-01-06-8f616a6e-10040-0 |
b504bf2409c7d2dd9a970aa3405ccc5ac4b94997 | (Registered 19 June 2014) | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 21 | 2015-01-06-8f616a6e-10040-0 |
a2979f2058de65999b74ee9ae5c2500470ca7005 | Name of donor: Trust Reservations Ltd | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 22 | 2015-01-06-8f616a6e-10040-0 |
91e6ee5fb947e2ac0e720f054a3ef05125f27fe1 | Address of donor: 6 Oxford St, Lambourn, Hungerford, RG17 8XP | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 23 | 2015-01-06-8f616a6e-10040-0 |
3efdc05338ef269afea9a7037ac996ad7a6c8c83 | Date of receipt: 7 June 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 25 | 2015-01-06-8f616a6e-10040-0 |
d372a792347ef7aafe6c4445cddb67c01a8f4f50 | Date of acceptance: 1 July 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 26 | 2015-01-06-8f616a6e-10040-0 |
4df26886467d96cf274432653142bade0b3fdc2d | Donor status: company, registration number 03829637 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 27 | 2015-01-06-8f616a6e-10040-0 |
4122c595b0bb0afe9d13d0312360ccb463bb67c9 | (Registered 1 July 2014 ) | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 28 | 2015-01-06-8f616a6e-10040-0 |
62fb3925a683c7f8c6747eb375d8d6a02a9bca4a | Name of donor: Madhu’s Ltd | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 29 | 2015-01-06-8f616a6e-10040-0 |
5746d4f29f16331552797120814d4a1b9e1884ad | Address of donor: 39 South Road, Southall, UB1 1SW | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 30 | 2015-01-06-8f616a6e-10040-0 |
d1c77e595d9e899fd3e38d3b09d18a7c1cd1193f | Date of receipt: 23 May 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 32 | 2015-01-06-8f616a6e-10040-0 |
0c04d76e88bc035bfedf54f37521a3c500bf0d21 | Date of acceptance: 16 June 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 33 | 2015-01-06-8f616a6e-10040-0 |
acdcb81f258a9c1f0d783721c0ff1394a71ab78f | Donor status: company, registration no 04580937 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 34 | 2015-01-06-8f616a6e-10040-0 |
689ba6e9395cd4a7035ffdc25f4b79e70150433f | (Registered 1 July 2014) | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 35 | 2015-01-06-8f616a6e-10040-0 |
31b1ffc266d3818ec5cf75e7c6de0c6ae922935c | Name of donor: APX Autopart Express Ltd | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 36 | 2015-01-06-8f616a6e-10040-0 |
16cb1607bfbe9185a7a2cf3b25465a43b56bb704 | Address of donor: 34 Greenhill Crescent, Watford Business Park, Watford WD18 8JU | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 37 | 2015-01-06-8f616a6e-10040-0 |
90efc94ee6c122724e9e53e9a7e8509d013e790c | Date of receipt: 14 November 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 39 | 2015-01-06-8f616a6e-10040-0 |
9a78af0ec146cb77ec31383fe77187e0a0d01921 | Donor status: company, registration number 09255164 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 41 | 2015-01-06-8f616a6e-10040-0 |
16d9fb845a8417c450b20fd5dd5ee4a0a4ccf301 | Name of donor: Dreamsland Ltd | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 43 | 2015-01-06-8f616a6e-10040-0 |
b12fb5ae0fb6e2f4508f46686fcd1bd578b3320c | Address of donor: 2 Hamlet Mews, London SE21 8HG | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 44 | 2015-01-06-8f616a6e-10040-0 |
b5ab364f2d48dc8f52970e78bb3bfa7479a21604 | Date of receipt: 10 November 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 46 | 2015-01-06-8f616a6e-10040-0 |
fc478846e3b799f131ee1385f5215b4f02e0b32c | Donor status: company, registration no 05055257 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 48 | 2015-01-06-8f616a6e-10040-0 |
1c2708fb7d319c77fb39aa1e63ad59cebfc57056 | Name of donor: London College of Accountancy Ltd | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 50 | 2015-01-06-8f616a6e-10040-0 |
6bdd632896b3499df32d20259318eb07be757c82 | Address of donor: 19 Charterhouse St, London EC1N 6RA | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 51 | 2015-01-06-8f616a6e-10040-0 |
0d6a475ef8a6a7ae9361c45f4b0ce41a7fe2761d | Donor status: company, registration no 03914791 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 55 | 2015-01-06-8f616a6e-10040-0 |
b365707ec337800baf63c17fd9d168aba4d63df5 | Name of donor: Lord Gulam Noon | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 57 | 2015-01-06-8f616a6e-10040-0 |
05d99c1c69bda94747eb231005260fd810765609 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 59 | 2015-01-06-8f616a6e-10040-0 |
c80062db0590830ab59f2f7ce3d3ca3bce02a5ef | Date of receipt: 18 November 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 60 | 2015-01-06-8f616a6e-10040-0 |
1fa75d67975c2ede2666c015458815f108adc905 | Date of acceptance: 21 November 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 61 | 2015-01-06-8f616a6e-10040-0 |
496619921235b0139ac3b220d56c58558ad49f0c | (Registered 5 December 2014) | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 63 | 2015-01-06-8f616a6e-10040-0 |
88c2647277c2b48ec87837ea173b6946e826c873 | Name of donor: Mr Kishorkant Bhatessa | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 64 | 2015-01-06-8f616a6e-10040-0 |
3ee8626f0581775cdc0282e69073d5784822f58c | Address of donor: private | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 65 | 2015-01-06-8f616a6e-10040-0 |
cc7e98f4a10ef8faa89839349160404b7b20385a | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 66 | 2015-01-06-8f616a6e-10040-0 |
dac850abb2728c0c7caf9e14821bf69d39e4f201 | Date of receipt: 20 November 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 67 | 2015-01-06-8f616a6e-10040-0 |
adfc3bc3895c390e0afcbbf0ec805c0e1ab915fc | Date of acceptance: 15 December 2014 | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 68 | 2015-01-06-8f616a6e-10040-0 |
b0ed4a688e6529d6bbd4dcba6f35fb8a465d7f79 | Donor status: individual | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 69 | 2015-01-06-8f616a6e-10040-0 |
516f8650f3b76c4beeb5fdf1d74efbc143342654 | (Registered 23 December 2014) | Sponsorships 8f616a6e | 2015-01-06 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 70 | 2015-01-06-8f616a6e-10040-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");