items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
91 rows where member_id = "uk.org.publicwhip/member/1830" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, sort_order, record_id, date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| 2e11749c89b02ce1e0482c4b6ff97811908c1cdc | £50 payment to charity for completing panel survey for Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2010-04-12-1f359ece-11174-0 |
| 04727db38d0c6a265e8322a079c9ad75e3a8ef50 | £150 donation to my local constituency party for completing panel survey for Ipsos Mori, 79-81 Borough Road, London SE1 1FY. Hours: 45 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2010-04-12-1f359ece-11174-0 |
| 1806420a826d7bb8a9b2470ca00f5191eed0b465 | £75 donation to my local constituency party for completing panel survey for ComRes, Four Millbank, London SW1P 3JA. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2010-04-12-1f359ece-11174-0 |
| eaacb058d392a32bb0c4805f805ea468ea4e4ab9 | £60 donation to my local constituency party for completing panel survey for PSA. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2010-04-12-1f359ece-11174-0 |
| 1d9d16c71e88f7fe6617185ca3d427b6ff5940d7 | Name of donor: Government of India | Overseas visits 80ef1083 | 2010-04-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2010-04-12-80ef1083-11174-0 |
| ee76496ca0659ac78eb60fccaa65a8c0d8071b54 | Address of donor: India | Overseas visits 80ef1083 | 2010-04-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2010-04-12-80ef1083-11174-0 |
| 143768394c209d7b95b6309d9ec9a323cccd4a48 | Amount of donation (or estimate of the probable value): approximately £3000 | Overseas visits 80ef1083 | 2010-04-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2010-04-12-80ef1083-11174-0 |
| 0f820428b5da54feb8fb145e8372c22647fd5a8b | Destination of visit: Delhi | Overseas visits 80ef1083 | 2010-04-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2010-04-12-80ef1083-11174-0 |
| fa49aea9dd67df3d555307e3ee5ac6514f9ecb44 | Date of visit: 27 September to 3 October 2009 | Overseas visits 80ef1083 | 2010-04-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 4 | 2010-04-12-80ef1083-11174-0 |
| 86fdb82c7adf559a150d2a1e4ee33f3f9a165fe5 | Purpose of visit: to meet with representatives of Indian government, commerce, parliament and security services for briefing on current issues. | Overseas visits 80ef1083 | 2010-04-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 5 | 2010-04-12-80ef1083-11174-0 |
| c7beb30dafd7e47f778b2acda05a7aef7108ab60 | (Registered 3 November 2009) | Overseas visits 80ef1083 | 2010-04-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 6 | 2010-04-12-80ef1083-11174-0 |
| d41e20f98d7c5a98743f60bf2389375a6d01dbad | £50 payment to charity for completing panel survey for Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2010-03-24-1f359ece-11174-0 |
| 8f00a2aeba8493d3d8b5592bf2d3292a987d1421 | £150 donation to my local constituency party for completing panel survey for Ipsos Mori, 79-81 Borough Road, London SE1 1FY. Hours: 45 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2010-03-24-1f359ece-11174-0 |
| df950a40ad48e28e388e274246adf7364a463f7b | £75 donation to my local constituency party for completing panel survey for ComRes, Four Millbank, London SW1P 3JA. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2010-03-24-1f359ece-11174-0 |
| f63f26fa5993eead91ffd9c6b4662a5e2fd3318b | £60 donation to my local constituency party for completing panel survey for PSA. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2010-03-24-1f359ece-11174-0 |
| 554498d85a12f81fbeb2c9fa8fb521be3cf75840 | Name of donor: Government of India | Overseas visits 80ef1083 | 2010-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2010-03-24-80ef1083-11174-0 |
| 2dfb2796f8eed64dce953d18f4ca0c549957a2ee | Address of donor: India | Overseas visits 80ef1083 | 2010-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2010-03-24-80ef1083-11174-0 |
| 97bd4a8423490b84b3d22f4ded818ad3ea9baca2 | Amount of donation (or estimate of the probable value): approximately £3000 | Overseas visits 80ef1083 | 2010-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2010-03-24-80ef1083-11174-0 |
| 64d399dc3732c22d5058dc7555eb393b8d8a47b7 | Destination of visit: Delhi | Overseas visits 80ef1083 | 2010-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2010-03-24-80ef1083-11174-0 |
| 513a09e2de09013a407810ea61c5a09973430db8 | Date of visit: 27 September to 3 October 2009 | Overseas visits 80ef1083 | 2010-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 4 | 2010-03-24-80ef1083-11174-0 |
| 807a33cbecf0f9193e1e5c2da8819d6fb05fbf90 | Purpose of visit: to meet with representatives of Indian government, commerce, parliament and security services for briefing on current issues. | Overseas visits 80ef1083 | 2010-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 5 | 2010-03-24-80ef1083-11174-0 |
| af597710390023d226e97658d94d588536bf9a61 | (Registered 3 November 2009) | Overseas visits 80ef1083 | 2010-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 6 | 2010-03-24-80ef1083-11174-0 |
| 3f92d68f41b2fa818ba79b89368a7822e1a51a6c | £50 payment to charity for completing panel survey for Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2010-03-10-1f359ece-11174-0 |
| 0de18ecffc4f6c688b7be1949f9723437c16d0fb | £150 donation to my local constituency party for completing panel survey for Ipsos Mori, 79-81 Borough Road, London SE1 1FY. Hours: 45 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2010-03-10-1f359ece-11174-0 |
| d2040362ea639d4d07d9bd2ab3cc34a9643600a3 | £75 donation to my local constituency party for completing panel survey for ComRes, Four Millbank, London SW1P 3JA. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2010-03-10-1f359ece-11174-0 |
| 040761537f87143fb1d9b1580111bcf76b6962ac | £60 donation to my local constituency party for completing panel survey for PSA. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2010-03-10-1f359ece-11174-0 |
| bb90a62194734faa8d7f22f5b1909656051a43d8 | Name of donor: Government of India | Overseas visits 80ef1083 | 2010-03-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2010-03-10-80ef1083-11174-0 |
| 4d07efbf6d2f08c44472c823c00dd1b01ae07d99 | Address of donor: India | Overseas visits 80ef1083 | 2010-03-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2010-03-10-80ef1083-11174-0 |
| f94e3c6061b84cc67270a5725e40a2b9f8335e38 | Amount of donation (or estimate of the probable value): approximately £3000 | Overseas visits 80ef1083 | 2010-03-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2010-03-10-80ef1083-11174-0 |
| c5bd09cf59c9028db85a8e2720408796a3545cbc | Destination of visit: Delhi | Overseas visits 80ef1083 | 2010-03-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2010-03-10-80ef1083-11174-0 |
| c3037a047575619d8991afe0e2ab2b338914aa54 | Date of visit: 27 September to 3 October 2009 | Overseas visits 80ef1083 | 2010-03-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 4 | 2010-03-10-80ef1083-11174-0 |
| fd8106578f6ddbfc0618c975a96c2bc863904c84 | Purpose of visit: to meet with representatives of Indian government, commerce, parliament and security services for briefing on current issues. | Overseas visits 80ef1083 | 2010-03-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 5 | 2010-03-10-80ef1083-11174-0 |
| d35c3ed4a23417f11d3c9039919f3ca9622b2936 | (Registered 3 November 2009) | Overseas visits 80ef1083 | 2010-03-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 6 | 2010-03-10-80ef1083-11174-0 |
| 7af550722e6ac25ada5a18d0f640294e69ff3a56 | £50 payment to charity for completing panel survey for Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2010-02-24-1f359ece-11174-0 |
| 3402e8e1e3fd1016f36f45fea8fcd8a7b92202b9 | £150 donation to my local constituency party for completing panel survey for Ipsos Mori, 79-81 Borough Road, London SE1 1FY. Hours: 45 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2010-02-24-1f359ece-11174-0 |
| d55cdbe31fd467957bae0e1309f789d8111b627a | £75 donation to my local constituency party for completing panel survey for ComRes, Four Millbank, London SW1P 3JA. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2010-02-24-1f359ece-11174-0 |
| 29fd8d434cc217d5c796284a4b3052fdc96798f5 | £60 donation to my local constituency party for completing panel survey for PSA. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2010-02-24-1f359ece-11174-0 |
| e54a43e21ccde259c92dd05fc9315be5954f2114 | Name of donor: Government of India | Overseas visits 80ef1083 | 2010-02-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2010-02-24-80ef1083-11174-0 |
| bc5f7d2452d8fe8e0efbdcf6a3d74647504c6d66 | Address of donor: India | Overseas visits 80ef1083 | 2010-02-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2010-02-24-80ef1083-11174-0 |
| 99a5dab8c1b9a6ce53693bd8f0872d2c2c737ae1 | Amount of donation (or estimate of the probable value): approximately £3000 | Overseas visits 80ef1083 | 2010-02-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2010-02-24-80ef1083-11174-0 |
| 338e586f58442d1de8eae9f54b3f366bf41ba143 | Destination of visit: Delhi | Overseas visits 80ef1083 | 2010-02-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2010-02-24-80ef1083-11174-0 |
| 16830454d8ec53684825bb2c9604901117d6495c | Date of visit: 27 September to 3 October 2009 | Overseas visits 80ef1083 | 2010-02-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 4 | 2010-02-24-80ef1083-11174-0 |
| fee521d17ec713637d1f0b28a5e104947e7a5e6f | Purpose of visit: to meet with representatives of Indian government, commerce, parliament and security services for briefing on current issues. | Overseas visits 80ef1083 | 2010-02-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 5 | 2010-02-24-80ef1083-11174-0 |
| 1a8bb50524cd1d4cfbb5c89abb73ffabad1a152b | (Registered 3 November 2009) | Overseas visits 80ef1083 | 2010-02-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 6 | 2010-02-24-80ef1083-11174-0 |
| 4d873a72840282500d6552ba3c347a8b6591fadd | £50 payment to charity for completing panel survey for Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2010-02-03-1f359ece-11174-0 |
| 1c71ac721d5231930bef15b9ce17e274c451264e | £150 donation to my local constituency party for completing panel survey for Ipsos Mori, 79-81 Borough Road, London SE1 1FY. Hours: 45 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2010-02-03-1f359ece-11174-0 |
| 619c2fc83381569a4d739a177f2cbf67eb844529 | £75 donation to my local constituency party for completing panel survey for ComRes, Four Millbank, London SW1P 3JA. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2010-02-03-1f359ece-11174-0 |
| 51e8a2409b5234a47d19fe185662e90e9ea48cbe | £60 donation to my local constituency party for completing panel survey for PSA. Hours: 30 mins. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2010-02-03-1f359ece-11174-0 |
| 3f0c7bd8c2e24ba871d1f6be7fbae7af26be559c | Name of donor: Government of India | Overseas visits 80ef1083 | 2010-02-03 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2010-02-03-80ef1083-11174-0 |
| e993d893e07da9e4fd15a567ddb215a8edfa99cd | Address of donor: India | Overseas visits 80ef1083 | 2010-02-03 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2010-02-03-80ef1083-11174-0 |
| 1bb236eb394dc6ae81837299cf5261ed96d2a9f0 | Amount of donation (or estimate of the probable value): approximately £3000 | Overseas visits 80ef1083 | 2010-02-03 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2010-02-03-80ef1083-11174-0 |
| 0c2c34ee9d71822606c8a307a37747031d833436 | Destination of visit: Delhi | Overseas visits 80ef1083 | 2010-02-03 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2010-02-03-80ef1083-11174-0 |
| 39d1dd0cb60fe3df289046bcb2be56230ee8739e | Date of visit: 27 September to 3 October 2009 | Overseas visits 80ef1083 | 2010-02-03 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 4 | 2010-02-03-80ef1083-11174-0 |
| 45a82a5650515061dd1f6788956be773dc519b9c | Purpose of visit: to meet with representatives of Indian government, commerce, parliament and security services for briefing on current issues. | Overseas visits 80ef1083 | 2010-02-03 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 5 | 2010-02-03-80ef1083-11174-0 |
| a0930cbd503449a9b5530272c14d939a2b052364 | (Registered 3 November 2009) | Overseas visits 80ef1083 | 2010-02-03 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 6 | 2010-02-03-80ef1083-11174-0 |
| 9ab045a7e7427b8ad6ecc24ceb3d7fe826815c23 | Name of donor: Government of India | Overseas visits 80ef1083 | 2010-01-06 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2010-01-06-80ef1083-11174-0 |
| 913eec9e97aac12c7955656e02c49929c69d3cea | Address of donor: India | Overseas visits 80ef1083 | 2010-01-06 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2010-01-06-80ef1083-11174-0 |
| 0c18dfa42bcf255bfc16bf9a53af826dd4cb0944 | Amount of donation (or estimate of the probable value): approximately £3000 | Overseas visits 80ef1083 | 2010-01-06 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2010-01-06-80ef1083-11174-0 |
| 6b9fdcdf22d18a5a88148a79ed67ec80c5d1a061 | Destination of visit: Delhi | Overseas visits 80ef1083 | 2010-01-06 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2010-01-06-80ef1083-11174-0 |
| 61ac52f893fcb62a13c6d413114e6cf7e0972f92 | Date of visit: 27 September to 3 October 2009 | Overseas visits 80ef1083 | 2010-01-06 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 4 | 2010-01-06-80ef1083-11174-0 |
| 69d0f8f3c47e4f26ebb011a6d46088afde5c2bcd | Purpose of visit: to meet with representatives of Indian government, commerce, parliament and security services for briefing on current issues. | Overseas visits 80ef1083 | 2010-01-06 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 5 | 2010-01-06-80ef1083-11174-0 |
| 49c72b5182562ece05d86ec42fe495eb153529e8 | (Registered 3 November 2009) | Overseas visits 80ef1083 | 2010-01-06 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 6 | 2010-01-06-80ef1083-11174-0 |
| 669efe72facc35cdbbfd14a8b8dfc9b47c568c89 | Name of donor: Government of India | Overseas visits 80ef1083 | 2009-12-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2009-12-10-80ef1083-11174-0 |
| 97a9f81689474fcc2708e034c903ca14d9cf3f75 | Address of donor: India | Overseas visits 80ef1083 | 2009-12-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2009-12-10-80ef1083-11174-0 |
| ca7bea1dd39e07867be9cf2aa189ca4c97b4db5d | Amount of donation (or estimate of the probable value): approximately £3000 | Overseas visits 80ef1083 | 2009-12-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2009-12-10-80ef1083-11174-0 |
| f8cf867b78b20f1778f19d37dce15f71db3390ef | Destination of visit: Delhi | Overseas visits 80ef1083 | 2009-12-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2009-12-10-80ef1083-11174-0 |
| abfd2626022144a5611152ffeefea6eeae3b5aaf | Date of visit: 27 September to 3 October 2009 | Overseas visits 80ef1083 | 2009-12-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 4 | 2009-12-10-80ef1083-11174-0 |
| 9d11cf4b77a027893e473d72a54dae75c21b8e60 | Purpose of visit: to meet with representatives of Indian government, commerce, parliament and security services for briefing on current issues. | Overseas visits 80ef1083 | 2009-12-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 5 | 2009-12-10-80ef1083-11174-0 |
| 6b3c3f784f3e1b8aef9663c80361fc62df7cfbab | (Registered 3 November 2009) | Overseas visits 80ef1083 | 2009-12-10 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 6 | 2009-12-10-80ef1083-11174-0 |
| ece5ef640e480c6f00e150afea9053915a8964e7 | Name of donor: Government of India | Overseas visits 80ef1083 | 2009-11-25 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2009-11-25-80ef1083-11174-0 |
| 8f2417ec4b6efd5f103a7a1399be01639b19b034 | Address of donor: India | Overseas visits 80ef1083 | 2009-11-25 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2009-11-25-80ef1083-11174-0 |
| 4653c06b14fdda3db1cbdc2f6c7621e580791995 | Amount of donation (or estimate of the probable value): approximately £3000 | Overseas visits 80ef1083 | 2009-11-25 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2009-11-25-80ef1083-11174-0 |
| 05e65bad384a196bc43c55faf400f78f9f244cd7 | Destination of visit: Delhi | Overseas visits 80ef1083 | 2009-11-25 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2009-11-25-80ef1083-11174-0 |
| 52c4243cd4979705b04737a83ee3f099d62e0a53 | Date of visit: 27 September to 3 October 2009 | Overseas visits 80ef1083 | 2009-11-25 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 4 | 2009-11-25-80ef1083-11174-0 |
| 124eda51fef49028ed7b1dce4195ee66ffc4d7ba | Purpose of visit: to meet with representatives of Indian government, commerce, parliament and security services for briefing on current issues. | Overseas visits 80ef1083 | 2009-11-25 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 5 | 2009-11-25-80ef1083-11174-0 |
| b4d8beffea2720519f1cb30f466edbbc443abdfb | (Registered 3 November 2009) | Overseas visits 80ef1083 | 2009-11-25 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 6 | 2009-11-25-80ef1083-11174-0 |
| e026c47ae6e38a05d0b8774a579b02cf23a00cab | Name of donor: Government of India | Overseas visits 80ef1083 | 2009-11-11 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2009-11-11-80ef1083-11174-0 |
| 8f4fedb1c34e69bbfefab09766af2da11155ebfe | Address of donor: India | Overseas visits 80ef1083 | 2009-11-11 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 1 | 2009-11-11-80ef1083-11174-0 |
| 9422f6bebe5d1c8a869ecd7d2a43b10bbb1fa67c | Amount of donation (or estimate of the probable value): approximately £3000 | Overseas visits 80ef1083 | 2009-11-11 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 2 | 2009-11-11-80ef1083-11174-0 |
| deef8a4ea8e54e32f1adac9a87b5aea4126aa977 | Destination of visit: Delhi | Overseas visits 80ef1083 | 2009-11-11 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 3 | 2009-11-11-80ef1083-11174-0 |
| ccee2ac059f75e9b6bdfeae1eb0b2bdb5f8e4268 | Date of visit: 27 September to 3 October 2009 | Overseas visits 80ef1083 | 2009-11-11 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 4 | 2009-11-11-80ef1083-11174-0 |
| 30ec30ba608df023b620f0251a18dec8ad37452a | Purpose of visit: to meet with representatives of Indian government, commerce, parliament and security services for briefing on current issues. | Overseas visits 80ef1083 | 2009-11-11 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 5 | 2009-11-11-80ef1083-11174-0 |
| 98cd9f528136025cc674bc35282a35154b14d6fc | (Registered 3 November 2009) | Overseas visits 80ef1083 | 2009-11-11 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 6 | 2009-11-11-80ef1083-11174-0 |
| b960f07dcaa2f0db1cf3cf063be217357e4fd9f9 | Donation to my election expenses from Sue and Aidan Maguire (Blue Fountain Systems Ltd). (Registered 26 July 2005) | Sponsorship or financial or material support 9e46def6 | 2006-07-25 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2006-07-25-9e46def6-11174-0 |
| 725012922271136ef5da96467eb96668aa3168c3 | Donation to my election expenses from Sue and Aidan Maguire (Blue Fountain Systems Ltd). (Registered 26 July 2005) | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2006-06-21-9e46def6-11174-0 |
| 46e07036acda4fd8e5709b13e9dcd18e46e1412b | Donation to my election expenses from Sue and Aidan Maguire (Blue Fountain Systems Ltd). (Registered 26 July 2005) | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2006-05-12-9e46def6-11174-0 |
| ead4e6d9ce69e73f7776365f4ad969d4b887b0b2 | Donation to my election expenses from Sue and Aidan Maguire (Blue Fountain Systems Ltd). (Registered 26 July 2005) | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2006-03-24-9e46def6-11174-0 |
| fdb41a701479f61c5f53e7e93334ae3a61846bb6 | Donation to my election expenses from Sue and Aidan Maguire (Blue Fountain Systems Ltd). (Registered 26 July 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2006-02-14-9e46def6-11174-0 |
| 935cee6ba15ae138fdcf2a0fe48bc1e92367b2a8 | Donation to my election expenses from Sue and Aidan Maguire (Blue Fountain Systems Ltd). (Registered 26 July 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2006-02-13-9e46def6-11174-0 |
| aa4576effa973a10175250a870793c908a692047 | Donation to my election expenses from Sue and Aidan Maguire (Blue Fountain Systems Ltd). (Registered 26 July 2005) | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2005-12-14-9e46def6-11174-0 |
| f77881316a8ceb2dc79b885b2be318d6c7f77ec9 | Donation to my election expenses from Sue and Aidan Maguire (Blue Fountain Systems Ltd). (Registered 26 July 2005) | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | John Pugh uk.org.publicwhip/member/1830 | John Pugh uk.org.publicwhip/person/11174 | 0 | 2005-11-01-9e46def6-11174-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");