items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where record_id = "2011-03-28-80ef1083-13934-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
c9f511edd9d0ed9dbd597fbe3d0b0c753dad4f69 | Name of donor: Results UK | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 0 | 2011-03-28-80ef1083-13934-0 |
76958c36f300d8ce45d22f943bf7dc22f468d831 | Amount of donation (or estimate of the probable value): £1075.69 (flights and accommodation) | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 2 | 2011-03-28-80ef1083-13934-0 |
3ab62a4a17267ba58ed287b2f693f46ab87f291d | Destination of visit: India (Mumbai and Delhi) | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 3 | 2011-03-28-80ef1083-13934-0 |
04e05e85931e718372d48405235bb761dbff1487 | Date of visit: 6-10 September 2009 | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 4 | 2011-03-28-80ef1083-13934-0 |
cbbdc94b7755d917cec1da138a56f58626b5bcbf | Purpose of visit: visit to Delhi and Mumbai with Results UK, a charity, to investigate problems of TB, HIV/AIDS, sanitation and water, with rag-pickers and slum-dwellers. | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 5 | 2011-03-28-80ef1083-13934-0 |
fc0503a3d12a5f498eae53a5a565c8f0b1209571 | (Registered 13 January 2010) | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 6 | 2011-03-28-80ef1083-13934-0 |
922cad1a9cf7d436fab983efb4e02fbb028c1fa9 | Name of donor: Results UK | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 7 | 2011-03-28-80ef1083-13934-0 |
c0d29da000e5004c5fd7523190bf0a61e400897a | Address of donor: 25 Clemens Street, Leamington Spa, CV31 2DP. | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 8 | 2011-03-28-80ef1083-13934-0 |
739c5413ef868140f6dd3e3d38bb8175da41120c | Amount of donation (or estimate of the probable value): £1903 (flights, accommodation, care hire and food). | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 9 | 2011-03-28-80ef1083-13934-0 |
065cca2c678062b4ab8a9d7d1f372c7f10ddc371 | Destination of visit: Kenya | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 10 | 2011-03-28-80ef1083-13934-0 |
e46ff0cf4a79c1ed4174d9861848c66890a3a3eb | Date of visit: 29 August-3 September 2010 | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 11 | 2011-03-28-80ef1083-13934-0 |
d021b182135f472e97450f112cd2f5deb6f93354 | Purpose of visit: visit to Kenya with Results UK, a charity, to investigate how to control TB in Kenya and internationally. | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 12 | 2011-03-28-80ef1083-13934-0 |
c26f4e504933ff50b02bb9a23a094f0429a54713 | Name of donor: India800 Foundation, a charity | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 14 | 2011-03-28-80ef1083-13934-0 |
4ff98f8bf09e1a0bdf6327cbea671d5a3e0291ce | Address of donor: Forbes House, Artillery Lane, London E1 7LP | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 15 | 2011-03-28-80ef1083-13934-0 |
d4655d589873e729421c3cbad7522ec8d1c0cd73 | Amount of donation (or estimate of the probable value): £1,850 (flights, transport, meals and accommodation) | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 16 | 2011-03-28-80ef1083-13934-0 |
55bcda0e97003524ac18c59f1e3cebcdec4f083a | Destination of visit: India (Kolkata, Mumbai and New Delhi) | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 17 | 2011-03-28-80ef1083-13934-0 |
d385454c7b292f4001aa662f625c5da221cd267b | Date of visit: 2-11 October 2010 | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 18 | 2011-03-28-80ef1083-13934-0 |
8a793fc50708655f3922974e19abc24c16d366c4 | Purpose of visit: to investigate projects meeting educational and health needs that also create employment opportunities to alleviate poverty | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 19 | 2011-03-28-80ef1083-13934-0 |
a52b5544704d61693ca84b4ff22ce520ec44b052 | (Registered 19 October 2010) | Overseas visits 80ef1083 | 2011-03-28 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 20 | 2011-03-28-80ef1083-13934-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");