items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2014-04-07-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 |
---|---|---|---|---|---|---|---|
fb65a798b90a0f44abdc4dc3f95cafdb9e3e1040 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2014-04-07-8f616a6e-24913-0 |
7f5ab3570bbae92a96cca15b043cec9fe0811527 | 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-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2014-04-07-8f616a6e-24913-0 |
879f743209d7eade4113142fbb7d90b72f8efd40 | Date of receipt: 29 April 2013 Date of acceptance: 30 April 2013 Donor status: company, registration 05757208 | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 2 | 2014-04-07-8f616a6e-24913-0 |
9273744642842b00a98b4f14d7ce067167a99d09 | (Registered 13 May 2013) | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2014-04-07-8f616a6e-24913-0 |
22804c6e45f6aaf20fb5fd794f6f708e80e096d5 | Name of donor: Microsoft Limited | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2014-04-07-8f616a6e-24913-0 |
34cef139ec3f5bea0373999cfde543721b6b4ddf | Address of donor: Microsoft Campus, Thames Valley Business Park, Reading, RG6 1WG | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2014-04-07-8f616a6e-24913-0 |
1ba69ba62d0a96be2ecbaf43b9de20813993bc55 | 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-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2014-04-07-8f616a6e-24913-0 |
a40b28f0a08abee2a95abb2d546e9c72cbf57fd5 | Date of receipt: 17 July 2013 | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2014-04-07-8f616a6e-24913-0 |
79c4b25a3e7348998c56d57ad5e2a545c7ad3dae | Date of acceptance: 17 July 2013 | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2014-04-07-8f616a6e-24913-0 |
e19c6c3379553d14d4ea534e29bfd9687429f0d3 | Donor status: company registration 01624297 | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 9 | 2014-04-07-8f616a6e-24913-0 |
200e2cdff083bbc918150d871f5409198ec40022 | (Registered 24 July 2013; updated 1 August 2013) | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 10 | 2014-04-07-8f616a6e-24913-0 |
0f6a64c77864d177782ae6d570f96aff76ef5843 | Name of donor: Mrs Pavita Cooper | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2014-04-07-8f616a6e-24913-0 |
42f534dcd86019da8f35661af87c0bbd2475db89 | Address of donor: private | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2014-04-07-8f616a6e-24913-0 |
e20360a5e858e9f65e457cd32c28acc7029aeaca | Amount of donation or nature and value if donation in kind: catering and hosting of fundraising event; value £3,500 | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2014-04-07-8f616a6e-24913-0 |
373ddfd095ee211c56573397b5a2d8cdba62a60a | Date of receipt: 22 October 2013 | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 14 | 2014-04-07-8f616a6e-24913-0 |
3fe45f08997314ad0b0369456c12f4e0a052802e | Date of acceptance: 22 October 2013 | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 15 | 2014-04-07-8f616a6e-24913-0 |
05036e47fd7adda1b07602ac8d32ea4388936e64 | Donor status: individual | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2014-04-07-8f616a6e-24913-0 |
67b1997225b9cc96b8a49684f944e917ff9c78c7 | (Registered 14 November 2013) | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 17 | 2014-04-07-8f616a6e-24913-0 |
ac7d425236c51ac66f33ee381869882bc6d287f5 | 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-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2014-04-07-8f616a6e-24913-0 |
0310f602b8ac4a00ecc25ca80fd544617dc448fd | Date of receipt: 3 December 2013 Date of acceptance: 3 December 2013 Donor status: company, registration no 01991017 | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2014-04-07-8f616a6e-24913-0 |
afbb82865a59aef1298ebc877f0d18df47061fd9 | (Registered 19 December2013) | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2014-04-07-8f616a6e-24913-0 |
19588d707985a8204e283e0c4f480e3eb42c3ba5 | Name of donor: Mr Henry Angest Address of donor: private | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2014-04-07-8f616a6e-24913-0 |
709cb6565f158c5e7c1e28f23c71960dab7f145c | Amount of donation or nature and value if donation in kind: £2,000; sponsorship for community projects | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2014-04-07-8f616a6e-24913-0 |
14e6d4540a33610fac5c0e81e724816c5dfb14f6 | Date of receipt: 2 December 2013 Date of acceptance: 2 December 2013 Donor status: individual | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2014-04-07-8f616a6e-24913-0 |
9b9bcc25b9aac294d21c764e132d63d2ed883933 | (Registered 19 December 2013) | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2014-04-07-8f616a6e-24913-0 |
6b2aef8e7b5fd43b377f18f1104ba8ab7fa58c27 | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2014-04-07-8f616a6e-24913-0 |
5b117d9f7f73f7ebeafc9ff7bf1f8b655d82809f | Address of donor: 18 Thorney Lane North, Iver, Buckinghamshire, SL0 9JY | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2014-04-07-8f616a6e-24913-0 |
30bd4929d4b853668ab98ce07525b043c78ae96e | Amount of donation or nature and value if donation in kind: £2,500 sponsorship for campaign community projects | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2014-04-07-8f616a6e-24913-0 |
97d485050f8355378975ce45b57bd9545c5924c9 | Date of receipt: 3 January 2014 Date of acceptance: 3 January 2014 Donor status: Members’ Association | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 28 | 2014-04-07-8f616a6e-24913-0 |
35d44671cf786feafc918ee5cd8ae23bd4b82b3e | (Registered 14 February 2014) | Sponsorships 8f616a6e | 2014-04-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 29 | 2014-04-07-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");