items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where record_id = "2012-01-13-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 |
---|---|---|---|---|---|---|---|
ea04dc3694cd7806d9a5d6cf4d9cd0a7698038d1 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2012-01-13-8f616a6e-24913-0 |
2fa2ab4952ba6d0ec9beb514329dd0c8714076a9 | Name of donor: Michael O’Donnell | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2012-01-13-8f616a6e-24913-0 |
a77527a90217f83ec0b4e3969a9677707b1de10c | Amount of donation or nature and value if donation in kind: catering and hosting of fundraising event; value £2,594 | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2012-01-13-8f616a6e-24913-0 |
2ab1638ca62cf6cd94e9802cfd7521db62de24c6 | (Registered 19 October 2011) | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2012-01-13-8f616a6e-24913-0 |
39cd4ddc8ef54629d6701d2ccc1c4683baa24829 | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2012-01-13-8f616a6e-24913-0 | |
e8b95be6f4b8e7ad3185fb4add0b6765bc1b9e6d | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2012-01-13-8f616a6e-24913-0 |
a8626279176bd150f358c110cc0c30552afe22cc | Name of donor: Mr Stephen Brenninkmeijer | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2012-01-13-8f616a6e-24913-0 |
e003ce30ab1cf0382daaf3c25263b20bd6c4cb07 | Date of receipt: 17 January 2011 | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2012-01-13-8f616a6e-24913-0 |
7b9e43c933d3929a901c7074cc220a8698754261 | Date of acceptance: 17 January 2011 | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2012-01-13-8f616a6e-24913-0 |
5c60dd156e83af9e327c320eb61774e7ec3588ae | (Registered 24 February 2011) | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 14 | 2012-01-13-8f616a6e-24913-0 |
828ce7db9c47a4fb69b08127ed4f0ffaefa6cde2 | Date of receipt: 24 March 2011 | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2012-01-13-8f616a6e-24913-0 |
ad66b4383ca7e99bc2273bab93e49b110a55d146 | Date of acceptance: 24 March 2011 | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2012-01-13-8f616a6e-24913-0 |
f94eec15ee94b795cb344b81f24f851058ec077e | (Registered 5 April 2011) | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2012-01-13-8f616a6e-24913-0 |
3ccbbe61808da775fc6911f05973356b5113f9fc | Name of donor: Mr Maurice Bennett | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2012-01-13-8f616a6e-24913-0 |
f6c1f5ff907cba0c6ba5fd6c5dc22226e80b5a8d | Address of donor: private | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2012-01-13-8f616a6e-24913-0 |
00f3136bb6f8e12b714e098665fd73666723615d | Amount of donation or nature and value if donation in kind: £5,000 donation | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2012-01-13-8f616a6e-24913-0 |
39f4248a6be2553cac969eab7643a146c0b0a5ed | Date of receipt: 24 November 2011 | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2012-01-13-8f616a6e-24913-0 |
8cee00924c0a164e14b5c5c4e20a381e083dae90 | Date of acceptance: 24 November 2011 | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2012-01-13-8f616a6e-24913-0 |
0211a2a03016d3dbe8881117507486bb915c5c4f | Donor status: individual | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2012-01-13-8f616a6e-24913-0 |
5762aaef117163fc4b77998a1e2656bd2f6db17f | (Registered 24 November 2011) | Sponsorships 8f616a6e | 2012-01-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 28 | 2012-01-13-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");