home / regmem

items

Data source: mySociety Data

17 rows where record_id = "2012-01-13-80ef1083-11946-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
de38f8fb8ddb7a9a152fa7ca8af1f1646d8d022c Name of donor: Parliamentarians for Global Action (UN Office) Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 0 2012-01-13-80ef1083-11946-0
d1c55501a51a7fac1163403fc7dae9ed27b2b4d5 Amount of donation (or estimate of the probable value): £1,500-£2,000 Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 2 2012-01-13-80ef1083-11946-0
d25e0b55ff4d6cdb3672d3a854fdb3826afd215a Destination of visit: Istanbul Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 3 2012-01-13-80ef1083-11946-0
e44b3f096a97b9caca0989294d334e14333e382a Date of visit: 21-25 October 2010 Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 4 2012-01-13-80ef1083-11946-0
6227b79fb95b112cf7efede5f8f47a0252c1589f Purpose of visit: to speak, chair, attend global conference on empowering women and human security in my capacity as Chairman of PGA Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 5 2012-01-13-80ef1083-11946-0
677ae1b72efccc391683466984a0778f121b4ed9 (Registered 8 November 2010) Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 6 2012-01-13-80ef1083-11946-0
0004c8ddc067a0cedf9c75a0eca2c2bd2ae2b6d8 Destination of visit: New York Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 10 2012-01-13-80ef1083-11946-0
42155f62124ab3df6dbcf59d77945d0295f74412 Date of visit: 3-5 January 2011 Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 11 2012-01-13-80ef1083-11946-0
35febd213e69e7d059314ae8bf712ed16a302a98 Purpose of visit: in my capacity as UK Chairman of PGA, to meet with Secretary General, discuss future programme; meet with NGOs and UN staff to discuss representations to Arms Trade Treaty. Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 12 2012-01-13-80ef1083-11946-0
7007d2ccc1e7fc52397d645bf8fb0fac431f05f5 (Registered 24 January 2011) Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 13 2012-01-13-80ef1083-11946-0
6018aaf40eab8af69badbdd0282d7776441fd827 Name of donor: Parliamentarians for Global Action Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 14 2012-01-13-80ef1083-11946-0
864fdfdc0788091bc437ae8eb6c8f061399788d0 Address of donor: 211 East 43rd Street, Suite 1604, New York, NY 10017, USA. Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 15 2012-01-13-80ef1083-11946-0
37b7860be73ce5aa900c0731cd92f0a14d9ee087 Amount of donation (or estimate of the probable value): £2,000 Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 16 2012-01-13-80ef1083-11946-0
b2855b0d7e97edca4da4ae97ac1e1bd337f77393 Destination of visit: Sri Lanka Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 17 2012-01-13-80ef1083-11946-0
543b4bfbbc2dd74cd0ab1ebf0a2041015f06b210 Date of visit: 26-29 October 2011 Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 18 2012-01-13-80ef1083-11946-0
9ad0127f47725a2f23ba99bf091ad6fa3e7161e3 Purpose of visit: to attend the 33rd Annual Forum of Parliamentarians for Global Action, meet with key opposition leaders, cross-party MPs and to participate in discussions on armed conflict and its impact on development and human rights. Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 19 2012-01-13-80ef1083-11946-0
8cf046dffee3c75cbbd3ac994044077134f05f8d (Registered 7 November 2011) Overseas visits 80ef1083 2012-01-13 uk.org.publicwhip/member/40604 Mark Pritchard uk.org.publicwhip/person/11946 20 2012-01-13-80ef1083-11946-0

Advanced export

JSON shape: default, array, object

CSV options:

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)
    )
Powered by Datasette · Query took 94.518ms · Data source: mySociety Data