items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where "date" is on date 2011-03-14 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 |
---|---|---|---|---|---|---|---|
2b1e1f87ec902baf6cb0b30bce36cdd2f20aeebf | I received a limited edition £2 coin and The Story of the King James Bible, total value £19, from the King James Bible Trust, Trinity Business Centre, Stonehill Green, Westlea, Swindon SN5 7DG when I attended a reception. Hours: 1.5 hrs. (Registered 25 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-03-14-1f359ece-24749-0 |
87d25ba6891dbd5cfc852cd1ff2743622da41c19 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-03-14-8f616a6e-24749-0 |
f05f7aa8b428b76ed6e1cc8106dafae018809364 | Name of donor: Austen Reid | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2011-03-14-8f616a6e-24749-0 |
7dc6c9d33b7d3cb41103a8e0fcad70b90d7c8ee0 | Address of donor: private | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 2 | 2011-03-14-8f616a6e-24749-0 |
157ce8cf8db3b05380d7da3c1e7b1f14cf54be4c | Donor status: individual | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 4 | 2011-03-14-8f616a6e-24749-0 |
9c4e8b3167c2fde70e44a2cd6e20beb46770805f | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 6 | 2011-03-14-8f616a6e-24749-0 |
0923ab6ca2287904bd7cc731fcdcedd987303063 | Address of donor: 18 Thorney Lane North Iver Bucks SL0 9PY | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 7 | 2011-03-14-8f616a6e-24749-0 |
346937fddbfe9743f261d9b04c8856928c65e03f | Amount of donation or nature and value if donation in kind: £2,500. | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 8 | 2011-03-14-8f616a6e-24749-0 |
87f1375d11af6d14455b7c2be4ff9d47e2c67181 | Donor status: club | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 9 | 2011-03-14-8f616a6e-24749-0 |
c1fceb279b7d7ed07b1d4074f514187e17d65ede | Name of donor: Metloc Printers | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 11 | 2011-03-14-8f616a6e-24749-0 |
622ce6f6b7ee27e87fe00bb2fcc14e14aed18281 | Address of donor: Caxton House Old Station Road Loughton Essex IG10 4PE | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 12 | 2011-03-14-8f616a6e-24749-0 |
ba7c071711f4fb8dffe368725e75d70d208d7969 | Amount of donation or nature and value if donation in kind: £3,000. | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 13 | 2011-03-14-8f616a6e-24749-0 |
671b6f3ab34f54784ababb711f17b0c8cdd8977f | Donor status: company | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 14 | 2011-03-14-8f616a6e-24749-0 |
0c36b4b1a146f0a7e4ccba8fd017d4f544174cec | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 15 | 2011-03-14-8f616a6e-24749-0 |
95213942b431f84cc162b3e0a870c68c7d2d3585 | One-fifth share in holiday home Languedoc | Land and Property 4f1e6359 | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-03-14-4f1e6359-24749-0 |
61246fd6768c3aeb9768952d9f1805d38e71790e | One-third share in holiday home Northern Cyprus | Land and Property 4f1e6359 | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2011-03-14-4f1e6359-24749-0 |
00f27d492de54ef62ead80d8de4e27e05f6cd1e7 | Aysgarth Properties Ltd | Shareholdings 5b34324e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-03-14-5b34324e-24749-0 |
0fdaabe07be6ca8eec6ac9dbff04955d0b961754 | Metloc Printers Ltd, of which I am an unremunerated director. | Shareholdings 5b34324e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2011-03-14-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");