items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where record_id = "2012-09-03-80ef1083-11599-0" sorted by date
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
2ae916527ae7a6746fd6c29fa93394f92488a947 | Address of donor: 83 Victoria Street, London SW1H OHW | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 1 | 2012-09-03-80ef1083-11599-0 |
b4fb1ebabaaa2f2af351eb37ec7b5d3737d494bc | Amount of donation (or estimate of the probable value): cars, flights, accommodation and communications; approximate value £2,000 | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 2 | 2012-09-03-80ef1083-11599-0 |
1aebea720fef472b04cccf7290c4e8957d94390d | Destination of visit: Tripoli, Libya | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 3 | 2012-09-03-80ef1083-11599-0 |
cf1263b398fa545a79cd05d0f7403f519cac49d1 | Date of visit: 30 August-5 September 2011 | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 4 | 2012-09-03-80ef1083-11599-0 |
3addd761c1b7898934fac0d0d6f28d058ae7ac91 | Purpose of visit: to look at the situation in the immediate aftermath of the collapse of the regime. | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 5 | 2012-09-03-80ef1083-11599-0 |
06cf11373138cfa16ffa4c4e0204e8c9e2b2ebaf | (Registered 16 April 2012) | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 6 | 2012-09-03-80ef1083-11599-0 |
14f3b58a32e54e6dc6a3dc367c981154857693a4 | Name of donor: | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 7 | 2012-09-03-80ef1083-11599-0 |
8ddcc0c3838a3d761582568afe63bf2dcd036a4e | 1) Government of Japan | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 8 | 2012-09-03-80ef1083-11599-0 |
238d186f852e322a1e16b5635a3c7ed455bc7892 | 2) All Party Parliamentary Group on Japan | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 9 | 2012-09-03-80ef1083-11599-0 |
92ffe2d870ec94f4435febea1c3a9fb391e55438 | Address of donor: | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 10 | 2012-09-03-80ef1083-11599-0 |
983846e174e8e48e8cf2d840ece688294e06739e | 1) Embassy of Japan, 101-104 Piccadilly, London; | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 11 | 2012-09-03-80ef1083-11599-0 |
8af695bfbffce614eb8f9e82a81138ff9904debd | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 12 | 2012-09-03-80ef1083-11599-0 |
831a484980a5b47dbc443b410394b3e39506b51a | 1) all internal costs, estimated at £2,500 | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 13 | 2012-09-03-80ef1083-11599-0 |
9bc479015f5b25cebbb49feed39f8dfec86a8888 | 2) flights to and from Japan, estimated at £2,000 | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 14 | 2012-09-03-80ef1083-11599-0 |
664e01ce7f1b932fdd20a06a48ff502fd14dbc28 | Destination of visit: Japan | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 15 | 2012-09-03-80ef1083-11599-0 |
fe7038d05281387a9f7c637bf01fb2135f181913 | Date of visit: 17-24 March 2012 | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 16 | 2012-09-03-80ef1083-11599-0 |
55233a321fa84e0ce01f4847a8608f8e46263958 | Purpose of visit: to promote relations between parliamentarians in Westminster and the Diet, to promote trade and to look at the tsunami affected area. | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 17 | 2012-09-03-80ef1083-11599-0 |
a2764a9c7f42bdd1faa6d43e1d0c9f1677e06b53 | (Registered 11 April 2012) | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 18 | 2012-09-03-80ef1083-11599-0 |
45c2b1afa6ddc4df365ee5070a344c20a4b3f5ec | Name of donor: Kurdish Democratic Party | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 19 | 2012-09-03-80ef1083-11599-0 |
ba272a160fe6a44dafaeae8d1cd1547ddbd152fa | Address of donor: Erbil, Kurdish Autonomous Region, Iraq | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 20 | 2012-09-03-80ef1083-11599-0 |
66deef3725a713646e43a30a3e9a3ac09f85aebc | Amount of donation (or estimate of the probable value): flights and accommodation worth approximately £2,500 | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 21 | 2012-09-03-80ef1083-11599-0 |
0003f5a834079471bf6a5b04182b65509b69a46c | Destination of visit: Northern Iraq | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 22 | 2012-09-03-80ef1083-11599-0 |
72a9f701e257412b05fe74b2b1b8c0e8a83f0d20 | Date of visit: 11 to 13 June 2012 | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 23 | 2012-09-03-80ef1083-11599-0 |
8dddc8311d280e1ceb387f0802433cfdbb73bec0 | Purpose of visit: to view progress since the 2003 invasion of Iraq. | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 24 | 2012-09-03-80ef1083-11599-0 |
eb3f40a9dc790cca9924847f4effb4a76c518255 | Name of donor: Conservative Middle East Council | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 26 | 2012-09-03-80ef1083-11599-0 |
7349014bcba2211815ec4eda934ee7c0afe6cdb1 | Address of donor: 55 Tufton St, London SW1P 3QL | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 27 | 2012-09-03-80ef1083-11599-0 |
a13aa01fb6cbffefd74e54b879e0095414e8df65 | Amount of donation (or estimate of the probable value): flights, accommodation, vehicles and services of interpreters worth approximately £1,000 in total | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 28 | 2012-09-03-80ef1083-11599-0 |
6cfdfb9475a140321922cf197f929f788a0b7c08 | Destination of visit: Lebanon | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 29 | 2012-09-03-80ef1083-11599-0 |
b98aff6ea5abe85ec2d5f1251ea49dff3b7b97e7 | Date of visit: 18 -23 April 2012 | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 30 | 2012-09-03-80ef1083-11599-0 |
03c2c42e418f19ea12cc2c7fc6b6ea9812c54c04 | Purpose of visit: to look at fallout from civil war in Syria and to visit border area | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 31 | 2012-09-03-80ef1083-11599-0 |
a81634cfb100ccf9deabad41d03b95cb88daf642 | (Registered 21 August 2012) | Overseas visits 80ef1083 | 2012-09-03 | Adam Holloway uk.org.publicwhip/member/40284 | Adam Holloway uk.org.publicwhip/person/11599 | 32 | 2012-09-03-80ef1083-11599-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");