items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where "date" is on date 2010-12-06 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 |
---|---|---|---|---|---|---|---|
6aa4142cca43bef370592b2c5550cf836336873e | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2010-12-06-8f616a6e-24749-0 |
c0b3a48ea4e83093264e9f81150ad79f6d21ff87 | Name of donor: Austen Reid | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2010-12-06-8f616a6e-24749-0 |
684983535e87f39796479ecdd66777ad124f6aa7 | Address of donor: private | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 2 | 2010-12-06-8f616a6e-24749-0 |
6900631d808ce8a715221fa271c951237d02c973 | Donor status: individual | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 4 | 2010-12-06-8f616a6e-24749-0 |
c156ca32e39e84520d7597317aa205dea2555169 | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 6 | 2010-12-06-8f616a6e-24749-0 |
c767eb745507e77c4717d79cf824ff8cd4c55f11 | Address of donor: 18 Thorney Lane North Iver Bucks SL0 9PY | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 7 | 2010-12-06-8f616a6e-24749-0 |
59914d9ebf1d0e14e8218b93c83986cbb5d677f7 | Amount of donation or nature and value if donation in kind: £2,500. | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 8 | 2010-12-06-8f616a6e-24749-0 |
86786764eaed6ff03f97c8143ff2abf067c2820f | Donor status: club | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 9 | 2010-12-06-8f616a6e-24749-0 |
6c18ba241415a8c0052a53123031b2b4abb946c6 | Name of donor: Metloc Printers | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 11 | 2010-12-06-8f616a6e-24749-0 |
807fa02ad26b046569bb0e1ba38cc9834acea0b5 | Address of donor: Caxton House Old Station Road Loughton Essex IG10 4PE | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 12 | 2010-12-06-8f616a6e-24749-0 |
cff067e00893507a2f0e7efa3a3399ddfbb09d1a | Amount of donation or nature and value if donation in kind: £3,000. | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 13 | 2010-12-06-8f616a6e-24749-0 |
3248f7db0b4bee4c8e13b773ec97dafbd0bfd13f | Donor status: company | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 14 | 2010-12-06-8f616a6e-24749-0 |
1a430e42c2ef05b09ea8de01188d211ff9464ba3 | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 15 | 2010-12-06-8f616a6e-24749-0 |
d9510f2375051ec0676e7bf9ab5f4e4f9546b8b2 | One-fifth share in holiday home Languedoc | Land and Property 4f1e6359 | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2010-12-06-4f1e6359-24749-0 |
e4fae10920e74080f0fb3dd164ee25f36ccc96fb | One-third share in holiday home Northern Cyprus | Land and Property 4f1e6359 | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2010-12-06-4f1e6359-24749-0 |
6c94d3a69a79e04ff063f4edf1432c106da9d67b | Aysgarth Properties Ltd | Shareholdings 5b34324e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2010-12-06-5b34324e-24749-0 |
874be1e5a6f0732e330f5cdbeda01340fbeedd2a | Metloc Printers Ltd, of which I am an unremunerated director. | Shareholdings 5b34324e | 2010-12-06 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2010-12-06-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");