items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where "date" is on date 2011-01-10 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 |
---|---|---|---|---|---|---|---|
96ed907fc329b42161bd0448cd46f2de04d5a347 | 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-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-01-10-1f359ece-24749-0 |
f152923c8482320f5416c54c0066c7ffd09899ec | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-01-10-8f616a6e-24749-0 |
8cab6902331b80f063755e8ea98d1eefc4b37e4d | Name of donor: Austen Reid | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2011-01-10-8f616a6e-24749-0 |
0bed361cca541957e569827251ee01ecfb7740e4 | Address of donor: private | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 2 | 2011-01-10-8f616a6e-24749-0 |
8d4b652bfe5f631f1d12723c4e458dc30f921999 | Donor status: individual | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 4 | 2011-01-10-8f616a6e-24749-0 |
c46953587fe3fe990de4e8fd6ebea794a83744ab | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 6 | 2011-01-10-8f616a6e-24749-0 |
42609ca4606a554f29b5b13753f6b6afe032ac4d | Address of donor: 18 Thorney Lane North Iver Bucks SL0 9PY | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 7 | 2011-01-10-8f616a6e-24749-0 |
ffadc645d7d858bb5d668fe03c32660a19e53dd2 | Amount of donation or nature and value if donation in kind: £2,500. | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 8 | 2011-01-10-8f616a6e-24749-0 |
762e9f346db1d808be3db4e7ce43eb39ad081330 | Donor status: club | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 9 | 2011-01-10-8f616a6e-24749-0 |
6d4ed0df43127612c1a767a8a9264a7451a54cec | Name of donor: Metloc Printers | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 11 | 2011-01-10-8f616a6e-24749-0 |
2195594a2bb5a2693c21911c74bb0135bb0fb04b | Address of donor: Caxton House Old Station Road Loughton Essex IG10 4PE | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 12 | 2011-01-10-8f616a6e-24749-0 |
1b2ebdc30f2355c6f816803f10ff7e2077b9eeea | Amount of donation or nature and value if donation in kind: £3,000. | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 13 | 2011-01-10-8f616a6e-24749-0 |
88138e8a34d4beaa2b0d08aa90dcfc1d124e9532 | Donor status: company | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 14 | 2011-01-10-8f616a6e-24749-0 |
6317f29af68ed62273e072ac1b48985d9017943f | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 15 | 2011-01-10-8f616a6e-24749-0 |
688727f9316d5020437cc79a7a8209385e49c8b7 | One-fifth share in holiday home Languedoc | Land and Property 4f1e6359 | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-01-10-4f1e6359-24749-0 |
f80dc7c71185f02d4948311394d464d059981419 | One-third share in holiday home Northern Cyprus | Land and Property 4f1e6359 | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2011-01-10-4f1e6359-24749-0 |
8a9a68320e3c5a56dd9710598c8db27a8f92f448 | Aysgarth Properties Ltd | Shareholdings 5b34324e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-01-10-5b34324e-24749-0 |
ab113a8266d009785bccb7bbd178b470ad464fa4 | Metloc Printers Ltd, of which I am an unremunerated director. | Shareholdings 5b34324e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2011-01-10-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");