items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2010-09-06-8f616a6e-11715-0" sorted by person_id descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id ▲ | sort_order | record_id |
---|---|---|---|---|---|---|---|
7eed198e864bd7e09abb72349b8d28eace38868b | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 0 | 2010-09-06-8f616a6e-11715-0 |
dbacb46cb3300599e1bf934e4b78afbe87f3c062 | Name of donor: Caledonia Investments PLC | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 1 | 2010-09-06-8f616a6e-11715-0 |
0623fe6098d2797a253a858c45f4607f4b589fd8 | Address of donor: Cayzer House, 30 Buckingham Gate, London SW1E 6NN | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 2 | 2010-09-06-8f616a6e-11715-0 |
45c502df1f023059e46378febe64359a39e38b5f | Amount of donation or nature and value if donation in kind: donation of £5,000 | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 3 | 2010-09-06-8f616a6e-11715-0 |
9c5cbf77c6b583dc07fc64632ad6310eea997235 | (Registered 4 March 2010) | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 5 | 2010-09-06-8f616a6e-11715-0 |
e6c3f2e28d17332c20244e868e869dc35476c339 | Name of donor: Peter J Wilson | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 6 | 2010-09-06-8f616a6e-11715-0 |
479bde3518e6f7ba8a23e28af163bcf2670bb35c | Address of donor: Private | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 7 | 2010-09-06-8f616a6e-11715-0 |
000cf08f88b1c15a6851dd503d8ccad88ee6d455 | Amount of donation or nature and value if donation in kind: donation of £1600 | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 8 | 2010-09-06-8f616a6e-11715-0 |
9a5b4346898f2975ddaff7b252372ce85b19b420 | Name of donor: The Portcullis Club | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 11 | 2010-09-06-8f616a6e-11715-0 |
e714976b9afbacdc9140bc991ce418d56b38e953 | Address of donor: Sycamore House, Grange Way, Willington, MK 44 1JP | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 12 | 2010-09-06-8f616a6e-11715-0 |
62fb79ef105a4975bb3aadd23925b12b5ceea97a | Amount of donation or nature and value if donation in kind: donation of £2000 | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 13 | 2010-09-06-8f616a6e-11715-0 |
5154c43b7bae493d3bce4aec255b65325d50f23c | Donor status: unincorporated association | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 14 | 2010-09-06-8f616a6e-11715-0 |
f95f7b2eea5e10fe1b0d5a8ce42e827de81f3b80 | Name of donor: The 1900 Club | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 16 | 2010-09-06-8f616a6e-11715-0 |
e5fa37c7777d6ab89826c28d8afc3d86b33a8d3c | Address of donor: 6 Barton Street London SW19 3NG | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 17 | 2010-09-06-8f616a6e-11715-0 |
b239f1a8c85e42047227e6dd2d43181e5877c6ba | Amount of donation or nature and value if donation in kind: donation of £2500 | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 18 | 2010-09-06-8f616a6e-11715-0 |
b2832dbc37604f7ddbe3bab58ceed26c4bdf302f | Donor status: company | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 19 | 2010-09-06-8f616a6e-11715-0 |
a0e68d3983ac22d978d34c23e235f72ceaa98b58 | Name of donor: Simon Cuthbertson | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 21 | 2010-09-06-8f616a6e-11715-0 |
de14bd61943ec99513b6cc16402a935e18e99ad9 | Address of donor: private | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 22 | 2010-09-06-8f616a6e-11715-0 |
060bfcfe26d0d3ebc03a18533d81404574322f77 | Amount of donation or nature and value if donation in kind: donation of £5000 to my constituency association. | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 23 | 2010-09-06-8f616a6e-11715-0 |
49fa663a34fc210a534a6409762d6c5adec46c32 | Donor status: individual | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 24 | 2010-09-06-8f616a6e-11715-0 |
7f75991ce5136d119d509f4c7ce82bb2eb1d8927 | (Registered 8 June 2010) | Sponsorships 8f616a6e | 2010-09-06 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 25 | 2010-09-06-8f616a6e-11715-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");