items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2011-04-18-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 |
---|---|---|---|---|---|---|---|
851bc2fae8702a4c9dc18b51aea1efc785fc16aa | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-04-18-8f616a6e-24913-0 |
469fb097001f965b93095c6d3832b69d13a9e010 | Name of donor: Maurice Bennett | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-04-18-8f616a6e-24913-0 |
f63b5d9cda45b4cf6cafa3a2898ae1444503b272 | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2011-04-18-8f616a6e-24913-0 |
c28977ef0f82876c623e7f5ecebe718d58460fed | (Registered 7June 2010) | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2011-04-18-8f616a6e-24913-0 |
f41555b1f2c689519f4fa40e6109395d93821bc6 | Name of donor: Avtar Lit | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2011-04-18-8f616a6e-24913-0 |
75597080ced7a2ee064df9e554353fe5638adae1 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2011-04-18-8f616a6e-24913-0 |
f6e0126e5e753f0ef7a9f2b4a18f30d963a7ed96 | Name of donor: Mr W W Salomon | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2011-04-18-8f616a6e-24913-0 |
738aa84508df25ee10029425e0fe4fd9c61a1c13 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2011-04-18-8f616a6e-24913-0 |
dbf40912d6b907fd9d0d55e089d232c84bd2c67e | Name of donor: Mr Julian S Tanner | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2011-04-18-8f616a6e-24913-0 |
6723d255df198a2f89a318ff220e20e6b1d20eb3 | (Registered 7June 2010 ) | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2011-04-18-8f616a6e-24913-0 |
e26f1f91737ded217c062f28b3c0fa27508c2717 | Name of donor: Mr Chris Lewis | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2011-04-18-8f616a6e-24913-0 |
6604eac683f2be67d57bb6d7a91d90b6ae8abeb4 | Address of donor: private | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2011-04-18-8f616a6e-24913-0 |
1c83e0377dffa779cd9fafe82e5fd87e699a1bda | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2011-04-18-8f616a6e-24913-0 |
cd84ffe9903ee7a569383442ef39766d44c3911a | Donor status: individual | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2011-04-18-8f616a6e-24913-0 |
58e961db6560541aea7c95f9fa8da90d53ed2728 | (Registered 7 June 2010) | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2011-04-18-8f616a6e-24913-0 |
5d5dc27cfc611b8328684e4cfe4de261f5d20cd9 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2011-04-18-8f616a6e-24913-0 |
bd70b3726b875504f3a35274ea717f7afad75f44 | Name of donor: Mr Stephen Brenninkmeijer | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2011-04-18-8f616a6e-24913-0 |
aed6912e2bb47b847d6d1c046cc4f38962c9e9c8 | Date of receipt: 17 January 2011 | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 30 | 2011-04-18-8f616a6e-24913-0 |
1ad3e4f6a8c4aa8ca7b7b547206123a8b1a31f4b | Date of acceptance: 17 January 2011 | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 31 | 2011-04-18-8f616a6e-24913-0 |
74b7ffac90d95d0ccfacc645f8a09ca08782f136 | (Registered 24 February 2011) | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 33 | 2011-04-18-8f616a6e-24913-0 |
2d5031c7672a804a210594940982b7a2858d2728 | Name of donor: Mr Maurice Bennett | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 34 | 2011-04-18-8f616a6e-24913-0 |
4397f6b9e86fd5d242b2221a432aa6b0a4993510 | Address of donor: private | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 35 | 2011-04-18-8f616a6e-24913-0 |
5993157a0045ff91703af4f74d661f75db1ce9d0 | Amount of donation or nature and value if donation in kind: £5,000 donation | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 36 | 2011-04-18-8f616a6e-24913-0 |
4644ef7cdffea1ab31db962f5a22fda92c69cb44 | Date of receipt: 24 March 2011 | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 37 | 2011-04-18-8f616a6e-24913-0 |
da4b2675e4382979f79db09c50594d028273bd34 | Date of acceptance: 24 March 2011 | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 38 | 2011-04-18-8f616a6e-24913-0 |
7a54bb765e0d477f294f8c94427fa12a2103de82 | Donor status: individual | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 39 | 2011-04-18-8f616a6e-24913-0 |
297b4bcf99cb113762a858323072624a3fa15e77 | (Registered 5 April 2011) | Sponsorships 8f616a6e | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 40 | 2011-04-18-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");