items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
71 rows where record_id = "2014-10-13-8f616a6e-24930-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 |
---|---|---|---|---|---|---|---|
116b3a336189f2dd8dd92a76d0e7cbc4d2d0e193 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 0 | 2014-10-13-8f616a6e-24930-0 |
6771c18e688fce71fce32e72f127fd247eb2ac9f | Address of donor: 24 Old Queen Street, London SW1H 9HP | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 2 | 2014-10-13-8f616a6e-24930-0 |
a92f0d0b3f6acaa8239911acacc1f202434f7966 | Donor status: company, registration 457188 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 4 | 2014-10-13-8f616a6e-24930-0 |
cd004e53f5d759f6ad168e275a34c3d52b4169ed | (Registered 2 June 2014) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 5 | 2014-10-13-8f616a6e-24930-0 |
5dabcada4c3381ef3fde28540ba4ebc091d20512 | Name of donor: The Association of Conservative Clubs Ltd | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 6 | 2014-10-13-8f616a6e-24930-0 |
d4fa8d4c54d1ac0089f016374e35ff726a0237d9 | Address of donor: 24 Old Queen Street, London, SW1H 9HP | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 7 | 2014-10-13-8f616a6e-24930-0 |
884e5fcf4d29e7466f071584d08d1c1976e2d06b | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 8 | 2014-10-13-8f616a6e-24930-0 |
e3689c9d69c4b93708fde2af35621010f17b5e85 | Donor status: limited company, registration no 457188 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 9 | 2014-10-13-8f616a6e-24930-0 |
5a92e6c374c42b022cc208e0f450fb0c3b411199 | (Registered 14 July 2014) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 10 | 2014-10-13-8f616a6e-24930-0 |
d261ce55887e6a0ba59ba99b0897dd7a9998c743 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 11 | 2014-10-13-8f616a6e-24930-0 |
97c157bb80b38c1ec3a34c07d0146c6ef8576707 | Amount of donation (or estimate of the probable value): £9,000 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 14 | 2014-10-13-8f616a6e-24930-0 |
d9b9ccd899569aba86f37ffdb52bd63f98f9240d | Date of receipt: 4 October 2013 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 15 | 2014-10-13-8f616a6e-24930-0 |
7f128e2f5e9e618acb581f33f6ebc9279ea8889b | Date of acceptance: 4 October 2013 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 16 | 2014-10-13-8f616a6e-24930-0 |
d0a4aebc455f3fb95dc91ce4459617930e0e84a5 | Donor status: members’ association. During 2013 Timothy Sanderson and Britt Shaw have each given more than £1,500 to this association | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 17 | 2014-10-13-8f616a6e-24930-0 |
139efa96ddf84e35f258be3eec06e8ba61be0680 | (Registered 9 October 2013) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 18 | 2014-10-13-8f616a6e-24930-0 |
7c6db5181586827f9ca1a021711bcebc8a2026e9 | Date of receipt: 25 October 2013 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 22 | 2014-10-13-8f616a6e-24930-0 |
e8151f1846933161383fb07a9d54aa25ad61c80d | Date of acceptance: 25 October 2013 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 23 | 2014-10-13-8f616a6e-24930-0 |
80c1ccb48e38ab9286e57670281c5743cf1cbab8 | (Registered 30 October 2013) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 25 | 2014-10-13-8f616a6e-24930-0 |
3cf776807645cd77e1b5b8d24509b2ebd1cbb7f2 | Amount of donation: £10,000 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 28 | 2014-10-13-8f616a6e-24930-0 |
ce70759796289503ee5011a0f892f84187e941a0 | Date of receipt of donation: 11 November 2013 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 29 | 2014-10-13-8f616a6e-24930-0 |
ded8b3d5b0ad41dff20076670cb9286a60824a19 | Date of acceptance of donation: 11 November 2013 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 30 | 2014-10-13-8f616a6e-24930-0 |
1614dd0c6438d78eee3a626f79c40adfd4b6cae6 | (Registered 12 November 2013) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 32 | 2014-10-13-8f616a6e-24930-0 |
734a2dfee37956be8d3d9cb8a72f1d4f2fb4697a | Name of donor: Alex Howard | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 33 | 2014-10-13-8f616a6e-24930-0 |
0ba34c5de975003e0b8240e9e207c2ebf64c1801 | Date of receipt: 2 January 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 36 | 2014-10-13-8f616a6e-24930-0 |
a24c0d6928564b074c85087d984667f2bf2ed1ff | Date of acceptance: 2 January 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 37 | 2014-10-13-8f616a6e-24930-0 |
c33c20d48317e4b129eebc7b48c1528b80f3382e | (Registered 13 January 2014) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 39 | 2014-10-13-8f616a6e-24930-0 |
b9095f56ad22481947a04bf3b6e4b808054e1b91 | Name of donor: Graham Robb | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 40 | 2014-10-13-8f616a6e-24930-0 |
8c6a514959d1bbe8ea6ad97a6c345aa6d263eb16 | Amount of donation or nature and value if donation in kind: £1,500 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 42 | 2014-10-13-8f616a6e-24930-0 |
7c80424f14518005c9171db3e116b77f8bcb5a9a | Date of receipt: 5 February 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 43 | 2014-10-13-8f616a6e-24930-0 |
4783ef93233f60e927faaa71bc0cf5dfb2012e1c | Date of acceptance: 5 February 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 44 | 2014-10-13-8f616a6e-24930-0 |
d6fdce30b054dd768e5443caf1ee6d7e3883c001 | (Registered 7 February 2014) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 46 | 2014-10-13-8f616a6e-24930-0 |
16bb1c80d876f0b8d070c88a70f7632202cffee6 | Date of receipt: 10 February 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 50 | 2014-10-13-8f616a6e-24930-0 |
000853efe22ea366062831b45d1aec8bd11324ec | Date of acceptance: 10 February 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 51 | 2014-10-13-8f616a6e-24930-0 |
e02084bb1ac9f0a34dc78090c67f82f9b674e92f | (Registered 11 February 2014) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 53 | 2014-10-13-8f616a6e-24930-0 |
ec55756560b35cb792eb76163da0eb13cffe7341 | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 54 | 2014-10-13-8f616a6e-24930-0 |
a0114741544677640a22ccffcf593ebabc2a7833 | Address of donor: 18 Thorney Lane North, Iver, Bucks SL0 9JY | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 55 | 2014-10-13-8f616a6e-24930-0 |
8d6025c64c555e3fe53b0b69b4463cc4f93d5ce9 | Amount of donation (or estimate of the probable value): £5,000 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 56 | 2014-10-13-8f616a6e-24930-0 |
8e9451079ff1199cd611bd22153eb1448de8f863 | Date of receipt: 12 February 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 57 | 2014-10-13-8f616a6e-24930-0 |
7a514e9402fc2c044f73d37885939439fef47684 | Date of acceptance: 12 February 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 58 | 2014-10-13-8f616a6e-24930-0 |
1587054e3d4ca7e69c2a6f20c4a2688799e6abc6 | Donor status: members’ association. | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 59 | 2014-10-13-8f616a6e-24930-0 |
b01e2740e51b7247fd2f90c219c9747cfaad4818 | (Registered 19 February 2014) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 60 | 2014-10-13-8f616a6e-24930-0 |
0167bb6891b386c70b6de8f89a99a8389ecb64ce | Name of donor: Sir John Hall | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 61 | 2014-10-13-8f616a6e-24930-0 |
ab5c8cbb36ea34f82176e6a35cd64b9a2f5a8ebd | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 63 | 2014-10-13-8f616a6e-24930-0 |
f7d6a623046f2756acc683f8b26ead39b1ee19e9 | Date of receipt: 19 February 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 64 | 2014-10-13-8f616a6e-24930-0 |
e3503d7df56a2aabb15830dc76b0df3b2865cb5d | Date of acceptance: 19 February 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 65 | 2014-10-13-8f616a6e-24930-0 |
ce74ce8ec71bc5e2e2e399bd04c5515342a969bd | (Registered 26 February 2014) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 67 | 2014-10-13-8f616a6e-24930-0 |
0ca5b3852b25d660e279a61e6a913a161ef572c9 | Name of donor: Mr Alexander Temerko | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 68 | 2014-10-13-8f616a6e-24930-0 |
0b2185f1ac0593c41324da58b54218cc2f0cfefa | Amount of donation: £5,000 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 70 | 2014-10-13-8f616a6e-24930-0 |
7497f863edac35bdab415101341e245895b4a383 | Date of receipt of donation: 17 March 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 71 | 2014-10-13-8f616a6e-24930-0 |
9542bc6e454848e00ad5fd3c45811b9b9686b790 | Date of acceptance of donation: 17 March 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 72 | 2014-10-13-8f616a6e-24930-0 |
48d2a22658884f1bfee12c6c5a5692ae4f315b9f | (Registered 18 March 2014) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 74 | 2014-10-13-8f616a6e-24930-0 |
e88acef5dd1828c4702300d016d129c6d112b803 | Name of donor: Peter Cruddas | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 75 | 2014-10-13-8f616a6e-24930-0 |
9b5b80f3f9e1ecf49b90cb5691dea36d0805f03b | Address of donor: private | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 76 | 2014-10-13-8f616a6e-24930-0 |
59c640d56b14d2d54acb0fbc05a753770dd624f9 | Date of receipt: 2 July 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 78 | 2014-10-13-8f616a6e-24930-0 |
0c2591c8bde5c825d3f066e5ec3c5b919996b660 | Date of acceptance: 2 July 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 79 | 2014-10-13-8f616a6e-24930-0 |
4625f04374aabe717781832cf08889d21ef54b6d | Donor status: individual | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 80 | 2014-10-13-8f616a6e-24930-0 |
0f5980a2d8af7718722c9d5e1930cbb4ef46d0e3 | (Registered 4 July 2014) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 81 | 2014-10-13-8f616a6e-24930-0 |
7059dbc8cd24fed9a31d4f01c9e3118254ca06e9 | Name of donor: JCB research | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 82 | 2014-10-13-8f616a6e-24930-0 |
449a9dec025fc2b7265e0dd944d3b7ad00309b8c | Address of donor: Lakeside Works, Denstone Road, Uttoxeter, ST14 5JP | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 83 | 2014-10-13-8f616a6e-24930-0 |
0f5ef44507db6ab2482c09366fdba1809672f767 | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 84 | 2014-10-13-8f616a6e-24930-0 |
83b5c79017c532f39e3017df6f3770f65d46503c | Date of receipt: 4 July 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 85 | 2014-10-13-8f616a6e-24930-0 |
a6e08f97b0178e915ff48fb495906e3389bcee49 | Date of acceptance: 4 July 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 86 | 2014-10-13-8f616a6e-24930-0 |
e7d7226cae88c3edafc5750d8fbbec55f0d4b3df | Donor status: company, registration no 00682651 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 87 | 2014-10-13-8f616a6e-24930-0 |
3508575148439bfa6f7118ac0d3c25650cff6ee3 | (Registered 10 July 2014) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 88 | 2014-10-13-8f616a6e-24930-0 |
ad749b68bf8c3fd177fd0bc5879c67c34c6cec1f | Name of donor: IPGL Ltd | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 89 | 2014-10-13-8f616a6e-24930-0 |
d47ec83dd0d04db1be246e7dc80afd1b5aeb0d83 | Address of donor: Park House, 16 Finsbury Circus, London EC2M 7EB | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 90 | 2014-10-13-8f616a6e-24930-0 |
9c519769462ffa59f6ddf625cc3d6ffdc3f1a8a6 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 91 | 2014-10-13-8f616a6e-24930-0 |
c3cf8cf1af64853ededa493c12587f04c7858095 | Date of receipt: 22 July 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 92 | 2014-10-13-8f616a6e-24930-0 |
25b5fc31b09de97f2c7f798420783051b415af5a | Date of acceptance: 22 July 2014 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 93 | 2014-10-13-8f616a6e-24930-0 |
e283d90829c5050ee19f3871fda94ec42a8e2b8e | Donor status: company, 02011009 | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 94 | 2014-10-13-8f616a6e-24930-0 |
28e7209a10c10dc4461ab94d03857e6b0c5a3b3d | (Registered 24 July 2014) | Sponsorships 8f616a6e | 2014-10-13 | James Wharton uk.org.publicwhip/member/40580 | James Wharton uk.org.publicwhip/person/24930 | 95 | 2014-10-13-8f616a6e-24930-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");