items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
632 rows where person_id = "uk.org.publicwhip/person/10685" sorted by category_id descending
This data as json, CSV (advanced)
Suggested facets: category_id, member_id, sort_order, date (date)
hash | item | category_id ▲ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
fd9444eb3a3004dbd9e36fce8446c5a9d11021af | Donations to the Anne Speirs Memorial Trust, created to benefit the Labour Party at local elections in my constituency, from: | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2005-11-01-9e46def6-10685-0 |
982a927d5463409f3c06d09d11d0b7ef488bdd7d | Mr Speirs (personal donation from constituent) | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2005-11-01-9e46def6-10685-0 |
835eac6d61666e82db2e65f54d6122d2dc31404f | Mr and Mrs Fitzpatrick (donation from constituents) | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2005-11-01-9e46def6-10685-0 |
eaf2b0d1aa097ff42478cf8586bfd0f3c9f6cbf5 | (Registered 27 October 2005) | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 3 | 2005-11-01-9e46def6-10685-0 |
a004d34a24760b581920356064cdcf99a48ff9e5 | Support from Camelon Labour Club. | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 4 | 2005-11-01-9e46def6-10685-0 |
01bdde25dcea0d92ee469cf7d1a23ec8c9041b45 | Donations to the Anne Speirs Memorial Trust, created to benefit the Labour Party at local elections in my constituency, from: | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2005-12-14-9e46def6-10685-0 |
86e6ca818c6d07f5b644aa0810491256bfc9ce0d | Mr Speirs (personal donation from constituent) | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2005-12-14-9e46def6-10685-0 |
1e6a9c4167c742be5e5d16d5908b434c0a8aa310 | Mr and Mrs Fitzpatrick (donation from constituents) | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2005-12-14-9e46def6-10685-0 |
3633cb140d307b06e76eb8ece347b04ac952e7d2 | (Registered 27 October 2005) | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 3 | 2005-12-14-9e46def6-10685-0 |
e12e1a556ad27a09bf35fbb7bfcce17c8bf213fa | Support from Camelon Labour Club. | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 4 | 2005-12-14-9e46def6-10685-0 |
49c84ffb0ae7ad019ad70b3595556163a016e04a | Donations to the Anne Speirs Memorial Trust, created to benefit the Labour Party at local elections in my constituency, from: | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-02-13-9e46def6-10685-0 |
2d493f508c67c6a2de791624472f47484b26e9ea | Mr Speirs (personal donation from constituent) | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-02-13-9e46def6-10685-0 |
d2ab36e23fbe27d2ff7f5d82019545c6b91c9594 | Mr and Mrs Fitzpatrick (donation from constituents) | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2006-02-13-9e46def6-10685-0 |
ff8cf88035f6abbee396f934432b0ae26388a43b | (Registered 27 October 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 3 | 2006-02-13-9e46def6-10685-0 |
20f1f99410d47843edb6e3bde91514df545669a1 | Support from Camelon Labour Club. | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 4 | 2006-02-13-9e46def6-10685-0 |
1a7fcf70341aa48148694db4f6b2cfc481fd6c47 | Donations to the Anne Speirs Memorial Trust, created to benefit the Labour Party at local elections in my constituency, from: | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-02-14-9e46def6-10685-0 |
ce55c138ba6cd3943e84cb5f34fcf6be5a4c9b1b | Mr Speirs (personal donation from constituent) | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-02-14-9e46def6-10685-0 |
7176f38184111b058b771cd0a1d92e74fd7233ca | Mr and Mrs Fitzpatrick (donation from constituents) | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2006-02-14-9e46def6-10685-0 |
37ea988abcb6c3eafb1aa751713bcc9dc1fa5859 | (Registered 27 October 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 3 | 2006-02-14-9e46def6-10685-0 |
153b8268a5ddc0794f6e8a4da0313646e1ff2a6f | Support from Camelon Labour Club. | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 4 | 2006-02-14-9e46def6-10685-0 |
5e7118d979f5e1ed7ca04a1b51e8354c4786e31d | Donations to the Anne Speirs Memorial Trust, created to benefit the Labour Party at local elections in my constituency, from: | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-03-24-9e46def6-10685-0 |
aedecf7acfa27af83532269f1fa59df3b366134b | Mr Speirs (personal donation from constituent) | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-03-24-9e46def6-10685-0 |
086ade94baa60abc2466c27da3d78bb2d1ae74ad | Mr and Mrs Fitzpatrick (donation from constituents) | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2006-03-24-9e46def6-10685-0 |
1f100ce9930fef500707617ec943abd0fd855d78 | (Registered 27 October 2005) | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 3 | 2006-03-24-9e46def6-10685-0 |
2d1cfd9b8171768018ab00b36dcc121eecc2754f | Support from Camelon Labour Club. | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 4 | 2006-03-24-9e46def6-10685-0 |
c496fc74c6d76ed16ab986d1cc0937fba8476d0d | Donations to the Anne Speirs Memorial Trust, created to benefit the Labour Party at local elections in my constituency, from: | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-05-12-9e46def6-10685-0 |
f8e2a64b44a73ab0fd587b51980a4557793d5f60 | Mr Speirs (personal donation from constituent) | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-05-12-9e46def6-10685-0 |
62f2a157ba1c0e5cd7dc99c44d94f39bb0b72cd6 | Mr and Mrs Fitzpatrick (donation from constituents) | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2006-05-12-9e46def6-10685-0 |
18c7f0b78b5d69219940a4fe46f91bd5cd28282b | (Registered 27 October 2005) | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 3 | 2006-05-12-9e46def6-10685-0 |
3b68c0057467970817c9a8ed0b79c979d8c36fd4 | Support from Camelon Labour Club. | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 4 | 2006-05-12-9e46def6-10685-0 |
8caa22646db9356089591b2bd60f408274911faf | Donations to the Anne Speirs Memorial Trust, created to benefit the Labour Party at local elections in my constituency, from: | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-06-21-9e46def6-10685-0 |
3b2df4889922b935941c70fac335cd206d8fe16b | Mr Speirs (personal donation from constituent) | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-06-21-9e46def6-10685-0 |
47550bb116257630d2effd57c2e6eb88d556170a | Mr and Mrs Fitzpatrick (donation from constituents) | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2006-06-21-9e46def6-10685-0 |
93006b082ed3ccfd663d908a85d42695a0b66dd6 | (Registered 27 October 2005) | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 3 | 2006-06-21-9e46def6-10685-0 |
d9938e546b2fd3dcaacf960c94cd63c44b80e71a | Support from Camelon Labour Club. | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 4 | 2006-06-21-9e46def6-10685-0 |
9478fc61a24c865712eb9ae31a4017e104530826 | Donations to the Anne Speirs Memorial Trust, created to benefit the Labour Party at local elections in my constituency, from: | Sponsorship or financial or material support 9e46def6 | 2006-07-25 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-07-25-9e46def6-10685-0 |
5c85bb8b382253f9ec27d9b2ba75f1ff060db50a | Mr Speirs (personal donation from constituent) | Sponsorship or financial or material support 9e46def6 | 2006-07-25 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-07-25-9e46def6-10685-0 |
9c4b1ea637348a74ab5ffd8175fc827cf1cae098 | Mr and Mrs Fitzpatrick (donation from constituents) | Sponsorship or financial or material support 9e46def6 | 2006-07-25 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2006-07-25-9e46def6-10685-0 |
aade25237b399b7ec618d84818f401176752af30 | (Registered 27 October 2005) | Sponsorship or financial or material support 9e46def6 | 2006-07-25 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 3 | 2006-07-25-9e46def6-10685-0 |
a0540e4e25ce2c7f334d19d0c223f9411966cb39 | Support from Camelon Labour Club. | Sponsorship or financial or material support 9e46def6 | 2006-07-25 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 4 | 2006-07-25-9e46def6-10685-0 |
76036def63c0f2c1b25f2600488340caee3ef158 | Donations to the Anne Speirs Memorial Trust, created to benefit the Labour Party at local elections in my constituency, from: | Sponsorship or financial or material support 9e46def6 | 2006-09-19 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-09-19-9e46def6-10685-0 |
bdb15113a686e748d303a457b4bf8d515f59dd4b | Mr Speirs (personal donation from constituent) | Sponsorship or financial or material support 9e46def6 | 2006-09-19 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-09-19-9e46def6-10685-0 |
2719ba94faad8251f3a52534319024f7d9abaf9b | Mr and Mrs Fitzpatrick (donation from constituents) | Sponsorship or financial or material support 9e46def6 | 2006-09-19 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2006-09-19-9e46def6-10685-0 |
1966abe8e0d0cb7b19424297ca8fa2064b756644 | (Registered 27 October 2005) | Sponsorship or financial or material support 9e46def6 | 2006-09-19 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 3 | 2006-09-19-9e46def6-10685-0 |
18bc9b4159455175e212ab96f91559e171bdb1f5 | Support from Camelon Labour Club. | Sponsorship or financial or material support 9e46def6 | 2006-09-19 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 4 | 2006-09-19-9e46def6-10685-0 |
1f61f28b758462c94df39045bb46ea56ce4f2811 | 10-14 February 2008, to Kurdistan Region in Iraq, with the All-Party Parliamentary Group on the Kurdistan Region in Iraq, as a guest of the Kurdistan Regional Government (KRG). The cost of my flights, internal travel and accommodation was borne by the KRG. (Registered 22 February 2008) | Sponsorship or financial or material support 9e46def6 | 2008-02-26 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2008-02-26-9e46def6-10685-0 |
c5fc86de91bb6a825f6425656a47ece18a0e5c76 | 10-14 February 2008, to Kurdistan Region in Iraq, with the All-Party Parliamentary Group on the Kurdistan Region in Iraq, as a guest of the Kurdistan Regional Government (KRG). The cost of my flights, internal travel and accommodation was borne by the KRG. (Registered 22 February 2008) | Sponsorship or financial or material support 9e46def6 | 2008-03-11 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2008-03-11-9e46def6-10685-0 |
89dcfa27a9bdf27804326f494795c7c8c86fbfeb | 10-14 February 2008, to Kurdistan Region in Iraq, with the All-Party Parliamentary Group on the Kurdistan Region in Iraq, as a guest of the Kurdistan Regional Government (KRG). The cost of my flights, internal travel and accommodation was borne by the KRG. (Registered 22 February 2008) | Sponsorship or financial or material support 9e46def6 | 2008-03-25 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2008-03-25-9e46def6-10685-0 |
535e3fe5b3d1412c2a53b389c3f4ca7eeab5f95b | 19-21 February 2008, to Brasilia, Brazil, to attend a conference organised by GLOBE, a group of legislators from the G8+5 climate change dialogue. Hotel and travel costs paid by the promoters of GLOBE. (Registered 18 March 2008) | Sponsorship or financial or material support 9e46def6 | 2008-03-25 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2008-03-25-9e46def6-10685-0 |
49cd6bbb4cc5e4908fe002e2e64f72f0122dcd6b | 10-14 February 2008, to Kurdistan Region in Iraq, with the All-Party Parliamentary Group on the Kurdistan Region in Iraq, as a guest of the Kurdistan Regional Government (KRG). The cost of my flights, internal travel and accommodation was borne by the KRG. (Registered 22 February 2008) | Sponsorship or financial or material support 9e46def6 | 2008-04-23 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2008-04-23-9e46def6-10685-0 |
f0eac3458feba5bc5d1dca5318eaa5e67003be82 | 19-21 February 2008, to Brasilia, Brazil, to attend a conference organised by GLOBE, a group of legislators from the G8+5 climate change dialogue. Hotel and travel costs paid by the promoters of GLOBE. (Registered 18 March 2008) | Sponsorship or financial or material support 9e46def6 | 2008-04-23 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2008-04-23-9e46def6-10685-0 |
96e1921a0311db373d29375a29da95e489ec5e7c | 10-14 February 2008, to Kurdistan Region in Iraq, with the All-Party Parliamentary Group on the Kurdistan Region in Iraq, as a guest of the Kurdistan Regional Government (KRG). The cost of my flights, internal travel and accommodation was borne by the KRG. (Registered 22 February 2008) | Sponsorship or financial or material support 9e46def6 | 2008-06-16 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2008-06-16-9e46def6-10685-0 |
f6e64cf82e609befef09f476419a00cfdf045106 | 19-21 February 2008, to Brasilia, Brazil, to attend a conference organised by GLOBE, a group of legislators from the G8+5 climate change dialogue. Hotel and travel costs paid by the promoters of GLOBE. (Registered 18 March 2008) | Sponsorship or financial or material support 9e46def6 | 2008-06-16 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2008-06-16-9e46def6-10685-0 |
4d039d3eb3c40daa73c2e0554e7d276c0ab939ce | 13-19 April 2008, to the Democratic Republic of Congo (DRC), with the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention. The costs of my flights, internal travel and accommodation were borne by charities Christian Aid, Worldvision, International Alert and the Catholic Agency for Overseas Development. (Registered 29 May 2008) | Sponsorship or financial or material support 9e46def6 | 2008-06-16 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2008-06-16-9e46def6-10685-0 |
b50729681b56463b9c6c3aef7b6477c32de910ca | 8-12 May 2008, to Baghdad, as a guest of the Islamic Dawa Party, to get update from Ministers on situation on the ground. The cost of travel and accommodation was borne by the Islamic Dawa Party. (Registered 6 June 2008) | Sponsorship or financial or material support 9e46def6 | 2008-06-16 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 3 | 2008-06-16-9e46def6-10685-0 |
1a41e900921bfb6e2468146c89d665d643f7f45b | 10-14 February 2008, to Kurdistan Region in Iraq, with the All-Party Parliamentary Group on the Kurdistan Region in Iraq, as a guest of the Kurdistan Regional Government (KRG). The cost of my flights, internal travel and accommodation was borne by the KRG. (Registered 22 February 2008) | Sponsorship or financial or material support 9e46def6 | 2008-07-08 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2008-07-08-9e46def6-10685-0 |
ac56992255fd1ed9109d70f07117e83aebf1bdf0 | 19-21 February 2008, to Brasilia, Brazil, to attend a conference organised by GLOBE, a group of legislators from the G8+5 climate change dialogue. Hotel and travel costs paid by the promoters of GLOBE. (Registered 18 March 2008) | Sponsorship or financial or material support 9e46def6 | 2008-07-08 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2008-07-08-9e46def6-10685-0 |
062804d013170b6270587f482bb45a63661fd364 | 13-19 April 2008, to the Democratic Republic of Congo (DRC), with the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention. The costs of my flights, internal travel and accommodation were borne by charities Christian Aid, Worldvision, International Alert and the Catholic Agency for Overseas Development. (Registered 29 May 2008) | Sponsorship or financial or material support 9e46def6 | 2008-07-08 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2008-07-08-9e46def6-10685-0 |
ccde0f5e186e6dee943498fa279cf70a2c87ae81 | 8-12 May 2008, to Baghdad, as a guest of the Islamic Dawa Party, to get update from Ministers on situation on the ground. The cost of travel and accommodation was borne by the Islamic Dawa Party. (Registered 6 June 2008) | Sponsorship or financial or material support 9e46def6 | 2008-07-08 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 3 | 2008-07-08-9e46def6-10685-0 |
0881fcf09f5988fe0725eb7ce9ed04a69aa52b24 | December 2000, I received a gift of a table lamp from the Camelon Labour Club in Falkirk, following my election. (Registered 20 March 2001) | Gifts, benefits and hospitality (UK) 84642823 | 2001-05-14 | Eric Joyce uk.org.publicwhip/member/685 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2001-05-14-84642823-10685-0 |
27c437b7a85c567d50973d1cf08b19b71f118aa1 | 10-11 September 2001, visit to the offshore Triton Floating Production in the North Sea as a guest of Amerada Hess, who paid for my overnight hotel accommodation in Aberdeen and helicopter flight to the platform. (Registered 27 September 2001) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2002-05-14-84642823-10685-0 |
1c260b9ddccc2fb0259a51f8f284f299018e15cd | 1-7 August 2001, to Democratic Republic of Congo, with All-Party Group on Rwanda, Great Lakes Region and Prevention of Genocide. Travel, accommodation and associated hospitality funded by the charities Oxfam, Christian Aid, Save the Children and Tearfund. (Registered 15 August 2001) | Overseas visits 80ef1083 | 2002-05-14 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2002-05-14-80ef1083-10685-0 |
97c3ae7467acde13dc27bf92cbdbd2bda602971e | 23-25 April 2002, to Gabon, Africa, to attend conference. Flight to Libreville and one night's hotel accommodation paid for by the Association of West European Parliamentarians for Africa. (Registered 18 July 2002) | Overseas visits 80ef1083 | 2002-11-26 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2002-11-26-80ef1083-10685-0 |
3fa7d441b65ec1372b37b1a6d1c3e031bcac638e | 4 August-1 September 2002, study tour of Buenos Aires, Detroit and Shanghai, funded by the Norfolk Charitable Trust. The Trust provided accommodation and subsistence at a briefing weekend in Norfolk (13-14 July 2002), and economy class flights to the cities, accommodation in business hotels in each city and a daily subsistence allowance. (Registered 10 September 2002) | Overseas visits 80ef1083 | 2002-11-26 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2002-11-26-80ef1083-10685-0 |
435114dc3be0d661d337609b83fe1f9ce5b61abe | 18-23 January 2004, to Israel to meet members of the Israeli Government and Palestinian Authority and others. All travel, accommodation and subsistence was funded by Labour Friends of Israel and the Israeli Foreign Ministry. (Registered 21 July 2004) | Overseas visits 80ef1083 | 2004-09-08 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2004-09-08-80ef1083-10685-0 |
ac4fc906a32540180ad31a5c0423b5c3e62d687d | 12-15 May 2004, to Turkey, funded by the Turkish Government Party, who provided travel in Turkey (excluding internal flights) and accommodation in Ankara and Istanbul for the duration of the visit. (Travel to and from and within Turkey paid by Members' European Travel Scheme administered by the House of Commons Department of Finance and Administration.) (Registered 21 July 2004) | Overseas visits 80ef1083 | 2004-09-08 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2004-09-08-80ef1083-10685-0 |
1eeedcdab8c52fdac6e2daba50df4d6ec8234e05 | 18-23 January 2004, to Israel to meet members of the Israeli Government and Palestinian Authority and others. All travel, accommodation and subsistence was funded by Labour Friends of Israel and the Israeli Foreign Ministry. (Registered 21 July 2004) | Overseas visits 80ef1083 | 2004-10-22 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2004-10-22-80ef1083-10685-0 |
8a6a17d13b3a7f608784cffa99916df45279272d | 12-15 May 2004, to Turkey, funded by the Turkish Government Party, who provided travel in Turkey (excluding internal flights) and accommodation in Ankara and Istanbul for the duration of the visit. (Travel to and from and within Turkey paid by Members' European Travel Scheme administered by the House of Commons Department of Finance and Administration.) (Registered 21 July 2004) | Overseas visits 80ef1083 | 2004-10-22 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2004-10-22-80ef1083-10685-0 |
fed52e0efa33e092082e980ed26f687788cf124f | 18-23 January 2004, to Israel to meet members of the Israeli Government and Palestinian Authority and others. All travel, accommodation and subsistence was funded by Labour Friends of Israel and the Israeli Foreign Ministry. (Registered 21 July 2004) | Overseas visits 80ef1083 | 2004-12-03 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2004-12-03-80ef1083-10685-0 |
f3808272942dbc00f45938d82944d3b58db15078 | 12-15 May 2004, to Turkey, funded by the Turkish Government Party, who provided travel in Turkey (excluding internal flights) and accommodation in Ankara and Istanbul for the duration of the visit. (Travel to and from and within Turkey paid by Members' European Travel Scheme administered by the House of Commons Department of Finance and Administration.) (Registered 21 July 2004) | Overseas visits 80ef1083 | 2004-12-03 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2004-12-03-80ef1083-10685-0 |
dc05494d8e58ce30fe6c385626f9ec4ddf09f4f9 | 18-23 January 2004, to Israel to meet members of the Israeli Government and Palestinian Authority and others. All travel, accommodation and subsistence was funded by Labour Friends of Israel and the Israeli Foreign Ministry. (Registered 21 July 2004) | Overseas visits 80ef1083 | 2005-01-28 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2005-01-28-80ef1083-10685-0 |
d50f593e4bdb2268e0072f541fc29f2ce0de195d | 12-15 May 2004, to Turkey, funded by the Turkish Government Party, who provided travel in Turkey (excluding internal flights) and accommodation in Ankara and Istanbul for the duration of the visit. (Travel to and from and within Turkey paid by Members' European Travel Scheme administered by the House of Commons Department of Finance and Administration.) (Registered 21 July 2004) | Overseas visits 80ef1083 | 2005-01-28 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2005-01-28-80ef1083-10685-0 |
11a24c57e8b3a18068b0b53a37f0aa4496df9cf9 | 18-23 January 2004, to Israel to meet members of the Israeli Government and Palestinian Authority and others. All travel, accommodation and subsistence was funded by Labour Friends of Israel and the Israeli Foreign Ministry. (Registered 21 July 2004) | Overseas visits 80ef1083 | 2005-04-11 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2005-04-11-80ef1083-10685-0 |
120a6622c859cfaacc7cd05508d1dec6aac30480 | 12-15 May 2004, to Turkey, funded by the Turkish Government Party, who provided travel in Turkey (excluding internal flights) and accommodation in Ankara and Istanbul for the duration of the visit. (Travel to and from and within Turkey paid by Members' European Travel Scheme administered by the House of Commons Department of Finance and Administration.) (Registered 21 July 2004) | Overseas visits 80ef1083 | 2005-04-11 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2005-04-11-80ef1083-10685-0 |
11ee5abf5eb129c7e8e72c4de4362f14c05e630d | 5-22 December 2004, to United States, to participate in United States International Visitors' Programme. Internal travel between Washington DC and New York via various cities, and a per diem allowance to cover accommodation and subsistence, provided by the US State Department. (I paid for my own external flights.) (Registered 16 February 2005) | Overseas visits 80ef1083 | 2005-04-11 | Eric Joyce uk.org.publicwhip/member/1008 | Eric Joyce uk.org.publicwhip/person/10685 | 2 | 2005-04-11-80ef1083-10685-0 |
c7585871ad239721dd8e0f71bd1af5e4de072e31 | 5-22 December 2004, to United States, to participate in United States International Visitors' Programme. Internal travel between Washington DC and New York via various cities, and a per diem allowance to cover accommodation and subsistence, provided by the US State Department. (I paid for my own external flights.) (Registered 16 February 2005) | Overseas visits 80ef1083 | 2005-11-01 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2005-11-01-80ef1083-10685-0 |
6bbe60de4516e371770a44223941a9cb68103e60 | 18-21 September 2005, to Kuwait with All-Party Parliamentary Kuwait Group. Return flights London to Kuwait City and accommodation paid for by the Kuwait Government. (Registered 26 October 2005) | Overseas visits 80ef1083 | 2005-11-01 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2005-11-01-80ef1083-10685-0 |
7da93a89b2be1034501eadf5894942b889456098 | 5-22 December 2004, to United States, to participate in United States International Visitors' Programme. Internal travel between Washington DC and New York via various cities, and a per diem allowance to cover accommodation and subsistence, provided by the US State Department. (I paid for my own external flights.) (Registered 16 February 2005) | Overseas visits 80ef1083 | 2005-12-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2005-12-14-80ef1083-10685-0 |
52fab013266531f8cfa9b2a425bc3ed741728e5a | 18-21 September 2005, to Kuwait with All-Party Parliamentary Kuwait Group. Return flights London to Kuwait City and accommodation paid for by the Kuwait Government. (Registered 26 October 2005) | Overseas visits 80ef1083 | 2005-12-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2005-12-14-80ef1083-10685-0 |
63cb65a7fb339b64b728483d496c304e411f0fc7 | 5-22 December 2004, to United States, to participate in United States International Visitors' Programme. Internal travel between Washington DC and New York via various cities, and a per diem allowance to cover accommodation and subsistence, provided by the US State Department. (I paid for my own external flights.) (Registered 16 February 2005) | Overseas visits 80ef1083 | 2006-02-13 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-02-13-80ef1083-10685-0 |
4bf8a805edd63094dfcc0df5c1e0e10c85bc3bdf | 18-21 September 2005, to Kuwait with All-Party Parliamentary Kuwait Group. Return flights London to Kuwait City and accommodation paid for by the Kuwait Government. (Registered 26 October 2005) | Overseas visits 80ef1083 | 2006-02-13 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-02-13-80ef1083-10685-0 |
6df0262185ce6ae9bda6d016183c8cd4d8c8c715 | 5-22 December 2004, to United States, to participate in United States International Visitors' Programme. Internal travel between Washington DC and New York via various cities, and a per diem allowance to cover accommodation and subsistence, provided by the US State Department. (I paid for my own external flights.) (Registered 16 February 2005) | Overseas visits 80ef1083 | 2006-02-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-02-14-80ef1083-10685-0 |
647383f9b21a29aa8043d532f9f68f6928348d60 | 18-21 September 2005, to Kuwait with All-Party Parliamentary Kuwait Group. Return flights London to Kuwait City and accommodation paid for by the Kuwait Government. (Registered 26 October 2005) | Overseas visits 80ef1083 | 2006-02-14 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-02-14-80ef1083-10685-0 |
42100d64c21c51d737348d275e788842659a4c0b | 18-21 September 2005, to Kuwait with All-Party Parliamentary Kuwait Group. Return flights London to Kuwait City and accommodation paid for by the Kuwait Government. (Registered 26 October 2005) | Overseas visits 80ef1083 | 2006-03-24 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-03-24-80ef1083-10685-0 |
56472ed5b33aca7be1b9486d05b058b96fde0d0a | 18-21 September 2005, to Kuwait with All-Party Parliamentary Kuwait Group. Return flights London to Kuwait City and accommodation paid for by the Kuwait Government. (Registered 26 October 2005) | Overseas visits 80ef1083 | 2006-05-12 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-05-12-80ef1083-10685-0 |
be07d95beebbc65cf6951b61a0c18d22d108b5b3 | 1-8 April 2006, to Rwanda and the Democratic Republic of Congo, on a visit of the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention. External and internal flights, accommodation, food and expenses covered by the APPG, who received funding for the visit from Save the Children, Christian Aid, Tearfund, the Rainforest Foundation, CAFOD, Amnesty International and Airserv. Sky TV accompanied the trip and contributed to the cost of the air charter and The Independent newspaper made a contribution to cover the costs of their correspondent who accompanied the visit. (Registered 20 April 2006) | Overseas visits 80ef1083 | 2006-05-12 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-05-12-80ef1083-10685-0 |
16c480fab32fef76138599feaf66f589164be743 | 18-21 September 2005, to Kuwait with All-Party Parliamentary Kuwait Group. Return flights London to Kuwait City and accommodation paid for by the Kuwait Government. (Registered 26 October 2005) | Overseas visits 80ef1083 | 2006-06-21 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-06-21-80ef1083-10685-0 |
fb32769e5c24b7cc7c4713ecc5e648955cb4400a | 1-8 April 2006, to Rwanda and the Democratic Republic of Congo, on a visit of the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention. External and internal flights, accommodation, food and expenses covered by the APPG, who received funding for the visit from Save the Children, Christian Aid, Tearfund, the Rainforest Foundation, CAFOD, Amnesty International and Airserv. Sky TV accompanied the trip and contributed to the cost of the air charter and The Independent newspaper made a contribution to cover the costs of their correspondent who accompanied the visit. (Registered 20 April 2006) | Overseas visits 80ef1083 | 2006-06-21 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-06-21-80ef1083-10685-0 |
122d40601e9139424bcead16846a5090cc8d4ec5 | 18-21 September 2005, to Kuwait with All-Party Parliamentary Kuwait Group. Return flights London to Kuwait City and accommodation paid for by the Kuwait Government. (Registered 26 October 2005) | Overseas visits 80ef1083 | 2006-07-25 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-07-25-80ef1083-10685-0 |
1cdeb4e8744566c417e280f79831603abb5eac6b | 1-8 April 2006, to Rwanda and the Democratic Republic of Congo, on a visit of the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention. External and internal flights, accommodation, food and expenses covered by the APPG, who received funding for the visit from Save the Children, Christian Aid, Tearfund, the Rainforest Foundation, CAFOD, Amnesty International and Airserv. Sky TV accompanied the trip and contributed to the cost of the air charter and The Independent newspaper made a contribution to cover the costs of their correspondent who accompanied the visit. (Registered 20 April 2006) | Overseas visits 80ef1083 | 2006-07-25 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-07-25-80ef1083-10685-0 |
7b19d057eac6c601ba082877242ef6a69e8a6985 | 18-21 September 2005, to Kuwait with All-Party Parliamentary Kuwait Group. Return flights London to Kuwait City and accommodation paid for by the Kuwait Government. (Registered 26 October 2005) | Overseas visits 80ef1083 | 2006-09-19 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-09-19-80ef1083-10685-0 |
6f76fbe3938e0210fae062f6f6b82e91bec7d3c1 | 1-8 April 2006, to Rwanda and the Democratic Republic of Congo, on a visit of the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention. External and internal flights, accommodation, food and expenses covered by the APPG, who received funding for the visit from Save the Children, Christian Aid, Tearfund, the Rainforest Foundation, CAFOD, Amnesty International and Airserv. Sky TV accompanied the trip and contributed to the cost of the air charter and The Independent newspaper made a contribution to cover the costs of their correspondent who accompanied the visit. (Registered 20 April 2006) | Overseas visits 80ef1083 | 2006-09-19 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-09-19-80ef1083-10685-0 |
f58de39aa462af238592f0b4a7f1480e49fbcd52 | 1-8 April 2006, to Rwanda and the Democratic Republic of Congo, on a visit of the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention. External and internal flights, accommodation, food and expenses covered by the APPG, who received funding for the visit from Save the Children, Christian Aid, Tearfund, the Rainforest Foundation, CAFOD, Amnesty International and Airserv. Sky TV accompanied the trip and contributed to the cost of the air charter and The Independent newspaper made a contribution to cover the costs of their correspondent who accompanied the visit. (Registered 20 April 2006) | Overseas visits 80ef1083 | 2006-11-06 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-11-06-80ef1083-10685-0 |
6d69efa49f0fc964db3cff77e0300863a638f557 | 25-26 October 2006, to Basle, Switzerland, to Worlddidac 2006 Conference and exhibition. Return flights, in-country travel, meals and accommodation paid for by the British Educational Suppliers Association. (Registered 1 November 2006) | Overseas visits 80ef1083 | 2006-11-06 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-11-06-80ef1083-10685-0 |
d609593a44cadb42d6b59f96f7b84b37ea4606c9 | 1-8 April 2006, to Rwanda and the Democratic Republic of Congo, on a visit of the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention. External and internal flights, accommodation, food and expenses covered by the APPG, who received funding for the visit from Save the Children, Christian Aid, Tearfund, the Rainforest Foundation, CAFOD, Amnesty International and Airserv. Sky TV accompanied the trip and contributed to the cost of the air charter and The Independent newspaper made a contribution to cover the costs of their correspondent who accompanied the visit. (Registered 20 April 2006) | Overseas visits 80ef1083 | 2006-11-27 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-11-27-80ef1083-10685-0 |
3e3056f133fd4fbe456551380a0643c185107641 | 25-26 October 2006, to Basle, Switzerland, to Worlddidac 2006 Conference and exhibition. Return flights, in-country travel, meals and accommodation paid for by the British Educational Suppliers Association. (Registered 1 November 2006) | Overseas visits 80ef1083 | 2006-11-27 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-11-27-80ef1083-10685-0 |
014753cb2b63ce9a9b26b0bf8c77f76d196272b4 | 1-8 April 2006, to Rwanda and the Democratic Republic of Congo, on a visit of the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention. External and internal flights, accommodation, food and expenses covered by the APPG, who received funding for the visit from Save the Children, Christian Aid, Tearfund, the Rainforest Foundation, CAFOD, Amnesty International and Airserv. Sky TV accompanied the trip and contributed to the cost of the air charter and The Independent newspaper made a contribution to cover the costs of their correspondent who accompanied the visit. (Registered 20 April 2006) | Overseas visits 80ef1083 | 2006-12-11 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2006-12-11-80ef1083-10685-0 |
668db44faf5623ab8e598491c55726610075e3de | 25-26 October 2006, to Basle, Switzerland, to Worlddidac 2006 Conference and exhibition. Return flights, in-country travel, meals and accommodation paid for by the British Educational Suppliers Association. (Registered 1 November 2006) | Overseas visits 80ef1083 | 2006-12-11 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2006-12-11-80ef1083-10685-0 |
9fb6d9ba1b6d75690b3ba458e7429b2bcd1f65a8 | 1-8 April 2006, to Rwanda and the Democratic Republic of Congo, on a visit of the All-Party Parliamentary Group on the Great Lakes Region and Genocide Prevention. External and internal flights, accommodation, food and expenses covered by the APPG, who received funding for the visit from Save the Children, Christian Aid, Tearfund, the Rainforest Foundation, CAFOD, Amnesty International and Airserv. Sky TV accompanied the trip and contributed to the cost of the air charter and The Independent newspaper made a contribution to cover the costs of their correspondent who accompanied the visit. (Registered 20 April 2006) | Overseas visits 80ef1083 | 2007-01-09 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 0 | 2007-01-09-80ef1083-10685-0 |
3d99ef935affe567e3042399a4f113b08a337c25 | 25-26 October 2006, to Basle, Switzerland, to Worlddidac 2006 Conference and exhibition. Return flights, in-country travel, meals and accommodation paid for by the British Educational Suppliers Association. (Registered 1 November 2006) | Overseas visits 80ef1083 | 2007-01-09 | Eric Joyce uk.org.publicwhip/member/1983 | Eric Joyce uk.org.publicwhip/person/10685 | 1 | 2007-01-09-80ef1083-10685-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");