items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
36 rows where record_id = "2014-11-10-8f616a6e-10040-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 |
---|---|---|---|---|---|---|---|
93bb5347618d901c83b62303480355ff858e3c32 | Donations to my campaign for re-election to the House of Commons were received as follows: | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 0 | 2014-11-10-8f616a6e-10040-0 |
a9650c64627eac84cdf132e833f9d763880dee1e | Name of donor: Sun Mark Ltd | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 1 | 2014-11-10-8f616a6e-10040-0 |
1c204ad7677af79c09fd261747fab3551fa28f4a | Address of donor: Sun House, 428 Long Drive, Greenford, Middlesex UB6 8UH | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 2 | 2014-11-10-8f616a6e-10040-0 |
23a23f7978e26d70844c049acc5e8603e5ad8d76 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 3 | 2014-11-10-8f616a6e-10040-0 |
5f4bdbf5ffdd31801daf771d3ce52294d0668389 | Date of receipt: 10 October 2013 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 4 | 2014-11-10-8f616a6e-10040-0 |
9cde8260d40afbb4c074c1d45a0e38324dfdeacb | Date of acceptance: 4 December 2013 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 5 | 2014-11-10-8f616a6e-10040-0 |
578ac4ce965127bcc0c9d844240fa5861bf592ed | Donor status: company, registration 03010238 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 6 | 2014-11-10-8f616a6e-10040-0 |
6bdce17d2c10e39d3755a2b1744c9b007114330b | (Registered 9 December 2013) | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 7 | 2014-11-10-8f616a6e-10040-0 |
d51f8b83eced43029b5bdebf65f23cf2315842ae | Name of donor: Michael Keegan | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 8 | 2014-11-10-8f616a6e-10040-0 |
ef5e0235881a3bcf139423dfed25c3ef741827f9 | Date of receipt: 16 March 2014 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 11 | 2014-11-10-8f616a6e-10040-0 |
dce791ca6c6e4d8bb0bdb9688102c04e3de8915c | Name of donor: Lord Levy | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 15 | 2014-11-10-8f616a6e-10040-0 |
1cb1e84f6fbf7ca191c3f9c871fc4ada34b1881a | Address of donor: private | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 16 | 2014-11-10-8f616a6e-10040-0 |
0d15c51655eb77f9d957c30daa0fe4ac4e2740c7 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 17 | 2014-11-10-8f616a6e-10040-0 |
bcb3dbdb38efc5a6a1232bb890c85dc00d6fead5 | Date of receipt: 18 March 2014 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 18 | 2014-11-10-8f616a6e-10040-0 |
7d72f5a597b733a9ab33be014a4d09aac2fc86cc | Date of acceptance: 24 March 2014 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 19 | 2014-11-10-8f616a6e-10040-0 |
026e631e55522262a0e3668180a836dde96718eb | Donor status: individual | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 20 | 2014-11-10-8f616a6e-10040-0 |
8bcf48bd70f2bc026d84ef84c1b90fa1ee33e0f7 | (Registered 27 March 2014) | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 21 | 2014-11-10-8f616a6e-10040-0 |
64bc8ec110d541dbee0fa46ee929f40ab4514df0 | Name of donor: Vascroft Contractors Ltd | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 22 | 2014-11-10-8f616a6e-10040-0 |
06b8515e55c9019099ab085bec5b053014ba8278 | Address of donor: Vascroft Estate, 861 Coronation Rd, London NW10 7PT | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 23 | 2014-11-10-8f616a6e-10040-0 |
8c5698a741834dc7955e863bf7db7ecd360204ea | Amount of donation or nature and value if donation in kind: £3,500 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 24 | 2014-11-10-8f616a6e-10040-0 |
38aa4cc6d5bf98a83fefc4713d8f4d24271d1edd | Date of acceptance: 18 June 2014 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 26 | 2014-11-10-8f616a6e-10040-0 |
cc8704c99159ccf5e2c7c5d901f0764eec7d118a | Donor status: company, registration no 1293674 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 27 | 2014-11-10-8f616a6e-10040-0 |
38dc3ed653eabdd3ab3c751c375886480cd4d07c | (Registered 19 June 2014) | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 28 | 2014-11-10-8f616a6e-10040-0 |
ccfda53f62200804e969fe5cbc5fa5d69117f434 | Name of donor: Trust Reservations Ltd | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 29 | 2014-11-10-8f616a6e-10040-0 |
ad567cafae57e7f2599c79d15ed65c7662870974 | Address of donor: 6 Oxford St, Lambourn, Hungerford, RG17 8XP | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 30 | 2014-11-10-8f616a6e-10040-0 |
a83702643e7f2f248811e984fd5e051651865380 | Date of receipt: 7 June 2014 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 32 | 2014-11-10-8f616a6e-10040-0 |
0d998476f3512073d2c4c2b80af4aebe4834923b | Date of acceptance: 1 July 2014 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 33 | 2014-11-10-8f616a6e-10040-0 |
9512ba736c20dffeaa43a34d2afe41887c16f8b3 | Donor status: company, registration number 03829637 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 34 | 2014-11-10-8f616a6e-10040-0 |
5c7aaad2bbd980aff4d20ed7d63d892ac7d122db | (Registered 1 July 2014 ) | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 35 | 2014-11-10-8f616a6e-10040-0 |
5edf8ef7cc3a35e6480f1d97220ed48d8389de98 | Name of donor: Madhu’s Ltd | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 36 | 2014-11-10-8f616a6e-10040-0 |
ac048bd33eedb91de0c7e9f91210256d4b165d2c | Address of donor: 39 South Road, Southall, UB1 1SW | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 37 | 2014-11-10-8f616a6e-10040-0 |
a0d378a058bf62e1369c5e88dab8544e68062235 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 38 | 2014-11-10-8f616a6e-10040-0 |
373be84fb5c61555aac9d9194cee730ff2babc8d | Date of receipt: 23 May 2014 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 39 | 2014-11-10-8f616a6e-10040-0 |
aec4054af6148512ad56c2c636e60b228b663973 | Date of acceptance: 16 June 2014 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 40 | 2014-11-10-8f616a6e-10040-0 |
e7747af192d8697f50846cf5c64db1f6c01727bb | Donor status: company, registration no 04580937 | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 41 | 2014-11-10-8f616a6e-10040-0 |
0b7639cab5d94d681117375565f636076620a3c8 | (Registered 1 July 2014) | Sponsorships 8f616a6e | 2014-11-10 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 42 | 2014-11-10-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");