items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
40 rows where person_id = "uk.org.publicwhip/person/10455" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, member_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
d6034eec01ecc4adecd0b32029c60e2f38c983f2 | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2010-02-03 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2010-02-03-80ef1083-10455-0 |
f7aeba4a835ef9ee1336085ce27ca3137b6bd143 | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2010-01-06 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2010-01-06-80ef1083-10455-0 |
1d10872f7b8144e225af15d06e1a86ac2393b5df | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-12-10 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-12-10-80ef1083-10455-0 |
67479319a0441c691938ae62895cfacd76255d2f | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-11-25 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-11-25-80ef1083-10455-0 |
3edfcf1e6b7fa0526ff5feee406438e7a554ba22 | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-11-11 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-11-11-80ef1083-10455-0 |
80b7269d4009331772f730209f86be8c1b1f172a | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-10-28 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-10-28-80ef1083-10455-0 |
92f701927590282970f247ddabea82db52a706fd | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-10-14 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-10-14-80ef1083-10455-0 |
6009a1303aa438b46a5eefde9fafcac99ec55936 | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-09-02 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-09-02-80ef1083-10455-0 |
70f5cf70e1384b83abf578de36ac216486255436 | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-07-21 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-07-21-80ef1083-10455-0 |
03c26ea697278c2f97fd7ce40539306a76f65670 | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-07-08 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-07-08-80ef1083-10455-0 |
6e3a0968aaa08587fb0b53bd2295a9953f6f8653 | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-06-24 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-06-24-80ef1083-10455-0 |
c5bbf5b6646ed0e50be9f714962ecd99232fac2d | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-06-10 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-06-10-80ef1083-10455-0 |
03246d939d05c1de132403d6cd73e916e68dd4fe | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-05-20 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-05-20-80ef1083-10455-0 |
1e33723819776e16d673aa2276ec81a65b5450c5 | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-05-06 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-05-06-80ef1083-10455-0 |
6a9f124223c5b96da9007a3ffbb363f484c5fe93 | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-04-22 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-04-22-80ef1083-10455-0 |
15f507a82877f401e3278d7d8b5c505a34a9fc44 | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-03-25 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-03-25-80ef1083-10455-0 |
7acddf8b1e0299546881077d2c1ea7e2f6dd0ca7 | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-03-11 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-03-11-80ef1083-10455-0 |
a73b0053ea93d25a86a3a5e334987a6abbe5920c | 6-11 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. I also visited localities in the Dakar area to see projects concerned with the prevention and treatment of AIDS, TB and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-02-25 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-02-25-80ef1083-10455-0 |
8a7e644f0478b20b4ace5eee350076f1456efee9 | 6-9 December 2008, to Dakar, Senegal, with the APPG on Global TB to attend an international conference on tuberculosis, AIDS and malaria. The visit was funded by the Global Fund for AIDS, TB and Malaria. (Registered 11 February 2009) | Overseas visits 80ef1083 | 2009-02-11 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2009-02-11-80ef1083-10455-0 |
2cb81d888bbec68bd3a1d12652ba580d3133d117 | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-12-17 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-12-17-80ef1083-10455-0 |
fbbc995b15b89d8fc701c91f2c8717dde2257d98 | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-12-03 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-12-03-80ef1083-10455-0 |
72c0d2b8a8744e0b1f027bbfa97912f922e093f8 | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-11-19 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-11-19-80ef1083-10455-0 |
863a4e9c02df6d80253fa6facc3406cd92e2a346 | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-11-05 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-11-05-80ef1083-10455-0 |
94752f62f89cca3a4481c438198fa03495712f73 | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-10-22 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-10-22-80ef1083-10455-0 |
a30433945c6f394e92d0459df7b565670b2d540a | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-10-08 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-10-08-80ef1083-10455-0 |
4391d93a2a984302b3baa2a947110b19fef8b2d5 | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-09-03 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-09-03-80ef1083-10455-0 |
ab79c8900a32f7ef9319b365fe1d26e6a16d5186 | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-07-22 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-07-22-80ef1083-10455-0 |
b51842442d26dbabe60f72250bb0b81f7a859539 | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-07-08 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-07-08-80ef1083-10455-0 |
19e27f35f71d63a66f473b216d2cdec9c09bf35d | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-06-16 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-06-16-80ef1083-10455-0 |
f12bdffdb57cba57d07dfb923bbba69f1d72803e | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-04-23 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-04-23-80ef1083-10455-0 |
aa90cef472c05dd83c7e8ea1f00927fd4a08c1c0 | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-03-25 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-03-25-80ef1083-10455-0 |
99afb5103e17e9eaabfb49ea302d5015f1cfdc0a | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-03-11 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-03-11-80ef1083-10455-0 |
1831eb7803de9949334c72168c11c2cefcd48b0a | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-02-26 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-02-26-80ef1083-10455-0 |
bedc09a4e7a5d43f0820a429af4eddfb293d179e | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-02-05 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-02-05-80ef1083-10455-0 |
af7b0148038ef2d9f0de706671a06bc45606bad5 | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-01-22 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-01-22-80ef1083-10455-0 |
05a6916a18821e3cc80f8fe734c2c2189d5d142c | 7-11 November 2007, to Cape Town, South Africa, to attend the 38 th World Union Conference on Lung Health, run by the International Union against Tuberculosis and Lung Disease. I also visited townships to see challenges of HIV and MDR in TB prevention and care. Costs of the visit were met by Results-UK. (Registered 19 December 2007) | Overseas visits 80ef1083 | 2008-01-09 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2008-01-09-80ef1083-10455-0 |
5b520681b266170fa2a0449edc373c1bb4608ec7 | 18 January 2005, to Toulouse to attend the Airbus UK celebration of the A380. Return air travel from London to Toulouse paid for by Airbus UK. (Registered 28 January 2005) | Overseas visits 80ef1083 | 2005-12-14 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2005-12-14-80ef1083-10455-0 |
1c1e46cf0058ba7da2f24f9b617890879cdbe995 | 18 January 2005, to Toulouse to attend the Airbus UK celebration of the A380. Return air travel from London to Toulouse paid for by Airbus UK. (Registered 28 January 2005) | Overseas visits 80ef1083 | 2005-11-01 | Doug Naysmith uk.org.publicwhip/member/1456 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2005-11-01-80ef1083-10455-0 |
7b9e93bd942070fb853501e2d3cb4d77abc79b7d | 18 January 2005, to Toulouse to attend the Airbus UK celebration of the A380. Return air travel from London to Toulouse paid for by Airbus UK. (Registered 28 January 2005) | Overseas visits 80ef1083 | 2005-04-11 | Doug Naysmith uk.org.publicwhip/member/1133 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2005-04-11-80ef1083-10455-0 |
8c59d481a36a72fef9534bd0e5553dc60545ac41 | 18 January 2005, to Toulouse to attend the Airbus UK celebration of the A380. Return air travel from London to Toulouse paid for by Airbus UK. (Registered 28 January 2005) | Overseas visits 80ef1083 | 2005-01-28 | Doug Naysmith uk.org.publicwhip/member/1133 | Doug Naysmith uk.org.publicwhip/person/10455 | 0 | 2005-01-28-80ef1083-10455-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");