items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where "date" is on date 2010-10-25 and person_id = "uk.org.publicwhip/person/24749" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
459ec65e2149f0ff38b26d3ef96bfb850c99a875 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2010-10-25-8f616a6e-24749-0 |
9a72834189230efbcdfe1e700a4371ddff36ea38 | Name of donor: Austen Reid | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2010-10-25-8f616a6e-24749-0 |
9105cc8aa3e81b77997c14b2661f53469f298440 | Address of donor: private | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 2 | 2010-10-25-8f616a6e-24749-0 |
39269b9636720a6a6387b6441984ac454b687308 | Donor status: individual | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 4 | 2010-10-25-8f616a6e-24749-0 |
d4ba95e97e7c948c2746c9fc3b72fac528745900 | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 6 | 2010-10-25-8f616a6e-24749-0 |
425a85cc950735e95d562fa7d39945939d253968 | Address of donor: 18 Thorney Lane North Iver Bucks SL0 9PY | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 7 | 2010-10-25-8f616a6e-24749-0 |
97189408cc19db79ca6db7cc24792d1d1537da3c | Amount of donation or nature and value if donation in kind: £2,500. | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 8 | 2010-10-25-8f616a6e-24749-0 |
6f4c6862a9a03082f37f5aaddb1600b3ce2522e7 | Donor status: club | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 9 | 2010-10-25-8f616a6e-24749-0 |
21f07359527023853d16e02067fab16422210f90 | Name of donor: Metloc Printers | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 11 | 2010-10-25-8f616a6e-24749-0 |
3c84493189ebc9875e919b0197ca05433deb4445 | Address of donor: Caxton House Old Station Road Loughton Essex IG10 4PE | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 12 | 2010-10-25-8f616a6e-24749-0 |
0ee66b9ca52d56eedcd0448c2553974a9c18a7ad | Amount of donation or nature and value if donation in kind: £3,000. | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 13 | 2010-10-25-8f616a6e-24749-0 |
e145df38c915adebdf1382f79510ec8c48b0e369 | Donor status: company | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 14 | 2010-10-25-8f616a6e-24749-0 |
efebe65b6eb6e0a17ed9e1637f64049c6ed64fba | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 15 | 2010-10-25-8f616a6e-24749-0 |
786054c799c335e84c6dc1868cafaf421ea702ac | One-fifth share in holiday home Languedoc | Land and Property 4f1e6359 | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2010-10-25-4f1e6359-24749-0 |
36130b1a6deebe78198a9ea0f0966603f8d85e24 | One-third share in holiday home Northern Cyprus | Land and Property 4f1e6359 | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2010-10-25-4f1e6359-24749-0 |
ead5ed9cef9ec0e402136ad348e8fd56412f332d | Aysgarth Properties Ltd | Shareholdings 5b34324e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2010-10-25-5b34324e-24749-0 |
ffa2ba031b7588d128a7b9a1c1b3334a506fcfb6 | Metloc Printers Ltd, of which I am an unremunerated director. | Shareholdings 5b34324e | 2010-10-25 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2010-10-25-5b34324e-24749-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");