home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

43 rows where person_id = "uk.org.publicwhip/person/10078" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: item, category_id, date, member_id, sort_order, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
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
4b59abacced152949d3e8306aeccf264422c1032 Farm land buildings and residential property in Devon and London from which rental income is derived. Land and Property 4f1e6359 2005-04-11 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2005-04-11-4f1e6359-10078-0
1a650dae8287a8b1a23b897f7a7b5ca4c99d3e65 I have an interest in certain trusts. Registrable shareholdings 3aff2389 2005-04-11 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2005-04-11-3aff2389-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
2347dfd5652f8accc0ec3f92aff9aaa93bfd40fa Farm land buildings and residential property in Devon and London from which rental income is derived. Land and Property 4f1e6359 2005-01-28 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2005-01-28-4f1e6359-10078-0
0617d9d897f01e441ad15c89b67c3a16d388d090 I have an interest in certain trusts. Registrable shareholdings 3aff2389 2005-01-28 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2005-01-28-3aff2389-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
0ed47c064aec389ecb0fc8f2730a3f2c7ac9ebb2 Farm land buildings and residential property in Devon and London from which rental income is derived. Land and Property 4f1e6359 2004-12-03 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-12-03-4f1e6359-10078-0
b4f55df670181f2a528b34d51d5444b2654e9c82 I have an interest in certain trusts. Registrable shareholdings 3aff2389 2004-12-03 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-12-03-3aff2389-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
2382e7b6e3917f44643676b687a1d9f3d830a8bc Farm land buildings and residential property in Devon and London from which rental income is derived. Land and Property 4f1e6359 2004-10-22 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-10-22-4f1e6359-10078-0
bf13743e5a6b10105bba679bb1deaef617a3fa15 I have an interest in certain trusts. Registrable shareholdings 3aff2389 2004-10-22 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-10-22-3aff2389-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
0098b2ebcf8ff2085ca80e631ce6649ba27b22bd Farm land buildings and residential property in Devon and London from which rental income is derived. Land and Property 4f1e6359 2004-09-08 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-09-08-4f1e6359-10078-0
a1278e2ed178c780235097061e8e65aea1cfbd18 I have an interest in certain trusts. Registrable shareholdings 3aff2389 2004-09-08 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-09-08-3aff2389-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
f58a6d7637f8c3e51d81b045b8cea5cfa2930267 Farm land buildings and residential property in Devon and London from which rental income is derived. Land and Property 4f1e6359 2004-07-16 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-07-16-4f1e6359-10078-0
359a27ec79d85ff72cd25350445f8eeb6bcc03e1 I have an interest in certain trusts. Registrable shareholdings 3aff2389 2004-07-16 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-07-16-3aff2389-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
e53155033d056089f5bee8e19a95a5e4adb92ee8 Farm land buildings and residential property in Devon and London from which rental income is derived. Land and Property 4f1e6359 2004-05-21 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-05-21-4f1e6359-10078-0
dec965843469f88868b64c3710173c49cc02d69f I have an interest in certain trusts. Registrable shareholdings 3aff2389 2004-05-21 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-05-21-3aff2389-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
b658bf9fa107391df00bfd0cb59b4182ca4910e6 Farm land buildings and residential property in Devon and London from which rental income is derived. Land and Property 4f1e6359 2004-01-31 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-01-31-4f1e6359-10078-0
b9749c82156a3d19c5ce85d0ffe110f919186576 I have an interest in certain trusts. Registrable shareholdings 3aff2389 2004-01-31 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2004-01-31-3aff2389-10078-0
2bfc403b1f86047b2619f1ab17a06112f756308e Registrable shareholdings 3aff2389 2004-01-31 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 1 2004-01-31-3aff2389-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
6df4edcbccddac9833e4867cd5c313766f6a9673 Farm land buildings and residential property in Devon and London from which rental income is derived. Land and Property 4f1e6359 2003-12-04 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2003-12-04-4f1e6359-10078-0
5cc91487e8c99ef41d7ef12c4020e7d9fd540df5 I have an interest in certain trusts. Registrable shareholdings 3aff2389 2003-12-04 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2003-12-04-3aff2389-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
7450d5cf158c3f0c7c0335c95a97412229ea60a7 Farm land buildings and residential property in Devon and London from which rental income is derived. Land and Property 4f1e6359 2002-11-26 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2002-11-26-4f1e6359-10078-0
b81566e872ac45c0355570e4e5ea31dc6a2c606d I have an interest in certain trusts. Registrable shareholdings 3aff2389 2002-11-26 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2002-11-26-3aff2389-10078-0
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
06a1e74782602dbb77283b31d9ff28e956ea1801 3-7 November 2000, to Rome, Italy, with the All-Party British Italian Parliamentary Group to the Jubilee celebrations for Parliamentarians. I paid the travel expenses for my wife and me. Accommodation and some hospitality was paid for by the organising Committee of the All-Party Parliamentary Group on Parliamentarians for the Jubilee Year in the Italian Senate. (Registered 1 November 2001) Overseas visits 80ef1083 2002-05-14 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2002-05-14-80ef1083-10078-0
681341f4fc2041e991805680d3505aa2e12d398c Farm land buildings and residential property in Devon and London from which rental income is derived. Land and Property 4f1e6359 2002-05-14 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2002-05-14-4f1e6359-10078-0
e29f3ab661ac66dddb20fcdbb11f45a450d8ed56 Greycoat Management Ltd. Registrable shareholdings 3aff2389 2002-05-14 John Burnett uk.org.publicwhip/member/765 John Burnett uk.org.publicwhip/person/10078 0 2002-05-14-3aff2389-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
95a4f7624190b30b29e5f45ee51bb5d38cf8506f Farm and farm cottages in Devon. Land and Property 4f1e6359 2001-05-14 John Burnett uk.org.publicwhip/member/78 John Burnett uk.org.publicwhip/person/10078 0 2001-05-14-4f1e6359-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
7514b41cb85e3e5d8863eb5d50f94ac0dccf491a Farm and farm cottages in Devon. Land and Property 4f1e6359 2000-11-10 John Burnett uk.org.publicwhip/member/78 John Burnett uk.org.publicwhip/person/10078 0 2000-11-10-4f1e6359-10078-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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");
Powered by Datasette · Queries took 192.202ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette