items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2014-03-24-8f616a6e-24913-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
8763998b44d708772c4048740a213f83d351b845 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2014-03-24-8f616a6e-24913-0 |
edc1ee2b1df012c208f2a1d21df15d64897ace06 | Name of donor: Heathrow Airport Holdings Limited Address of donor: The Compass Centre, Nelson Road, Hounslow, Middlesex TW6 2GW Amount of donation or nature and value if donation in kind: £5,000; sponsorship to meet costs and expenses of local community project organised by the MP | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2014-03-24-8f616a6e-24913-0 |
3996c50fd1d7260df00bf70db68a8fedd8653ce9 | Date of receipt: 29 April 2013 Date of acceptance: 30 April 2013 Donor status: company, registration 05757208 | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 2 | 2014-03-24-8f616a6e-24913-0 |
7e56091759517da3c9e3cf7b30cbab1b9522d866 | (Registered 13 May 2013) | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2014-03-24-8f616a6e-24913-0 |
520c3d493944c59f481c45fef0af6a2a513f7ceb | Name of donor: Microsoft Limited | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2014-03-24-8f616a6e-24913-0 |
f571dc2f7ac276d82703ffd7304a01f294083802 | Address of donor: Microsoft Campus, Thames Valley Business Park, Reading, RG6 1WG | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2014-03-24-8f616a6e-24913-0 |
6ab90c421a0afc2f4fa93dba2765f821a1385b76 | Amount of donation: £18,148.65; sponsorship for the Executive Women in the Workplace Inquiry report, which I co-authored with another Member. | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2014-03-24-8f616a6e-24913-0 |
142fda4326113ef9e7da5f86d4d49008c3b03842 | Date of receipt: 17 July 2013 | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2014-03-24-8f616a6e-24913-0 |
474b604bfbf5e99b82b6365315296b2daea26b19 | Date of acceptance: 17 July 2013 | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2014-03-24-8f616a6e-24913-0 |
ff61277d63dc27a1efb7a40ebe66cae37cc1feac | Donor status: company registration 01624297 | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 9 | 2014-03-24-8f616a6e-24913-0 |
8fc4ab007ef40fc1e3bc736d1c2a2d5f566f0fa8 | (Registered 24 July 2013; updated 1 August 2013) | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 10 | 2014-03-24-8f616a6e-24913-0 |
fc41443161101045aea5c3e044d1ad7346860ad5 | Name of donor: Mrs Pavita Cooper | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2014-03-24-8f616a6e-24913-0 |
62b25a60809cd59f49064783fe681c7febb9481a | Address of donor: private | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2014-03-24-8f616a6e-24913-0 |
e5510fec641b283859b46f364c286910b0888f9c | Amount of donation or nature and value if donation in kind: catering and hosting of fundraising event; value £3,500 | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2014-03-24-8f616a6e-24913-0 |
7437c7741e3594b71bd4eb7269dc8a0cf82218a4 | Date of receipt: 22 October 2013 | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 14 | 2014-03-24-8f616a6e-24913-0 |
c1d19ab4d990374e2f51c0acf1e4f10ba96045c2 | Date of acceptance: 22 October 2013 | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 15 | 2014-03-24-8f616a6e-24913-0 |
a65a0e78e04d721c58177c899087fd1ae81883dc | Donor status: individual | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2014-03-24-8f616a6e-24913-0 |
50a952d32692e9b9b9cff5d0f71edd2f31632a29 | (Registered 14 November 2013) | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 17 | 2014-03-24-8f616a6e-24913-0 |
c93fe1783179570aa84961ddd7e2bf9a82278675 | Name of donor: Heathrow Airport Limited Address of donor: The Compass Centre, Nelson Road, Hounslow, Middlesex TW6 2GW Amount of donation or nature and value if donation in kind: £5,000; sponsorship for 2014 West London Jobs and Apprenticeships Fair | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2014-03-24-8f616a6e-24913-0 |
0ba283988d517949ab72234655f67912352915ad | Date of receipt: 3 December 2013 Date of acceptance: 3 December 2013 Donor status: company, registration no 01991017 | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2014-03-24-8f616a6e-24913-0 |
ed2dbe0991a62b52be757ee2fcf4651d885ca641 | (Registered 19 December2013) | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2014-03-24-8f616a6e-24913-0 |
38a971394e899e33d4c9c07861f833c6008e15de | Name of donor: Mr Henry Angest Address of donor: private | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2014-03-24-8f616a6e-24913-0 |
03b86a65b6a6ac065f4d0867f3cc22104801e908 | Amount of donation or nature and value if donation in kind: £2,000; sponsorship for community projects | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2014-03-24-8f616a6e-24913-0 |
74f6864c7d4b72237cfea039d62aa263b187c1d0 | Date of receipt: 2 December 2013 Date of acceptance: 2 December 2013 Donor status: individual | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2014-03-24-8f616a6e-24913-0 |
f3b348c7e97df26c171ca1ee24e97cc9d2dcd6c5 | (Registered 19 December 2013) | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2014-03-24-8f616a6e-24913-0 |
dd0f425bb4d072a75026eb7242235cbf9e914d53 | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2014-03-24-8f616a6e-24913-0 |
2340f7ce386e0a7d0433410975bcef64736abdf6 | Address of donor: 18 Thorney Lane North, Iver, Buckinghamshire, SL0 9JY | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2014-03-24-8f616a6e-24913-0 |
6a7298af17ae0744c86c6f11a521dc4530d5cfec | Amount of donation or nature and value if donation in kind: £2,500 sponsorship for campaign community projects | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2014-03-24-8f616a6e-24913-0 |
2a17b9f996f7f1363a7c86185297e96a89a7053c | Date of receipt: 3 January 2014 Date of acceptance: 3 January 2014 Donor status: Members’ Association | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 28 | 2014-03-24-8f616a6e-24913-0 |
4dd9909cc63193c99c5d443a05a9ea97d59eab60 | (Registered 14 February 2014) | Sponsorships 8f616a6e | 2014-03-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 29 | 2014-03-24-8f616a6e-24913-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");