items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2010-03-24-80ef1083-10221-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 |
---|---|---|---|---|---|---|---|
421ec6b7e69119808e81ba0337d5442811b2653d | Name of donor: Ministry of External Affairs, Government of India | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 0 | 2010-03-24-80ef1083-10221-0 |
f3774ea02513fbb0646eec7b35db826fcbe76862 | Address of donor: South Block, Secretariat Building, Raisina Hill, Delhi, India | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 1 | 2010-03-24-80ef1083-10221-0 |
57826e930e6553fe12a30e93ad96e8b14ed40148 | Amount of donation (or estimate of the probable value): £5,000 including travel to and from India, travel within India, accommodation and some meals. | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 2 | 2010-03-24-80ef1083-10221-0 |
3dd4f7d6e01322d76d42adaf7a2d038331f15c03 | Destination of visit: Delhi, India | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 3 | 2010-03-24-80ef1083-10221-0 |
667474b7adcb4e2f983f714ecffdfed1bd224e7a | Date of visit: 25-30 July 2009 | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 4 | 2010-03-24-80ef1083-10221-0 |
634a99c54ac210f04abf9bb19297cca772e1baae | Purpose of visit: To meet Indian parliamentarians, Government ministers and officials, academics and business leaders and to become better acquainted with British-Indian political, diplomatic and trade matters from the Indian point of view. (Registered 31 July 2009) | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 5 | 2010-03-24-80ef1083-10221-0 |
15170713035f6d098ec1583c8485c0d80305224f | Name of donor: Conservative Friends of Israel | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 6 | 2010-03-24-80ef1083-10221-0 |
89ceb6cf5d7c1897ed5fd484d507b982d77c84c1 | Address of donor: 45B Westbourne Terrace, London W2 3UR. | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 7 | 2010-03-24-80ef1083-10221-0 |
295d9899fcac146ec42aa41143642c44f3e2f260 | Amount of donation (or estimate of the probable value): £2,000 | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 8 | 2010-03-24-80ef1083-10221-0 |
5b1c62a06243a088875876b68df41835ca616517 | Destination of visit: Israel and the West Bank | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 9 | 2010-03-24-80ef1083-10221-0 |
a19e4e48a61181cb8619f7547772757106be2bdd | Date of visit: 14-19 February 2010 | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 10 | 2010-03-24-80ef1083-10221-0 |
163836f0871996cbbb83f8320cd2c753afe2b5e9 | Purpose of visit: to meet Israeli and Palestinian government ministers and politicians, central and other bankers, business people, judges and lawyers. | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 11 | 2010-03-24-80ef1083-10221-0 |
6e4019bebe382ae47a55ff10a3be7555d34b9994 | (Registered 25 February 2010) | Overseas visits 80ef1083 | 2010-03-24 | Edward Garnier uk.org.publicwhip/member/1615 | Edward Garnier uk.org.publicwhip/person/10221 | 12 | 2010-03-24-80ef1083-10221-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");