items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2,043 rows where category_id = "0a4a155f" sorted by date descending
This data as json, CSV (advanced)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0944ef50f668542872ce42c9bf9bcf0ac431630c | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-11-19 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-11-19-0a4a155f-10106-0 |
2970ebf902488eb85e66bc9d1a3b523985fdc379 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-11-19 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-11-19-0a4a155f-10106-0 |
381a7095dc4313b48bf4c743b3c2cf27cc885071 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-11-05 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-11-05-0a4a155f-10106-0 |
7c1f9b08d8db6a5363bbae60c8a402802183cb5c | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-11-05 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-11-05-0a4a155f-10106-0 |
4f137720982f8dd928f59c7ad611f6e9f000d35b | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-10-22 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-10-22-0a4a155f-10106-0 |
f953a58a51a04cfbd148d01d48c2f023ac02a53c | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-10-22 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-10-22-0a4a155f-10106-0 |
5f8ef504c3b47ca108d45e360be82a7dd16cdb9f | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-10-01 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-10-01-0a4a155f-10106-0 |
aec1b74267e55308f8c162eba5b5fc39064f38ce | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-10-01 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-10-01-0a4a155f-10106-0 |
591d87d4b409aaecb9a9fa4ca07587924841a9ad | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-09-03 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-09-03-0a4a155f-10106-0 |
8b9ccebc2c866bd595a440fdbe7e9dafb2568f6d | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-09-03 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-09-03-0a4a155f-10106-0 |
36bee279574d624a22e03cb8349848c3d8adf3aa | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-07-30 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-07-30-0a4a155f-10106-0 |
b7c9cbbd77db693168f2dfa345941860d9978923 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-07-30 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-07-30-0a4a155f-10106-0 |
09497d63a0a4b384d400e08b4b5df6bb0716dac5 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-07-09 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-07-09-0a4a155f-10106-0 |
cfb3fc077b38a09219aaf24cce30e37b136d275f | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-07-09 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-07-09-0a4a155f-10106-0 |
1b95afc8a9a287841997eca02854e89ac242bed9 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-06-25 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-06-25-0a4a155f-10106-0 |
d59252cb7acd971a1bb0aa462ffdcf73b2d65bf6 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-06-25 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-06-25-0a4a155f-10106-0 |
abbafc8b38e98edf6776dffa62e0bc4f9bc42b6a | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-06-11 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-06-11-0a4a155f-10106-0 |
f86b82bc6262d21e404ec0a5e227a54fc48d6539 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-06-11 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-06-11-0a4a155f-10106-0 |
d6c05085f270bea8439882d0e6db0e0cd7606bf3 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-05-14 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-05-14-0a4a155f-10106-0 |
fe46e9d7cbd3260337812a3854e4b431e7bd7655 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-05-14 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-05-14-0a4a155f-10106-0 |
8f182a07b6308b28c663b787ad37ab7e008b7349 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-04-30 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-04-30-0a4a155f-10106-0 |
fe56f2034440efa3394f5bb7cff5ec220311f8dc | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-04-30 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-04-30-0a4a155f-10106-0 |
5ee6a84a3a9d56c508ca17214aa6b44fc2760129 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-04-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-04-16-0a4a155f-10106-0 |
9cf1fb159b214418f522016b025dbf843d5f080c | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-04-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-04-16-0a4a155f-10106-0 |
4c2c4115c833936c83fb14e60879c24aefc41cd2 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-03-19 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-03-19-0a4a155f-10106-0 |
80f60471715493c3aab1fa8c7407e4ec9422bbf6 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-03-19 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-03-19-0a4a155f-10106-0 |
75007b7ed55db1f2cdc625cd82a3a1f239e0055c | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-03-05 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-03-05-0a4a155f-10106-0 |
852c2e3661000582e5ef2cb6dcb8d9083ff56947 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-03-05 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-03-05-0a4a155f-10106-0 |
78ad55369052391595125e8b5cda69d57f110a01 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-02-20 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-02-20-0a4a155f-10106-0 |
7c067f7cb62e5d75b72938fa42b44dccd47e0436 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-02-20 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-02-20-0a4a155f-10106-0 |
063c5cba12ba17793abd45689d0da6508ba6c158 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-01-30 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-01-30-0a4a155f-10106-0 |
de7dc53bc213f5605657fa5edbad9306ef14a85b | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-01-30 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-01-30-0a4a155f-10106-0 |
a43df544725c6f13027c024c67a5ac364ad01fec | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2012-01-13 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2012-01-13-0a4a155f-10106-0 |
ecce87c0fb2354ddf15245bc2127aa1cc1440472 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2012-01-13 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2012-01-13-0a4a155f-10106-0 |
3457cb774f70a065a936342fd5ecc2d75e6847c8 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-12-13 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-12-13-0a4a155f-10106-0 |
4bc7b41cbabf06e8e71805d1c5c60587fb3d4a2e | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-12-13 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-12-13-0a4a155f-10013-0 |
58ddabaa57f98f2c638a302f32deb4f058c9bd9e | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-12-13 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-12-13-0a4a155f-10106-0 |
bc64bd8d0261c4f470469808ca63cee7fb71a272 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-12-13 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-12-13-0a4a155f-10013-0 |
2d6a6845dab1b0613eb46185f5e784dcec7e3b43 | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-11-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-11-29-0a4a155f-10013-0 |
848d066cefc45a5b30c4f798177bee036fdb4f78 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-11-29 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-11-29-0a4a155f-10106-0 |
8dd470dc14213794fc534d2aca13a4a9f20fdcf2 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-11-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-11-29-0a4a155f-10013-0 |
aedece6df500cdb334e8b083afed665b6fa6df38 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-11-29 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-11-29-0a4a155f-10106-0 |
0389fc0f0377ba83fa6a35ab13063782c6bcf91b | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-11-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-11-16-0a4a155f-10106-0 |
7fe40e6789944eed23c92c5e7c822274baea0051 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-11-16 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-11-16-0a4a155f-10013-0 |
84d0cf204df1c49f7303af77695c40017c7398ff | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-11-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-11-16-0a4a155f-10106-0 |
fda34654d47d25d598189d83db9ec2a65960ee88 | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-11-16 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-11-16-0a4a155f-10013-0 |
12df6a9553d1ecd417ee3fc89315c30b5862b2a9 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-10-31 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-10-31-0a4a155f-10106-0 |
364e62da66c7c581ad38f72c2086a329914591f7 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-10-31 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-10-31-0a4a155f-10013-0 |
3cb00b57d22a6d53061ee04888fab1b3a0b3f6a1 | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-10-31 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-10-31-0a4a155f-10013-0 |
7f430c238eea777d1338329ddced364e741fec60 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-10-31 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-10-31-0a4a155f-10106-0 |
0cd3a5b7a2109c884db7f3ca8b0c984e8a80a4df | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-10-17 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-10-17-0a4a155f-10106-0 |
9cf660b535c27796c05774064a6aa11b6d283168 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-10-17 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-10-17-0a4a155f-10013-0 |
bc49012ce97a4526233c0b5711912280cfa8c10e | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-10-17 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-10-17-0a4a155f-10013-0 |
bd51fd3724fd36464c626543a372b7de0717fecc | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-10-17 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-10-17-0a4a155f-10106-0 |
733bc41ad797aa0095eadf150c673385320102b8 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-09-28 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-09-28-0a4a155f-10106-0 |
7a1d6bd969f5ef1d401696bb95a55118a8ea8f8e | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-09-28 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-09-28-0a4a155f-10106-0 |
ddb789cf5cdd127d54f25317cac42683ae814e3d | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-09-28 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-09-28-0a4a155f-10013-0 |
e61cf43385596b8e6662c4aa2fdb7f55e00a9083 | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-09-28 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-09-28-0a4a155f-10013-0 |
3d017be27bd5d8adafddc8e79f05234441b81b43 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-08-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-08-30-0a4a155f-10013-0 |
632b63a231ffc2ae081d82c219955ebfa9436eb8 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-08-30 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-08-30-0a4a155f-10106-0 |
7ad600d1a088f8a9aeae45e0542f3bed08473f37 | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-08-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-08-30-0a4a155f-10013-0 |
c814722aea8782e037b4ebe6a5b79c39b6175ef7 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-08-30 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-08-30-0a4a155f-10106-0 |
1a10264eef6801cf7a0dbc75bf046a1373df3c8e | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-07-19 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-07-19-0a4a155f-10013-0 |
271aa04e0e84700d364a35f6808a46e5875f3a7f | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-07-19 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-07-19-0a4a155f-10106-0 |
77b60e099947dffe79a12cae7f3ac7a99a8aff32 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-07-19 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-07-19-0a4a155f-10013-0 |
a4adb92ef1b16cc53ac81993a48f9877c1c4e08a | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-07-19 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-07-19-0a4a155f-10106-0 |
5b55c82a538c3280e7ffdb00f257c8ec43a432cd | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-07-06 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-07-06-0a4a155f-10106-0 |
7a79a2e7a4c71aefbeb978e3731f630e3ee4e4f9 | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-07-06 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-07-06-0a4a155f-10013-0 |
85f72e95a787a326e4e754dcfbdb32a8338edb7d | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-07-06 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-07-06-0a4a155f-10013-0 |
9ac0c44ea6537991bda69d6c758af045604a416d | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-07-06 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-07-06-0a4a155f-10106-0 |
4b87413795ab983f2e79f5932e5084a1cc1b3096 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-06-20 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-06-20-0a4a155f-10106-0 |
8ce0812d48d9b37f783076a84b37a44237af9075 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-06-20 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-06-20-0a4a155f-10013-0 |
944f3432523ae5dcac11a52c76f58a4b1a9461e4 | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-06-20 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-06-20-0a4a155f-10013-0 |
c6faf186e64959e908607d744b650093aefa80ab | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-06-20 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-06-20-0a4a155f-10106-0 |
5ca069026fc43dedaab69e51717c7a4067941b2f | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-06-06 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-06-06-0a4a155f-10013-0 |
9c218ea31d724a744f6729fcedb6d24663b986ed | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-06-06 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-06-06-0a4a155f-10013-0 |
a27a408068273cc574342618829899ea86dd4fab | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-06-06 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-06-06-0a4a155f-10106-0 |
aeaa2a0f143884fee0a072b78b78a34764862898 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-06-06 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-06-06-0a4a155f-10106-0 |
71e7164a4f4b07ba9dc344b61f534cfc0e51a00e | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-05-16 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-05-16-0a4a155f-10013-0 |
d099ca836625e60f3c4db07952511057e70b24df | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-05-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-05-16-0a4a155f-10106-0 |
e05b57bd18c6dbb7c5fd99edee25d7d0f5b1d920 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-05-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-05-16-0a4a155f-10106-0 |
f115472188bbdbb971a3a2fa9ae16ee133c59f9e | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-05-16 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-05-16-0a4a155f-10013-0 |
141bf76623a70618a51c4b44e289e701dc47ea23 | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-05-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-05-03-0a4a155f-10013-0 |
36aa5a0fe3d8f2aa68d5d3c34e4baae1674fb32d | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-05-03 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-05-03-0a4a155f-10106-0 |
443610bdfc84b65cea2d6ac9b10fa191034f00e4 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-05-03 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-05-03-0a4a155f-10106-0 |
6ce7d7b7208e0ad4c4fe1894fe1841ce72686469 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-05-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-05-03-0a4a155f-10013-0 |
2a7d205f6605c28fcba7aeeee487a27ae0032d00 | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-04-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-04-18-0a4a155f-10013-0 |
96e1ee5e5f178e74b854366b88dbdf81a214cfa9 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-04-18 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-04-18-0a4a155f-10106-0 |
f7a2a27e62f7f5d4ed7b51b0feb38ff235e20723 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-04-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-04-18-0a4a155f-10013-0 |
fdb073c5edf838132d67e79fef4c9b42218845f7 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-04-18 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-04-18-0a4a155f-10106-0 |
0ca312588ff70ed0f6f0c1f1e9d646b999480a85 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2011-03-28 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2011-03-28-0a4a155f-10106-0 |
0e94670473b9706b19e0e265d66e590dcef5f0be | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2011-03-28 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2011-03-28-0a4a155f-10106-0 |
d40c51615748c6de007e4118a295b16667e64196 | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-03-28 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-03-28-0a4a155f-10013-0 |
df0ef5a7f2cc98ecfbc44b69e82dfc3715d78b8e | Received a tie (value £5) for giving a speech on 22 March 2010. Hours: 2.5 hrs. Address of payer: The Royal Aeronautical Society, 4 Hamilton Place, London W1J 7BQ. (Registered 6 April 2010) | Remunerated employment, office, profession etc. 0a4a155f | 2011-03-28 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 2 | 2011-03-28-0a4a155f-10013-0 |
f8e37dd1b2c587225c7c967348ead2704a0ff0b0 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-03-28 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-03-28-0a4a155f-10013-0 |
1488bde0045cfbb32fd4e66c8214f7f5bbc318d6 | Date of visit: 20-25 February 2011 | Remunerated employment, office, profession etc. 0a4a155f | 2011-03-14 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 8 | 2011-03-14-0a4a155f-10013-0 |
2c67015213429830c61eefca2a6157d367b82c88 | Received a tie (value £5) for giving a speech on 22 March 2010. Hours: 2.5 hrs. Address of payer: The Royal Aeronautical Society, 4 Hamilton Place, London W1J 7BQ. (Registered 6 April 2010) | Remunerated employment, office, profession etc. 0a4a155f | 2011-03-14 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 2 | 2011-03-14-0a4a155f-10013-0 |
400ef8000190741ec99159bb136ee0545860db12 | Member of Lloyd's (resigned as from 31 December 2002). | Remunerated employment, office, profession etc. 0a4a155f | 2011-03-14 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-03-14-0a4a155f-10013-0 |
45e9af71a184ca8be82f773e3c78818d19811663 | Categories of business underwritten until resignation - CBS Private Capital Ltd.: All categories. | Remunerated employment, office, profession etc. 0a4a155f | 2011-03-14 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-03-14-0a4a155f-10013-0 |
67e0c8e5eeecd84b61f7a7dbc3e782f6cdaf341f | Destination of visit: Israel | Remunerated employment, office, profession etc. 0a4a155f | 2011-03-14 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 7 | 2011-03-14-0a4a155f-10013-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");