items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2011-01-24-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 |
---|---|---|---|---|---|---|---|
9322f8f5fbeaa8ac5b7bfc36d6f946a52dfcc146 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-01-24-8f616a6e-24913-0 |
c2a4804a7521b2400ce1e65d18b88b4231234027 | Name of donor: Maurice Bennett | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-01-24-8f616a6e-24913-0 |
499a1adfca0fb2c8634053ac57a825c33beb125e | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2011-01-24-8f616a6e-24913-0 |
69892b398f3864690fe7b9478b2c8f97bdc6151e | (Registered 7June 2010) | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2011-01-24-8f616a6e-24913-0 |
f0045bdd670712621d437e0ebb2e5ddcc0fb0683 | Name of donor: Avtar Lit | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2011-01-24-8f616a6e-24913-0 |
fcf6bfac42f8e99e70ef527017c6006c729beb14 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2011-01-24-8f616a6e-24913-0 |
6b6c94d2f10cba776eee5d51995a7d072241c8d8 | Name of donor: Mr W W Salomon | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2011-01-24-8f616a6e-24913-0 |
0c01b8b3437daac1cded965f8b6e77a56f3a35a4 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2011-01-24-8f616a6e-24913-0 |
1a44256ffc66e4fa284f2ab748302a1767e70e9b | Name of donor: Mr Julian S Tanner | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2011-01-24-8f616a6e-24913-0 |
3980af713231a2da1d13fa57eb90fd8ba5d53cab | (Registered 7June 2010 ) | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2011-01-24-8f616a6e-24913-0 |
b3dbcb55b3b6a3befd72c32b71be803b5a75c87e | Name of donor: Mr Chris Lewis | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2011-01-24-8f616a6e-24913-0 |
eb8cca040a9e62f857c3efc3a58aa2069f8a6bff | Address of donor: private | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2011-01-24-8f616a6e-24913-0 |
6c85bd505f0d34951d50a8494de502019747d3c4 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2011-01-24-8f616a6e-24913-0 |
37f360140b0402670552e85d4d5d006fe3b33f8c | Donor status: individual | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2011-01-24-8f616a6e-24913-0 |
1417f91971eae222550c8c8d3f738db87496607c | (Registered 7 June 2010) | Sponsorships 8f616a6e | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2011-01-24-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");