items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
23 rows where record_id = "2011-03-28-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 |
---|---|---|---|---|---|---|---|
e26f4b668afb66efdf89db8c8d0cbe4988843454 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-03-28-8f616a6e-24913-0 |
617ac85b75f6e039861e6c7fa16477d45994472c | Name of donor: Maurice Bennett | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-03-28-8f616a6e-24913-0 |
711fb61e2cca03bf4013b1d7bbe86e1fb3a3b84a | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2011-03-28-8f616a6e-24913-0 |
ad3265ac5c60e26faf6dafed11b2707c7bfc1c75 | (Registered 7June 2010) | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2011-03-28-8f616a6e-24913-0 |
9e62cc8544bcdb4ec5c861b241e9f22b55e18bd0 | Name of donor: Avtar Lit | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2011-03-28-8f616a6e-24913-0 |
e77d4c33b5b6fc788bd95a569140641982a9c593 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2011-03-28-8f616a6e-24913-0 |
845ca125d4a313f6002487efb8a1b5d71775e688 | Name of donor: Mr W W Salomon | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2011-03-28-8f616a6e-24913-0 |
0bae40ce37ec6e4a4f03ed46173e65e449833a4f | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2011-03-28-8f616a6e-24913-0 |
262dca7a5a2cbce9a5f885145f095369987a383f | Name of donor: Mr Julian S Tanner | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2011-03-28-8f616a6e-24913-0 |
76345adac819f998aa6fb861ab26b173a53056ff | (Registered 7June 2010 ) | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2011-03-28-8f616a6e-24913-0 |
7fa89e5e451c74505c547842aa8e8922870a129b | Name of donor: Mr Chris Lewis | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2011-03-28-8f616a6e-24913-0 |
59536287ee05245765cc324e6c20e1157556c340 | Address of donor: private | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2011-03-28-8f616a6e-24913-0 |
ed3a8117d998803613c17190e287c38a0f5d3e0d | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2011-03-28-8f616a6e-24913-0 |
7da50cd908297e153eefde0abf44ed1f25b5899d | Donor status: individual | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2011-03-28-8f616a6e-24913-0 |
285853ad182c992bbf59854bf702c61b963850fd | (Registered 7 June 2010) | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2011-03-28-8f616a6e-24913-0 |
d3d7809e04c043786d91547680489850d6ba389b | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2011-03-28-8f616a6e-24913-0 |
7d6e492cc218070c8401539381cb0fd2d82db70d | Name of donor: Mr Stephen Brenninkmeijer | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2011-03-28-8f616a6e-24913-0 |
bd0c0c1f1e8ad2cbc874df00cd0b3738444fce2d | Address of donor: private | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 28 | 2011-03-28-8f616a6e-24913-0 |
7eadbc153bb7a17748259dfeff928692512be718 | Amount of donation or nature and value if donation in kind: £5,000 donation | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 29 | 2011-03-28-8f616a6e-24913-0 |
578dcf3add029effe0130044fb0980c52f748dda | Date of receipt: 17 January 2011 | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 30 | 2011-03-28-8f616a6e-24913-0 |
9dc5afb03591bf099093a3cbcc5ebe6ab5dbfe56 | Date of acceptance: 17 January 2011 | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 31 | 2011-03-28-8f616a6e-24913-0 |
c33b91998c77686ea525f2de3bb089bf11e2cee5 | Donor status: individual | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 32 | 2011-03-28-8f616a6e-24913-0 |
e4e30bc0cd5d6a10d41ae8936abc0b5523d5e487 | (Registered 24 February 2011) | Sponsorships 8f616a6e | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 33 | 2011-03-28-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");