items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where record_id = "2014-11-24-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 |
---|---|---|---|---|---|---|---|
30c92faac649a2db1b3c4be4a25c295412e1955b | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2014-11-24-8f616a6e-24913-0 |
095ad583db568d72f683939f988fc6e976d7e39a | Name of donor: Mrs Pavita Cooper | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2014-11-24-8f616a6e-24913-0 |
91ffd51347c4f930486047f4717548242bb121e5 | Amount of donation or nature and value if donation in kind: catering and hosting of fundraising event; value £3,500 | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2014-11-24-8f616a6e-24913-0 |
470338ebc81a298bcc75d5f974a8809a13a6cc7a | Date of receipt: 22 October 2013 | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2014-11-24-8f616a6e-24913-0 |
adf023e464139168dda241f5480bef9f047546e5 | Date of acceptance: 22 October 2013 | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2014-11-24-8f616a6e-24913-0 |
a35e8ae1a488006c2addc6fd6c26b1853c4ca7b2 | (Registered 14 November 2013) | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2014-11-24-8f616a6e-24913-0 |
94dd3ebaed6c07a16a2ecf9bd3b7e10d780673f4 | Name of donor: Heathrow Airport Ltd | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2014-11-24-8f616a6e-24913-0 |
4b7933540ab428a4473cb774bc9c0f833ab2888a | Address of donor: The Compass Centre, Nelson Road, Hounslow TW6 2GW | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 9 | 2014-11-24-8f616a6e-24913-0 |
acf533a3add303ea683af3f90789ad7b98f1de40 | 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-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 10 | 2014-11-24-8f616a6e-24913-0 |
245861a26e22c253eaa0b904b6f31fe8d0eed313 | Date of receipt: 3 December 2013 | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2014-11-24-8f616a6e-24913-0 |
6faf1052f0cec850076b72d8669c4b3b1d098aa6 | Date of acceptance: 3 December 2013 | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2014-11-24-8f616a6e-24913-0 |
e0a74303a2ddbd72ba208062385f4aaf334ec8bb | Donor status: company, registration no 01991017 | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2014-11-24-8f616a6e-24913-0 |
5120065ecb28f7e3f6fbad0d487a74e19746ee98 | Name of donor: Mr Henry Angest | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 15 | 2014-11-24-8f616a6e-24913-0 |
0be785cbc9868def234943bf7aa68b7dd7005c43 | Address of donor: private | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2014-11-24-8f616a6e-24913-0 |
2cc6357dbbbdea1788e8c2fafbfc5ed1b5ec421b | Amount of donation or nature and value if donation in kind: £2,000; sponsorship for community projects | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 17 | 2014-11-24-8f616a6e-24913-0 |
c71ff77fc667afc751ec4bf0a1a7200c7bd7c8fa | Date of receipt: 2 December 2013 | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2014-11-24-8f616a6e-24913-0 |
1bb1e87d1656b25295956ccc8fedd9469d6f0220 | Date of acceptance: 2 December 2013 | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2014-11-24-8f616a6e-24913-0 |
41299df34e975f348211354570cbb23eae096797 | Donor status: individual | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2014-11-24-8f616a6e-24913-0 |
dfc7e438ddfb0503ffe3a87903dbf2a9442aede7 | (Registered 19 December 2013) | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2014-11-24-8f616a6e-24913-0 |
44c78567bebd9b0f8d712a8cd56e4580a6cbbcfe | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2014-11-24-8f616a6e-24913-0 |
1b8fda75099d492ef6ba5c550f1633c0d08fc00b | Address of donor: 18 Thorney Lane North, Iver, Buckinghamshire, SL0 9JY | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2014-11-24-8f616a6e-24913-0 |
4667bf0d72d1dc1cc44491be0fbe3b557f0f31df | Amount of donation or nature and value if donation in kind: £2,500 sponsorship for campaign community projects | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2014-11-24-8f616a6e-24913-0 |
0a55d3bffd82f994dac166a59438127f2cd811d8 | Date of receipt: 3 January 2014 Date of acceptance: 3 January 2014 Donor status: Members’ Association | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2014-11-24-8f616a6e-24913-0 |
6f7c1ebbf34fde020cab7b53b31565a9487d7f9f | (Registered 14 February 2014) | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2014-11-24-8f616a6e-24913-0 |
7eba08bfdb2ddef56d71d17d561c44139393bc7c | Name of donor: T C Limited | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2014-11-24-8f616a6e-24913-0 |
05782f1635c956d06fc717979eab602cb4f32ee1 | Address of donor: 30 City Road, London EC1Y 2AB | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 28 | 2014-11-24-8f616a6e-24913-0 |
a60dd8ea77de939bb6de4f9a393db4bba64c15b7 | Amount of donation: £7,500; sponsorship for communication and local projects | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 29 | 2014-11-24-8f616a6e-24913-0 |
57b52a697625d6deb41ff31fadd80acd240f37d8 | Date of receipt: 1 July 2014 | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 30 | 2014-11-24-8f616a6e-24913-0 |
04f4793356143d3dfaf197e585ee2f06f1191e8e | Date of acceptance: 1 July 2014 | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 31 | 2014-11-24-8f616a6e-24913-0 |
4b2334618917bbc55a2c2eb8299f577aed262ae5 | Donor status: company, registration 01125377 | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 32 | 2014-11-24-8f616a6e-24913-0 |
2e550d7499298174cb5916e93c2911ef1d27fdb4 | (Registered 15 July 2014) | Sponsorships 8f616a6e | 2014-11-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 33 | 2014-11-24-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");