items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
156 rows where person_id = "uk.org.publicwhip/person/10020" sorted by person_id
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id ▼ | sort_order | record_id |
---|---|---|---|---|---|---|---|
888fc877be2bc7ca71c70b18da6922d5b9c640f2 | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-03-25 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-03-25-1f359ece-10020-0 |
88d2f9ee4cbbc3a5f1682b8ebb2701111a03d65a | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2004-09-08 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2004-09-08-1f359ece-10020-0 |
8a4a8293427d84da02e8ddd28ab1b713c2f2111a | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-01-09 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-01-09-1f359ece-10020-0 |
8d5875e3be2b1090e4ade88fb9c4a09c65b5c9bc | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2004-12-03 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2004-12-03-1f359ece-10020-0 |
8eae838797dad6b53559c34da7fecdda642c9d84 | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-06-16 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-06-16-1f359ece-10020-0 |
8fdd48c4f79b9c13734bf2f317c4e4fd785f769f | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2006-06-21-9e46def6-10020-0 |
95fd1fad6ec24a2f85febbddcc9956e8121702cb | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2009-03-25 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2009-03-25-9e46def6-10020-0 |
96f87d8179ac13d7b95a9129832f77f4262e2903 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2008-01-09 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-01-09-9e46def6-10020-0 |
991c2c7b3e966c1da12f0afd6f271d9d94637e49 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2002-11-26 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2002-11-26-9e46def6-10020-0 |
9f3923a75db7acc9081ad844bae13ea4cc53fb05 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2009-05-20 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2009-05-20-9e46def6-10020-0 |
a3ac555aa7a607e49b4b61037b253dad48298336 | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2007-02-27 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-02-27-1f359ece-10020-0 |
a4a02ee31ff2ee4f683e502d7f047654a0f963c8 | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-07-08 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-07-08-1f359ece-10020-0 |
a4acdf22e0302a4a76f092f92a9e5df733163fd7 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2007-01-23 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-01-23-9e46def6-10020-0 |
a5a43b81d8c692d7081fcd95be426daab3e920df | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2007-01-09 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-01-09-9e46def6-10020-0 |
a67bc6134f031afc3ac3dbe0164e12efa95fdd25 | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Peter Atkinson uk.org.publicwhip/member/20 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2000-11-10-1f359ece-10020-0 |
a6823dd2c50ab5569075ee21d3788dec4a400955 | House in Newcastle upon Tyne. | Land and Property 4f1e6359 | 2003-12-04 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2003-12-04-4f1e6359-10020-0 |
a8ab7748bccbb24af45843039ec0268eebb204f5 | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2004-05-21-1f359ece-10020-0 |
ab236124fc699bf295a83721f9cd0b19972e63e6 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2006-02-13-9e46def6-10020-0 |
ade13572cf64913001e2900bb6a7d72df1776493 | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2005-04-11-1f359ece-10020-0 |
b0cb2d4024710a0bb40bb7b825ccfd493039f0f4 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2004-12-03 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2004-12-03-9e46def6-10020-0 |
b17d02add6150af4a747ecc2cf4a6cef51f3f354 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2004-01-31 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2004-01-31-9e46def6-10020-0 |
b1ad0d03458844a8bf7c008f9e73e5a471d132ae | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-10-08 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-10-08-1f359ece-10020-0 |
b5eddd29fee192b92ccd49b9b0b21e786dbfb552 | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2007-01-23 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-01-23-1f359ece-10020-0 |
b88185b3f714d414f37b3ae7bbf9cbc12d16f77c | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2006-02-14-9e46def6-10020-0 |
b9124792940509cf7cc2fc8d44b2383bca3ea894 | Member of the political opinion panel of BPRI (Business Planning and Research International). (£1-£1,000). The fees received are paid directly to Hexham Conservative Association. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Peter Atkinson uk.org.publicwhip/member/20 | Peter Atkinson uk.org.publicwhip/person/10020 | 2 | 2000-11-10-1f359ece-10020-0 |
bb5aed1e904aa6c9f39f0dd16dbfd80244360d39 | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2007-11-20 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-11-20-1f359ece-10020-0 |
bceb0cb1375d6f41fb630b4b4ac3bbf01528b6ec | Occasional research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2000-11-10 | Peter Atkinson uk.org.publicwhip/member/20 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2000-11-10-9e46def6-10020-0 |
bde7837ee09ce6ff8090fdf9585315abab94142b | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2007-06-19 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-06-19-9e46def6-10020-0 |
be8db649e4f315c88cda96e9aeabbf49ac5c1939 | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-12-17 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-12-17-1f359ece-10020-0 |
c51dbfcfdeb15fb76ba374dd3b292aaa2999fbac | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2008-12-17 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-12-17-9e46def6-10020-0 |
c5684c457f4cb67b7038c4e4f38aab9035216576 | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-06-10 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2009-06-10-1f359ece-10020-0 |
c8d28a6c5b423afee61c7f46801eb0441291c43a | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2007-12-04 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-12-04-9e46def6-10020-0 |
ca6076a3e5ce0d8ca9484afc3d676145321f1e17 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2008-04-23 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-04-23-9e46def6-10020-0 |
ccdd59f6981ddb3dcc937894254c34562998e8df | Freelance journalism. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Peter Atkinson uk.org.publicwhip/member/20 | Peter Atkinson uk.org.publicwhip/person/10020 | 1 | 2000-11-10-1f359ece-10020-0 |
cd41299f6c670ed2c13ec643cf5515f5cc2813bf | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-12-03 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-12-03-1f359ece-10020-0 |
cd6239df6f25898057fbeaac9a1f7c29da757ff8 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2005-11-01-9e46def6-10020-0 |
cdf82a968d2226a962d517a2c5297bd23e19d14a | Freelance journalism. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Peter Atkinson uk.org.publicwhip/member/20 | Peter Atkinson uk.org.publicwhip/person/10020 | 1 | 2001-05-14-1f359ece-10020-0 |
d13ef36007b925c96af24cd4a4431d6e22c3e14a | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2002-11-26-1f359ece-10020-0 |
d1b45c654ebd8cbc7903b0f74b4c49ea88eb3ffa | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2006-11-06 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2006-11-06-1f359ece-10020-0 |
d449e3e802394be3906d4c77f5c895219366f5f5 | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2007-12-04 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-12-04-1f359ece-10020-0 |
d917e56c6ab58ee1088be497c1922f7f2e418fbb | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2007-05-15 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-05-15-9e46def6-10020-0 |
de55386340d1b3e02a01c93ed9a83739447accac | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2006-12-11-1f359ece-10020-0 |
df08bf52cc31535963670f832cc8275a529f34ae | Member of the political opinion panel of BPRI (Business Planning and Research International). (£1-£1,000). The fees received are paid directly to Hexham Conservative Association. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 2 | 2002-05-14-1f359ece-10020-0 |
df5e3dbe9539e7b4796583cf3807e63c428f4966 | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2005-12-14 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2005-12-14-1f359ece-10020-0 |
e122645b96d93d2fd6d398654401e394aec348e5 | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-03-11 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2009-03-11-1f359ece-10020-0 |
e20889dc9471d148542aa69aa879fabaf3c6f973 | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2007-03-26 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-03-26-1f359ece-10020-0 |
e4fb16f9018ec9e889504da75119b9f1f84f989c | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2004-10-22-1f359ece-10020-0 |
e51e1ed4dc29087368cea5e11fae1a5668d6e747 | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-05-06 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2009-05-06-1f359ece-10020-0 |
e730a1063beb9c1fed1806c92148b5172327db32 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2006-11-06 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2006-11-06-9e46def6-10020-0 |
ef9aba18a890ae7dd7b6e076644ec6df37e26c9a | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2005-12-14-9e46def6-10020-0 |
ef9e4974b83be11289a31f126ccde89e2b9cf393 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-02-27-9e46def6-10020-0 |
f212f8890d1762aef4618a2e93eca6e5b6d73bfe | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-04-23 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-04-23-1f359ece-10020-0 |
f2563d59f95e4668f9357df01231f2a81c58a11a | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2007-02-06 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-02-06-9e46def6-10020-0 |
f2a9cb308441864d07e5432f6fbd5cccb6eafb9a | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2004-01-31 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2004-01-31-1f359ece-10020-0 |
f32c74fa885603677f19da93d91433d229ffe695 | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Peter Atkinson uk.org.publicwhip/member/705 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2002-05-14-1f359ece-10020-0 |
f47b7c289cc5bc2375f95ecf720d25771eae10bb | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2008-07-08 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-07-08-9e46def6-10020-0 |
f56fa310aba38156eb046008520f9964b2d63547 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2006-09-19 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2006-09-19-9e46def6-10020-0 |
f75e59934a835b39f958f15cb62c665633ec2e1a | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2009-05-06 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2009-05-06-9e46def6-10020-0 |
f9347021029b8322e6103c08b9223bac85d9b1f9 | Research work provided by Countryside Alliance. | Sponsorship or financial or material support 9e46def6 | 2007-08-28 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2007-08-28-9e46def6-10020-0 |
fb18688fb60981cbf838fc795fa5bfb497c14a1b | Parliamentary and public affairs consultant, Countryside Alliance. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-11-19 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2008-11-19-1f359ece-10020-0 |
fd4476919266d6384fef2f4964101ad6dd149fd4 | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2006-07-25 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2006-07-25-1f359ece-10020-0 |
fd540e40a099de22001267706808dd44888ce31b | Parliamentary and public affairs consultant, Countryside Alliance. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2006-03-24 | Peter Atkinson uk.org.publicwhip/member/1635 | Peter Atkinson uk.org.publicwhip/person/10020 | 0 | 2006-03-24-1f359ece-10020-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");