items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where item = "I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington." and person_id = "uk.org.publicwhip/person/10078" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: category_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 |
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 |
d63c203923cb82616c730ab9b6f0e6bcbabacb48 | I retain an interest in Messrs. Stones (formerly Burd Pearse), Solicitors of Okehampton and Great Torrington. | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | John Burnett uk.org.publicwhip/member/765 | John Burnett uk.org.publicwhip/person/10078 | 0 | 2005-01-28-5177ae6a-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 |
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");