items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
346 rows where person_id = "uk.org.publicwhip/person/10010" sorted by category_id
This data as json, CSV (advanced)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
3d4d71c25c47a7534b71261acc090af7f275c0a6 | Houses and miscellaneous property on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2004-10-22 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 1 | 2004-10-22-4f1e6359-10010-0 |
3def62bc311ab1b9c7601f135fa36fc8a8df5ba6 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-10-09 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-10-09-4f1e6359-10010-0 |
41cd9db0b87179ca2ef8c1c39f433b4c8b8805a9 | Industrial rents (mining) in Lothian, Scotland. | Land and Property 4f1e6359 | 2004-10-22 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 2 | 2004-10-22-4f1e6359-10010-0 |
43e6bd9047642af4e418cec024560e3030b21b00 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. (Registered 10 October 2005) | Land and Property 4f1e6359 | 2006-03-24 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2006-03-24-4f1e6359-10010-0 |
4a80622dfabc33e1087a304c9393a2d3df2bda87 | Farms on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2002-11-26 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2002-11-26-4f1e6359-10010-0 |
4b34b6e7a166fbd0bbd788e298bebe9c99ae0012 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2009-04-22 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-04-22-4f1e6359-10010-0 |
4bf6431ce1a9208b552c6cacd1c9e77b80e9d822 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-12-18 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-12-18-4f1e6359-10010-0 |
4e9f099392dbabbd8fa980f37cc2a4de343f7379 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-01-09 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-01-09-4f1e6359-10010-0 |
4f023d982a4480eb1dfb81a997185a2838dc720b | Houses and miscellaneous property on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2005-04-11 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 1 | 2005-04-11-4f1e6359-10010-0 |
4f7d87db18b2e7791da492d1c6dd0132d31b36f6 | Farms on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2005-01-28 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2005-01-28-4f1e6359-10010-0 |
4ffd2f25c583ce34a197d13cbcef46802b6e5183 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-06-19 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-06-19-4f1e6359-10010-0 |
501174f172c8ee56cc409b08021740abfcbc676f | Houses and miscellaneous property on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2004-05-21 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 1 | 2004-05-21-4f1e6359-10010-0 |
516c0437fe05fb60698b3c13e2fd2be87f473e9d | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2009-02-11 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-02-11-4f1e6359-10010-0 |
51cc5e09c2f175ad2df947e353fa80c65d95ef97 | Industrial rents (mining) in Lothian, Scotland. | Land and Property 4f1e6359 | 2005-04-11 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 2 | 2005-04-11-4f1e6359-10010-0 |
56aba4892f1666249944ae737f20ba8e99c04a3f | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2010-02-03 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-02-03-4f1e6359-10010-0 |
5741d11928c27d5671165e87688ac05f2cca841a | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-07-30 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-07-30-4f1e6359-10010-0 |
5a4334a507a1fd8e6bab5e1ae34558a50df29cfd | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-02-26 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-02-26-4f1e6359-10010-0 |
5a4d95c85062b1823650d7dd0a173809f8a31792 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-12-03 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-12-03-4f1e6359-10010-0 |
5b95892ed7bb56dc97f79c924d93ffb6d8f8d5cc | Houses and miscellaneous property on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2004-07-16 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 1 | 2004-07-16-4f1e6359-10010-0 |
5c7f322f6935a7092f34a428fc651b9ccb6f1475 | A small tenanted estate and a partnership in a tenanted farm in Roxburghshire. | Land and Property 4f1e6359 | 2002-05-14 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2002-05-14-4f1e6359-10010-0 |
5e163293aae8964335f5d53c5a776ca4c15c9436 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2009-01-14 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-01-14-4f1e6359-10010-0 |
5f605bfe1dab1ebbc677c9b8c041ecc921e7a31b | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-02-05 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-02-05-4f1e6359-10010-0 |
5ff92e2298fc1da43ef4e68a2dc4479f291a68c4 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-11-19 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-11-19-4f1e6359-10010-0 |
60c1beb179f5dd04c1ac6df0a696f500e5faa119 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-08-28 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-08-28-4f1e6359-10010-0 |
61483a5031a9f2ac57a8d55f2b6cddfb0234a9bf | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. (Registered 10 October 2005) | Land and Property 4f1e6359 | 2006-02-14 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2006-02-14-4f1e6359-10010-0 |
632288773152166c0adb70c931842b75e201fe76 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. (Registered 10 October 2005) | Land and Property 4f1e6359 | 2005-11-01 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2005-11-01-4f1e6359-10010-0 |
65a600742a04d2d8d65524184ab5200326d5c498 | Industrial rents (mining) in Lothian, Scotland. | Land and Property 4f1e6359 | 2004-05-21 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 2 | 2004-05-21-4f1e6359-10010-0 |
66010f8e5f0ab280eaf7d7f0f4e5d7b45bbe54dc | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2009-12-10 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-12-10-4f1e6359-10010-0 |
68f1306a3f35a555e27158bde23341ebb0e25fba | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-07-08 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-07-08-4f1e6359-10010-0 |
69f32ef171711e2d580c7ec10d1329fd60c792f6 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-07-22 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-07-22-4f1e6359-10010-0 |
70765529e4d13180ae36594eaf9aee82f4aff070 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-07-17 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-07-17-4f1e6359-10010-0 |
71ee96caac40f486c86f369071dabfd47732ea96 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-03-11 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-03-11-4f1e6359-10010-0 |
729096e0ad6bfd79b405bde1ecfe4e6ba8aaec74 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2009-02-25 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-02-25-4f1e6359-10010-0 |
72a6bed40c40831377b1d97e41efb11d1a4ac4ad | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-10-22 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-10-22-4f1e6359-10010-0 |
74ae13bee42bfe975a18af9ff29f7e88d576e403 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2009-05-20 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-05-20-4f1e6359-10010-0 |
77d8e2184904328b13acfe756625ecc10516c61d | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2010-01-06 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-01-06-4f1e6359-10010-0 |
79768f45744713d2d187b365b3d741b57c06febc | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-03-13 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-03-13-4f1e6359-10010-0 |
7a0d3267047456c265165ab11305de6b71e48837 | A small tenanted estate and a partnership in a tenanted farm in Roxburghshire. | Land and Property 4f1e6359 | 2000-11-10 | Michael Ancram uk.org.publicwhip/member/10 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2000-11-10-4f1e6359-10010-0 |
7bec3dcd5c93ac2f844253fd7cf877a7bb0422e5 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-03-26 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-03-26-4f1e6359-10010-0 |
7e336227ddd893fea31323280d0f8401c2268fca | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. (Registered 10 October 2005) | Land and Property 4f1e6359 | 2006-05-12 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2006-05-12-4f1e6359-10010-0 |
7e8a0433fc8bd65ad18f433b77286a8db614e505 | Industrial rents (mining) in Lothian, Scotland. | Land and Property 4f1e6359 | 2004-12-03 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 2 | 2004-12-03-4f1e6359-10010-0 |
82d0fb38a3ea66144e109a58ca4b9edfa0c75f03 | Farms on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2004-07-16 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2004-07-16-4f1e6359-10010-0 |
8988162c07c211b2a5fbd09fe437666801839836 | A small tenanted estate and a partnership in a tenanted farm in Roxburghshire. | Land and Property 4f1e6359 | 2001-05-14 | Michael Ancram uk.org.publicwhip/member/10 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2001-05-14-4f1e6359-10010-0 |
8c5d74fb6ad261644742bb324bc234da7365c5d6 | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2009-11-11 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-11-11-4f1e6359-10010-0 |
8ebbc3aeb5e668044ee1af2260337729e0bb444e | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-09-03 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-09-03-4f1e6359-10010-0 |
8f799db51cfb3101bc0ca5fbdb8ec538be06bfb9 | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2010-03-24 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-03-24-4f1e6359-10010-0 |
969cc6eb4e1098d31fb312ca5d5f944d6ca22c78 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-05-01 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-05-01-4f1e6359-10010-0 |
a2f5a64a6dc790bee7ca9cf3979540b5ce7f71d8 | Farms on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2003-12-04 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2003-12-04-4f1e6359-10010-0 |
a306d781393a94b6a71126071933de1d0ae62941 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2009-06-10 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-06-10-4f1e6359-10010-0 |
ab3a8e5f40229301aaea96bbd1dec29c8aebc61e | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. (Registered 10 October 2005) | Land and Property 4f1e6359 | 2005-12-14 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2005-12-14-4f1e6359-10010-0 |
ac66ada3fd35e00fe1149bcf0f320fa165b1d7ab | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-06-16 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-06-16-4f1e6359-10010-0 |
acf0b3f78d8d56e3dfc72c27d1a2b0c243e00567 | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2010-03-10 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-03-10-4f1e6359-10010-0 |
ad8ae2da8bc46493b93790a76610f4d25f28b2f3 | Houses and miscellaneous property on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2002-11-26 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 1 | 2002-11-26-4f1e6359-10010-0 |
b172b01913b5fa52deee193f85220cf678e5cde8 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. (Registered 10 October 2005) | Land and Property 4f1e6359 | 2006-06-21 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2006-06-21-4f1e6359-10010-0 |
b3f5439969b59b8c952e33f73f6bab30c855b9fd | Farms on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2004-09-08 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2004-09-08-4f1e6359-10010-0 |
b82569912680aa3aee195e012686989ba117dcbc | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2010-04-12 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-04-12-4f1e6359-10010-0 |
bf43b3062e88051f461f15c8f4b3a056e44917ea | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-11-06 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-11-06-4f1e6359-10010-0 |
c0f918daf0ae83d0013bd09a89701e00cd0d4ef3 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2009-07-08 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-07-08-4f1e6359-10010-0 |
c1d9f4613803eebf59d07770a2fc5464ea106c5d | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2009-09-02 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-09-02-4f1e6359-10010-0 |
c464f59fe3df98d6b7ac10de8728021b1a182ac6 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2009-03-11 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-03-11-4f1e6359-10010-0 |
ca23cf42ae274c9d8af5b7b95d1fd5a1b393fa53 | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2010-02-24 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-02-24-4f1e6359-10010-0 |
cba8d37cac3be16ef0d3c42a63348d4d35ebd29b | Industrial rents (mining) in Lothian, Scotland. | Land and Property 4f1e6359 | 2002-11-26 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 2 | 2002-11-26-4f1e6359-10010-0 |
cd06f0532de68c490a146337f336b730a4ca4c7c | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-02-06 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-02-06-4f1e6359-10010-0 |
ce37bb51cb71a0aed5dddde1529ce2b230f1864a | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-12-17 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-12-17-4f1e6359-10010-0 |
d01b3dd2500cf29e30dae726e22a89833b7bfaa0 | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2009-11-25 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-11-25-4f1e6359-10010-0 |
d0483146783049e3954ed695e3be261cda6c6953 | Farms on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2005-04-11 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2005-04-11-4f1e6359-10010-0 |
d851003588ac31079699fff5762152e4b11fe971 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2009-03-25 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-03-25-4f1e6359-10010-0 |
dd977c33f03dcb2c929eeb903b571fdf4b213a8d | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-12-04 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-12-04-4f1e6359-10010-0 |
df9f3f09009337417eaba3c60303432a85291d02 | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2009-10-28 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-10-28-4f1e6359-10010-0 |
e4adb31703820a2a44942fe57ec7d10b3750c274 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-05-15 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-05-15-4f1e6359-10010-0 |
e4e2fc0334b851ae30fd13fed8665f7568beda94 | Tenanted farm in Roxburghshire, Scotland, from which rental income is received. | Land and Property 4f1e6359 | 2009-07-21 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-07-21-4f1e6359-10010-0 |
e5f2fc685f261fc9e1f17715fa6fae8945f7d8c8 | Industrial rents (mining) in Lothian, Scotland. | Land and Property 4f1e6359 | 2004-07-16 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 2 | 2004-07-16-4f1e6359-10010-0 |
e664a86c2194a63986358149170e441fb991c67e | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. (Registered 10 October 2005) | Land and Property 4f1e6359 | 2006-02-13 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2006-02-13-4f1e6359-10010-0 |
e767a6584dcba2f15f2073e5b49e84a33d94c9b6 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-10-08 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-10-08-4f1e6359-10010-0 |
e8d30e156d517032835bd62466449fc5b64a4878 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2008-11-05 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2008-11-05-4f1e6359-10010-0 |
e8e7df426c9bd9abd356f5fd49172bd7ac4013d2 | Farms on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2004-01-31 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2004-01-31-4f1e6359-10010-0 |
ea844d47db470f906b2a6a5f784cf94d5dbe09ed | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-07-03 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-07-03-4f1e6359-10010-0 |
eac8502be292b61143421c76a0a458eb0aefe03c | Houses and miscellaneous property on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2003-12-04 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 1 | 2003-12-04-4f1e6359-10010-0 |
edcb11f80c22c15daf1a675b664039f802937e02 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2006-12-11 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2006-12-11-4f1e6359-10010-0 |
ef3309f6ceb0de743ad02f1411edf2f61f56b0de | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2009-01-28 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-01-28-4f1e6359-10010-0 |
f3b6c0d527368c9b4294a9c2c0128e2f53fb1106 | Industrial rents (mining) in Lothian, Scotland. | Land and Property 4f1e6359 | 2005-01-28 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 2 | 2005-01-28-4f1e6359-10010-0 |
f4cbf157c4c53ac55c9dc1ab44ca412b8ef9ecaa | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. (Registered 10 October 2005) | Land and Property 4f1e6359 | 2006-09-19 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2006-09-19-4f1e6359-10010-0 |
f9a58ecff0a22ccb6847c7435366970f40a8df9a | Industrial rents (mining) in Lothian, Scotland. | Land and Property 4f1e6359 | 2004-01-31 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 2 | 2004-01-31-4f1e6359-10010-0 |
fe465ede47347d89b92c86077476d78a537163b5 | Small tenanted agricultural estate in Scottish Borders and Midlothian, from which rental income is received. | Land and Property 4f1e6359 | 2007-06-05 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2007-06-05-4f1e6359-10010-0 |
ff41b2c7df5eca19eb1f07d8017b2cc013087fd0 | Houses and miscellaneous property on Scottish Borders, from which rental income is received. | Land and Property 4f1e6359 | 2004-12-03 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 1 | 2004-12-03-4f1e6359-10010-0 |
1039890cf3842e4457d6d3521f882fba69da4216 | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2009-11-11 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-11-11-5f2cbd10-10010-0 |
1cdbfb43fd34506d20a7f7897e2b68d1dd9b83f5 | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2009-11-25 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-11-25-5f2cbd10-10010-0 |
22402514117bbcba2215eafd5bc1847663172438 | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2009-10-28 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-10-28-5f2cbd10-10010-0 |
23f9c11484ec4b41e36bba535e61740661810649 | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2009-07-21 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-07-21-5f2cbd10-10010-0 |
2727f63834a897eec495e54ab877534292cf0731 | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2010-01-06 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-01-06-5f2cbd10-10010-0 |
5b1341bb9115a57d72b0529c76fb1018667baf4c | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2009-12-10 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-12-10-5f2cbd10-10010-0 |
71ef6905dbf6f1381596a6cff0c78d1f76562576 | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2009-10-14 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-10-14-5f2cbd10-10010-0 |
9e085eab97344f177e40cb2aa2b5eb5f4459be12 | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2010-04-12 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-04-12-5f2cbd10-10010-0 |
c232404b9b6341717d7453efe6bcaec637c9cf18 | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2009-09-02 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2009-09-02-5f2cbd10-10010-0 |
ca7ddc45b17b4eb0562a8cd920e6dc44d07b637e | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2010-02-03 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-02-03-5f2cbd10-10010-0 |
cb54c80761089d38326276aa77dae07f35e244db | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2010-02-24 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-02-24-5f2cbd10-10010-0 |
cc7208d93aa48af1c7095330fdef7907741575a7 | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2010-03-24 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-03-24-5f2cbd10-10010-0 |
e4f23803ea97c81e3b7ae827d60bea7076b1ddbb | Non-active partner in Nisbet Mill Farm partnership from which no payment has been received in the last year and none in the current farming year which starts June 2009. | Miscellaneous 5f2cbd10 | 2010-03-10 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 0 | 2010-03-10-5f2cbd10-10010-0 |
03a245095ffbcaac3b5d9ed7c8756895c21877d0 | 17 June 2007, cost of flight to Syria met by Flying Lion Ltd. (I met all other costs of the visit.) (Registered 17 July 2007) | Overseas visits 80ef1083 | 2007-07-30 | Michael Ancram uk.org.publicwhip/member/1537 | Michael Ancram uk.org.publicwhip/person/10010 | 2 | 2007-07-30-80ef1083-10010-0 |
05fb2b7a13b378421060ec294cfd4633770087e6 | 30 June-2 July 2003, visit to Israel and the Palestinian Authority. Fare paid by Conservative Central Office, hotel accommodation by Government of Israel. (Registered 8 July 2003) | Overseas visits 80ef1083 | 2004-01-31 | Michael Ancram uk.org.publicwhip/member/697 | Michael Ancram uk.org.publicwhip/person/10010 | 2 | 2004-01-31-80ef1083-10010-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");