items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
46 rows where record_id = "2012-10-01-1f359ece-10068-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
495f10c3986c6cac560d3033200feb07f5c5bca2 | Payments as Distinguished Global Leader in Residence at New York University: Campuses in New York, Abu Dhabi and Florence. Hours: ongoing commitment. | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2012-10-01-1f359ece-10068-0 |
fe03d10f25acb73677d273ffb1d9d27359f62a82 | Address: 70 Washington Square South, New York, NY 10012: | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2012-10-01-1f359ece-10068-0 |
9f4c6a64a082b61fd263c2ff396898443597a95c | Airfare paid for my travel to New York campus, value £6,194 (Registered 10 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2012-10-01-1f359ece-10068-0 |
c23e7ae7c7c161c1ac1f7109835007091fc663ce | Payment of £72,806.51, which includes transport and accommodation costs for me and a member of my staff to travel to the New York University Campuses for 2011-12. (Registered 10 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2012-10-01-1f359ece-10068-0 |
42e70ed621ae13ace188d5efbbe889da1c65819f | Airfare paid for my travel to New York University Abu Dhabi campus, value £2,950. Hours: 7 hrs. (Registered 30 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2012-10-01-1f359ece-10068-0 |
abaaea1aca90024a47c85ec816e40f3c7263b1cc | Flights and transport paid for me and my staff; value £6,487.92 to New York campus. Hours: 5.5 hrs. (Registered 16 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2012-10-01-1f359ece-10068-0 |
3e164af9dde54aec2293abf69898c2f4de4155e7 | Flights paid for me and my staff to New York campuses; value £8,845. (Registered 14 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2012-10-01-1f359ece-10068-0 |
f683600771970268281bb6c6f6527d24a0fa3e0e | Transport paid for me and my staff to New York campuses; value £1,598.14. (Registered 3 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2012-10-01-1f359ece-10068-0 |
810da6cb42988b85f9d80e3b6f6d98d50465cd70 | I am not receiving any money from this role personally. It is being held by the Office of Gordon and Sarah Brown for the employment of staff to support my ongoing involvement in public life. | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2012-10-01-1f359ece-10068-0 |
276761bcf8b1a93d754ca988bbb11b214f6b60ea | Payments as Chairman of the World Economic Forum Policy Coordination Group. Address: Route de la Capite 91-93, 1223 Cologny/Geneva: | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2012-10-01-1f359ece-10068-0 |
7cd86846cef50530aaedc11d6e8d6b21808d8a23 | Airfare and accommodation in Dalian, China also paid, £7,001.56. (Registered 10 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 10 | 2012-10-01-1f359ece-10068-0 |
9af9cce68cc332e40e0e2fd9f76fe791e5bd5f0e | Payment for staff and research of £44,166.95 (Registered 10 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2012-10-01-1f359ece-10068-0 |
4a9f7c595f8df3c9f50a198241ea4defbcc5e71b | Airfare and accommodation in Abu Dhabi also paid for me and my staff, £6,442.67 (Registered 30 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 12 | 2012-10-01-1f359ece-10068-0 |
c6571a2e9803a8276eccd8698849167062bdf398 | Payment for staff and research of £43,955.27. (Registered 16 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 13 | 2012-10-01-1f359ece-10068-0 |
1d642d23ddba8956466aa747795d4ca6182a4d02 | Payment for staff and research of £42,059.22 as Chairman of the World Economic Forum Policy Coordination Group. (Registered 17 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 14 | 2012-10-01-1f359ece-10068-0 |
3fad884bd14a48fb6d02d8504343aa4e5b7b4e57 | Airfare and accommodation in Davos also paid for me and my staff; £11,045.92. (Registered 17 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 15 | 2012-10-01-1f359ece-10068-0 |
578ed14530135ff37530ad9996a81c5df3774b1d | Payment for staff and research of £62,500 as Chairman of the World Economic Forum Policy Coordination Group. (Registered 28 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 16 | 2012-10-01-1f359ece-10068-0 |
5cfd6ff9c404195a59f127ed28166701f6fcddd3 | Payment for staff and research of £23,271.91 as Chairman of the World Economic Forum Policy Coordination Group. (Registered 14 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 17 | 2012-10-01-1f359ece-10068-0 |
6d0d133e649e870486aea0bacb15ede4f9bc0c64 | Airfare, transport and accommodation in Addis Ababa, Ethiopia, also paid for me and my staff; £10,950.91. (Registered 3 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 18 | 2012-10-01-1f359ece-10068-0 |
a949dab72bc084d99cc51427681247ad7a855682 | Airfare, transport and accommodation in Geneva, Switzerland, also paid for me and my staff; £2,035.20. (Registered 18 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 19 | 2012-10-01-1f359ece-10068-0 |
678be3a6a64efa2b2c7935765bcbcd46ce08e662 | Payment of £38,292 and £362.70 for train to Washington for speech to Association of Foreign Investors in Real Estate, 1300 Pennsylvania Ave, NW, Washington DC 20004 on 19 September 2011. Hours: 2.5 hrs. I am not receiving any money from this engagement personally. It is being held by the Office of Gordon and Sarah Brown for the employment of staff to support my ongoing involvement in public life. (Registered 10 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 21 | 2012-10-01-1f359ece-10068-0 |
434f9bc7ba69b4d3593587fb6946c6190abba1da | Payment of £62.108.66 for speech to Maeil Business Newspaper, World Knowledge Forum i Seoul , South Korea . Address: Maeil Business Newspaper Media Centre building, 30, 1-ga, Pil-dong, Jung-Ku, Seoul , Korea , 100-728. Hours: Flights and accommodation also paid for me and my staff; value £24,963.09. (Registered 30 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 22 | 2012-10-01-1f359ece-10068-0 |
620d23114f3273c7ab7c5f659fea9144439bc874 | I am not receiving any money from this engagement personally. It is being held by the Office of Gordon and Sarah Brown for the employment of staff to support my ongoing involvement in public life. | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 23 | 2012-10-01-1f359ece-10068-0 |
03458a5b7bfe95671ea42098f59f90aad582b48c | Flight, accommodation and transport paid for me my staff; value £2,196.22, for speech to IDEAS Foundation, Madrid. Address: IDEAS Foundation, Gobelas, 31. 28023 Madrid. Hours: 2 hrs. (Registered 30 November2011) . | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 24 | 2012-10-01-1f359ece-10068-0 |
6988a6547fd14658a1b980cceafd46552a9182ef | Flight and train journey paid for me my staff; value £7,912.56, for speech to Carnegie Council, New York. Address : Carnegie Council, 170 East 64th Street, New York, NY 10021, USA. Hours: 2 hrs. (Registered 30 November 2011) . | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 26 | 2012-10-01-1f359ece-10068-0 |
4aa55fe5891113489f7c8d8b02f62c7e1a506283 | Flight, accommodation and transport paid for me and my staff; value £8,835.16, for speech to United Nations Environment Programme Finance Initiative and Principles for Responsible Investment,Washington. Address: 15 Chemin des Anémones, Geneva, Switzerland. Hours: 3 hrs. (Registered 30 November 2011) . | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 28 | 2012-10-01-1f359ece-10068-0 |
abdc782a3bec373db40f7f3a5bf67b55a2c1e154 | Speech to The New School: New York. Address: The New School, 6 E 16th Street, Room 1022 New York, NY 10011, USA. Hours: 3 hrs. Value of £4,273.04. (Registered 30 November 2011) . I am not receiving any money from this engagement personally. The sum of £4,273.04 was donated to charity upon receipt. | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 30 | 2012-10-01-1f359ece-10068-0 |
296b80503fa61a879b8a70492469df23e8cd0bac | Payment of £49,580.80 for speech to Carlyle Investment Management, in Paris. Address: of Carlyle Investment Management LLC: 1001 Pennsylvania Ave, NW Suite 220 South Washington DC 20004, USA. Hours: 2 hrs. Flights, transport and accommodation also paid for me and my staff; value £1,822.94. (Registered 20 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 31 | 2012-10-01-1f359ece-10068-0 |
f447cb045f9df4e8a371a3bcc4aa9c9535aa3b20 | Payment of £74,936.79 for speech to ANAP Foundation/This Day in Nigeria. Address: Sterling Towers, 7th Floor East Wing, 20 Marina, Lagos, Nigeria. Hours: 4 hrs. Flights and accommodation also paid for me and my staff; value £20,165.91. (Registered 20 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 33 | 2012-10-01-1f359ece-10068-0 |
34505159d8a9e73a89d49cb5bba08abed1876e09 | Payment of £61,637.68 for speech to The Schuette Group/Alfa Bank in Moscow. Address: 1101 30th Street, NW-Suite 500, Washington DC 20007, USA. Hours: 2 hrs. Flights and accommodation also paid for me and my staff: value £5,351.96. (Registered 20 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 35 | 2012-10-01-1f359ece-10068-0 |
e9c428fada7f6810faedc5990f97aa9bbe29c3da | Signature advance of £22,500 from Simon and Schuster UK Ltd, for book to be published in 2012. Address: 222 Grays Inn Road, London WC1X 8HB. Hours: Nil at time of registration. (Registered 20 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 37 | 2012-10-01-1f359ece-10068-0 |
e330e73e59a803704d64df6382d565b4d92f84f2 | Payment of £62,901.91 for speech to Halter Financial in Guangzhou, China. Address of Halter Financial: 12890 Hilltop Road, Argyle, TX 76226, USA. Hours: 5 hrs. Flights and accommodation also paid for me and my staff; value £24,084.20. (Registered 16 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 39 | 2012-10-01-1f359ece-10068-0 |
61774cca9aa6d054ada644b85eb249aaed4b608b | Accommodation and transport paid for me and my staff; value £767.30 for meeting organised by the Chinese People’s Institute for Foreign Affairs, Beijing, China. Address of Chinese People’s Institute for Foreign Affairs: 71 Nanchizi Street, Beijing 100006, China. Hours: 3 hrs. (Registered 16 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 41 | 2012-10-01-1f359ece-10068-0 |
cec8fb7710aa244b1c1545c6d617b80e394003e8 | Flights, accommodation and transport paid for me and my staff; value £7,782.82 for speech to Doha UN Alliance of Civilizations, Doha. Address of Qatar Committee of UNAOC, PO Box 5825, Doha, Qatar. Hours: 1.5 hrs. (Registered 16 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 43 | 2012-10-01-1f359ece-10068-0 |
258b4a2708b27178ec20d5a330d5730285148628 | Flights, accommodation and transport paid for me and my staff; value £4,197.68 for speech to 21st Century Council, Berggruen Institute, Paris. Address of Nicolas Berggruen Institute: 9720 Wilshire Blvd, 6F Beverly Hills, CA 90212. Hours: 2 hrs. (Registered 16 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 45 | 2012-10-01-1f359ece-10068-0 |
c9da96503c457294364420a1a228fe2aa2218706 | Flights, accommodation and transport paid for me and my staff; value £6,645.44 for dinner and speech to World Innovation Summit for Education (WISE), Doha. Address of Qatar Foundation: PO Box 5825, Doha, Qatar. Hours: 4.5 hrs. (Registered 16 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 47 | 2012-10-01-1f359ece-10068-0 |
4a0030c0362bfb94c6555159dc76a28d19ecd95c | Payment of £49,974.26 for speech to Ernst & Young on behalf of Sports Marketing & Entertainment Inc in Davos. Address of SME Inc: 11640 San Vicente Boulevard, Suite 204, Los Angeles, CA 90049, USA. Hours: 2 hrs. Transport also paid for me and my staff; value £624.38. (Registered 17 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 49 | 2012-10-01-1f359ece-10068-0 |
cb978e14e4f2b4e51153e67893810ec682cd5848 | Payment of £61,893.34 for speech to Kuwait Finance House in Kuwait. Address of Kuwait Finance House: PO Box 24989, Safat 13110, Kuwait. Hours: 2 hrs. Flights and accommodation also paid for me and my staff; value £13,016.51. (Registered 17 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 51 | 2012-10-01-1f359ece-10068-0 |
1c8484a40691b36f75e5d0904afdfea1c33bcb88 | Payment of £124, 494.99 for speech to Troika Dialog and Sberbank in Moscow. Address of Troika Diolog and Sberbank: 4 Romanov Pereulok, Moscow, 125009, Russia. Hours: 4 hrs. Flights and accommodation also paid for me and my staff; value £4,018.49. (Registered 17 February 2012; updated 28 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 53 | 2012-10-01-1f359ece-10068-0 |
955d52029f9ab571a57d54a34a0ac0b82f4f5ecd | Payment of £101,412.63 for speeches to MPSF, Inc in California. Address of MPSC Inc: 1229 Burlingame Avenue, #204, Burlingame, CA 94010, USA. Hours: 9.40. Flights, accommodation and transport also paid for me and my staff; value £31,290.39. (Registered 14 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 55 | 2012-10-01-1f359ece-10068-0 |
5d9e86566cbd5b57432788c94a71ffa6032f4f21 | Payment of £335 for flight to University of San Diego in California for speech. Address of University of San Diego: 5998 Alcalá Park, San Diego, CA 92110, USA. Hours: 1 hr. ( Registered 14 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 57 | 2012-10-01-1f359ece-10068-0 |
1a6400320abe5980619ef913e2181f282d2d4b7d | Payment of £49,006.23 for speech to Institute for Corporate Governance in Copenhagen. Address of Institute of Corporate Governance: Olof Palmes Gade 8, Copenhagen, DK-2100, Denmark. Hours: 3 hrs. Flights, accommodation and transport also paid for me and my staff; value £4,729.47. (Registered 14 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 59 | 2012-10-01-1f359ece-10068-0 |
52438f9a40c31e33b953ce31bf63e49fbbd778d5 | Flights and accommodation paid for me and my staff; value £12,470.46 to attend a forum in Mexico City hosted by the Nicolas Berggruen Institute. Address of Nicolas Berggruen Institute: 9720 Wilshire Blvd, 6F Beverly Hills, CA 90212. Hours: 2 days. (Registered 3 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 61 | 2012-10-01-1f359ece-10068-0 |
e5071bb649c3a4a410f43ac2b5230c4ce88532b5 | Payment of £49.497.95 for speech to Itau BBA in New York. Address of Itau BBA: Itau BBA USA, 767 5th Avenue, 50th Floor, New York, NY 10153, USA. Hours: 3 hrs. Flights and transport also paid for me and my staff; value £17,001.91. (Registered 3 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 63 | 2012-10-01-1f359ece-10068-0 |
3ff5fa65b82370262efcf2ccffb882546c4c02bf | Payment of £60,679.90 for speech to the Abu Dhabi Education Council Abu Dhabi. Address of the Abu Dhabi Education Council: PO Box 36005, Abu Dhabi, United Arab Emirates. Hours: 1 hrs. Flights, transport and accommodation also paid for me and my staff; value £14,059.91. (Registered 3 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 65 | 2012-10-01-1f359ece-10068-0 |
821c6c87287f9126a3cd9ecc1f634349df8308c5 | I am not receiving any money from this engagement personally. It is being held by the Office of Gordon and Sarah Brown for the employment of staff to support my ongoing involvement in public life. | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Gordon Brown uk.org.publicwhip/member/40348 | Gordon Brown uk.org.publicwhip/person/10068 | 66 | 2012-10-01-1f359ece-10068-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");