items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where record_id = "2014-06-30-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 |
---|---|---|---|---|---|---|---|
5a4d29b89c33d3b18c0d787fcb6ac3455634284a | Donations to my campaign for re-election to the House of Commons were received as follows: | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 0 | 2014-06-30-8f616a6e-10040-0 |
c42c3c818f312e8ebfbb7ac120240c386110c448 | Name of donor: Sun Mark Ltd | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 1 | 2014-06-30-8f616a6e-10040-0 |
6780d744f1eecdd7d0e868db01a72453945f4f0c | Address of donor: Sun House, 428 Long Drive, Greenford, Middlesex UB6 8UH | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 2 | 2014-06-30-8f616a6e-10040-0 |
3c2cf77cb7f34d9ce039ef9634ffd2de5a9c33f9 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 3 | 2014-06-30-8f616a6e-10040-0 |
078f4bff87e422b74ad28c441859cb5ee6cfd238 | Date of receipt: 10 October 2013 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 4 | 2014-06-30-8f616a6e-10040-0 |
57e7e28609d888f91054293ced945ed6a605d99f | Date of acceptance: 4 December 2013 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 5 | 2014-06-30-8f616a6e-10040-0 |
60628ae7807b3f12327efd99d334d2d14b3d00bb | Donor status: company, registration 03010238 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 6 | 2014-06-30-8f616a6e-10040-0 |
ef93fd3dc49b7147f4ea1304417d207f37227d81 | (Registered 9 December 2013) | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 7 | 2014-06-30-8f616a6e-10040-0 |
30941353e892a58ae076b5ea758b5a2538535fbf | Name of donor: Michael Keegan | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 8 | 2014-06-30-8f616a6e-10040-0 |
9e1cd1c5b3ce1aecd9615a63441dc3f4ca18223e | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 10 | 2014-06-30-8f616a6e-10040-0 |
1ce73de68a82abb524bcc6a83b708e762240e0a0 | Date of receipt: 16 March 2014 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 11 | 2014-06-30-8f616a6e-10040-0 |
c68acc1749ef4bf0af4ecc554c10af38a81fcdbf | Name of donor: Lord Levy | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 15 | 2014-06-30-8f616a6e-10040-0 |
f60db96c42297f5fabc61cfbc90a068187ca6cf6 | Address of donor: private | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 16 | 2014-06-30-8f616a6e-10040-0 |
7297cdf35aa07ab19fc04b097556b5dac6bce4f0 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 17 | 2014-06-30-8f616a6e-10040-0 |
1fd6327fe72d710c44c20b62ebf7571261ce01c5 | Date of receipt: 18 March 2014 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 18 | 2014-06-30-8f616a6e-10040-0 |
a44d52f830caff3836df0125e32b9f5552ce9f31 | Date of acceptance: 24 March 2014 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 19 | 2014-06-30-8f616a6e-10040-0 |
d404679fb13761679469942eab951c6952fd7911 | Donor status: individual | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 20 | 2014-06-30-8f616a6e-10040-0 |
b351f24137ae8ffe5861705b911aa3bd7831a797 | (Registered 27 March 2014) | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 21 | 2014-06-30-8f616a6e-10040-0 |
eacddfdc2f06263ac037983fae2fd509accb48ba | Name of donor: Vascroft Contractors Ltd | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 22 | 2014-06-30-8f616a6e-10040-0 |
48e8301edf4776cf92cb78e5b014b5351a495be6 | Address of donor: Vascroft Estate, 861 Coronation Rd, London NW10 7PT | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 23 | 2014-06-30-8f616a6e-10040-0 |
b519dfd3e8a3f23539c481a2e2809383c034fb8a | Amount of donation or nature and value if donation in kind: £3,500 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 24 | 2014-06-30-8f616a6e-10040-0 |
d455132d29d5f30d550cd2cb407827db50d70959 | Date of receipt: 23 May 2014 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 25 | 2014-06-30-8f616a6e-10040-0 |
61e197ee0f21fae9836ff8b06c4e7295ea7fd283 | Date of acceptance: 18 June 2014 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 26 | 2014-06-30-8f616a6e-10040-0 |
dfdef2831d0d39d7e4792e6b90a2f208479398b9 | Donor status: company, registration no 1293674 | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 27 | 2014-06-30-8f616a6e-10040-0 |
03554253d1de3bf54c48ff3a2333d1a98aa38f79 | (Registered 19 June 2014) | Sponsorships 8f616a6e | 2014-06-30 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 28 | 2014-06-30-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");