items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where member_id = "uk.org.publicwhip/member/731" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
228b9acc7530ba00822255f7bc0245acf806d16b | Self-employed dental surgeon. | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2005-04-11-1f359ece-10041-0 |
2846b0fa1da00b25b07bdd72e304a9ba46ebfcaa | Private accommodation and surgery, Putney, London SW15. | Land and Property 4f1e6359 | 2005-04-11 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2005-04-11-4f1e6359-10041-0 |
f6af2d362c1ae0ed8318e22b6168f0148204d9df | Self-employed dental surgeon. | Remunerated employment, office, profession etc.. 12405e8c | 2005-01-28 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2005-01-28-12405e8c-10041-0 |
385739626b49a44ebfd98452e4968b00d8bbc824 | Private accommodation and surgery, Putney, London SW15. | Land and Property 4f1e6359 | 2005-01-28 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2005-01-28-4f1e6359-10041-0 |
a9094d444af5f47cea82a9c6d10fecab56bc761d | Self-employed dental surgeon. | Remunerated employment, office, profession etc 1f359ece | 2004-12-03 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-12-03-1f359ece-10041-0 |
f8533733d3d90b013901aa9e870c3d2ed2ee92e4 | Member of Advisory Panel to Professional Indemnity Division, MIA Insurance. | Remunerated employment, office, profession etc 1f359ece | 2004-12-03 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 1 | 2004-12-03-1f359ece-10041-0 |
75862b09a82f4cf3649dd5853ecf0311e85239cc | Private accommodation and surgery, Putney, London SW15. | Land and Property 4f1e6359 | 2004-12-03 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-12-03-4f1e6359-10041-0 |
c0f82931e65ea9d1fd27db131aa22b3db0f00adc | Self-employed dental surgeon. | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-10-22-1f359ece-10041-0 |
aa526d3656d2c9f52edcf82b5d4aefb714a235fc | Member of Advisory Panel to Professional Indemnity Division, MIA Insurance. | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 1 | 2004-10-22-1f359ece-10041-0 |
ee18625453f11f48576038b207848416b3a6cf5f | Private accommodation and surgery, Putney, London SW15. | Land and Property 4f1e6359 | 2004-10-22 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-10-22-4f1e6359-10041-0 |
ebc70822ab37401bdc86e23f18e2c99fdbd11ea8 | Self-employed dental surgeon. | Remunerated employment, office, profession etc 1f359ece | 2004-09-08 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-09-08-1f359ece-10041-0 |
11f84329599e5b8857bd3f37698d63283530ab29 | Member of Advisory Panel to Professional Indemnity Division, MIA Insurance. | Remunerated employment, office, profession etc 1f359ece | 2004-09-08 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 1 | 2004-09-08-1f359ece-10041-0 |
4c181f3207c8dd2b38d6eae9172785816065cda5 | Private accommodation and surgery, Putney, London SW15. | Land and Property 4f1e6359 | 2004-09-08 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-09-08-4f1e6359-10041-0 |
0c08313219b81d268a4067bf274e18f39692c006 | Self-employed dental surgeon. | Remunerated employment, office, profession etc 1f359ece | 2004-07-16 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-07-16-1f359ece-10041-0 |
37f704eb4b1d132a45d424cb80faa8f584977ae9 | Member of Advisory Panel to Professional Indemnity Division, MIA Insurance. | Remunerated employment, office, profession etc 1f359ece | 2004-07-16 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 1 | 2004-07-16-1f359ece-10041-0 |
2fa7a0472a6e6d966036e87a9e7bc5fed3e68331 | Private accommodation and surgery, Putney, London SW15. | Land and Property 4f1e6359 | 2004-07-16 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-07-16-4f1e6359-10041-0 |
def82f7b54ae925cbe29ed089e987010583bf77b | Self-employed dental surgeon. | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-05-21-1f359ece-10041-0 |
a51a90b9557bd30536aff119b31c0981adbd6053 | Member of Advisory Panel to Professional Indemnity Division, MIA Insurance. | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 1 | 2004-05-21-1f359ece-10041-0 |
07c9e4ccf72a81ca7f63fc053405e303e676b600 | Private accommodation and surgery, Putney, London SW15. | Land and Property 4f1e6359 | 2004-05-21 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-05-21-4f1e6359-10041-0 |
d53f2bc49715f2b087479ff5d04d6e5948a0fb91 | Self-employed dental surgeon. | Remunerated employment, office, profession etc 1f359ece | 2004-01-31 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-01-31-1f359ece-10041-0 |
c932a580704ec45b6816b0173bf6e904d2c88761 | Member of Advisory Panel to Professional Indemnity Division, MIA Insurance. | Remunerated employment, office, profession etc 1f359ece | 2004-01-31 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 1 | 2004-01-31-1f359ece-10041-0 |
7c485496ecfa75c6850ca5193953868ea4d020b7 | Private accommodation and surgery, Putney, London SW15. | Land and Property 4f1e6359 | 2004-01-31 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2004-01-31-4f1e6359-10041-0 |
053be611b646c2e57c4575f303ed49112ce750c4 | Self-employed dental surgeon. | Remunerated employment, office, profession etc 1f359ece | 2003-12-04 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2003-12-04-1f359ece-10041-0 |
0f6c8ca766fce5e792dd7079dace95bdfa001b35 | Member of Advisory Panel to Professional Indemnity Division, MIA Insurance. | Remunerated employment, office, profession etc 1f359ece | 2003-12-04 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 1 | 2003-12-04-1f359ece-10041-0 |
011e2658d040b3631e4b314817e567efbc95d462 | Private accommodation and surgery, Putney, London SW15. | Land and Property 4f1e6359 | 2003-12-04 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2003-12-04-4f1e6359-10041-0 |
007e45a273d913338b112267b11fdcf69017b2bd | Self-employed dental surgeon. | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2002-11-26-1f359ece-10041-0 |
01c7c60a2def286b8fc517bb993173b67c236fe9 | Private accommodation and surgery, Putney, London SW15. | Land and Property 4f1e6359 | 2002-11-26 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2002-11-26-4f1e6359-10041-0 |
8dd5544cea4d692bf51c94a0df64eb5c13704b20 | Dental surgeon. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2002-05-14-1f359ece-10041-0 |
2bd106b38b126fab0d6b81e6a9fd7c74c57bc807 | Car parking pass from South West Trains. (Registered 16 July 2001) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2002-05-14-84642823-10041-0 |
a5a3c90a1efc20a63765d32ea4c22201f3ae1f8b | Private accommodation and surgery, Putney, London SW15. | Land and Property 4f1e6359 | 2002-05-14 | Paul Beresford uk.org.publicwhip/member/731 | Paul Beresford uk.org.publicwhip/person/10041 | 0 | 2002-05-14-4f1e6359-10041-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");