items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2014-01-06-8f616a6e-24913-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 |
---|---|---|---|---|---|---|---|
9e31695f47427138365863e6e59b5de913587619 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2014-01-06-8f616a6e-24913-0 |
ab6ecede21e46be273f39126044f1932cf1851a6 | Name of donor: Mr Michael Farmer | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2014-01-06-8f616a6e-24913-0 |
e20311b6353ea60f3db961937873e70cf151a0e3 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2014-01-06-8f616a6e-24913-0 |
31af5b71a7dfac22a8e3e459c4987e16f69ccc15 | Date of receipt: 14 January 2013 | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2014-01-06-8f616a6e-24913-0 |
c7ff33552062b1384365560a58c87f3ef856dae9 | Date of acceptance: 16 January 2013 | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2014-01-06-8f616a6e-24913-0 |
0dcd1f74a94692600a60f9f6ac4f73e7f376ab6c | (Registered 17 January 2013) | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2014-01-06-8f616a6e-24913-0 |
307e3695cf441ab7412e8665f03ac42dbb14fb87 | 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-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2014-01-06-8f616a6e-24913-0 |
0cc976591832c9b21f6a4c5c814199d33072c770 | Date of receipt: 29 April 2013 Date of acceptance: 30 April 2013 Donor status: company, registration 05757208 | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 9 | 2014-01-06-8f616a6e-24913-0 |
14973bf8e5265ba65641ac834284e16d5dc35e1c | (Registered 13 May 2013) | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 10 | 2014-01-06-8f616a6e-24913-0 |
40102483657a6d669b6360c0d28938475e53a3e2 | Name of donor: Microsoft Limited | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2014-01-06-8f616a6e-24913-0 |
c09fc6b2fe50a248193d780bd4ca165d8fed253c | Address of donor: Microsoft Campus, Thames Valley Business Park, Reading, RG6 1WG | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2014-01-06-8f616a6e-24913-0 |
bc9e1a5f4c316b0a7f55663cc45f97a73d7864ca | 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-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2014-01-06-8f616a6e-24913-0 |
41cee1887aa5f6965c62a482bf53998e41254853 | Date of receipt: 17 July 2013 | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 14 | 2014-01-06-8f616a6e-24913-0 |
6703ec3192e7d7c5f7572f6d282534ddfb1e845c | Date of acceptance: 17 July 2013 | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 15 | 2014-01-06-8f616a6e-24913-0 |
f1b7589347438a1b022c9d7d8d34f98904d2596e | Donor status: company registration 01624297 | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2014-01-06-8f616a6e-24913-0 |
34e80727ba4697c8d78aa5d864b05488477ed9b3 | (Registered 24 July 2013; updated 1 August 2013) | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 17 | 2014-01-06-8f616a6e-24913-0 |
f1d8fdf592826c41cc3a9fe549e8078fec724d18 | Name of donor: Mrs Pavita Cooper | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2014-01-06-8f616a6e-24913-0 |
8a1d59d00edfa495c0fa3e2ade1d912ded2decbb | Address of donor: private | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2014-01-06-8f616a6e-24913-0 |
87002863f71400f3a0180f688548ae892c4ac2a4 | Amount of donation or nature and value if donation in kind: catering and hosting of fundraising event; value £3,500 | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2014-01-06-8f616a6e-24913-0 |
41a051de2991b3a573803be12292679248d2ffe0 | Date of receipt: 22 October 2013 | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2014-01-06-8f616a6e-24913-0 |
6f7e0b9fbc305c60cc08d2635fd6b7290aacf424 | Date of acceptance: 22 October 2013 | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2014-01-06-8f616a6e-24913-0 |
c88f275f07205255d9867d0a39b9fd99495a9cfa | Donor status: individual | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2014-01-06-8f616a6e-24913-0 |
aae363aa01d22221972a0086ee0f465f8f90b928 | (Registered 14 November 2013) | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2014-01-06-8f616a6e-24913-0 |
7d3e65adcf7d18bf4af0fde7812c5337782fb7b8 | 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-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2014-01-06-8f616a6e-24913-0 |
59ffc2ce8dc1bfe68defbeb7e10b95850037b72a | Date of receipt: 3 December 2013 Date of acceptance: 3 December 2013 Donor status: company, registration no 01991017 | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2014-01-06-8f616a6e-24913-0 |
4c7aba62fd38d75e39ebe64ff5dc5322251c0ce3 | (Registered 19 December 2013) | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2014-01-06-8f616a6e-24913-0 |
019c8fa88987e2f325cfcf83a9cfd79732a8e0a4 | Name of donor: Mr Henry Angest Address of donor: private | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 28 | 2014-01-06-8f616a6e-24913-0 |
3a4a9382ed1e7eb2bf9d12eeae16be93498110c6 | Amount of donation or nature and value if donation in kind: £ 2 ,000; sponsorship for community projects | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 29 | 2014-01-06-8f616a6e-24913-0 |
d1e4f7276eea7965a2b7adadf7c68534f06e2091 | Date of receipt: 2 December 2013 Date of acceptance: 2 December 2013 Donor status: individual | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 30 | 2014-01-06-8f616a6e-24913-0 |
54c8b5d6f7be66cb80a674b2276588e1cec780cd | (Registered 19 December 2013) | Sponsorships 8f616a6e | 2014-01-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 31 | 2014-01-06-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");