items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where record_id = "2011-01-24-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 |
---|---|---|---|---|---|---|---|
080cfc1d766fdbbfb02799121db60269b40df95b | Name of donor: Results UK | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 0 | 2011-01-24-80ef1083-13934-0 |
ee12edcb34443af44fa5bfb5b800e945d96ac9c9 | Amount of donation (or estimate of the probable value): £1075.69 (flights and accommodation) | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 2 | 2011-01-24-80ef1083-13934-0 |
77594964753fc7ce363d9725118cfac86eafa348 | Destination of visit: India (Mumbai and Delhi) | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 3 | 2011-01-24-80ef1083-13934-0 |
388a3299981871d60a45318ac940a26b6a235e0c | Date of visit: 6-10 September 2009 | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 4 | 2011-01-24-80ef1083-13934-0 |
cf3c4b83498306ba1b130195a503d38d143d577d | 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-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 5 | 2011-01-24-80ef1083-13934-0 |
202fafaa71f2b5cf77c46d80d7131d064f925f80 | (Registered 13 January 2010) | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 6 | 2011-01-24-80ef1083-13934-0 |
f686cfb9b879410d545c7cd2b8bc70d93e86f6cb | Name of donor: Results UK | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 7 | 2011-01-24-80ef1083-13934-0 |
a9f23ec3ed34cc5859b3dbb9356a8301910f10d2 | Address of donor: 25 Clemens Street, Leamington Spa, CV31 2DP. | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 8 | 2011-01-24-80ef1083-13934-0 |
a0635c901d7ed73977a563213d3b53d30f972d6b | Amount of donation (or estimate of the probable value): £1903 (flights, accommodation, care hire and food). | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 9 | 2011-01-24-80ef1083-13934-0 |
213d8aaf9ce65cc98b9ec038a7749ce36faef0eb | Destination of visit: Kenya | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 10 | 2011-01-24-80ef1083-13934-0 |
cb64869cab286b95893b2ae824b627aeaf345677 | Date of visit: 29 August-3 September 2010 | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 11 | 2011-01-24-80ef1083-13934-0 |
a6e5ce47df0b316e7302a8974e02e511a4c43c7e | 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-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 12 | 2011-01-24-80ef1083-13934-0 |
ed6ee16fd6813dd233b4f2e4ce085a53336707ee | Name of donor: India800 Foundation, a charity | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 14 | 2011-01-24-80ef1083-13934-0 |
271599aac79fac6d5e75f6bd5af1740e2ebed985 | Address of donor: Forbes House, Artillery Lane, London E1 7LP | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 15 | 2011-01-24-80ef1083-13934-0 |
774bdef66cb34d7fdff57241ea963c3a3cefc6bd | Amount of donation (or estimate of the probable value): £1,850 (flights, transport, meals and accommodation) | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 16 | 2011-01-24-80ef1083-13934-0 |
c6e5f959977c114deb572157c1c4bf17ef522336 | Destination of visit: India (Kolkata, Mumbai and New Delhi) | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 17 | 2011-01-24-80ef1083-13934-0 |
b005a4a46eafbe3aefaa020287abc719ff21bf14 | Date of visit: 2-11 October 2010 | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 18 | 2011-01-24-80ef1083-13934-0 |
7acce9f2c1d53f131b9ae80a2e8346c39993f7cd | Purpose of visit: to investigate projects meeting educational and health needs that also create employment opportunities to alleviate poverty | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 19 | 2011-01-24-80ef1083-13934-0 |
8df185e049c2869bf464502df4b2a09c4f82d43d | (Registered 19 October 2010) | Overseas visits 80ef1083 | 2011-01-24 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 20 | 2011-01-24-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");