items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
413 rows where category_id = "80ef1083" and member_id = "uk.org.publicwhip/member/40275" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, sort_order, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
fd488a9f9c253a9f44113bab3b6420deaaaa49e1 | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-11-25 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-11-25-80ef1083-10684-0 |
84b9020a763e3640f1433cde046419f805ca6f8f | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-11-25 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-11-25-80ef1083-10684-0 |
057aa7fd14efafdc5b7cb9616dd95735b8f6d68c | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-11-25 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-11-25-80ef1083-10684-0 |
4b0f9402a6675059b6c650e6abe14425f8b2bbf4 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-11-25 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-11-25-80ef1083-10684-0 |
d7615e0beb4c7fc639eee58d23af0e263b38445f | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-11-25 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-11-25-80ef1083-10684-0 |
aea5d8315f27ef1f0db01f9fa93ca9d6dc831c7a | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-11-25 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-11-25-80ef1083-10684-0 |
2a9ccc9a427a464d220dd6b4b02f87c5c30b0142 | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-11-25 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-11-25-80ef1083-10684-0 |
f4d00151059b7171fbf7dfe2cb368700f6f3ca12 | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-11-11 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-11-11-80ef1083-10684-0 |
4d890bc77ef1790adffeecf6124047a940deebe3 | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-11-11 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-11-11-80ef1083-10684-0 |
a696bdd763333a209d6df45fcd190a115114153e | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-11-11 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-11-11-80ef1083-10684-0 |
851a320d79fc71291c94894f1132788f7d1346db | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-11-11 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-11-11-80ef1083-10684-0 |
8b0c19b949203c4173387c4a24e42df73c866280 | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-11-11 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-11-11-80ef1083-10684-0 |
30f5ecd2d53b8a52f2f7d5dfcfc06b5de77fced4 | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-11-11 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-11-11-80ef1083-10684-0 |
5cffedd51fa7240bd47c04500d5f7068f6da1590 | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-11-11 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-11-11-80ef1083-10684-0 |
920e905b0573a75472a50fef71e0c36977694d7e | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-10-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-10-28-80ef1083-10684-0 |
c21cb7c8c5a24566f170fe38ebee5d75666a01e0 | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-10-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-10-28-80ef1083-10684-0 |
b541091287e28fa689fbf8d4b4b87987e29c3ee3 | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-10-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-10-28-80ef1083-10684-0 |
cc7861ec45530c3ff329733038e455eac80b2712 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-10-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-10-28-80ef1083-10684-0 |
349431c091d5d54467e25194b05177da3db4b870 | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-10-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-10-28-80ef1083-10684-0 |
48ccdfced3f90499e8c22829ebaa2c114ecb33c8 | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-10-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-10-28-80ef1083-10684-0 |
ce74791bd1a9bdf4487d0e5fcf22277f8881bd7c | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-10-28 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-10-28-80ef1083-10684-0 |
f918b1e141766720a2ac16d9a2c07586f9324709 | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-10-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-10-14-80ef1083-10684-0 |
fc71eefb3ddc5c9427443c80bd2fffeb95afee04 | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-10-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-10-14-80ef1083-10684-0 |
6b2e810b1706077afe85b935d51d32a49e266b96 | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-10-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-10-14-80ef1083-10684-0 |
d97f526870868be97eee0ebbdd3179e782f84806 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-10-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-10-14-80ef1083-10684-0 |
1f365c16cdb4c745b93dc5235485efe32ec5178a | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-10-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-10-14-80ef1083-10684-0 |
1ce7fae69a32de9096894e941a4d0cc1cd3321e7 | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-10-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-10-14-80ef1083-10684-0 |
e390a779ade4eb6317f10e99d8b9d5b1699e3f1b | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-10-14 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-10-14-80ef1083-10684-0 |
307ba9e35f7bd7112ba08722ac148612e682a06a | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-09-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-09-30-80ef1083-10684-0 |
ceaa859ecb809f7b6b917050d8c56257279d577f | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-09-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-09-30-80ef1083-10684-0 |
4d128c2ef4943bd89642c263321a8dde69c38264 | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-09-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-09-30-80ef1083-10684-0 |
82c094f84357852bf67a251e6bc0bd814187c1c2 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-09-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-09-30-80ef1083-10684-0 |
88b21acb33500b663708cbe2c99d4c13c9aa8e1a | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-09-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-09-30-80ef1083-10684-0 |
5aefd9ca95c0355a434852241a8a70ebc98c47be | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-09-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-09-30-80ef1083-10684-0 |
155e97bcce00f520c4d8999cd6b9dd73358d247c | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-09-30 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-09-30-80ef1083-10684-0 |
37ae7a23f486162e7780a9695fa63b4aeda45ddc | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-09-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-09-09-80ef1083-10684-0 |
5fbce5bb9ca555b7f2a819dfd7c7f2205db444a6 | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-09-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-09-09-80ef1083-10684-0 |
5d09317245cc1b3e2d4603b6c71a13409ac49319 | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-09-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-09-09-80ef1083-10684-0 |
6e5bae7b869a9ce5b2285cf395a6a79d02c2ad23 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-09-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-09-09-80ef1083-10684-0 |
97d3734c06108317385fb110598da7a18a8bde65 | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-09-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-09-09-80ef1083-10684-0 |
8815cc3358d4ee3a363dc2b916dae478995620ec | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-09-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-09-09-80ef1083-10684-0 |
6514af2065ec9203e103721a479ca3d66b210540 | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-09-09 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-09-09-80ef1083-10684-0 |
fcedce9f908819ab2a40a63a17ac5424dcfdff4c | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-08-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-08-27-80ef1083-10684-0 |
76ae9c227bf05342a1d1cdb145a70b2dc4eb4046 | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-08-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-08-27-80ef1083-10684-0 |
33615df335c47941a9ed164dc848db187c5dee5c | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-08-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-08-27-80ef1083-10684-0 |
6c0724d11eb5eeb6f0dc8b9e42450be0cdf7da95 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-08-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-08-27-80ef1083-10684-0 |
1ffaf6bd771cf1b398c40b14d01873c68c1de316 | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-08-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-08-27-80ef1083-10684-0 |
e8a41d344d8e420a6a88d10c254c40e06323a451 | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-08-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-08-27-80ef1083-10684-0 |
70d503de6bf7458512fdcd1a01cac0574f36aaed | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-08-27 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-08-27-80ef1083-10684-0 |
7b1062f9a49042d760de840f1061061a7e160fdd | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-07-29 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-07-29-80ef1083-10684-0 |
2ac7d05fb877f6b9c24482fad4482f44650e348c | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-07-29 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-07-29-80ef1083-10684-0 |
9c6ed115451dae082d3ee1f1b0538de648cae10d | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-07-29 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-07-29-80ef1083-10684-0 |
628f622ab8545b8fa397c978c5bd227fd333c6e4 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-07-29 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-07-29-80ef1083-10684-0 |
c95f670b87f9ef63f6ec87446e2c6ceae3484ac5 | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-07-29 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-07-29-80ef1083-10684-0 |
eabaa5bcedcccab2990592b186c32c1eb1ed7aaf | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-07-29 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-07-29-80ef1083-10684-0 |
d20b26ea11c8bd22c209497a2b3a1b4e2a09c245 | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-07-29 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-07-29-80ef1083-10684-0 |
5784faaeeccc483e68cfd2352ae6e898a50cfd16 | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-07-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-07-08-80ef1083-10684-0 |
4505d00910876bf5f8ddf1dfbcf29246fe79740c | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-07-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-07-08-80ef1083-10684-0 |
95e7f4cb39907bd71baa332450e82e48ad99dff5 | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-07-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-07-08-80ef1083-10684-0 |
a32f170c06146102e87c8c9b5b897965be1721b8 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-07-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-07-08-80ef1083-10684-0 |
eaa0dc32be1ab9d361fc6390577da0ab8ed94468 | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-07-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-07-08-80ef1083-10684-0 |
ebe7ded660360f25c51b9009ea011ef32d3427e5 | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-07-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-07-08-80ef1083-10684-0 |
cf1ec6c9ee8cfaa81b678a40e995a30461d76a51 | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-07-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-07-08-80ef1083-10684-0 |
5af273f5500518d7396002bae429a3c106fade3b | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-06-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-06-24-80ef1083-10684-0 |
9b03114802cf9f785537e04b2f2347b727f6e310 | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-06-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-06-24-80ef1083-10684-0 |
ee0d98718207546ead294519734e117207ad91b1 | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-06-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-06-24-80ef1083-10684-0 |
11f9dc4e45834f6307b85d9becb137cdbd1fe826 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-06-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-06-24-80ef1083-10684-0 |
573f486dc618722dedfa03508135676d56d3e807 | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-06-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-06-24-80ef1083-10684-0 |
20cd043c62ccda2a4e6e16e9b346160d89e59181 | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-06-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-06-24-80ef1083-10684-0 |
2a7427514c899daca8196bde6f3253f41b2cade5 | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-06-24 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-06-24-80ef1083-10684-0 |
a206d52d584286a87ac8986e5b02f2faca69b0f0 | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-06-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-06-10-80ef1083-10684-0 |
ff3433f259d811d77cb9d0aaa1387364c90f1d10 | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-06-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-06-10-80ef1083-10684-0 |
8c46538fe0664aa34603aa51ca3fadb6d4d6226a | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-06-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-06-10-80ef1083-10684-0 |
3f89cd54bce1b498dbd14109dea5daa0760e40b6 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-06-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-06-10-80ef1083-10684-0 |
ed6c319f595a68c8a59c54fe32b528c917b4abb3 | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-06-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-06-10-80ef1083-10684-0 |
03ad6e5875f88f3234d7b1ca4ba53bc8d4f98944 | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-06-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-06-10-80ef1083-10684-0 |
7371e14b58db77319b16c690aac2c5f3095b41c2 | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-06-10 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-06-10-80ef1083-10684-0 |
111e6938df84bea87db3c58aa0ac493d06b599e0 | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-05-20 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-05-20-80ef1083-10684-0 |
210e0526220289587ccce59a04ae45762213edec | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-05-20 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-05-20-80ef1083-10684-0 |
39d1f86a53ecb61063f6202bb64149b665ed17c7 | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-05-20 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-05-20-80ef1083-10684-0 |
a0a063341c969a53a0ece2a532858782f0132f25 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-05-20 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-05-20-80ef1083-10684-0 |
72d1a7564aa589ce5578d001557745dd995fc8b4 | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-05-20 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-05-20-80ef1083-10684-0 |
ca339b437ab15c2b0049e2a4b691ae0f331cc974 | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-05-20 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-05-20-80ef1083-10684-0 |
786dd3888cf8b87f47ef8e7f080c2d8334ed739c | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-05-20 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-05-20-80ef1083-10684-0 |
ba37e4deeb45f7149b9c68d67cc7a09c280c4b99 | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-05-07 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-05-07-80ef1083-10684-0 |
266abfe58d69788db02e51f5118f3f680c2a1602 | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-05-07 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-05-07-80ef1083-10684-0 |
65f14f65836637101dc8f4dfb85a0e3acd56a90e | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-05-07 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-05-07-80ef1083-10684-0 |
a433d1b4d9a6790d022e3c48b1faeb2baadc409a | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-05-07 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-05-07-80ef1083-10684-0 |
8f02e998f418bbcd6347db888238a30d4296ddd7 | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-05-07 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-05-07-80ef1083-10684-0 |
ec09046adf4406a713569101fb8798bdfec78384 | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-05-07 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-05-07-80ef1083-10684-0 |
9b4977a706801705bc28ced576f188c40d9127f9 | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-05-07 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-05-07-80ef1083-10684-0 |
1150e712a2f1c957cc00ceabb5fec035574fac19 | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-04-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-04-22-80ef1083-10684-0 |
eba323446f2ea6e8fbcb018748a24c21632132a1 | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-04-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-04-22-80ef1083-10684-0 |
b1e667d2e48ce35b7b2c2abda7e192cdd0283cc7 | Amount of donation (or estimate of the probable value): air fare for myself and my wife with a value of £999.01and hotel accommodation with a value of £445; total: £1,444.01 | Overseas visits 80ef1083 | 2013-04-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 2 | 2013-04-22-80ef1083-10684-0 |
7472139d4f5a4396e77d068cc4d0a5ecfaa28de9 | Destination of visit: Gibraltar | Overseas visits 80ef1083 | 2013-04-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 3 | 2013-04-22-80ef1083-10684-0 |
5faa8cf10febe396a36c5dd3fde4ed4991f97a7b | Date of visit: 6-11 September 2012 | Overseas visits 80ef1083 | 2013-04-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 4 | 2013-04-22-80ef1083-10684-0 |
b85ae179539f3dd1f437e3f3424a33a2edcd90af | Purpose of visit: Visit as part of a Parliamentary Delegation with the APPG on Gibraltar, to celebrate Gibraltar Day. | Overseas visits 80ef1083 | 2013-04-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 5 | 2013-04-22-80ef1083-10684-0 |
8f7e430f2ff958d73c711dd5c481d5251121bbf6 | (Registered 1 November 2012) | Overseas visits 80ef1083 | 2013-04-22 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 6 | 2013-04-22-80ef1083-10684-0 |
796672df094f2781172a27352d4848ced0ea4f7f | Name of donor: H M Government of Gibraltar | Overseas visits 80ef1083 | 2013-04-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 0 | 2013-04-08-80ef1083-10684-0 |
999bb96d208308f95a7059fc78ba1ee244675ba0 | Address of donor: 150 Strand, London, WC2R 1JA | Overseas visits 80ef1083 | 2013-04-08 | John Robertson uk.org.publicwhip/member/40275 | John Robertson uk.org.publicwhip/person/10684 | 1 | 2013-04-08-80ef1083-10684-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");