items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
36 rows where record_id = "2014-07-14-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 |
---|---|---|---|---|---|---|---|
23bee33f740008937c2788996744c2f6b657641d | Donations to my campaign for re-election to the House of Commons were received as follows: | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 0 | 2014-07-14-8f616a6e-10040-0 |
fbce834b19ce8eb2380dffaf3822e56c06fa45b6 | Name of donor: Sun Mark Ltd | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 1 | 2014-07-14-8f616a6e-10040-0 |
46494abf7bc6a886caa7e77a84d58381135ac7f6 | Address of donor: Sun House, 428 Long Drive, Greenford, Middlesex UB6 8UH | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 2 | 2014-07-14-8f616a6e-10040-0 |
5894e4fa5a95a682c8d6e5688e5da52361c242d0 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 3 | 2014-07-14-8f616a6e-10040-0 |
2974263415a7f3fbe11dfb349f0c62fbfee9d514 | Date of receipt: 10 October 2013 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 4 | 2014-07-14-8f616a6e-10040-0 |
8c37f9ea29d35033f3e814981520cfe940a1221b | Date of acceptance: 4 December 2013 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 5 | 2014-07-14-8f616a6e-10040-0 |
8d0570f6205e9d34b63cfdbae40451af124f9aa4 | Donor status: company, registration 03010238 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 6 | 2014-07-14-8f616a6e-10040-0 |
448b1eed436e7bf17e39e452b149618b39ae160e | (Registered 9 December 2013) | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 7 | 2014-07-14-8f616a6e-10040-0 |
8411a093d7e102f17aa2ce4b7422d51285cbc67a | Name of donor: Michael Keegan | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 8 | 2014-07-14-8f616a6e-10040-0 |
97d8da88ef63084f365263bd880325e41822ade8 | Date of receipt: 16 March 2014 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 11 | 2014-07-14-8f616a6e-10040-0 |
2d77358d8c853beca63211218cd6e37c4a137510 | Name of donor: Lord Levy | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 15 | 2014-07-14-8f616a6e-10040-0 |
8cce3f6a0f6cab9e760574140993b7caac582ca5 | Address of donor: private | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 16 | 2014-07-14-8f616a6e-10040-0 |
35676071fd1946a19cf1a73c2421008e5913cde7 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 17 | 2014-07-14-8f616a6e-10040-0 |
33a427069cc3374ea8772780c2c242bf4423bb17 | Date of receipt: 18 March 2014 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 18 | 2014-07-14-8f616a6e-10040-0 |
f0a38c8bf1bb14f96e74e37ca2513582637bbbca | Date of acceptance: 24 March 2014 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 19 | 2014-07-14-8f616a6e-10040-0 |
e9acb6124e35400bf0f2af4162f48b52051242b0 | Donor status: individual | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 20 | 2014-07-14-8f616a6e-10040-0 |
23eb20edd04db4d71f5b5f3c419c4f61e5e44df0 | (Registered 27 March 2014) | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 21 | 2014-07-14-8f616a6e-10040-0 |
0dc122ed6a39ab472de9a1f6f89d66959e3063e5 | Name of donor: Vascroft Contractors Ltd | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 22 | 2014-07-14-8f616a6e-10040-0 |
20ec6e5109a3c83c477c5f21d090384676a2342d | Address of donor: Vascroft Estate, 861 Coronation Rd, London NW10 7PT | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 23 | 2014-07-14-8f616a6e-10040-0 |
0130187fd5ea5c62c9df85a0b646b60828f43c33 | Amount of donation or nature and value if donation in kind: £3,500 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 24 | 2014-07-14-8f616a6e-10040-0 |
314b36ff18ff2c98ad55b19de463f9f11044a5ec | Date of acceptance: 18 June 2014 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 26 | 2014-07-14-8f616a6e-10040-0 |
10544d9793b230779deb764f4ce15f26b922f46d | Donor status: company, registration no 1293674 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 27 | 2014-07-14-8f616a6e-10040-0 |
db1ddcf1ec92c3476c4bbc83c5f1a66140442b4d | (Registered 19 June 2014) | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 28 | 2014-07-14-8f616a6e-10040-0 |
91bc76cbe4c19749b8c3568e34d985811c8721b9 | Name of donor: Trust Reservations Ltd | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 29 | 2014-07-14-8f616a6e-10040-0 |
8727126359428cb1f91d4894bb8194f6a6bdb710 | Address of donor: 6 Oxford St, Lambourn, Hungerford, RG17 8XP | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 30 | 2014-07-14-8f616a6e-10040-0 |
267cdfb2bff25b18e45142ed06de3825d73f54e4 | Date of receipt: 7 June 2014 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 32 | 2014-07-14-8f616a6e-10040-0 |
70c9b7bd6c1afad934b20a60732b531e8d9a991c | Date of acceptance: 1 July 2014 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 33 | 2014-07-14-8f616a6e-10040-0 |
a6fcf96eca2726c9d14aaaf25245dc64f44847e8 | Donor status: company, registration number 03829637 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 34 | 2014-07-14-8f616a6e-10040-0 |
de2af18d8c237010371d7b714155f4d09268fcad | (Registered 1 July 2014 ) | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 35 | 2014-07-14-8f616a6e-10040-0 |
19bf1f9836104bfd38561bb24cb8398636de3daa | Name of donor: Madhu’s Ltd | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 36 | 2014-07-14-8f616a6e-10040-0 |
d667fa50e19fa2f85b2c4425b5195ec7e10b40d2 | Address of donor: 39 South Road, Southall, UB1 1SW | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 37 | 2014-07-14-8f616a6e-10040-0 |
0381744965d7eb384a6f2936809f74004269017c | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 38 | 2014-07-14-8f616a6e-10040-0 |
9b2d2c219d373d53d28b495bce2071cc0b754f81 | Date of receipt: 23 May 2014 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 39 | 2014-07-14-8f616a6e-10040-0 |
70b56d3109ab9e2d616e9b2ec534148701f0acfe | Date of acceptance: 16 June 2014 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 40 | 2014-07-14-8f616a6e-10040-0 |
73b52accd0cddd07c8e0d4f37c293df14500d9f9 | Donor status: company, registration no 04580937 | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 41 | 2014-07-14-8f616a6e-10040-0 |
7a612f60c693719d6510878a184e69a959c9fc7c | (Registered 1 July 2014) | Sponsorships 8f616a6e | 2014-07-14 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 42 | 2014-07-14-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");