items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
26 rows where record_id = "2011-11-29-80ef1083-13934-0" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
d7784ec3e6bcdca61df5aa8e92642c2d1bffff9a | Name of donor: Results UK | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 0 | 2011-11-29-80ef1083-13934-0 |
0447272654571c6778ac9c4c65f64e97004491f3 | Amount of donation (or estimate of the probable value): £1075.69 (flights and accommodation) | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 2 | 2011-11-29-80ef1083-13934-0 |
0959e7426a1781e5bf7a4686281f8525fc23174d | Destination of visit: India (Mumbai and Delhi) | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 3 | 2011-11-29-80ef1083-13934-0 |
ebb9af357a0c1822c65692d7f9cd9a86570e453b | Date of visit: 6-10 September 2009 | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 4 | 2011-11-29-80ef1083-13934-0 |
6950b16b4d6a5cb2ce3fb71567c45eec7dbac76b | 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-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 5 | 2011-11-29-80ef1083-13934-0 |
6a3d72a2ef3b356eadf53598e4ebb296b6970e62 | (Registered 13 January 2010) | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 6 | 2011-11-29-80ef1083-13934-0 |
d7cb842f892f0929835966a451f02cae7ae63dba | Name of donor: Results UK | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 7 | 2011-11-29-80ef1083-13934-0 |
783c98dced862ed534974ed96325ba8040230db8 | Address of donor: 25 Clemens Street, Leamington Spa, CV31 2DP. | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 8 | 2011-11-29-80ef1083-13934-0 |
38d7d64189740f9a294139da2382c939c6bacc9b | Amount of donation (or estimate of the probable value): £1903 (flights, accommodation, care hire and food). | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 9 | 2011-11-29-80ef1083-13934-0 |
4a4d96e4ba54316816761736c29773b50222f88a | Destination of visit: Kenya | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 10 | 2011-11-29-80ef1083-13934-0 |
7f6bfa9c414a388e7228ca208354a846390e645d | Date of visit: 29 August-3 September 2010 | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 11 | 2011-11-29-80ef1083-13934-0 |
7d507eb25973f0a8839cc4408a7eeb9b21b4414e | 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-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 12 | 2011-11-29-80ef1083-13934-0 |
0b450443061a19fa6eb51070f53e0b4b20356396 | Name of donor: India800 Foundation, a charity | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 14 | 2011-11-29-80ef1083-13934-0 |
10482f5bcbb5c4ddafca717dfaef92fb6f3757bd | Address of donor: Forbes House, Artillery Lane, London E1 7LP | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 15 | 2011-11-29-80ef1083-13934-0 |
cca5a42e4678d13f6b3038d2242228062b7f2102 | Amount of donation (or estimate of the probable value): £1,850 (flights, transport, meals and accommodation) | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 16 | 2011-11-29-80ef1083-13934-0 |
1240445a5d892c705dafcbd687e0b8329a00bdd9 | Destination of visit: India (Kolkata, Mumbai and New Delhi) | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 17 | 2011-11-29-80ef1083-13934-0 |
8b2d378f0641a81174217cd1ad74aade66d5599f | Date of visit: 2-11 October 2010 | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 18 | 2011-11-29-80ef1083-13934-0 |
c0be6d233960d5a792130dad1dee87114b8939cb | Purpose of visit: to investigate projects meeting educational and health needs that also create employment opportunities to alleviate poverty | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 19 | 2011-11-29-80ef1083-13934-0 |
1b4c91ce0e14c71cbbdebddcf09452bd6899cf4c | (Registered 19 October 2010) | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 20 | 2011-11-29-80ef1083-13934-0 |
34c402c8430af0e9282e980f1f55e1b3f8567404 | Name of donor: UK Kerala Business Forum | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 21 | 2011-11-29-80ef1083-13934-0 |
43f4a7e0aac2969d1c6e311fd80c6747065cc0ea | Address of donor: PO Box 215 Loughton, Essex IG10 3HY | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 22 | 2011-11-29-80ef1083-13934-0 |
9e2bacf2f4f0738a87c333968d59587b491f4626 | Amount of donation (or estimate of the probable value): £2,400 flights and accommodation. I also received an upgrade to Business Class by Air India. | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 23 | 2011-11-29-80ef1083-13934-0 |
cc7103ebce75f2c9fd6268d68a061b5e822ea266 | Destination of visit: India (Kerala) | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 24 | 2011-11-29-80ef1083-13934-0 |
ef7613a91047e788734969d9e3cade20ed63d6fb | Date of visit: 22-30 August 2011 | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 25 | 2011-11-29-80ef1083-13934-0 |
2b1407e5915ff0ec9fb7da70005bf8377778c366 | Purpose of visit: as Chair of the UK Kerala Business forum, to meet with the chief Minister of Kerala and the Kerala Chamber of Commerce to discuss proposed infrastructure, waste and education projects in Kerala. | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 26 | 2011-11-29-80ef1083-13934-0 |
9eb4112878d4c7c6f5dfc48fd29c9c53532d62f1 | (Registered 4 October 2011) | Overseas visits 80ef1083 | 2011-11-29 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 27 | 2011-11-29-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");