items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where category_id = "1f359ece" and person_id = "uk.org.publicwhip/person/10078" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: item, date, member_id, sort_order, record_id, date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
c2cd4500deebba8a26eccb677ff6c8470b26cfb8 | I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2002-05-14-1f359ece-10078-0 |
1adb3673d16c92807b714c362da497f897939b36 | I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2002-11-26-1f359ece-10078-0 |
a767aedb1a4139157e82ae12e708845e5e6983f4 | I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2003-12-04 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2003-12-04-1f359ece-10078-0 |
27087c0c8bca6bd192593ed06a65c3a2a0a506c9 | I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2004-01-31 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-01-31-1f359ece-10078-0 |
1449458fc06d626311cf1e32f7f4284ccff0d7f3 | I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-05-21-1f359ece-10078-0 |
c0b5e45744a7c027b6ede60f3a3cd79601a45b90 | I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2004-07-16 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-07-16-1f359ece-10078-0 |
5983e55ea03bed2c15fca38269e95d5157d3a3dd | I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2004-09-08 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-09-08-1f359ece-10078-0 |
820b29a23c49ea638576f70ce6bfd0c1198e3716 | I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-10-22-1f359ece-10078-0 |
fe788a63f25661d0b7a61df702a75134a174d1d6 | I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2004-12-03 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2004-12-03-1f359ece-10078-0 |
b96aff09e0d1f0bfb6ad5679f3b1041db88793a9 | I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2005-04-11-1f359ece-10078-0 |
4d3274b83ee56f185b6e17d6d865fa29231cf087 | Senior partner of Burd Pearse, Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | John Burnett uk.org.publicwhip/member/78 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2000-11-10-1f359ece-10078-0 |
92eb2ad91bf9a573d69b91598ec28d8f14b24055 | Partner of A. Craig-Mooney, Solicitors of Tavistock. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | John Burnett uk.org.publicwhip/member/78 | John Burnett uk.org.publicwhip/person/10078 | 1 | 2000-11-10-1f359ece-10078-0 |
753f01275f9d350cdafe39d23d92b4618a86d0db | Farmer. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | John Burnett uk.org.publicwhip/member/78 | John Burnett uk.org.publicwhip/person/10078 | 2 | 2000-11-10-1f359ece-10078-0 |
ce0bd12be2223632cd359eadca67462a2c414b9e | Senior partner of Burd Pearse, Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | John Burnett uk.org.publicwhip/member/78 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2001-05-14-1f359ece-10078-0 |
557f1133e3b1ef31c6a081ef1eba84c64b6cb4b0 | Partner of A. Craig-Mooney, Solicitors of Tavistock. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | John Burnett uk.org.publicwhip/member/78 | John Burnett uk.org.publicwhip/person/10078 | 1 | 2001-05-14-1f359ece-10078-0 |
b50c4437de003d1821074667371a92e1baa4aad6 | Farmer. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | John Burnett uk.org.publicwhip/member/78 | John Burnett uk.org.publicwhip/person/10078 | 2 | 2001-05-14-1f359ece-10078-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");