items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where record_id = "2014-01-20-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 |
---|---|---|---|---|---|---|---|
7f554f20ad19c655367040857ac30b38fe22ccb7 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2014-01-20-8f616a6e-24913-0 |
58242bb9bf6a2d2c05aece2ca79d64349686366f | 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-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2014-01-20-8f616a6e-24913-0 |
04e8dac7988daa6d5baf83417f9e886940a133a0 | Date of receipt: 29 April 2013 Date of acceptance: 30 April 2013 Donor status: company, registration 05757208 | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 2 | 2014-01-20-8f616a6e-24913-0 |
439b16b85b69d8e72ad405cc065250a6e19e153f | (Registered 13 May 2013) | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2014-01-20-8f616a6e-24913-0 |
b94ebcc956a11e9621ebbc293781b135b24c9b65 | Name of donor: Microsoft Limited | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2014-01-20-8f616a6e-24913-0 |
d76b1c92b52d3fbb50cb7cc0ef4d81c270505eb7 | Address of donor: Microsoft Campus, Thames Valley Business Park , Reading , RG6 1WG | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2014-01-20-8f616a6e-24913-0 |
317c42d5a3f6b42f7898ac6249d700b732f8985d | 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-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2014-01-20-8f616a6e-24913-0 |
b26a03f1b55cb9e852a35976ead6887d24217028 | Date of receipt: 17 July 2013 | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2014-01-20-8f616a6e-24913-0 |
aea41354d3038bd3c9c7dcc0e5bd3ab6f6611366 | Date of acceptance: 17 July 2013 | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2014-01-20-8f616a6e-24913-0 |
b869e3b3d69004b7c14f26435907edd00db9d0d0 | Donor status: company registration 01624297 | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 9 | 2014-01-20-8f616a6e-24913-0 |
e676ef978d6739907acf299e44fa99b458b8e202 | (Registered 24 July 2013; updated 1 August 2013) | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 10 | 2014-01-20-8f616a6e-24913-0 |
15988d66aab818bfaf78bd1001413e0ea9f0970d | Name of donor: Mrs Pavita Cooper | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2014-01-20-8f616a6e-24913-0 |
d559e700a1edc7ef4ab770f8835c38c50e92f000 | Address of donor: private | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2014-01-20-8f616a6e-24913-0 |
5faadcab4a51009226fed5af3f932e6faf1a5fef | Amount of donation or nature and value if donation in kind: catering and hosting of fundraising event; value £3,500 | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2014-01-20-8f616a6e-24913-0 |
487aa98651ad544ae46fc9c0fb8f1e92a8421330 | Date of receipt: 22 October 2013 | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 14 | 2014-01-20-8f616a6e-24913-0 |
20cdf15b87af8b9fb31d6f74c0adf164a94e176f | Date of acceptance: 22 October 2013 | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 15 | 2014-01-20-8f616a6e-24913-0 |
b6950159ebb5117c23ff32a7eef4ab40b01623d5 | Donor status: individual | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2014-01-20-8f616a6e-24913-0 |
5227de969f2936f775c905a44938f48191f20173 | (Registered 14 November 2013) | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 17 | 2014-01-20-8f616a6e-24913-0 |
383da25cf3583f678d294c87405df128aeaae035 | 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-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2014-01-20-8f616a6e-24913-0 |
1e38326e8bac9608e08e0378e4f979e110c84a33 | Date of receipt: 3 December 2013 Date of acceptance: 3 December 2013 Donor status: company, registration no 01991017 | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2014-01-20-8f616a6e-24913-0 |
b6db3f0df230565f39eff0ddb92e435e9cd41490 | (Registered 19 December2013) | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2014-01-20-8f616a6e-24913-0 |
5f6a7bbf888bb73748460afd3f205005307f2efe | Name of donor: Mr Henry Angest Address of donor: private | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2014-01-20-8f616a6e-24913-0 |
d01fe59d3cb4bd1114c4a4b2c557f2a58c21fab3 | Amount of donation or nature and value if donation in kind: £2,000; sponsorship for community projects | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2014-01-20-8f616a6e-24913-0 |
debc2bcfc7c32d58b49b572e24e4ff1154fcf65f | Date of receipt: 2 December 2013 Date of acceptance: 2 December 2013 Donor status: individual | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2014-01-20-8f616a6e-24913-0 |
7c7977fc9b305a797f168ce7780f750f86271663 | (Registered 19 December 2013) | Sponsorships 8f616a6e | 2014-01-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2014-01-20-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");