items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where record_id = "2011-11-29-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 |
---|---|---|---|---|---|---|---|
597e94d278e3101b141f4e7a9615613c5a5b02aa | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-11-29-8f616a6e-24913-0 |
30b56b837527e2c1eda47582089cac95b4b9f114 | Name of donor: Michael O’Donnell | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-11-29-8f616a6e-24913-0 |
33934b4bff8dafda0b8885acae6ffa92b32b7576 | Amount of donation or nature and value if donation in kind: catering and hosting of fundraising event; value £2,594 | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2011-11-29-8f616a6e-24913-0 |
9c42265646e599fcf6c7f2bfd47619be5945405a | (Registered 19 October 2011) | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2011-11-29-8f616a6e-24913-0 |
a28c2cd5c9fb68e24c78f2f1b5fdffc12b6b3129 | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2011-11-29-8f616a6e-24913-0 | |
0cc8c36196bcf2771f5a165bd26578e374ea2b25 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2011-11-29-8f616a6e-24913-0 |
36745b913e3e5ea4ccb8d186e9e3fe4f0e133920 | Name of donor: Mr Stephen Brenninkmeijer | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2011-11-29-8f616a6e-24913-0 |
007023bc28212a9adb284fb6118d6ec83f783669 | Date of receipt: 17 January 2011 | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2011-11-29-8f616a6e-24913-0 |
5dd9741fa24b22adb80496ab82679e24b618c818 | Date of acceptance: 17 January 2011 | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2011-11-29-8f616a6e-24913-0 |
bcc8beb083f26235ab169fbb34d42467c3b9f4ca | (Registered 24 February 2011) | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 14 | 2011-11-29-8f616a6e-24913-0 |
48eb7bb1d3d3072719a6d1cfafb01cc100a8db24 | Date of receipt: 24 March 2011 | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2011-11-29-8f616a6e-24913-0 |
d47b6c6ab130f7a0ece724e175c535b7ecd6ba5d | Date of acceptance: 24 March 2011 | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2011-11-29-8f616a6e-24913-0 |
da383d1a16eaa3af7d2d8c82fa9c2d4c08b88bc6 | (Registered 5 April 2011) | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2011-11-29-8f616a6e-24913-0 |
3f53b63b0e627213f609455227990b3e5b16e63a | Name of donor: Mr Maurice Bennett | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2011-11-29-8f616a6e-24913-0 |
a54f2045b661a7180abc4e4d73f061e9d3103393 | Address of donor: private | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2011-11-29-8f616a6e-24913-0 |
dac14ae9cd163744ac4936d4b6e4cf31b65875ac | Amount of donation or nature and value if donation in kind: £5,000 donation | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2011-11-29-8f616a6e-24913-0 |
34a8444c319509c8b6f1414ad3a63d71a9648d53 | Date of receipt: 24 November 2011 | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2011-11-29-8f616a6e-24913-0 |
5fa311639a9870cff4ecd9a887ed5aec826a08ff | Date of acceptance: 24 November 2011 | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2011-11-29-8f616a6e-24913-0 |
000b1cbe60389bd29fddb8c6cf52d20d4f94fbff | Donor status: individual | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2011-11-29-8f616a6e-24913-0 |
85e4053a760462e5be272a8e4da221bd7cbe3df8 | (Registered 24 November 2011) | Sponsorships 8f616a6e | 2011-11-29 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 28 | 2011-11-29-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");