items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
37 rows where record_id = "2014-03-24-80ef1083-11946-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 |
---|---|---|---|---|---|---|---|
27ec25574e8298dca31926f0245a59f83ce1fd26 | Name of donor: Parliamentarians for Global Action (PGA) | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 0 | 2014-03-24-80ef1083-11946-0 |
0c0383c44641799bb3287ed2010c7657c4151c6d | Address of donor: PGA-UN Office, 211 East 43rd Street, Suite 1604, New York, NY, 10017, USA | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 1 | 2014-03-24-80ef1083-11946-0 |
6a32ea61e89333066fd610e6a5578a9dc7ba699a | Amount of donation (or estimate of the probable value): flights and accommodation; £1,500 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 2 | 2014-03-24-80ef1083-11946-0 |
6c74e4c58d758f0a7ba1b31300ead9e8ff3b7156 | Destination of visit: Rome | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 3 | 2014-03-24-80ef1083-11946-0 |
181303498e7e863dccda8d99c14431a96ab60a21 | Date of visit: 10-13 December 2012 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 4 | 2014-03-24-80ef1083-11946-0 |
f59da2b32a9d019c2aaf59cfee272e910f742317 | Purpose of visit: to discuss the Rome Statute of the International Criminal Court and human rights in my capacity as Chairman of the PGA. | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 5 | 2014-03-24-80ef1083-11946-0 |
f1f860453af57497830a72f73a4f8763c305a241 | (Registered 6 March 2013) | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 6 | 2014-03-24-80ef1083-11946-0 |
69f5372b305bc36533401c587e0018dbc2d21d38 | Amount of donation (or estimate of the probable value): flights and accommodation with a value of £2,500 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 9 | 2014-03-24-80ef1083-11946-0 |
3277aa26a4d94e25780b57c23d38cfa4e4a97d7c | Destination of visit: United Nations, New York | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 10 | 2014-03-24-80ef1083-11946-0 |
000819dc81eaa2fd33f7a595e7f139dd5d1dd352 | Date of visit: 24-30 March 2013 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 11 | 2014-03-24-80ef1083-11946-0 |
cdc61cd964760fc12882335ac78375538962b67e | Purpose of visit: to meet NGOs, charities, UN officials and negotiators, as part of the Arms Trade Treaty negotiations at the United Nations, New York, in my capacity as a global board member of the Parliamentarians for Global Action. | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 12 | 2014-03-24-80ef1083-11946-0 |
0b670dfa96131396d4d4a1e43de3f839e92772a2 | (Registered 3 April 2013) | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 13 | 2014-03-24-80ef1083-11946-0 |
03a69d87d82627f018e55359a9d878ea2276980a | Amount of donation (or estimate of the probable value): flights, accommodation and other costs with a value of £3,500-£4,000 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 16 | 2014-03-24-80ef1083-11946-0 |
5ef1e25f107907ca0c8deabfbc11d91e0fbfbc64 | Destination of visit: Jakarta, Indonesia | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 17 | 2014-03-24-80ef1083-11946-0 |
99564e6707ebfc6186eae834fc25c7397101c575 | Date of visit: 10-16 May 2013 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 18 | 2014-03-24-80ef1083-11946-0 |
423817c055028ff93833e166f2b0dcbf25dc57ec | Purpose of visit: to discuss Rome statute of the international criminal court and to raise human rights issues in Indonesia and to discuss parliamentary reform in my capacity as a board member and UK chairman of the PGA. | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 19 | 2014-03-24-80ef1083-11946-0 |
57463f7d05b0b53cb8bb0f80190c047c22c7e82a | (Registered 12 June 2013) | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 20 | 2014-03-24-80ef1083-11946-0 |
b58b663c4d7e12e1991121b980624ed1c279f551 | Name of donor: Christian Aid | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 21 | 2014-03-24-80ef1083-11946-0 |
cb4813cd7e681c9465a5b3b8a4f49fc701dcbe8a | Address of donor: 35 Lower Marsh, London SE1 7RT | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 22 | 2014-03-24-80ef1083-11946-0 |
7f1687d4c0e449b78afab63a838b7a57f238340a | Amount of donation (or estimate of the probable value) : £1,055 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 23 | 2014-03-24-80ef1083-11946-0 |
ba7f7a67d3b3ba069e2963b041eefc427fa2b4a4 | Destination of visit: Democratic Republic of the Congo | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 24 | 2014-03-24-80ef1083-11946-0 |
587d0754b3b6b95769035194c06b1274dece85d9 | Date of visit: 26-29 May 2013 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 25 | 2014-03-24-80ef1083-11946-0 |
b652faa414a4ba47ea3211a710a7384012ed7ef0 | Purpose of visit: to examine the implementation of conflict resolution processes for eastern DRC and key reforms relating to long-term stabilisation objectives for the DRC; to meet M23 former rebel leaders, NGOs and charities | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 26 | 2014-03-24-80ef1083-11946-0 |
f159c136db29c97d353fc645b89643792baac210 | (Registered 19 June 2013) | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 27 | 2014-03-24-80ef1083-11946-0 |
bfb8b8db541e82d4ee4611ca9665f0291f3ae8ac | Address of donor: PGA-UN Office, 211 East 43 rd Street, Suite 1604, New York, NY 10017 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 29 | 2014-03-24-80ef1083-11946-0 |
a54023f7aa5da04af7c60404205cb9ee7327e092 | Amount of donation (or estimate of the probable value): flights, accommodation and other costs with a value of £2,800 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 30 | 2014-03-24-80ef1083-11946-0 |
130b0096819ec9e9eecf3fa8fb0eac84784bb503 | Destination of visit: Bogota, Colombia | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 31 | 2014-03-24-80ef1083-11946-0 |
d2d3510f99ba05432db6b3ce9ce6ae6b143ab312 | Date of visit: 8-11 December 2013 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 32 | 2014-03-24-80ef1083-11946-0 |
bd0a53952cd82f0daeffba08cdd5f855d99c95c7 | Purpose of visit: to attend, chair, and speak at the 35th Annual Parliamentary Forum of Parliamentarians for Global Action in my role as PGA board member. | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 33 | 2014-03-24-80ef1083-11946-0 |
dcca4b01cdadfcfbf58055110d093c6a83dd1c40 | (Registered 16 December 2013) | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 34 | 2014-03-24-80ef1083-11946-0 |
5d11b2f911bd346f20aa006567ffa40c68bbd9d5 | Name of donor: Parliamentarians for Global Action (PGA) | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 35 | 2014-03-24-80ef1083-11946-0 |
53af2244fa405e8ffd6bbb26776d2afdcf475708 | Address of donor: PGA-UN Office, 211 East 43 rd Street, Suite 1604, New York, NY 10017, USA | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 36 | 2014-03-24-80ef1083-11946-0 |
e827a1b36b14099585d6444b18d4ac5b298d12c1 | Amount of donation (or estimate of the probable value): costs of visit estimated at £3,000-£4,000 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 37 | 2014-03-24-80ef1083-11946-0 |
e1c683bb6c3d4db26239a934b7d353a1e53b4ca0 | Destination of visit: Sierra Leone | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 38 | 2014-03-24-80ef1083-11946-0 |
46e917f6187441872de3af3f7421576dbdbe7e61 | Date of visit: 12-16 January 2014 | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 39 | 2014-03-24-80ef1083-11946-0 |
c56d08420a32cd30dd59363e5870da3f1efa6027 | Purpose of visit: to attend and speak at a conference on the abolition of the death penalty in my capacity as a board member of PGA. | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 40 | 2014-03-24-80ef1083-11946-0 |
0544c585f471bb651d6c5f3227c1b1e64b425877 | (Registered 19 February 2014) | Overseas visits 80ef1083 | 2014-03-24 | Mark Pritchard uk.org.publicwhip/member/40604 | Mark Pritchard uk.org.publicwhip/person/11946 | 41 | 2014-03-24-80ef1083-11946-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");