items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
23 rows where record_id = "2011-03-14-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 |
---|---|---|---|---|---|---|---|
e1ecfd4e560cf3b86a41bb80c4eeaabf6f0a4ff9 | 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-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-03-14-8f616a6e-24913-0 |
6898635eebb87dcee73974928988ce7d072a8ffc | Name of donor: Maurice Bennett | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-03-14-8f616a6e-24913-0 |
f289149b42c963fa977a913e9f075a498d8c362c | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2011-03-14-8f616a6e-24913-0 |
419eadb2164221c0043048d42316df9e5f4aab0b | (Registered 7June 2010) | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2011-03-14-8f616a6e-24913-0 |
339011e6e8752957ee5c7a8ac20a121cfb106a51 | Name of donor: Avtar Lit | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2011-03-14-8f616a6e-24913-0 |
b01419a775583b935e3059cb66bc15d0c2048603 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2011-03-14-8f616a6e-24913-0 |
e533d1250cb6a680c6bb6e9fa2cc163a9f92a237 | Name of donor: Mr W W Salomon | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2011-03-14-8f616a6e-24913-0 |
9df5ab003bebd4277c3ad2552b618cb9698d4518 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2011-03-14-8f616a6e-24913-0 |
a2435ff4cf63f61e0ea583aa26d311eb9e106185 | Name of donor: Mr Julian S Tanner | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2011-03-14-8f616a6e-24913-0 |
66c5fb138b67efb58a53891ec1dd19afa042bb8b | (Registered 7June 2010 ) | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2011-03-14-8f616a6e-24913-0 |
008bdc4ef92c81dba26492e8d14ab005e548767f | Name of donor: Mr Chris Lewis | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2011-03-14-8f616a6e-24913-0 |
5c85d6672eec6756d2288ab08a1e8911a182faf6 | Address of donor: private | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2011-03-14-8f616a6e-24913-0 |
d2f1b4d0e6017ff37a3a92002e66bd567ac466a1 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2011-03-14-8f616a6e-24913-0 |
e62cb47d1269121ffca5f708d12b208183d90151 | Donor status: individual | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2011-03-14-8f616a6e-24913-0 |
0eb9ffe8900c47ffa330fcc59fe91a00ce45a465 | (Registered 7 June 2010) | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2011-03-14-8f616a6e-24913-0 |
1cc2813e17627f0d8617824e57fcc47a973d86dd | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2011-03-14-8f616a6e-24913-0 |
ce76e9eb8b4233a7d589471a25d4cb46260be4f5 | Name of donor: Mr Stephen Brenninkmeijer | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2011-03-14-8f616a6e-24913-0 |
be4d0b5b85f7badab800d0ab350bcca1e5b519d3 | Address of donor: private | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 28 | 2011-03-14-8f616a6e-24913-0 |
43eec3f54c965bbba8a9b60d1798496d690b0478 | Amount of donation or nature and value if donation in kind: £5,000 donation | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 29 | 2011-03-14-8f616a6e-24913-0 |
d2c599450f30b7fe8df9d604d02d93f4869d7e27 | Date of receipt: 17 January 2011 | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 30 | 2011-03-14-8f616a6e-24913-0 |
55a696723445a8046bdf7010ef473847a0508c97 | Date of acceptance: 17 January 2011 | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 31 | 2011-03-14-8f616a6e-24913-0 |
8da0c1ec7fb20781a208217dcfcafda1b6f93714 | Donor status: individual | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 32 | 2011-03-14-8f616a6e-24913-0 |
c370a2e3f2fedfe42477eb0de33a7775cd811785 | (Registered 24 February 2011) | Sponsorships 8f616a6e | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 33 | 2011-03-14-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");