items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where "date" is on date 2015-02-23 and person_id = "uk.org.publicwhip/person/24749" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, sort_order, record_id
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
1e16c216d9160001a1b81eb5e1a2ea5a0b04e913 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2015-02-23-8f616a6e-24749-0 |
59e87a82787e2c44ad680ae2a493688eceaa8afe | Name of donor: Mr John Isabel | Sponsorships 8f616a6e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2015-02-23-8f616a6e-24749-1 |
77c5541a3a048f329f1125e0d44c50bb8f4401d4 | Address of donor: private | Sponsorships 8f616a6e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2015-02-23-8f616a6e-24749-1 |
023a698385014839504258caf98a7f7cd293dbc9 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 2 | 2015-02-23-8f616a6e-24749-1 |
34316476185b729c5bdd657d81c8659fe29780fb | Donor status: individual | Sponsorships 8f616a6e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 3 | 2015-02-23-8f616a6e-24749-1 |
7c938d35c55364c946b8575c35ffb505cfd8bbc2 | (Registered 12 February 2015) | Sponsorships 8f616a6e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 4 | 2015-02-23-8f616a6e-24749-1 |
67a614c4b89ff92d42836082d262797ae22f0ae1 | Name of donor: Mr Robert Lyon | Sponsorships 8f616a6e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2015-02-23-8f616a6e-24749-2 |
2a9d447eaae2d53d4667ca92008d017cd2bd1a5f | Address of donor: private | Sponsorships 8f616a6e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2015-02-23-8f616a6e-24749-2 |
7d297efc0386c1c4c0bc74dfca0047dab3d9023c | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 2 | 2015-02-23-8f616a6e-24749-2 |
72ccf248aafbbedac43d69d76660755cc6313be1 | Donor status: individual | Sponsorships 8f616a6e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 3 | 2015-02-23-8f616a6e-24749-2 |
6a75ad83f71eee66c8055e882807e49e31d999d1 | (Registered 12 February 2015) | Sponsorships 8f616a6e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 4 | 2015-02-23-8f616a6e-24749-2 |
a4281cfd6de261ee635bb9f24e99ba9167bb82d4 | One-fifth share in holiday home Languedoc | Land and Property 4f1e6359 | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2015-02-23-4f1e6359-24749-0 |
e63b2ff6d440d54ebb6c9f814c010893f0133cac | One-third share in holiday home Northern Cyprus | Land and Property 4f1e6359 | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2015-02-23-4f1e6359-24749-0 |
1cd7be781b0f154ba725fdefd2d106639a398fad | Aysgarth Properties Ltd | Shareholdings 5b34324e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2015-02-23-5b34324e-24749-0 |
e1fc88e3bf7d00719463ba0283967c86ced4133f | Metloc Printers Ltd | Shareholdings 5b34324e | 2015-02-23 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2015-02-23-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");