items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where record_id = "2013-09-30-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 |
---|---|---|---|---|---|---|---|
4976dfee64ddd8615dfd69cc47224af00b6e0b29 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2013-09-30-8f616a6e-24913-0 |
0672972b7f2abe61c065442fc7b851e47f44f312 | Name of donor: Barclays Bank PLC | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2013-09-30-8f616a6e-24913-0 |
027467a590e333cdff638de5b13a4e8f1e22d798 | Address of donor: 1 Churchill Place, London E14 5HP | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 2 | 2013-09-30-8f616a6e-24913-0 |
cddb4eee6aa49094d90f625dfc5fa5d2891945cb | Amount of donation: £2,500; sponsorship for cross-party event: Women on Boards Leadership Forum | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2013-09-30-8f616a6e-24913-0 |
6a29de27d4a5133fa189424b5ada976ae23b300d | Date of receipt: 14 December 2012 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2013-09-30-8f616a6e-24913-0 |
62f831d31e55016246bee29a5f90915b99217e99 | Date of acceptance: 14 December 2012 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2013-09-30-8f616a6e-24913-0 |
6e10c73492d57a17cf6abf5229a3b33a074dc1d7 | Donor status: company no 1026167 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2013-09-30-8f616a6e-24913-0 |
e3a86b459d596f9c44c88c50d50bce363ad66eb7 | Name of donor: LHR Airports Ltd | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2013-09-30-8f616a6e-24913-0 |
4611094d89a288b53ca025fe36bba1cb6bddc7eb | Address of donor: LHR Airports Limited, The Compass Centre, Nelson Road, Hounslow, Middlesex TW6 2GW | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 9 | 2013-09-30-8f616a6e-24913-0 |
bc5b6cf1b8a0c7448501757160fd7fa8326fea32 | Amount of donation: £5,000; sponsorship for local community project: 2013 Jobs and Apprenticeships Fair | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 10 | 2013-09-30-8f616a6e-24913-0 |
faafd2ba35b7a695672a437279cbca32631af431 | Date of receipt: 24 December 2012 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2013-09-30-8f616a6e-24913-0 |
c69e970b5b6258be584863c1e8e9ec9a04325dd2 | Date of acceptance: 24 December 2012 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2013-09-30-8f616a6e-24913-0 |
51fd6b0ad14ed9bec2bde9d0d975e6265bfcaa64 | Donor status: company no 1970855 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2013-09-30-8f616a6e-24913-0 |
cc5a4f9c441931da1ee8e7d8ce49a955c929ce0e | (Registered 24 December 2012) | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 14 | 2013-09-30-8f616a6e-24913-0 |
50f0dfa6673c72c0767b831d1b5659a9d0a575ba | Name of donor: Mr Michael Farmer | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 15 | 2013-09-30-8f616a6e-24913-0 |
889adef342da52753bf0b1799b9e8d02a6444f01 | Address of donor: private | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2013-09-30-8f616a6e-24913-0 |
68a4739bf8c296798296fcdbd90375ac1182af85 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 17 | 2013-09-30-8f616a6e-24913-0 |
4a2d3e543150653fa94467c75ec658d8453a1fc4 | Date of receipt: 14 January 2013 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2013-09-30-8f616a6e-24913-0 |
cfbac378641627fb7c825a1887cd4757b1f5e882 | Date of acceptance: 16 January 2013 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2013-09-30-8f616a6e-24913-0 |
0b2e97d12ac8ea968df5ea72b1b870aea1ed1451 | Donor status: individual | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2013-09-30-8f616a6e-24913-0 |
874372e85d95f75a709396b4f1f9dfe0e253b064 | (Registered 17 January 2013) | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2013-09-30-8f616a6e-24913-0 |
ab5562e6769aec7e13d9f46a10c5091add4265ab | 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 | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2013-09-30-8f616a6e-24913-0 |
294b63ab15c836b22b537fe2adfb2d62c4c38180 | Date of receipt: 29 April 2013 Date of acceptance: 30 April 2013 Donor status: company, registration 05757208 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2013-09-30-8f616a6e-24913-0 |
14ba6d19cfc2e3bf0fef34b34681ab9028ccd26f | (Registered 13 May 2013) | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2013-09-30-8f616a6e-24913-0 |
9a4723a557db35238075ea8527f003f4f6231112 | Name of donor: Microsoft Limited | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2013-09-30-8f616a6e-24913-0 |
ec380f4c69f781ea2ebfb5b765167ab68020522b | Address of donor: Microsoft Campus, Thames Valley Business Park, Reading, RG6 1WG | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2013-09-30-8f616a6e-24913-0 |
00b6a2ab4b413b8ea55ae277fd21ab893effe7ae | 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 | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2013-09-30-8f616a6e-24913-0 |
d2912a75eb161b53b63f5c638cd9945911c57d4c | Date of receipt: 17 July 2013 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 28 | 2013-09-30-8f616a6e-24913-0 |
bdd27baa9c30efd6c2abdcb5897aec0395300267 | Date of acceptance: 17 July 2013 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 29 | 2013-09-30-8f616a6e-24913-0 |
64c2d0874033aa85a94d05945718f44e8561fe80 | Donor status: company registration 01624297 | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 30 | 2013-09-30-8f616a6e-24913-0 |
7d0eec96ca3b418bf925105b9fecbbbb3a416f39 | (Registered 24 July 2013; updated 1 August 2013) | Sponsorships 8f616a6e | 2013-09-30 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 31 | 2013-09-30-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");