items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where "date" is on date 2011-06-20 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 |
---|---|---|---|---|---|---|---|
0917d401b8bdca588bcf75a2d972f9d8af51a6f4 | 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-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-06-20-1f359ece-24749-0 |
27f54852c2e073522759c6cf90ec3b6a58cb03c4 | Name of donor: JTI – Japan Tobacco International | Gifts, benefits and hospitality (UK) 84642823 | 2011-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-06-20-84642823-24749-0 |
cd0fa8af38f5cf79eedc30d5d9a4976557b012ea | Address of donor : Members Hill, Brooklands Road, Weybridge, Surrey KT13 0QU | Gifts, benefits and hospitality (UK) 84642823 | 2011-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2011-06-20-84642823-24749-0 |
daa3f53a4939a825616eb22f5dead193b7d85314 | Amount of donation or nature and value if donation in kind: my wife and I attended the Chelsea Flower Show including tickets and lunch. Total value £1,132.80 | Gifts, benefits and hospitality (UK) 84642823 | 2011-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 2 | 2011-06-20-84642823-24749-0 |
cd9715aba0f9bc094a7fa038c2f0bfa011166d59 | Date of receipt of donation: 24 May 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 3 | 2011-06-20-84642823-24749-0 |
919562d826407d16ba4e569e9fc81ae51ee48694 | Date of acceptance of donation: 24 May 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 4 | 2011-06-20-84642823-24749-0 |
71e51d1ff7a40d4a3563bee7025bcbe2f870244f | Donor status: company, registration number 01501573 | Gifts, benefits and hospitality (UK) 84642823 | 2011-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 5 | 2011-06-20-84642823-24749-0 |
7307e000313fd7edbadd01264de1b430321c1c27 | (Registered 8 June 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 6 | 2011-06-20-84642823-24749-0 |
92311c6b3cc4d493b5d777603b3c31592e73397a | One-fifth share in holiday home Languedoc | Land and Property 4f1e6359 | 2011-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-06-20-4f1e6359-24749-0 |
f465dc8507853c3d5354d0648a9ad98552af2bff | One-third share in holiday home Northern Cyprus | Land and Property 4f1e6359 | 2011-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2011-06-20-4f1e6359-24749-0 |
2580bbcc431723de44c088a4bc71ffdf99bacb17 | Aysgarth Properties Ltd | Shareholdings 5b34324e | 2011-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-06-20-5b34324e-24749-0 |
c09766a12d29651cfcdad034ecdc0a2a8ad06281 | Metloc Printers Ltd | Shareholdings 5b34324e | 2011-06-20 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2011-06-20-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");