items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
45 rows where "date" is on date 2014-06-30 and member_id = "uk.org.publicwhip/member/40115" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, record_id
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
f5d4d223a3fd77fbba31a36239cdbca4ea063655 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2014-06-30-8f616a6e-24913-0 |
c993f3529fc704bdcc68743bc4be70ebd3d298af | Name of donor: Microsoft Limited | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2014-06-30-8f616a6e-24913-0 |
fafb4bbeee962fb96b3461d5d07ccb948a98fe95 | Address of donor: Microsoft Campus, Thames Valley Business Park, Reading, RG6 1WG | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 2 | 2014-06-30-8f616a6e-24913-0 |
258201ec08627708e3e3996f9fa6459786bb9489 | 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-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2014-06-30-8f616a6e-24913-0 |
4b24c15eb19c4bb0b6104d9b7606dfc5c560f095 | Date of receipt: 17 July 2013 | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2014-06-30-8f616a6e-24913-0 |
e00cf6084767b98999be9ecdff940ff51cc24138 | Date of acceptance: 17 July 2013 | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2014-06-30-8f616a6e-24913-0 |
f92f8f9655cb8e9a2d9c2a20233b2c6c45459b50 | Donor status: company registration 01624297 | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2014-06-30-8f616a6e-24913-0 |
94ea01da35d5412cf1b4c1e47201af798a479d10 | (Registered 24 July 2013; updated 1 August 2013) | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2014-06-30-8f616a6e-24913-0 |
f49c46e050d1cd73d9c7742b2f8b8d1eba26bea6 | Name of donor: Mrs Pavita Cooper | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2014-06-30-8f616a6e-24913-0 |
0b455ac07af76de3993539ecb31a1d9296826994 | Amount of donation or nature and value if donation in kind: catering and hosting of fundraising event; value £3,500 | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 10 | 2014-06-30-8f616a6e-24913-0 |
c369f13c4390c05b1c9921890ec990ed3901830d | Date of receipt: 22 October 2013 | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2014-06-30-8f616a6e-24913-0 |
0f64409f5b5fba7c166984e2026e3ad5dcfa9492 | Date of acceptance: 22 October 2013 | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2014-06-30-8f616a6e-24913-0 |
e467f24ba28e9888420e23f01533474d2b037500 | (Registered 14 November 2013) | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 14 | 2014-06-30-8f616a6e-24913-0 |
b141edb201651b35082cb9dac428bf87e0c4d438 | Name of donor: Heathrow Airport Ltd | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 15 | 2014-06-30-8f616a6e-24913-0 |
445d66821bb7da64a05f0c8bdd3637922aca0312 | Address of donor: The Compass Centre, Nelson Road, Hounslow TW6 2GW | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2014-06-30-8f616a6e-24913-0 |
401909029792667241eab60e77eac7e5fec82e95 | 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-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 17 | 2014-06-30-8f616a6e-24913-0 |
0c61298c8ad0414b693f599c2b1fac50b63972c5 | Date of receipt: 3 December 2013 | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2014-06-30-8f616a6e-24913-0 |
5a424fd88418418f4a972b59ea5876d93e0b78b2 | Date of acceptance: 3 December 2013 | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2014-06-30-8f616a6e-24913-0 |
5da84f17edfeb2915cc17de1b0c8806d3afd0dad | Donor status: company, registration no 01991017 | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2014-06-30-8f616a6e-24913-0 |
6dc31cc1badc3a21c80b0a9199948d2069ab782d | Name of donor: Mr Henry Angest | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2014-06-30-8f616a6e-24913-0 |
0c14d9f9bef329940b293e27e24bcc0c233a5fc8 | Address of donor: private | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2014-06-30-8f616a6e-24913-0 |
7c67b88001cd64d3b4ea99a79530f32d57d76cf5 | Amount of donation or nature and value if donation in kind: £2,000; sponsorship for community projects | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2014-06-30-8f616a6e-24913-0 |
e198b1b40ca6eefb8f4964a4395afc72408b8a76 | Date of receipt: 2 December 2013 | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2014-06-30-8f616a6e-24913-0 |
bd398495dbdbd90fd6909c546ab384837d30eadb | Date of acceptance: 2 December 2013 | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2014-06-30-8f616a6e-24913-0 |
f52c650496650775b7b0d649212bce92ecb70bf1 | Donor status: individual | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2014-06-30-8f616a6e-24913-0 |
2871de6e8ec24baacc793f874a577b21026e7700 | (Registered 19 December 2013) | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 28 | 2014-06-30-8f616a6e-24913-0 |
220ffb86ebd6912d982877f670dd13d1f3d8d0ca | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 29 | 2014-06-30-8f616a6e-24913-0 |
14810567a14b15ea544e964b1eaf74d1082b778f | Address of donor: 18 Thorney Lane North, Iver, Buckinghamshire, SL0 9JY | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 30 | 2014-06-30-8f616a6e-24913-0 |
76b8aa292c42baac02621692fbbbe8033092297c | Amount of donation or nature and value if donation in kind: £2,500 sponsorship for campaign community projects | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 31 | 2014-06-30-8f616a6e-24913-0 |
48a6bd32474cf6bcb30f8b6de796c46c709e8699 | Date of receipt: 3 January 2014 Date of acceptance: 3 January 2014 Donor status: Members’ Association | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 32 | 2014-06-30-8f616a6e-24913-0 |
22deb502e202925f6c7b0a6ffc7cc799ce20c642 | (Registered 14 February 2014) | Sponsorships 8f616a6e | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 33 | 2014-06-30-8f616a6e-24913-0 |
761f40e1f18006ca00449370974207695df22dc0 | Name of donor: Mr Baljinder Hansra | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2014-06-30-80ef1083-24913-0 |
2a3b13554219d3eb4a96eddfc494a08c0437fda5 | Address of donor: private | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2014-06-30-80ef1083-24913-0 |
05a2913a07cfe4371dd2c593db320f83c36a82ac | Amount of donation (or estimate of the probable value): reimbursement of £918.75 for flights | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 2 | 2014-06-30-80ef1083-24913-0 |
2f6ac0190862661ee6951a436bc6d3e02e465258 | Destination of visit: India | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2014-06-30-80ef1083-24913-0 |
8fe6bb271999ebbcd71e9202d8070b296d76a8f9 | Date of visit: 3 to 9 October 2013 | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2014-06-30-80ef1083-24913-0 |
bc0ebe6cea66f3872b74ed566ca60036e6085ec3 | Purpose of visit: visit with local Gurdwara to see their charitable projects in the Punjab | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2014-06-30-80ef1083-24913-0 |
2d11d0a225bf67123789c2543683d58376c4c5fd | (Registered 19 December 2013) | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2014-06-30-80ef1083-24913-0 |
c398fec7a6ea0d361360abe8c16fe0318e767096 | Name of donor: Save the Children International | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2014-06-30-80ef1083-24913-0 |
df09412ecff43f5354c07921893b15d97504567e | Address of donor: 1 St John's Lane, London EC1M 4AR | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2014-06-30-80ef1083-24913-0 |
627677f99d0cbe5b4a7afb3601c2d8c686fb3d1c | Amount of donation (or estimate of the probable value: r eturn flight and transfers with a value of £789.15, accommodation with a value of £359.95, and refreshments valued at £38.80; £1,187.90 in total | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 9 | 2014-06-30-80ef1083-24913-0 |
6c114d0bb131daa804a40c2c7e6461eaadc6a0a1 | Destination of visit: Liberia | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 10 | 2014-06-30-80ef1083-24913-0 |
668408fa7b58b80ca3ea4007fa430917ec0bc135 | Date of visit: 1 February 2014 to 5 February 2014 | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2014-06-30-80ef1083-24913-0 |
52fdad8228173e246a33e1be65a0b67ee0b28ee9 | Purpose of visit: To review issues with maternal health, visit projects and meet Minister for Health | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2014-06-30-80ef1083-24913-0 |
63c9be285e0bce571c8cd34362667ea18875eac3 | (Registered 14 February 2014) | Overseas visits 80ef1083 | 2014-06-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2014-06-30-80ef1083-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");